[Libreoffice-bugs] [Bug 138377] New: Autofilter not recognized even when XLSX has <autoFilter> defined in openxml

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138377

            Bug ID: 138377
           Summary: Autofilter not recognized even when XLSX has
                    <autoFilter> defined in openxml
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: doria.saric at gmail.com

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201120/5015980c/attachment.htm>