After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 571603 - Large CSV cropped to 65536 rows without warning
Large CSV cropped to 65536 rows without warning
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export Text
1.9.x
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
: 555274 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2009-02-13 10:47 UTC by Stuart Axon
Modified: 2009-02-13 21:49 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Stuart Axon 2009-02-13 10:47:20 UTC
Please describe the problem:
After loading a large CSV (this one was 157,685 rows) it was cropped to 65536 rows, without any warning message.

Steps to reproduce:
1. Generate a large csv from a script
2. Load in gnumeric
3. Scroll to last line


Actual results:
It seems to load ok but is truncated at 65536 rows

Expected results:
Worst case:  Display a dialog explaining only 65536 rows were loaded
Best case:   Just load all the rows, better than excel (maybe warn that other spreadsheets won't be able to load all this data)

Does this happen every time?
Yes

Other information:
Comment 1 Morten Welinder 2009-02-13 14:11:03 UTC
I added a warning.  Note, though, that this warning and the existing one for
too-many-rows only get to stderr when a file is loaded from the command line.
(At that point we don't have a gui to show warnings -- we need to fix that
somehow at some point.)

The more-rows issue is bug 168875.

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
Comment 2 Morten Welinder 2009-02-13 18:04:45 UTC
*** Bug 555274 has been marked as a duplicate of this bug. ***
Comment 3 Andreas J. Guelzow 2009-02-13 21:49:17 UTC
Note that if you use the configurable importer, you can choose which rows to import.

Morten: wouldn't it be better if, instead of showing a warning, we simply keep on importing the rows into additional sheets?