To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=15090
------- Additional comments from [EMAIL PROTECTED] Sat Feb 16 20:43:07 +0000 2008 ------- I had a closer look at the problem. Gnumeric 1.6.3 (Windows) returns the value 0 if the algorithm doesn't converge. That is not correct. Excel returns an error, if the calculated value is smaller than -1. I don't think we should follow Excel, because those values are still solutions to the equation, which is given in the ODFF spec. Gnumeric shows such values. What I have done: (1) Introduce a test for Nper<=0 because ODFF constraints it that way. (2) Made a case distinction for Nper integer or not. In ODFF spec it is not yet decided whether non inter Nper are allowed. If the non integer Nper will be forbidden, the case can easily be removed. With this distinction, we get additional values as they are calculated in Gnumeric. (3) Catch special case "solution on an extreme". (4) Remove setting non zero PayType to 1, because other values than 0 or 1 are meaningful and can easily be handled. ODFF spec is not precise in that area. The text includes comments, so that you can enable the statements, if you don't like to follow my decision concerning PayType or validity of results <-1. Additional remark to ODFF spec: The given equation is not defined for a solution RATE=0. But such situations are possible. Changing the equation to a version with geometric series instead of the version with fraction would solve that problem and force Nper to be integer. The patches are based on m244 with CWS odff. --------------------------------------------------------------------- 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]
