Difference between revisions of "FillCells Command"
From GeoGebra Manual
(command syntax: changed [ ] into ( )) |
m (Text replace - ";(.*)\[(.*)\]" to ";$1($2)") |
||
Line 1: | Line 1: | ||
<noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|spreadsheet}} | <noinclude>{{Manual Page|version=5.0}}</noinclude>{{command|spreadsheet}} | ||
− | ;FillCells( <CellRange>, <Object> ):Copies the value/equation etc. of the object to the given cellrange. Resulting cells are | + | ;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''. | ||
Line 6: | Line 6: | ||
:*Cells are labelled by column and row, e.g.: ''B2''.}} | :*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 | + | ;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 into the spreadsheet. The upper left corner of the matrix is matched to the given cell. Resulting cells are | + | ;FillCells( <Cell>, <Matrix> ):Copies values from the matrix into the spreadsheet. 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=See also [[FillRow Command|FillRow]] and [[FillColumn Command|FillColumn]] commands.}} | {{Note|1=See also [[FillRow Command|FillRow]] and [[FillColumn Command|FillColumn]] commands.}} |
Revision as of 17:15, 7 October 2017
- 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:
- 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, Dependent and Auxiliary Objects|free objects)], i.e. independent of the list.
- FillCells( <Cell>, <Matrix> )
- Copies values from the matrix into the spreadsheet. 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: See also FillRow and FillColumn commands.