Description: Excel recognizes an autofilter region by the presence of the <autoFilter/> entry in the individual worksheet XML. LO appears to check for the defined name _xlnm._FilterDatabase . While files generated by Excel do include the defined name, Excel only requires the autoFilter tag. Related: https://github.com/SheetJS/js-xlsx/issues/1165 Steps to Reproduce: Open attached files Actual Results: LibreOffice only recognizes autofilter in af_with_tag_and_name.xlsx Expected Results: LibreOffice recognizes autofilter in af_with_tag_and_name.xlsx and af_with_tag.xlsx Reproducible: Always User Profile Reset: Yes Additional Info: There are 3 attached files: - af_with_tag_and_name.xlsx was generated in Excel 2016, then edited using zip.vim to reformat the xml in the workbook entry `xl/workbook.xml` and `xl/worksheets/sheet1.xml` - af_with_tag.xlsx was generated by removing the definedNames block of the workbook XML of af_with_tag_and_name.xlsx - af_with_name.xlsx was generated by removing the autoFilter tag from the worksheet XML of af_with_tag_and_name.xlsx
Created attachment 143365 [details] AutoFilter example with autoFilter tag and _xlnm._FilterDatabase defined name
Created attachment 143366 [details] AutoFilter example sans autoFilter tag with _xlnm._FilterDatabase defined name
Created attachment 143367 [details] AutoFilter example with autoFilter tag sans _xlnm._FilterDatabase defined name
Confirm. Autofilter is present in excel 2010, but not in LO Version: 6.2.0.0.alpha0+ Build ID: 5fce97a58b8f764e35bf98128591c9a89537da05 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
BUMP ! https://github.com/SheetJS/js-xlsx/issues/1165
*** Bug 138377 has been marked as a duplicate of this bug. ***