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 94957 - cell formula corrupted when saved to .xls file, and reloaded
cell formula corrupted when saved to .xls file, and reloaded
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.0.x
Other Linux
: Immediate major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2002-10-05 19:42 UTC by linux_dr
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description linux_dr 2002-10-05 19:42:44 UTC 
The following formula:

=concatenate(floor(sum(B4:B10)*24),":",mod(floor(sum(B4:B10)*24*6),6),mod(floor(sum(B4:B10)*24*60),10))

is corrupted (consistantly) to this:

=concatenate("WrongArgs","WrongArgs",floor(sum(B4:B10)*24),mod(floor(mod(floor(":",sum(B4:B10)*24*6),6),sum(B4:B10)*24*60),10))

whenever the spreadsheet is saved to a .xls file and reloaded...
saving to a .gnumeric file does not cause the problem

This happens in Gnumeric 1.0.9 which (to my knowledge) is the latest stable
release...

(Thanks in advance for the fix)...
Comment 1 Jody Goldberg 2002-10-05 21:20:29 UTC 
I just did some quick tests that will help track this down.

1) it is reproducable in 1.0.9
2) it is _not_ reproducable in 1.1.10
3) it is in the export code because 1.1.10 loading the results of 1.0.9 has
   the same trouble.

The scary thing is that I do not recall fixing anything around there.
I'll have a look tonight.
Comment 2 Jody Goldberg 2002-10-06 00:47:52 UTC 
Ok, I see the patch that fixes it.  I thought I'd back ported that.
I'll do a 1.0.10 release shortly to get this out there.

Thanks for the reminder.