Bug#558038: openoffice.org-base: paste from calc into base converts Calc date data into date serial integers, which then fails data conversion into a date column (on a MySql database)
Package: openoffice.org-base
Version: 1:3.1.1-8
Severity: normal
1. Make a spreadsheet with data formatted as dates and use row 1 for column headings.
2. Copy this data range and then paste into Base, which brings up a dialog to create a new table.
3a. If you choose a new table, then the date data is not recognised, and is pasted as text.
3b. If you paste onto an existing table where the matching column has a date type, the appending of the data fails because Base tries to import the date value as the serial integer representation of the date. MySql doesn't recognise this as a date and the import fails.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.31-6.slh.2-sidux-686 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages openoffice.org-base depends on:
ii default-jre [java5-runt 1.6-33 Standard Java or Java compatible R
ii libc6 2.10.2-2 GNU C Library: Shared libraries
ii libgcc1 1:4.4.2-3 GCC support library
ii libhsqldb-java 1.8.0.10-6 Java SQL database engine
ii libstdc++6 4.4.2-3 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii openjdk-6-jre [java5-ru 6b16-1.6.1-2 OpenJDK Java runtime, using Hotspo
ii openoffice.org-base-cor 1:3.1.1-8 full-featured office productivity
ii openoffice.org-core 1:3.1.1-8 full-featured office productivity
ii openoffice.org-java-com 1:3.1.1-8 full-featured office productivity
ii sun-java6-jre [java5-ru 6-16-1 Sun Java(TM) Runtime Environment (
ii ure 1.5.1+OOo3.1.1-8 OpenOffice.org UNO runtime environ
openoffice.org-base recommends no packages.
Versions of packages openoffice.org-base suggests:
ii libmyodbc 3.51.27r695-1 the MySQL ODBC driver
ii libmysql-java 5.1.10+dfsg-2 Java database (JDBC) driver for My
pn openoffice.org-gcj <none> (no description available)
pn openoffice.org-report-buil <none> (no description available)
ii unixodbc 2.2.11-21 ODBC tools libraries
Versions of packages openoffice.org-core depends on:
ii fontconfig 2.6.0-4 generic font configuration library
ii libc6 2.10.2-2 GNU C Library: Shared libraries
ii libcairo2 1.8.8-2 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.19.7-1 Multi-protocol file transfer libra
ii libdb4.8 4.8.24-1 Berkeley v4.8 Database Libraries [
ii libexpat1 2.0.1-5 XML parsing C library - runtime li
ii libfreetype6 2.3.11-1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.4.2-3 GCC support library
ii libglib2.0-0 2.22.2-2 The GLib library of C routines
ii libgstreamer-plugins-b 0.10.25-6 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.25-3 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.18.3-1 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.8-5 spell checker and morphological an
ii libhyphen0 2.4-6 ALTLinux hyphenation library - sha
ii libice6 2:1.0.6-1 X11 Inter-Client Exchange library
ii libicu42 4.2.1-3 International Components for Unico
ii libjpeg62 6b-15 The Independent JPEG Group's JPEG
ii libldap-2.4-2 2.4.17-2.1 OpenLDAP libraries
ii libneon27-gnutls 0.29.0-1 An HTTP and WebDAV client library
ii libnspr4-0d 4.8.2-1 NetScape Portable Runtime Library
ii libnss3-1d 3.12.4-1 Network Security Service libraries
ii librdf0 1.0.9-2+b1 Redland Resource Description Frame
ii libsm6 2:1.1.1-1 X11 Session Management library
ii libstdc++6 4.4.2-3 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii libx11-6 2:1.3.2-1 X11 client-side library
ii libxaw7 2:1.0.6-1 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.7.6.dfsg-1 GNOME XML library
ii libxrandr2 2:1.3.0-2 X11 RandR extension library
ii libxrender1 1:0.9.4-2 X Rendering Extension client libra
ii libxslt1.1 1.1.26-1 XSLT processing library - runtime
ii libxt6 1:1.0.6-1 X11 toolkit intrinsics library
ii libxtst6 2:1.0.3-1 X11 Testing -- Resource extension
ii openoffice.org-common 1:3.1.1-8 full-featured office productivity
ii ttf-opensymbol 1:3.1.1-8 OpenSymbol TrueType font
ii ure 1.5.1+OOo3.1.1-8 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.3.dfsg-15 compression library - runtime
Versions of packages openoffice.org-base is related to:
ii libmyodbc 3.51.27r695-1 the MySQL ODBC driver
ii libmysql-java 5.1.10+dfsg-2 Java database (JDBC) driver for My
pn libpg-java <none> (no description available)
pn libsapdbc-java <none> (no description available)
pn libsqliteodbc <none> (no description available)
pn mdbtools <none> (no description available)
pn odbc-postgresql <none> (no description available)
pn tdsodbc <none> (no description available)
ii unixodbc 2.2.11-21 ODBC tools libraries
-- no debconf information
Reply to: