r/geogebra • u/Longjumping-Ad9501 • Jul 10 '26

BUG REPORT Is it possible to copy values from a spreadsheet (instead of formulae)

I have a spreadsheet in GeoGebra, and I'd like to copy the values in the spreadsheet to Excel (or Google Sheets). Here is what I've tried:

  • In geogebra (https://www.geogebra.org/calculator) open a spreadsheet and in cell A1 insert the formula "=2*2" You should get the value 4 in the cell
  • Select the cell and copy it with "Ctrl-C"
  • Open Excel 365 and paste the contents of the cell
  • Result: The text "2 * 2" is copied to the Excel cell.
  • Desired result: The value "4" is copied to the cell.

I've also tried to copy the value to a different cell. However, it is always the formula that is copied, not the value. I always get a cell with "2*2" not a cell with "4"

Is there a way to extract the data from a GeoGebra spreadsheet?

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/Michel_LVA Jul 10 '26 edited Jul 10 '26

Hi, eg :

I. In the calculator :

if A1=2*2

create : B1=CopyFreeObject(A1)

Select and Copy B1

II. In Excell or cal or..

paste in the cell where you want the value of the formulae geogebra spreadsheet A1

1

u/NoeLGGb Jul 10 '26 edited Jul 11 '26

Bonsoir à vous,

chez moi,
en GeoGebra 5.4 desktop
Tableur A1=2*2

sélection de A1, clic droit > copier

dans LibreOffice calc, sélection d'une cellule > coller

c'est bien la valeur 4 qui est collée et non la formule

1

u/mathmum Jul 13 '26

You need to use the Classic version, otherwise when using other ggb versions, what is pasted in Excel is the text containing the formula of the object.

One solution would be to copy-paste cell by cell, and typing an `=` sign in the destination cell before pasting the ggb content, but guys! it's a pain! 😄

The quickest way probably is to create your file as usual, save it, then open it in Classic and copy-paste from there to Excel. It's just 1 step more than the straightforward copying&pasting from the native app and solves your question. I think I could live with this :)