com.aspose.cells

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
static final intSUM
Represents Sum function.
static final intCOUNT
Represents Count function.
static final intAVERAGE
Represents Average function.
static final intMAX
Represents Max function.
static final intMIN
Represents Min function.
static final intPRODUCT
Represents Product function.
static final intCOUNT_NUMS
Represents Count Nums function.
static final intSTD_DEV
Represents StdDev function.
static final intSTD_DEVP
Represents StdDevp function.
static final intVAR
Represents Var function.
static final intVARP
Represents Varp function.
static final 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.