Pivot Grid Cell

An object containing information about the pivot grid cell.

columnPath

Contains the path to the data cell by columns. The full path also includes a rowPath.

Type: Array

Note that this field has a value only if the cell belongs to the data area.

columnType

Contains the type of the column to which the data cell belongs.

Type: String
Accepted Values: 'D' | 'T' | 'GT'

The columnType field has the following values.

Note that this field has a value only if the cell belongs to the data area.

dataIndex

Contains the index of the data field.

Type: Number

Note that this field has a value only if the cell belongs to the data area.

expanded

Contains the boolean value indicating whether or not the cell is in an expanded state.

Type: Boolean

path

Contains the path to the row/column cell.

Type: Array

Note that this field has a value only if the cell belongs to the row or column area.

rowPath

Contains the path to the data cell by rows. The full path also includes a columnPath.

Type: Array

Note that this field has a value only if the cell belongs to the data area.

rowType

Contains the type of the row to which the data cell belongs.

Type: String
Accepted Values: 'D' | 'T' | 'GT'

The rowType field has the following values.

Note that this field has a value only if the cell belongs to the data area.

text

Contains the text displayed in a cell.

Type: String

type

Contains the type of the cell located in a header.

Type: String
Accepted Values: 'D' | 'T' | 'GT'

The type field has the following values.

Note that this field has a value only if the cell belongs to the row or column area.

value

Contains the cell value.