[Libreoffice-bugs] [Bug 124282] New: FILESAVE: Conditonal Formatting with 'Formula is' is not saved when saving as xlsx

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124282
           Summary: FILESAVE: Conditonal Formatting with 'Formula is' is
                    not saved when saving as xlsx
           Product: LibreOffice
           Version: 6.2.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: elske.we at gmail.com

Description:
Conditional Formatting with a 'Formula is' rule is not preserved when saving to
xlsx

Steps to Reproduce:
1. Create a new workbook in excel and add some conditional formatting rule with
an 'Formula is' rule, e.g. '=$C1="true"', with some formatting
2. Save the file as xlsx and open it in LO
3. Save the file in LO as xlsx
4. Open the file in Excel

Actual Results:
Excel says 'We found a problem with some content'. If you choose to recover the
workbook, the conditional formatting is still there, but only the rule without
the formatting. When opening the file in LO the formatting is lost, too.

Expected Results:
The conditional formatting is preserved or at least the xlsx is still readable
by Excel


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190322/c8e36a9a/attachment-0001.html>