<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c5">Comment # 5</a>
on <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">bug 134155</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to christos from <a href="show_bug.cgi?id=134155#c4">comment #4</a>)
The cell value is displayed always according to the language defined for the
number format of that cell.
(In reply to christos from <a href="show_bug.cgi?id=134155#c0">comment #0</a>)
<span class="quote">> 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.</span >
The question is: given the locale that you chose (Spanish) and UI language
(en-US), how do you thing should *numbers* be displayed in a new spreadsheet by
default? According to Spanish rules, or according to rules used in USA?
In LibreOffice, the convention is that locale rules are used to format numbers
- *by default*. Note that the language shown in status bar is misleading and
only shows the language used for spell check (available on cell format's Font
tab); but number format locale is available on cell format's *Numbers* tab. And
that is what gives you the "unexpected" boolean value display: just like
formatting of numbers would use comma for decimal separator for Spanish locale,
the same logic requires that true value be formatted according to same locale's
rules.
If you think that not only boolean values, but any formats should *by default*
follow UI language and not locale, then there's a place for discussion (which I
can't participate in). Likely it's considered that being in sole place
(locale), display of values in the spreadsheet should match the place rules ...
but as I said, I can't discuss reasons. My point is that either it should stay
as it is, or *all* formats should by default follow UI language, not only
booleans, but also numbers, dates, times, currencies (!), etc.</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>