https://bugs.documentfoundation.org/show_bug.cgi?id=163022
Bug ID: 163022
Summary: FILEOPEN XLSX: Autofilter state is inconsistent
Product: LibreOffice
Version: 25.2.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 196519
--> https://bugs.documentfoundation.org/attachment.cgi?id=196519&action=edit
Table without filter buttons
Open attached xlsx file. It has a table, where the filter buttons are disabled.
The table from Excel results in a database range "myData". That is OK.
Save the file to ods, e.g. using "Save a copy".
Open this ods file.
Error: It has Autofilter enabled.
In the opened xlsx file, select the database range "myData". In menu Data look
at state of item AutoFilter. It is off. That is OK.
Open the development Tools.
On Object Document show Properties.
Open DatabaseRanges and therein @myData. You see AutoFilter=True. That is
wrong.
Error: The UNO property AutoFilter has a different value than the state of item
"AutoFilter".
This wrong UNO property results in a wrong value for the attribute
table:display-filter-buttons in the saved ods file.
If you select the database range "myData" in the just opened xlsx file and
enable AutoFilter and immediately disable AutoFilter, then the UNO property
AutoFilter has the correct value False and save to ods is correct.
So this is an error in the import filter of xlsx.
--
You are receiving this mail because:
You are the assignee for the bug.
