PivotTableCalculateOption
Contents
[
Hide
]PivotTableCalculateOption class
Rerepsents the options of calculating data of the pivot table.
class PivotTableCalculateOption;
Constructors
| Name | 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. |
| refreshOption | PivotTableRefreshOption | Gets and set options for refreshing data source to pivot cache. |
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 PivotTableCalculateOption.RefreshData is true.
refreshOption
Gets and set options for refreshing data source to pivot cache.
refreshOption : PivotTableRefreshOption;