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

Bug#513349: openoffice.org-calc: OOcalc mishandling DAYS function



Package: openoffice.org-calc
Version: 1:2.4.1-17
Severity: normal

Start a new OOcalc
Open a new Speadsheet
Enter one date in A1 ("2009-01-20")
Enter another date in A2 ("2008-12-28")
Enter "=days(A2;A1)" into A3 (resulting in -23)
Save as Excel 97/2000/XP
Close.
Re-Open.
See "#MACRO?" error in A3.
Edit A3, change any character, and change it back immediately
See correct value again.

Greetings
Marc



-- System Information:
Debian Release: 5.0
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.28.2-nc8000 (PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages openoffice.org-calc depends on:
ii  libc6                        2.7-18      GNU C Library: Shared libraries
ii  libgcc1                      1:4.3.3-1   GCC support library
ii  libstdc++6                   4.3.3-1     The GNU Standard C++ Library v3
ii  libstlport4.6ldbl            4.6.2-3.2   STLport C++ class library
ii  libsuitesparse-3.1.0         1:3.1.0-3.1 collection of libraries for comput
ii  lp-solve                     5.5.0.10-10 Solve (mixed integer) linear progr
ii  openoffice.org-base-core     1:2.4.1-17  OpenOffice.org office suite -- lib
ii  openoffice.org-core          1:2.4.1-17  OpenOffice.org office suite archit

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-3           generic font configuration library
ii  libc6                  2.7-18            GNU C Library: Shared libraries
ii  libcairo2              1.6.4-7           The Cairo 2D vector graphics libra
ii  libcurl3               7.18.2-8          Multi-protocol file transfer libra
ii  libdb4.6               4.6.21-13         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.3-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-6.1        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-5           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
ii  libssl0.9.8            0.9.8g-15         SSL shared libraries
ii  libstdc++6             4.3.3-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-5     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 
ii  openoffice.org-common  1:2.4.1-17        OpenOffice.org office suite archit
ii  ttf-opensymbol         1:2.4.1-17        The OpenSymbol TrueType font
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

-- no debconf information



Reply to: