https://bugs.documentfoundation.org/show_bug.cgi?id=91758
Bug ID: 91758
Summary: dash delimited dates entered are not correctly
interpreted as Y-M-D in specific cases
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Localization
Assignee: [email protected]
Reporter: [email protected]
"5-1-15" (entered today 2015-05-30 into a Calc cell) will result
in "05.01.15" being meant to mean 2015-01-05 in a German locale.
It will end up with "05/01/15" meaning 2015-05-01 im a US-English locale.
"5-13-14" will not be recognised as a date in both these locales. It is
assigned to the cell as a text. This may supposedly be triggered by the fact
that 13 isn't a valid number for a month.
The examples are from a question posted in
http://ask.libreoffice.org/en/question/51340/why-does-date-format-only-work-on-dates-less-than-13/
and tested by me in V4.4.3 Calc under both mentioned locales. The questioner
was much irritated because he expects the date value 2014-05-13 for the second
input.
The only locale independent date format named in ODF 1.2 is the complete
YYYY-MM-DD format from ISO 8601 (with 4 digit year). Allowing for sloppy
abbreviations may meet the expectations of some users. It's a mess
nevertheless. If any abbreviation in dash delimited dates shall be accepted it
should, however, be restricted to variants of Y-M-D formats without exception.
The present behaviour, as described, is error-prone including risks much
exceeding the very small possible use of trying to adapt the "recognition" to
locales.
--
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
