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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls, filter:xlsx
Depends on:
Blocks: XLSX-DataRange
  Show dependency tree / graph
 
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

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

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 
Description:
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)