Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 30 Jun 2020 19:03:10 +0200How do I translate Calc functions between different languages?https://ask.libreoffice.org/en/question/51239/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 :-(
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.Thu, 28 May 2015 20:03:46 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/Answer by erAck for <p>The English documentation is most complete and most articles on the web explain the English version of LibreOffice.</p>
<p>But Calc uses German names for functions which makes it impossible to find anything :-(</p>
<p>How do I find the German names for functions, for example for the function FREQUENCY?</p>
<p>The expected translation would be FREQUENZ but neither the help not Calc itself like this word.</p>
https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=252977#post-id-252977See also the translation test document linked from [that answer there](https://ask.libreoffice.org/en/question/252770/calc-list-of-changed-functions-with-the-language/?answer=252976#post-id-252976) not specific to a particular language.
Tue, 30 Jun 2020 19:03:10 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=252977#post-id-252977Answer by karolus for <p>The English documentation is most complete and most articles on the web explain the English version of LibreOffice.</p>
<p>But Calc uses German names for functions which makes it impossible to find anything :-(</p>
<p>How do I find the German names for functions, for example for the function FREQUENCY?</p>
<p>The expected translation would be FREQUENZ but neither the help not Calc itself like this word.</p>
https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=51243#post-id-51243have a look into attached Calc-file
[calc_func_names_en_de.ods](/upfiles/14328459393261979.ods)Thu, 28 May 2015 22:46:55 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=51243#post-id-51243Comment by Aaron Digulla for <p>have a look into attached Calc-file </p>
<p><a href="/upfiles/14328459393261979.ods">calc_func_names_en_de.ods</a></p>
https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?comment=210142#post-id-210142How did you come up with the list (in case there are new functions added)?Thu, 26 Sep 2019 10:53:15 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?comment=210142#post-id-210142Comment by horst for <p>have a look into attached Calc-file </p>
<p><a href="/upfiles/14328459393261979.ods">calc_func_names_en_de.ods</a></p>
https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?comment=51305#post-id-51305Nice list but at the end not translated.Fri, 29 May 2015 18:54:58 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?comment=51305#post-id-51305Answer by m.a.riosv for <p>The English documentation is most complete and most articles on the web explain the English version of LibreOffice.</p>
<p>But Calc uses German names for functions which makes it impossible to find anything :-(</p>
<p>How do I find the German names for functions, for example for the function FREQUENCY?</p>
<p>The expected translation would be FREQUENZ but neither the help not Calc itself like this word.</p>
https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=51247#post-id-51247Or with:
Menu/Tools/Options/LibreOffice calc/Formula - Use English functions names.
Change is applied immediately.Fri, 29 May 2015 01:24:38 +0200https://ask.libreoffice.org/en/question/51239/how-do-i-translate-calc-functions-between-different-languages/?answer=51247#post-id-51247