Package io.keikai.axyra.sheets

Enum Class AggregateFunction

java.lang.Object

java.lang.Enum<AggregateFunction>

io.keikai.axyra.sheets.AggregateFunction

All Implemented Interfaces:

Serializable, Comparable<AggregateFunction>, Constable

public enum AggregateFunction
extends Enum<AggregateFunction>

Aggregate function for a pivot table data (values) field.

Mirrors ECMA-376 Part 1 §18.18.18 ST_DataConsolidateFunction, the value set of the subtotal attribute on <dataField>.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
AVERAGE
COUNT
COUNT_NUMS	Count of numeric values only (countNums).
MAX
MIN
PRODUCT
STD_DEV	Sample standard deviation (stdDev).
STD_DEVP	Population standard deviation (stdDevp).
SUM
VAR	Sample variance (var).
VARP	Population variance (varp).

Method Summary

Modifier and Type	Method	Description
static AggregateFunction	fromOoxml(String value)	Parses an ST_DataConsolidateFunction string (case-insensitive).
String	ooxml()	The ST_DataConsolidateFunction string ("sum", "countNums", ...).
static AggregateFunction	valueOf(String name)	Returns the enum constant of this class with the specified name.
static AggregateFunction[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

SUM

public static final AggregateFunction SUM

COUNT

public static final AggregateFunction COUNT

AVERAGE

public static final AggregateFunction AVERAGE

MAX

public static final AggregateFunction MAX

MIN

public static final AggregateFunction MIN

PRODUCT

public static final AggregateFunction PRODUCT

COUNT_NUMS

public static final AggregateFunction COUNT_NUMS

Count of numeric values only (countNums).

STD_DEV

public static final AggregateFunction STD_DEV

Sample standard deviation (stdDev).

STD_DEVP

public static final AggregateFunction STD_DEVP

Population standard deviation (stdDevp).

VAR

public static final AggregateFunction VAR

Sample variance (var).

VARP

public static final AggregateFunction VARP

Population variance (varp).

Method Details

values

public static AggregateFunction[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static AggregateFunction valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

ooxml

public String ooxml()

The ST_DataConsolidateFunction string ("sum", "countNums", ...).

fromOoxml

public static AggregateFunction fromOoxml(String value)

Parses an ST_DataConsolidateFunction string (case-insensitive).