https://bugs.freedesktop.org/show_bug.cgi?id=59694
Priority: medium
Bug ID: 59694
Assignee: [email protected]
Summary: Data recognition in libreoffice Calc fails
(inconsistent with locale and date format of cell)
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.6.2.2 release
Component: Spreadsheet
Product: LibreOffice
Using Calc, in a cell formatted with date as day/month/year (e.g.:
21/Jan/2013), and in a system set with locale to be the same (day/month/year),
if I type:
If I type:
21Jan (all together, no spaces)
The cell "recognizes" wrongly: 01/Jan/2021
If I type:
Jan21 (all together, no spaces)
The cell recognizes (unexpectedly, given my locale): 21/Jan/2013
In M$ Excel, the cell format defines how to "guess" and convert strings into
dates as one would naturally expect. If the cell is formatted as date as
"day/month/year", then entering 21Jan is converted into 21/Jan/2013.
Unfortunately Libreoffice seems hardwired to recognize only US/Northamerica
date format (ignoring even the locale of the OS (I use linux/ubuntu 12.10 BTW)
which has been an annoyance since I started to use Calc daily.
Libreoffice should "recognize" (convert) strings into dates with a more
intuitive heuristic based on the date format that the user set for the cell, or
at least based on the locale that was set for the OS
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
