Apache OpenOffice (AOO) Bugzilla – Issue 123047
Autofilter disappears when you try to use it
Last modified: 2017-05-20 10:35:18 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"
Confirmed with Rev. 1513819 Win 7. PS not sure about step 6 - I used Ctrl+A
> not sure about step 6 I think Edwin's result makes relation to Bug 122870 a little more improbable, but I am not sure. @Edwin: 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.
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.
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
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.