Spreadsheet View
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 FillColumn, FillRow or FillCells. See also section Tracing to spreadsheet.
With a simple drag and drop operation it is also possible to copy objects from the Algebra View to the Spreadsheet View. If you drag a list its elements will be pasted horizontally, starting from the cell in which you release the left mouse button. Pressing the Shift key while dragging opens a dialog window when the mouse button is released, allowing you to choose whether the pasted objects will be free or dependent, as well as to choose the vertical placement of the copied objects (option Transpose).
You can also import data from other applications, if stored using .txt, .csv and .dat formats. Simply right click on a free cell of the Spreadsheet, then choose the Import Data File... option.
Using spreadsheet data in other views
You may process the spreadsheet data by selecting multiple cells, right-clicking and choosing an option from the "Create" submenu of appearing Context Menu. Available options are: 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. When you enter the function and the parameter values, select the rectangular area of desired operation table, right click it and use option Create > Operation Table of the appearing context menu.