aspose.cells

Classes

Constants

Class PivotTableCalculateOption

Rerepsents the options of calcuating the pivot table.

Constructor Summary
`PivotTableCalculateOption()`

Property Getters/Setters Summary
`function`	`getRefreshCharts()`
`function`	`setRefreshCharts(value)`
	Indicates whether refreshing charts are based on this pivot table.
`function`	`getRefreshData()`
`function`	`setRefreshData(value)`
	Indicates whether refreshing data source of the pivottable.
`function`	`getRefreshOption()`
`function`	`setRefreshOption(value)`

`function`	`getReserveMissingPivotItemType()`
`function`	`setReserveMissingPivotItemType(value)`
	Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant.

- Constructor Detail
  - PivotTableCalculateOption
```
function PivotTableCalculateOption()
```
- Property Getters/Setters Detail
  - getRefreshData/setRefreshData : boolean
```
function getRefreshData() / function setRefreshData(value)
```
    Indicates whether refreshing data source of the pivottable.
  - getRefreshCharts/setRefreshCharts : boolean
```
function getRefreshCharts() / function setRefreshCharts(value)
```
    Indicates whether refreshing charts are based on this pivot table.
  - getReserveMissingPivotItemType/setReserveMissingPivotItemType : Number
```
function getReserveMissingPivotItemType() / function setReserveMissingPivotItemType(value)
```
    Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant.
    Only works when RefreshData is true.
  - getRefreshOption/setRefreshOption : PivotTableRefreshOption
```
function getRefreshOption() / function setRefreshOption(value)
```