GNOME Bugzilla – Bug 530704
Single-quoted strings exported incorrectly to xls
Last modified: 2008-05-07 14:56:20 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:
I see the effect, but I sure do not see the cause. Excel-generated and Gnumeric-generated files have identical LABELSST and SST records.
Ok, we've found the magic flag. XF::f123prefix. Now we need to decide how to model it internally.
Created attachment 110251 [details] [review] Tentative patch Not very well tested, but this ought to do the trick
Created attachment 110408 [details] [review] Saner patch This one probably even works.
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.