# The Gnumeric Manual, version &appversion;

2007
2006
2005
2004
Adrian Custer, Ray Dassen, Jody Goldberg, Andreas Guelzow.
2003
Kevin Breit, Adrian Custer, Ray Dassen, Jody Goldberg, Andreas J. Guelzow, Jon K. Hellan, Jukka-Pekka Iivonen, Alexander Kirillov, Charles Twardy, Sebastian Klost, Thomas Miesbauer.
2002
Jody Goldberg, Andreas J. Guelzow, Wayne Schuller, Adrian Custer, Kevin Breit, Aaron Weber, Alexander Kirillov, Eric Baudais, Gregory Leblanc.
1998
1999
2000
2001
Miguel de Icaza, Thomas Canty, Jukka-Pekka Iivonen, Almer S. Tigelaar, Morten Welinder.
GNOME Documentation Project
&legal;

Eric
Baudais
baudais@okstate.edu
Kevin
Breit
mrproper@ximian.com
Thomas
Canty
tommydal@ihug.com.au
Adrian
Custer
acuster@gnome.org
Ray
Dassen
jdassen@debian.org
Jody
Goldberg
jody@gnome.org
Andreas
Guelzow
aguelzow@taliesin.ca
Jon K.
Hellan
hellan@acm.org
Miguel
de Icaza
miguel@gnu.org
Jukka-Pekka
Iivonen
jiivonen@hutcs.cs.hut.fi
Alexander
Kirillov
kirillov@math.sunysb.edu
Sebastian
Klost
sebastian.klost@gmx.de
Gregory
Leblanc
gleblanc@linuxweasel.com
Thomas
Miesbauer
thomas.miesbauer@web.de
Wayne
Schuller
k_wayne@linuxpower.org
Almer S.
Tigelaar
almer1@dds.nl
Charles
Twardy
ctwardy@mail.csse.monash.edu.au
Aaron
Weber
aaron@ximian.com
Morten
Welinder
terra@diku.dk
Gnumeric Manual: Version &manrevision;
&date;

The Gnumeric Team

GNOME Documentation Project

Gnumeric Manual: Version 1.4
November 2004

The Gnumeric Team

GNOME Documentation Project

Gnumeric Manual: Version 1.2
September 2002

The Gnumeric Team

GNOME Documentation Project

Gnumeric Manual: Version 1.0
January 2002

The Gnumeric Team

GNOME Documentation Project

Gnumeric Manual: Earlier Versions
1998-2001

The Gnumeric Team

GNOME Documentation Project

This manual describes version &appversion; of Gnumeric

## Feedback

To report a bug or make a suggestion regarding the &gnum; application or this manual, follow the directions in .

## Welcome!

&welcome;

## How to Use this Manual

&manual-usage;

## A Quick Introduction

The best way to learn how to use &gnum; is to begin exploring the program yourself. This chapter will help you get started trying new things and seeing what happens. The chapter explains the fundamentals of spreadsheets in general and of &gnum; in particular. The chapter attempts to help new users get started with &gnum; and provides background for the more detailed explanations given in the rest of the manual.

Getting started with computers

Unfortunately, this manual cannot teach you the very basics of interacting with a modern computer. If you have never used computers, don't know the names of the hardware components (the pieces you can touch) or don't know the names of the elements you see on the screen (like windows or the mouse pointer), you will probably want to get some basic advice from someone you know or read the manuals which came with your machine or your operating system. It's all pretty easy but, in order to understand this manual, you will need to know some basic terminology and have some basic computing skills.

If you are using the GNOME desktop environment, you can read the the GNOME Desktop User Guide for help in getting started with computers.

If you are using the another desktop environment such as KDE or another operating system, please see the instructions from the web site linked with either your desktop environment, your operating system, your software distribution source or the people who provided you with your computer. There are also many books providing good introduction to computers.

&quick-start;

## Gnumeric Elements

This chapter describes all of the pieces of &gnum; which a user can manipulate. The chapter provides explanations for each of the menus, menu entries, toolbar buttons and other elements of the graphical user interface.

&gui-overview; &gui-menus; &gui-toolbars; &gui-other-elements; &gui-mouse;

## Working with Data

This chapter explains the core functionality of &gnum; including the basic types of data manipulated by &gnum;, the methods of entering, manipulating and formatting data, and the basic tools for analysis of these data. More advanced analysis is described in .

&data-overview; &data-types; &data-entry; &data-entry-adv; &data-entry-extern; &data-selections; &data-move-copy; &data-delete; &data-insert; &data-format; &data-filter; &data-modify; &data-generate; &data-commentNlink;

## Advanced Analysis

This chapter explains many of the advanced analytic tools available in &gnum; including statistical analysis, linear algebra calculations and simulation analysis.

&analysis-overview; &analysis-complexNum; &analysis-goalseek; &analysis-solver; &analysis-simulation; &analysis-scenarios; &analysis-statistical;

## Graphics: Plots, Images, Widgets, and Drawings

This chapter explains how to add graphical elements to a &gnum; worksheet, including data graphs to plot worksheet data, images from external files, graphical user interface widgets which interact with worksheet data, and simple drawing elements.

&graphics-overview; &graphics-plots; &graphics-images; &graphics-widgets; &graphics-drawings;

## Configuring Gnumeric

This chapter explains how to change the default behaviour of &gnum; including the startup behaviour and default locale (language and number display).

&config-overview; &config-preferences; &config-toolbars; &config-plugins; &config-localization;

## Working with Files

This chapter explains how to use files in &gnum;. The chapter provides an extensive description of the file formats used by &gnum;. The chapter also explains how to open files, import data from text files, save files, export data to text files, send data to others via electronic mail, and convert files from one format to another.

&files-overview; &files-formats; &files-opening; &files-textopen; &files-saving; &files-textsave; &files-email; &files-ssconvert;

## Printing

This chapter explains how to print spreadsheets, tables and plots from &gnum; to a printer directly or into Postscript or PDF (both are page description languages).

&printing;

## Getting More Help

This chapter describes other sources of help which are available to users including the &gnum; web site, the mailing list, and the internet relay chat (IRC) discussion channel.

&morehelp;

## Reporting a Problem

This chapter explains how to report a problem with &gnum; so that the problem can be fixed. The same procedure can be used to file a report requesting an enhancement or a new feature.

&bugs;

## Extending Gnumeric

This chapter explains how to go about extending &gnum; to provide extra functionality. Because &gnum; is Free Software this is quite easy to do.

&extending-overview; &extending-functions; &extending-python; &extending-plugins;

&function-ref; &appendix-keybindings;