Language
The Free and Open Productivity Suite
:: com :: sun :: star :: sheet ::
|
| enum GeneralFunction |
- Description
- used to specify a function to be calculated from values.
|
| Values |
| NONE |
nothing is calculated.
|
| AUTO |
function is determined automatically.
|
| SUM |
sum of all numerical values is calculated.
|
| COUNT |
all values, including non-numerical values, are counted.
|
| AVERAGE |
average of all numerical values is calculated.
|
| MAX |
maximum value of all numerical values is calculated.
|
| MIN |
minimum value of all numerical values is calculated.
|
| PRODUCT |
product of all numerical values is calculated.
|
| COUNTNUMS |
numerical values are counted.
|
| STDEV |
standard deviation is calculated based on a sample.
|
| STDEVP |
standard deviation is calculated based on the entire population.
|
| VAR |
variance is calculated based on a sample.
|
| VARP |
variance is calculated based on the entire population.
|
| Values' Details |
NONE
NONE,
- Description
- nothing is calculated.
|
|
AUTO
AUTO,
- Description
- function is determined automatically.
If the values are all numerical, SUM is used, otherwise COUNT.
|
|
SUM
SUM,
- Description
- sum of all numerical values is calculated.
|
|
COUNT
COUNT,
- Description
- all values, including non-numerical values, are counted.
|
|
AVERAGE
AVERAGE,
- Description
- average of all numerical values is calculated.
|
|
MAX
MAX,
- Description
- maximum value of all numerical values is calculated.
|
|
MIN
MIN,
- Description
- minimum value of all numerical values is calculated.
|
|
PRODUCT
PRODUCT,
- Description
- product of all numerical values is calculated.
|
|
COUNTNUMS
COUNTNUMS,
- Description
- numerical values are counted.
|
|
STDEV
STDEV,
- Description
- standard deviation is calculated based on a sample.
|
|
STDEVP
STDEVP,
- Description
- standard deviation is calculated based on the entire population.
|
|
VAR
VAR,
- Description
- variance is calculated based on a sample.
|
|
VARP
VARP,
- Description
- variance is calculated based on the entire population.
|
|
Top of Page
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.
