Created attachment 175634 [details]
Example file from Calc
When color filtering is enabled on a sheet, turning OFF and ON again the autofilter seemingly retains the filter condition.
Steps to reproduce:
1. Open attached file, it has an autofilter on column B set to green background color.
2. Turn OFF the autofilter, this will show the pink background rows as well.
3. Turn ON the autofilter.
The autofilters Background color list shows the green item highlighted.
Turning off the autofilter should lose the previous settings.
Version: 188.8.131.52.alpha0+ (x64) / LibreOffice Community
Build ID: b1488cd6f008049a9aaff7350deeb73cbbd535b6
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: hu-HU (en_US); UI: en-US
Created attachment 175635 [details]
Screenshot of the original document in Calc
Created attachment 175636 [details]
Screenshot of the problem in the Standard Filter dialog
Created attachment 175637 [details]
Screenshot of the problem in the Autofilter dropdown
Not reproducible in
Version: 184.108.40.206.alpha0+ / LibreOffice Community
Build ID: fd11f019e8b7253131bdb09f8023f15cd6525bf8
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
(In reply to Samuel Mehrbrodt (allotropia) from comment #4)
> Not reproducible in
> Version: 220.127.116.11.alpha0+ / LibreOffice Community
> Build ID: fd11f019e8b7253131bdb09f8023f15cd6525bf8
> CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
> Locale: de-DE (de_DE.UTF-8); UI: de-DE
> Calc: CL
Clarification: you need to turn it off by placing the highlight in the filtered range in column B and press the toolbar icon (or Data - Autofilter) to turn it on and off.
After that the pink background cells are also visible (there is no filtering) but the clicking on the dropdown -> Background color still shows the green color checked.
Version: 18.104.22.168.beta1+ / LibreOffice Community
Build ID: 81b26582ed62db40e2be701ddefede7d8230d0d2
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
(linux-bibisect from 9 days ago)