GNOME Bugzilla – Bug 405951
[xls] some cell comment formatting is not imported
Last modified: 2018-05-22 13:20:14 UTC
Please describe the problem: comments in my excel files can be formatted: bold, underlined etc... when I open these in gnumeric the formatting doesn't show up. Steps to reproduce: 1. make some comments in an excel file and format them: bold, underlined etc... 2. save them and open in gnumeric 3. fight with gnumeric a little while untill you get the comments to show up 4. observe cell comments in gnumeric have no formatting Actual results: unformatted comments appear Expected results: the comment would appear with the same formatting as it has in excel Does this happen every time? yup Other information:
It would be helpful if you could attach a sample file.
Created attachment 82479 [details] sample file this file is not exhaustive, but I tried to cover all types of comment formatting possible in XL. There are much more than I expected. maybe just attach a tiny .odt file and display it as a comment. Then absolutely anything would be possible...
Created attachment 85730 [details] 4-2-2007-example file added background color case
I have just modified the comment dialog to allow some comment formatting within Gnumeric. That formatting is at this time not shown in Gnumeric (but there appears to be some partial implementation in the comment sheet object). In fact we are not even saving that formatting inside a .gnumeric file.
I just tested the above sample file. It seems that some of the formats (foreground color, bold, strikethrough,...) are in fact imported. THey are not shown when the comment appears but one can verify their import in the edit-comment dialog.
The imported formatting is now also shown in the comment itself. There is some formatting that appears not to be imported and some (such as double underline) is imported incorrectly (as single underline).
Note: incorrectly imported: double underline imported as single not imported: single underline background alignment font setting point size
double and single underline import is now fixed. We are left with needing to fix: background alignment font point size
Created attachment 166707 [details] Example with single/double/single acc./double acc/mixed underlines (XL2k3) By Andreas request
Created attachment 166708 [details] Example with single/double/single acc./double acc/mixed underlines (XL5/95 saved from XL2k3) By Andreas request
Created attachment 166710 [details] Screenshot for "underline_text.xls"
Created attachment 166711 [details] Screenshot for "underline_text.xls" ("200%" in XL2k3)
Rich text (B11) is weirder than can be seen. If looks like if the first character has either single-accounting or double-accounting underlining then the whole cell is given that. I'm not sure we need to implement that.
-- 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/73.