Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.