update translations

and force-fix errors using pocheck

Change-Id: I2afa34705cebda561eb974fedf7a921666089f2b

3 files changed, 454 insertions, 14 deletions

diff --git a/source/de/helpcontent2/source/text/scalc/01.po b/source/de/helpcontent2/source/text/scalc/01.po
index 4b772e7caf5..e48b2e2d681 100644
--- a/source/de/helpcontent2/source/text/scalc/01.po
+++ b/source/de/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2019-04-24 18:25+0200\n"
+"POT-Creation-Date: 2019-04-30 14:59+0200\n"
 "PO-Revision-Date: 2019-03-03 06:33+0000\n"
 "Last-Translator: Christian Kühl <kuehl.christian@googlemail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -51552,6 +51552,86 @@ msgctxt ""
 msgid "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255."
 msgstr "<item type=\"input\">FARBE(0;0;400;0)</item> ergibt Err:502 (Ungültiges Argument), weil der Wert für blau größer als 255 ist."
 
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"tit\n"
+"help.text"
+msgid "CONCAT function"
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"bm_id741556228031712\n"
+"help.text"
+msgid "<bookmark_value>CONCAT function</bookmark_value>"
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"hd_id471556226436779\n"
+"help.text"
+msgid "<variable id=\"concatfunct\"><link href=\"text/scalc/01/func_concat.xhp\" name=\"concat\">CONCAT</link></variable>"
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id891556226436781\n"
+"help.text"
+msgid "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatenates one or more strings</ahelp></variable>"
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id701556226865876\n"
+"help.text"
+msgid "CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M."
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id461556226873963\n"
+"help.text"
+msgid "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate."
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id911556226813411\n"
+"help.text"
+msgid "CONCAT( string1[, string2][, …] )"
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id581556227044166\n"
+"help.text"
+msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains strings to concatenate."
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id531556227248228\n"
+"help.text"
+msgid "<input>=CONCAT(\"Hello \", A1:C3)</input>  concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>."
+msgstr ""
+
+#: func_concat.xhp
+msgctxt ""
+"func_concat.xhp\n"
+"par_id781556244709752\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\" name=\"concatenate\">CONCATENATE</link>"
+msgstr ""
+
 #: func_countifs.xhp
 msgctxt ""
 "func_countifs.xhp\n"
@@ -53488,6 +53568,150 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060102.xhp\" name=\"YEAR\">YEAR</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"NOW\">NOW</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MINUTE\">MINUTE</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MONTH\">MONTH</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"DAY\">DAY</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"WEEKDAY\">WEEKDAY</link>."
 msgstr "<link href=\"text/scalc/01/04060102.xhp\" name=\"JAHR\">JAHR</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"JETZT\">JETZT</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MINUTE\">MINUTE</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MONAT\">MONAT</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"TAG\">TAG</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"WOCHENTAG\">WOCHENTAG</link>."
 
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "IFS function"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"bm_id901556242230198\n"
+"help.text"
+msgid "<bookmark_value>IFS function</bookmark_value>"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"hd_id271556234923654\n"
+"help.text"
+msgid "<variable id=\"ifsfunct\"><link href=\"text/scalc/01/func_ifs.xhp\" name=\"function ifs\">IFS</link></variable>"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id171556234923655\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">IFS is a multiple IF-function.</ahelp></variable>"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id271556235333493\n"
+"help.text"
+msgid "IFS( expression1, result1[, expression2, result2][, …] )"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id31556235655212\n"
+"help.text"
+msgid "<emph>expression1, expression2, ...</emph> are any boolean values or expressions that can be TRUE or FALSE"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id441556235649549\n"
+"help.text"
+msgid "<emph>result1, result2, ... </emph> are the values that are returned if the logical test is TRUE"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id641556235704257\n"
+"help.text"
+msgid "IFS( expression1, result1, expression2, result2, expression3, result3 ) is executed as"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id551556235712759\n"
+"help.text"
+msgid "IF expression1 is TRUE"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id1001556235718948\n"
+"help.text"
+msgid "THEN result1"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id571556235725969\n"
+"help.text"
+msgid "ELSE IF expression2 is TRUE"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id581556235731982\n"
+"help.text"
+msgid "THEN result2"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id961556235738258\n"
+"help.text"
+msgid "ELSE IF expression3 is TRUE"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id951556235743954\n"
+"help.text"
+msgid "THEN result3"
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id671556235758504\n"
+"help.text"
+msgid "To get a default result should no expression be TRUE, add a last expression that is always TRUE, like TRUE or 1=1 followed by the default result."
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id541556235771022\n"
+"help.text"
+msgid "If there is a result missing for an expression or is no expression is TRUE, a #N/A error is returned."
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id181556235788473\n"
+"help.text"
+msgid "If expression is neither TRUE or FALSE, a #VALUE error is returned."
+msgstr ""
+
+#: func_ifs.xhp
+msgctxt ""
+"func_ifs.xhp\n"
+"par_id781556244709752\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060105.xhp#Section4\" name=\"if\">IF</link>"
+msgstr ""
+
 #: func_imcos.xhp
 msgctxt ""
 "func_imcos.xhp\n"
@@ -55760,6 +55984,222 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Wenn E2 = stift ist, ergibt die Funktion 65, da der Bezug zur Zelle derem Inhalt entspricht."
 
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"tit\n"
+"help.text"
+msgid "SWITCH function"
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"bm_id571556244875552\n"
+"help.text"
+msgid "<bookmark_value>SWITCH function</bookmark_value>"
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"hd_id21556242313791\n"
+"help.text"
+msgid "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\" name=\"switch\">SWITCH</link></variable>"
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id361556242313793\n"
+"help.text"
+msgid "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_value is given, that will be returned.</ahelp></variable>"
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id521556242803283\n"
+"help.text"
+msgid "SWITCH( expression, value1, result1[, value2, result2][, … ][, default_result] )"
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id341556242996378\n"
+"help.text"
+msgid "<emph>expression</emph> is a text, numeric, logical or date input or reference to a cell."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id321556243790332\n"
+"help.text"
+msgid "<emph>value1, value2, ...</emph>  is any value or reference to a cell. Each value must have a result given."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id171556243796068\n"
+"help.text"
+msgid "<emph>result1, result2, ...</emph> is any value or reference to a cell."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id331556245422283\n"
+"help.text"
+msgid "<emph>default_result</emph>: any value or reference to a cell that is returned when there is no match."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id871556243022881\n"
+"help.text"
+msgid "If no <emph>value</emph> equals <emph>expression</emph> and no default result is given, a #N/A error is returned."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id851556243961783\n"
+"help.text"
+msgid "<input>=SWITCH(MONTH(A3),1,\"January\",2,\"February\",3,\"March\",\"No match\")</input> returns \"January\" when A3=1, February when A3=2 , etc..."
+msgstr ""
+
+#: func_switch.xhp
+msgctxt ""
+"func_switch.xhp\n"
+"par_id781556244709752\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060105.xhp#Section4\" name=\"if\">IF</link>"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"tit\n"
+"help.text"
+msgid "TEXTJOIN function"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"bm_id581556228060864\n"
+"help.text"
+msgid "<bookmark_value>TEXTJOIN function</bookmark_value>"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"hd_id551556227727946\n"
+"help.text"
+msgid "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\" name=\"textjoinfunction\">TEXTJOIN</link></variable>"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id121556227727948\n"
+"help.text"
+msgid "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable>"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id541556228253979\n"
+"help.text"
+msgid "TEXTJOIN( delimiter, skip_empty, string1[, string2][, …] )"
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id741556228390897\n"
+"help.text"
+msgid "<emph>delimiter</emph> is a text string and can be a range."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id621556228397269\n"
+"help.text"
+msgid "<emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id631556228516997\n"
+"help.text"
+msgid "<emph>string1[, string2][, …]</emph> are strings or references to cells or ranges that contains text to join."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id1001556228523394\n"
+"help.text"
+msgid "Ranges are traversed row by row (from top to bottom)."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id81556228530082\n"
+"help.text"
+msgid "If <emph>delimiter</emph> is a range, the range need not be of the same size as the number of strings to be joined."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id831556228543099\n"
+"help.text"
+msgid "If there are more delimiters than strings to be joined, not all delimiters will be used."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id321556228557611\n"
+"help.text"
+msgid "If there are less delimiters than strings to be joined, the delimiters will be used again from the start."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id441556229012536\n"
+"help.text"
+msgid "<input>=TEXTJOIN(\" \",TRUE, \"Here\", \"comes\", \"the\", \"sun\")</input> returns \"Here comes the sun\" with space character as delimiter and empty strings are ignored."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id441556239012536\n"
+"help.text"
+msgid "if A1:B2 contains \"Here\", \"comes\", \"the\", \"sun\" respectively, <input>=TEXTJOIN(\"-\",TRUE,A1:B2)</input> returns \"Here-comes-the-sun\" with dash character as delimiter and empty strings are ignored."
+msgstr ""
+
+#: func_textjoin.xhp
+msgctxt ""
+"func_textjoin.xhp\n"
+"par_id781556244709752\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\" name=\"concatenate\">CONCATENATE</link>"
+msgstr ""
+
 #: func_time.xhp
 msgctxt ""
 "func_time.xhp\n"
