[Libreoffice-bugs] [Bug 121851] Calc loses time zone information for datetime cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Libomark <pnetmod at f2s.com> ---
I suspect this would turn into a nightmare to maintain, because time zones and
daylight savings time date changes are subject to constant change on political
whim.  Expecting these events all to be detected, and finding a way to
implement the updates automatically would be no trivial task.  I think the onus
has to remain with the spreadsheet designer to record the time zone in a
separate cell, or to find a way to use GMT (or a designated local time) as a
standard where event sequence is important. 

Where contracts are concerned, these will specify the time zone to be used if
it is critical  e.g. "by 17:00 hours London time". 

Where collaborative editing is involved, the edits will presumably be
timestamped by the hosting server.

-- 
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/20190118/892cd871/attachment-0001.html>