[Libreoffice-bugs] [Bug 88359] CSV import could recognize ISO 8601 date/time fields without having to check "Detect special numbers" on

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 1 12:07:21 UTC 2021


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

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
Timezones are not supported at all, which is due to how date+time is stored in
major spreadsheet applications, as days (and fractions) since a given null date
with no means to store a timezone. You can do a search and replace with regular
expressions to remove the trailing Z upon which the resulting date+time value
will be accepted as cell content. This is off-topic for this RFE though.

-- 
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/20210301/303286cf/attachment.htm>


More information about the Libreoffice-bugs mailing list