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

Reply via email to