[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 #3 from Dan Dascalescu <ddascalescu+freedesktop at gmail.com> ---
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,

> Specifically one does not want to see different times just because viewing data someone entered in a different time zone

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.

-- 
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/20190115/1d3ba930/attachment.html>