Difference between revisions of "CellRange Command"

From GeoGebra Manual
Jump to: navigation, search
(added v4 - example formatting)
(command syntax: changed [ ] into ( ))
 
(11 intermediate revisions by 5 users not shown)
Line 1: Line 1:
<noinclude>{{Manual Page|version=4.0}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude>
+
<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=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=<code>A1:A3</code> is a shorter syntax.}}

Latest revision as of 15:07, 4 October 2017


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