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 654941 - INTERPOLATION problem with missing values in target argument
INTERPOLATION problem with missing values in target argument
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other Linux
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-07-20 05:21 UTC by Andreas J. Guelzow
Modified: 2011-07-20 06:43 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
suggested patch (708 bytes, patch)
2011-07-20 06:25 UTC, Andreas J. Guelzow
committed Details | Review

Description Andreas J. Guelzow 2011-07-20 05:21:00 UTC
I just rewrote gnumeric_interpolation to use collect_float_pairs. In testing the new implementation I noticed the following issue which I also confirmed in the previous implementation (ie. I didn't just introduce it):

------------------------------------------
#1:

A1:A3  1,2,3
B1:B3  1,2,3
C2:C4  1,2,3

in E1:E2 enter the array function:
=interpolation(A1:A3,B1:B3,C1:C4)

I would expect to see the result:
#VALUE
1
2
3
but indeed observe
#VALUE
0
1
2

This is clearly not correct.

------------------------------------------
#2

A1:A3  1,2,3
B1:B3  1,2,3
G1:G4  1,2,,3 (ie, G3 remains empty)

in H1:H4 enter the array formula
=interpolation(A1:A3,B1:B3,G1:G4)

I would expect to see the result
1
2
#VALUE!
3

but indeed observe
1
2
#VALUE!
0

This is clearly not correct.
Comment 1 Andreas J. Guelzow 2011-07-20 06:25:14 UTC
Created attachment 192273 [details] [review]
suggested patch
Comment 2 Andreas J. Guelzow 2011-07-20 06:43:36 UTC
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.