[Libreoffice-bugs] [Bug 141607] New: FILEOPEN XLSX Cell background colour missing (patternFill)

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: ilmari.lauhakangas at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210410/ccf09b05/attachment-0001.htm>