Gnumeric's user manual
Copyright
© 1998, 1999, 2000 by Miguel de Icaza, Thomas Canty
Table of Contents
1.
Introduction.
The Worksheet
The Menu bar
The Toolbar
Other worksheet areas.
Data entry area.
The Cell area
The Info Area
2.
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.
Editing cells using the selection
Simple Selections
Selecting multiple cells
Discontinuous selections
Keyboard Shortcuts
Filling a region with the same text or value.
3.
Copying and Moving.
Using the mouse to drag the selection
Right Click Options
Move and copy right click menu options
4.
Autofill.
AutoFill
Filling with Dates
String And Number autofill
Formula autofill
Automagic autofill
Other Notes on autofill
5.
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
6.
Working with files.
Saving files
File format
7.
Printing
Printing to a Printer or a File.
Print Setup.
Print Setup Dialog - Page
Print Setup Dialog - Margins
Print Setup Dialog - Headers and Footers
Print Setup Dialog - Page
Print Preview.
Menu Bar
Toolbar
8.
Solver
Solver
Introduction to Linear Programming
Spreadsheet Modeling
Integer Programming
9.
Data analysis tools
Analysis Tools
Anova: Single Factor Tool
Anova: Two-Factor With Replication Tool
Anova: Two-Factor Without Replication Tool
Correlation Tool
Covariance Tool
Descriptive Statistics Tool
F-Test:Two-Sample for Variances Tool
Moving Average Tool
Random Number Generation Tool
Rank and Percentile Tool
Regression Tool
Sampling Tool
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
10.
Tutorials
11.
Drawing on a worksheet
12.
Authors
Authors
13.
License
License
14.
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 —
TRUE —
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 —
FALSE —
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 —
DATEDIF —
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 —
GNUMERIC_VERSION —
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.
A example of the entire worksheet.
1-2.
The
toolbar
1-3.
The Data Entry area.
1-4.
The Current Cell Indicator.
1-5.
The column labels at the top of the worksheet.
1-6.
The row labels at the left side of the worksheet.
1-7.
The info area.
1-8.
The running calculation area.
2-1.
Entering strings and numbers.
2-2.
The highlighted selection
2-3.
An Active cell.
2-4.
The active cell with the cursor.
2-5.
A multi-cell selection
2-6.
Multiple cells being selected with the cursor.
2-7.
A discontinuous selection of cells.
2-8.
An entire row being selected.
2-9.
An entire column being selected.
2-10.
The entire worksheet being selected.
2-11.
A selection of several cells.
2-12.
A selection of several cells, filled with the same values.
3-1.
The option menu for dragging a cell with right click
4-1.
A cell with the seed for an autofill.
4-2.
A set of cells being autofilled
4-3.
A seed cell for a date autofill.
4-4.
A set of cells being filled with a sequence.
4-5.
A cell with a date in it, ready to be the seed for a fill.
4-6.
A set of cells being filled.
4-7.
A range of cells autofilled with the months.
4-8.
Some simple autofill examples.
4-9.
Formula to be autofilled.
4-10.
Formula autofilled to several cells.
5-1.
The main number formatting dialog.
5-2.
The Font selection dialog
5-3.
The cell color dialog.
5-4.
Example of text justification.
5-5.
The cell justification dialog.
5-6.
Example of justification quick buttons.
7-1.
Print Dialog
7-2.
Print Setup Dialog - Page
7-3.
Print Setup Dialog - Margins
7-4.
Print Dialog
7-5.
Print Setup Dialog - Page
7-6.
Print Preview Dialog
8-1.
Linear programming example
8-2.
The empty Solver dialog.
8-3.
Add constraint dialog.
8-4.
The solver dialog
8-5.
The Solver results dialog
List of Examples
2-1.
Examples of standard operators
2-2.
Basic Function syntax
2-3.
Some examples of function syntax
2-4.
Examples of name usage
2-5.
Entering an Array Formula
2-6.
Some examples of function syntax
2-7.
Absolute cell referencing examples
2-8.
Some examples of function syntax
2-9.
Referencing blocks of cells
2-10.
Referencing blocks of cells
2-11.
Referencing values in other sheets
5-1.
Number Format Categories
5-2.
Some examples of number formatting
5-3.
Date and Time Formatting.
Next
Introduction.