Bug 140095 - EDITING Standard filter when added from menu is not visible
Summary: EDITING Standard filter when added from menu is not visible
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Filter
  Show dependency treegraph
 
Reported: 2021-02-02 15:22 UTC by NISZ LibreOffice Team
Modified: 2021-06-19 14:25 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Example file from Calc with autofilter and standard filter (9.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-02-02 15:22 UTC, NISZ LibreOffice Team
Details
Autofilter is indicated with dropdown (33.47 KB, image/png)
2021-02-02 15:23 UTC, NISZ LibreOffice Team
Details
Standard filter is not indicated with dropdown (32.87 KB, image/png)
2021-02-02 15:23 UTC, NISZ LibreOffice Team
Details
standard and automatic filter display problem (69.63 KB, image/jpeg)
2021-02-02 17:02 UTC, kabilo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2021-02-02 15:22:37 UTC
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

Actual results:
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.

Expected results:
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.

LibreOffice details:
Version: 7.2.0.0.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
Calc: CL
Comment 1 NISZ LibreOffice Team 2021-02-02 15:23:28 UTC
Created attachment 169396 [details]
Autofilter is indicated with dropdown
Comment 2 NISZ LibreOffice Team 2021-02-02 15:23:43 UTC
Created attachment 169397 [details]
Standard filter is not indicated with dropdown
Comment 3 kabilo 2021-02-02 17:01:15 UTC
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).
Comment 4 kabilo 2021-02-02 17:02:40 UTC
Created attachment 169401 [details]
standard and automatic filter display problem
Comment 5 m.a.riosv 2021-02-04 15:51:39 UTC
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.
Comment 6 kabilo 2021-02-09 14:13:31 UTC
(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.
Comment 7 Heiko Tietze 2021-05-18 09:50:03 UTC
Duplicates bug 125857, which is only about pivot tables but applies to all data.
Comment 8 stragu 2021-06-19 14:25:08 UTC
Reproduced with:

Version: 7.3.0.0.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
Calc: threaded

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?)