Difference between revisions of "Spreadsheet View"
Line 6: | Line 6: | ||
In the spreadsheet cells you can enter not only numbers, but all types of [[General Objects|General]] and [[Geometrical Objects]] that are supported by GeoGebra (e. g., coordinates of points, [[functions]], [[commands]]). If possible, GeoGebra immediately displays the graphical representation of the object you entered in a spreadsheet cell in the [[Graphics View]] as well. Thereby, the name of the object matches the name of the spreadsheet cell used to initially create it (e. g., A5, C1). | In the spreadsheet cells you can enter not only numbers, but all types of [[General Objects|General]] and [[Geometrical Objects]] that are supported by GeoGebra (e. g., coordinates of points, [[functions]], [[commands]]). If possible, GeoGebra immediately displays the graphical representation of the object you entered in a spreadsheet cell in the [[Graphics View]] as well. Thereby, the name of the object matches the name of the spreadsheet cell used to initially create it (e. g., A5, C1). | ||
− | {{note|By default, spreadsheet objects are classified as [[Free, Dependent and Auxiliary Objects#Auxiliary Objects|auxiliary objects]] in the [[Algebra View]]. You can show or hide these auxiliary objects by selecting "Auxiliary Objects" from the context menu (right-click) or by clicking on the appropriate icon in the Algebra View's Style Bar}} | + | {{note|By default, spreadsheet objects are classified as [[Free, Dependent and Auxiliary Objects#Auxiliary Objects|auxiliary objects]] in the [[Algebra View]]. You can show or hide these auxiliary objects by selecting "Auxiliary Objects" from the context menu (right-click) or by clicking on the appropriate icon in the [[Algebra View#Style Bar|Algebra View's Style Bar]]}} |
==Relative cell names== | ==Relative cell names== |
Revision as of 13:13, 25 January 2013
In GeoGebra’s Spreadsheet View every cell has a specific name that allows you to directly address each cell. For example, the cell in column A and row 1 is named A1.
In the spreadsheet cells you can enter not only numbers, but all types of General and Geometrical Objects that are supported by GeoGebra (e. g., coordinates of points, functions, commands). If possible, GeoGebra immediately displays the graphical representation of the object you entered in a spreadsheet cell in the Graphics View as well. Thereby, the name of the object matches the name of the spreadsheet cell used to initially create it (e. g., A5, C1).
Relative cell names
By default, if you copy content from one cell to another, all references are changed accordingly to the target position.
To prevent this behaviour, you can insert $ before the column and/or row of the referenced cell.
Getting data into the spreadsheet
Besides manually adding entries to the spreadsheet, you may use FillCoumn, FillRow or FillCells. Also see section tracing to spreadsheet.
Using spreadsheet data in other views
You may process the spreadsheet data by selecting multiple cells, right-clicking and choosing an item from the "Create" submenu of appearing Context Menu.