<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c3">Comment # 3</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 <span class="vcard"><a class="email" href="mailto:ddascalescu+freedesktop@gmail.com" title="Dan Dascalescu <ddascalescu+freedesktop@gmail.com>"> <span class="fn">Dan Dascalescu</span></a>
</span></b>
<pre>I've had a second look at the underlying content.xml file of the .ODS that I've
attached to my first ticket. The timezone information is included as "Z"
(Zulu/UTC time) in the office:value-type="date" attribute, then also as text in
the <text:p> field:
<table:table-cell office:value-type="date"
office:date-value="2018-11-30T23:30:00.000Z"
table:style-name="ce1"><text:p>2018-11-30T23:30:00.000Z</text:p></table:table-cell>
Should the "Z" time zone specifier be respected when displaying the cell's
value in a different timezone?
In regards to this comment,
<span class="quote">> Specifically one does not want to see different times just because viewing data someone entered in a different time zone</span >
How about this use case:
A business person living in the US has customers in the US, and an outsourced
contractor in Asia who takes support calls. The contract logs each call with
its timestamp and a brief summary. Due to the timezone difference, the local
times in Asia corresponding to business hours in the US will tend to be during
the US night. That doesn't make sense. The US person will want to see the time
in the US timezone when the contractor answered the support call.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>