Bug#418541: openoffice.org-calc: XIRR calculation wrong on amd64

[Kai Juse <KaiJuse@t-online.de>]

Package: openoffice.org-calc
Version: 2.0.4.dfsg.2-7
Severity: normal

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

oocalc appears to mis-calculate the XIRR function (internal rate of return) on amd64. Example:

01.01.05 1000
01.01.06 -600
01.01.07 -600

i386 --> 13,0662% (expected)
amd64 ->  0,0000% 

I created a test-file (attached) with 2.0.4.dfsg.2-7 on amd64 (showing 0%), opended it on i386 (2.0.4.dfsg.2-5etch1; 
showing  13%) and saved it there for comparison (also attached). Here the probably most relevant part of the diff of 
content.xml:

- -          <table:table-cell table:style-name="ce2" 
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXirr([.B1:.B3];[.A1:.A3];0.2)" office:value-type="percentage" 
office:value="1.43069306930693E-321">
- -            <text:p>0.0000%</text:p>
+          <table:table-cell table:style-name="ce2" 
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXirr([.B1:.B3];[.A1:.A3];0.2)" office:value-type="percentage" 
office:value="0.130662386291807">
+            <text:p>13,0662%</text:p>

I upgraded ooo on i386 to match the amd64 version with no change in observed behavior. 

I am ready to provide more info or test things as needed.

- -- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages openoffice.org-calc depends on:
ii  libc6                     2.3.6.ds1-13   GNU C Library: Shared libraries
ii  libgcc1                   1:4.1.1-21     GCC support library
ii  libstdc++6                4.1.1-21       The GNU Standard C++ Library v3
ii  libstlport4.6c2           4.6.2-3        STLport C++ class library
ii  libufsparse               1.2-7          collection of libraries for comput
ii  openoffice.org-core       2.0.4.dfsg.2-7 OpenOffice.org office suite archit

openoffice.org-calc recommends no packages.

- -- no debconf information

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGG4Sr0bFYwuxg7eMRAtrmAJ4qZWoj6nhkUmsb9ILPEZ3rXlqbLACeK0Pd
MYgRhmuxRXuQmOx+XUsvLrk=
=33nI
-----END PGP SIGNATURE-----

Attachment: xirr-demo1-amd64.ods
Description: Zip archive

Attachment: xirr-demo1-amd64.pdf
Description: Adobe PDF document

Attachment: xirr-demo1-i386.ods
Description: Zip archive

Attachment: xirr-demo1-i386.pdf
Description: Adobe PDF document