aspose.cells

Class PivotAreaFilter

Represents the filter of PivotArea for PivotTable.

Constructor Summary
 
Property Getters/Setters Summary
functiongetSelected()
function
           Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
 
Method Summary
functionisSubtotalSet(subtotalType)
Gets which subtotal is set for this filter.
functionsetSubtotals(subtotalType, shown)
Subtotal for the filter.
 

    • Constructor Detail

      • PivotAreaFilter

        function PivotAreaFilter()
    • Property Getters/Setters Detail

      • getSelected/setSelected : boolean 

        function getSelected() / function setSelected(value)
        
        Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
    • Method Detail

      • isSubtotalSet

        function isSubtotalSet(subtotalType)
        Gets which subtotal is set for this filter.
        Parameters:
        subtotalType: Number - A PivotFieldSubtotalType value. The subtotal function type.
        Returns:
      • setSubtotals

        function setSubtotals(subtotalType, shown)
        Subtotal for the filter.
        Parameters:
        subtotalType: Number - A PivotFieldSubtotalType value. The subtotal function.
        shown: boolean - Indicates if showing this subtotal data.