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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127893
           Summary: Detect other date formats when pasting text
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jg at jguk.org

When I paste a column of text into Calc, I tick "Detect special numbers"

Only (c) below works. It's pretty easy to identify dates, can some more options
be added on to to the detection?

a) LibreOffice cannot detect this format as a date.

Jul-19-2019
Jul-18-2019
Jul-17-2019

b) LibreOffice cannot detect this format as a date.
Sep 29, 2019
Sep 28, 2019
Sep 27, 2019


c) LibreOffice can detect this format as a date

Jul/19/2019
Jul/18/2019
Jul/17/2019



Some other options worth adding detection for
2019-Jan-01
01-Jan-2019


Some more advanced
01-Jan-18

Some really advanced
26/12/2019
12/26/2019

(need to check which field goes above 12 to identify the month)

-- 
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/20190930/81448e54/attachment.html>