Difference between revisions of "CellRange Command"

From GeoGebra Manual
Jump to: navigation, search
m (added link to spreadsheet view)
Line 2: Line 2:
 
{{command|spreadsheet}}
 
{{command|spreadsheet}}
 
;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=<div>Let <code>A1 = 1</code>, <code>A2 = 4</code>, <code>A3 = 9</code> be spreadsheet cells values.</div><div>Then <code>CellRange[A1, A3]</code> returns the list {1, 4, 9}.</div>}}
+
:{{Example|1=<div>Let <code>A1 = 1</code>, <code>A2 = 4</code>, <code>A3 = 9</code> be [[spreadsheet View|spreadsheet]] cells values.Then <code>CellRange[A1, A3]</code> returns the list {1, 4, 9}.</div>}}
 
{{Note|1=<code>A1:A3</code> is a shorter syntax.}}
 
{{Note|1=<code>A1:A3</code> is a shorter syntax.}}

Revision as of 12:20, 20 December 2014



CellRange[ <Start Cell>, <End Cell> ]
Creates a list containing the cell values in this cell range.
Example:
Let A1 = 1, A2 = 4, A3 = 9 be spreadsheet cells values.Then CellRange[A1, A3] returns the list {1, 4, 9}.
Note: A1:A3 is a shorter syntax.
© 2024 International GeoGebra Institute