[Libreoffice-bugs] [Bug 130734] New: COUNTIFS function not evaluating correctly when not only checking for equality

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130734
           Summary: COUNTIFS function not evaluating correctly when not
                    only checking for equality
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: karoshi at 137tmx.de

Created attachment 157945
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157945&action=edit
Countifs works in LO 5.x, broken since 6.0

Countifs is defined to count 1 when all criteria are met which seems not to
work properly when not only comparing with some fixed content.

The attached file shows a countifs of 1 in both cases when opened in
LibreOffice Calc 5.9 (correct).

But 2 for the first value (incorrect), 1 for the latter (correct) when opened
in 6.0 through 6.4.

The issue has appeared in a disclosed document so I created a minimal test as
attached.

-- 
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/20200217/06fc2d6c/attachment.htm>