https://bugs.documentfoundation.org/show_bug.cgi?id=154915
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Assignee|[email protected] |[email protected] |desktop.org | Status|UNCONFIRMED |ASSIGNED --- Comment #1 from Eike Rathke <[email protected]> --- (In reply to ady from comment #0) > 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"). Because those refTable fragments are 0-based. > https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#Infix_Operator_Reference_Intersection That actually says "If there are no cells in common, returns an Error" without specifying the error value (which is common in ODFF because implementations may vary). We can switch to #NULL! though for interoperability. Note that the table's comment "Intersection of ranges produced zero cells." is only an example (and apparently inspired by Excel), for us internally #NULL! is FormulaError::NoCode that can be set on error conditions producing no code.. (of which an empty intersection could be regarded as such). -- You are receiving this mail because: You are the assignee for the bug.
