Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-0":
http://cgit.freedesktop.org/libreoffice/core/commit/?id=fa270848936d2ca9ddd312fc551ab189896b9417&h=libreoffice-4-0 resolved fdo#65082 RATE function should not find roots <= -1 It will be available in LibreOffice 4.0.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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
