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 586312 - IF does not handle empties right during implicit iteration
IF does not handle empties right during implicit iteration
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2009-06-18 20:58 UTC by Morten Welinder
Modified: 2009-06-18 23:05 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Morten Welinder 2009-06-18 20:58:52 UTC 
=SUM(G1:G2+ISBLANK(IF(TRUE,E1,E1)))

Excel: 2, Gnumeric: 0.

The problem is that gnumeric_if is unable to tell whether its second
and third arguments were missing (in the two-commas-right-after-each-
other sense) or evaluated as empty.
Comment 1 Morten Welinder 2009-06-18 23:05:24 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.