Bug#617595: libreoffice-base: date entry in Form grid ignores data entered in ISO 8601 format.
Package: libreoffice-base
Version: 1:3.3.1-1
Severity: normal
My system has a default locale of en_US. This means that dates
rewritten to match my locale come out like 02/27/11 (for 2011,
February 27th). I prefer to enter dates in ISO-8601 format
(2011-02-27) because of its lack of ambiguity. (i actually prefer to
view them that way too, but i haven't sorted out how to do that yet).
I start a fresh database with libreoffice-base. Make a new table with
a Date [DATE] column in it.
If i edit the table directly, i can enter dates in ISO-8601 format and
they get stored properly.
>From Forms, choose "Use Wizard to Create Form", and click "finish" to
get the default form with a grid view.
Open the form, and enter the date in ISO-8601 format. no matter what
date i enter, it gets re-written to today's date (03/09/11). It would
be pretty easy to enter a dozen dates before realizing tha the
rewriting is getting it wrong :(
If i enter a date in the locale format, it is accepted properly. Then
if i go back and re-enter it (for the same record) in ISO8601 format,
the old date is retained (rather than being set to the today's date).
Feel free to forward this upstream if you think that's appropriate.
I'm afraid i don't have the space (or time!) to install two versions
of libreoffice and test them side by side.
Thanks for maintaining libreoffice in debian!
--dkg
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing'), (200, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.37-2-686 (SMP w/1 CPU core)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages libreoffice-base depends on:
ii gcj-4.4-jre [java5-run 4.4.5-9 Java runtime environment using GIJ
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.5.2-4 GCC support library
ii libhsqldb-java 1.8.0.10-9 Java SQL database engine
ii libreoffice-base-core 1:3.3.1-1 office productivity suite -- share
ii libreoffice-core 1:3.3.1-1 office productivity suite -- arch-
ii libreoffice-java-commo 1:3.3.1-1 office productivity suite -- arch-
ii libstdc++6 4.5.2-4 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii ure 1.7.0+LibO3.3.1-1 LibreOffice UNO runtime environmen
libreoffice-base recommends no packages.
Versions of packages libreoffice-base suggests:
pn libmysql-java | libpg-java | <none> (no description available)
pn libreoffice-gcj <none> (no description available)
pn libreoffice-report-builder <none> (no description available)
ii libsqliteodbc 0.88-1 ODBC driver for SQLite embedded da
ii unixodbc 2.2.14p2-2 ODBC tools libraries
Versions of packages libreoffice-core depends on:
ii fontconfig 2.8.0-2.1 generic font configuration library
ii libatk1.0-0 1.30.0-1 The ATK accessibility toolkit
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
ii libcairo2 1.8.10-6 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.21.3-1 Multi-protocol file transfer libra
ii libdb4.8 4.8.30-4 Berkeley v4.8 Database Libraries [
ii libexpat1 2.0.1-7 XML parsing C library - runtime li
ii libfontconfig1 2.8.0-2.1 generic font configuration library
ii libfreetype6 2.4.4-1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.5.2-4 GCC support library
ii libglib2.0-0 2.28.1-1+b1 The GLib library of C routines
ii libgraphite3 1:2.3.1-0.2 SILGraphite - a "smart font" rende
ii libgstreamer-plugins 0.10.30-1 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.30-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.20.1-2 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.14-4 spell checker and morphological an
ii libhyphen0 2.7.1-3 ALTLinux hyphenation library - sha
ii libice6 2:1.0.7-1 X11 Inter-Client Exchange library
ii libicu44 4.4.2-2 International Components for Unico
ii libjpeg62 6b1-1 The Independent JPEG Group's JPEG
ii libmythes-1.2-0 2:1.2.1-1 simple thesaurus library
ii libneon27-gnutls 0.29.5-3 An HTTP and WebDAV client library
ii libnspr4-0d 4.8.7-2 NetScape Portable Runtime Library
ii libnss3-1d 3.12.8-2 Network Security Service libraries
ii libpango1.0-0 1.28.3-1+squeeze1 Layout and rendering of internatio
ii libpng12-0 1.2.44-1 PNG library - runtime
ii librdf0 1.0.13-2 Redland Resource Description Frame
ii libreoffice-common 1:3.3.1-1 office productivity suite -- arch-
ii libsm6 2:1.2.0-1 X11 Session Management library
ii libssl0.9.8 0.9.8o-5 SSL shared libraries
ii libstdc++6 4.5.2-4 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii libx11-6 2:1.4.1-5 X11 client-side library
ii libxaw7 2:1.0.9-2 X11 Athena Widget library
ii libxext6 2:1.2.0-2 X11 miscellaneous extension librar
ii libxinerama1 2:1.1.1-1 X11 Xinerama extension library
ii libxml2 2.7.8.dfsg-2 GNOME XML library
ii libxrandr2 2:1.3.1-1 X11 RandR extension library
ii libxrender1 1:0.9.6-1 X Rendering Extension client libra
ii libxslt1.1 1.1.26-6 XSLT 1.0 processing library - runt
ii libxt6 1:1.0.9-2 X11 toolkit intrinsics library
ii ttf-opensymbol 2:2.4.3+LibO3.3.1-1 OpenSymbol TrueType font
ii ure 1.7.0+LibO3.3.1-1 LibreOffice UNO runtime environmen
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages libreoffice-base is related to:
pn libmyodbc <none> (no description available)
pn libmysql-java <none> (no description available)
pn libpg-java <none> (no description available)
pn libsapdbc-java <none> (no description available)
ii libsqliteodbc 0.88-1 ODBC driver for SQLite embedded da
pn mdbtools <none> (no description available)
pn odbc-postgresql <none> (no description available)
pn tdsodbc <none> (no description available)
ii unixodbc 2.2.14p2-2 ODBC tools libraries
-- no debconf information
Reply to: