[Libreoffice-bugs] [Bug 125109] Calc inverts typed dates

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125109

--- Comment #9 from SStefanek <s.stefanek at gmail.com> ---
I'm trying to play with "Date Acceptance Patterns" but I can't figure out how
they work. Whatever i put in the setting the input behavior doesn't change: it
still interprets all the date patterns as dates and still swaps day and month.

By the way, I still have LibreOffice 5.4.5.1 on my laptop and that one works
perfectly (same system and LO settings). First of all it seems to interpret the
input based on the cell format. If it's set to an English locale then
01/02/2019 will lead to 02 Jan 2019. If it's set to Italian locale then
01/02/2019 will lead to 01 Feb 2019. Moreover it never swaps day and month:
what the user types is what will end up in the cell.

I think that the previous behavior was correct. Obviously it might be a matter
of personal preference, "industry standard" or whatever. But since currently
there doesn't seem to be a way to fix it, I suggest that the behavior should be
configurable: either prefer cell format for date interpretation or prefer
global locale.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190504/543618db/attachment.html>