PivotTableCalculateOption
Contents
[
Hide
]PivotTableCalculateOption class
Rerepsents the options of calcuating the pivot table.
Constructors
| Name | Description |
|---|---|
| PivotTableCalculateOption |
Properties
| Name | 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 | int | Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant |
| RefreshOption | PivotTableRefreshOption |
PivotTableCalculateOption()
PivotTableCalculateOption.RefreshData property
Indicates whether refreshing data source of the pivottable.
Type: boolean
PivotTableCalculateOption.RefreshCharts property
Indicates whether refreshing charts are based on this pivot table.
Type: boolean
PivotTableCalculateOption.ReserveMissingPivotItemType property
Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant. Only works when RefreshData is true.
Type: int
PivotTableCalculateOption.RefreshOption property
Type: PivotTableRefreshOption