:: com :: sun :: star :: sheet ::

constants group GeneralFunction2

Constants
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.  
MEDIAN * median of all numerical values is calculated. *
Since LibreOffice 5.3  
Constants' Details
NONE
const short NONE = 0;
Description
nothing is calculated.
AUTO
const short AUTO = 1;
Description
function is determined automatically.

If the values are all numerical, SUM is used, otherwise COUNT.

SUM
const short SUM = 2;
Description
sum of all numerical values is calculated.
COUNT
const short COUNT = 3;
Description
all values, including non-numerical values, are counted.
AVERAGE
const short AVERAGE = 4;
Description
average of all numerical values is calculated.
MAX
const short MAX = 5;
Description
maximum value of all numerical values is calculated.
MIN
const short MIN = 6;
Description
minimum value of all numerical values is calculated.
PRODUCT
const short PRODUCT = 7;
Description
product of all numerical values is calculated.
COUNTNUMS
const short COUNTNUMS = 8;
Description
numerical values are counted.
STDEV
const short STDEV = 9;
Description
standard deviation is calculated based on a sample.
STDEVP
const short STDEVP = 10;
Description
standard deviation is calculated based on the entire population.
VAR
const short VAR = 11;
Description
variance is calculated based on a sample.
VARP
const short VARP = 12;
Description
variance is calculated based on the entire population.
MEDIAN
const short MEDIAN = 13;
Description
* median of all numerical values is calculated. *
Since LibreOffice 5.3
Top of Page