AX2367
GetRowNumber function
Returns the row number of the current cell, of the cell that was active when the file was refreshed, or for a specific cell reference.
The intent of GetColumnLetter is to help support custom drilling in Axiom files using double-click.
Syntax
GetRowNumber("Cell")
The parameter Cell takes the following values:
- <Blank>: Leave the Cell parameter blank (open parentheses) to return the row number for the current cell (the cell that contains the GetRowNumber function).
Active
: Use this keyword to return the row number for the cell that was active when the last recalculation occurred.- CellReference: Enter a cell reference to return the row number for that cell.
All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.
Remarks
- Drilling initiates a recalculation, so
Active
can be used to identify the row where the user double-clicked to perform the drill. - GetRowNumber is a volatile function.
Examples
=GetRowNumber()
This example returns the row number for the cell that contains the GetRowNumber function (for example: "1").
=GetRowNumber("Active")
This example returns the row number for the active cell when the file was refreshed (for example: "20").
=GetRowNumber("AD25")
This example returns the row number for the specified cell reference ("25" in this case).