Difference between revisions of "FillCells Command"

From GeoGebra Manual
Jump to: navigation, search
m
(command syntax: changed [ ] into ( ))
Line 1: Line 1:
 
<noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|spreadsheet}}
 
<noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|spreadsheet}}
;FillCells[ <CellRange>, <Object> ]:Copies the value/equation etc. of the object to the given cellrange. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of object.  
+
;FillCells( <CellRange>, <Object> ):Copies the value/equation etc. of the object to the given cellrange. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of object.  
 
:{{Notes|1=
 
:{{Notes|1=
 
:*''CellRange'' has to be entered like this: e.g.: ''B2:D5''.
 
:*''CellRange'' has to be entered like this: e.g.: ''B2:D5''.
:*''Object'' can be anything, e.g.: ''3'', ''RandomBetween[0, 10]'', ''Circle[A, B]''.
+
:*''Object'' can be anything, e.g.: ''3'', ''RandomBetween(0, 10)'', ''Circle(A, B)''.
 
:*Cells are labelled by column and row, e.g.: ''B2''.}}
 
:*Cells are labelled by column and row, e.g.: ''B2''.}}
  
;FillCells[ <Cell>, <List> ]:Copies values from the list to the first cells on the right of the given cell. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of the list.  
+
;FillCells( <Cell>, <List> ):Copies values from the list to the first cells on the right of the given cell. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of the list.  
  
;FillCells[ <Cell>, <Matrix> ]:Copies values from the matrix into the spreadsheet. The upper left corner of the matrix is matched to the given cell. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of the matrix.  
+
;FillCells( <Cell>, <Matrix> ):Copies values from the matrix into the spreadsheet. The upper left corner of the matrix is matched to the given cell. Resulting cells are [[Free, Dependent and Auxiliary Objects|free objects]], i.e. independent of the matrix.  
 
{{Note|1=See also [[FillRow  Command|FillRow]] and [[FillColumn Command|FillColumn]]  commands.}}
 
{{Note|1=See also [[FillRow  Command|FillRow]] and [[FillColumn Command|FillColumn]]  commands.}}

Revision as of 15:09, 4 October 2017


FillCells( <CellRange>, <Object> )
Copies the value/equation etc. of the object to the given cellrange. Resulting cells are free objects, i.e. independent of object.
Notes:
  • CellRange has to be entered like this: e.g.: B2:D5.
  • Object can be anything, e.g.: 3, RandomBetween(0, 10), Circle(A, B).
  • Cells are labelled by column and row, e.g.: B2.
FillCells( <Cell>, <List> )
Copies values from the list to the first cells on the right of the given cell. Resulting cells are free objects, i.e. independent of the list.
FillCells( <Cell>, <Matrix> )
Copies values from the matrix into the spreadsheet. The upper left corner of the matrix is matched to the given cell. Resulting cells are free objects, i.e. independent of the matrix.
Note: See also FillRow and FillColumn commands.
© 2024 International GeoGebra Institute