Red Hat Bugzilla – Bug 400151
[fix available] xirr function in oocalc always returns 0 (x86_64 only)
Last modified: 2008-05-21 13:46:44 EDT
Description of problem:
The xirr function should calculate the internal rate of return of a series of
cash flows. Instead it always returns 0. This does not appear to be a problem
with i386 machines, only x86_64 on RHEL5. oocalc version 1.1 from RHEL 4 x86_64
does not have this problem either.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Open the attached spreadsheet
2. See the wrong answer in cell B3
Additional info: It's kind of hard for me to believe that nobody has ever
noticed such an obvious (and important) bug before but I cannot find an existing
bug report. I've tried on three different machines and it's consistent so I
don't think it is just me.
Created attachment 269301 [details]
A very simple xirr spreadsheet
The x86_64 uno bridge had a problem returning doubles, you should also see that
"RANDBETWEEN(100;200)" returns 0, not a number between 100 and 200. Odd eh,
should be good in 2.3.0 coming soon to RHEL-5.2
RHEL-5.2 includes 2.3.0 which has this fix in it.
For more information on where to find the updated files, please follow the link
below. You may reopen this bug report if the solution does not work for you.