[Libreoffice-bugs] [Bug 127727] Converting .xls files appears to shift metadata times the wrong way

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127727

Nick Matteo <libreoffice at kundor.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #4 from Nick Matteo <libreoffice at kundor.org> ---
The attached .xls file was created in Microsoft Excel at 2019-09-25 11:30 AM
MDT. The Create Date seems to be stored as 2019-09-25 17:30:34 (as reported by
exiftool), which is the UTC time.

If LibreOffice assumes the Create Date was stored in UTC, the file after
conversion should have had Create Date 2019-09-25 17:30:34Z. If LibreOffice
instead assumes the Create Date was stored in local time (which is not the
case, but perhaps old versions of Excel did this), the resulting file should
have had Create Date 2019-09-25 23:30:34Z.

Instead, the .xlsx file resulting from `libreoffice --headless --convert-to
xlsx Sep25-1139MDT.xls` (also attached) has Create Date 2019-09-25 11:30:34Z.

-- 
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/20190925/d6866ea0/attachment.html>