Difference between revisions of "CellRange Command"
From GeoGebra Manual
m (added link to spreadsheet view) |
m |
||
| Line 1: | Line 1: | ||
| − | <noinclude>{{Manual Page|version= | + | <noinclude>{{Manual Page|version=5.0}}</noinclude> |
{{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 View|spreadsheet]] cells values.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 15:19, 20 July 2015
- CellRange[ <Start Cell>, <End Cell> ]
- Creates a list containing the cell values in this cell range.
- Example:Let
A1 = 1,A2 = 4,A3 = 9be spreadsheet cells values.ThenCellRange[A1, A3]returns the list {1, 4, 9}.
Note:
A1:A3 is a shorter syntax.
