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 725168 - Cell comments
Cell comments
Status: RESOLVED OBSOLETE
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-02-25 20:29 UTC by Morten Welinder
Modified: 2018-05-22 14:08 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Morten Welinder 2014-02-25 20:29:19 UTC
t6506

xls/biff8 is badly broken

xlsx roundtrips, but Excel doesn't see the comments at all.
Comment 1 Morten Welinder 2014-02-25 20:31:14 UTC
Excel complains about errors when loading the ods file we create.
Comment 2 Morten Welinder 2014-02-26 00:45:15 UTC
xls/biff8 mostly fixed.  Somewhere in the roundtrip we pick up explicit
text attributes.
Comment 3 Andreas J. Guelzow 2014-02-26 01:29:47 UTC
We create ODF 1.2 files. Excel reads ODF 1.1 files. ODF 1.2 requires a version attribute that did not exist in 1.1. As a consequence Excel complaints bitterly about any file that is valid ODF 1.2.
Comment 4 Morten Welinder 2014-02-26 01:34:20 UTC
I see.  Any idea why Excel doesn't see our comments?  Localc is perfectly
happy with them.

Excel doesn't even seem to parse the comment1.xml subfile in there.
Comment 5 Andreas J. Guelzow 2014-02-26 03:16:30 UTC
If I use gnumeric to create an ODS file containing a cell comment, then Excel 2013 opens it without complaint (they must have fixed their issue in 2013) and it shows a comment. But that ODS file does not contain a 'comment1.xml' subfile...!? And I don't see why there should be a comment1.xml subfile.
Comment 6 Morten Welinder 2014-02-26 03:37:43 UTC
The comments1.xml was referring to xlsx format.  Excel doesn't see our
comments for no reason I can spot.

Unrelatedly, xls/biff fixed.
Comment 7 Andreas J. Guelzow 2014-02-26 04:31:17 UTC
There is some strange stuff going on: If I create a file with content in C4 and a comment attached to C4 and save the file as ECMA v2, when I open it in Excel 2013, column C is visible but columns A, B, D to IV are hidden. (And there is no comment).
Comment 8 Andreas J. Guelzow 2014-02-26 06:01:42 UTC
Hmm, if one uses Excel to create a one-comment file the relationships are:

<Relationship<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments" Target="../comments1.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing" Target="../drawings/vmlDrawing1.vml"/></Relationships>s xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments" Target="../comments1.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing" Target="../drawings/vmlDrawing1.vml"/></Relationships>

even though the ../drawings/vmlDrawing1.vml file only exists if at time of saving the comment was being shown. So the Id for the comment relationship is rId2. I am wondering whether that is important for Excel.
Comment 9 GNOME Infrastructure Team 2018-05-22 14:08:13 UTC
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/249.