Welcome! How to Use this Manual A Quick Introduction Getting Started Using Gnumeric Starting Gnumeric the First Time Working with Gnumeric Using Commands Data in Gnumeric Cell Formats Simple Cell Formating Formating the Display and Entry Data Types Complex Cell Selections Moving Cell Contents, Inserting New Cells or Deleting Cells Sheets Graphing A Simple Graphing Example Graphing is changing rapidly in Gnumeric 1.2 Printing File Opening and Saving Closing Gnumeric The Elements of Gnumeric Overview of the Elements of Gnumeric Introduction to Menus The Menubar General Menu Behavior The File Menu The Edit Menu The View Menu The Insert Menu The Format Menu The Tools Menu The Data Menu The Help Menu Context Menus in Gnumeric The Context Menu for the Cell Grid Area The Context Menu for Column and Row Headers The Context Menu menu for Worksheet Tabs The Context Menu for Embedded Objects and Components The Context Menu for Toolbars The Gnumeric Toolbars General Toolbar Behavior The Standard Toolbar The Format Toolbar The Object Toolbar The Elements of the Gnumeric Worksheet Data Entry Area The Cell Grid The Column and Row Headers The Information Area The Mouse Pointers used by Gnumeric Working with Data Data in Gnumeric Cells The Types of Cell Elements Text Data Elements Number Data Elements Boolean Data Elements Formula Elements Cell Referencing Names Error Elements Data Entry. Data Entry by Editing Cells. Advanced Editing Mode Entering Text Data Entering Number Data Entering Boolean Data Entering Formulas Shortcuts for including cell references and ranges in formulas Entering formulas using the function list Entering formulas using the formula guru Entering Errors Advanced Data Entry. Entering Large Quantities of Data Entering a Regular Sequence Automatically Correcting Simple Mistakes Correct TWo INitial CApitals Capitalize the First Letter of Sentences Capitalize the Names of Days Using a Format Template Generating Random Number Sequences Obtaining Data from External Sources Obtaining Data from External Files Obtaining Data by Cut and Paste Getting Data from a Database Getting Data from an Internet Data Stream Selecting Cells and Cell Ranges Simple Selections Selecting Multiple Cells Continuous selections Discontinuous selections Selections Using the Keyboard Moving and Copying Data Simple Copy and Move Cut, Copy and Paste Cutting a Selection to the Clipboard Copying a Selection to the Clipboard Pasting the Clipboard Paste Special Cut and Paste Between Gnumeric and Other Applications Deleting Data Inserting New Data Cells Formating Cells Number Formatting Tab Alignment, Font, Border, and Background Tabs Alignment Tab Font Tab Border Tab Background Tab Protection and Validation Tabs Protection Tab Validation Tab Modifying Data Searching for Data Searching and Replacing Data Sorting Data Shuffling Data Filtering Data Advanced Filter Advanced Filter Advanced Filter Generating Data Creating a Tabulation of Dependencies Creating Multiple Repeats of Standard Data Consolidating a Result from Several Source Regions Adding a Comment to a Cell Adding a Hyperlink to a Cell Advanced Analysis Advanced Analysis in Gnumeric Analysis using Complex Numbers Goal Seek Tool Solver Simulation Analysis Analysis using scenarios Adding new scenarios Viewing and managing scenarios Statistical Analysis Analysis of Variance ANOVA: Single Factor Tool ANOVA: Two-Factor Tool ANOVA: Two-Factor Without Replication Tool ANOVA: Two-Factor With Replication Tool Correlation Tool Covariance Tool Descriptive Statistics Tool Exponential Smoothing Tool Fourier Analysis Tool F-Test: Two-Sample for Variances Tool Histogram Tool Introduction The Input Tab The Bins Tab The Options Tab The Output Tab A Histogram Example Moving Average Tool Rank and Percentile Tool Regression Tool Sampling Tool Comparing Means of 2 Populations t-Test: Paired Two Sample for Means Tool t-Test: Two-Sample Assuming Equal Variances Tool t-Test: Two-Sample Assuming Unequal Variances Tool z-Test: Two Samples for Means Tool Graphics: Plots, Images and Drawings Adding Graphical Elements to a Worksheet Adding Data Plots to a Worksheet Creating a Basic Graph Advanced Graphing Selecting Data Ranges Plot Series Name Data Range Values Data Range Category Labels Data Range Customizing Graph Layout Adding Images to a Worksheet Adding Drawing and Graphical Interface Elements to a Worksheet Drawing Lines. Drawing Arrows. Drawing Ovals. Drawing Rectangles. Adding Labels. Adding Frames. Adding Checkboxes. Adding Scrollbars. Adding Spinbuttons. Adding Sliders. Drawing Lines. Adding Combination Boxes. Managing and Viewing Worksheets An Overview of Worksheets and Views Manipulating Whole Columns and Rows Manipulating Columns Manipulating Rows Managing Worksheets The Sheet Management Dialog Duplicating a Worksheet Adding a Blank Worksheet Renaming a Worksheet Removing Worksheets Viewing Worksheet Contents Zoom: Changing the Scale of a View Moving the View Having Multiple Views of a Worksheet The location of new views View sharing Freezing a Portion of a Worksheet View Grouping and Outlining Cells in a Worksheet Workbook Settings Overview of the File Contents and Settings Document Summary Document Settings Document Printing Settings Document Autosave Settings Document Autocorrection Settings Document View Settings Document Protection Settings Document Validation Settings Document Recalculation Lag Settings Document Named Elements Configuring Gnumeric Configuring Gnumeric Configuring Gnumeric Toolbars Configuring Gnumeric Preferences Configuring Gnumeric Plugins Configuring the Language and Local Settings of Gnumeric File Opening and Saving Working with Files Opening and Importing Files Opening Files Importing Files File Formats Gnumeric XML File Format Data Interchange Format DVI TeX Format MS Excel (tm) File Formats Experimental Bonobo EFS Format Gnome Glossary PO File Format HTML File Formats HTML generated by Gnumeric HTML 3.2 File Format HTML 4.0 File Format HTML Fragment Format LaTeX 2e Format Including Tables Into Other Documents Customizing The LaTeX Tables Linear and Integer Program File Format Plan Perfect Format PDF Format SC/XSpread Format Text Format The Text Export Druid The Text Import Druid TROFF Format Saving Files AutoSave Tool Printing Printing to a Printer or a File. Page Setup. Page Setup Dialog - Page Page Setup Dialog - Headers and Footers Customizing Headers and Footers Page Setup Dialog - Sheet Print Preview. Menu Bar Getting Help from Other Sources Getting Help using Gnumeric The Gnumeric Web Site and Other Web Resources The Gnumeric Web Site The Gnumeric Mailing List Joining the Gnumeric Discussion Channel Reporting Bugs in the Program Extending Gnumeric The Approaches to Extending Gnumeric Defining New Functions Programming Gnumeric using Python Installing and Building Gnumeric for Python Preliminaries In the Beginning (Installing and Building) Getting the binaries (Debian) Getting and building the current Debianized source Getting and building the source from CVS-HEAD The Python Console Enabling the Python Console Playing with the Python console More fun with the Python console Using the built-in Python functions Writing your own Python functions Prepare the spellbook Writing new spells Do it yourself (mostly) More help Program Listings Upgrading Fancy tricks Features wanted, and Questions Writing New Plugins Adding to the Gnumeric Program About Gnumeric The History of Gnumeric Authors License How to Build Gnumeric from Source Code How to Get Involved in Gnumeric Function Reference Alphabetical List of Gnumeric Functions Bitwise Operations Complex Database Date/Time Engineering Finance Gnumeric Information Logic Lookup Mathematics Number Theory Random Numbers Statistics String Keybinding Reference Gnumeric Keybindings