Issue 91651

Summary: VDB function: Calc and Excel produce different results; both wrong
Product: Calc Reporter: drking <openoffice>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: amy2008, issues, ooo.redflag
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=109420
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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.