Hello,
I found and issue in LibreOffice Calc v. 7.1.5.2, don’t know if the issue was present at older version, I just tried to use those functions only in this week.
Besides my Linux (manjaro KDE Stable) is set to English language and also calc is set to english language, logic functions are showing the the results in Portuguese.
=AND ()
=OR ()
=NOT()
etc…
See in the middle of the bottom of your own screenshot (status bar), which shows Portuguese (Brazil)
BTW: A screenshot is not suitable to find a document’s setting issue.
Well this is even more weird, my LibreOffice language is set to English USA as you can see below.
I tried to click in the status bar and check to English but the results remains the same. If the software interface is in English, the function is written in English, why the results will be shown in a different language?
Because your spreadsheet’s cells are configured for pt-BR. This is per-cell setting, also configurable using styles. Likely your spreadsheet was created before you changed the language, or elsewhere.
… because of your Locale setting: Portuguese (Brazil)
a bit confusing this stuff,
the locale setting for Portuguese should just impact formats for date, commas and so on. not the displayed language.
Where can I open the per-cell configuration to change them to English? by default they should be created to English to align with system configuration.
… “and so on” includes the format for type BOOLEAN
Use Format -> Cells -> Tab: Numbers and set the desired language using drop down Language
Linux really has the ability to make simple stuffs very complicate, ahahah but also complicate stuffs very simple, kind of curse.
Tied also to format the cell but are already set to English. I will need to check this BOOLEAN
Look at the locale on Numbers tab.
… this got nothing to do with Linux, but with an event called “Babylonian confusion of languages” ;-).
By the way, I totally agree that screenshot is not a good thing for understanding the problem, but even on that you only shown formula in the correct cell!
Thanks mikekaganski, it fix the issue at least interim way.
… this got nothing to do with Linux, it has because comparing to other OS it’s much easier to set language and they work in a simple way. Don’t get me wrong, i’m not blaming, just learning
… if you like it to see this way. But related to your current issue, try to do the same thing on Windows 10, and you’ll face the same problem and the same solution. So where is the “Linux vs. any other OS” thing here? (This is a rhetoric question, no response required)
yeah, i will not engage this discussion because it’s related to personal point of view.
I just hoping with the steam deck and maybe windows 11 issues for old hardware those thinks could be a chance for Linux to grow and improve a lot of thinks. We hit 1% so let see what future brings.
Issue fixed, at least ad interim, thank you all for the help.
Oh, I was under impression that the issue here was the wrong results produced from logical functions; and that the language of TRUE/FALSE was only a secondary thing. I believe we helped a bit to resolve the latter, but we couldn’t do anything about the former (the major?). If you found a reason, please share with the community, to help others who might have a similar issue in the future.
In the langauge settings, the LOCALE is set to Brazilian which means that by default all numbers are formatted in a Brazilian fashion.
If you do nothing, the OS locale “Portuguese (Brazil)” is taken as default locale for the whole office suite. Same with Windows, Linux and Mac.
If you do nothing, the LibreOffice default locale is used for all numbers in all components (table cells, text fields, formula expressions database columns, form fields and more). Same with Windows, Linux and Mac.
The user interface langauge has to be completely independent from the locale.
The langauge for written text has to be completely independent from the locale and from the user interface language. You can have an office suite with English user interface and explain Brazilian figures with Chinese, French and Russian text.
Unfortunately I can’t test Microsoft solution anymore, I still have windows 7 installed in dual boot but I replaced Microsoft Office with LibreOffice there too. I’m happy with open source and trying to convince friends to give a try, there are always an issue here and there with open source but it’s just about market share and resources to achieve the same level … regarding individual used target…
Thank you all
