Apache OpenOffice (AOO) Bugzilla – Issue 12666
autofilter works just on one sheet (only one auto-range per document)
Last modified: 2017-05-20 10:34:12 UTC
I'm working for Sun Microsystems and so using also staroffice. I found the same problem with seting up autofilter as with staroffice (fixed now in version 6b). If you activate an autofilter on, let's say sheet-1 and after that you set an autofilter on sheet-2, your autofilter is gone on sheet-1. This is specially ignoring if you use more sheets in one document.
Thats not quite correct; you can have more than one autofilter but only if you define a range per dataarea (DATA-DEFINE RANGE). I agree that this in not very intuitive, therefor I set this issue as enhancement
Summary: Allow setting autofilters on several sheets This one is considered for Office Later.
This problem is also (still) present in 1.1.0 and 1.1.1a for Linux. And what has not been commented until now -and what I'd like to note here- is that losing the autofilter does not unhide the filtered-away rows, which is quite annoying. If possible please consider raising priority to 3. Thanks.
*** Issue 25214 has been marked as a duplicate of this issue. ***
*** Issue 11594 has been marked as a duplicate of this issue. ***
From the duplicates it more precisely boils down to: 1) support multiple "auto-data-ranges" in OOo documents That is what ppl implicitly rely on for easy autofiltering and is needed so that subsequent data additions to their tables do not break filtering. (at the point when a static range does not include additions anymore) 2) don't forget to remove workaround in .xls filter that: - imports auto-ranges as static data ranges - exept when only one auto-range present. (issue 10995) (user does not notice this but strange things will happen later) (really bad)
*** Issue 35647 has been marked as a duplicate of this issue. ***
*** Issue 38042 has been marked as a duplicate of this issue. ***
*** Issue 40113 has been marked as a duplicate of this issue. ***
*** Issue 44394 has been marked as a duplicate of this issue. ***
*** Issue 51706 has been marked as a duplicate of this issue. ***
If this issue is not going to be fixed prior to 2.0 final, please at least please patch the issue posted by askoning on Sat Jan 3 12:37:49 -0700 2004: When adding second filter on spreadsheet, initial filter is removed but the rows remain hidden. If the first filter is removed, please have it removed completely. i.e. Remove filter graphics and show all hidden rows. If left unfixed, this issue will be troublesome to many new users who are trying to switch to OOO from MSO.
This is annoying & counterintuitive. Just to reiterate. 1) Select autofilter in sheet 1 - choose some column & value 2) Switch to sheet 2 & select autofilter 3) Come back to sheet 1. Autofilter UI (arrows) are gone. But sheet only shows filtered data.
Created attachment 35639 [details] autofilter test spreadsheet
*** Issue 67394 has been marked as a duplicate of this issue. ***
The fact that the sheet where the autofilter buttons have vanished shows filtered data makes this issue a DEFECT, non an ENHANCEMENT.
I'd second that. Please, consider changing the issue type to deffect.
*** Issue 73169 has been marked as a duplicate of this issue. ***
Hi Niklas, please take this issue to your ownership. Thank you!
*** Issue 82037 has been marked as a duplicate of this issue. ***
Niklas, what is your take on this issue? Do you consider it important? Does it have a chance of being resolved for 3.0? Thanks a lot for your response. Regards, Kirill Palagin.
Issue 85305 is relevant to this issue. That one fixes the static database range issue when importing an Excel document by supporting dynamic resizing of filtered range at run-time. This way we can leave the current importer behavior as-is. This also has the added benefit that the user can now append new data rows and have them take effect immediately without resetting the autofilter explicitly.
*** Issue 88087 has been marked as a duplicate of this issue. ***
+1 with kpalagin It would really be great to see this one in OOo 3.0 as this has 60 votes.
A simple solution: http://www.openoffice.org/issues/show_bug.cgi?id=66015
This issue is important and listed on the quarterly review for Calc: http://wiki.services.openoffice.org/wiki/2008_Q2_Review_of_Spreadsheet_Project Therefore adjusting target to 3.x.
As long as this issue is not fixed, you can use the autOOoFilter extension http://extensions.services.openoffice.org/project/autOOoFiltre .
*** Issue 94823 has been marked as a duplicate of this issue. ***
*** Issue 95546 has been marked as a duplicate of this issue. ***
Any update on this issue?
*** Issue 105091 has been marked as a duplicate of this issue. ***
Same issue here... I detect it happening in OOO310m19 Build 9420 on Mac OS X and NeoOffice (yes I know, this is not the place, but is good to know that derivatives work has also the problem). I consider that this is a very important Bug, and I can't believe that there is only 20 people following this. Well I just figured out that if I select the range and define a name for that "database range" the autofilter will stay if you autofilter another range. I also discover that the problem occurs in the same sheet as in other tabs sheets. And finally, in order to mantain Excel compatibility (and in this case is not an Excel Bug, I mean that have 2 autofilters without defining a "database range") OOo should work like Excel. Thanks. clemare
*** Issue 108389 has been marked as a duplicate of this issue. ***
Add me to cc.
Just been hit by this one - agreeing with most comments so far. It really does feel like a defect rather than an enhancement. Please can we get this on into the next version of oo?
Maybe 3.3? This important improvement, and much it is necessary. Already 91 voice.
Also, copying a sheet that has an AutoFilter creates a sheet that has the drop-down button but no filtered area defined. This gives the impression that it has been copied with the filter intact, but it is non-functional. It should either work or be cleared as part of the copy process.
*** Issue 117332 has been marked as a duplicate of this issue. ***
*** Issue 114345 has been marked as a duplicate of this issue. ***
*** Issue 118143 has been marked as a duplicate of this issue. ***
Popular bug.
the problem remains in Aoo 3.4. It's a popular function, suggest to fix
Name your data range by menu Data > Define Range. Then you can have an autofilter for each range.
I wonder, why this bug is marked as "enhancement", as this deficiency literally making the suite unusable.
By the way, LibreOffice has this fixed, see https://bugs.freedesktop.org/show_bug.cgi?id=38548 .
*** Issue 120479 has been marked as a duplicate of this issue. ***
Wait, I think, I have "un idea". There was an issue (I don't know, if it's still true), when you ask Calc to print current sheet, it'd print whole book. The root of this bug may be there. It defining one autofilter range per "sheet" that is actually a whole book.
Created attachment 78913 [details] function spec I am working on this issue, I have attached function spec, and will upload patch soon.
Created attachment 78920 [details] Add patch I have uploaded patch for this issue
Created attachment 78935 [details] Add patch latest patch
Zhang Lu, thanks for your codes. I apply the patch at revision 1372767
Created attachment 78947 [details] test cases for new filter feature
I do not see this problem on build AOO401m4(Build:9713) - Rev. 1521921