aspose.cells

Classes

Constants

Class PivotOptions

Represents a complex type that specifies the pivot controls that appear on the chart

Property Getters/Setters Summary
`function`	`getDropZoneCategories()`
`function`	`setDropZoneCategories(value)`
	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.
`function`	`getDropZoneData()`
`function`	`setDropZoneData(value)`
	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.
`function`	`getDropZoneFilter()`
`function`	`setDropZoneFilter(value)`
	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.
`function`	`getDropZoneSeries()`
`function`	`setDropZoneSeries(value)`
	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.
`function`	`getDropZonesVisible()`
`function`	`setDropZonesVisible(value)`
	Specifies whether any pivot controls can appear on the pivot chart.

- Property Getters/Setters Detail
  - getDropZoneFilter/setDropZoneFilter : boolean
```
function getDropZoneFilter() / function setDropZoneFilter(value)
```
    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.
  - getDropZoneCategories/setDropZoneCategories : boolean
```
function getDropZoneCategories() / function setDropZoneCategories(value)
```
    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.
  - getDropZoneData/setDropZoneData : boolean
```
function getDropZoneData() / function setDropZoneData(value)
```
    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.
  - getDropZoneSeries/setDropZoneSeries : boolean
```
function getDropZoneSeries() / function setDropZoneSeries(value)
```
    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.
  - getDropZonesVisible/setDropZonesVisible : boolean
```
function getDropZonesVisible() / function setDropZonesVisible(value)
```
    Specifies whether any pivot controls can appear on the pivot chart.