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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to SStefanek from comment #2)
> However this is very user-unfriendly
> ...
> The same applies to dates. If a document contains a column of dates
> formatted as (DD/MM/YYY), thinking and typing them all in as MM/DD/YYYY is
> very hard. I'd say it's almost impossible to do without errors.

In opposite, the current behavior is much more user-friendly than the proposed
change.

If you are from the US, you likely think of dates using the national standard
(month-day). And having to always re-think how to put it to a cell accepting a
date would be a burden. So proper selection of your locale allows you to
disregard any formatting; and e.g. use string like "jan/3" if you wish.

Additionally, you only consider a case of formatting where only day and month
exchange positions. But there are more possible formats. You may use ISO format
(2019-04-30); or you may use home-grown format like `"day "DD" in year "YY"
month "MM`... and treating format as input mask would impose huge difficulties
to user.

-- 
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/f9c3649e/attachment-0001.html>