Difference between revisions of "CellRange Command"

From GeoGebra Manual
Jump to: navigation, search
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|1 = You may also use shorter syntax <code>A1:A3</code>.}}
+
{{Note|You may also use shorter syntax <code>A1:A3</code>.}}

Revision as of 16:27, 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 command CellRange[A1, A3] then gives you the list {1, 4, 9}.
Note: You may also use shorter syntax A1:A3.
© 2022 International GeoGebra Institute