Created attachment 151854 [details] Test document to show the problem In the attached test document "Testtabelle_Filter_V1a.ods" is a filter defined in column D via Standard Filter with condition "contains" + value. There are 2 problems: 1. By a click on the blue filter arrow I would expect that only these entries in the filter entry list are marked as selected that correspond the filter condition "contains" + value, but all entries are marked as "selected". This problem exists in LO 6.1 and LO 6.2 (e.g. release LO 6.1.4.2 and LO 6.2.4.2 and LO dev 6.2.5) and in LO 6.3.0.0.alpha1+. I think the behavior isn't OK but for me this is the minor problem. The greater problem is: 2. When all entries in filter entry list are marked as selected I would expect that as result of a click on OK all rows are shown. This works correctly in LO 6.2, last test was made with Version: 6.2.5.0.0+ (x64) Build ID: 474bef8e06ee514c4ff751b64ef395a54987bd7d CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:libreoffice-6-2, Time: 2019-05-30_23:49:53 Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded In LO 6.3 after a click on OK the same rows are shown as before means only these rows which values in column D correspond the filter condition. Last test was made with Version: 6.3.0.0.alpha1+ (x64) Build-ID: 2574ce0f2dc711e71b4799bbd76d5d8b6ec04300 CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; VCL: win; TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-05-29_22:36:58 Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: threaded
Bisected point 2. This seems to have begun at the below commit. Adding Cc: to Serge Krot ; Could you possibly take a look at this one? Thanks 31fbd00c6bccdffb921ec74f745d775e15d105be is the first bad commit commit 31fbd00c6bccdffb921ec74f745d775e15d105be Author: Jenkins Build User <tdf@pollux.tdf> Date: Fri Apr 12 20:22:22 2019 +0200 source 4e7e3670c31329d60f5cc782abc4568c2aba33a7 author Serge Krot <Serge.Krot@cib.de> 2019-03-05 17:03:31 +0100 committer Thorsten Behrens <Thorsten.Behrens@CIB.de> 2019-04-12 11:46:58 +0200 commit 4e7e3670c31329d60f5cc782abc4568c2aba33a7 (patch) tree 0e962c50607a049634400d32c0d96871427c9fc9 parent 0342562261beede5d3bb2e43c08f6d0f216ff97c (diff) tdf#117276 sc: autofilter was unexpected reset with OK pressed
Created attachment 181009 [details] Screenshot of the example file in Calc and its xlsx version in Excel Excel does not show the checkboxes unchecked in such a situation. Instead there is a submenu with "Text Filters" and that is checked, then the condition used (if it's a single condition). Calc does not have an option to show a checkbox in the autofilter menu for submenus, but probably should. This would be useful for the Filter by Color submenu, to indicate there is something set THERE. At the same time if there is a color filter set (such as for yellow cell background in column G), the checkboxes are also all deleted. So we could do that at the least.