Difference between revisions of "CellRange Command"
From GeoGebra Manual
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. | + | :{{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.ThenCellRange[A1, A3]
returns the list {1, 4, 9}.
Note:
A1:A3
is a shorter syntax.