<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - XLS Import Wrong Colors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137362">137362</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLS Import Wrong Colors
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>dev@sheetjs.com
</td>
</tr></table>
<p>
<div>
<pre>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]
<a href="https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/993d15c4-ec04-43e9-ba36-594dfb336c6d">https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/993d15c4-ec04-43e9-ba36-594dfb336c6d</a>
[2]
<a href="https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/8a198485-3609-4bcb-87e7-41894d48b76a">https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/8a198485-3609-4bcb-87e7-41894d48b76a</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>