Bug 138377

Summary: Autofilter not recognized even when XLSX has <autoFilter> defined in openxml
Product: LibreOffice Reporter: Doria Saric <doria.saric>
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: 79045_79045
Priority: medium Keywords: filter:xlsx
Version: 6.4.6.2 release   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 123807    
Attachments: This file opened with Libreoffice 6.4.6.2 does not recognize auto filter (defined in openxml format properly in xlsx)

Description Doria Saric 2020-11-20 16:26:00 UTC 
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.
Comment 1 Doria Saric 2020-11-20 16:34:25 UTC 
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)
Comment 2 Roman Kuznetsov 2020-11-23 19:14:14 UTC 
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
Comment 3 NISZ LibreOffice Team 2020-11-24 11:11:48 UTC 

*** This bug has been marked as a duplicate of bug 118592 ***