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 586215 - Sumif (etc) do not understand wildcards
Sumif (etc) do not understand wildcards
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 08:40 UTC by Ólafur Arason
Modified: 2009-06-20 19:36 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Ólafur Arason 2009-06-18 08:40:09 UTC
Please describe the problem:
In excel this works:
=sumif(RANGE,"VALUE*",RANGE)

but it does not work in gnumeric

so:
    A   B
1  07   50
2  ML   52
3  07   47
4  07   48

=sumif(A1:A4,"0*",B1:B4) should work

Steps to reproduce:
1. 
2. 
3. 


Actual results:


Expected results:


Does this happen every time?


Other information:
Comment 1 Morten Welinder 2009-06-18 13:46:28 UTC
What do you get and what do you expect to get?
Comment 2 Morten Welinder 2009-06-18 14:01:04 UTC
I think I see the problem.  We do not support the matching versions of
criteria, i.e., the ones with "*" and "?" in them.
Comment 3 Ólafur Arason 2009-06-18 17:23:47 UTC
It shouldn't be that hard to implement, I can look at it if you point
me in the right direction. Most sumif information online
has this matching criteria. This and the array formula find bug are
the only thing keeping me from using gnumeric.
Comment 4 Morten Welinder 2009-06-18 19:18:21 UTC
src/value.c function parse_criteria is a good start.  I'll get around to
it.
Comment 5 Morten Welinder 2009-06-20 19:36:51 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.