The Gnumeric Manual, version 1.12

1. Welcome!
2. How to Use This Manual
3. A Quick Introduction
- 3.1. Working with Gnumeric
- 3.2. Starting Gnumeric the First Time
- 3.3. The Parts of Gnumeric
- 3.4. Using Commands
- 3.5. Data in Gnumeric
- 3.6. Cell Formats
- 3.7. Complex Cell Selections
- 3.8. Moving Cell Contents, Inserting New Cells or Deleting Cells
- 3.9. Sheets
- 3.10. Graphing
- 3.11. Printing
- 3.12. File Opening and Saving
- 3.13. Closing Gnumeric
4. Gnumeric Elements
- 4.1. Overview
- 4.2. Menus
- 4.3. Context Menus
- 4.4. Toolbars
- 4.5. Data Entry Area
- 4.6. The Cell Grid
- 4.7. The Information Area
- 4.8. The Mouse Pointers used by Gnumeric
5. Working with Data
- 5.1. Data in Gnumeric Cells
- 5.2. The Types of Cell Elements
- 5.3. Data Entry
- 5.4. Advanced Data Entry
- 5.5. Obtaining Data from External Sources
- 5.6. Selecting Cells and Cell Ranges
- 5.7. Moving and Copying Data
- 5.8. Deleting Data
- 5.9. Inserting New Data Cells
- 5.10. Formatting Cells
- 5.11. Conditional Formatting of Cells
- 5.12. Filtering Data
- 5.13. Modifying Data
- 5.14. Generating Data
- 5.15. Adding a Comment to a Cell
- 5.16. Adding a Hyperlink to a Cell
6. Advanced Analysis
- 6.1. Advanced Analysis in Gnumeric
- 6.2. Analysis using Complex Numbers
- 6.3. Goal Seek Tool
- 6.4. Simulation Analysis
- 6.5. Analysis using scenarios
7. The Solver
- 7.1. Solver
8. Statistical Analysis
- 8.1. Overview
- 8.2. Descriptive Statistics
- 8.3. Sampling Tool
- 8.4. Dependent Observations
- 8.5. One Sample Tests
- 8.6. Two Sample Tests
- 8.7. Multiple Sample Tests
9. Graphics: Images, Widgets, and Drawings
- 9.1. Overview
- 9.2. Images
- 9.3. GUI Widgets
- 9.4. Drawing Elements
10. Graphs
- 10.1. Overview of Graphs
- 10.2. The Graph Guru
- 10.3. Plot Types
- 10.4. Configuring Graph Element Properties
- 10.5. Pre-Selecting Data
11. Using Worksheets
- 11.1. Overview
- 11.2. Worksheet Navigation
- 11.3. Worksheet Display
- 11.4. General Settings
- 11.5. Print Settings
- 11.6. Managing Worksheets
12. Workbook Settings
- 12.1. Overview
- 12.2. Document Summary
- 12.3. Document Settings
- 12.4. Document Named Elements
13. Configuring Gnumeric
- 13.1. Overview
- 13.2. General Preferences
- 13.3. Toolbars
- 13.4. Plugins
- 13.5. Languages and Locales
14. Working with Files
- 14.1. Files in Gnumeric
- 14.2. File Formats
- 14.3. Opening Files
- 14.4. Importing Text Files
- 14.5. Saving Files
- 14.6. Exporting Text Files
- 14.7. Sending Files
- 14.8. Converting Files
15. Printing
- 15.1. Printing to a Printer or a File.
- 15.2. Page Setup.
- 15.3. Print Preview
16. Getting More Help
- 16.1. Sources of Help
- 16.2. Web Resources
- 16.3. Related Manuals
- 16.4. The Mailing List
- 16.5. Internet Chat (IRC)
17. Reporting a Problem
- 17.1. Overview
- 17.2. Defining the error
- 17.3. Opening an account
- 17.4. Filing a report
18. Extending Gnumeric
- 18.1. The Approaches to Extending Gnumeric
- 18.2. Defining New Functions
- 18.3. Programming Gnumeric using Python
- 18.4. Writing New Plugins
A. Function Reference
- A.1. Bitwise Operations
- A.2. Complex
- A.3. Database
- A.4. Date/Time
- A.5. Engineering
- A.6. Erlang
- A.7. Finance
- A.8. Gnumeric
- A.9. Information
- A.10. Logic
- A.11. Lookup
- A.12. Mathematics
- A.13. Number Theory
- A.14. Random Numbers
- A.15. Statistics
- A.16. String
- A.17. Time Series Analysis
B. Keybinding Reference