[Bug 83048] offset only works for a one-cell range
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
[Bug 83048] offset only works for a one-cell range
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
[Bug 83048] offset only works for a one-cell range
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
[Bug 83048] offset only works for a one-cell range
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
[Bug 83048] offset only works for a one-cell range
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
[Bug 83048] offset only works for a one-cell range
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
