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 121440 - Implicit iteration for operators
Implicit iteration for operators
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
unspecified
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 94298 126013 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2003-09-04 12:04 UTC by Hal
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Hal 2003-09-04 12:04:32 UTC 
Using an array function to conditionally Sum or count or whatever.
I first saw this in CVS version in August, however haven't double checked
it as my computer was stolen so back with 1.0.12 (which is actually a
really nice thing to use) 

(col A)  (col B)
label_a  10
label_b  20
label_a  30

in cell A4

{=sum(if($A$1:$A$3="label_a",$B$1:$B$3,0))}(1,1)[0][0]

returns the error message #VALUE

instead of the expected value 40

I'd love to hack it myself but... One day. My skills improve slowly, but
surely.
Comment 1 Jody Goldberg 2003-09-07 02:02:47 UTC 
We don't suppot implicit iteration for operators yet.  1.2.0 has it
for function arguments, but not operators yet.
Comment 2 Andreas J. Guelzow 2003-09-13 12:40:03 UTC 
*** Bug 94298 has been marked as a duplicate of this bug. ***
Comment 3 Andreas J. Guelzow 2003-11-02 07:25:54 UTC 
*** Bug 126013 has been marked as a duplicate of this bug. ***
Comment 4 Morten Welinder 2003-11-02 22:54:53 UTC 
The elegant way of fixing this would be to turn operators into regular
functions that just happen to have funny names and special parsing
support.
Comment 5 Jody Goldberg 2004-05-21 14:03:49 UTC 
This is now in cvs.  I don't think we'll back port to 1.2
Comment 6 Jody Goldberg 2004-06-09 14:46:01 UTC 
Looks like I changed my mind.  I backed ported it a while ago.  IT will be in
the next release.