[Libreoffice-bugs] [Bug 142664] New: EDITING Calc Auto-Filter does not filter empty cells with a formula when "not empty" is selected

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142664

            Bug ID: 142664
           Summary: EDITING Calc Auto-Filter does not filter empty cells
                    with a formula when "not empty" is selected
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: draskey+bugs at gmail.com

Description:

If I enter nothing into a cell, the "not empty" filter hides the row correctly.
If the cell has a formula that assigns "" to the cell, the row remains visible.
Test spreadsheet has entries as:
TestColumnHeading
4
=IF(2=2,"", "never happen")
2

8


Steps to Reproduce:
1. Enter the data from the description in 6 cells of a column
2. Select the cells and auto-filter
3. Select "not empty from the filter drop down

Actual Results:
TestColumnHeading
4

2
8

Expected Results:
TestColumnHeading
4
2
8




Reproducible: Always


User Profile Reset: Yes



Additional Info:
Work around:
Use a standard filter
Cell <>  ...and leave the value field blank
Select OK
Calc with automatically insert a  "0" into the value field
Re-open the Standard Filter dialog
Remove the "0"
Select OK again

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210605/4309045f/attachment.htm>