https://bugs.documentfoundation.org/show_bug.cgi?id=154167
Bug ID: 154167
Summary: Calc's ERROR.TYPE() function incorrect result vs ODF
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
According to:
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#refTable3
=ERROR.TYPE(#NULL!) should be "1".
* Calc results in #N/A, which is an incorrect result for this function.
According to:
https://help.libreoffice.org/7.5/en-US/text/scalc/01/func_error_type.html
Error value "Err:511" Returns "1", but this is incorrect documentation.
* It should be "#NULL!" Returns "1".
--
You are receiving this mail because:
You are the assignee for the bug.
