• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVIDEA function
  • CVINFO function
  • CVMENUST function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

CELLROW Function

The CELLROW function returns the table row number of the current cell as a string into the current cell.

Syntax

CELLROW(<cell number>)

If a cell number is specified, it returns the table row of that cell starting at 1, as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the row number, starting at 1, of the current cell.

It is also possible to use the CELLROW() function in skip and hide conditions on table rows. 

Example 1

Enter CELLROW() in a table cell ABC.D100 returns 100.

Example 2

Enter CELLROW(ABC.D135) returns 135.

This function provides an easy way to include table row information in such a way that it is re-referenced when rows are added or deleted or when a table is re-labeled.

Related Topics

• Miscellaneous Functions