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
