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-----
xirr-demo1-amd64.ods
Description: Zip archive
xirr-demo1-amd64.pdf
Description: Adobe PDF document
xirr-demo1-i386.ods
Description: Zip archive
xirr-demo1-i386.pdf
Description: Adobe PDF document