Difference between revisions of "FillCells Command"

From GeoGebra Manual
Jump to: navigation, search
Line 1: Line 1:
 
<noinclude>{{Manual Page|version=4.0}}</noinclude>
 
<noinclude>{{Manual Page|version=4.0}}</noinclude>
 
{{command|spreadsheet}}
 
{{command|spreadsheet}}
;FillCells[<CellRange>, <Object>]
+
;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).
;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 on list L).  
+
{{Note|The parameter ''CellRange'' has to be entered this way: e.g.: ''B2:A5''.}}
;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 on matrix).  
+
{{Note|The parameter ''Object'' can be anything, e.g.: ''3'', ''RandomBetween[0,10]'', ''Circle[A,B]''.}}
 +
 
 +
;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 list L).  
 +
;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 matrix).  
 
{{Note|Cells are labeled by column and row, e.g.: ''B2''.}}
 
{{Note|Cells are labeled by column and row, e.g.: ''B2''.}}

Revision as of 10:18, 10 August 2011



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).
Note: The parameter CellRange has to be entered this way: e.g.: B2:A5.
Note: The parameter Object can be anything, e.g.: 3, RandomBetween[0,10], Circle[A,B].
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 list L).
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 matrix).
Note: Cells are labeled by column and row, e.g.: B2.
© 2021 International GeoGebra Institute