Bug 400151 - [fix available] xirr function in oocalc always returns 0 (x86_64 only)
Summary: [fix available] xirr function in oocalc always returns 0 (x86_64 only)
Alias: None
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: openoffice.org   
(Show other bugs)
Version: 5.1
Hardware: x86_64 Linux
Target Milestone: ---
: ---
Assignee: Caolan McNamara
QA Contact: desktop-bugs@redhat.com
Depends On:
TreeView+ depends on / blocked
Reported: 2007-11-26 21:19 UTC by William D. Hamblen
Modified: 2008-05-21 17:46 UTC (History)
0 users

Fixed In Version: RHEL-5.2
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2008-05-21 17:46:44 UTC
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 21:19 UTC, William D. Hamblen
no flags Details

Description William D. Hamblen 2007-11-26 21:19:08 UTC
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 21:19:08 UTC
Created attachment 269301 [details]
A very simple xirr spreadsheet

Comment 2 Caolan McNamara 2007-11-26 22:56:25 UTC
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 17:46:44 UTC
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.