PivotTableCalculateOption
Contents
[
Hide
]PivotTableCalculateOption class
Rerepsents the options of calcuating 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;
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.