aspose.cells

aspose.cells

Class PivotFieldDataDisplayFormat

Utility class containing constants. Represents data display format in the PivotTable data field.

Field Summary
const  NumberNORMAL
Represents normal display format.
const  NumberDIFFERENCE_FROM
Represents difference from display format.
const  NumberPERCENTAGE_OF
Represents percentage of display format.
const  NumberPERCENTAGE_DIFFERENCE_FROM
Represents percentage difference from display format.
const  NumberRUNNING_TOTAL_IN
Represents running total in display format.
const  NumberPERCENTAGE_OF_ROW
Represents percentage of row display format.
const  NumberPERCENTAGE_OF_COLUMN
Represents percentage of column display format.
const  NumberPERCENTAGE_OF_TOTAL
Represents percentage of total display format.
const  NumberINDEX
Represents index display format.
const  NumberPERCENTAGE_OF_PARENT_ROW_TOTAL
Represents percentage of parent row total display format.
const  NumberPERCENTAGE_OF_PARENT_COLUMN_TOTAL
Represents percentage of parent column total display format.
const  NumberPERCENTAGE_OF_PARENT_TOTAL
Represents percentage of parent total display format.
const  NumberPERCENTAGE_OF_RUNNING_TOTAL_IN
Represents percentage of running total in display format.
const  NumberRANK_SMALLEST_TO_LARGEST
Represents smallest to largest display format.
const  NumberRANK_LARGEST_TO_SMALLEST
Represents largest to smallest display format.
 

    • Field Detail

      • NORMAL

        const Number NORMAL
        Represents normal display format.

      • DIFFERENCE_FROM

        const Number DIFFERENCE_FROM
        Represents difference from display format.

      • PERCENTAGE_OF

        const Number PERCENTAGE_OF
        Represents percentage of display format.

      • PERCENTAGE_DIFFERENCE_FROM

        const Number PERCENTAGE_DIFFERENCE_FROM
        Represents percentage difference from display format.

      • RUNNING_TOTAL_IN

        const Number RUNNING_TOTAL_IN
        Represents running total in display format.

      • PERCENTAGE_OF_ROW

        const Number PERCENTAGE_OF_ROW
        Represents percentage of row display format.

      • PERCENTAGE_OF_COLUMN

        const Number PERCENTAGE_OF_COLUMN
        Represents percentage of column display format.

      • PERCENTAGE_OF_TOTAL

        const Number PERCENTAGE_OF_TOTAL
        Represents percentage of total display format.

      • INDEX

        const Number INDEX
        Represents index display format.

      • PERCENTAGE_OF_PARENT_ROW_TOTAL

        const Number PERCENTAGE_OF_PARENT_ROW_TOTAL
        Represents percentage of parent row total display format.

      • PERCENTAGE_OF_PARENT_COLUMN_TOTAL

        const Number PERCENTAGE_OF_PARENT_COLUMN_TOTAL
        Represents percentage of parent column total display format.

      • PERCENTAGE_OF_PARENT_TOTAL

        const Number PERCENTAGE_OF_PARENT_TOTAL
        Represents percentage of parent total display format.

      • PERCENTAGE_OF_RUNNING_TOTAL_IN

        const Number PERCENTAGE_OF_RUNNING_TOTAL_IN
        Represents percentage of running total in display format.

      • RANK_SMALLEST_TO_LARGEST

        const Number RANK_SMALLEST_TO_LARGEST
        Represents smallest to largest display format.

      • RANK_LARGEST_TO_SMALLEST

        const Number RANK_LARGEST_TO_SMALLEST
        Represents largest to smallest display format.