[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 #9 from Eike Rathke <erack at redhat.com> ---
Everyone talking about a maybe theoretically possible time zone support, please
be aware that in spreadsheet context a date+time value is one single numeric
floating point value in days since null date (with 0.5 == 12h ...), it does not
hold any time zone information whatsoever. Please see comment 2. This is
completely different from what *could* be possible in the file format where an
ISO 8601 date+time string is stored (at least for ODF and optionally for OOXML,
the old binary .xls file format doesn't allow any such thing).

-- 
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/20190129/b733d856/attachment.html>