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 790299 - VDB
VDB
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: 2017-11-13 17:28 UTC by Andreas J. Guelzow
Modified: 2017-11-15 00:37 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Tentative patch (3.45 KB, patch)
2017-11-14 00:32 UTC, Morten Welinder 		none Details | Review

Description Andreas J. Guelzow 2017-11-13 17:28:15 UTC 
=vdb(100000,20000,10,7,8) evaluates to 971.52
=vdb(100000,20000,10,7.25,7.75) evaluates to 3276.80

These cannot be both correct. (It seems te former is correct and the later should be closer to 971.52/2.

See also https://bugs.documentfoundation.org/show_bug.cgi?id=101204
Comment 1 Morten Welinder 2017-11-13 18:17:30 UTC 
That's some ugly code we're dragging around there.

I would take a guess that the problem is that get_vdb's for-loop
is not prepared to deal with nLoopStart==nLoopEnd.

Unrelatedly, one can surely also cause a hang by supplying sufficiently
large start and end values.
Comment 2 Morten Welinder 2017-11-13 18:28:09 UTC 
https://stackoverflow.com/questions/36322039/actual-ms-excel-formula-for-vdb
looks useful.
Comment 3 Morten Welinder 2017-11-14 00:32:59 UTC 
Created attachment 363549 [details] [review]
Tentative patch
Comment 4 Morten Welinder 2017-11-15 00:37:34 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.