Description: using filters in more than one column no longer allows to select empty values in the second and subsequent filters Steps to Reproduce: 1. set a first filter in a column that includes both filled and empty cells 2. set a second field in a column that includes both filled and empty cells Actual Results: The second filter doesn't allow to select empty cells. Although these cells exist in the column, the "(empty)" option is disabled and can't be selected. Expected Results: Both filter should allow to select empty cells. This was the behavior in previous versions of OpenOffice. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b CPU threads: 20; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: pt-PT (pt_PT); UI: en-US Calc: CL threaded
Created attachment 193040 [details] second filter (empty) option is not available
Please attach a _minimal_ spreadsheet file that has such a problem. It would be even better if you could also add specific steps in order to see the problem with that file. For example: 1. In column A, uncheck "X" value in the autofilter. 2. Try to check or uncheck the "(empty)" value in the autofilter in column B. That's just a generic example. Maybe the steps are completely different in order to replicate the problem. Be aware that the attached file will be publicly available.
Created attachment 193045 [details] exemple spreadsheet
(In reply to ady from comment #2) > Please attach a _minimal_ spreadsheet file that has such a problem. It would > be even better if you could also add specific steps in order to see the > problem with that file. > > For example: > 1. In column A, uncheck "X" value in the autofilter. > 2. Try to check or uncheck the "(empty)" value in the autofilter in column B. > > That's just a generic example. Maybe the steps are completely different in > order to replicate the problem. > > Be aware that the attached file will be publicly available. I've attached the spreadsheet that has this problem. You check by doing the following. 1. In column A, row 10, labeled "Nation", click in the arrow and set the filter to the first value "Britain". 2. In column H, row 10, labeled "state", click in the arrow and open the filter options. You can see that the "(empty)" option is disabled, even though there are many rows with empty fields. This problem did not occurred in previous versions. As far as I could realize, this is not due to a specific column. It happens on setting the second filter and all after that. The first filter works as it should. I've also upgraded my LibreOffice to the most recent version to see if it solved the issue. It didn't. The version is listed bellow. Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 20; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: pt-PT (pt_PT); UI: en-US Calc: CL threaded
This is resolved in latest master branch and also for the next LO 7.6.6 and LO 24.2.2. for tdf#159420. *** This bug has been marked as a duplicate of bug 159420 ***