https://bugs.documentfoundation.org/show_bug.cgi?id=157797
Bug ID: 157797
Summary: ifna() returns #VALUE! if the input is a sum of a N/A
value and another text cell
Product: LibreOffice
Version: 7.5.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 190240
--> https://bugs.documentfoundation.org/attachment.cgi?id=190240&action=edit
Spreadsheet showing the issue in Libreoffice 7.5.6.2
ifna(value, alternative value) throws #VALUE! if the value is a #N/A produced
by adding a text cell (not a string literal) to a #N/A value.
The following two produces "ok":
=IFNA(NA(),"ok")
=IFNA("ok"+NA(),"ok")
However, the following produces #VALUE! despite the input value is #N/A, where
C2 is a cell containing the text "ok":
=IFNA(C2+NA(),"ok")
--
You are receiving this mail because:
You are the assignee for the bug.
