[Libreoffice-bugs] [Bug 142578] New: FILESAVE XLSX Filter by color overwrites conditional format background setting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142578

            Bug ID: 142578
           Summary: FILESAVE XLSX Filter by color overwrites conditional
                    format background setting
           Product: LibreOffice
           Version: 7.2.0.0 alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx, implementationError
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: m.weghorn at posteo.de, nemeth at numbertext.org,
                    samuel.mehrbrodt at allotropia.de, varga.balazs3 at nisz.hu
            Blocks: 123807

Created attachment 172482
  --> https://bugs.documentfoundation.org/attachment.cgi?id=172482&action=edit
Example file from Calc

Attached example file has conditional formatting set on cells with background
color, and autofilter by color set on this color.
When saved to XLSX the conditional formatting color is overwritten with the
autofiltered background color.


Steps to reproduce:
    1. Open attached file
    2. Save as XLSX, reload

Actual results:
The B1:B3 cells background color changes from pink to green, text color changes
from red to black since it has changed in the Conditional Formatting dialog.

Expected results:
Conditional formatting style retained correctly.

LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 187136265d26c014e842550c2f1fc5997736e4fa
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=123807
[Bug 123807] [META] XLSX Autofilter-related bugs
-- 
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/20210531/c15f2be3/attachment-0001.htm>