Search code examples
libreofficelibreoffice-calcautofilter

LibreOffice Calc autofilter shows weird display

The autofilter in LibreOffice Calc does not behave as expected. To be precise, the autofilter sometimes does not show items as checked when they should be.

MWE:

I have one simple column and apply autofilter:

enter image description here

Next, I open the filter options by clicking on the small triangle. The 4 is unchecked, the same is true for the All button (but both are expected to be checked):

enter image description here

Now, I click on All. What is up with the 2 not being allowed to be clicked?

enter image description here

I click All again. The 4 is still unchecked:

enter image description here

I scroll down...

enter image description here

and up again. Now the 4 is checked. Hurray!

enter image description here

Analysis:

The main issue is that I would like to know for sure which items are checked (thus to be found when filtering) and which are not. Just think of a large document with thousands of rows where you can not verify which items are included by hand / eye.

Because scrolling down and up again fixed the issue, I assume this as a GUI problem.

Version:

Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group

Solution

  • Upgrading to LibreOffice version 6 solved the problem.