aspose.cells

Class PivotOptions

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

Property Getters/Setters Summary
functiongetDropZoneCategories()
function
           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.
functiongetDropZoneData()
function
           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.
functiongetDropZoneFilter()
function
           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.
functiongetDropZoneSeries()
function
           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.
functiongetDropZonesVisible()
function
           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.