Issue 93216 - autofilter import: datarange is only the first row
Summary: autofilter import: datarange is only the first row
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0 Beta 2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-28 16:04 UTC by mroe
Modified: 2013-01-29 21:54 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Excel file containing an autofilter whose datarange is restricted to the first line in Calc (630.50 KB, application/vnd.ms-excel)
2010-07-26 20:06 UTC, camillem
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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