Description: Hi. The automatic color filter condition is transferred to the standard filter. (This error also occurs when using a simpler condition from the AutoFilter menu). I don't know how the filter settings are physically stored in the LO, but it shouldn't be linked (in part). It should be clear whether an automatic filter or a color filter or a standard filter is applied. MSO or Google have a different method to applying multiple different filters to the same column at the same time, but it is always clear which filter is used. Thanks Steps to Reproduce: 1.use an automatic color filter 2.display the standard filter 3.the setting is transferred Actual Results: the setting is transferred Expected Results: the settings should not be transferred Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 178291 [details] interaction between filters
With two independent filter methods you never know what makes a certain value included or not. Our behavior makes it transparent what is filtered. Do you have more reasons for the request other than "MSO/Google do so"? Any good use case that requires a change?
Ad 'Our behavior makes it transparent what is filtered.' My opinion - no. I would say it is unconceptual and confusing. I see something different in one filter than in the other. Other times, the interaction will not occur. It is usually one-sided. Only one type of filter can be used in MSO, it is graphically identified by a character ('checkbox') - it is clean. Google has a different logic, filters can be combined, but each has only what the user has set - it is clean.
Created attachment 178352 [details] interaction between filters 2
Idea -when I select a condition from the automatic filter - it should be visible only in the list (I do not set a standard filter). -when I enter a condition in the standard filter - it should only be here -when I select values from the predefined ones (top10, empty ...) - I don't know - should the graphic label be visible in the menu ??? The question is whether or not to allow these options to be combined. Another question to display all items in the automatic filter list or to filter them eg by a standard filter? Thanks
[Automated Action] NeedInfo-To-Unconfirmed
Haven't thought too much about this - my assumption was that Standard Filter is just another view of Auto Filter, so that they represent the same data. This is how it's implemented currently. And I don't think two separate filters would be supported by ODF currently. If we want to change this, it has major consequences. Code needs lots of refactoring, and ODF needs an extension. And, IMO, it would only complicate things unnecessarily. I'd rather fix the cases where the display in autofilter popup is not properly reflected in the standard filter dialog.
(In reply to kabilo from comment #3) > Only one type of filter can be used in MSO, it is graphically identified by > a character... Are you sure the standard filter overwrites the autofilter? And how can users know what happens (besides experts); I mean is the idea to auto filter first and ADD-apply a complex standard filter so wrong? > Google has a different logic... And we too. :-) (In reply to kabilo from comment #5) > -when I select a condition from the automatic filter... ...it should be visible in the standard filter and vice versa. Thanks a lot for your request, it makes things much more clear when pondering over these topics. (In reply to Samuel Mehrbrodt (allotropia) from comment #7) > And I don't think two separate filters would be supported by ODF currently. > If we want to change this, it has major consequences.... So let's keep our behavior.
(In reply to Heiko Tietze from comment #8) > > Google has a different logic... > And we too. :-) I do not contradict that, but it works better for others :-) . The appendix is a simple example with one column. The standard filter is set - MM contains 'er'. The automatic filter displays all items and has editing enabled. When I cancel the December option and confirm ok all options except December are displayed. But MM = 'april' is now set in the standard filter. AND, OR between filters make it more complicated. Is it really an idea to display an automatic and standard filter 1:1? I do not know the solution in MSO, but when selecting a filter by color or a filter by item, all items in the list for the automatic filter are invalidated. Selecting any of them cancels the other filters. (In reply to Heiko Tietze from comment #8) > (In reply to kabilo from comment #5) > > -when I select a condition from the automatic filter... > ...it should be visible in the standard filter and vice versa. Thanks a lot > for your request, it makes things much more clear when pondering over these > topics. Not for me :-) . I'll see if it ever does. Thank you.
Created attachment 178431 [details] Dependency between auto filter and standard filter
(In reply to kabilo from comment #9) > The appendix is a simple example with one column. The standard filter is set > - MM contains 'er'. The automatic filter displays all items and has editing > enabled. When I cancel the December option and confirm ok all options except > December are displayed. But MM = 'april' is now set in the standard filter. Obviously buggy. If no ticket has been filed it would be good to do so.
ok, I will report this error or add it to the existing ones. Nevertheless, I am convinced that it will not be possible to combine textual and selective writing methods, which is why others do not offer it. Try to enter in the standard filter MM contains 'er' and January is red. How does this appear in the auto filter, etc.
repair: MM contains 'er' OR MM background color red