aspose.cells

Class PivotAreaType

Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.

Field Summary
const  NumberNONE
No Pivot area.
const  NumberNORMAL
Represents a header or item.
const  NumberDATA
Represents something in the data area.
const  NumberALL
Represents the whole PivotTable.
const  NumberORIGIN
Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
const  NumberBUTTON
Represents a field button.
const  NumberTOP_RIGHT
Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).
 

    • Field Detail

      • NONE

        const Number NONE
        No Pivot area.
      • NORMAL

        const Number NORMAL
        Represents a header or item.
      • DATA

        const Number DATA
        Represents something in the data area.
      • ALL

        const Number ALL
        Represents the whole PivotTable.
      • ORIGIN

        const Number ORIGIN
        Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
      • BUTTON

        const Number BUTTON
        Represents a field button.
      • TOP_RIGHT

        const Number TOP_RIGHT
        Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).