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] Fri Apr 25 16:33:50 +0000 2008 ------- @Eike: 'I assume the "should" is to be considered purely mathematical' Yes. I have added rows 16 and 17 to investigate it. The formula in row 17 is similar to that in row 9 but uses the directly set values in row 16. Now when you change the last digit in row 16, you can see, that it is not possible to get zero in some cases. The other problem is the oscillating case (column J), where the algorithm gives no better solution, because it would be a great effort to detect and handle such oscillations. 'does allowing PayType other than 0 or 1 affect the functions FV, NPER, PMT and PV' That functions set other PayType than 0 to value 1 and will work in the same way as before. They are not affected directly. It is your decision whether to change them. The ODF says "It is 0 if payments are due at the end of the period; 1 if they are due at the beginning of the period." but it doesn't say what to do with other values than 0 or 1, and on the other hand doesn't constrain it to 0 and 1. Gnumeric uses different values than 0 and 1, Excel07 uses only 0 and 1. It is the same problem as for RATE. FV, NPER, PMT and PV use the same equation, so the same solution as in RATE should be possible. In addition that functions have the problem with non-integer Nper too. A decision in the ODF spec is needed badly. --------------------------------------------------------------------- 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]
