Difference between revisions of "CellRange Command"

Latest revision as of 16: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.

@@ Line 1: / Line 1: @@
-<noinclude>{{Manual Page}}[[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: Enter the following values into the corresponding spreadsheet cells: <tt>A1 = 1, A2 = 4, A3 = 9</tt>. The command <tt>CellRange[A1, A3]</tt> then gives you the list {1, 4, 9}.
+{{Note|1=<code>A1:A3</code> is a shorter syntax.}}