update translations for 5.2.0 beta1

and force-fix errors using pocheck

Change-Id: I9dac678a4e705f255463e6ba3b127f423e82fd65

3 files changed, 410 insertions, 34 deletions

diff --git a/source/ru/sc/source/ui/sidebar.po b/source/ru/sc/source/ui/sidebar.po
index 0b2540b61fc..9dbaafbf410 100644
--- a/source/ru/sc/source/ui/sidebar.po
+++ b/source/ru/sc/source/ui/sidebar.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: sidebar\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-05-16 10:54+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\n"
 "Language-Team: Russian <l10n@ru.libreoffice.org>\n"
@@ -12,8 +12,8 @@ msgstr ""
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n"
-"X-Generator: Pootle 2.5.1\n"
 "X-Accelerator-Marker: ~\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1431773655.000000\n"
 
 #: CellAppearancePropertyPanel.src
@@ -204,19 +204,3 @@ msgctxt ""
 "string.text"
 msgid "Left and Right Borders"
 msgstr "Линии слева и справа"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_THOUSAND_SEP\n"
-"string.text"
-msgid "Thousands separator"
-msgstr "Разделитель разрядов"
-
-#: NumberFormatPropertyPanel.src
-msgctxt ""
-"NumberFormatPropertyPanel.src\n"
-"RID_SFX_STR_ENGINEERING\n"
-"string.text"
-msgid "Engineering notation"
-msgstr "Инженерная запись"
diff --git a/source/ru/sc/source/ui/src.po b/source/ru/sc/source/ui/src.po
index 92046903441..f24cb5c5549 100644
--- a/source/ru/sc/source/ui/src.po
+++ b/source/ru/sc/source/ui/src.po
@@ -3,18 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-Version: src\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-03-22 20:19+0000\n"
-"Last-Translator: bormant <bormant@mail.ru>\n"
+"POT-Creation-Date: 2016-05-25 13:27+0200\n"
+"PO-Revision-Date: 2016-04-17 07:04+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Russian <l10n@ru.libreoffice.org>\n"
 "Language: ru\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1458677977.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1460876646.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 "Округляет число до кратного заданной точности."
+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 "Округляет число к нулю до ближайшего кратного модуля точности."
+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 ""
@@ -22642,13 +22646,14 @@ msgid "Combines several text items into one."
 msgstr "Объединяет несколько текстовых элементов в одну строку."
 
 #: scfuncs.src
+#, fuzzy
 msgctxt ""
 "scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_CONCAT\n"
 "2\n"
 "string.text"
-msgid "text "
-msgstr "текст "
+msgid "text"
+msgstr "текст"
 
 #: scfuncs.src
 msgctxt ""
@@ -22662,6 +22667,348 @@ msgstr "Текст для объединения."
 #: 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 "текст"
+
+#: 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 "текст"
+
+#: 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 "текст"
+
+#: 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 "Любое значение или выражение, которое при вычислении даёт значение TRUE или FALSE."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_IFS_MS\n"
+"4\n"
+"string.text"
+msgid "result"
+msgstr "Результат"
+
+#: 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
+#, fuzzy
+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 "значение "
+
+#: 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 "Результат"
+
+#: 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 "Сумма значений ячеек из нескольких диапазонов, удовлетворяющих нескольким критериям."
+
+#: 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 "диапазон"
+
+#: 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 "Диапазон 1, диапазон 2, ... — диапазоны ячеек, к которым применяются критерии."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MINIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "критерий"
+
+#: 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 "Критерий 1, критерий 2, … - критерии, применяемые к заданным диапазонам."
+
+#: 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 "Сумма значений ячеек из нескольких диапазонов, удовлетворяющих нескольким критериям."
+
+#: 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 "диапазон"
+
+#: 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 "Диапазон 1, диапазон 2, ... — диапазоны ячеек, к которым применяются критерии."
+
+#: scfuncs.src
+#, fuzzy
+msgctxt ""
+"scfuncs.src\n"
+"RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_MAXIFS_MS\n"
+"6\n"
+"string.text"
+msgid "criteria"
+msgstr "критерий"
+
+#: 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 "Критерий 1, критерий 2, … - критерии, применяемые к заданным диапазонам."
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_EXACT\n"
 "1\n"
 "string.text"
diff --git a/source/ru/sc/uiconfig/scalc/ui.po b/source/ru/sc/uiconfig/scalc/ui.po
index 13c18c96c8a..6996275214c 100644
--- a/source/ru/sc/uiconfig/scalc/ui.po
+++ b/source/ru/sc/uiconfig/scalc/ui.po
@@ -3,18 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-Version: ui\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-13 20:37+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-23 21:36+0200\n"
+"PO-Revision-Date: 2016-04-17 07:04+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Russian <l10n@ru.libreoffice.org>\n"
 "Language: ru\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1457901431.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1460876646.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -4603,6 +4603,24 @@ msgctxt ""
 msgid "No solution was found."
 msgstr "Решение не было найдено."
 
+#: 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 "Вставляет разделитель тысяч."
 
+#: 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"