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 555274 - Should at least warn when truncating a file
Should at least warn when truncating a file
Status: RESOLVED DUPLICATE of bug 571603
Product: Gnumeric
Classification: Applications
Component: import/export Text
unspecified
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-10-06 18:42 UTC by Dominic Lachowicz
Modified: 2009-02-13 18:04 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Dominic Lachowicz 2008-10-06 18:42:05 UTC 
Create a spreadsheet with more than 65k rows (I have lots of CSV files that exceed this limit). Open the file, and see the data silently truncated after the 65536th row.

Expectations:
Excel 2k7 imports the file in its entirety
Excel 2k3 pops up a warning dialog if the # of rows exceeds the spreadsheet's internal 65k limit

Gnumeric 1.9.3 on Win32.
Comment 1 Andreas J. Guelzow 2008-10-06 21:03:14 UTC 
I hope I assume correctly that you are talking about the non-configurable text import?
Comment 2 Dominic Lachowicz 2008-10-06 21:08:34 UTC 
What does "non-configurable text import" mean? 

I'm importing CSV files in this case since generating them using PERL is bog-simple, but I assume that one could run into a similar problem for any file format capable of containing more than 65k rows.
Comment 3 Andreas J. Guelzow 2008-10-06 21:22:12 UTC 
You can open text files (csv files) using the configurable importer or the default csv importer (when you open them from within gnumeric). Choose the advanced settings in the open dialog to set the file type/importer to be used.

The configurable importer allows you to set which lines to import.

The issue with the non-configurable importer is not Windows specific so I am changing that to "All".
Comment 4 sum1 2009-02-13 16:50:07 UTC 
The fix for Bug 571603 added a console warning when rows are dropped (see r17140).
Comment 5 Morten Welinder 2009-02-13 17:53:43 UTC 
Actually it is a gui warning when the file is opened from the gui.
Comment 6 Morten Welinder 2009-02-13 18:04:45 UTC 

*** This bug has been marked as a duplicate of 571603 ***