Issue 94823

Summary: AutoFilter dropdowns disappear when toggling between sheets
Product: Calc Reporter: jclingan <jtclingan>
Component: uiAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO300m9   
Target Milestone: ---   
Hardware: Mac   
OS: Mac OS X, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description jclingan 2008-10-10 00:38:49 UTC 
When working with AutoFilter, moving between two sheets that have an
AutoFiltered range, sometimes the AutoFilter dropdowns disappear.

To reproduce:
1) Create a new spreadsheet
2) Insert the following sample data into Sheet1 and Sheet2
a	b	c	d	e
1	2	3	4	5
4	5	6	7	8
3	2	3	4	6

3) On Sheet1, select the entire range above and click Data->Filter->AutoFilter.
Dropdowns appear on the 1st row (a, b, c, d, e).

4) On Sheet 2, select the entire range above and click Data->Filter->AutoFilter.
Dropdowns appear on the 1st row (a, b, c, d, e).

5) Return to Sheet1 (by clicking "Sheet1" tab) and notice the dropdowns
disappeared on Sheet1.

6) Workaround: Re-select the range and repeat step 3.
Comment 1 chl207 2008-10-10 03:05:24 UTC 
In OOO300_m9 On WinXP，the issue still exists. BTW, MS_Excel does not exist the 
issue.
Comment 2 frank 2008-10-10 08:59:22 UTC 
double to Issue 12666

*** This issue has been marked as a duplicate of 12666 ***
Comment 3 frank 2008-10-10 09:01:39 UTC 
please do a query on category Spreadsheet and Description set to Autofilter
Databaserange to get more information