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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
