Difference between revisions of "FillCells Command"
From GeoGebra Manual
Line 2: | Line 2: | ||
{{command|spreadsheet}} | {{command|spreadsheet}} | ||
;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[<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 | + | {{Note|The parameter ''CellRange'' has to be entered like this: e.g.: ''B2:D5''.}} |
{{Note|The parameter ''Object'' can be anything, e.g.: ''3'', ''RandomBetween[0,10]'', ''Circle[A,B]''.}} | {{Note|The parameter ''Object'' can be anything, e.g.: ''3'', ''RandomBetween[0,10]'', ''Circle[A,B]''.}} | ||
Revision as of 10:20, 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 like this: e.g.: B2:D5.
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.