Kopiering af data fra Excel til Geogebra

john andreasen shared this problem 1 month ago
Not a Problem

Det plejer at kunne lade sig gøre at kopiere decimaltal fra Excel til GeoGebra, selvom Excel's tal bruger komma som decimalseparator.

I version 5.0.504.0-d indsættes sådanne decimaltal i to kolonner - med heltallet i en kolonne samt decimalbrøken som et heltal i den næste kolonne !?!

Det er ikke set før. Kan det rettes?

Venligst, John Andreasen

Comments (9)

photo
1

This video illustrates the problem:

photo
1

Can you configure Excel to use "." for the decimal separator?

photo
1

Yes I can - and then there is no problem. But I wonder why the problem exists.

It will be a problem for my students working with computers where the administrator does not allow to change the settings

... and it should not be nessessary to make that change.

photo
1

Pasting these works for me (either with quotes or <Tab> separated). What is Excel putting on the clipboard for you?

"1,2"	"3,4"
"5,2"	"7,4"

5,3	5,4
1,2	3,4

"1,2","3,4"
"5,2","7,4"

photo
1

There is no problem when you copy and paste more then one column. The problem is only existing when you work with just one column of decimal numbers. When you insert in GeoGebra, two columns appear - one with the digits before the comma and one with the digits after the comma.

This is not very good if it is a long list of numbers that should be treated statistically. :-(

photo
1

The problem is that

1,2
3,4
5,6
is more likely to be two columns pasted from Excel with the decimal separator set to "." and there's no way to tell without the <Tab> separator

photo
1

If you look at the video that I attached, you will see that one of the numbers is an integer - it should cause GeoGebra to fail to interpret data as comma-separated, I think.

photo
1

... and one more thing to be said: the problem is rather new - for a long time GeoGebra interpreted a column with comma-separated numbers correctly - except if there were exactly 3 decimals after the comma - and that was not really a problem, because it is easy to show a number with one extra decimal in Excel :-)

photo
1

Here is a little clip from a video, I have made a while ago - copying with comma-separated numbers works fine in this version of GeoGebra - and now it does not!

Now with video-clip ;)

photo
© 2018 International GeoGebra Institute