SpreadSheet does not show

xtzetzias shared this problem 2 years ago
Solved

Hi

I'm not sure whether it's a bug or something i did wrong. I sterted making a construction in GeoGebra, which included the use of spreadsheet, and everything worked fine. I saved it and when i tried to open it later, it wouldn't open properly. It was slow, not corresponding well and mainly, the spreadsheet does not show when i selected it.

I tried to make a new constuction and the results were the same. Then I changed from linux geogebra 5 to windows geogebra 5, with no improvement. Afterwords, I tried the online version. It was very slow and when tried to export it as .ggb, the new file had the same problem.

When I tried to save it in my works, and then tried to open the worksheet, it stucked (https://ggbm.at/RMR8SSfW)

Is there any obvious explanation I cannot see?

Comments (16)

photo
1

The filename is extremely long. Anyway, despite I've changed it on saving, the file doesn't open.

I'm addressing your issue to the developers.

photo
1

Thank you. Here is a copy with a different name, if it makes any difference.

Files: test.ggb
photo
1

the values and labels saved for the first elements are very strange. I think the saved file is corrupted/+ZAAAAAElFTkSuQmCCAA==

is the original lang english?

photo
1

No, it's greek. Do you think that changing language would be better?

photo
1

I'm quite sure that there were issues with Cyrillic (russian). Not so sure about Greek. That's why I've changed the filename on download. But as far as I know the issues were only related to that charset in the filename

photo
1

It's not to do with the Greek, that's saved correctly:

 <ggbscript val="SetValue[ΕνεργόΧρώμα,"Μπλε"]
"/>
You seem to have some objects defined in terms of themselves which isn't allowed eg
<expression label="D14" exp="D14:B14" />
ie
D14 = D14:B14
What are you trying to do exactly?

photo
1

I made an english version, but the problem remained. However, when i made i different definition for the objects in column D, everything was ok.

What i was trying to do, was to make a copy column B into column D, so i entered "=B1" in D1 and draged down to D20. That's th only connection between B and D column. Was it a wrong command ?

Thank you anyway...

photo
1

Ok. However, where does this "D1: B1" come from? I would expect it to b just "B1" when inserting "=B1" in the cell.

photo
1

Sorry, it's a bug with "D1=B1" when the file is saved. Can you avoid that step for your file until we fix it?

photo
1

bug fixed in the new version (v455)

photo
1

Thanks!

photo
photo
1

Yes, of course. I've already avoid it and gone further. But I think I run into some more problem, concerning "E1==F1" (that is, double "="). In the attached file, try to "paint" the fourth circle (by clicking it). You will see that G4 looses its definition, which is "E1==F1". I cannot find the reason why, and since there has already been a bug, probably it;s the same case here.

Files: test.ggb
photo
1

Make sure you use English color names for the SetColor() command and repost your file

photo
1

Sorry, I didn't think to do that earlier... Now colours are in english everywhere. The strange behaviour (if it's not something else) still remains.

Files: test.ggb
photo
1

Ah, I see. That behaviour is expected as FillCells() deletes what's already in the cells. Why are you using FillCells() to change just one cell?

photo
1

Ah, ok then! That was something i didn't know, otherwise I would have used SetValue. I guess i run into FillCells() and thought it would be ok to use it (a chance to explore GeoGebra a bit). The problem did not come up early, so I stucked with this command. Know everything is ok! Thanks!

photo
© 2020 International GeoGebra Institute