<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc loses time zone information for datetime cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121851#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc loses time zone information for datetime cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=121851">bug 121851</a> from <a class="email" href="mailto:pnetmod@f2s.com" title="Libomark <pnetmod@f2s.com>"> Libomark</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>