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 530704 - Single-quoted strings exported incorrectly to xls
Single-quoted strings exported incorrectly to xls
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-04-30 09:40 UTC by Steven Lai
Modified: 2008-05-07 14:56 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Tentative patch (5.24 KB, patch)
2008-05-01 23:21 UTC, Morten Welinder
none Details | Review
Saner patch (10.55 KB, patch)
2008-05-05 14:55 UTC, Morten Welinder
none Details | Review

Description Steven Lai 2008-04-30 09:40:42 UTC
Please describe the problem:

as below


Steps to reproduce:
1. In A1, enter "'- This is a test"
2. File > Save > MS Excel


Actual results:
When opened on MS Excel, the beginning ' character is lost
go to A1, press F2, press enter, then you'll likely get the "#NAME?" error as Excel is trying to treat the input as an expression


Expected results:
When opened on MS Excel, the beginning ' character is still there

Does this happen every time?
yes

Other information:
Comment 1 Morten Welinder 2008-04-30 22:25:07 UTC
I see the effect, but I sure do not see the cause.  Excel-generated
and Gnumeric-generated files have identical LABELSST and SST records.
Comment 2 Jody Goldberg 2008-05-01 21:27:20 UTC
Ok, we've found the magic flag.   XF::f123prefix.  Now we need to decide how to model it internally.
Comment 3 Morten Welinder 2008-05-01 23:21:47 UTC
Created attachment 110251 [details] [review]
Tentative patch

Not very well tested, but this ought to do the trick
Comment 4 Morten Welinder 2008-05-05 14:55:03 UTC
Created attachment 110408 [details] [review]
Saner patch

This one probably even works.
Comment 5 Morten Welinder 2008-05-07 14:56:20 UTC
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.