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

Bug#513349: marked as done (openoffice.org-calc: OOcalc mishandling DAYS function)

Your message dated Sun, 7 Jun 2009 20:54:12 +0200
with message-id <20090607185412.GD18692@torres.zugschlus.de>
and subject line Re: Bug#513349: openoffice.org-calc: OOcalc mishandling DAYS function
has caused the Debian Bug report #513349,
regarding openoffice.org-calc: OOcalc mishandling DAYS function
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 this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
513349: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=513349
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
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

--- End Message ---
--- Begin Message --- 
On Sun, Feb 01, 2009 at 07:21:45PM +0100, Rene Engelhard wrote:
> Marc, can we close this?

Yes. The upstream issue even has a workaround, by subtracting the two
cells directly. It would be great if OOo Calc would automatically
translate this on Excel save.

Greetings
Marc

-- 
-----------------------------------------------------------------------------
Marc Haber         | "I don't trust Computers. They | Mailadresse im Header
Mannheim, Germany  |  lose things."    Winona Ryder | Fon: *49 621 72739834
Nordisch by Nature |  How to make an American Quilt | Fax: *49 3221 2323190

--- End Message ---
Reply to: