Issue 118143

Summary: filter dropdowns disappear between worksheets
Product: Calc Reporter: decays <decaysspare>
Component: uiAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Normal    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.3Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description decays 2011-06-07 14:35:05 UTC 
open blank calc file.
enter random data in column A, leaving some rows empty
switch to worksheet 2, enter random data in column A, leaving some rows empty
switch to worksheet 1
select all data by clicking the top left box
select from the menu, Data -> Filter -> Autofilter (select default options)
Using the filter dropdown in column A, select Standard filter, value = empty
Switch to worksheet 2
select all data by clicking the top left box
select from the menu, Data -> Filter -> Autofilter (select default options)
Using the filter dropdown in column A, select Standard filter, value = empty
switch to worksheet 1 and you'll see the filter dropdown arrow has disappeared

The filter dropdowns should not disappear just because the user switched to a different worksheet and applied another filter.
Comment 1 Regina Henschel 2011-06-07 15:39:52 UTC 
You can have only one anonymous autofilter per document. If you need more autofilter, you must name the data range via Data > Define Range.

Contact a forum or mailing list, if you need help doing this.

*** This issue has been marked as a duplicate of issue 12666 ***
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:22:07 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.