[Libreoffice-bugs] [Bug 127893] Detect other date formats when pasting text

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #11 from Eike Rathke <erack at redhat.com> ---
Jul-19-2019 is *not* obviously a date if the locale in use doesn't define such,
specifically not in an en-GB locale that would have a D/M/Y order not M-D-Y,
though it may look obvious for you in your context. But not even in the en-US
locale it is a common date because even there it would be written as
19-Jul-2019. Are you by chance Canadian? Because en-CA is about the only locale
where that date form would be used,
https://en.wikipedia.org/wiki/Date_format_by_country and
https://en.wikipedia.org/wiki/Date_and_time_notation_in_Canada#English and
entering Jul-19-2019 in en-CA locale *does* recognize it as date.

And that's also why the CSV/Text import dialog offers the option to force a
column to a specific date type and order.. but setting the import locale to
English (Canada) should work as well.

-- 
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/20210119/cc59b51d/attachment-0001.htm>