Difference between revisions of "CellRange Command"
From GeoGebra Manual
Line 3: | Line 3: | ||
; CellRange[Start Cell, End Cell]: Creates a list containing the cell values in this cell range. | ; CellRange[Start Cell, End Cell]: Creates a list containing the cell values in this cell range. | ||
: {{Example| 1=Enter the following values into the corresponding spreadsheet cells: <code>A1 = 1, A2 = 4, A3 = 9</code>. The command <code>CellRange[A1, A3]</code> then gives you the list {1, 4, 9}.}} | : {{Example| 1=Enter the following values into the corresponding spreadsheet cells: <code>A1 = 1, A2 = 4, A3 = 9</code>. The command <code>CellRange[A1, A3]</code> then gives you the list {1, 4, 9}.}} | ||
− | {{Note|You may also use shorter syntax <code>A1:A3</code>.}} | + | {{Note|1 = You may also use shorter syntax <code>A1:A3</code>.}} |
Revision as of 16:26, 29 April 2011
- 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 commandCellRange[A1, A3]
then gives you the list {1, 4, 9}.
Note: You may also use shorter syntax
A1:A3
.