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.

Note: These cell names can be used in expressions and commands in order to address the content of the corresponding cell.

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).

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 (right-click) or by clicking on the appropriate icon in the Algebra View's Style Bar

Relative cell names

By default, if you copy content from one cell to another, all references are changed accordingly to the target position.

Example: Let A1=1,A2=2. In B1 put (A1,A1). By copying B1 to B2 (either via Ctrl + C, Ctrl + V or by dragging the cell corner) you get (A2,A2) in B2.

To prevent this behaviour, you can insert $ before the column and/or row of the referenced cell.

Note: On Mac the copy & paste shortcuts are Cmd + C and Cmd + V

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.

It is also possible to drag a list from the Algebra View and drop it into the Spreadsheet View: the list elements will be inserted horizontally, starting from the cell in which you release the left mouse button. If you press the Shift key while dragging, when you drop the list a dialog window opens, allowing to choose whether the pasted objects will be free or dependent, as well as choosing a vertical placement of the copied objects (option Transpose).

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.

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.

Example: Let A1 = x y, A2 = 1, A3 = 2, A4 = 3, B1 = 1, C1 = 2 and D1 = 3. Select cells A1:D4, then right click on them and select Create > Operation Table in the context menu to create a table containing the results of substitution of the inserted values in the given function.