<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Cells no automatically recalculated when formula is dependent of language and this is changed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111920">111920</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Cells no automatically recalculated when formula is dependent of language and this is changed
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>luismiguel.lacosta@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Al least function TEXT is dependent of language in the format code argument.
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.
Procedure to test first case:
1) Create a new calc file
2) Set language of cell A1 to "English (USA)" (not starting with default)
3) Enter formula in cell A1
=TEXT(12345/10,"#.000")
Result show in cell is 1234.500
4) Change language of cell A1 to "Spanish (Spain)" (not starting with default)
Nothing changes in result
5) Over cell A1 press F9
Result changes to 1.235
Procedure to test second case:
1) In Tools -> Options... -> Language Settings -> Languages set locale settings
to "English (USA)"
2) Create a new calc file
3) Enter formula in cell A1
=TEXT(12345/10,"#.000")
Result show in cell is 1234.500
4) In Tools -> Options... -> Language Settings -> Languages set locale settings
to "Spanish (Spain)"
Nothing changes in result
5) Over cell A1 press F9
Result changes to 1.235</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>