[Libreoffice-bugs] [Bug 139928] New: FILEOPEN XLSX Conditional formatting with multiple different operators incorrect

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139928
           Summary: FILEOPEN XLSX Conditional formatting with multiple
                    different operators incorrect
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: 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 169152
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169152&action=edit
Example file from Excel

This is another continuation of bug #120749
If a cell range has several different conditional formatting set with operators
“contains” “does not contain” “starts with” or “ends with” then upon import
these different operators are imported as a single type.

Steps to reproduce:
    1. Open attached document
    2. Open the Manage Conditional Formatting dialog in Excel and in Calc too

Actual results:
For the range A2:A5 the rules in Excel are: Cell value contains (A8 and A8) +
Cell value does not contain (A9 and A110).
For the range D2:D5 the rules in Excel are: Cell value begins with (D7 and D9)
+ Cell value ends with (D8 and D10).
In Calc the range A2:A5 has only “Cell values does not contain” rules. The
range D2:D5 has only “Cell value ends with” rules.

Expected results:
Same rules as in Excel.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6c8a6b6aa2f962bd2fadbdf27405bfcd7d167fec
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (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/20210126/e8bd92f1/attachment.htm>