[Libreoffice-bugs] [Bug 127727] New: 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

            Bug ID: 127727
           Summary: Converting .xls files appears to shift metadata times
                    the wrong way
           Product: LibreOffice
           Version: 6.2.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at kundor.org

Description:
Timestamps in a .xls file seem to not have a timezone. Current versions of
Excel appear to save Create Date and Modify Date in UTC when saving .xls files,
but other software (e.g. exiftool) interprets them as local times.

However, LibreOffice appears to interpret them as UTC, shift them to local
time, then store them as UTC, which is definitely incorrect. (Equivalently, it
may be interpreting them as local time, shifting them the wrong way to UTC,
then storing as UTC).

Steps to Reproduce:
1. Start with a .xls file, with e.g. Create Date 2019:09:20 12:49:52.
2. Convert to .xlsx, either using `libreoffice --headless --convert-to xlsx` or
by opening in the GUI and saving as .xlsx.

Actual Results:
The new file has Create Date 2019:09:20 06:49:52Z. (I am in MDT, with a UTC
offset of -6 hours.) I can think of no interpretation where this could be
correct.

Expected Results:
If you assume the timestamp in the .xls was already in UTC, the resulting
timestamp should have been 2019:09:20 12:49:52Z.

If you assume the timestamp in the .xls was in local time (MDT for me), the
resulting timestamp should have been 2019:09:20 18:49:52Z.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.6.2
Build ID: 1:6.2.6-0ubuntu0.19.04.1
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: kde5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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/20190923/c86b86fb/attachment.html>