Libre office Calc OR is not working according to documentation

user_659223 0
Viewed 202

Accoring to libre office calc documentation this should return true: =OR(FALSE;TRUE) but my Libre Office return only #NAME?. I have tried many different examples, they all end up the same and Calc refuses to work with OR.

If I change OR to AND everything is ok and formula results in TRUE or FALSE.

Calc

So, formula =AND(12<11;13>22;45=45) ends with FALSE and formula =OR(12<11;13>22;45=45) ends with #NAME?.

I already think calc doesn't have "OR"... but is it possible? What am i doing wrong?

--

The reason was actually the "Use English function Names" setting, which is canceled by default.

But, look at my default function names (language: Slovak)

enter image description here

Everything except OR (selected on screenshot) is in English. This is definitely a bad default value (uncheck Use English function Names) and formulas should be clearly in English by default. This way I can expect something to stop working for me at any moment, because someone translated it.

libreoffice-calc libreoffice
1 Answers

This is most likely a language-settings issue.

First, check your Formula Options (Menu Tools -> Options -> LibreOffice Calc -> Formula, under "Formula Options"). Check if "Use English function Names" is activated - i suppose it isn't. Your screenshot indicates that "OR" isn't recognized as function name, and this is most likely due to the fact that you're using localized function names instead of the English ones.

Additionally, you may have to change "TRUE" and "FALSE" to the localized equivalent. Even with English function names enabled, the boolean values follow the localization settings.

Alternatively, keep your language settings and use the function wizard (or the context help) to identify the localized function names.

user_3425460
Related