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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from SStefanek <s.stefanek at gmail.com> ---
Thank you for taking time to make a video. It helps nailing down the issue.

So on windows with Excel it's a matter of system date settings. I have English
locale and date format set to YYYY-MM-DD. If I type in any format that is not
like YYYY-MM-DD (say it's DD/MM/YYYY) it is interpreted like text and
preserved: not perfect but still OK. If I type in YYYY-MM-DD then it works like
in your video: it changes it to whatever the format is set on the cell, even to
the insane MM/DD/YYYY. OK. So Excel really interprets input related to system
locale.

Calc on windows has a different behavior. With global English locale and system
date format YYYY-MM-DD it still interprets XX/YY/ZZZZ input as MM/DD/YYYY
regardless of what format is set on the cell (unless MM is greater than 12). So
I guess that the system setting is honored only partially: global locale is
used but specific date format is ignored.

This seems to be case also on linux: with LC_TIME set to it_IT and everything
else set to en_US the dates are swapped on input.

I'm pretty sure this used to work before. My dates weren't swapped when typing.
It started when I have upgraded from Ubuntu 18.* to Ubuntu 19.04.

I have also tested Calligra Sheets (which does not preserve input) and Gnumeric
(which preserves it).

-- 
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/76afa7fa/attachment.html>