update translations for 5.2.0 beta1

and force-fix errors using pocheck

Change-Id: I9dac678a4e705f255463e6ba3b127f423e82fd65

3 files changed, 409 insertions, 34 deletions

diff --git a/source/gug/sc/source/ui/sidebar.po b/source/gug/sc/source/ui/sidebar.po
index fa8ebd0aaf1..4101f7b6c53 100644
--- a/source/gug/sc/source/ui/sidebar.po
+++ b/source/gug/sc/source/ui/sidebar.po
@@ -3,17 +3,17 @@ 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"
+"POT-Creation-Date: 2016-05-07 21:35+0200\n"
 "PO-Revision-Date: 2015-08-07 17:46+0000\n"
-"Last-Translator: Giovanni Caligaris <giovannicaligaris@gmail.com>\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: gug\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-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1438969612.000000\n"
 
 #: CellAppearancePropertyPanel.src
@@ -204,19 +204,3 @@ msgctxt ""
 "string.text"
 msgid "Left and Right Borders"
 msgstr "Bordes Akatúa ha Asu"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_THOUSAND_SEP\n"
-"string.text"
-msgid "Thousands separator"
-msgstr "Separador de millares"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_ENGINEERING\n"
-"string.text"
-msgid "Engineering notation"
-msgstr "Notación ingenieril"
diff --git a/source/gug/sc/source/ui/src.po b/source/gug/sc/source/ui/src.po
index a11d49ee4db..f32e52b5971 100644
--- a/source/gug/sc/source/ui/src.po
+++ b/source/gug/sc/source/ui/src.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: 2016-04-16 21:40+0200\n"
-"PO-Revision-Date: 2015-12-11 16:29+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-25 13:27+0200\n"
+"PO-Revision-Date: 2016-04-17 03:23+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: gug\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: 1449851382.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1460863385.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -12338,8 +12338,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 "Emoapu'a peteĩ papapy al múltiplo significativo hi'aguĩvéa."
+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 ""
@@ -12662,7 +12664,9 @@ 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."
+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
@@ -22657,13 +22661,14 @@ msgid "Combines several text items into one."
 msgstr "Embojoaju varios elemento kuéra moñe'ẽrãgui peteĩpe."
 
 #: scfuncs.src
+#, fuzzy
 msgctxt ""
 "scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT\n"
 "2\n"
 "string.text"
-msgid "text "
-msgstr "moñe'ẽrã "
+msgid "text"
+msgstr "moñe'ẽrã"
 
 #: scfuncs.src
 msgctxt ""
@@ -22677,6 +22682,347 @@ msgstr "Moñe'ẽrã concatenación guarã."
 #: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT_MS\n"
+"2\n"
+"string.text"
+msgid "text"
+msgstr "moñe'ẽrã"
+
+#: 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 ""
+
+#: 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 ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"2\n"
+"string.text"
+msgid "delimiter"
+msgstr ""
+
+#: 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 ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"4\n"
+"string.text"
+msgid "skip empty cells"
+msgstr ""
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_TEXTJOIN_MS\n"
+"6\n"
+"string.text"
+msgid "text"
+msgstr "moñe'ẽrã"
+
+#: 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 ""
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"2\n"
+"string.text"
+msgid "test"
+msgstr "moñe'ẽrã"
+
+#: scfuncs.src
+#, fuzzy
+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 "Ha'e oimeraẽa valor o expresión ikatu oje'evaluataha mba'éicha VERDADERO o FALSO."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"4\n"
+"string.text"
+msgid "result"
+msgstr "Resultado"
+
+#: 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 ""
+
+#: 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 ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"2\n"
+"string.text"
+msgid "expression"
+msgstr ""
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"4\n"
+"string.text"
+msgid "value "
+msgstr "valor "
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_SWITCH_MS\n"
+"6\n"
+"string.text"
+msgid "result"
+msgstr "Resultado"
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+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 "Suma total de los valores koty'ígui kuéra peteĩ intervalope ocumpliha hetándi criterios hetápe intervalos."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"2\n"
+"string.text"
+msgid "min_range"
+msgstr ""
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"4\n"
+"string.text"
+msgid "range"
+msgstr "intervalo"
+
+#: 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 "Intervalo 1, intervalo 2, ...ha'e los intervalos ojevaluátaha criterios especificados háicha."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "criterios"
+
+#: scfuncs.src
+#, fuzzy
+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 "Criterio 1, criterio 2, ...ha'e los criterios oñemoĩtaha intervalospe oñeme'ẽa."
+
+#: scfuncs.src
+#, fuzzy
+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 "Suma total de los valores koty'ígui kuéra peteĩ intervalope ocumpliha hetándi criterios hetápe intervalos."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"2\n"
+"string.text"
+msgid "max_range"
+msgstr ""
+
+#: 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 ""
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"4\n"
+"string.text"
+msgid "range"
+msgstr "intervalo"
+
+#: 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 "Intervalo 1, intervalo 2, ...ha'e los intervalos ojevaluátaha criterios especificados háicha."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "criterios"
+
+#: scfuncs.src
+#, fuzzy
+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 "Criterio 1, criterio 2, ...ha'e los criterios oñemoĩtaha intervalospe oñeme'ẽa."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_EXACT\n"
 "1\n"
 "string.text"
diff --git a/source/gug/sc/uiconfig/scalc/ui.po b/source/gug/sc/uiconfig/scalc/ui.po
index e72352e4476..6bfa580a42b 100644
--- a/source/gug/sc/uiconfig/scalc/ui.po
+++ b/source/gug/sc/uiconfig/scalc/ui.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: 2016-03-09 20:48+0100\n"
-"PO-Revision-Date: 2015-12-11 16:30+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-23 21:36+0200\n"
+"PO-Revision-Date: 2016-03-11 06:15+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: gug\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: 1449851403.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1457676902.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -4604,6 +4604,24 @@ msgctxt ""
 msgid "No solution was found."
 msgstr "Nojetopái mavave solución."
 
+#: 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"
@@ -8339,6 +8357,33 @@ msgctxt ""
 msgid "Inserts a separator between thousands."
 msgstr "Moĩngue peteĩ jeiha millares mbytepe."
 
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"label\n"
+"string.text"
+msgid "_Engineering notation"
+msgstr ""
+
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"tooltip_markup\n"
+"string.text"
+msgid "Ensures that exponent is a multiple of 3."
+msgstr ""
+
+#: sidebarnumberformat.ui
+msgctxt ""
+"sidebarnumberformat.ui\n"
+"engineeringnotation\n"
+"tooltip_text\n"
+"string.text"
+msgid "Ensures that exponent is a multiple of 3."
+msgstr ""
+
 #: simplerefdialog.ui
 msgctxt ""
 "simplerefdialog.ui\n"