<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#c9">Comment # 9</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:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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 <a href="show_bug.cgi?id=121851#c2">comment 2</a>. 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).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>