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@lists.freedesktop.org
Reporter: kelem...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
