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.