LibreOffice Module sc (master)  1
Enumerations
generalfunction.hxx File Reference
#include <com/sun/star/sheet/GeneralFunction.hpp>
#include <com/sun/star/sheet/GeneralFunction2.hpp>
Include dependency graph for generalfunction.hxx:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Enumerations

enum  ScGeneralFunction {
  ScGeneralFunction::NONE = int(css::sheet::GeneralFunction_NONE),
  ScGeneralFunction::AUTO = int(css::sheet::GeneralFunction_AUTO),
  ScGeneralFunction::SUM = int(css::sheet::GeneralFunction_SUM),
  ScGeneralFunction::COUNT = int(css::sheet::GeneralFunction_COUNT),
  ScGeneralFunction::AVERAGE = int(css::sheet::GeneralFunction_AVERAGE),
  ScGeneralFunction::MAX = int(css::sheet::GeneralFunction_MAX),
  ScGeneralFunction::MIN = int(css::sheet::GeneralFunction_MIN),
  ScGeneralFunction::PRODUCT = int(css::sheet::GeneralFunction_PRODUCT),
  ScGeneralFunction::COUNTNUMS = int(css::sheet::GeneralFunction_COUNTNUMS),
  ScGeneralFunction::STDEV = int(css::sheet::GeneralFunction_STDEV),
  ScGeneralFunction::STDEVP = int(css::sheet::GeneralFunction_STDEVP),
  ScGeneralFunction::VAR = int(css::sheet::GeneralFunction_VAR),
  ScGeneralFunction::VARP = int(css::sheet::GeneralFunction_VARP),
  ScGeneralFunction::MEDIAN = css::sheet::GeneralFunction2::MEDIAN
}
 the css::sheet::GeneralFunction enum is extended by constants in GeneralFunction2, which causes some type-safety issues. More...
 

Enumeration Type Documentation

enum ScGeneralFunction
strong

the css::sheet::GeneralFunction enum is extended by constants in GeneralFunction2, which causes some type-safety issues.

So abstract them behind the facade of this enum.

Enumerator
NONE 

nothing is calculated.

AUTO 

function is determined automatically.

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

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.

Available since:
LibreOffice 5.3

Definition at line 29 of file generalfunction.hxx.