[Libreoffice-bugs] [Bug 137362] New: XLS Import Wrong Colors

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137362
           Summary: XLS Import Wrong Colors
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at sheetjs.com

Description:
LibreOffice does not match colors with Excel "Bad" style

Steps to Reproduce:
1. Create an XLS file in Excel where a cell has the "Bad" style (sample
attached)
2. Open in LibreOffice

Actual Results:
background color hex FF99CC, text color 800080

Expected Results:
background color hex FFC7CE, text color 9C0006


Reproducible: Always


User Profile Reset: Yes



Additional Info:
XLS files use the XF record [1] to record cell style info.  However, Excel
97-2004 XLS also supports extensions to the cell style, stored in XFExt records
[2].  When present and intended to override, the relevant formatting should be
pulled from there.

LibreOffice appears to be reading the formatting info from the XF correctly,
but it seems to be skipping the XFExt records.

This also affects "Good", "Neutral" and other common styles from the Styles
portion of the Home tab in the Ribbon in Excel.


 [1]
https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/993d15c4-ec04-43e9-ba36-594dfb336c6d

 [2]
https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/8a198485-3609-4bcb-87e7-41894d48b76a

-- 
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/20201009/cde002c6/attachment.htm>