Issue 91651 - VDB function: Calc and Excel produce different results; both wrong
Summary: VDB function: Calc and Excel produce different results; both wrong
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-14 21:34 UTC by drking
Modified: 2014-03-25 10:51 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description drking 2008-07-14 21:34:57 UTC 
This is an isolated problem - only affects the year when depreciation is 
capped. The function in most normal use is OK.

VDB(100000;20000;10;7;8) returns 971.52 (correct)
VDB(100000;20000;10;7.25;7.75) returns 3276.80 (incorrect - can't be more!)
Excel97 returns 0 - that's wrong too. Should be 971.52/2 I think.

I've just finished a writeup of this function that (I hope) clarifies it fairly 
well:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_VDB_functio
n
The graphs should help illustrate the situation.
Comment 1 amy2008 2008-08-11 09:17:26 UTC 
Can reproduce it in DEV300_m28 on WinXP.
Comment 2 redflagzhulihua 2008-08-20 07:24:29 UTC 
So, set to New.