Difference between revisions of "FillCells Command"
From GeoGebra Manual
| 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>]: 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, Dependent and Auxiliary Objects|free objects]] (i.e. independent of object). |
| − | {{ | + | :{{Notes|1=<br>Regarding the parameters:<br> |
| − | + | :*''CellRange'' has to be entered like this: e.g.: ''B2:D5''. | |
| + | :*''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>, <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 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). | + | ;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, Dependent and Auxiliary Objects|free objects]] (i.e. independent of matrix). |
| − | {{Note|Cells are labeled by column and row, e.g.: ''B2''.}} | + | :{{Note|1=<br>Cells are labeled by column and row, e.g.: ''B2''.}} |
Revision as of 22:44, 21 November 2012
- 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:
Regarding the parameters:
- CellRange has to be entered like this: e.g.: B2:D5.
- 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.
