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 )
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=<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.}}
+
:{{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>}}
:{{Note|1=<code>A1:A3</code> is a shorter syntax.}}
+
{{Note|1=<code>A1:A3</code> is a shorter syntax.}}

Revision as of 10:23, 16 July 2013



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