# The Gnumeric Manual

Copyright © 1998, 1999, 2000, 2001, 2002 Miguel de Icaza, Jody Goldberg, Thomas Canty, Jukka-Pekka Iivonen, Andreas J. Guelzow, Wayne Schuller, Adrian Custer, Kevin Breit, Aaron Weber, Alexander Kirillov.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license can be found in Appendix A.

Many of the names used by companies to distinguish their products and services are claimed as trademarks. Where those names appear in any GNOME documentation, and those trademarks are made aware to the members of the GNOME Documentation Project, the names have been printed in initial caps and a (tm) appended.

List of Tables
9-1. Examples of Date Formats
9-2. Examples of Time Formats
18-1. Gnumeric was written by

List of Figures
1-1. An example of what Gnumeric can do.
2-1. The Gnumeric worksheet elements.
3-1. The Gnumeric menubar.
3-2. A re-arranged Gnumeric.
3-3. Gnumeric menus can be torn off.
3-4. The File menu.
3-5. The Edit menu.
3-6. The View menu.
3-7. The Insert menu.
3-8. The Format menu.
3-9. The Tools menu.
3-10. The Data menu.
3-11. The Help menu.
3-12. The Context Menu for the Cell Grid Area.
3-13. The Context Menu of a Row Header
3-14. The Context Menu.
3-15. The Context Menu
3-16. The Context Menu.
4-1. The Three Gnumeric Toolbars
4-2. The Standard Toolbar.
4-3. The Format Toolbar
4-4. The Object Toolbar
5-1. The Data Entry area.
5-2. The Current Cell Indicator.
5-3. The Cell Grid area, with cells of different sizes.
5-4. The column labels at the top of the worksheet.
5-5. The row labels at the left side of the worksheet.
5-6. The Information Display Area.
5-7. The running calculation area.
6-1. Entering Strings and Numbers
6-2. The highlighted selection
6-3. An Active cell
6-4. The active cell with the cursor
6-5. A multi-cell selection
6-6. Multiple cells being selected with the cursor
6-7. A discontinuous selection of cells.
6-8. An entire row being selected
6-9. An entire column being selected
6-10. The entire worksheet being selected
6-11. A selection of several cells
6-12. A selection of several cells, filled with the same values
7-1. The option menu for dragging a cell with right click
9-1. Format Cells Dialog
9-2. Alignment Tab
9-3. The Font Tab
9-4. Border Tab
9-5. Background Tab
9-6. Protection Tab
9-7. Validation Tab
9-8. Warning dialog in response to invalid input
10-1. File Format Selector
10-2. File Format Selector
10-3. Gnumeric Sample Screenshot
10-4. xdvi Screenshot of DVI TeX File
10-5. Mozilla Screenshot of HTML 3.2 File
10-6. Mozilla Screenshot of HTML 4.0 File
10-7. Mozilla Screenshot of HTML Fragment
10-8. xpdf Screenshot of LaTeX file
10-9. Specifying which sheets to export
10-10. Specifying line terminators
10-11. csv File
10-12. Selecting the basic format type
10-13. Separation Customization
10-14. Separation Customization With Correct Selection
10-15. Selecting Formats
10-16. Some Number Formats
10-17. Some Currency Formats
10-18. Some Date and Time Formats
10-19. Some Percentage Formats
10-20. Some Fraction Formats
10-21. Some Scientific Formats
10-22. The Text Format
10-23.
10-24. The Auto Save Tool dialog.
11-1. Print Dialog
11-2. Print Setup Dialog - Page
11-3. Print Setup Dialog - Margins
11-4. Print Dialog - Headers and Footers
11-5. Print Dialog - Customize Header/Footer
11-6. Print Setup Dialog - Sheet
11-7. Print Preview Dialog
12-1. Worksheet containing the table to be filtered and a simple criteria.
12-2. Criteria for selecting rows whose `Profit' column is between 0 and 40000.
12-3. The Advanced Filter dialog.
13-1. Linear programming example
13-2. The empty Solver dialog.
13-3. Add constraint dialog.
13-4. The solver dialog
13-5. The Solver results dialog
14-1. Data Analysis Tools
14-2. Common output options of the data analysis tools
14-3. Specifying Ranges
14-4. 1-factor ANOVA Dialog and Example Data
14-5. Output From a 1-factor ANOVA
14-6. 2-factor ANOVA Without Replication Dialog
14-7. Output From a 2-factor ANOVA Without Replication
14-8. 2-factor ANOVA With Replication Dialog
14-9. Output From a 2-factor ANOVA With Replication
14-10. Correlation Tool Dialog
14-11. Some Example Data
14-12. Completed Correlation Dialog
14-13. Correlation Tool Output
14-14. Covariance Tool Dialog
14-15. Some Example Data
14-16. Covariance Tool Output
14-17. Descriptive Statistics Tool Dialog
14-18. Some Example Data
14-19. Descriptive Statistics Tool Output
14-20. Exponential Smoothing Tool Dialog
14-21. Some Example Data for the Exponential Smoothing Tool
14-22. Exponential Smoothing Tool Output
14-23. Moving Average Tool Dialog
14-24. Some Example Data for the Moving Average Tool
14-25. Moving Averages Tool Output
14-26. Fourier Analysis Tool Dialog
14-27. Fourier Analysis Formulae
14-28. F-Test Tool Dialog
14-29. Some Example Data
14-30. F-Test Tool Output
14-31. Histogram Tool Dialog
14-32. Histogram Tool Dialog "Bins Tab"
14-33. Some Example Data
14-34. Specifying Bins
14-35. Histogram Tool Output
14-36. Random Number Generation Tool Dialog
14-37. Some Example Data for the Random Number Generation Tool
14-38. Random Number Generation Tool Output
14-39. Rank and Percentile Tool Dialog
14-40. Some Example Data for the Rank and Percentile Tool
14-41. Rank and Percentile Tool Output
14-42. Regression Tool Dialog
14-43. Regression Example Data
14-44. Completed Regression Dialog
14-45. Regression Tool Output
14-46. Sampling Tool Dialog
14-47. Some Example Data for the Sampling Tool
14-48. Sampling Tool Output
14-49. t- and z-Test Tool Dialog
14-50. t-Test (Paired) Tool Dialog Options
14-51. t-Test (Paired) Example Data
14-52. Output from the t-Test (Paired) Tool
14-53. t-Test (Equal Variances) Tool Dialog Options
14-54. t-Test (Unknown but Equal Variances) Example Data
14-55. Output from the t-Test (Unknown but Equal Variances) Tool
14-56. t-Test (Unknown and Unequal Variances) Tool Dialog Options
14-57. t-Test (Unknown and Unequal Variances) Example Data
14-58. Output from the t-Test (Unknown and Unequal Variances) Tool
14-59. z-Test Tool Dialog Options
14-60. z-Test Example Data
14-61. Output from the z-Test Tool
15-1. The Auto Correct dialog.

List of Examples
6-1. Examples of standard operators
6-2. Basic Function syntax
6-3. Some examples of function syntax
6-4. Examples of name usage
6-5. Entering an Array Formula
6-6. Some examples of function syntax
6-7. Relative References
6-8. Absolute cell referencing examples
6-9. Some examples of function syntax
6-10. Referencing blocks of cells
6-11. Referencing blocks of cells
6-12. Referencing values in other sheets
8-1. Adjacent Columns for Autofill Length Example
10-1. Saving as DVI TeX
10-2. Saving as HTML 3.2
10-3. Saving as HTML 4.0
10-4. Saving as HTML fragment
10-5. Saving as LaTeX file
10-6. Creating an ASCII File
14-1. Using the single factor ANOVA
14-2. Using the 2-factor ANOVA Without Replication Tool
14-3. Using the Correlation Tool
14-4. Using The Covariance Tool
14-5. Using the Descriptive Statistics Tool
14-6. Using the Exponential Smoothing Tool
14-7. Using the Moving Average Tool
14-8. Using the F-Test Tool
14-9. Using the Histogram Tool
14-10. Using the Random Number Generation Tool
14-11. Using the Rank and Percentile Tool
14-12. Using the Regression Tool
14-13. Using the Sampling Tool
14-14. Using the t-Test (Paired) Tool
14-15. Using the t-Test (Unknown but Equal Variances) Tool
14-16. Using the t-Test (Unknown and Unequal Variances) Tool
14-17. Using the z-Test Tool
17-1. Series Example
17-2. Name Example
17-3. Values Example
17-4. Category Labels Example

|  | Next
|  | Preface