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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces incorrect results!!! 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 : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
