aspose.cells

aspose.cells

Class ConsolidationFunction

Utility class containing constants. Represents consolidation function.

Field Summary
const  NumberSUM
Represents Sum function.
const  NumberCOUNT
Represents Count function.
const  NumberAVERAGE
Represents Average function.
const  NumberMAX
Represents Max function.
const  NumberMIN
Represents Min function.
const  NumberPRODUCT
Represents Product function.
const  NumberCOUNT_NUMS
Represents Count Nums function.
const  NumberSTD_DEV
Represents StdDev function.
const  NumberSTD_DEVP
Represents StdDevp function.
const  NumberVAR
Represents Var function.
const  NumberVARP
Represents Varp function.
const  NumberDISTINCT_COUNT
Represents Distinct Count function.
 

    • Field Detail

      • SUM

        const Number SUM
        Represents Sum function.

      • COUNT

        const Number COUNT
        Represents Count function.

      • AVERAGE

        const Number AVERAGE
        Represents Average function.

      • MAX

        const Number MAX
        Represents Max function.

      • MIN

        const Number MIN
        Represents Min function.

      • PRODUCT

        const Number PRODUCT
        Represents Product function.

      • COUNT_NUMS

        const Number COUNT_NUMS
        Represents Count Nums function.

      • STD_DEV

        const Number STD_DEV
        Represents StdDev function.

      • STD_DEVP

        const Number STD_DEVP
        Represents StdDevp function.

      • VAR

        const Number VAR
        Represents Var function.

      • VARP

        const Number VARP
        Represents Varp function.

      • DISTINCT_COUNT

        const Number DISTINCT_COUNT
        Represents Distinct Count function. Only valid for PivotTable with Data Module created since by 2013.