PivotTableCalculateOption

PivotTableCalculateOption class

Rerepsents the options of calcuating the pivot table.

class PivotTableCalculateOption;

Constructors

NameDescription
constructor()Default Constructor.

Methods

MethodDescription
getRefreshData()Indicates whether refreshing data source of the pivottable.
setRefreshData(boolean)Indicates whether refreshing data source of the pivottable.
getRefreshCharts()Indicates whether refreshing charts are based on this pivot table.
setRefreshCharts(boolean)Indicates whether refreshing charts are based on this pivot table.
getReserveMissingPivotItemType()Represents how to reserve missing pivot items.
setReserveMissingPivotItemType(ReserveMissingPivotItemType)Represents how to reserve missing pivot items.
isNull()Checks whether the implementation object is null.

constructor()

Default Constructor.

constructor();

getRefreshData()

Indicates whether refreshing data source of the pivottable.

getRefreshData() : boolean;

setRefreshData(boolean)

Indicates whether refreshing data source of the pivottable.

setRefreshData(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

getRefreshCharts()

Indicates whether refreshing charts are based on this pivot table.

getRefreshCharts() : boolean;

setRefreshCharts(boolean)

Indicates whether refreshing charts are based on this pivot table.

setRefreshCharts(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

getReserveMissingPivotItemType()

Represents how to reserve missing pivot items.

getReserveMissingPivotItemType() : ReserveMissingPivotItemType;

Returns

ReserveMissingPivotItemType

Remarks

Only works when RefreshData is true.

setReserveMissingPivotItemType(ReserveMissingPivotItemType)

Represents how to reserve missing pivot items.

setReserveMissingPivotItemType(value: ReserveMissingPivotItemType) : void;

Parameters:

ParameterTypeDescription
valueReserveMissingPivotItemTypeThe value to set.

Remarks

Only works when RefreshData is true.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;