[Libreoffice-bugs] [Bug 118592] New: FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118592
           Summary: FILEOPEN XLSX AutoFilter import erroneously requires
                    FilterDatabase defined name
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at sheetjs.com

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

-- 
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/20180706/5599fde1/attachment-0001.html>