Created attachment 173237 [details] Example file from Calc with filter criteria connected with OR Attached example file contains a standard filter with two criteria connected by a logical OR. When opened in Calc the autofilter dropdown of the column does not indicate that there is a filter in effect, although the Standard Filter dialog correctly displays the set criteria. A similar example file with criteria linked by a logical AND does not show this. Steps to reproduce: 1. Open attached file 2. Pull down the autofilter dropdown of column B, choose Standard Filter 3. Observe there are filter criteria set: Does not end with “a” OR Does not begin with “b”. Actual results: The autofilter dropdown in column B does not have a blue background. Expected results: The autofilter dropdown in column B should have a blue background. LibreOffice details: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 00a658ff104623d4e7fc984b5fc82d1a7e2607f2 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL Also happens in 7.0, 6.0, 5.0, 4.0, 3.5.
Created attachment 173238 [details] Screenshot of the problem in Calc
Created attachment 173239 [details] Example file from Calc with filter criteria connected with AND
Created attachment 173240 [details] Screenshot of the correct display in Calc if filter criteria are connected with AND
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1115d4d5ac63394ca0f3f1b75dc81916cdbeebe9 tdf#143101 sc UI: fix highlight of standard filter with logical OR It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/7f9fde0132b326d5ff3335aae6985e71a8ccaf6d tdf#143101 sc UI: fix highlight of standard filter with logical OR It will be available in 7.2.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d1f1f546b212ecd651146addeb328806bb270d5f CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded