update translations for 5.2.0 beta1

and force-fix errors using pocheck

Change-Id: I9dac678a4e705f255463e6ba3b127f423e82fd65

3 files changed, 410 insertions, 37 deletions

diff --git a/source/he/sc/source/ui/sidebar.po b/source/he/sc/source/ui/sidebar.po
index 15668b77747..98c72930797 100644
--- a/source/he/sc/source/ui/sidebar.po
+++ b/source/he/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-12-10 19:32+0000\n"
-"Last-Translator: Yaron Shahrabani <sh.yaron@gmail.com>\n"
+"POT-Creation-Date: 2016-05-07 21:35+0200\n"
+"PO-Revision-Date: 2015-12-11 16:47+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: he\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: 1449775969.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1449852467.000000\n"
 
 #: CellAppearancePropertyPanel.src
 msgctxt ""
@@ -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/he/sc/source/ui/src.po b/source/he/sc/source/ui/src.po
index 32183288966..5336cf75c3f 100644
--- a/source/he/sc/source/ui/src.po
+++ b/source/he/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-05-04 07:06+0000\n"
+"POT-Creation-Date: 2016-05-25 13:27+0200\n"
+"PO-Revision-Date: 2016-05-18 18:07+0000\n"
 "Last-Translator: Yaron Shahrabani <sh.yaron@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: he\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: 1462345577.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1463594851.000000\n"
 
 #: condformatdlg.src
 msgctxt ""
@@ -5014,7 +5014,7 @@ msgctxt ""
 "STR_CLOSE_WITH_UNSAVED_REFS\n"
 "string.text"
 msgid "This Document is referenced by another document and not yet saved. Closing it without saving will result in data loss."
-msgstr "מסמך אחר מפנה למסמך זה שעוד לא נשמר. סגירתו תוביל לאובדן מידע."
+msgstr "מסמך אחר מפנה למסמך זה שעוד לא נשמר. סגירתו ללא שמירה תוביל לאובדן מידע."
 
 #: globstr.src
 msgctxt ""
@@ -12349,8 +12349,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 ""
@@ -12674,7 +12676,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
@@ -22732,13 +22736,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 ""
@@ -22752,6 +22757,345 @@ 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
+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
+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 ""
+
+#: 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
+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 ""
+
+#: scfuncs.src
+msgctxt ""
+"scfuncs.src\n"
 "RID_SC_FUNCTION_DESCRIPTIONS2.SC_OPCODE_EXACT\n"
 "1\n"
 "string.text"
diff --git a/source/he/sc/uiconfig/scalc/ui.po b/source/he/sc/uiconfig/scalc/ui.po
index 3114ac28028..b250af6f405 100644
--- a/source/he/sc/uiconfig/scalc/ui.po
+++ b/source/he/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: 2015-12-11 16:50+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-23 21:36+0200\n"
+"PO-Revision-Date: 2016-05-18 18:23+0000\n"
+"Last-Translator: Yaron Shahrabani <sh.yaron@gmail.com>\n"
 "Language-Team: none\n"
 "Language: he\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: 1449852608.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1463595836.000000\n"
 
 #: advancedfilterdialog.ui
 msgctxt ""
@@ -2265,7 +2265,7 @@ msgctxt ""
 "label\n"
 "string.text"
 msgid "Don't save _imported data"
-msgstr ""
+msgstr "לא _לשמור את הנתונים שייובאו"
 
 #: definedatabaserangedialog.ui
 msgctxt ""
@@ -4657,6 +4657,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"
@@ -8422,6 +8440,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"