Your message dated Mon, 17 Aug 2015 09:57:22 +0200
with message-id <[email protected]>
and subject line Re: Bug#615832: Processed: Re: Bug#615832: libreoffice-calc:
Filter by date isn't working while, date is set in non-English format
has caused the Debian Bug report #615832,
regarding libreoffice-calc: Filter by date isn't working while date is set in
non-English format
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 [email protected]
immediately.)
--
615832: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=615832
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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 ---
Version: 1:5.0.1~rc1-1
Hi Eike, $submitter,
On Mon, Aug 17, 2015 at 09:44:35AM +0200, Eike Rathke wrote:
> I believe this is upstream
> https://bugs.documentfoundation.org/show_bug.cgi?id=92767
> which has been fixed for 4.4.6 and 5.0.1
Thanks for the info. Closing appropriately then as we already have
5.0.1 rc1 (where this is included afaics) in unstable :)
Regards,
Rene
--- End Message ---