Difference between revisions of "FillCells Command"

From GeoGebra Manual
Jump to: navigation, search
m
Line 1: Line 1:
<noinclude>{{Manual Page|version=5.0}}</noinclude>
+
<noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|spreadsheet}}
{{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=

Revision as of 14:11, 27 August 2015


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. 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