Description: The problem is that LibreOffice does not recognize it should set autoFilter although it is defined in openxml format properly. The trick is to also define a hidden named range _xlnm._FilterDatabase on autofilter cells so that it could recognize the autofilter -and then it works. But such solutions highly depend on LibreOffice internals Steps to Reproduce: 1.create xlsx that contains <autoFilter ref="A3:P103"></autoFilter> (I was using fastexcel java library - very easy to use) 2. worksheet.setAutoFilter(0, 1, 4) sets autofilter on the first row on columns B to E 3. try to open it in libreoffice and see how autofilter is not recognized Actual Results: No autofilter arrows Expected Results: autofilter arrows with dropdown menus Reproducible: Always User Profile Reset: No Additional Info: it should recognize the autoFilter tag in XLSX documents without the defined hidden named range _xlnm._FilterDatabase.
Created attachment 167423 [details] This file opened with Libreoffice 6.4.6.2 does not recognize auto filter (defined in openxml format properly in xlsx)
confirm in Version: 7.1.0.0.alpha1+ (x64) Build ID: ccd0e5f445d4a7d0e7aca6c23c02c61bf14510b2 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
*** This bug has been marked as a duplicate of bug 118592 ***