<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Locale-specific arguments must be treated depending on the cell's number format locale"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143508#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Locale-specific arguments must be treated depending on the cell's number format locale"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143508">bug 143508</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>For completeness I repeat some fragments here I just posted on Ask.LO:
Taking the formula cell's locale into account isn't such a good idea, though it
might help a little in some cases, like maybe this DATEVALUE(). It was done for
TEXT() to be able to have *some* hint, and it has two fallbacks (current locale
and en-US) if the format string can't be interpreted in the cell's locale.
That's quite unpredictable but works in *most* cases. Which doesn't make it
less of a mess.</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>