Difference between revisions of "FillCells Command"
From GeoGebra Manual
m (added links to FillRow and FillColumn cmds) |
|||
| 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, 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''}} | ||
| + | |||
;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. 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. 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= | + | {{Note|1=See also [[FillRow Command|FillRow]] and [[FillColumn Command|FillColumn]] commands.}} |
Revision as of 09:45, 18 February 2014
- 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.
