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. |
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.