Spreadsheet Commands

CellRange

CellRange[Start Cell, End Cell]: Creates a list containing the cell values in this cell range.           
Example: Enter the following values into the corresponding spreadsheet cells:
A1 = 1, A2 = 4, A3 = 9. The command CellRange[A1, A3] then gives you the list {1, 4, 9}.

Column

Column[Spreadsheet Cell]: Returns the column of the cell as a number (starting at 1).
Example: Column[B3] gives you number a = 2 since column B is the second column of the spreadsheet.

ColumnName

ColumnName[Spreadsheet Cell]: Returns the column name of the cell as a text.
Example: ColumnName[A1] gives you a text “A” in the Graphics View.

Row

Row[Spreadsheet Cell]: Returns the row number of a spreadsheet cell (starting at 1).
Example: Row[B3] gives you number a = 3.


www.geogebra.org