Bug#343540: openoffice.org-calc: Broken behavior with cells containing '-'
This bug report is basically the same as
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
I can reproduce the problem both on x86/unstable and powerpc/unstable.
-- 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 18.104.22.168
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