Issue 93216

Summary: autofilter import: datarange is only the first row
Product: Calc Reporter: mroe <mroe.nospam>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cmoulin, issues, marc.galmard
Version: OOo 3.0 Beta 2   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Excel file containing an autofilter whose datarange is restricted to the first line in Calc none

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.
Comment 3 camillem 2010-07-26 20:06:14 UTC 
Created attachment 70832 [details]
Excel file containing an autofilter whose datarange is restricted to the first line in Calc