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@lists.freedesktop.org
Reporter: j...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
