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
Created attachment 166223 [details] Cell A1 has the built-in "Bad" style
This might have been present in OpenOffice as well: https://bz.apache.org/ooo/show_bug.cgi?id=110667 The first test case "colored.original.xls" looks different in Excel and LibreOffice.
Created attachment 166312 [details] Comparison MSO 2010 and LibreOffice 7.1 master
Reproduced in Version: 7.1.0.0.alpha0+ Build ID: a9976a958b2857e308c6598532151878615bfd9f CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Version: 5.2.0.0.alpha1+ Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; Locale: ca-ES (ca_ES.UTF-8) Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
FYI the python "xlrd" package has this same bug.
Looks like a duplicate of bug 106734. *** This bug has been marked as a duplicate of bug 106734 ***
You just need to take the duplicate search one step further. By sorting the lists you want to select by color. Just by doing so, you can make bulk changes to duplicate items and cells more easily. This will help you delete the items easily. You just need to do it in a few ways: First, you click anywhere in the data range. Then click Data>Sort & Filter>Sort. Next, select the area you want to filter for the Sort by option. Click to select a cell color in the Sort on drop-down list. Next, choose a color in the order menu, then top in the last dropdown https://2048cupcakes.io/