[Libreoffice-bugs] [Bug 140840] libreoffice calc can't parse and convert dates in opened file

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
Another way to post-process a column of such dates imported as text: select the
column, use Find and Replace dialog (Ctrl+H) to search for
"(\d{4})(\d\d)(\d\d)" (without quotes), and replace with "$1-$2-$3" (also
without quotes); "Regular expressions" and "Current selection only" must be
checked under "Other options" in the dialog.

-- 
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/20210306/c0510e2c/attachment-0001.htm>