[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

SubtotalType

Enum Class SubtotalType

java.lang.Object
java.lang.Enum<SubtotalType>
com.grapecity.documents.excel.SubtotalType
All Implemented Interfaces:
Serializable, Comparable<SubtotalType>, Constable
public enum SubtotalType extends Enum<SubtotalType>
Specifies the type of subtotal for the specified pivot field.

  • Enum Constant Details

    • None

      public static final SubtotalType None
      Specifies no subtotal is used.

    • Automatic

      public static final SubtotalType Automatic
      Specifies that the subtotal type is the same as the value of PivotDataConsolidationFunction. If Automatic is used, all other subtotals should be removed.

    • Sum

      public static final SubtotalType Sum
      Specifies sum.

    • Count

      public static final SubtotalType Count
      Specifies the number of values.

    • Average

      public static final SubtotalType Average
      Specifies the average.

    • Max

      public static final SubtotalType Max
      Specifies the maximum.

    • Min

      public static final SubtotalType Min
      Specifies the minimum.

    • Product

      public static final SubtotalType Product
      Specifies the product.

    • CountNums

      public static final SubtotalType CountNums
      Specifies the number of numeric values.

    • StdDev

      public static final SubtotalType StdDev
      Specifies StdDev.

    • StdDevP

      public static final SubtotalType StdDevP
      Specifies StdDevP.

    • Var

      public static final SubtotalType Var
      Specifies Var.

    • VarP

      public static final SubtotalType VarP
      Specifies VarP.

  • Method Details

    • values

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