<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Custom time format changes to default upon load (only those saved from older versions)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118850">bug 118850</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>NEW
</td>
<td>ASSIGNED
</td>
</tr>
<tr>
<td style="text-align:right;">Assignee</td>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Custom time format changes to default upon load (only those saved from older versions)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118850#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_ASSIGNED "
title="ASSIGNED - Custom time format changes to default upon load (only those saved from older versions)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118850">bug 118850</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>Thanks.
Base of the problem is that the 5.0 version (and earlier?) did not store the
cell as time cell, so when loading the explicitly set en-US locale leads to the
default number format (of that cell type, i.e. float number) of that locale
being applied. Which again with some twisted logic is needed if there is no
cell style but a cell type ...
Attached sample stored with 5.0:
<table:table-cell office:value-type="float" office:value="0.333333"
calcext:value-type="float">
Stored with 6.2/master:
<table:table-cell office:value-type="time"
office:time-value="PT07H59M59.9712S" calcext:value-type="time"></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>