<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:christos@labs.epiuse.com" title="christos@labs.epiuse.com">christos@labs.epiuse.com</a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc VIEWING: Boolean values shown in number formatting language instead of UI language"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134155">bug 134155</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;">Summary</td>
<td>Calc VIEWING: Boolean values shown in locale instead of UI language
</td>
<td>Calc VIEWING: Boolean values shown in number formatting language instead of UI language
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc VIEWING: Boolean values shown in number formatting language instead of UI language"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134155#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc VIEWING: Boolean values shown in number formatting language 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:christos@labs.epiuse.com" title="christos@labs.epiuse.com">christos@labs.epiuse.com</a>
</span></b>
<pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=134155#c5">comment #5</a>)
Thank you for your comment. I am updating the summary accordingly.
<span class="quote">> (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.
> </span >
That's the bug. This "always", this one-size-fits-all is not right for Boolean
words. They are a different beast. Roughly speaking, this has to do with the
difference between words and numbers. In the spreadsheet, I tried to show why
the UI language is more appropriate for Boolean words.
<span class="quote">> (In reply to christos from <a href="show_bug.cgi?id=134155#c0">comment #0</a>)
> [...]
> 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?</span >
Genuine numbers are displayed fine. This report is about the display of Boolean
words.
<span class="quote">> If you think that not only boolean values, but any formats should *by
> default* follow UI language and not locale, [...]</span >
No, this is only about the Boolean values that are displayed automatically as
words. The locale language, when it differs from the UI language, is a useful
default for the display of genuine numbers.</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>