Issue 59898

Summary:	List of choices from Autofilter, does not update
Product:	Calc	Reporter:	rvolke <rvolke>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, yoshimit
Version:	OOo 2.0.1	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description rvolke 2005-12-30 16:32:53 UTC

I have confirmed this issue with versions 109, 125, and the current version as 
of 12/30/05.  The problem is that the autofilter result list does not update 
upon filtering like Excel does.  To demonstrate, run the autofilter and click 
the combo box for column 1 and select a filter criteria.  Now, click on the 
combo box for column 2 to further filter this list.  Now, if we were using 
Excel, the list of options would be limited to what remains in the filtered 
portion, not the entire list which is unfortunately what Calc does.  For small 
spreadsheets this is not a problem.  But when working with a large spreadsheet 
and you want to see what options for column B remain after filtering by columns 
A (in which case you would only need to look at what entries are in the combo 
box for Column 1), you will not be able to do so without manually skimming the 
cell entries.  This should be a relatively easy fix, but one that I feel needs 
to be done.  Thank you for your help

Robert

Comment 1 hwoarang 2006-01-02 15:38:05 UTC

Double.

Hwoarang

*** This issue has been marked as a duplicate of 27745 ***

Comment 2 hwoarang 2006-01-02 15:38:19 UTC