Bug#504604: openoffice.org-calc: current lenny version do not read files made with 3.0
Package: openoffice.org-calc
Version: 1:2.4.1-11
Severity: grave
Justification: causes non-serious data loss
Actually: it does not even read files made whit 2.3 !!!!
i prepared an xls file usind a 2.0 version of ooo.
i updated many times, until about 20 days ago was ok.
now it is no longer read.
It does not depend on format (either ods or xls have the same problem)
some cells give error 529.
These are cells that have in the formula:
in R10: IF(T10-Z10<>0;T10-Z10;R$6)
in W10: SUM(R9:R11)
if T10-Z10 evaluate to a non zero value it is ok, if it is 0
(or better T10 is empty, Z0 in my files is always empty) instead
it shows the error.
R$6 cell is actually an empty string.
If i change to a 0 or an empty cell the formula in return in R10: [numeric] 0.
Using previous version or even 3.0 in R10 return an empty string
(so it does not show anything in the display, that was the requirement)
and in W10 just the value of (R9+R11) ignoring the empty string value .
Can you fit this behaviour OR as an alternative make 3.0 immediately available on lenny ?
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.20-1-686 (SMP w/1 CPU core)
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
Versions of packages openoffice.org-calc depends on:
ii libc6 2.7-15 GNU C Library: Shared libraries
ii libgcc1 1:4.3.2-1 GCC support library
ii libstdc++6 4.3.2-1 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-3.2 STLport C++ class library
ii libsuitesparse-3.1.0 3.1.0-3 collection of libraries for comput
ii lp-solve 5.5.0.10-10 Solve (mixed integer) linear progr
pn openoffice.org-base-core <none> (no description available)
pn openoffice.org-core <none> (no description available)
openoffice.org-calc recommends no packages.
openoffice.org-calc suggests no packages.
Versions of packages openoffice.org-core depends on:
ii fontconfig 2.6.0-1 generic font configuration library
ii libc6 2.7-15 GNU C Library: Shared libraries
ii libcairo2 1.6.4-6.1 The Cairo 2D vector graphics libra
ii libcurl3 7.18.2-7 Multi-protocol file transfer libra
ii libdb4.6 4.6.21-11 Berkeley v4.6 Database Libraries [
ii libexpat1 2.0.1-4 XML parsing C library - runtime li
ii libfreetype6 2.3.7-2 FreeType 2 font engine, shared lib
ii libgcc1 1:4.3.2-1 GCC support library
ii libglib2.0-0 2.16.6-1 The GLib library of C routines
ii libgstreamer-plugins-b 0.10.20-1 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.20-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.12.11-4 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.6-1 spell checker and morphological an
ii libhyphen0 2.4-4 ALTLinux hyphenation library - sha
ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library
ii libicu38 3.8.1-3 International Components for Unico
ii libjpeg62 6b-14 The Independent JPEG Group's JPEG
ii libldap-2.4-2 2.4.11-1 OpenLDAP libraries
ii libneon27 0.28.2-5 An HTTP and WebDAV client library
ii libnspr4-0d 4.7.1-4 NetScape Portable Runtime Library
ii libnss3-1d 3.12.0-5 Network Security Service libraries
ii libpam0g 1.0.1-4 Pluggable Authentication Modules l
ii libpango1.0-0 1.20.5-3 Layout and rendering of internatio
ii libsm6 2:1.0.3-2 X11 Session Management library
pn libssl0.9.8 <none> (no description available)
ii libstdc++6 4.3.2-1 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-3.2 STLport C++ class library
ii libx11-6 2:1.1.5-2 X11 client-side library
ii libxaw7 2:1.0.4-2 X11 Athena Widget library
ii libxext6 2:1.0.4-1 X11 miscellaneous extension librar
ii libxinerama1 2:1.0.3-2 X11 Xinerama extension library
ii libxml2 2.6.32.dfsg-4 GNOME XML library
ii libxrender1 1:0.9.4-2 X Rendering Extension client libra
ii libxslt1.1 1.1.24-2 XSLT processing library - runtime
ii libxt6 1:1.0.5-3 X11 toolkit intrinsics library
ii libxtst6 2:1.0.3-1 X11 Testing -- Resource extension
pn openoffice.org-common <none> (no description available)
pn ttf-opensymbol <none> (no description available)
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
-- no debconf information
Reply to: