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 485842 - Type error in reference not caught
Type error in reference not caught
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: Main System
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-10-11 20:12 UTC by J.H.M. Dassen (Ray)
Modified: 2018-05-22 13:23 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description J.H.M. Dassen (Ray) 2007-10-11 20:12:50 UTC 
Please describe the problem:
Gnumeric isn't generating an error message for formula with a type problem, resulting in misleading results.

Steps to reproduce:
Put 1 in A1
Put 2 in B1
Put =address(1,2) in A3
Put =count(A1:$B$1) in A4
Put =count(A1:address(1,2)) in A5


Actual results:
The formula in A5 is accepted without an error.

Expected results:
An error message indicating a type problem with the expression in A5

Does this happen every time?
Yes

Other information:
Originally reported as http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=446021
Comment 1 Morten Welinder 2007-10-11 20:31:42 UTC 
Excel refuses =count(A1:address(1,2)) at parse time.
Comment 2 Morten Welinder 2007-10-12 14:34:23 UTC 
Note, that with sum instead of count we do get an error.  Count ignores
errors.

This problem is that we do not distinguish between errors inside ranges
and errors in the constructed range.
Comment 3 Andreas J. Guelzow 2010-02-19 06:28:23 UTC 
I don't see any real problem here. 

COUNT ignores errors and it ignores errors inside ranges. COUNT(NA()) should surely be 0, so we can't trigger an error on having a direct error and we clearly don't want to trigger an error on errors in the range.

It would be nice to know what Excel is doing. OOo has the same behaviour as we do,
Comment 4 GNOME Infrastructure Team 2018-05-22 13:23:38 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/84.