Bug#373252: openoffice.org-calc: Some expressions fail on empty cells.
Package: openoffice.org-calc
Version: 2.0.1-5
Severity: important
I do not use spread sheets so pardon me if I use the wrong terms..
Finding spreadsheets from openoffice 1.0.3 that used to work now fail.
If an expression references blank cells the result will be #value!
Also note the cell must have never had anything in it
The simplest case I have seen is something like =D6-C6
If for example in the case above you put a number in cell D6 and C6 the
result will be 0.
If you then delete the values the result will remain 0.
Both calc the current backports and testing do this.
I was told that openoffice 2.01 in fedora 4 works properly.
I also verified that 2.02 for windows works properly.
Attached is a time sheet spread sheet.
It was converted from openoffice 1.0.3
There may be some fields that need a smaller font that has ###.
For example if you go to the time sheet part at 05-29 and put 0 in all 6
spaces and then remove it it will work.
Also on the Mileage_Expenses sheet if you put in 0 in the begin and end
field and then remove it will work.
Just noticed in a new spreadsheet I put in something like =D6-C6 it
works but if I cut and paste a block from the attached sheet it fails.
Again this is only a problem in the debian port.
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (900, 'testing'), (200, 'unstable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16-2-686
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages openoffice.org-calc depends on:
ii libc6 2.3.6-13 GNU C Library: Shared libraries
ii libgcc1 1:4.1.0-4 GCC support library
ii libstdc++6 4.1.0-4 The GNU Standard C++ Library v3
ii libstlport4.6c2 4.6.2-3 STLport C++ class library
ii openoffice.org-core 2.0.1-5 OpenOffice.org office suite archit
openoffice.org-calc recommends no packages.
-- no debconf information
Reply to: