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 126013 - only first row is evaluated in array function
only first row is evaluated in array function
Status: RESOLVED DUPLICATE of bug 121440
Product: Gnumeric
Classification: Applications
Component: Analytics
1.2.x
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2003-11-02 00:15 UTC by Johan Van de Wauw
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: 2.3/2.4


Description Johan Van de Wauw 2003-11-02 00:15:53 UTC 
This bug is probably known, because I found a reference email showing
another example. But since I couldn't find the bug in bugzilla I report it
again.

I think it is an important bug, because in some cases there is no easy
workaround, and it also poses conversionproblems with MS Excel

Here's the old sample:
http://mail.gnome.org/archives/gnumeric-list/2000-July/msg00015.html

My own problem occured when using:
=sum((A$2:A$15>A2)*B$2:B$15)

I tested the using Gnumeric 1.2 and 1.2.1
Comment 1 Andreas J. Guelzow 2003-11-02 07:25:55 UTC 
This is the `implicit iteration' issue which is not yet implemented.

*** This bug has been marked as a duplicate of 121440 ***
Comment 2 Jody Goldberg 2003-11-02 15:39:33 UTC 
Its only partially implemented.

Function arguments are handled, operator arguments are not.
The code for operators is still incomplete.