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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
