<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_REOPENED "
title="REOPENED - Calc inverts typed dates"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125109">bug 125109</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;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc inverts typed dates"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125109#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc inverts typed dates"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125109">bug 125109</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>This
"1. Set locale to en-US"
and this
"2. Format a cell with a locale that has DD/MM/YYYY dates"
explains it. The cell input is parsed according to the system locale (or the
locale set under Tools->Options) in its M/D/Y order and then displayed using
the date order of the applied date format. That is expected. At least for so
far empty cells there is no indication what input would be accepted so using
the system locale is logical.
The problem here is editing an existing date in such constellation, because
after F2 the date is presented in the edit format of the applied format in
D/M/Y order but again parsed as M/D/Y of the system locale.
To be investigated.</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>