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 395926 - =sum(indirect():indirect())
=sum(indirect():indirect())
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
1.7.x
Other All
: High normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-01-12 21:52 UTC by Guess
Modified: 2007-08-01 23:41 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Sample of the problem (bug.gnumeric) (53.52 KB, application/xml)
2007-01-12 22:17 UTC, Guess 		Details
Correct sample of problem (423.50 KB, application/xml)
2007-03-16 20:37 UTC, Guess 		Details

Description Guess 2007-01-12 21:52:52 UTC 
=sum(indirect(address()):indirect(address())) worked fine in 1.6.3, but returns #!VALUE in 1.7.6. If the =indirect(address()) calls are moved to separate cells, it works.
Comment 1 Guess 2007-01-12 22:17:30 UTC 
Created attachment 80150 [details]
Sample of the problem (bug.gnumeric)

This the the output of a program that translate gnucash files into gnumeric spreadsheets
Comment 2 Jody Goldberg 2007-03-15 13:29:34 UTC 
That file looks like a gnu-cash file, not a gnumeric file.
Please re-send.
Comment 3 Guess 2007-03-15 18:31:42 UTC 
It is a *gnumeric* file from a program that translates gnucash files into gnumeric. It works in 1.6.3, but fails in 1.7.6. Try opening it in both and you'll see the difference.
Comment 4 Jody Goldberg 2007-03-15 18:42:49 UTC 
No it's not.
Neither 1.6.x nor 1.7.x can load it.

It appears to be raw XML with no gnumeric namespaces listed.

<gnc-v2
     xmlns:gnc="http://www.gnucash.org/XML/gnc"
     xmlns:act="http://www.gnucash.org/XML/act"
     xmlns:book="http://www.gnucash.org/XML/book"
Comment 5 Guess 2007-03-16 20:37:29 UTC 
Created attachment 84737 [details]
Correct sample of problem
Comment 6 Guess 2007-03-16 20:39:07 UTC 
Oops. Previously uploaded the wrong file. New attachment has the gnumeric version that opens correctly under 1.6.3 but fails under 1.7.6.
Comment 7 Jody Goldberg 2007-08-01 23:41:20 UTC 
Finally had some time to look into this.  The core of the problem was that I didn't handle the special case of
   SUM(INDIRECT:INDIRECT)
being the same as
  SUM(INDIRECT) and SUM(RANGE)
but different from
  SUM(RANGE=3)

The patch will be in 1.7.12, along with more test cases but at some point we really need to figure out what the XL mandated behaviour should be.

PS
   I assume that this file was generated by gnucash.  Good grief.  DO NOT write this stuff.  We're open source.  If you want some special functions lets talk about it and add them.  There is little excuse for this sort of funky spreadsheet hackery.