Download it now!
Bug 44636 - FORMATTING: NF-DATE: match input against date acceptance patterns to recognize as date
Summary: FORMATTING: NF-DATE: match input against date acceptance patterns to recogniz...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Master old -3.6
Hardware: All All
: medium major
Assignee: Eike Rathke
Depends on:
Reported: 2012-01-10 07:09 UTC by Eike Rathke
Modified: 2012-01-21 16:43 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Eike Rathke 2012-01-10 07:09:52 UTC
Scanning cell input is very lax regarding dates and recognizes much too many patterns as "valid" dates, especially when it comes to abbreviated (incomplete) dates, for example:

en-US: M/D is valid (day of month of current year), but also accepted is M/D/ and M.D and M.D.
de-DE: D.M. is valid, but also accepted is D.M and D/M and D/M/
Any mixture of '.' '/' '-' (plus the locale's date separator if it differs) is accepted, e.g. 22.11/99 in a locale's DMY order.

In many cases this leads to forced dates if in fact the input should be treated as text instead.

Implement a match against locale dependent date acceptance patterns to form a valid date. Additionally, ISO 8601 yyyy-mm-dd input must still be valid in every locale, a match against an already applied date format should be recognized as well, if not contradicting.
Comment 1 Eike Rathke 2012-01-11 04:24:35 UTC
Implemented in master:
Comment 2 Eike Rathke 2012-01-21 16:43:38 UTC
Anyone interested in details may want to have a look at