GNOME Bugzilla – Bug 724898
Pattern round trip issues
Last modified: 2014-02-23 22:25:00 UTC
I added pattern tests to t6502. ods seems to drop the pattern colour: - <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="2" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:9999" PatternColor="0:0:FFFF" Format="General"> + <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="1" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:9999" PatternColor="0:0:0" Format="General"> biff7 and biff8 have problems with patterns 19 and up. xlsx is still so messy I cannot tell.
Regarding ods/odf there is more to this than just the pattern colour: We aren't saving the pattern either.
biff7 and biff8 differences were format deficiencies.
WHile this seems strange, ODF does not appear to have a defined way to specify pattern fills for table cells. There are hatches for graphic objects but there is no reasonable way to use them as backgrounds for table cells. One can specify a background image for a table cell and that is probably the most appropriate way of implement pattern in an ODF supported way. Of course the easy way of fixing the round trip issue would be to specify the pattern and colours using foreign elements.
The round trip issue is fixed (the easy way). When we find an ODF consumer or producer that supports background patterns and images for cells, we can consider writing/reading the info in a standard way.
I *think* we're done here. This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.