Package: openoffice.org-calc Version: 2.0.0-5 Severity: normal This bug report is basically the same as http://www.openoffice.org/issues/show_bug.cgi?id=57402 which as been closed (as WFM) because the problem seems to be specific to the Debian builds of OO.org
On Windows and, apparently, on non-Debian Linux builds, formulas seem to interpret '-' as 0, while on Debian builds '-' is interpreted as an illegal value. I have several spreadsheets which work fine on Windows but are broken on Linux because of this. How to reproduce: * Start a new spreadsheet * Enter a '-' in cells A1 and B1 * Set cell C1 to formula '=A1-B2' => Result on Windows: cell C1 contains '0' => Result on Linux: cell C1 contains '#VALUE!' Expected result: Same result on both Linux and Windows (whatever of the two results is deemed as correct) A spreadsheet demonstrating the problem can be found in the OO.org bug report: http://www.openoffice.org/nonav/issues/showattachment.cgi/31272/57402.ods I can reproduce the problem both on x86/unstable and powerpc/unstable. Juergen -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: powerpc (ppc64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.14.3 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.5-8 GNU C Library: Shared libraries an ii libgcc1 1:4.0.2-5 GCC support library ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3 ii libstlport4.6c2 4.6.2-3 STLport C++ class library ii openoffice.org-core 2.0.0-5 OpenOffice.org office suite archit openoffice.org-calc recommends no packages. -- no debconf information -- Juergen Kreileder, Blackdown Java-Linux Team http://blog.blackdown.de/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
