[Libreoffice-bugs] [Bug 92503] FILEOPEN: CSV - Certain date fields not imported correctly, pattern detected

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
Took a more detailed look into this after a long time. Fun stuff.. or not. The
calendar is always created with the time zone of the system as default, so for
most Europeans something with CET (normal time) or CEST (summer daylight saving
time). Then 2013-03-31 and the other two dates indeed were DST transition
dates, there simply is no 02:00 to 02:59:59.999 for those days in Europe.

Not sure how to solve this except for all Gregorian based calendars use always
the UTC time zone, which is not DST afflicted. It wouldn't fit the general
assumption that times are entered (and thus displayed) in the local time zone,
but then again there are no conversions to/from time zones or time zone aware
calculations at all, all times are "as is".

-- 
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/20190618/ae1b45b3/attachment.html>