Bug 45753 - Selected Auto-Filter Criteria not recognizable
Summary: Selected Auto-Filter Criteria not recognizable
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
: 45730 46149 (view as bug list)
Depends on:
Reported: 2012-02-07 14:21 UTC by th
Modified: 2016-10-26 08:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

unable to identify selected filter criterion (77.74 KB, image/png)
2012-02-07 14:21 UTC, th
LO calc file with filters set (21.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-04 13:52 UTC, th
screenshot filter bug (102.82 KB, image/png)
2012-06-05 00:36 UTC, th

Note You need to log in before you can comment on or make changes to this bug.
Description th 2012-02-07 14:21:11 UTC
Created attachment 56728 [details]
unable to identify selected filter criterion

what is: i'm unable to see which filter criterion is selected, all icons have the same appearance; 

what should be: the icon of the selected filter criterion should be marked (blue triangle in the icon's center)

screenshot attached

btw, i would suggest to invert the coloring of the selected filter icon, since blue and black are really difficult to distinguish
Comment 1 sasha.libreoffice 2012-05-15 06:18:37 UTC
Thanks for bugreport
Please, attach small ods document that demonstrates this problem
Comment 2 th 2012-05-15 06:27:23 UTC
HI, with LO 3.5.3 i am unable to reproduce this bug, so it seems to be ok; anyway i would like to recommend an inverted "filter icon" for selected criteria. This would be much easier to recognize than with the current "blue" triangle. regards tom
Comment 3 sasha.libreoffice 2012-05-15 07:03:16 UTC
Thanks for additional testing

> anyway i would like to recommend an inverted "filter icon"
Please, create new bugreport for it and attach there:
1. ods document where such filter applied. On this document developers and other people may experiment for determine which appearance of filter is better and more handy to use
2. screenshot of current situation
3. Picture, how it should be (just replace color of icons on screenshot or something like this)
Comment 4 th 2012-06-04 13:52:21 UTC
Created attachment 62537 [details]
LO calc file with filters set
Comment 5 th 2012-06-04 13:54:37 UTC
bug is reopened; as per attached lo calc file, you can't see which columns are filtered from the filter icon (should be a blue triangle); i chose two filter criteria, perhaps there the problem is?
Comment 6 sasha.libreoffice 2012-06-05 00:23:02 UTC
Thanks for attachment. But there is nothing filtered out. May be wrong wile attached
Comment 7 th 2012-06-05 00:35:39 UTC
i've checked and i confirm my previous bug..look at the line numbering, outer left (screenshot); try to filter a calc sheet with two criteria (from the standard filter) close it afterwards and reopen it. rgds tom
Comment 8 th 2012-06-05 00:36:09 UTC
Created attachment 62557 [details]
screenshot filter bug
Comment 9 th 2012-06-05 00:40:42 UTC
ok, now i can reproduce it:
in the ods file i've attached, filter AVOL>=200 AND PRC>=5; you will see the indicated filter (blue triangle); close the file and then reopen it and you can see that there is still the filter active, but in the standard filter (drop down) the fields are empty...can't be normal. rgds tom
Comment 10 sasha.libreoffice 2012-06-05 00:59:39 UTC
Thanks for additional information. Sorry for not understand from first attempt.
Indeed, in column z and aa some problem. Filter applied, but not shown.
reproduced in 3.3.4 and 3.5.4 on Fedora  64 bit (Windows not tested)

Changing version to 3.3.4 as most early reproducible
Comment 11 th 2012-06-06 01:29:05 UTC
*** Bug 45730 has been marked as a duplicate of this bug. ***
Comment 12 th 2012-06-06 01:29:44 UTC
*** Bug 46149 has been marked as a duplicate of this bug. ***
Comment 13 sasha.libreoffice 2012-07-20 13:09:02 UTC
in 3.5.5 and 3.6.beta1 still reproducible. Reopening
Comment 14 Joel Madero 2014-11-06 20:56:21 UTC
Looks like this was never directly taken on by any dev - moving to NEW as it's the appropriate status. Thanks
Comment 15 QA Administrators 2015-12-20 16:19:44 UTC Comment hidden (obsolete)
Comment 16 Kevin Suo 2016-10-26 08:47:28 UTC
Do not reproduce with:
Build ID: 01ec8f357e651ca9656837b783cf7e6a32ee4d92
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; 
Locale: zh-CN (zh_CN.UTF-8); Calc: group

Do not reproduce with:
Build ID: f4ca1573fcf445164c068c1046ab5d084e1b005f
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; 
Locale: zh-CN (zh_CN.UTF-8); Calc: group

Filter icons are properly shown.