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).