## PivotTableCalculateOption class

Rerepsents the options of calculating data of the pivot table.

```javascript
class PivotTableCalculateOption;
```


## Constructors

| Constructor | Description |
| --- | --- |
| [constructor()](#constructor--)| Default Constructor. |

## Properties

| Property | Type | Description |
| --- | --- | --- |
| [refreshData](#refreshData--)| boolean | Indicates whether refreshing data source of the pivottable. |
| [refreshCharts](#refreshCharts--)| boolean | Indicates whether refreshing charts are based on this pivot table. |
| [reserveMissingPivotItemType](#reserveMissingPivotItemType--)| ReserveMissingPivotItemType | Represents how to reserve missing pivot items. |
| [refreshOption](#refreshOption--)| PivotTableRefreshOption | Gets and set options for refreshing data source to pivot cache. |

## Methods

| Method | Description |
| --- | --- |
| [getRefreshData()](#getRefreshData--)| <b>@deprecated.</b> Please use the 'refreshData' property instead. Indicates whether refreshing data source of the pivottable. |
| [setRefreshData(boolean)](#setRefreshData-boolean-)| <b>@deprecated.</b> Please use the 'refreshData' property instead. Indicates whether refreshing data source of the pivottable. |
| [getRefreshCharts()](#getRefreshCharts--)| <b>@deprecated.</b> Please use the 'refreshCharts' property instead. Indicates whether refreshing charts are based on this pivot table. |
| [setRefreshCharts(boolean)](#setRefreshCharts-boolean-)| <b>@deprecated.</b> Please use the 'refreshCharts' property instead. Indicates whether refreshing charts are based on this pivot table. |
| [getReserveMissingPivotItemType()](#getReserveMissingPivotItemType--)| <b>@deprecated.</b> Please use the 'reserveMissingPivotItemType' property instead. Represents how to reserve missing pivot items. |
| [setReserveMissingPivotItemType(ReserveMissingPivotItemType)](#setReserveMissingPivotItemType-reservemissingpivotitemtype-)| <b>@deprecated.</b> Please use the 'reserveMissingPivotItemType' property instead. Represents how to reserve missing pivot items. |
| [getRefreshOption()](#getRefreshOption--)| <b>@deprecated.</b> Please use the 'refreshOption' property instead. Gets and set options for refreshing data source to pivot cache. |
| [setRefreshOption(PivotTableRefreshOption)](#setRefreshOption-pivottablerefreshoption-)| <b>@deprecated.</b> Please use the 'refreshOption' property instead. Gets and set options for refreshing data source to pivot cache. |
| [isNull()](#isNull--)| Checks whether the implementation object is null. |


### constructor() {#constructor--}

Default Constructor.

```javascript
constructor();
```


### refreshData {#refreshData--}

Indicates whether refreshing data source of the pivottable.

```javascript
refreshData : boolean;
```


**Remarks**

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

### refreshCharts {#refreshCharts--}

Indicates whether refreshing charts are based on this pivot table.

```javascript
refreshCharts : boolean;
```


### reserveMissingPivotItemType {#reserveMissingPivotItemType--}

Represents how to reserve missing pivot items.

```javascript
reserveMissingPivotItemType : ReserveMissingPivotItemType;
```


**Remarks**

Only works when [PivotTableCalculateOption.RefreshData](../pivottablecalculateoption.refreshdata/) is true.

### refreshOption {#refreshOption--}

Gets and set options for refreshing data source to pivot cache.

```javascript
refreshOption : PivotTableRefreshOption;
```


### getRefreshData() {#getRefreshData--}

<b>@deprecated.</b> Please use the 'refreshData' property instead. Indicates whether refreshing data source of the pivottable.

```javascript
getRefreshData() : boolean;
```


**Remarks**

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

### setRefreshData(boolean) {#setRefreshData-boolean-}

<b>@deprecated.</b> Please use the 'refreshData' property instead. Indicates whether refreshing data source of the pivottable.

```javascript
setRefreshData(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

**Remarks**

If it is true, refresh pivot cache from data source,then calculate all pivot tables based same pivot cache.

### getRefreshCharts() {#getRefreshCharts--}

<b>@deprecated.</b> Please use the 'refreshCharts' property instead. Indicates whether refreshing charts are based on this pivot table.

```javascript
getRefreshCharts() : boolean;
```


### setRefreshCharts(boolean) {#setRefreshCharts-boolean-}

<b>@deprecated.</b> Please use the 'refreshCharts' property instead. Indicates whether refreshing charts are based on this pivot table.

```javascript
setRefreshCharts(value: boolean) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | boolean | The value to set. |

### getReserveMissingPivotItemType() {#getReserveMissingPivotItemType--}

<b>@deprecated.</b> Please use the 'reserveMissingPivotItemType' property instead. Represents how to reserve missing pivot items.

```javascript
getReserveMissingPivotItemType() : ReserveMissingPivotItemType;
```


**Returns**

[ReserveMissingPivotItemType](../reservemissingpivotitemtype/)

**Remarks**

Only works when [PivotTableCalculateOption.RefreshData](../pivottablecalculateoption.refreshdata/) is true.

### setReserveMissingPivotItemType(ReserveMissingPivotItemType) {#setReserveMissingPivotItemType-reservemissingpivotitemtype-}

<b>@deprecated.</b> Please use the 'reserveMissingPivotItemType' property instead. Represents how to reserve missing pivot items.

```javascript
setReserveMissingPivotItemType(value: ReserveMissingPivotItemType) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | [ReserveMissingPivotItemType](../reservemissingpivotitemtype/) | The value to set. |

**Remarks**

Only works when [PivotTableCalculateOption.RefreshData](../pivottablecalculateoption.refreshdata/) is true.

### getRefreshOption() {#getRefreshOption--}

<b>@deprecated.</b> Please use the 'refreshOption' property instead. Gets and set options for refreshing data source to pivot cache.

```javascript
getRefreshOption() : PivotTableRefreshOption;
```


**Returns**

[PivotTableRefreshOption](../pivottablerefreshoption/)

### setRefreshOption(PivotTableRefreshOption) {#setRefreshOption-pivottablerefreshoption-}

<b>@deprecated.</b> Please use the 'refreshOption' property instead. Gets and set options for refreshing data source to pivot cache.

```javascript
setRefreshOption(value: PivotTableRefreshOption) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| value | [PivotTableRefreshOption](../pivottablerefreshoption/) | The value to set. |

### isNull() {#isNull--}

Checks whether the implementation object is null.

```javascript
isNull() : boolean;
```