Package io.keikai.axyra.sheets

Enum Class TotalsRowFunction

java.lang.Object

java.lang.Enum<TotalsRowFunction>

io.keikai.axyra.sheets.TotalsRowFunction

All Implemented Interfaces:

Serializable, Comparable<TotalsRowFunction>, Constable

public enum TotalsRowFunction
extends Enum<TotalsRowFunction>

Table totals-row aggregation (ECMA-376 §18.18.92 ST_TotalsRowFunction). The built-in kinds map to the SUBTOTAL(101..110, …) formulas Excel writes into the totals-row cell; CUSTOM carries an explicit formula.

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	COUNTA — counts non-empty cells (SUBTOTAL 103).
COUNT_NUMS	COUNT — counts numeric cells (SUBTOTAL 102).
CUSTOM
MAX
MIN
NONE
STD_DEV
SUM
VAR

Method Summary

Modifier and Type	Method	Description
String	code()	The ECMA-376 token passed across the FFI.
static TotalsRowFunction	valueOf(String name)	Returns the enum constant of this class with the specified name.
static TotalsRowFunction[]	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

NONE

public static final TotalsRowFunction NONE

SUM

public static final TotalsRowFunction SUM

MIN

public static final TotalsRowFunction MIN

MAX

public static final TotalsRowFunction MAX

AVERAGE

public static final TotalsRowFunction AVERAGE

COUNT

public static final TotalsRowFunction COUNT

COUNTA — counts non-empty cells (SUBTOTAL 103).

COUNT_NUMS

public static final TotalsRowFunction COUNT_NUMS

COUNT — counts numeric cells (SUBTOTAL 102).

STD_DEV

public static final TotalsRowFunction STD_DEV

VAR

public static final TotalsRowFunction VAR

CUSTOM

public static final TotalsRowFunction CUSTOM

Method Details

values

public static TotalsRowFunction[] 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 TotalsRowFunction 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

code

public String code()

The ECMA-376 token passed across the FFI.