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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org