https://bugs.documentfoundation.org/show_bug.cgi?id=141607
Bug ID: 141607
Summary: FILEOPEN XLSX Cell background colour missing
(patternFill)
Product: LibreOffice
Version: 4.1.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ilmari.lauhakan...@libreoffice.org
Blocks: 107332, 108897
Created attachment 171082
--> https://bugs.documentfoundation.org/attachment.cgi?id=171082&action=edit
Blue invoice template
Note: the confirming of this report is reserved for triagers in training, so if
you are a veteran, please skip :)
1. Open attached XLTX template
2. Compare with the attached PDF
Notice that the gray cell backgrounds in the Item Description / Amount section
are missing.
Examining the styles.xml we see
<tableStyles count="1" defaultTableStyle="TableStyleMedium2"
defaultPivotStyle="PivotStyleLight16">
<tableStyle name="Business Table" pivot="0" count="3"
xr9:uid="{00000000-0011-0000-FFFF-FFFF00000000}">
<tableStyleElement type="wholeTable" dxfId="6"/>
<tableStyleElement type="headerRow" dxfId="5"/>
<tableStyleElement type="secondRowStripe" dxfId="4"/>
</tableStyle>
</tableStyles>
Explanation: dxfId (Formatting Id) Zero-based index to a dxf record in the
dxfs collection, specifying differential formatting to use with this Table or
PivotTable style element.
https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.tablestyleelement?view=openxml-2.8.1
So our gray cell style should be secondRowStripe. It points to the dxf with the
zero-based index of 4. Thus, in styles.xml we find it inside the <dxfs
count="7"> element as
<dxf>
<fill>
<patternFill>
<bgColor theme="0" tint="-4.9989318521683403E-2"/>
</patternFill>
</fill>
</dxf>
Note: other issues in the same template are already reported. Missing borders
is bug 141588 while missing gradient background depends on bug 49177.
Arch Linux 64-bit
Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 3b6408988487c886adc5415f7050f9da13d2e16b
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 8 April 2021
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=107332
[Bug 107332] [META] Calc cell and page styles bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
