https://bugs.documentfoundation.org/show_bug.cgi?id=158633
Bug ID: 158633
Summary: Something is wrong with dates: they are not visible in
filter by formatted columns and are almost impossible
to edit.
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: der...@laafd.com
Description:
At formatted columns without year digits AutoFilter doesn't work properly.
It is no longer possible to use digital values to insert and edit dates.
Steps to Reproduce:
1.1. I have some formatted file from 2018; see bad_date-1.ods. It has two
columns with formatted dates without years digits: Q and X(the X column is a
link to column Q). These columns have AutoFlilter for them.
When I try to make filter by dates for them, the filter don't expose years
digits for them, thus they cannot be filtered correctly by dates taking into
account the year.
1a) I can filter dates by the way.To do this, I convert the dates into a
number format and apply a Standard Filter. For example for filtering May, 2018:
Column Q > 43220
AND Column Q < 43252
See bad_date-2.png. I do this trick in a copy of the file so as not to spoil
the main file.
1b) For version 6.4.7.2 AutoFilter works fine, see bad_date-3.png .
2. From version 7.6.3.2 something strange is happening with the dates
inserting.
Previously I could write in the Russian keyboard layout:
02.10. then press Enter and get the date in the current year => 02.10.2023.
Moreover, in the Russian locale I could use the English keyboard layout to
quickly set the date:
02/10/ then press Enter and get the date in the current year => 02.10.2023 or
another formatted date.
Today this method has stopped working. Moreover, full date entry does not
work:
02/10/2023 or 02.10.2023 are not formatted as a date anymore.
The only way left to enter the date is to enter the day and name of month for
the current year or the day, name of month and year for other years:
Dec 05 => 12/05/2023
Dec 05 2021 => 12/05/2021.
This input method does not allow you to substitute dates in formatted cells.
For example, in the table from the file bad_date-1.ods, in column A, you can
substitute the current date in the drop-down window. In the English locale this
formatting works, but in the Russian locale it does not work: numbers are
substituted, but they are not formatted as a date!
Actual Results:
1. Autofilter doesn't see formatted dates without year digits.
2. Entering date with digits only is impossible.
Expected Results:
1. Autofilter must to see full dates when formatted cells doesn't contain year
digits.
2. Entering dates with digits must to format cells as date formatted.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (ru_RU.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.3-0ubuntu0.22.04.1~lo1
Calc: threaded
Version 6.4.7.2 doesn't has these troubles.
--
You are receiving this mail because:
You are the assignee for the bug.
