[Bug 67708] =sum(offset(...)) gives #VALUE! error

[Crispin Flowerday]

Public bug reported:

Ubuntu/Edgy version 1.7.0

I have a simple spreadsheet (which I will attach), which is essentially:

1                        |  10
2                        |  13
3                        |  40
=sum(offset(A1,0,1,3,1)) |

Using openoffice this gives me 63 in cell D1, but gnumeric gives me #VALUE! I
am about 90% sure this worked fine in 1.6.x ...

Incidently just =offset(A1,0,1,1,1) works fine.


Apparently this is fixed in 1.7.2 (the latest development release of gnumeric).

** Affects: gnumeric (upstream)
     Importance: Unknown
         Status: Unknown
** Affects: gnumeric (Ubuntu)
     Importance: Undecided
         Status: Unconfirmed

-- 
=sum(offset(...)) gives #VALUE! error
https://launchpad.net/bugs/67708