[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#615832: marked as done (libreoffice-calc: Filter by date isn't working while date is set in non-English format)

Your message dated Mon, 17 Aug 2015 09:57:22 +0200
with message-id <20150817075722.GI3657@rene-engelhard.de>
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 owner@bugs.debian.org
immediately.)


-- 
615832: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=615832
Debian Bug Tracking System
Contact owner@bugs.debian.org 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 ---
Reply to: