Package com.grapecity.documents.excel

Enum Class PivotFieldCalculation

java.lang.Object
java.lang.Enum<PivotFieldCalculation>
com.grapecity.documents.excel.PivotFieldCalculation
All Implemented Interfaces:
Serializable, Comparable<PivotFieldCalculation>, Constable
public enum PivotFieldCalculation extends Enum<PivotFieldCalculation>
指定小计功能。

  • Enum Constant Details

    • DifferenceFrom

      public static final PivotFieldCalculation DifferenceFrom
      与基字段中基项值的差异。

    • Index

      public static final PivotFieldCalculation Index
      数据计算方式为：((单元格中的值) x (所有总计的总和)) / ((行总计) x (列总计)).

    • NoAdditionalCalculation

      public static final PivotFieldCalculation NoAdditionalCalculation
      无计算。

    • PercentDifferenceFrom

      public static final PivotFieldCalculation PercentDifferenceFrom
      基数字段中基项值的百分比差异。

    • PercentOf

      public static final PivotFieldCalculation PercentOf
      基字段中基项目值的百分比。

    • PercentOfColumn

      public static final PivotFieldCalculation PercentOfColumn
      列或系列的总百分比。

    • PercentOfParent

      public static final PivotFieldCalculation PercentOfParent
      指定父级Base字段总数的百分比。

    • PercentOfParentColumn

      public static final PivotFieldCalculation PercentOfParentColumn
      父列总量的百分比。

    • PercentOfParentRow

      public static final PivotFieldCalculation PercentOfParentRow
      父行的总百分比。

    • PercentOfRow

      public static final PivotFieldCalculation PercentOfRow
      行或类别占总数的百分比。

    • PercentOfTotal

      public static final PivotFieldCalculation PercentOfTotal
      报告中所包含的所有数据或数据点的总量的百分比。

    • PercentRunningTotal

      public static final PivotFieldCalculation PercentRunningTotal
      指定基础字段运行总数的百分比。

    • RankAscending

      public static final PivotFieldCalculation RankAscending
      按从小到大的顺序排列。

    • RankDecending

      public static final PivotFieldCalculation RankDecending
      从大到小排序。

    • RunningTotal

      public static final PivotFieldCalculation RunningTotal
      基字段中后续项目的数据作为累加总计。

  • Method Details

    • values

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

    • getValue

      public int getValue()

    • forValue

      public static PivotFieldCalculation forValue(int value)