[Bug 83048] offset only works for a one-cell range

[Francesco Potortì]

Public bug reported:

Binary package hint: gnumeric

This is gnumeric 1.7.0

The offset function apparently does not work when it should return a
range, but works when it returns a single cell.  The attached sheet
demonstrates the problem.

In A4 i have =sum(offset(A3,-2,1)), which is a 1x1 range, and everything
is well.

In A5 I have =sum(offset(A3:A4,-2,1)), which is a 2x1 range, and #VALUE
is returned.

In A5 I have =sum(offset(A3,-2,1,2,1)), which is a 2x1 range, and #VALUE
is returned.

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

-- 
offset only works for a one-cell range
https://launchpad.net/bugs/83048