[Libreoffice-bugs] [Bug 113013] New: FILEOPEN XLSX Calc is unable to interpret 'Formula is' type conditional formatting rule

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113013
           Summary: FILEOPEN XLSX Calc is unable to interpret 'Formula is'
                    type conditional formatting rule
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 136864
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136864&action=edit
The problematic document made with Excel 2013

The IF(A1<>Sheet2!A1;1;0) conditional formatting rule applied to a range of
cells compares the same cells on two different worksheets, and if the value of
the same cells on the two different doesn't match it applies the conditional
formatting. LibreOffice Calc is unable to interpret this rule, and the
condition is lost when the document is saved as XLSX.

Steps to reproduce:
1. Create a new spreadsheet in Microsoft Excel.
2. Give values for a range of cells.
3. Create a new worksheet.
4. Copy the content from the first worksheet to the second worksheet to the
same range of cells.
5. Change a few values on the second worksheet.
6. Select the cells with the values on the original (first) worksheet.
7. Create a new conditional formatting with the following rule:
IF(A1<>Sheet2!A1;1;0)
8. Save the document as XLSX and close Excel.
9. Open the newly created file in LibreOffice Calc.
10. Save the file as XLSX with a different filename.
11. Open the XLSX file that was created with Calc in Excel.

Actual results:
Calc is unable to interpret the conditional formatting rule, and the condition
is lost when the document is saved as XLSX.

Expected results:
Calc should be able to interpret and apply the conditional formatting rule and
the rule should be preserved when the spreadsheet is saved as XLSX.

-- 
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/20171009/2ff814ac/attachment.html>