[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Fixed released with saucy as it was fixed upstream with 4.1.0.1. ** Changed in: libreoffice (Ubuntu) Status: Incomplete = Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Fix Released Status in “libreoffice” package in Ubuntu: Fix Released Bug description: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. Reproducible in Raring. WORKAROUND: Use Gnumeric. apt-cache policy gnumeric gnumeric: Installed: 1.12.1-1ubuntu1 Candidate: 1.12.1-1ubuntu1 Version table: *** 1.12.1-1ubuntu1 0 500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages 100 /var/lib/dpkg/status To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
** Changed in: df-libreoffice Status: Confirmed = Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Fix Released Status in “libreoffice” package in Ubuntu: Incomplete Bug description: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. Reproducible in Raring. WORKAROUND: Use Gnumeric. apt-cache policy gnumeric gnumeric: Installed: 1.12.1-1ubuntu1 Candidate: 1.12.1-1ubuntu1 Version table: *** 1.12.1-1ubuntu1 0 500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages 100 /var/lib/dpkg/status To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
** Description changed: - STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. - The result should be 0.1398, but LibreOffice shows -1.9474! + The result should be 0.1398, but LibreOffice shows -1.9474! - ADDITIONAL INFORMATION: - I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. + I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu + 12.04, 64-bit version, with up-to-date packages. + + Reproducible in Raring. + + WORKAROUND: Use Gnumeric. + apt-cache policy gnumeric + gnumeric: + Installed: 1.12.1-1ubuntu1 + Candidate: 1.12.1-1ubuntu1 + Version table: + *** 1.12.1-1ubuntu1 0 + 500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages + 100 /var/lib/dpkg/status ** Tags added: amd64 i386 precise raring -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Incomplete Bug description: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. Reproducible in Raring. WORKAROUND: Use Gnumeric. apt-cache policy gnumeric gnumeric: Installed: 1.12.1-1ubuntu1 Candidate: 1.12.1-1ubuntu1 Version table: *** 1.12.1-1ubuntu1 0 500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages 100 /var/lib/dpkg/status To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
** Summary changed: - LibreOffice Calc's RATE function sometimes produces incorrect results!!! + LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
upstreamed, note upstream comments ** Bug watch added: freedesktop.org Bugzilla #65082 https://bugs.freedesktop.org/show_bug.cgi?id=65082 ** Also affects: df-libreoffice via https://bugs.freedesktop.org/show_bug.cgi?id=65082 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Unknown Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Björn: thank you for upstreaming it. Let me try and explain why LibreOffice returning -1.9474... as the result of =RATE(50,35,-250,0) is really a *very* bad thing, and should be marked as a CRITICAL bug. I''ll try to provide an intuitive explanation without delving into too much math. Let's start with the simplest example. If you invest $250 today in exchange for receiving an annual payment of $35 *forever in perpetuity*, your annual return will be 35/250 = 0.14, or 14%/year. You can see that the formula for a perpetual annuity is Present Value = Annuity / Rate; hence Rate = Annuity / Present Value) in lots of websites. Here's the Wikipedia page on it: http://en.wikipedia.org/wiki/Time_value_of_money#Present_value_of_a_perpetuity Now imagine that instead of receiving the annual payments of $35 in perpetuity, you will receive them only for a fixed number of years. In this case, your annual return will necessarily be lower than 14%/year. The greater the number of years, the closer to 14%/year your annual rate of return will be. Specifically, your internal rate of return will asymptotically approach 14%/year as the number of years during which you will receive the annual payments increases to infinity. This is ***EXACTLY*** what I get in other spreadsheet programs, but NOT in LibreOffice. IT'S MATH. Since you guys are having problems with Excel, try these formulas in Google Spreadsheets, and you will see how the results asymptotically approach 14%: RATE(10, 35, -250, 0) returns 0.06637326 RATE(20, 35, -250, 0) returns 0.12724192 RATE(30, 35, -250, 0) returns 0.13702841 RATE(40, 35, -250, 0) returns 0.13923873 RATE(50, 35, -250, 0) returns 0.13979829 RATE(60, 35, -250, 0) returns 0.13994592 RATE(70, 35, -250, 0) returns 0.13998544 RATE(80, 35, -250, 0) returns 0.13999607 RATE(90, 35, -250, 0) returns 0.13999894 RATE(100, 35, -250, 0) returns 0.1371 Then go and try those formulas in LibreOffice. As I wrote before, returning an error would be a *LOT* better than the wrong number!!! -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Launchpad has imported 2 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=65082. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2013-05-28T14:59:06+00:00 Björn Michaelsen wrote: From downstream bug: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. Master shows the same -1.9474 result when last tested. Note that the RATE() function is iterative and even docs of MS Office say they might have zero or more solutions: http://office.microsoft.com/en-001/excel-help/rate-function-HP010342819.aspx As differences in calculation are sensitive this still warrants investigation. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/10 On 2013-05-28T15:00:59+00:00 Björn Michaelsen wrote: suggesting as a 4.1 MAB because of differences in result, please drop from MAB when considered non-critical. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/11 ** Changed in: df-libreoffice Status: Unknown = Confirmed ** Changed in: df-libreoffice Importance: Unknown = Medium -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
please continue discussion upstream, but restrict yourself to comments that help triaging the issue. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Björn: will do. Sorry if my comment was too long or had too much info. Thank you so much for your help! -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Incomplete Bug description: STEPS TO REPRODUCE: Type =RATE(50,35,-250,0) on any cell, and press Enter. The result should be 0.1398, but LibreOffice shows -1.9474! ADDITIONAL INFORMATION: I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp