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
--
desktop-bugs mailing list
desktop-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/desktop-bugs
