Created attachment 187033 [details] Trying to filter empty The functionality to filter empty cells is not working anymore after upgrading my LibreOffice to version 7.4.6.2. I noticed that it has to do with the setting in calc: "Search criteria = and <> must apply to whole cells" I used to have that setting always disabled and filtering for empty worked anyway.
IDK which exactly is supposed to be the expected behavior when menu Tools > LibreOffice Calc > Calculate > "Search criteria = and <> must apply to whole cells" is unticked / OFF regarding Autofilter empty cells. Whichever the case, I can repro when that setting is OFF with LO 7.4.6.2. Under these conditions, Autofilter "empty" cells (checkbox marked, some other items may or may not be) results in hiding, not showing, the empty blank cells. Autofilter works as expected with the "Search criteria = and <> must apply to whole cells" setting checked ON.
Works for me in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 52acefd6024ec79f8333ba40eef83816eda3046f CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ Calc: threaded Please can you test with newer version?
@raal, (In reply to raal from comment #2) > Works for me in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Is your "Search criteria = and <> must apply to whole cells" OFF or ON? For me it is also repro in LO 7.6.alpha on Windows, with that setting OFF.