Download it now!
Bug 68113 - [UI] [Autofilter] Selecting "Not empty" unchecks all entries
Summary: [UI] [Autofilter] Selecting "Not empty" unchecks all entries
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2013-08-14 15:50 UTC by Mirosław Zalewski
Modified: 2019-02-03 19:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Simple file with autofilter enabled, for your convenience (8.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-14 15:50 UTC, Mirosław Zalewski

Note You need to log in before you can comment on or make changes to this bug.
Description Mirosław Zalewski 2013-08-14 15:50:00 UTC
Created attachment 84062 [details]
Simple file with autofilter enabled, for your convenience

(Derived from Bug 57431)

Steps to reproduce
1. Open any spreadsheet document, create AutoFilter on some data (see attached file for example).
2. In any column, open AutoFilter pop-up window and select "Not empty".
3. Open AutoFilter pop-up window again on this column.

All checkboxes (by values and "All") are unchecked.

Expected result
Since all values are visible, one might expect these checkboxes to be checked.

Reproduced under Debian testing, amd64. LO 4.0.4 from Debian repository and 3.6.6 and 4.1.0, both from TDF website. Therefore, starting with NEW.
Comment 1 Michel Rudelle 2013-08-21 17:11:40 UTC
Reproduced under Vista-32b:
Version (Build ID: 5464147a081647a250913f19c0715bca595af2f)
Version: Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28
Comment 2 Kevin Suo 2014-11-10 06:55:17 UTC
I my opinion, this is the same issue as in Bug 65505 - FILTER: Auto filter checkbox missing for "empty" cells.

When you click "Not Empty", Calc is filtering out only the values "Not Empty", thus uncheck all others. "Not Empty" here has the same effect as a checkbox.

The "Not Empty" botton should be converted to a checkbox (as requested in bug 65505) in order to avoid many confusion.

Can this bug be marked as a duplicate of bug 65505? (I am adding SEE ALSO at this moment.
Comment 3 alister.hood 2014-11-10 22:30:06 UTC
Yes, if all these bugs are rolled into one, this should be included - it is impossible to visually represent "Not empty" without implementing an "empty" checkbox.
Comment 4 alister.hood 2014-11-10 22:49:17 UTC
Well, I suppose technically you could have "All" checked with a "-" instead of a tick (Maybe some platforms tick in grey rather than with a "-"), and everything else ticked with a tick.  But this isn't transparent - most users probably wouldn't realise what it meant.
Comment 5 QA Administrators 2015-12-20 16:18:04 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2017-01-03 19:49:58 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2019-02-03 19:16:18 UTC
still repro in

ID сборки: 51af3179cf972809d6495c7d58033e069f647bbf
Потоков ЦП: 4; ОС:Linux 4.18; Отрисовка ИП: по умолчанию; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-01_00:15:00
Локаль: ru-RU (ru_RU.UTF-8); UI-Language: ru-RU
Calc: threaded