<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_RESOLVED bz_closed"
title="RESOLVED WONTFIX - CONVERSION FORMAT DATE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116450">bug 116450</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>REOPENED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>WONTFIX
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - CONVERSION FORMAT DATE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116450#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WONTFIX - CONVERSION FORMAT DATE"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116450">bug 116450</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>The format code passed to the TEXT() function is a string, which can be
constant or made up of function calls or concatenations. It is user data. There
is no solution to "consider / take into account during export". It isn't known
in which environment the file will be opened next. Also, other applications may
not have the feature that the format code is tried to be interpreted with the
locale set as number format locale, so a localized format code may or may not
work. Use of the TEXT() function in different locales is fragile.
The attached document btw works only in one locale, the cell's B3 locale is
Default and not set to Dutch, so when recalculated it displays 17-03-JJJJ in an
en-US locale.
It doesn't help to reopen this. Unless someone comes up with a .xlsx document
created by Excel that works for all locales I'm closing this again.</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>