(Web) Spreadsheet - cannot paste further than Row 200

pirsquared shared this problem 5 years ago
New

Hi,


In the web version of Geogebra, there is unusual behaviour when attempting to paste in any row greater than Row 200. It is not possible to paste anywhere beyond Row 200, be it from a data set larger than 200 rows long or simply attempting to paste at Row 201 or below. Sometimes attempts to do so result in the text appearing on top of each other in the Graphics View.


There is no such issue with the desktop version as far as I can tell.


Thanks.

Comments (10)

photo
1

Hi all,

This still remains an issue. It would be interesting to know if this is a restriction that just cannot be avoided (in which case, it may be worth there being some form of 'alert' to inform users some of their data will be missing), or whether this is a bug.

Thanks!

photo
2

I am researching tools to use for our school for dealing with large datasets ready for the new MEI A-level. This is an issue that may be a show-stopper for us and presumably thousands of other institutions. I turned to the web version, partly because that's what our students will primarily have access to and partly because copy and paste wasn't working for me in the Windows App.


I'm using Google Chrome Version 55.0.2883.87 m on Windows. It says it's up-to-date.


An indication of whether this is something that will be actively fixed or not in the near future would be appreciated if possible.


Many thanks.


Marcus Butler

photo
1

How many rows do you need?

photo
1

There are some examples of the large data set available here: http://mei.org.uk/data-sets


The first one (magpies) runs to almost 4,000 rows. Geogebra Desktop handles this perfectly, but I can also confirm that if this is then shared then the web version will again limit this to just 200 rows.


Thanks.

photo
1

Sorry, that's not going to be possible in the short term. The maximum size needed in the official data sets seems to be 350 (OCR-Large-Data-Set-Jan-171.xlsx) so we've increased the maximum to that for the next release

photo
1

Thank you Michael for clarifying the position. That's useful to know for planning.


Hopefully 350 will be enough... It seems a bit of a guessing game as to how big large has to (and will) actually be, but the specimen data-set I'm looking at is only 239 records. The one you reference is 348, and OCR say the one released in June for the first exams will be a 'similar size'. With a sample of two, assuming a normal distribution of sizes, the probability of the set in June 2017 being less than 350 is just over 75%, so I think we'll be unlucky if it goes above 350. We could increase our luck to 95% chance of being OK if you're able to push the limit up to 420? :)


As a backup for one of the specific features we are looking at (using box-plots to compare datasets) I've written a simple javascript based web page (http://www.mrbutler.org.uk/...), so I'm thinking we can plan (and train staff) to use Geogebra, knowing there's a simple fall back as a fill in if we're unlucky enough to get a larger than 350 data set in June :)


Thanks again for addressing this issue.


Yours,


Marcus

photo
photo
1

I discovered today that you can now open a CSV file in the web version, which you weren't able to do before (it may have been implemented ages ago, it's a while since I've tried!). This is very handy, including (as Marcus mentions) for using Geogebra for the large dataset requirements of the new English A-Level Mathematics.


Unfortunately the problem of not going beyond Row 200 also exists when importing a CSV - it simply won't paste or import anything beyond Row 200. This could be a bit of a showstopper for this sort of work - it would be good to know if this is a "can't / won't fix" or is a "difficult to fix but we might be able to"...


Many thanks

photo
1

try A500=0 in input line, then paste

PD: sorry, this works only for desktop version

photo
1

can you try 350x10 for 3500 data?

is it very difficult to work with A1:J350? or does memory crash?

photo
1

Try with one column at a time

  1. A1:A350

© 2021 International GeoGebra Institute