Skip to main content

CELL

Grabs the output from another cell in the window.


FORMAT: CELL reference


DEFINITIONS:

  • reference: ( column number or column title , row number ) or quoted text representing a cell or column title

EXAMPLES:

show cell (2,1)
Returns the output from the cell in column 2, row 1

show cell "my cell title"
Returns the output from the cell which has a title "my cell title"

show cell "my column title"
Returns the cell which has a column title of "my column title" on this cell's row

show cell ( "Column 1" , 3 )
Returns the cell which has a column title of "Column 1" on row 3

show cell ( $column-1, $row+2 )
Returns the contents of the cell 1 row left and 2 rows down

show cell ( "Column 2" , $row-2 )
Returns the contents of the cell which has a column title of "Column 2" and 2 rows up from this cell

Available for spreadsheet windows version 9 and later.