https://bz.apache.org/bugzilla/show_bug.cgi?id=65988
--- Comment #12 from Yegor Kozlov <[email protected]> --- Created attachment 38240 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38240&action=edit RATE function fixes Use the implementation of RATE ported from the NumPy library: https://github.com/numpy/numpy/blob/648fe68f79dfbad21947db4b55873703db0675c4/numpy/lib/financial.py#L580-L650 I added a few more unit tests from the LibreOffice documentation (https://wiki.documentfoundation.org/Documentation/Calc_Functions/RATE) and NumPy tests (https://github.com/numpy/numpy-financial/blob/master/numpy_financial/tests/test_financial.py) One test case is still disabled: RATE(3,10,900,1,0,0.5) does not converge in Excel and LibreOffice , but POI and NumPy return a result. Other examples of infeasible solutions pass, only this one fails. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