diff --git a/source/de/helpcontent2/source/text/scalc/04.po b/source/de/helpcontent2/source/text/scalc/04.po
index 6f63935bc33..bf74653a5a0 100644
--- a/source/de/helpcontent2/source/text/scalc/04.po
+++ b/source/de/helpcontent2/source/text/scalc/04.po
@@ -4,8 +4,8 @@ msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
 "POT-Creation-Date: 2019-04-08 14:23+0200\n"
-"PO-Revision-Date: 2019-04-17 04:31+0000\n"
-"Last-Translator: Christian Kühl <kuehl.christian@googlemail.com>\n"
+"PO-Revision-Date: 2019-05-07 05:37+0000\n"
+"Last-Translator: Sophia Schröder <sophia.schroeder@outlook.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: de\n"
 "MIME-Version: 1.0\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: Pootle 2.8\n"
-"X-POOTLE-MTIME: 1555475474.000000\n"
+"X-POOTLE-MTIME: 1557207445.000000\n"
 
 #: 01020000.xhp
 msgctxt ""
@@ -262,7 +262,7 @@ msgctxt ""
 "hd_id281550311052582\n"
 "help.text"
 msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Space"
-msgstr ""
+msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">Befehl</caseinline><defaultinline>Strg</defaultinline></switchinline>+Leertaste"
 
 #: 01020000.xhp
 msgctxt ""
@@ -278,7 +278,7 @@ msgctxt ""
 "hd_id311550311052582\n"
 "help.text"
 msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Space"
-msgstr ""
+msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\">Befehl</caseinline><defaultinline>Strg</defaultinline></switchinline>+Umschalt+Leertaste"
 
 #: 01020000.xhp
 msgctxt ""
@@ -286,7 +286,7 @@ msgctxt ""
 "par_id851550311052582\n"
 "help.text"
 msgid "Selects all cells in the sheet."
-msgstr ""
+msgstr "Wählt alle Zellen im Tabellenblatt aus."
 
 #: 01020000.xhp
 msgctxt ""
diff --git a/source/de/helpcontent2/source/text/scalc/05.po b/source/de/helpcontent2/source/text/scalc/05.po
index d79e2c8057b..9cb41c65450 100644
--- a/source/de/helpcontent2/source/text/scalc/05.po
+++ b/source/de/helpcontent2/source/text/scalc/05.po
@@ -4,8 +4,8 @@ msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
 "POT-Creation-Date: 2019-04-08 14:23+0200\n"
-"PO-Revision-Date: 2018-09-08 04:50+0000\n"
-"Last-Translator: Christian Kühl <kuehl.christian@googlemail.com>\n"
+"PO-Revision-Date: 2019-05-07 05:37+0000\n"
+"Last-Translator: Sophia Schröder <sophia.schroeder@outlook.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: de\n"
 "MIME-Version: 1.0\n"
@@ -13,8 +13,8 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1536382215.000000\n"
+"X-Generator: Pootle 2.8\n"
+"X-POOTLE-MTIME: 1557207450.000000\n"
 
 #: 02140000.xhp
 msgctxt ""
@@ -702,7 +702,7 @@ msgctxt ""
 "par_id231549820000708\n"
 "help.text"
 msgid "533"
-msgstr ""
+msgstr "533"
 
 #: 02140000.xhp
 msgctxt ""
@@ -710,7 +710,7 @@ msgctxt ""
 "par_id951549820044260\n"
 "help.text"
 msgid "Nested arrays are not supported"
-msgstr ""
+msgstr "Verschachtelte Matrizen werden nicht unterstützt"
 
 #: 02140000.xhp
 msgctxt ""
@@ -726,7 +726,7 @@ msgctxt ""
 "par_id961549825716936\n"
 "help.text"
 msgid "538"
-msgstr ""
+msgstr "538"
 
 #: 02140000.xhp
 msgctxt ""