Issue 92677

Summary:	ODFF: implement IFERROR and IFNA
Product:	Calc	Reporter:	kyoshida
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	cotarejo, discoleo, eric.bachard, guy, hgabreu, issues, kaptainkatsu, lvyue, m-Matti-a.Lehtonen, ooo, oooforum, pescetti, rseshu, vulcain, webassistant5.tft+openoffice
Version:	DEV300m29
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:
Issue Blocks:	105140

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

+me

Comment 6 lvyue 2010-02-03 01:38:22 UTC

cc

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

Comment 14 oooforum (fr) 2024-01-26 07:25:48 UTC

*** Issue 112152 has been marked as a duplicate of this issue. ***