Difference between revisions of "CellRange Command"

From GeoGebra Manual
Jump to: navigation, search
m (Text replace - "<div class="box info"> 48px|left This page is part of the official manual for print and pdf. For structural reasons normal users can't edit this page. If you found any errors on this page please contact )
(command syntax: changed [ ] into ( ))
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<noinclude>{{Manual Page|version=4.2}}</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=<code>CellRange[A1, A3]</code> returns the list {1, 4, 9} being  <code>A1 = 1, A2 = 4, A3 = 9</code> the corresponding spreadsheet cells values.}}
+
{{Note|1=<code>A1:A3</code> is a shorter syntax.}}
:{{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