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 497294 - OFFSET problem
OFFSET problem
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
unspecified
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-11-16 06:02 UTC by Andreas J. Guelzow
Modified: 2008-06-22 19:37 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Use the existing height/width (2.57 KB, patch)
2007-11-20 21:21 UTC, Jody Goldberg 		none Details | Review

Description Andreas J. Guelzow 2007-11-16 06:02:21 UTC 
B1  = 1
B2  = 1
B3  = 1
A5  = =sum(offset(A3:A4,-2,1))

I would expect the value in A5 to be 2, it turns out to be 3.
Comment 1 Jody Goldberg 2007-11-20 14:55:21 UTC 
You are correct.  We are double applying the width/height.
Comment 2 Jody Goldberg 2007-11-20 21:21:22 UTC 
Created attachment 99411 [details] [review]
Use the existing height/width

Needs review.
Comment 3 Morten Welinder 2007-11-21 03:35:54 UTC 
Looks ok to me (visually).  We ought to have a pile of tests.
Comment 4 Jody Goldberg 2007-11-24 20:53:20 UTC 
Patched in 1.7.90, still requires some tests.
Comment 5 Jody Goldberg 2008-06-22 19:34:06 UTC 
Tests added.