ColumnNumber/RowNumber

ColumnNumber or RowNumber are functions that return the column number or row number in a grid.

Syntax:

ColumnNumber(SkipEmpty)

Note:

See Parameters for Text Functions for parameter definitions.

Example:

Returns the column number for data and formula columns, but not for text or separator columns. 

ColumnNumber(true)

Returns the row number for all rows (data, formula, text and/or separator).

RowNumber()

Validation Errors

A validation error will occur if the following situations occur in the report:

  • The RowNumber and ColumnNumber functions are not allowed in text boxes.

  • The RowNumber function cannot be used in column heading cells, and the ColumnNumber function cannot be used in row heading cells.

  • The RowNumber and ColumnNumber functions cannot be used in the corner cells (upper left corner of the grid).