<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 - Calc VIEWING: Boolean values shown in locale instead of UI language"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134155">134155</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc VIEWING: Boolean values shown in locale instead of UI language
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.4.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>christos@labs.epiuse.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Calc shows Boolean values in the locale language. However, Calc should show
Boolean values in the language in which LibreOffice communicates with the user,
as it does for functions. Locale serves a different purpose. For example,
someone living in a country with a different convention for the decimal
separator can paste numbers with decimal digits from websites or text files
into Calc with no risk of Calc converting these numbers into text. The UI
language is a communication language, the locale a technical language. Booleans
belong to the former.
Steps to Reproduce:
1. Make sure that English is the UI language and the locale setting is
different.
2. Open a new spreadsheet.
3. Type =TRUE() and ENTER.
Actual Results:
TRUE is shown in the cell translated into the locale language, becoming, for
example, VRAI in French.
Expected Results:
The Boolean value should be shown in the UI language. This is the language in
which all functions including TRUE() are shown in both the input line and the
cells once the user has chosen, from the menu, View > Show Formula.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: fr-FR (en_US); UI-Language: en-US
Calc: threaded</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>