Bug 147578

Description:
The dependence between the autofilter and the standard filter is incorrectly displayed.
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.

Note: using a standard filter, you can enter a more complex condition, e.g. MM contains 'er' OR MM background color red. These more complex conditions may not be able to be displayed with the automatic filter (1:1)

Steps to Reproduce:
1. open the attached file
2. check the standard filter settings (confirm ok)
3. display automatic filter (display is not the same as standard filter)
4. cancel 'December'
5. check the standard filter settings (MM = 'april' is now set )
6. all options except December are displayed

Actual Results:
dependence autofilter vs standard filter is violated

Expected Results:
display the dependency correctly or do not allow concurrency of multiple filters or other solutions 


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info: