aspose.cells

Classes

Constants

Class PivotAreaFilter

Represents the filter of PivotArea for PivotTable.

Constructor Summary
`PivotAreaFilter()`

Property Getters/Setters Summary
`function`	`getSelected()`
`function`	`setSelected(value)`
	Indicates whether this field has selection. Only works when the PivotTable is in Outline view.

Method Summary
`function`	`isSubtotalSet(subtotalType)`
`function`	Gets which subtotal is set for this filter.
`function`	`setSubtotals(subtotalType, shown)`
`function`	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.