Bug 400151 - [fix available] xirr function in oocalc always returns 0 (x86_64 only)
[fix available] xirr function in oocalc always returns 0 (x86_64 only)
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: openoffice.org (Show other bugs)
x86_64 Linux
low Severity high
: ---
: ---
Assigned To: Caolan McNamara
Depends On:
  Show dependency treegraph
Reported: 2007-11-26 16:19 EST by William D. Hamblen
Modified: 2008-05-21 13:46 EDT (History)
0 users

See Also:
Fixed In Version: RHEL-5.2
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2008-05-21 13:46:44 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
A very simple xirr spreadsheet (7.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-11-26 16:19 EST, William D. Hamblen
no flags Details

  None (edit)
Description William D. Hamblen 2007-11-26 16:19:08 EST
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):

How reproducible:
Every time.

Steps to Reproduce:
1. Open the attached spreadsheet
2. See the wrong answer in cell B3
Actual results:

Expected results:

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.
Comment 1 William D. Hamblen 2007-11-26 16:19:08 EST
Created attachment 269301 [details]
A very simple xirr spreadsheet
Comment 2 Caolan McNamara 2007-11-26 17:56:25 EST
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
Comment 3 Caolan McNamara 2008-05-21 13:46:44 EDT
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.


Note You need to log in before you can comment on or make changes to this bug.