<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:libreoffice@kundor.org" title="Nick Matteo <libreoffice@kundor.org>"> <span class="fn">Nick Matteo</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Converting .xls files appears to shift metadata times the wrong way"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127727">bug 127727</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Converting .xls files appears to shift metadata times the wrong way"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127727#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Converting .xls files appears to shift metadata times the wrong way"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127727">bug 127727</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@kundor.org" title="Nick Matteo <libreoffice@kundor.org>"> <span class="fn">Nick Matteo</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>