Bug 160156 - Impossible to filter for lines with empty values, when certain other filters used
Summary: Impossible to filter for lines with empty values, when certain other filters ...
Status: RESOLVED DUPLICATE of bug 159420
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-11 19:36 UTC by linus.kardell
Modified: 2024-03-11 20:56 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description linus.kardell 2024-03-11 19:36:27 UTC
Description:
Calc blocks you from filtering for only lines with empty cells in a column, when certain filters are used in other columns.

Steps to Reproduce:
1. Setup a spreadsheet with e.g.:
a,b,c
x,d,
y,,e
z,,
2. Add autofilter (ctrl+shift+l)
3. In column c, show only empty values
4. In column b, try to show only empty values

Actual Results:
When trying to set filters for column b, the value "(empty)" is grayed out. If you deselect "d", "Ok" will be grayed out.

Expected Results:
Only rows with empty values in column b and c shown (i.e. row "z")


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.7; UI render: default; VCL: kf5 (cairo+xcb)
Locale: sv-SE (sv_SE.UTF-8); UI: sv-SE
Calc: CL threaded
Comment 1 ady 2024-03-11 20:56:36 UTC
LO 24.2.2 and 7.6.6 and master branches should solve this.

*** This bug has been marked as a duplicate of bug 159420 ***