Bug 136541 - Fileopen XLSX and XLS: Some filter cells have no color
Summary: Fileopen XLSX and XLS: Some filter cells have no color
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: XLSX-DataRange
  Show dependency treegraph
Reported: 2020-09-07 09:26 UTC by rajhariya
Modified: 2023-10-30 22:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature: https://bugs.documentfoundation.org/show_bug.cgi?id=66377

.xlsx file with tables (17.36 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-09-07 09:28 UTC, rajhariya
XLSX compared in MSO, OO and LO (112.05 KB, image/png)
2020-09-14 08:50 UTC, Timur
XLS from MSO (49.50 KB, application/vnd.ms-excel)
2020-09-14 08:57 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description rajhariya 2020-09-07 09:26:50 UTC
I created the attached table on ms office excel. upon opening the file, the table aren't as expected.

Actual Results:
Incorrect table without proper colours and details

Expected Results:
Correct table without anything missing

Reproducible: Always

User Profile Reset: Yes

OpenGL enabled: Yes

Additional Info:
Comment 1 rajhariya 2020-09-07 09:28:21 UTC
Created attachment 165224 [details]
.xlsx file with tables
Comment 2 Timur 2020-09-14 08:50:29 UTC
Created attachment 165477 [details]
XLSX compared in MSO, OO and LO

We need to pinpoint the bug, so I choose the biggest issue. Some filter cells have no color. Repro from OO to LO 7.1+.

Note: another problem and bug is that violet table has no border lines. To be seen if already reported. 

Note: similar problem with colors from MSO-created XLS. Another problem and bug is that filters are not shown.
Comment 3 Timur 2020-09-14 08:57:06 UTC
Created attachment 165478 [details]
XLS from MSO

Let's keep here also XLS created in MSO. 
Normally are XLSX and XLS different filters and bugs, but let's see what happens here.
Comment 4 NISZ LibreOffice Team 2020-10-06 12:45:47 UTC
The Format as Table feature in Excel has the Filter rows feature (checkbox) which is used here.
In Calc the Data - Define range dialog does not have a similar checkbox.
Comment 5 rajhariya 2020-10-12 05:42:35 UTC Comment hidden (no-value)
Comment 6 Pedro 2022-03-09 09:05:58 UTC Comment hidden (no-value)