Cell Data Object

A cellData object contains all the information about the cell.

Properties

NameTypeDescription
columnIndexNumberAn index of the cell’s column.
columnsArray of Hierarchy ObjectsContains the hierarchies from the column associated with the cell.
height NumberDefines a height of the cell.
hierarchy ObjectDefines a hierarchy associated with the cell.
isClassicTotalRowBooleanSpecifies whether the cell contains a subtotal value and is formatted according to the classic form.
isDrillThroughBooleanSpecifies whether the cell belongs to the drill-through view (true) or the grid (false).
isGrandTotalBooleanSpecifies whether the cell contains a grand total value.
isGrandTotalColumnBooleanSpecifies whether the cell contains a grand total value of the column.
isGrandTotalRowBooleanSpecifies whether the cell contains a grand total value of the row.
isTotalBooleanSpecifies whether the cell contains a total value.
isTotalColumnBooleanSpecifies whether the cell contains a total value of the column.
isTotalRowBooleanSpecifies whether the cell contains a total value of the row.
labelStringContains a label of the cell.
levelNumberDefines a level of the hierarchy.
measureObjectDefines a measure associated with the cell.
memberObjectDefines a member associated with the cell.
rowIndexNumberAn index of the cell’s row.
Defines the width of the cell.Array of Hierarchy ObjectsContains the hierarchies from the
row associated with the cell.
typeStringDefines a type of the cell. Possible values:
"header" and "value".
valueNumberContains a value of the cell.
widthNumberDefines the height of the cell.
xNumberDefines an absolute X-positioning of the cell on the page
yNumberDefines an absolute Y-positioning of the cell on the page