[Libreoffice-bugs] [Bug 124953] New: FILESAVE, FORMATTING: xlsx file with conditional formatting created in Excel roundtripped by Calc does not look the same in Excel again

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124953
           Summary: FILESAVE, FORMATTING: xlsx file with conditional
                    formatting created in Excel roundtripped by Calc does
                    not look the same in Excel again
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dennisfrancis.in at gmail.com

Description:
The attached file is created from scratch in Excel. Opening this in Calc and
saving it as another xlsx file and opening this new xlsx file in Excel shows
misplaced conditional formatting colors.

Steps to Reproduce:
1. Open the attached xlsx file in Calc
2. Notice that B5 and G2 have green background via conditional formatting.
3. Save this as a new xlsx file.
4. Open this new file in Excel.
5. Observe the background color of cells B5 and G2. Also observe background
color of B4.

Actual Results:
Cells B5 and G2 do not have green background anymore, where as B4 is now
colored green !

Expected Results:
Cells B5 and G2 must have retained the green background and B4 should not have
any background color for the round-tripped file when viewed in Excel.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: 74a7b890524af4a52e711d8f0793ce844ded0948
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.utf8); UI-Language: en-US
Calc: threaded

-- 
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/20190425/06b473a6/attachment.html>