Issue 108661 - Autofilter does not filter correct rows with some .xls documents
Summary: Autofilter does not filter correct rows with some .xls documents
Status: CLOSED DUPLICATE of issue 85305
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO320m10
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2010-01-25 22:58 UTC by geripi
Modified: 2010-01-26 15:29 UTC (History)
2 users (show)

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

FilterBug.xls (91.50 KB, application/
2010-01-25 23:00 UTC, geripi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description geripi 2010-01-25 22:58:25 UTC
How to come to this issue:

 * Open attached file "FilterBug.xls"
 * in column D, row 6 select "P-2009-10-AK" from autofilter menu.
 * There now should be not only rows with "P-2009-10-AK" visible, but also rows
with different entries.

This issue is known to occur on Linux x86-64 and Windows x86 (32 bit) machines
with the attached file.

On the Linux machine it was tested with 3.2.0 RC3, on the Windows
machines with 3.1.1, all using German language pack, all directly
downloaded from .
Comment 1 geripi 2010-01-25 23:00:13 UTC
Created attachment 67411 [details]
Comment 2 raal 2010-01-26 06:09:41 UTC
I can reproduce with DEV300m70, ubuntu 9.10.
Data range is $Nov.$A$6:$F$39.
When I delete data range Excel_BuiltIn__FilterDatabase_1 and define range again
: $Nov.$A$6:$M$106, then
filtering works.
Comment 3 kyoshida 2010-01-26 15:28:49 UTC
This is a duplicate, in fact.

*** This issue has been marked as a duplicate of 85305 ***
Comment 4 kyoshida 2010-01-26 15:29:43 UTC
closing a dupe.