PivotTableCalculateOption

PivotTableCalculateOption class

Rerepsents the options of calculating data of the pivot table.

class PivotTableCalculateOption;

Constructors

Constructor	Description
constructor()	Default Constructor.

Properties

Property	Type	Description
refreshData	boolean	Indicates whether refreshing data source of the pivottable.
refreshCharts	boolean	Indicates whether refreshing charts are based on this pivot table.
reserveMissingPivotItemType	ReserveMissingPivotItemType	Represents how to reserve missing pivot items.

Methods

Method	Description
getRefreshData()	@deprecated. Please use the ‘refreshData’ property instead. Indicates whether refreshing data source of the pivottable.
setRefreshData(boolean)	@deprecated. Please use the ‘refreshData’ property instead. Indicates whether refreshing data source of the pivottable.
getRefreshCharts()	@deprecated. Please use the ‘refreshCharts’ property instead. Indicates whether refreshing charts are based on this pivot table.
setRefreshCharts(boolean)	@deprecated. Please use the ‘refreshCharts’ property instead. Indicates whether refreshing charts are based on this pivot table.
getReserveMissingPivotItemType()	@deprecated. Please use the ‘reserveMissingPivotItemType’ property instead. Represents how to reserve missing pivot items.
setReserveMissingPivotItemType(ReserveMissingPivotItemType)	@deprecated. Please use the ‘reserveMissingPivotItemType’ property instead. Represents how to reserve missing pivot items.
isNull()	Checks whether the implementation object is null.

constructor()

Default Constructor.

constructor();

refreshData

Indicates whether refreshing data source of the pivottable.

refreshData : boolean;

Remarks

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

refreshCharts

Indicates whether refreshing charts are based on this pivot table.

refreshCharts : boolean;

reserveMissingPivotItemType

Represents how to reserve missing pivot items.

reserveMissingPivotItemType : ReserveMissingPivotItemType;

Remarks

Only works when RefreshData is true.

getRefreshData()

@deprecated. Please use the ‘refreshData’ property instead. Indicates whether refreshing data source of the pivottable.

getRefreshData() : boolean;

Remarks

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

setRefreshData(boolean)

@deprecated. Please use the ‘refreshData’ property instead. Indicates whether refreshing data source of the pivottable.

setRefreshData(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

getRefreshCharts()

@deprecated. Please use the ‘refreshCharts’ property instead. Indicates whether refreshing charts are based on this pivot table.

getRefreshCharts() : boolean;

setRefreshCharts(boolean)

@deprecated. Please use the ‘refreshCharts’ property instead. Indicates whether refreshing charts are based on this pivot table.

setRefreshCharts(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getReserveMissingPivotItemType()

@deprecated. Please use the ‘reserveMissingPivotItemType’ property instead. Represents how to reserve missing pivot items.

getReserveMissingPivotItemType() : ReserveMissingPivotItemType;

Returns

ReserveMissingPivotItemType

Remarks

Only works when RefreshData is true.

setReserveMissingPivotItemType(ReserveMissingPivotItemType)

@deprecated. Please use the ‘reserveMissingPivotItemType’ property instead. Represents how to reserve missing pivot items.

setReserveMissingPivotItemType(value: ReserveMissingPivotItemType) : void;

Parameters:

Parameter	Type	Description
value	ReserveMissingPivotItemType	The value to set.

Remarks

Only works when RefreshData is true.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;