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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to SStefanek from comment #7)
> So on windows with Excel it's a matter of system date settings.

True.

> 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.

LibreOffice does not take system locale into consideration "completely". Well -
sorts of: LibreOffice uses system locale to detect the *default* locale - if
user doesn't set LibreOffice locale to some explicit value in Options->Language
Settings->Languages.

And then, it doesn't take into account any OS-specific additional settings,
like intl.cpl settings other than language on Windows, or LC_TIME on Linux.
There's an enhancement request on that; but it has never worked differently
with LO/OOo. LO had introduced accepted date formats to allow users to
fine-tune what is accepted as date.

-- 
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/0b8ef11b/attachment.html>