[Libreoffice-bugs] [Bug 113621] New: FILESAVE XLSX Conditional formatting range is lost if it is applied to a whole column

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113621
           Summary: FILESAVE XLSX Conditional formatting range is lost if
                    it is applied to a whole column
           Product: LibreOffice
           Version: 5.4.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 137501
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137501&action=edit
Example file from Excel 2013

The range of a conditional formatting applied to a whole column in Excel 2013
is lost when the XLSX file is opened in LibreOffice Calc and saved as XLSX.

Steps to reproduce:
1. Create a new spreadsheet in Excel 2013.
2. Select a whole column and apply a conditional formatting rule to it.
3. Save the file as XLSX and close Excel.
4. Open the file in LibreOffice Calc and save it as XLSX.
5. Reload the file.

Actual results:
While the rule for the conditional still exists, the range is lost, and
therefore it isn't applied anymore.

Expected results:
The conditional formatting rule and range should be fully preserved.

-- 
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/20171103/0c90d8f0/attachment.html>