After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 445591 - IFERROR
IFERROR
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal enhancement
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-06-08 20:05 UTC by Andreas J. Guelzow
Modified: 2008-04-11 22:53 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2007-06-08 20:05:17 UTC 
MS Office 2007 introduced an IFERROR function, we may want to implement it in Gnumeric.
Comment 1 Andreas J. Guelzow 2007-06-08 20:06:04 UTC 
Reference:
http://office.microsoft.com/en-us/excel/HA012317651033.aspx
Comment 2 Morten Welinder 2007-06-08 20:16:07 UTC 
What is the value of =IFERROR(0,1/0) ?
Comment 3 Andreas J. Guelzow 2007-06-08 20:39:36 UTC 
I don't have access to IFERROR so I can't say what it indeed returns. (There is discussion in the OpenFormula SC of OASIS regarding incusion of this function.)

The way I understand it, it should evaluate the first argument, find 0, determine it is not an error from among N/A VALUE! REF! DIV/0 NUM! NAME? NULL! and so return 0.
Comment 4 Morten Welinder 2008-04-11 22:53:54 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.

I took a qualified guess on the semantics.  If I am not mistaken, then
we can now replace

    if(iserror(expr),alt,expr)

by

    iferror(expr,alt)

for purposes of calculation.  (Although we do not have the machinery to
do so at the present time.)