Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||ODFF: implement IFERROR and IFNA|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||cotarejo, discoleo, eric.bachard, guy, hgabreu, issues, kaptainkatsu, lvyue, m-Matti-a.Lehtonen, ooo, oooforum, pescetti, vulcain, webassistant5.tft+openoffice|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
|Issue Depends on:|
Description kyoshida 2008-08-11 22:00:31 UTC
IFERROR is (AFAIK) a new built-in function introduced in Excel 2007. As such, a file saved by Excel 2007 that contains use of this function creates an interop issue, even if the file is saves as the legacy binary format (.xls).
Comment 1 kyoshida 2008-08-11 22:26:43 UTC
I'm working on this as we speak.
Comment 2 ooo 2008-08-12 12:14:49 UTC
Nice. IFERROR() is also drafted in ODFF, adding to subject. Note that IFNA() is closely related.
Comment 3 discoleo 2008-08-12 19:01:27 UTC
I have seen some discussions on the MS forums to improve the IFERROR() function to catch only a specified type of error. I can imagine that this is useful, as some errors (like #REF!) are undesirable to catch. I can imagine to expand the function with a 3rd argument specifying which error/errors should be caught: =IFERROR( _expression_ , _alt_expression_ , *ERROR_TYPE* )
Comment 4 kyoshida 2008-10-31 19:20:28 UTC
Sorry folks. Things have changed, and I am not planning on working on implementing IFERROR any more. I'll be happy to keep this assigned to me for now, but if someone else wants to implement this piece, please raise your hand here.
Comment 5 eric.bachard 2009-10-15 20:58:37 UTC
Comment 6 lvyue 2010-02-03 01:38:22 UTC
Comment 7 ooo 2010-02-15 12:45:18 UTC
*** Issue 109253 has been marked as a duplicate of this issue. ***
Comment 8 vulcain 2013-01-28 10:05:08 UTC
Resolved in LibreOffice 4.0: https://bugs.freedesktop.org/show_bug.cgi?id=56124
Comment 9 Guy 2013-04-13 21:34:28 UTC
I came up with something of a workaround for my funtions : IFERROR( ... ;0) ISNA(ERRORTYPE( ... )) I hope this helps.
Comment 10 webassistant5.tft+openoffice 2013-08-12 14:47:28 UTC
Confirming this is still not in OpenOffice 4.0, was unable to run an =IFERROR.
Comment 11 webassistant5.tft+openoffice 2013-08-12 14:48:12 UTC
(In reply to vulcain from comment #8) > Resolved in LibreOffice 4.0: > https://bugs.freedesktop.org/show_bug.cgi?id=56124 Could this same patch be applied to OpenOffice?
Comment 12 Katsu 2015-12-03 21:45:20 UTC
This is still no implemented in the current version of OO. Its a real pain because I use a spreadsheet from an excel user and I have to delete the iferror to get the spreadsheet to work. Sample code =iferror(VLOOKUP($H2;$O$2:$P$121;2;0);"") With the iferror there, the vlookup doesn't work
Comment 13 oooforum (fr) 2016-06-03 08:59:49 UTC
(In reply to webassistant5.tft+openoffice from comment #11) > > https://bugs.freedesktop.org/show_bug.cgi?id=56124 > Could this same patch be applied to OpenOffice? Read issue 105140: licence used by LibreOffice is not compatible with Apache