Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||autofilter import: datarange is only the first row|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||cmoulin, issues, marc.galmard|
|Version:||OOo 3.0 Beta 2|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description mroe 2008-08-28 16:04:23 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.
Comment 1 mroe 2008-11-21 16:07:22 UTC
If necessary I can send a confidential document to reproduce this issue.
Comment 2 camillem 2008-11-23 23:24:36 UTC
I also encountered this problem many times with real-life .xls files but haven't found a minimal test case yet.