PivotAreaFilter

PivotAreaFilter class

Represents the filter of PivotArea for PivotTable.

class PivotAreaFilter;

Constructors

NameDescription
constructor()Default Constructor.

Methods

MethodDescription
getSelected()Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
setSelected(boolean)Indicates whether this field has selection. Only works when the PivotTable is in Outline view.
isSubtotalSet(PivotFieldSubtotalType)Gets which subtotal is set for this filter.
setSubtotals(PivotFieldSubtotalType, boolean)Subtotal for the filter.
isNull()Checks whether the implementation object is null.

constructor()

Default Constructor.

constructor();

getSelected()

Indicates whether this field has selection. Only works when the PivotTable is in Outline view.

getSelected() : boolean;

setSelected(boolean)

Indicates whether this field has selection. Only works when the PivotTable is in Outline view.

setSelected(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

isSubtotalSet(PivotFieldSubtotalType)

Gets which subtotal is set for this filter.

isSubtotalSet(subtotalType: PivotFieldSubtotalType) : boolean;

Parameters:

ParameterTypeDescription
subtotalTypePivotFieldSubtotalTypeThe subtotal function type.

setSubtotals(PivotFieldSubtotalType, boolean)

Subtotal for the filter.

setSubtotals(subtotalType: PivotFieldSubtotalType, shown: boolean) : void;

Parameters:

ParameterTypeDescription
subtotalTypePivotFieldSubtotalTypeThe subtotal function.
shownbooleanIndicates if showing this subtotal data.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;