Skip to main content

Found a bug in #LibreOffice Calc @libreoffice:

Column contains single-digit values and #N/A. Tried to use AutoFilter to hide any #N/A but show everything else. The #N/A still appears.

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
Ubuntu package version: 4:24.2.5-0ubuntu0.24.04.2
Calc: threaded

Also, tried to take a screenshot of the AutoFilter but PrintScreen doesn't work when it's showing for some reason? Using Linux Mint

Screenshot of LibreOffice Calc, showing an active AutoFilter that's supposed to hide #N/A, but the bottom line with #N/A is still visible and nothing has been filtered out.
#libreoffice #n @LibreOffice
in reply to LibreOffice

NeatNit
NeatNit
• •

Alright: bugs.documentfoundation.org/sh…

What about the inability to take a screenshot? I guess I gotta open one for that too.. But I wonder if it's LibreOffice or Cinnamon 🤔 Any idea?

162609 – AutoFilter cannot hide N/A errors while showing all digits

bugs.documentfoundation.org
⇧