Package: openoffice.org-calc Version: 2.0.4.dfsg.2-7etch5 Severity: normal As per the subject, XIRR() function gives Err:502 when annualised return is < -30%.
I have an example spreadshhet and will attempt to attach it to this report. -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.18-6-686 Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Versions of packages openoffice.org-calc depends on: ii libc6 2.3.6.ds1-13etch7 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-7etch5 OpenOffice.org office suite archit openoffice.org-calc recommends no packages. -- no debconf information
OO_XIRR.ods
Description: Zip archive