To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53845
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Aug 27 05:21:04 -0700
2005 -------
You are right, I found the same formula in other places, for example in
http://en.wikipedia.org/wiki/Net_present_value.
I guess that this could be changed easily by starting "nCount = 0.0" in stead of
"nCount = 1.0" in the code in interpr2.cxx. But I see two problems. (1)Such a
change would affect the results of older sheets. (2)At least Excel97 calculates
in the same way than OOo.
You can get the correct result, if you add C0 to the NPV-result. But how should
you know, that you have to do it? So I think, that it is necessary, that the
online help becomes more precise.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
