Bug 117346 - color of Auto-FILTER-▼-Button does not switch back from blue to black after Filter RESET, still shows old filter settings
Summary: color of Auto-FILTER-▼-Button does not switch back from blue to black after F...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: AutoFilter Calc-DataRange
  Show dependency treegraph
Reported: 2018-04-30 12:56 UTC by Rainer Bielefeld Retired
Modified: 2021-12-15 10:37 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Sample Document (15.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-30 12:56 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2018-04-30 12:56:02 UTC
Created attachment 141773 [details]
Sample Document

Steps how to reproduce with Version: (x64)
Build-ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU-Threads: 4; BS: Windows 6.1; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: group:

1. Form Start Center open attached "NEW_AutofilterNotResettable_004.ods"
2. Click Autofilter-▼
3. Type search string "11" → [ok]
   » only 3 lines containing "11" remain below heading "Wo"
4. Click on B4 containing "11"
5. Menu ˋData → More Filters → Reset Filterˊ
   As Expected: all hidden lines restored (except empty ones due to
                Bug 117328)
   Expected:  Auto-FILTER-▼-Button switch back from blue to black
   Bug:       Remains blue (means "filter active")                      😥

Additional info:
a) Symptom: If you click Autofilter-▼ after Step 5 and click 
            "Standard Filter" you will see some filter contents 
b) This is not a general problem with all documents, but the source document
   of the sample document here (an Excel-file) shows the problem in all 
c) Still REPRODUCIBLE with Version: (x64)
   Build ID: c926a1e34672afaa5b7de0e3b08b1537e88fbb6f 
   OS: Windows 6.1; UI render: default; TinderBox: Win-x86_64@42, 
   Branch:master, Time: 2017-12-24_01:10:03 Locale: de-DE (de_DE); 
   Calc: CL, my default user profile, Tango theme
d) Version: (x64) Build-ID: 066b007f5ebcc236395c7d282ba488bca6720265
   CPU-Threads: 4; BS-Version: Windows 6.1; UI-Render: Standard; 
   Gebietsschema: de-DE (de_DE) shows a different problem with 
   sample document: After step 5 Autofilter-▼ will disappear.
e) This issue is not in AOO420m1(Build:9800)  -  Rev. 1692551
Comment 1 raal 2018-04-30 13:42:45 UTC
I can confirm with Version:
Build ID: 653e58f9eb3d4ee61d8103993cdff2660c9127a5
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 2 Xisco Faulí 2018-05-02 11:19:07 UTC
Regression introduced by:

author	Eike Rathke <erack@redhat.com>	2018-02-15 12:50:40 +0100
committer	Eike Rathke <erack@redhat.com>	2018-02-15 12:51:41 +0100
commit	74d30155c5067271fb98bacbcb895c215e61678d (patch)
tree	bb8a69a38fd38821b385f140868a1506745b973d
parent	09cb65bb92318bf8edb467fcd7720f072306f379 (diff)
Resolves: tdf#115046 don't restore a sheet-local DBData from temporary
And don't clear AutoFilter button flags in the new temporary range.

Bisected with: bibisect-linux64-6.1

Adding Cc: to Eike Rathke
Comment 3 Rainer Bielefeld Retired 2019-04-23 17:13:10 UTC
Still a bug in 6.3.
Comment 4 QA Administrators 2021-04-23 04:00:06 UTC Comment hidden (obsolete)
Comment 5 NISZ LibreOffice Team 2021-05-10 08:27:32 UTC
Still a problem in:

Version: (x64) / LibreOffice Community
Build ID: 1675a68526c43c6c6e4dc850ee911f0c1de75c88
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 6 stragu 2021-06-16 07:01:13 UTC
Reproduced with recent master:

Version: / LibreOffice Community
Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-14_22:38:17
Calc: threaded

It's not only a cosmetic issue about a button's colour, but it's also very misleading as the old filter's settings are unchanged when clicking the autofilter dropdown (i.e. the displayed filter settings do not correspond to what is shown in the sheet).

I would suggest to change the importance from "minor" to "normal".