PivotTableCalculateOption
Contents
[
Hide
]PivotTableCalculateOption class
Rerepsents the options of calcuating the pivot table.
class PivotTableCalculateOption;
Constructors
Name | Description |
---|---|
constructor() | Default Constructor. |
Methods
Method | Description |
---|---|
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:
Parameter | Type | Description |
---|---|---|
value | boolean | The 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:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
getReserveMissingPivotItemType()
Represents how to reserve missing pivot items.
getReserveMissingPivotItemType() : ReserveMissingPivotItemType;
Returns
Remarks
Only works when RefreshData is true.
setReserveMissingPivotItemType(ReserveMissingPivotItemType)
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;