https://issues.apache.org/ooo/show_bug.cgi?id=121727
Dmitry <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|XLSX : cell |XLSX : cell's background is | |ignored from x:cellXfs tag --- Comment #1 from Dmitry <[email protected]> --- XLSX format has redundant cell style definitions. They repeat the attribute values one after another while having different semantical sense: just he cell's style, the "kinda named" cell's style, the cell style that user selected to be present in GUI (ribbon in Office 2010), but other than that they just repeat each other. For simplistic report generator the most basic of those tags, the one that has no relation to GUI whatsoever - x:cellXfs - is enough. <x:cellXfs count="73" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main";> <x:xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="true" applyBorder="true" applyAlignment="false" applyProtection="true"> <x:protection locked="false" hidden="true" /> </x:xf> <x:xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="true" applyBorder="true" applyAlignment="true" applyProtection="true"> <x:alignment horizontal="center" vertical="center" textRotation="0" wrapText="true" indent="0" shrinkToFit="false" /> <x:protection locked="false" hidden="true" /> </x:xf> <x:xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="true" applyBorder="true" applyAlignment="false" applyProtection="true"> <x:protection locked="false" hidden="true" /> .......... <x:fills count="4" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main";> <x:fill> <x:patternFill patternType="none" /> </x:fill> <x:fill> <x:patternFill patternType="gray125" /> </x:fill> <x:fill> <x:patternFill patternType="none" /> </x:fill> <x:fill> <x:patternFill patternType="solid"> <x:fgColor rgb="00CCFFCC" /> </x:patternFill> </x:fill> </x:fills> ----------- That is pretty enough for both MS Excel 2010 and OpenXML SDK 2.5 validator But OpenOffice just fails to read the background fill-id here -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
