<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Timestamp is hardcoded to UTC while it is a local time for docx creation date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134589">134589</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Timestamp is hardcoded to UTC while it is a local time for docx creation date
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>virusmater@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Let's say I'm in CET timezone, 15:00 local time. I create new Writer document
and save it as .docx (2007-365). Then I open it as archive and go to:
docProps > core.xml
there I can see:
<dcterms:created
xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00Z</dcterms:created>
but this is wrong, since the date has Z on the end it means that this is UTC
timestamp. it should be like this:
<dcterms:created
xsi:type="dcterms:W3CDTF">2020-07-06T13:00:00Z</dcterms:created>
or just timezone naive:
<dcterms:created
xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00</dcterms:created>
because of this some libraries, as python-docx, may have issues with timezones.
same goes for the review comments: LibreOffice saves it as local time, but adds
UTC 'Z' to the timestamp.
Microsoft Office works differently and just put timestamps in the naive way
inside (for comments) or in proper timezone (for creation date)
Steps to Reproduce:
1.Create new Writer doc
2.Export to docx
3.Open it as archive
4.Check creation timestamp
Actual Results:
<dcterms:created
xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00Z</dcterms:created>
Expected Results:
<dcterms:created
xsi:type="dcterms:W3CDTF">2020-07-06T15:00:00</dcterms:created>
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Link to the forum:
<a href="https://ask.libreoffice.org/en/question/253816/timezone-of-creation-date-for-docx-file/">https://ask.libreoffice.org/en/question/253816/timezone-of-creation-date-for-docx-file/</a></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>