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.

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

Or with:

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

Change is applied immediately.

have a look into attached Calc-file

calc_func_names_en_de.ods

Nice list but at the end not translated.

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