Difference between revisions of "Cell 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 ( ))
 
(5 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}}
+
;Cell( <Column>, <Row> )
;Cell[ <Column>, <Row> ]
 
 
:Returns copy of [[Spreadsheet View|spreadsheet]] cell in given column and row.  
 
:Returns copy of [[Spreadsheet View|spreadsheet]] cell in given column and row.  
{{Example|1=<code>Cell[2,1]</code> returns copy of B1.}}
+
:{{Example|1=<code>Cell(2, 1)</code> returns copy of B1.}}
{{Note|By default the cells in spreadsheet cells are [[Free, Dependent and Auxiliary Objects|auxiliary]] and in such case this command returns auxiliary object as well.}}
+
{{Note|<div>
{{Note|You must make sure that the cells you refer to are '''earlier''' in the [[Construction_Protocol]] than this command}}
+
*By default the cells in spreadsheet cells are [[Free, Dependent and Auxiliary Objects|auxiliary]] and in such case this command returns auxiliary object as well.
 +
*You must make sure that the cells you refer to are '''earlier''' in the [[File:Menu view construction protocol.svg|link=|16px]] [[Construction_Protocol|Construction Protocol]] than this command. </div>}}

Latest revision as of 16:07, 4 October 2017


Cell( <Column>, <Row> )
Returns copy of spreadsheet cell in given column and row.
Example: Cell(2, 1) returns copy of B1.
Note:
  • By default the cells in spreadsheet cells are auxiliary and in such case this command returns auxiliary object as well.
  • You must make sure that the cells you refer to are earlier in the Menu view construction protocol.svg Construction Protocol than this command.
© 2024 International GeoGebra Institute