PivotTableCalculateOption

PivotTableCalculateOption class

Rerepsents the options of calcuating the pivot table.

class PivotTableCalculateOption;

Constructors

ConstructorDescription
constructor()Default Constructor.

Properties

PropertyTypeDescription
refreshDatabooleanIndicates whether refreshing data source of the pivottable.
refreshChartsbooleanIndicates whether refreshing charts are based on this pivot table.
reserveMissingPivotItemTypeReserveMissingPivotItemTypeRepresents how to reserve missing pivot items.

Methods

MethodDescription
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;

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;

setRefreshData(boolean)

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

setRefreshData(value: boolean) : void;

Parameters:

ParameterTypeDescription
valuebooleanThe value to set.

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:

ParameterTypeDescription
valuebooleanThe 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:

ParameterTypeDescription
valueReserveMissingPivotItemTypeThe value to set.

Remarks

Only works when RefreshData is true.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;