com.aspose.cells

Class ConsolidationFunction

  • java.lang.Object
    • com.aspose.cells.ConsolidationFunction
public class ConsolidationFunction 
extends java.lang.Object

Utility class containing constants. Represents consolidation function.

Field Summary
staticfinal intSUM
Represents Sum function.
staticfinal intCOUNT
Represents Count function.
staticfinal intAVERAGE
Represents Average function.
staticfinal intMAX
Represents Max function.
staticfinal intMIN
Represents Min function.
staticfinal intPRODUCT
Represents Product function.
staticfinal intCOUNT_NUMS
Represents Count Nums function.
staticfinal intSTD_DEV
Represents StdDev function.
staticfinal intSTD_DEVP
Represents StdDevp function.
staticfinal intVAR
Represents Var function.
staticfinal intVARP
Represents Varp function.
staticfinal intDISTINCT_COUNT
Represents Distinct Count function.
 

    • Field Detail

      • SUM

        public static final int SUM
        Represents Sum function.
      • COUNT

        public static final int COUNT
        Represents Count function.
      • AVERAGE

        public static final int AVERAGE
        Represents Average function.
      • MAX

        public static final int MAX
        Represents Max function.
      • MIN

        public static final int MIN
        Represents Min function.
      • PRODUCT

        public static final int PRODUCT
        Represents Product function.
      • COUNT_NUMS

        public static final int COUNT_NUMS
        Represents Count Nums function.
      • STD_DEV

        public static final int STD_DEV
        Represents StdDev function.
      • STD_DEVP

        public static final int STD_DEVP
        Represents StdDevp function.
      • VAR

        public static final int VAR
        Represents Var function.
      • VARP

        public static final int VARP
        Represents Varp function.
      • DISTINCT_COUNT

        public static final int DISTINCT_COUNT
        Represents Distinct Count function. Only valid for PivotTable with Data Module created since by 2013.