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: