[Libreoffice-bugs] [Bug 134155] New: Calc VIEWING: Boolean values shown in locale instead of UI language

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134155

            Bug ID: 134155
           Summary: Calc VIEWING: Boolean values shown in locale instead
                    of UI language
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: christos at labs.epiuse.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200619/ec532e48/attachment.htm>