In [i]GeoGebra’s [/i][img]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img][i]Spreadsheet View[/i] every cell has a specific name that allows you to directly address each cell.[br][b]Example:[/b] The cell in column [i]A[/i] and row [i]1[/i] is named A1.[br][br]You can use the [i]Spreadsheet [/i]cells to create mathematical objects that are directly displayed in the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i] (e.g. points).
Enter data into the cells of the Spreadsheet.
[table][tr][td][size=100]1.[/size][/td][td][size=100][b]A1[/b][/size][br][/td][td][size=100]Enter the number [code]10 [/code]into cell [b]A1[/b].[br][b]Hint:[/b] Always confirm your input by pressing the [i]Enter[/i] key.[/size][/td][/tr][tr][td][size=100]2.[/size][/td][td][size=100][b]B1[/b][/size][br][/td][td][size=100]Enter the coordinates [code](-2, 2) [/code]into cell [b]B1[/b].[br][b]Note:[/b] The point [i]B1 = (-2, 2)[/i] is automatically shown in the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i].[/size][/td][/tr][tr][td][size=100]3.[br][/size][/td][td][size=100][icon]https://www.geogebra.org/images/ggb/toolbar/mode_move.png[/icon][br][/size][/td][td][size=100]Select the [i]Move[/i] tool and drag point [i]B1[/i] in the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i]. [br][b]Note:[/b] The [img]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] [i]Spreadsheet View [/i]shows the current position of point [i]B1 [/i]in cell [b]B1[/b].[br][/size][/td][/tr][tr][td][size=100]4.[br][/size][/td][td][size=100][icon]https://www.geogebra.org/images/ggb/toolbar/mode_delete.png[/icon][br][/size][/td][td][size=100]Delete the content of cell[b] B1[/b].[br][/size][/td][/tr][/table]
You can refer to another cell by using its name in your new input.[br][b]Note: [/b]If the content of this cell is modified, the new input adapts automatically.
Enter data by referring to other cells of the Spreadsheet.
[table][tr][td][size=100]1.[/size][/td][td][size=100][b]A1[/b][/size][/td][td][size=100]Change the number in cell [b]A1[/b] to [code]1.5[/code] and confirm your input.[/size][/td][/tr][tr][td][size=100]2.[/size][/td][td][size=100][b]B1[/b][/size][/td][td][size=100]Enter the formula [code]= 2 * [/code]into cell [b]B1[/b] and then select cell [b]A1[/b] to insert its name into the formula. Confirm your input.[br][b]Note:[/b] [i]GeoGebra [/i]calculates [i]2 * 1.5[/i] and displays the solution [i]3[/i] in cell [b]B1[/b].[br][/size][/td][/tr][tr][td][size=100]3.[br][/size][/td][td][b][size=100][/size][/b][size=100][b]A1[/b][br][/size][/td][td][size=100]Change the content of cell [b]A1[/b] to 3.[br][b]Note:[/b] The content of cell [b]B1[/b] automatically adapts to your changes.[/size][/td][/tr][/table][size=100][table][tr][td]4.[/td][td][b]C1[/b][/td][td]Enter the coordinates [code](A1, B1) [/code]into cell [b]C1[/b] and confirm your input.[br][b]Hint:[/b] Cell [b]C1[/b][i] [/i]now shows the coordinates [i](3, 6)[/i]. The corresponding Point [i]C1[/i] is automatically displayed in the [img]https://wiki.geogebra.org/uploads/thumb/c/c8/Menu_view_graphics.svg/16px-Menu_view_graphics.svg.png[/img] [i]Graphics View[/i].[/td][/tr][tr][td]5.[/td][td][b]A1[/b][/td][td]Change the value of cell [b]A1[/b] to [code]2[/code].[br][b]Note:[/b] The coordinates in cell [b]C1[/b] and the corresponding point automatically adapt to your changes.[br][/td][/tr][/table][/size]
[br][size=100][size=150]Manual Entry, Commands, and Tracing[/size][/size][br]Besides manually adding entries into the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] [i]Spreadsheet View[/i] cells, you may use the commands [i]FillColumn[/i],[i] FillRow [/i]or[i] FillCells.[/i] You can also enter data by using the feature [i]Tracing to Spreadsheet. [br][/i][size=150][br]Copy Data from the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/4/40/Menu_view_algebra.svg/16px-Menu_view_algebra.svg.png[/img] Algebra View[/size][i][br][/i]With a simple drag and drop operation it is also possible to copy objects from the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/4/40/Menu_view_algebra.svg/16px-Menu_view_algebra.svg.png[/img] Algebra View to the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] Spreadsheet View.[br] 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).[i][br][br][/i][size=150]Copy Data from Other Spreadsheet Software[/size][i][br][/i]GeoGebra allows you to import data from other spreadsheet software into the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] Spreadsheet View.[br][br][list][*]Select and copy the data you want to import. For example, you may use the keyboard shortcut Ctrl + C (Mac OS: Cmd + C) in order to copy the data to your computer’s clipboard.[/*][*]Open a GeoGebra window and show the [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] Spreadsheet View.[/*][*]Click on the spreadsheet cell that should contain the first data value (e.g. cell A1)[/*][*]Paste the data from your computer’s clipboard into GeoGebra’s [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] Spreadsheet View. For example, you may select a cell and use the keyboard shortcut Ctrl + V (Mac OS: Cmd + V) in order to paste the data into the highlighted spreadsheet cell.[/*][/list][size=150]Import Data Files from other Applications[/size][i][br][/i]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 [img width=16,height=16]https://wiki.geogebra.org/uploads/thumb/7/73/Menu_view_spreadsheet.svg/16px-Menu_view_spreadsheet.svg.png[/img] Spreadsheet View, then choose the Import Data File... option.[i][br][/i]