--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: libreoffice-calc: Filter by date isn't working while date is set in non-English format
- From: The Nonetheless <thenonetheless@ya.ru>
- Date: Mon, 28 Feb 2011 14:06:00 +0300
- Message-id: <20110228110600.1510.40225.reportbug@lagutin.RVT>
Package: libreoffice-calc
Version: 1:3.3.1~rc1-2
Severity: important
Tags: l10n
Good day.
If there is a column with dates and you trying to apply a Standard Filter to it, e.g. «Field name» = «date», «Condition» = «>=», «Value» = «11.02.2011» it filters out the whole table because it thinks there are no coincidences with the «11.02.2011» value. It seeks for the «40585» value (although all the dates fields have a «Date» format) and when it's being set in Standard Filter, filtering works fine.
I have noticed, that this issue doesn't complain where dates are set in the «Default - English (USA)» format. e. g. «12/31/99». Solution is to set «Default - English (USA)» in the «Language» section and apply «DD.MM.YYYY» mask or whatever you need. Not the rather obvious way, because the user at first tries to change the «Language». And I think it's necessary to say, that actual stable version of OpenOffice from the Debian Repository isn't have this issue (I have just migrated).
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing'), (50, 'unstable'), (10, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.37-1-amd64 (SMP w/2 CPU cores)
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 libreoffice-calc depends on:
ii libc6 2.11.2-11 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.5-12 GCC support library
ii libreoffice-base-c 1:3.3.1~rc1-2 office productivity suite -- share
ii libreoffice-core 1:3.3.1~rc1-2 office productivity suite -- arch-
ii libstdc++6 4.4.5-12 The GNU Standard C++ Library v3
ii lp-solve 5.5.0.13-7 Solve (mixed integer) linear progr
ii ure 1.7.0+LibO3.3.1~rc1-2 LibreOffice UNO runtime environmen
libreoffice-calc recommends no packages.
libreoffice-calc suggests no packages.
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.2-2.1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.4.5-12 GCC support library
ii libglib2.0-0 2.24.2-1 The GLib library of C routines
ii libgraphite3 1:2.3.1-0.2 SILGraphite - a "smart font" rende
ii libgstreamer-plu 0.10.30-1 GStreamer libraries from the "base
ii libgstreamer0.10 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- 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.6-1 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.10-3 Redland Resource Description Frame
ii libreoffice-comm 1:3.3.1~rc1-2 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.4.5-12 The GNU Standard C++ Library v3
ii libx11-6 2:1.4.1-4 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~rc1-2 OpenSymbol TrueType font
ii ure 1.7.0+LibO3.3.1~rc1-2 LibreOffice UNO runtime environmen
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
-- no debconf information
--- End Message ---
--- Begin Message ---
tags 615832 wontfix
thanks
On Mon, Feb 28, 2011 at 02:06:00PM +0300, The Nonetheless wrote:
If there is a column with dates and you trying to apply a Standard Filter to it, e.g. Field name = date, Condition = >=,
Value = 11.02.2011 it filters out the whole table because it thinks there are no coincidences with the 11.02.2011 value.
When you use Standard Filter, or many other dialogs, LO will use the
Locale setting and Date acceptance pattern setting from Tools -> Options
-> Language Settings -> Languages
So if you want it to recognise the input '11.02.2011', you need to make
sure that either your Locale is set to one that will recognise the date
as entered, or you need to enter the date in your current locale's
format. This is independent of the way in which the date is displayed in
the cell in question.
I hope that solves your question. Sorry it took so long to answer your
report!
Chris
--- End Message ---