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 736202 - Saving strings in xlsx using type "str"
Saving strings in xlsx using type "str"
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2014-09-06 18:40 UTC by Kirill Zaborsky
Modified: 2014-09-08 13:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Kirill Zaborsky 2014-09-06 18:40:08 UTC 
This have shown up in this github issue - https://github.com/qrilka/xlsx/pull/12
It appears that when exporting to xlsx Gnumeric uses "str" cell type for simple strings but spec says explicitly that this cell type means "Cell containing a formula string."
And code under the question is located near https://git.gnome.org/browse/gnumeric/tree/plugins/excel/xlsx-write.c#n1606
Comment 1 Morten Welinder 2014-09-07 22:54:18 UTC 
The real question here is: what does Excel do?

I think what you are asking for is to use "inlineStr" instead of "str".
For that, we need to know if Excel and LO can read that.
Comment 2 Morten Welinder 2014-09-08 13:09:26 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.


Excel, LO, and Gnumeric accept either version.

Excel and LO produce neither version, opting instead for putting everything
into the string table.