Recording to spreadsheet
When the 
Spreadsheet View is enabled, it is possible to trace the changing positions of a point in the 
Graphics View. To do so, right-click on a point in the Graphics View, then select 
Record to Spreadsheet.
This feature allows you to move an object and to record a sequence of its values in the 
Spreadsheet View. This feature works for numbers, points, and vectors.
Note: GeoGebra will use the first two empty columns of the Spreadsheet View to record the values of the selected objects.
Spreadsheet View is enabled, it is possible to trace the changing positions of a point in the Graphics View. To do so, right-click on a point in the Graphics View, then select Record to Spreadsheet.
This feature allows you to move an object and to record a sequence of its values in the Spreadsheet View. This feature works for numbers, points, and vectors.
Note: GeoGebra will use the first two empty columns of the Spreadsheet View to record the values of the selected objects.Task
Record the coordinates of different positions of point A to the Spreadsheet.
Instructions
| 1. |  | Turn on the trace of point A. Right-click (MacOS: Ctrl-click) on point A and select Show Trace from the appearing context menu. |
| 2. |  | Change the value of slider a to examine the trace point A leaves for every slider position. |
| 3. | | Set the value of slider a to -5. |
| 4. |  | Record the coordinates for different positions of point A to the spreadsheet: Right-click (MacOS: Ctrl-click) on point A and select Record to Spreadsheet from the appearing context menu. |
| Now, change the value of slider a to record the coordinates of all other possible positions of point A to the spreadsheet as well. | ||
| | | Note: Do not switch to another tool before moving the slider. |
Try it yourself...
Display of Mathematical objects
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 Auxiliary Objects in the 
Algebra View. You can show or hide these Auxiliary Objects by selecting Auxiliary Objects from the Context Menu or by clicking on the 
icon in the Algebra View Style Bar.
Using Spreadsheet Data in other Views
You may process the Spreadsheet Data by selecting multiple cells and right-clicking (Mac OS: Cmd-clicking) on the selection. In the appearing Context Menu, choose the submenu Create and select the appropriate option (List, List of points, Matrix, Table, Polyline and Operation table).
Operation Table
For a function with two parameters you can create an Operation Table with values of the first parameter written in the top row and values of second parameter written in the left column. The function itself must
be entered in the top left cell.
After entering the function and the parameter values in the appropriate cells, select the rectangular area of the desired Operation Table with the mouse. Then, right click (Mac OS: Cmd-click) on the selection and choose option Create > Operation Table of the appearing Context Menu.
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 Auxiliary Objects in the Algebra View. You can show or hide these Auxiliary Objects by selecting Auxiliary Objects from the Context Menu or by clicking on the icon in the Algebra View Style Bar.
Using Spreadsheet Data in other Views
You may process the Spreadsheet Data by selecting multiple cells and right-clicking (Mac OS: Cmd-clicking) on the selection. In the appearing Context Menu, choose the submenu Create and select the appropriate option (List, List of points, Matrix, Table, Polyline and Operation table).
Operation Table
For a function with two parameters you can create an Operation Table with values of the first parameter written in the top row and values of second parameter written in the left column. The function itself must
be entered in the top left cell.
After entering the function and the parameter values in the appropriate cells, select the rectangular area of the desired Operation Table with the mouse. Then, right click (Mac OS: Cmd-click) on the selection and choose option Create > Operation Table of the appearing Context Menu.