# GC.Spread.Pivot.PivotAreaReference

## Content

# Enumeration: PivotAreaReference

[Spread](../modules/GC.Spread).[Pivot](../modules/GC.Spread.Pivot).PivotAreaReference

Specifies the whether automatically generate the getPivotData formula or cell reference when choose pivot table data area. Default is getPivotData.

## Table of contents

### Enumeration members

- [cellReference](GC.Spread.Pivot.PivotAreaReference#cellreference)
- [getPivotData](GC.Spread.Pivot.PivotAreaReference#getpivotdata)

## Enumeration members

### <a id="cellreference" name="cellreference"></a> cellReference

• **cellReference** = `0`

Generate normal cell reference.

___

### <a id="getpivotdata" name="getpivotdata"></a> getPivotData

• **getPivotData** = `1`

Generate the getPivotData formula.