[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
I really don't know what else to tell you... Did you try them in Google Spreadsheets? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
Christopher: What specific version of Excel? Excel 2003 on a Windows XP VM under VirtualBox. To get the answer, you must enable iterative calculations, increase the number of iterations, and lower the maximum change per iteration. Otherwise you will get the #NUM! error. Unfortunately, this was not a different, exact command Try these, then: =RATE(50,36,-250,0) =RATE(50,37,-250,0) =RATE(50,38,-250,0) =RATE(50,39,-250,0) =RATE(50,40,-250,0) These RATE functions are supposed to return the internal rate of return of investing -250 in exchange for receiving a recurring payiment of respectively 36, 37, 38, 39, and 40 per period for a total of 50 periods, with no payment at the end. LibreOffice returns a nonsensical answer in ALL of these cases!!! -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
PS. It would be a LOT better if LibreOffice returned a #NUM! error instead of an incorrect number. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
F.H., regarding the following in Microsoft Office Professional Plus 2010 Word Version 14.0.6023.1000 (32-bit) : =RATE(50,35,-250,0) =RATE(50,36,-250,0) =RATE(50,37,-250,0) =RATE(50,38,-250,0) =RATE(50,39,-250,0) =RATE(50,40,-250,0) all of these produce errors. Excel Options - Formulas - checked checkbox Enable iterative calculation - Maximum Iterations 32767 (maximum allowed by Excel) - Maximum Change 1E-99 (maximum allowed by Excel). Could you please advise? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
F.H., regarding your comments https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/4 : ...and on Microsoft Excel: What specific version of Excel? =RATE(50,35,-250,0) Unfortunately, this was not a different, exact command as previously requested in https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/3 . -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
F.H. thank you for reporting this and helping make Ubuntu better. As per Excel Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit), the result of: =RATE(B5,B4,B3,0) is: #NUM! Could you please provide a different, exact command that demonstrates this problem? ** Project changed: df-libreoffice = libreoffice (Ubuntu) ** Changed in: libreoffice (Ubuntu) Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
Christopher -- sure. I just tried this on Google Drive's Spreadsheet and on Microsoft Excel: =RATE(50,35,-250,0) The result in both cases is approximately 0.1398. When I try the same formula in LibreOffice, I get a nonsensical answer. (I sure hope no one out there is using this function to calculate important financial figures!) I'm using LibreOffice 3.5.7.2 Build ID: 350m1(Build:2) on Ubuntu 12.04 64-bit. Hope this is helpful. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
