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
|
|
Copyright © 2020, 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.