Description: If I want to use the LET-Function in Libreoffice Calc in 24.8 I have to use and remember the german function name "BEHALTEN". Behalten means more like "KEEP". I therefore suggest to stay with "LET" in the german translation or maybe "SEI". Steps to Reproduce: none Actual Results: none Expected Results: have a meaningful function name like "SEI", "LET" Reproducible: Always User Profile Reset: No Additional Info: no other information. That's it.
Apparently Excel went with the untranslated LET() in German localization, see https://support.microsoft.com/de-de/office/let-funktion-34842dd8-b92b-4d3f-b325-b8b8f9908999 I suggest to go with the same.
Eike/Heiko: I made a search in German part of the translation repo, I found these: formula/messages.po-1401-msgctxt "RID_STRLIST_FUNCTION_NAMES" formula/messages.po-1402-msgid "LET" formula/messages.po:1403:msgstr "BEHALTEN" formula/messages.po-1404- formula/messages.po-1405-#. dTotR -- helpcontent2/source/text/scalc/01.po-65265-"help.text" helpcontent2/source/text/scalc/01.po-65266-msgid "LET function" helpcontent2/source/text/scalc/01.po:65267:msgstr "Funktion BEHALTEN" helpcontent2/source/text/scalc/01.po-65268- helpcontent2/source/text/scalc/01.po-65269-#. mp4Fy -- helpcontent2/source/text/scalc/01.po-65274-"help.text" helpcontent2/source/text/scalc/01.po-65275-msgid "<bookmark_value>LET function</bookmark_value>" helpcontent2/source/text/scalc/01.po:65276:msgstr "<bookmark_value>Funktion BEHALTEN</bookmark_value>" helpcontent2/source/text/scalc/01.po-65277- helpcontent2/source/text/scalc/01.po-65278-#. cUrJc -- helpcontent2/source/text/scalc/01.po-65283-"help.text" helpcontent2/source/text/scalc/01.po-65284-msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" helpcontent2/source/text/scalc/01.po:65285:msgstr "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">BEHALTEN</link></variable>" helpcontent2/source/text/scalc/01.po-65286- helpcontent2/source/text/scalc/01.po-65287-#. NFFDr -- helpcontent2/source/text/scalc/01.po-65292-"help.text" helpcontent2/source/text/scalc/01.po-65293-msgid "Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function." helpcontent2/source/text/scalc/01.po:65294:msgstr "Weist Berechnungsergebnissen Namen zu. Dies ermöglicht das Speichern von Zwischenberechnungen, Werten oder das Definieren von Namen innerhalb einer Formel. Diese Namen gelten nur im Rahmen der Funktion BEHALTEN." helpcontent2/source/text/scalc/01.po-65295- helpcontent2/source/text/scalc/01.po-65296-#. A9iKa -- helpcontent2/source/text/scalc/01.po-65301-"help.text" helpcontent2/source/text/scalc/01.po-65302-msgid "LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])" helpcontent2/source/text/scalc/01.po:65303:msgstr "BEHALTEN(Name 1; Wert 1; Berechnung oder Name 2; [Wert 2; Berechnung oder Name 3 [; …]])" helpcontent2/source/text/scalc/01.po-65304- helpcontent2/source/text/scalc/01.po-65305-#. voGvK -- helpcontent2/source/text/scalc/01.po-65346-"help.text" helpcontent2/source/text/scalc/01.po-65347-msgid "<emph>Calculation</emph>: a formula expression that uses all names within the LET function." helpcontent2/source/text/scalc/01.po:65348:msgstr "<emph>Berechnung</emph>: ein Formelausdruck, der alle Namen innerhalb der Funktion BEHALTEN verwendet." helpcontent2/source/text/scalc/01.po-65349- helpcontent2/source/text/scalc/01.po-65350-#. AaFRL -- helpcontent2/source/text/scalc/01.po-65355-"help.text" helpcontent2/source/text/scalc/01.po-65356-msgid "<emph>Calculation</emph> must be the last argument in the LET function." helpcontent2/source/text/scalc/01.po:65357:msgstr "<emph>Berechnung</emph> muss das letzte Argument in der Funktion BEHALTEN sein." helpcontent2/source/text/scalc/01.po-65358- helpcontent2/source/text/scalc/01.po-65359-#. vGdpF -- helpcontent2/source/text/scalc/01.po-65373-"help.text" helpcontent2/source/text/scalc/01.po-65374-msgid "<input>=LET(mHydro; HLOOKUP(\"Hydrogen\"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP(\"Oxygen\"; $A$1:$DO$4; 4; 0); \"The molar mass of water is \"&(mOxy+2*mHydro)&\" g/mol\")</input> returns \"The molar mass of water is 18.015 g/mol\"." helpcontent2/source/text/scalc/01.po:65375:msgstr "<input>=BEHALTEN(mWasserstoff; WVERWEIS(\"Wasserstoff\"; $A$1:$DO$4; 4; 0); mSauerstoff; WVERWEIS(\"Sauerstoff\"; $A$1:$DO$4; 4; 0); \"Die Molmasse von Wasser beträgt \"&(mSauerstoff+2*mWasserstoff)&\" g/mol\")</input> gibt \"Die Molmasse von Wasser beträgt 18,015 g/mol\" zurück." helpcontent2/source/text/scalc/01.po-65376- helpcontent2/source/text/scalc/01.po-65377-#. TGwea -- helpcontent2/source/text/scalc/01.po-65382-"help.text" helpcontent2/source/text/scalc/01.po-65383-msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wiki page</link>." helpcontent2/source/text/scalc/01.po:65384:msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">Wiki-Seite zu BEHALTEN</link>." helpcontent2/source/text/scalc/01.po-65385- helpcontent2/source/text/scalc/01.po-65386-#. Cauxq -- sc/messages.po-17140-msgctxt "SC_OPCODE_LET" sc/messages.po-17141-msgid "The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function." sc/messages.po:17142:msgstr "Die Funktion BEHALTEN weist Berechnungsergebnissen Namen zu. Dies ermöglicht das Speichern von Zwischenberechnungen, Werten oder das Definieren von Namen innerhalb einer Formel. Diese Namen gelten nur im Rahmen der Funktion BEHALTEN." sc/messages.po-17143- sc/messages.po-17144-#. 6DDAi -- sc/messages.po-17176-msgctxt "SC_OPCODE_LET" sc/messages.po-17177-msgid "A calculation that uses all names within the LET function. This must be the last argument in the LET function. Or a second Name to assign to a second Name value. If a second Name is specified, Name value 2 and Calculation or Name 3 become required." sc/messages.po:17178:msgstr "Eine Berechnung, die alle Namen innerhalb der Funktion BEHALTEN verwendet. Dies muss das letzte Argument in der Funktion BEHALTEN sein. Oder ein Name 2, der einem Wert 2 zugewiesen wird. Wenn ein Name 2 angegeben wird, werden Wert 2 und Berechnung oder Name 3 erforderlich." sc/messages.po-17179- sc/messages.po-17180-#. pDDme First, could it generate some backward compatibility pb? if no: Ok to change all the quoted ones? (I can do it on Weblate if it's ok for you)
(In reply to Eike Rathke from comment #1) > I suggest to go with the same. +1
Just thought that if Eike indicated it was ok, no need to ask about backward compatibility, since he's the Calc expert :-) Here are the translations changed: https://translations.documentfoundation.org/translate/libo_ui-master/formulamessages/de/?q=note%3Agvi4T&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/de/?q=note%3AaxamT&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_ui-master/scmessages/de/?q=note%3AtFMkP&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3AANivD&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3Amp4Fy&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3AcUrJc&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3ANFFDr&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3AA9iKa&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3Aii4Cd&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3AAaFRL&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3As46BC&sort_by=-priority%2Cposition&offset=1 https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/de/?q=note%3ATGwea&sort_by=-priority%2Cposition&offset=1
Of course, now it's changed in Weblate, you must wait for synchronization with translate repo, then wait for another LO release.
All msgstr values coming from Weblate are ok to change, there's no compatibility problem, stored in document files are immutable name values.
You guys rock! Thank your for the work you are doing!