<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 - Updated locale does not update the result of text-resulting formulae"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125484">125484</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Updated locale does not update the result of text-resulting formulae
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>csongor@halmai.hu
</td>
</tr></table>
<p>
<div>
<pre>My local setting in `Tools` -> `Options` -> `Language Settings` -> `Languages`
-> `Locale setting` is Hungarian and the label of the checkbox under it is
"Same as locale setting (,)"
If I enter the formula `=1/2` in the cell A1 then "0,5" is displayed which is
correct, in Hungarian, decimal comma is used, not period.
If I enter the formula `="A:"&A1` then "A:0,5" is displayed which is also
correct.
However, if I change the locale setting to "English (USA)" then the following
things happen:
- A1 is changed to "0.5" which is correct.
- B1 is not changed, it remains "A:0,5" (comma) which seems to be wrong
- a vague error message is displayed which seems to be related to this issue.
Instead of this, the following should happen:
- displaying a question: "Some text-resulting formulae refer to cells
containing numbers. Do you want to update them according to the new locale
setting?"
- if the user says YES then B1 should show "A:0.5" (period), otherwise it
should remain "A:0,5" (comma).</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>