<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:raal@post.cz" title="raal <raal@post.cz>"> <span class="fn">raal</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells no automatically recalculated when formula is dependent of language and this is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920">bug 111920</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;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>5.4.0.3 release
</td>
<td>4.1.0.4 release
</td>
</tr>
<tr>
<td style="text-align:right;">OS</td>
<td>Windows (All)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>raal@post.cz
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells no automatically recalculated when formula is dependent of language and this is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Cells no automatically recalculated when formula is dependent of language and this is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920">bug 111920</a>
from <span class="vcard"><a class="email" href="mailto:raal@post.cz" title="raal <raal@post.cz>"> <span class="fn">raal</span></a>
</span></b>
<pre>
I can confirm with Version: 6.2.0.0.alpha0+
Build ID: b7e139fa21607f488465fd87333db757ad0c91a2
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
and 4.1
When the lenguage of cell is English (decimal separator is ".") the formula
TEXT(12345/10,"#.000") returns "1234.500"
but when the lenguage of cell is Spanish (decimal separator is ",") the formula
TEXT(12345/10,"#.000") return "1.235"
When you change cell language in the "Format cells" dialog or when you change
locale settings in Tools -> Options... -> Language Settings -> Languages and
the result of the function is diferent, the cell is not automatically
recalculated
---
informational message:
Because the current formula separator settings conflict with the locale, the
formula separators have been reset to their default values.
can be tweaked or we should trigger recalculation.</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>