https://bugs.documentfoundation.org/show_bug.cgi?id=170460
Bug ID: 170460
Summary: COUNTIFS returns value for reference List (aka union
~) but should be error
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205158
--> https://bugs.documentfoundation.org/attachment.cgi?id=205158&action=edit
Reference List in COUNTIF and COUNTIFS
Open attached file. It explains the error.
The standard specifies for COUNTIFS function, that the range has to be a
reference. A reference list is not allowed. Thus LibreOffice should report an
error. Instead, it seems that LibreOffice silently ignores the second range in
the list.
That is different from the COUNTIF function, where a reference list is allowed.
See
6.13.9 COUNTIF and 6.13.10 COUNTIFS in part 4, ODF 1.4
https://docs.oasis-open.org/office/OpenDocument/v1.4/part4-formula/OpenDocument-v1.4-os-part4-formula.html
Excel notices the use of a reference list in COUNTIFS as an error.
--
You are receiving this mail because:
You are the assignee for the bug.
