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