https://bugs.documentfoundation.org/show_bug.cgi?id=154915
Bug ID: 154915
Summary: "Intersection of ranges produced zero cells" error vs
ODF standard
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
A formula such as:
=(A2!A3)
...results in an error (es expected), because there is no reference
intersection.
Actual results:
In that example, Calc currently shows the #REF! error.
Expected results:
According to the ODF standard, this error should be #NULL!, "Intersection of
ranges produced zero cells. ERROR.TYPE of 1".
See "Table 4" in ODF standard:
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#refTable3
(yes, that link really points to "Table 4").
Background info:
The reference intersection operator in Calc is the exclamation mark "!".
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#Infix_Operator_Reference_Intersection
A formula such as:
=SUM(A2:D3!B1:C4)
...provides the sum of the numeric values of B2:C3.
A formula such as:
=(B1:B3!A2:C2)
...provides the value of B2 (in this case, the parentheses are optional).
A formula such as:
=(A2!A2:A3)
...provides the value of A2.
A formula such as:
=(A2!A2)
...provides the value of A2.
The #NULL! error is also seen in Excel for the same "no intersection" cases
(where the space character is the intersection operator, e.g. "=(A2 A3)" is
#NULL! in Excel).
The #REF! error should be corrected to the #NULL! error for this case
("Intersection of ranges produced zero cells"), in order to be compliant with
the ODF standard, and for interoperability.
(CC'ing Eike Rathke)
--
You are receiving this mail because:
You are the assignee for the bug.
