Bug#343540: openoffice.org-calc: Broken behavior with cells containing '-'
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/
Reply to: