Created attachment 196519 [details] 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.
Reproducible Version: 24.8.1.2 (X86_64) / LibreOffice Community Build ID: 87fa9aec1a63e70835390b81c40bb8993f1d4ff6 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Maybe in relation with tdf#162992
Created attachment 196532 [details] Screenshot opening in Excel Opening in Excel looks as the filter was active, but not showed.
IIUC correct to have XLSX disabled and AutoFilter=false. LO used to also show filter on open until 7.5. Seems incomplete fix. commit 2942fdc8dbda375622d0add8c36df2d6679e321a [log] author offtkp <parisoplop@gmail.com> Fri Nov 25 15:16:53 2022 committer Tomaž Vajngerl <quikee@gmail.com> Thu Dec 01 13:05:54 2022 tdf#144786 Implement XML_hiddenButton functionality Now hides autofilter button when there's an XML_hiddenButton=true or a XML_showButton=false attribute