asposecells.api

Classes

Constants

asposecells.api

Class PivotAreaFilter

Represents the filter of PivotArea for PivotTable.

Constructor Summary
`PivotAreaFilter()`

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

Method Summary
`method`	`isSubtotalSet(subtotalType)`
`method`	Gets which subtotal is set for this filter.
`method`	`setSubtotals(subtotalType, shown)`
`method`	Subtotal for the filter.

- Constructor Detail
  - PivotAreaFilter
```
PivotAreaFilter()
```
- Property Getters/Setters Detail
  - getSelected/setSelected : boolean
```
boolean getSelected() / setSelected(value)
```
    Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
- Method Detail
  - isSubtotalSet
```
boolean isSubtotalSet(subtotalType)
```
    Gets which subtotal is set for this filter.
    Parameters:
    subtotalType: int - A PivotFieldSubtotalType value. The subtotal function type.
    Returns:
  - setSubtotals
```
 setSubtotals(subtotalType, shown)
```
    Subtotal for the filter.
    Parameters:
    subtotalType: int - A PivotFieldSubtotalType value. The subtotal function.
    shown: boolean - Indicates if showing this subtotal data.