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 531111 - sumif function wrongly interprets *E* text
sumif function wrongly interprets *E* text
Status: RESOLVED DUPLICATE of bug 523250
Product: Gnumeric
Classification: Applications
Component: General
1.8.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-05-02 18:56 UTC by chris dunn
Modified: 2008-05-04 00:11 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description chris dunn 2008-05-02 18:56:49 UTC 
Using the sumif function.

If I enter 2E4 as text for the criteria, and then enter a sumif() thus :

=sumif(cell:cell,"2E4",cell:cell)

then the sumif result is always zero.

I suspect that sumif is viewing 2E4 as a number and not as text, even though it was entered as text.

If I use 2Z4 instead of 2E4 as both the criteria and the cell text entry then the expected result is returned.

I'm not sure whether this affects other functions as well as sumif, as I haven't experimented with other functions.

Thanks for all the work that has gone into Gnumeric. It really is a superb spreadsheet.
Comment 1 Morten Welinder 2008-05-02 19:40:22 UTC 
Sample sheet, please.

Please note what you get and what you expect to get for a given cell.

Also, precisely what Gnumeric version are you using?
Comment 2 Morten Welinder 2008-05-02 21:59:08 UTC 
I am guessing that this is a duplicate of bug 523250.
Comment 3 Morten Welinder 2008-05-04 00:11:45 UTC 
Sheet in hand.  Problem confirmed as dupe of bug 523250.
"2E4" will get interpreted, but cells should be interpreted similarly.

(We have to interpret: otherwise you could not ask ">200" either.  Blame
Microsoft for an interface that cannot tell strings from numbers.)


*** This bug has been marked as a duplicate of 523250 ***