[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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
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:

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
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

Reply to: