ColumnNumber/RowNumber
ColumnNumber
or RowNumber
are functions that return the column number or row number in a grid.
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
andColumnNumber
functions are not allowed in text boxes. -
The
RowNumber
function cannot be used in column heading cells, and theColumnNumber
function cannot be used in row heading cells. -
The
RowNumber
andColumnNumber
functions cannot be used in the corner cells (upper left corner of the grid).