Bug#373252: marked as done (openoffice.org-calc: Some expressions fail on empty cells.)
Your message dated Mon, 19 Jun 2006 17:22:01 +0200
with message-id <200606191722.02258.rene@debian.org>
and subject line Bug#373252: openoffice.org-calc: Some expressions fail on empty cells.
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Version: 2.0.2-3
Am Montag, 19. Juni 2006 16:47 schrieb John McMonagle:
> Loaded unstable version and it works properly.
Thanks. Closing with appropriate info.
Regards,
Rene
--
.''`. René Engelhard -- Debian GNU/Linux Developer
: :' : http://www.debian.org | http://people.debian.org/~rene/
`. `' rene@debian.org | GnuPG-Key ID: 248AEB73
`- Fingerprint: 41FA F208 28D4 7CA5 19BB 7AD9 F859 90B0 248A EB73
--- End Message ---
Reply to: