程序包 com.grapecity.documents.excel

Enum Class PivotFieldCalculation

java.lang.Object

java.lang.Enum<PivotFieldCalculation>

com.grapecity.documents.excel.PivotFieldCalculation

所有已实现的接口:

Serializable, Comparable<PivotFieldCalculation>, Constable

public enum PivotFieldCalculation
extends Enum<PivotFieldCalculation>

Specifies the subtotal function.

嵌套类概要

从类继承的嵌套类/接口 java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

枚举常量概要

枚举常量

枚举常量	说明
DifferenceFrom	The difference from the value of the Base item in the Base field.
Index	Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).
NoAdditionalCalculation	No calculation.
PercentDifferenceFrom	Percentage difference from the value of the Base item in the Base field.
PercentOf	Percentage of the value of the Base item in the Base field.
PercentOfColumn	Percentage of the total for the column or series.
PercentOfParent	Percentage of the total of the specified parent Base field.
PercentOfParentColumn	Percentage of the total of the parent column.
PercentOfParentRow	Percentage of the total of the parent row.
PercentOfRow	Percentage of the total for the row or category.
PercentOfTotal	Percentage of the grand total of all the data or data points in the report.
PercentRunningTotal	Percentage of the running total of the specified Base field.
RankAscending	Rank smallest to largest.
RankDecending	Rank largest to smallest.
RunningTotal	Data for successive items in the Base field as a running total.

方法概要

修饰符和类型	方法	说明
static PivotFieldCalculation	forValue(int value)
int	getValue()
static PivotFieldCalculation	valueOf(String name)	Returns the enum constant of this class with the specified name.
static PivotFieldCalculation[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

从类继承的方法 java.lang.Enum

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

从类继承的方法 java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

枚举常量详细资料

DifferenceFrom

public static final PivotFieldCalculation DifferenceFrom

The difference from the value of the Base item in the Base field.

Index

public static final PivotFieldCalculation Index

Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)).

NoAdditionalCalculation

public static final PivotFieldCalculation NoAdditionalCalculation

No calculation.

PercentDifferenceFrom

public static final PivotFieldCalculation PercentDifferenceFrom

Percentage difference from the value of the Base item in the Base field.

PercentOf

public static final PivotFieldCalculation PercentOf

Percentage of the value of the Base item in the Base field.

PercentOfColumn

public static final PivotFieldCalculation PercentOfColumn

Percentage of the total for the column or series.

PercentOfParent

public static final PivotFieldCalculation PercentOfParent

Percentage of the total of the specified parent Base field.

PercentOfParentColumn

public static final PivotFieldCalculation PercentOfParentColumn

Percentage of the total of the parent column.

PercentOfParentRow

public static final PivotFieldCalculation PercentOfParentRow

Percentage of the total of the parent row.

PercentOfRow

public static final PivotFieldCalculation PercentOfRow

Percentage of the total for the row or category.

PercentOfTotal

public static final PivotFieldCalculation PercentOfTotal

Percentage of the grand total of all the data or data points in the report.

PercentRunningTotal

public static final PivotFieldCalculation PercentRunningTotal

Percentage of the running total of the specified Base field.

RankAscending

public static final PivotFieldCalculation RankAscending

Rank smallest to largest.

RankDecending

public static final PivotFieldCalculation RankDecending

Rank largest to smallest.

RunningTotal

public static final PivotFieldCalculation RunningTotal

Data for successive items in the Base field as a running total.

方法详细资料

values

public static PivotFieldCalculation[] values()

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

返回:

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

valueOf

public static PivotFieldCalculation 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.)

参数:

name - 要返回的枚举常量的名称。

返回:

返回带有指定名称的枚举常量

抛出:

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

NullPointerException - 如果参数为空值

getValue

public int getValue()

forValue

public static PivotFieldCalculation forValue(int value)