Issue 96489 - Standard Filter applied on wrong range when Autofilter starts after first row
Summary: Standard Filter applied on wrong range when Autofilter starts after first row
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-23 23:44 UTC by camillem
Modified: 2013-03-09 19:51 UTC (History)
2 users (show)

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

Attachments
File with autofilter starting at row 3. (8.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-23 23:45 UTC, camillem 		no flags Details
Screenshot: the autofilter works properly for listed values (48.28 KB, image/png)
2008-11-23 23:46 UTC, camillem 		no flags Details
Screenshot: the range is wrongly modified with standard filter (74.30 KB, image/png)
2008-11-23 23:47 UTC, camillem 		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 camillem 2008-11-23 23:44:00 UTC 
If you define an autofilter that starts below the first row, choosing a Standard
Filter for a column will change the range and include all the rows from row 1.
Steps to reproduce : 
-open the file AutoFilterBelow1stRow.ods
-In the filter for column C, choose one the proposed values : A for instance.
The filter works correctly. (see screenshot)
-In the filter for column C, choose All to reset it
-In the filter for column B, choose Standard Filter: the range selection is
wrong (see screenshot)
Comment 1 camillem 2008-11-23 23:45:17 UTC 
Created attachment 58237 [details]
File with autofilter starting at row 3.
Comment 2 camillem 2008-11-23 23:46:36 UTC 
Created attachment 58238 [details]
Screenshot: the autofilter works properly for listed values
Comment 3 camillem 2008-11-23 23:47:19 UTC 
Created attachment 58239 [details]
Screenshot: the range is wrongly modified with standard filter
Comment 4 Edwin Sharp 2013-03-09 19:51:32 UTC 
Selecting standard filter in column B doesn't highlight the top two rows like in the attached screenshot.
Rev. 1400866