# The Gnumeric Manual, version &appversion;

2004
Adrian Custer, Ray Dassen, Jody Goldberg.
2003
Kevin Breit, Adrian Custer, Ray Dassen, Jody Goldberg, Andreas J. Guelzow, Jon K. Hellan, Jukka-Pekka Iivonen, Alexander Kirillov, Charles Twardy.
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
Gregory
Leblanc
gleblanc@linuxweasel.com
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.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 &app;.

## Feedback

To report a bug or make a suggestion regarding the &app; application or this manual, follow the directions in the GNOME Feedback Page.

## Welcome!

&welcome;

## How to Use this Manual

&manual-usage;

## A Quick Introduction

The best way to learn how to use Gnumeric 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 Gnumeric in particular. The chapter attempts to help new users get started with Gnumeric 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 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;

## The Elements of Gnumeric

This chapter describes all of the pieces of Gnumeric 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.

This chapter has not yet been updated for the 1.2 release of Gnumeric but still describes the earlier releases. The descriptions will still be generally useful to those attempting to understand the menu entries of Gnumeric 1.2. This chapter will be updated as time permits.

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

## Working with Data

This chapter explains the core functionality of Gnumeric including the basic types of data manipulated by Gnumeric, the methods of entering, manipulating and formating 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-modify; &data-generate; &data-commentNlink;

## Advanced Analysis

This chapter explains many of the advanced analytic tools available in Gnumeric 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 and Drawings

This chapter explains how to use Gnumeric to add graphical elements to a worksheet. Data plots allow users to create charts of data in a worksheet including pie charts, bar and column charts and scatterplots. Images in standard computer formats can be added on top of a worksheet. Drawings allow users to add simple graphical elements on top of a worksheet including lines, arrows and simple polygons.

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

## Managing and Viewing Worksheets

This chapter explains how to manage worksheets and manipulate the view of the worksheet contents.

&f-worksheets;

## Workbook Settings

This chapter explains the contents of a Gnumeric workbook which are not part of the worksheets. This includes several settings which apply to the workbook and are saved in the Gnumeric file. Settings which apply to the Gnumeric program itself are called `preferences' and are explained in .

&f-workbooks;

## Configuring Gnumeric

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

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

## File Opening and Saving

This chapter explains how to use files in Gnumeric including how to save the current file, how to change the file format of saved files and how to open files from a different format.

&files-overview; &files-opening; &files-saving; &files-autosave;

## Printing

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

&printing;

## Getting Help from Other Sources

This chapter describes other sources of help which are available to users including the Gnumeric web site, the mailing list, and the internet relay chat (IRC) discussion channel. The chapter also explains how to tell the project about a problem with the program.

&morehelp;

## Extending Gnumeric

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

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

## About Gnumeric

This chapter provides some background information on the creation and distribution of Gnumeric.

&about-history; &about-authors; &about-license; &about-compiling; &about-get-involved;

## Function Reference

This appendix provides a list of all the functions which are currently defined in Gnumeric.

&function-ref;

## Keybinding Reference

This appendix lists the keyboard shortcuts which are defined by default in Gnumeric.

&appendix-keybindings;