Spreadsheet View

The Spreadsheet View can be customized according to your preferences by

In the appearing dialog window you may change the layout by choosing whether to

In addition, you may change the behavior of the Spreadsheet View by

In the Spreadsheet Cells you can enter not only numbers, but all types of General Objects and Geometric Objects that are supported by GeoGebra (e.g. coordinates of points, Functions, Commands).

To select non adjacent columns or cells in the spreadsheet, use the shortcut Ctrl + Click.

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

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

Besides manually adding entries into the Spreadsheet View cells, you may use the commands FillColumn, FillRow or FillCells. You can also enter data by using the feature 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 or touchscreen. 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 (check option Transpose).

GeoGebra allows you to import data from other spreadsheet software into the Spreadsheet View.

.

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 View, then choose the Import Data File…​ option.

The Spreadsheet View Toolbar provides a range of Tools that allow you to create objects in the Spreadsheet View. Every icon in the Toolbar represents a Toolbox that contains a selection of related Tools. In order to open a Toolbox, you need to click on the corresponding default Tool shown in the Spreadsheet View Toolbar (GeoGebra Web and Tablet Apps) or on the small arrow in the lower right corner of the Toolbar icon (GeoGebra Desktop).

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

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

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.

The Spreadsheed View Style Bar provides buttons to