Apache OpenOffice (AOO) Bugzilla – Issue 93216
autofilter import: datarange is only the first row
Last modified: 2013-01-29 21:54:01 UTC
Hello! If a excel document is opened with a defined autofilter the autofilter do not work in calc, because the created named data range "Excel_BuiltIn__FilterDatabase_x" has only the size of on row (the first row of the data range). If the user set the autofilter off and again on it results every time in no autofilter entries, because calc uses always the created datarange. If an autofilter not only defined but active, the the created data range "Excel_BuiltIn__FilterDatabase_x" has the right size and the autofilter works. The problem appears also in 2.x. (Sorry, can't create a sample document because no excel is present.) Solution: Creation of "Excel_BuiltIn__FilterDatabase_x" with the right size of the whole data range or no creation of named data range if the autofilter is not active.
If necessary I can send a confidential document to reproduce this issue.
I also encountered this problem many times with real-life .xls files but haven't found a minimal test case yet.
Created attachment 70832 [details] Excel file containing an autofilter whose datarange is restricted to the first line in Calc