Issue 123047 - Autofilter disappears when you try to use it
Summary: Autofilter disappears when you try to use it
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.0.0
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: 4.1.0
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-08-16 05:03 UTC by Rainer Bielefeld
Modified: 2017-05-20 10:35 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample Document (124.40 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-08-16 05:03 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2013-08-16 05:03:55 UTC
Created attachment 81339 [details]
Sample Document

Steps how to reproduce with  "AOO 4.0.0-Dev – German UI / German locale - [AAOO400m3(Build:9702)  -  Rev. 1513120  2013-08-13]" on German WIN7 Home
Premium (64bit)", own separate user profile:

1. From AOO Start Center open attached sample document
2. <control+end> 
   > moves cell cursor to end of document, cell AX1827
3. press key <Page Down> several times until row of cell cursor is bigger 
   than 2000
4. Scroll up using scroll slider until top of scroll bar
5. Scroll left using scroll slider until left end of scroll bar
6. <shift+clkick> selects all range 
7. Menu 'Data -> Filter -> Autofilter'
   > Removes Autofilter, what might be a bug already
8. Menu 'Data -> Filter -> Autofilter' restores Autoiflter after you have
   confirmed Column Heading message with <ok>
9. Click Auto Filter Dropdown in B1
   > Filter Dialog appears
10. Click 'Standard Filter'
    Bug: All Auto Filter Dropdowns disappear

Additional info:
a) This problem is not 100% reproducible for me, sometimes I see the problem without detour with steps 1 ... 8, sometimes problem is not reproducible at all. 

b) I have horrible problems with disappearing Auto Filters in most of my bigger Spreadsheets, what makes AOO Calc More or less unusable.  

c) Steps 1 ... 8 are not mandatory for me to see the problem in my normal documents. But problem is better reproducible with this detour

d) I never see this problem with AOO 3.4.1, so this one seems to be a regression.

e) I wonder whether this one might be related to "Bug 122870 - Advanced filter removes Autofilter"
Comment 1 Edwin Sharp 2013-08-16 08:28:22 UTC
Confirmed with Rev. 1513819 Win 7.

PS not sure about step 6 - I used Ctrl+A
Comment 2 Rainer Bielefeld 2013-08-16 09:01:20 UTC
> not sure about step 6 

I think Edwin's result makes relation to Bug 122870 a little more improbable, but I am not sure.

That should not matter, I only used that little more complicated way because it seemed to me that that made it more reliable to reproduce the bug.
Comment 3 robtgraves 2013-11-30 21:33:23 UTC
I am using 4.01. I frequently use Standard Filter with AutoFilter and have never had a problem. But my AutoFilters disappear frequently for no apparent reason. Sometimes one or more AutoFilters is gone when I first open a file. Sometimes an AutoFilter disappears when I return to a sheet after working on another sheet, or another file, or another application. It happens so often that it is a major pain in the neck. I cannot, however, reproduce it at will; it's unpredictable and uncontrollable.
Comment 4 Rainer Bielefeld 2014-05-22 04:43:47 UTC
Today NOT reproducible with server installation of "AOO 4.1.0-dev – English UI / German locale - [AOO410m14(Build:9760)  -  Rev. 1583418_2014-04-02]" on German WIN7 Home Premium (64bit)", own separate user profile.

I will do some more test soon
Comment 5 Rainer Bielefeld 2014-05-22 04:47:03 UTC
Still reproducible with 4.0.0, but already fixed for "AOO 4.0.1  – German UI / German locale [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", own User Profile

   Has been fixed for AOO 4.0.1, but because of incomplete Target Milestone
   selector contents (Bug 123063) I only can select TM = 4.1.0, no correct
   information can be contributed.