Skip to main content Skip to complementary content

NxPivotDimensionCell

Properties

Name Description Type
qText Some text String
qElemNo

Rank number of the value

If set to -1, it means that the value is not an element number.

Integer
qValue

Value of the cell

Is set to NaN, if the value is not a number.

Double precision floating point
qCanExpand

If set to true, it means that the cell can be expanded.

This parameter is not returned if it is set to false.

Boolean
qCanCollapse

If set to true, it means that the cell can be collapsed.

This parameter is not returned if it is set to false.

Boolean
qType Type of the cell

One of:

  • V for NX_DIM_CELL_VALUE. Applies to values in the data matrix.
  • E for NX_DIM_CELL_EMPTY. Applies to empty cells in the top and left dimensions.
  • N for NX_DIM_CELL_NORMAL. Applies to left and top dimensions cells.
  • T for NX_DIM_CELL_TOTAL. Applies to cells marked with Total
  • P for NX_DIM_CELL_PSEUDO. Applies to pseudo dimensions.
  • R for NX_DIM_CELL_ROOT. Applies to root node.
  • U for NX_DIM_CELL_NULL. Applies to Null values in the data matrix.
qUp

Number of elements that are part of the previous tail.

This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight.

Integer
qDown

Number of elements that are part of the next tail.

This number depends on the paging, more particularly it depends on the values defined in qTop and qHeight.

Integer
qSubNodes

Information about sub nodes (or sub cells)

The array is empty [ ] when there is no sub nodes.

Array of NxPivotDimensionCell

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!