I really don't know what else to tell you...
Did you try them in Google Spreadsheets?
--
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 functi
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
PS. It would be a LOT better if LibreOffice returned a #NUM! error
instead of an incorrect number.
--
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
Christopher:
> What specific version of Excel?
Excel 2003 on a Windows XP VM under VirtualBox. To get the answer, you
must enable iterative calculations, increase the number of iterations,
and lower the maximum change per iteration. Otherwise you will get the
#NUM! error.
> Unfortunately, this
F.H., regarding your comments
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/comments/4 :
>"...and on Microsoft Excel:"
What specific version of Excel?
>" =RATE(50,35,-250,0)"
Unfortunately, this was not a different, exact command as previously
requested in
https://bugs.laun
Christopher -- sure. I just tried this on Google Drive's Spreadsheet
and on Microsoft Excel:
=RATE(50,35,-250,0)
The result in both cases is approximately 0.1398.
When I try the same formula in LibreOffice, I get a nonsensical answer.
(I sure hope no one out there is using this function to calc
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?
** Projec
7 matches
Mail list logo