Difference between revisions of "CellRange Command"

Revision as of 18:56, 21 November 2012

CellRange[ <Start Cell>, <End Cell> ]: Creates a list containing the cell values in this cell range.; Example: CellRange[A1, A3] returns the list {1, 4, 9} being A1 = 1, A2 = 4, A3 = 9 the corresponding spreadsheet cells values.

Note: A1:A3 is a shorter syntax.

@@ Line 1: / Line 1: @@
 <noinclude>{{Manual Page|version=4.0}}[[Category:Manual (official)|{{PAGENAME}}]]</noinclude>
 {{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=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}.}}
+:{{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 = You may also use shorter syntax <code>A1:A3</code>.}}
+:{{Note|1=<code>A1:A3</code> is a shorter syntax.}}