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@lists.freedesktop.org
Reporter: draskey+b...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs