Gnumeric's user manual

Miguel de Icaza Amozurrutia

    miguel@gnu.org
  

Adrian Likins

    adrian@gimp.org
  


Table of Contents
1. Entering data.
Strings and numbers
Dates and Numbers
Editing of cells.
Editing commands
Formulas
Syntax
Using Functions
Names
Array Formulas
Cell Referencing
Absolute cell referencing
Referencing multiple cells
Referencing cells on other sheets
Selecting Cells While Entering Formulas.
Entering data into a formula with the mouse
Entering data into a formula with the keyboard.
Copying and moving cells
Using the mouse to drag the selection
Right Click Options
Move and copy right click menu options
Editing cells using the selection
Simple Selections
Selecting multiple cells
Discontinuous selections
Keyboard Shortcuts
Filling a region with the same text or value.
Autofill
Filling with Dates
String And Number autofill
Formula autofill
Other Notes on autofill
2. Style.
3. Cell Formatting
Cell Formatting
The Format Dialog
Changing the Font or Font Color
Changing the cell's Background Colors and Patterns
Cell content justification and alignment
Cell Formatting options on the buttonbar.
Number formatting overview
Date and Time formatting
4. Worksheet overview.
The Worksheet
The Menu bar
The Button Bar
Data entry area.
The Cell area
The Info Area
5. Working with files.
Working with files
Saving files
File format
6. Printing
7. Analysis tools
Data Analysis Tools
Anova: Single Factor Tool
Correlation Tool
Covariance Tool
Descriptive Statistics Tool
F-Test:Two-Sample for Variances Tool
Random Number Generation Tool
Sampling Tool
z-Test:Two Samples for Means Tool
8. Tutorials
9. Drawing on a worksheet
10. Gnumeric Function Reference
Reference
LCM —
PRICEDISC —
IMARGUMENT —
RANDBETWEEN —
COSH —
YIELDDISC —
REPT —
DEGREES —
NOMINAL —
ISODD —
RSQ —
ODDLYIELD —
COLUMN —
RATE —
DPRODUCT —
FDIST —
ISEVEN —
ZTEST —
DMIN —
TEXT —
RandBinom —
RandBernoulli —
WEEKDAY —
PRODUCT —
RandPoisson —
MULTINOMIAL —
IMSIN —
COS —
EXP —
ASIN —
PERCENTILE —
TRIMMEAN —
FLOOR —
GCD —
ODDLPRICE —
CHOOSE —
POISSON —
SYD —
MID —
ASINH —
EXPONDIST —
COUPDAYBS —
UPPER —
HARMEAN —
TBILLYIELD —
ODDFYIELD —
CONVERT —
LOG —
HYPGEOMDIST —
IMABS —
SINH —
AVEDEV —
NORMDIST —
GEOMEAN —
TIME —
MIN —
MEDIAN —
FREQUENCY —
GAMMAINV —
IMSUB —
ISTEXT —
SQRT —
COUPDAYSNC —
INTERCEPT —
LEN —
RIGHT —
PERMUT —
ODDFPRICE —
AVERAGEA —
PERCENTRANK —
RandNegBinom —
COUPDAYS —
DATE —
STEYX —
OCT2BIN —
PRICEMAT —
IMCONJUGATE —
SUMIF —
LINEST —
IMREAL —
IMSUM —
SERIESSUM —
XIRR —
LEFT —
DURATION —
COMPLEX —
DEC2HEX —
COLUMNS —
LN —
DGET —
DATEVALUE —
COUNTBLANK —
AVERAGE —
CORREL —
CUMIPMT —
SUMSQ —
IMPRODUCT —
CHAR —
PMT —
DAY —
GROWTH —
INDEX —
SQRTPI —
FISHER —
VARA —
DMAX —
ISLOGICAL —
ATAN2 —
MINA —
LOOKUP —
CEIL —
MDETERM —
COUPNCD —
MDURATION —
HEX2DEC —
MINUTE —
VARPA —
NOT —
TINV —
TAN —
G_PRODUCT —
SUMXMY2 —
NOW —
NA —
BETAINV —
ROWS —
DSTDEVP —
CHITEST —
CRITBINOM —
SUMPRODUCT —
INT —
BINOMDIST —
DB —
IMLOG2 —
VARP —
AMORLINC —
EXACT —
EDATE —
DVAR —
YEAR —
LOWER —
TIMEVALUE —
DEC2OCT —
RAND —
KURT —
BIN2DEC —
ERF —
MAX —
NEGBINOMDIST —
DOLLARDE —
EOMONTH —
MROUND —
DEVSQ —
SELECTION —
ROUND —
FIND —
VALUE —
WEIBULL —
BIN2HEX —
DDB —
NPV —
VLOOKUP —
DAVERAGE —
MINVERSE —
LOGNORMDIST —
RANK —
INTRATE —
BESSELI —
BESSELJ —
COUPPCD —
TBILLEQ —
BESSELK —
ADDRESS —
INDIRECT —
SIGN —
REPLACE —
GAMMADIST —
SKEW —
CHIINV —
CODE —
LOGINV —
ERROR —
ROUNDDOWN —
ISNA —
SUMX2MY2 —
VAR —
HEX2OCT —
STDEVPA —
DAYS360 —
DVARP —
FINV —
ISPMT —
IMCOS —
IMDIV —
ISBLANK —
SECOND —
IMEXP —
ACOS —
STANDARDIZE —
BESSELY —
SIN —
EFFECT —
OFFSET —
OR —
TYPE —
QUARTILE —
GETPIVOTDATA —
QUOTIENT —
FORECAST —
BIN2OCT —
CHIDIST —
CONFIDENCE —
PI —
COUNT —
EURO —
IMPOWER —
NORMSINV —
CELL —
DSUM —
EXPRESSION —
TBILLPRICE —
RandExp —
LOG2 —
ABS —
PEARSON —
IMAGINARY —
ROW —
ATANH —
ERFC —
N —
WORKDAY —
ROMAN —
POWER —
NORMSDIST —
STDEVA —
TTEST —
DISC —
NPER —
NETWORKDAYS —
STDEV —
MOD —
FACTDOUBLE —
GAMMALN —
SMALL —
OCT2DEC —
T —
LOGEST —
NORMINV —
PV —
DOLLAR —
TANH —
MATCH —
SUBSTITUTE —
TODAY —
FV —
PPMT —
VDB —
PROPER —
DELTA —
CEILING —
KURTP —
IMLOG10 —
AND —
ODD —
MAXA —
ISNONTEXT —
SUM —
FVSCHEDULE —
MONTH —
BETADIST —
ISERR —
FIXED —
STDEVP —
ACCRINTM —
DEC2BIN —
COUPNUM —
YIELD —
HLOOKUP —
MMULT —
LOG10 —
IRR —
HYPERLINK —
DCOUNT —
COUNTA —
PRICE —
SUBTOTAL —
CLEAN —
MODE —
DCOUNTA —
SUMX2PY2 —
FTEST —
SKEWP —
ISNUMBER —
RADIANS —
TREND —
IPMT —
MIRR —
ISREF —
ROUNDUP —
DSTDEV —
SUMA —
ACCRINT —
IMTAN —
FISHERINV —
ATAN —
SLN —
LARGE —
YIELDMAT —
HEX2BIN —
GESTEP —
TDIST —
HOUR —
FACT —
SLOPE —
COVAR —
DOLLARFR —
OCT2HEX —
COMBIN —
EVEN —
RECEIVED —
IF —
XNPV —
IMSQRT —
COUNTIF —
CUMPRINC —
ACOSH —
TRUNC —
TRIM —
PROB —
TRANSPOSE —
SEARCH —
CONCATENATE —
ISERROR —
INFO —
AMORDEGRC —
IMLN —
ERROR.TYPE —
List of Figures
1-1. Entering strings and numbers.
1-2. The highlighted selection
1-3. The option menu for dragging a cell with right click (MB3).
1-4. An Active cell.
1-5. The active cell with the cursor.
1-6. A multi-cell selection
1-7. Multiple cells being selected with the cursor.
1-8. A discontinuous selection of cells.
1-9. An entire row being selected.
1-10. An entire column being selected.
1-11. The entire worksheet being selected.
1-12. A selection of several cells.
1-13. A selection of several cells, filled with the same values.
1-14. A cell with the seed for an autofill.
1-15. A set of cells being autofilled
1-16. A seed cell for a date autofill.
1-17. A set of cells being filled with a sequence.
1-18. A cell with a date in it, ready to be the seed for a fill.
1-19. A set of cells being filled.
1-20. A range of cells autofilled with the months.
1-21. Some simple autofill examples.
1-22. Formula to be autofilled.
1-23. Formula autofilled to several cells.
3-1. The main number formatting dialog.
3-2. The Font selection dialog
3-3. The cell color dialog.
3-4. Example of text justification.
3-5. The cell justification dialog.
3-6. Example of justification quick buttons.
4-1. A example of the entire worksheet.
4-2. The Data Entry area.
4-3. The Current Cell Indicator.
4-4. The column labels at the top of the worksheet.
4-5. The row labels at the left side of the worksheet.
4-6. The info area.
4-7. The Zoom in button.
4-8. The Zoom out button
4-9. The running calculation area.
List of Examples
1-1. Examples of standard operators
1-2. Basic Function syntax
1-3. Some examples of function syntax
1-4. Examples of name usage
1-5. Entering an Array Formula
1-6. Some examples of function syntax
1-7. Absolute cell referencing examples
1-8. Some examples of function syntax
1-9. Referencing blocks of cells
1-10. Referencing blocks of cells
1-11. Referencing values in other sheets
3-1. Number Format Categories
3-2. Some examples of number formatting
3-3. Date and Time Formatting.