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
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
FilterBug.xls (91.50 KB, application/vnd.ms-excel)
2010-01-25 23:00 UTC, geripi 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 OpenOffice.org 3.2.0 RC3, on the Windows
machines with OpenOffice.org 3.1.1, all using German language pack, all directly
downloaded from www.openoffice.org .
Comment 1 geripi 2010-01-25 23:00:13 UTC 
Created attachment 67411 [details]
FilterBug.xls
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.