[Libreoffice-bugs] [Bug 123785] New: count functions count also empty fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123785
           Summary: count functions count also empty fields
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: burkhard.kasten at gmx.net

Description:
Commands like

 =ZÄHLENWENN(B11:B85;"<>0")
or
 =COUNTIF(D11:D85;"<>0")

count also empty fields.


Fields which contain 0 are not counted (correct)
Fields which contain nothing are counted (wrong)



Steps to Reproduce:
Create a new Calc file
Select field A1
Enter command like
 =ZÄHLENWENN(B11:B85;"<>0")
or
 =COUNTIF(D11:D85;"<>0")

Result is 75 even if all fields are empty

Actual Results:
75


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
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/20190301/e8af2b51/attachment.html>