Bug 400151

Summary: [fix available] xirr function in oocalc always returns 0 (x86_64 only)
Product: Red Hat Enterprise Linux 5 Reporter: William D. Hamblen <whamblen>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED CURRENTRELEASE QA Contact: desktop-bugs <desktop-bugs>
Severity: high Docs Contact:
Priority: low    
Version: 5.1   
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: RHEL-5.2 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-05-21 17:46:44 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
A very simple xirr spreadsheet none

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):
openoffice.org-calc-2.0.4-5.4.24

How reproducible:
Every time.

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

Expected results:
71.5%


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.

http://rhn.redhat.com/errata/RHBA-2008-0403.html