update translations for 5.2.0 beta1

and force-fix errors using pocheck

Change-Id: I9dac678a4e705f255463e6ba3b127f423e82fd65

3 files changed, 396 insertions, 36 deletions

diff --git a/source/en-GB/sc/source/ui/sidebar.po b/source/en-GB/sc/source/ui/sidebar.po
index f3b622fde6a..c696a415965 100644
--- a/source/en-GB/sc/source/ui/sidebar.po
+++ b/source/en-GB/sc/source/ui/sidebar.po
@@ -3,18 +3,18 @@ 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: 2015-05-11 16:12+0200\n"
-"PO-Revision-Date: 2015-05-28 10:24+0000\n"
-"Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
+"POT-Creation-Date: 2016-05-07 21:35+0200\n"
+"PO-Revision-Date: 2015-12-11 15:39+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: en_GB\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1432808687.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1449848362.000000\n"
 
 #: CellAppearancePropertyPanel.src
 msgctxt ""
@@ -204,19 +204,3 @@ msgctxt ""
 "string.text"
 msgid "Left and Right Borders"
 msgstr "Left and Right Borders"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_THOUSAND_SEP\n"
-"string.text"
-msgid "Thousands separator"
-msgstr "Thousands separator"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_ENGINEERING\n"
-"string.text"
-msgid "Engineering notation"
-msgstr "Engineering notation"
diff --git a/source/en-GB/sc/source/ui/src.po b/source/en-GB/sc/source/ui/src.po
index 53f552ba417..b2c4f893788 100644
--- a/source/en-GB/sc/source/ui/src.po
+++ b/source/en-GB/sc/source/ui/src.po
@@ -3,8 +3,8 @@ 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: 2016-04-16 21:40+0200\n"
-"PO-Revision-Date: 2016-04-26 14:10+0000\n"
+"POT-Creation-Date: 2016-05-25 13:27+0200\n"
+"PO-Revision-Date: 2016-05-09 10:08+0000\n"
 "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: en_GB\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: Pootle 2.7\n"
-"X-POOTLE-MTIME: 1461679823.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1462788535.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -12333,8 +12333,10 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_CEIL_MS\n"
 "1\n"
 "string.text"
-msgid "Rounds a number up to the nearest multiple of significance."
-msgstr "Rounds a number up to the nearest multiple of significance."
+msgid ""
+"Rounds a number up to the nearest multiple of significance.\n"
+"This function exists for interoperability with Microsoft Excel 2007 or older versions."
+msgstr ""
 
 #: scfuncs.src
 msgctxt ""
@@ -12657,8 +12659,10 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_FLOOR_MS\n"
 "1\n"
 "string.text"
-msgid "Rounds number towards zero to the nearest multiple of absolute value of significance."
-msgstr "Rounds number towards zero to the nearest multiple of absolute value of significance."
+msgid ""
+"Rounds number towards zero to the nearest multiple of absolute value of significance.\n"
+"This function exists for interoperability with Microsoft Excel 2007 or older versions."
+msgstr ""
 
 #: scfuncs.src
 msgctxt ""
@@ -22640,8 +22644,8 @@ msgctxt ""
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT\n"
 "2\n"
 "string.text"
-msgid "text "
-msgstr "text "
+msgid "text"
+msgstr "text"
 
 #: scfuncs.src
 msgctxt ""
@@ -22655,6 +22659,333 @@ msgstr "A text string for concatenation."
 #: scfuncs.src
 msgctxt ""
 "scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT_MS\n"
+"1\n"
+"string.text"
+msgid "Combines several text items into one, accepts cell ranges as arguments."
+msgstr "Combines several text items into one, accepts cell ranges as arguments."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT_MS\n"
+"2\n"
+"string.text"
+msgid "text"
+msgstr "text"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT_MS\n"
+"3\n"
+"string.text"
+msgid "Text and/or cell ranges for the concatenation."
+msgstr "Text and/or cell ranges for the concatenation."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"1\n"
+"string.text"
+msgid "Combines several text items into one, accepts cell ranges as arguments. Uses delimiter between items."
+msgstr "Combines several text items into one, accepts cell ranges as arguments. Uses delimiter between items."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"2\n"
+"string.text"
+msgid "delimiter"
+msgstr "delimiter"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"3\n"
+"string.text"
+msgid "Text string to be used as delimiter."
+msgstr "Text string to be used as delimiter."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"4\n"
+"string.text"
+msgid "skip empty cells"
+msgstr "skip empty cells"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"5\n"
+"string.text"
+msgid "If TRUE, empty cells will be ignored."
+msgstr "If TRUE, empty cells will be ignored."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"6\n"
+"string.text"
+msgid "text"
+msgstr "text"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"7\n"
+"string.text"
+msgid "Text and/or cell ranges for the concatenation."
+msgstr "Text and/or cell ranges for the concatenation."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"1\n"
+"string.text"
+msgid "Checks 1 or more conditions and returns a value corresponding to the first true condition."
+msgstr "Checks 1 or more conditions and returns a value corresponding to the first true condition."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"2\n"
+"string.text"
+msgid "test"
+msgstr "text"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"3\n"
+"string.text"
+msgid "Any value or expression which can be either TRUE or FALSE."
+msgstr "Any value or expression which can be either TRUE or FALSE."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"4\n"
+"string.text"
+msgid "result"
+msgstr "result"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"5\n"
+"string.text"
+msgid "The result of the function if test is TRUE."
+msgstr "The result of the function if test is TRUE."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"1\n"
+"string.text"
+msgid "Checks 1 or more conditions and returns a value corresponding to the first true condition."
+msgstr "Checks 1 or more conditions and returns a value corresponding to the first true condition."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"2\n"
+"string.text"
+msgid "expression"
+msgstr "expression"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"3\n"
+"string.text"
+msgid "Value that will be compared against value1-valueN."
+msgstr "Value that will be compared against value1-valueN."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"4\n"
+"string.text"
+msgid "value "
+msgstr "value "
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"5\n"
+"string.text"
+msgid "Value that will be compared against expression."
+msgstr "Value that will be compared against expression."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"6\n"
+"string.text"
+msgid "result"
+msgstr "result"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"7\n"
+"string.text"
+msgid "Value to return when corresponding value argument matches expression."
+msgstr "Value to return when corresponding value argument matches expression."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"1\n"
+"string.text"
+msgid "Returns the minimum value in a range that meet multiple criteria in multiple ranges."
+msgstr "Returns the minimum value in a range that meet multiple criteria in multiple ranges."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"2\n"
+"string.text"
+msgid "min_range"
+msgstr "min_range"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"3\n"
+"string.text"
+msgid "The range from which the minimum will be determined."
+msgstr "The range from which the minimum will be determined."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"4\n"
+"string.text"
+msgid "range"
+msgstr "range"
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"5\n"
+"string.text"
+msgid "Range 1, range 2,... are the ranges to be evaluated by the criteria given."
+msgstr "Range 1, range 2, ... are the ranges to be evaluated by the criteria given."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "criteria"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"7\n"
+"string.text"
+msgid "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given."
+msgstr "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"1\n"
+"string.text"
+msgid "Returns the maximum value in a range that meet multiple criteria in multiple ranges."
+msgstr "Returns the maximum value in a range that meet multiple criteria in multiple ranges."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"2\n"
+"string.text"
+msgid "max_range"
+msgstr "max_range"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"3\n"
+"string.text"
+msgid "The range from which the maximum will be determined."
+msgstr "The range from which the maximum will be determined."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"4\n"
+"string.text"
+msgid "range"
+msgstr "range"
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"5\n"
+"string.text"
+msgid "Range 1, range 2,... are the ranges to be evaluated by the criteria given."
+msgstr "Range 1, range 2, ... are the ranges to be evaluated by the criteria given."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "criteria"
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"7\n"
+"string.text"
+msgid "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given."
+msgstr "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_EXACT\n"
 "1\n"
 "string.text"
diff --git a/source/en-GB/sc/uiconfig/scalc/ui.po b/source/en-GB/sc/uiconfig/scalc/ui.po
index 781a28b6095..67ef9823dbc 100644
--- a/source/en-GB/sc/uiconfig/scalc/ui.po
+++ b/source/en-GB/sc/uiconfig/scalc/ui.po
@@ -3,18 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-Version: LibO 40l10n\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2016-03-09 20:48+0100\n"
-"PO-Revision-Date: 2016-03-23 19:04+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-23 21:36+0200\n"
+"PO-Revision-Date: 2016-05-09 10:19+0000\n"
+"Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n"
 "Language-Team: none\n"
 "Language: en_GB\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1458759850.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1462789184.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -4603,6 +4603,24 @@ msgctxt ""
 msgid "No solution was found."
 msgstr "No solution was found."
 
+#: notebookbar.ui
+msgctxt ""
+"notebookbar.ui\n"
+"label1\n"
+"label\n"
+"string.text"
+msgid "File"
+msgstr ""
+
+#: notebookbar.ui
+msgctxt ""
+"notebookbar.ui\n"
+"label2\n"
+"label\n"
+"string.text"
+msgid "Calc"
+msgstr ""
+
 #: optcalculatepage.ui
 msgctxt ""
 "optcalculatepage.ui\n"
@@ -8329,6 +8347,33 @@ msgctxt ""
 msgid "Inserts a separator between thousands."
 msgstr "Inserts a separator between thousands."
 
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"label\n"
+"string.text"
+msgid "_Engineering notation"
+msgstr "_Engineering notation"
+
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"tooltip_markup\n"
+"string.text"
+msgid "Ensures that exponent is a multiple of 3."
+msgstr "Ensures that exponent is a multiple of 3."
+
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"tooltip_text\n"
+"string.text"
+msgid "Ensures that exponent is a multiple of 3."
+msgstr "Ensures that exponent is a multiple of 3."
+
 #: simplerefdialog.ui
 msgctxt ""
 "simplerefdialog.ui\n"