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 153260 - cell contents get mangled around row #2048
cell contents get mangled around row #2048
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other Linux
: High major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-09-21 10:22 UTC by Jan Nieuwenhuizen
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
excel 2000 import problem around #2048 (87.00 KB, application/octet-stream)
2004-09-21 10:24 UTC, Jan Nieuwenhuizen 		Details

Description Jan Nieuwenhuizen 2004-09-21 10:22:25 UTC 
Opening the attached* file mangles rows around row #2048.

Spreadsheet created with excel 2000.

Problem in 1.3.90 (debian/experimental) and CVS.

*) I hope I get the option to attach a file later, not on this page?
   http://bugzilla.gnome.org/enter_bug.cgi?product=Gnumeric
Comment 1 Jan Nieuwenhuizen 2004-09-21 10:24:34 UTC 
Created attachment 31762 [details]
excel 2000 import problem around #2048
Comment 2 Morten Welinder 2004-09-21 12:57:46 UTC 
I see strange things around A2051:

A2050: Abcdefghi
A2051: 768
A2052: 5.37...e-299
A2053: Abcdefghi
A2054: FALSE
A2055: Abcdefghi

(gnumeric:4471): gnumeric:read-WARNING **: XL: Xf index 0x17 is not in the
range[0..0x15)
Comment 3 Jan Nieuwenhuizen 2004-09-21 15:30:23 UTC 
Yes, in 2051, 2052 and 2054.  The fun thing is, that when you remove
a number of rows at the beginning, the mangling stays at the same rows.

That's why I so sloppily referred to `around 2048', because that suggests not
to be a specific cell-, but rather a buffer size problem.
Comment 4 Jody Goldberg 2004-09-21 22:16:08 UTC 
I see the problem and will work up a patch tonight.  The trouble is that MS has
been less than clean about it's file format.  The web search records use the
same ordinals as some basic records to store values, but use a different version
number ...

Gnumeric did not realize they were not normal values, and loads them.
Comment 5 Morten Welinder 2004-09-22 14:29:32 UTC 
Fixed in cvs, it seems.
Comment 6 Jan Nieuwenhuizen 2004-11-04 09:48:03 UTC 
Thanks a lot you for this quick fix -- I installed CVS
the same day.  Sorry for this late thank you.

-- Janneke