F.H. thank you for reporting this and helping make Ubuntu better. As per Excel
Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit),
the result of:
=RATE(B5,B4,B3,0)
is:
#NUM!
Could you please provide a different, exact command that demonstrates
this problem?
** Project changed: df-libreoffice => libreoffice (Ubuntu)
** Changed in: libreoffice (Ubuntu)
Status: New => Incomplete
--
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