Bug 154311 - FILEOPEN MS XML Autofilter not imported
Summary: FILEOPEN MS XML Autofilter not imported
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
 
Reported: 2023-03-21 15:28 UTC by ady
Modified: 2023-04-11 11:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description ady 2023-03-21 15:28:33 UTC
Based on:

https://bz.apache.org/ooo/show_bug.cgi?id=82849

But, the problem is different in LO.

Sample file (MS Excel XML):
https://bz.apache.org/ooo/attachment.cgi?id=49069

Comment that includes the sample file:
https://bz.apache.org/ooo/show_bug.cgi?id=82849#c3


In LO 7.4.6:
* Date format is not automatically imported (e.g. Columns D, E)
* Date+Time format is not automatically imported (e.g. Columns K, L, M)
* Background color is incorrectly imported (e.g. Column I)
* Background color is not imported (e.g. Row 11)
* Autofilter is not imported (Row 11)

In LO 7.6.alpha built on 2023-03-19, the following import filters remain unsolved:
* Autofilter not imported (Row 11)
* Different Column width, possibly related to lack of recognition of Autofilter (e.g. Columns K, L)

I have not tested LO 7.5 in this case. I am leaving the earliest version unspecified for now, but my guess is that the autofilter has never been identified as applied/active.
Comment 1 Buovjaga 2023-04-11 11:38:47 UTC
Confirmed missing autofilter.

One issue per report, so let's make this be about the autofilter.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8029a239cf294d06bb9f29aeb9b6897cb422a880
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 11 April 2023