How do I translate Calc functions between different languages?

The English documentation is most complete and most articles on the web explain the English version of LibreOffice.

But Calc uses German names for functions which makes it impossible to find anything :frowning:

How do I find the German names for functions, for example for the function FREQUENCY?

The expected translation would be FREQUENZ but neither the help not Calc itself like this word.

1 Like

Or with:

Menu/Tools/Options/LibreOffice calc/Formula - Use English functions names.

Change is applied immediately.

See also the translation test document linked from that answer there not specific to a particular language.

have a look into attached Calc-file


Nice list but at the end not translated.

How did you come up with the list (in case there are new functions added)?