aspose.cells

Class PivotOptions

Utility class containing constants. Represents a complex type that specifies the pivot controls that appear on the chart

Field Summary
booleanDropZoneFilter
Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
booleanDropZoneCategories
Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
booleanDropZoneData
Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
booleanDropZoneSeries
Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
booleanDropZonesVisible
Specifies whether any pivot controls can appear on the pivot chart.
 

    • Field Detail

      • DropZoneFilter

        boolean DropZoneFilter
        Specifies whether a control for each PivotTable field on the PivotTable page axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
      • DropZoneCategories

        boolean DropZoneCategories
        Specifies whether a control for each PivotTable field on the PivotTable row axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
      • DropZoneData

        boolean DropZoneData
        Specifies whether a control for each PivotTable field on the PivotTable data axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
      • DropZoneSeries

        boolean DropZoneSeries
        Specifies whether a control for each PivotTable field on the PivotTable column axis of the source PivotTable appears on the chart when dropZonesVisible is set to true.
      • DropZonesVisible

        boolean DropZonesVisible
        Specifies whether any pivot controls can appear on the pivot chart.