[Libreoffice-bugs] [Bug 139394] New: FILESAVE XLSX Conditional formatting is not applied in RT file in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139394
           Summary: FILESAVE XLSX Conditional formatting is not applied in
                    RT file in Excel
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ 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: nagy.tibor2 at nisz.hu, nemeth at numbertext.org
            Blocks: 113782

Created attachment 168654
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168654&action=edit
The original attachment #152826 saved by Calc

This is a continuation of bug #120749
When the example file of attachment #152826 is opened in Calc, all conditional
formatting rules are now imported.
When this is saved as XLSX and reloaded in Calc, these are all retained.
However if the exported XLSX is opened in Excel then some of the newly
supported conditions don’t seem to have an effect.

Steps to reproduce:
    1. Open attachment #152826 in Calc
    2. Save as XLSX
    3. Open the file in Excel 2013+

Actual results:
Cells B10 ; B14 ; C10 ; C14 are not colored in Excel.

Expected results:
Those cells should have colored background too.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 96bafa464ebdbce3ef04bec9beae5e745bb37794
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113782
[Bug 113782] [META] XLSX (OOXML) conditional formatting 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/20210104/36aa6e4e/attachment.htm>