Bug 118592 - FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name
Summary: FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Autofilter Excel-Default-Names
  Show dependency treegraph
 
Reported: 2018-07-06 17:59 UTC by SheetJS
Modified: 2019-09-02 23:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
AutoFilter example with autoFilter tag and _xlnm._FilterDatabase defined name (8.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-07-06 18:00 UTC, SheetJS
Details
AutoFilter example sans autoFilter tag with _xlnm._FilterDatabase defined name (8.56 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-07-06 18:00 UTC, SheetJS
Details
AutoFilter example with autoFilter tag sans _xlnm._FilterDatabase defined name (8.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-07-06 18:01 UTC, SheetJS
Details

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2018-07-06 17:59:34 UTC
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
Comment 1 SheetJS 2018-07-06 18:00:20 UTC
Created attachment 143365 [details]
AutoFilter example with autoFilter tag and _xlnm._FilterDatabase defined name
Comment 2 SheetJS 2018-07-06 18:00:56 UTC
Created attachment 143366 [details]
AutoFilter example sans autoFilter tag with _xlnm._FilterDatabase defined name
Comment 3 SheetJS 2018-07-06 18:01:25 UTC
Created attachment 143367 [details]
AutoFilter example with autoFilter tag sans _xlnm._FilterDatabase defined name
Comment 4 raal 2018-07-08 06:37:07 UTC
Confirm. Autofilter is present in excel 2010, but not in LO Version: 6.2.0.0.alpha0+
Build ID: 5fce97a58b8f764e35bf98128591c9a89537da05
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 5 Guillermo Lo Coco 2018-11-15 14:17:56 UTC
BUMP !


https://github.com/SheetJS/js-xlsx/issues/1165