Created attachment 169395 [details]
Example file from Calc with autofilter and standard filter
When creating a standard filter in Calc there is zero visual indication that it is set on a cell range, apart from hidden rows.
Autofilter displays a dropdown in the header cells and the same would be desirable for standard filter as well.
This happens only with standard filter set from menu Data – More filters – Standard Filter. Enabling autofilter first then selecting Standard Filter from its dropdown creates the same filtering, but the dropdown menu stays there.
Steps to reproduce:
1. Open attached file
On the first sheet there is an autofilter set which is indicated by a dropdown menu in the cells.
On the second sheet there is a standard filter and nothing indicates it.
On the second sheet the filtered columns should have a dropdown menu.
Also as requested in bug #89841 a bit more: such as filtered rows should have blue number.
Version: 126.96.36.199.alpha0+ (x64) / LibreOffice Community
Build ID: 318d384c596c1593667d6c936f55bf6ebd0c5db6
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-GB
Created attachment 169396 [details]
Autofilter is indicated with dropdown
Created attachment 169397 [details]
Standard filter is not indicated with dropdown
I've already tried to solve it here ( Bug 119958 ). I see a problem here too, the checkbox should be in the menu when the standard filter is set, because the visible parameters of setiings of the standard or automatic filter may not be the same (excuse my english).
Created attachment 169401 [details]
standard and automatic filter display problem
I'm not sure that it is a bug, they are different filters, icons are always for autofilter, and not possible to modify the standard filter with autofilter selections, it must be modified through the standard filter, even accessing to it through the autofilter.
(In reply to m.a.riosv from comment #5)
> I'm not sure that it is a bug, they are different filters, icons are always
> for autofilter, and not possible to modify the standard filter with
> autofilter selections, it must be modified through the standard filter, even
> accessing to it through the autofilter.
Therefore, i think, the checkbox should be displayed (in all columns with an automatic filter)in the menu of automatic filter before the Standard Filter option when the standard filter is applied . And for better identification also directly in the menu Data -> More Filters -> Standard Filter.
Duplicates bug 125857, which is only about pivot tables but applies to all data.
Version: 188.8.131.52.alpha0+ / LibreOffice Community
Build ID: 94d552f94b427f884c004dba5d4619ecf729d605
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-18_13:30:27
I agree that there should be a clearer indication that a Standard Filter is in use in the range the selected cell is located.
A tick box in the menu (just like for AutoFilter) is a first step, but some indication on the spreadsheet would be welcome too (small icon overlay, like for comments? with a border highlighting the filtered range?)