GNOME Bugzilla – Bug 725168
Cell comments
Last modified: 2018-05-22 14:08:13 UTC
t6506 xls/biff8 is badly broken xlsx roundtrips, but Excel doesn't see the comments at all.
Excel complains about errors when loading the ods file we create.
xls/biff8 mostly fixed. Somewhere in the roundtrip we pick up explicit text attributes.
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.
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.
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.
The comments1.xml was referring to xlsx format. Excel doesn't see our comments for no reason I can spot. Unrelatedly, xls/biff fixed.
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).
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.
-- 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.