Issue 70506 - Calc's Autofilter, filtering by two columns - filter out values too.
Summary: Calc's Autofilter, filtering by two columns - filter out values too.
Status: CLOSED DUPLICATE of issue 27745
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-10-17 10:05 UTC by kpalagin
Modified: 2006-10-17 15:22 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Illustrating spreadsheet (7.60 KB, application/vnd.sun.xml.calc)
2006-10-17 10:06 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2006-10-17 10:05:27 UTC
I would like to suggest enhancement to the way Autofilter works. Let's say I 
want to filter by two columns simultaneosly, first by one and then by the 
I think that showing in second filter only values, that are visible after 
application of the first one, is much more logical (what is the point of 
showing empty subset?) and would allow user to focus only on relevant data.

On linked sample file click arrow down in cell B2 and note how "b1" and "b2" 
values are available for selection. 

Thanks a lot.
K. Palagin.
Comment 1 kpalagin 2006-10-17 10:06:59 UTC
Created attachment 39807 [details]
Illustrating spreadsheet
Comment 2 frank 2006-10-17 15:21:50 UTC

double to Issue 27745 .


*** This issue has been marked as a duplicate of 27745 ***
Comment 3 frank 2006-10-17 15:22:08 UTC
closed double