Issue 70506

Summary: Calc's Autofilter, filtering by two columns - filter out values too.
Product: Calc Reporter: kpalagin <kpalagin>
Component: formattingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.4   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Illustrating spreadsheet none

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 
other.
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.
WBR,
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 
Hi,

double to Issue 27745 .

Frank

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