update translations for 5.2.0 beta1

and force-fix errors using pocheck

Change-Id: I9dac678a4e705f255463e6ba3b127f423e82fd65

3 files changed, 409 insertions, 32 deletions

diff --git a/source/zh-TW/sc/source/ui/sidebar.po b/source/zh-TW/sc/source/ui/sidebar.po
index c454e80435f..a85259a2161 100644
--- a/source/zh-TW/sc/source/ui/sidebar.po
+++ b/source/zh-TW/sc/source/ui/sidebar.po
@@ -1,19 +1,20 @@
+#. extracted from sc/source/ui/sidebar
 msgid ""
 msgstr ""
 "Project-Id-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-25 14:52+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-05-07 21:35+0200\n"
+"PO-Revision-Date: 2015-12-11 21:21+0000\n"
+"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
 "Language-Team: \n"
 "Language: zh_TW\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1432565554.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1449868876.000000\n"
 
 #: CellAppearancePropertyPanel.src
 msgctxt ""
@@ -203,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/zh-TW/sc/source/ui/src.po b/source/zh-TW/sc/source/ui/src.po
index eb0ec6f3cf4..e4e9a141330 100644
--- a/source/zh-TW/sc/source/ui/src.po
+++ b/source/zh-TW/sc/source/ui/src.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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"
+"POT-Creation-Date: 2016-05-25 13:27+0200\n"
 "PO-Revision-Date: 2016-04-30 05:10+0000\n"
 "Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
 "Language-Team: \n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.7\n"
+"X-Generator: LibreOffice\n"
 "X-Poedit-Bookmarks: 2115,2157,-1,-1,-1,-1,-1,-1,-1,-1\n"
 "X-POOTLE-MTIME: 1461993021.000000\n"
 
@@ -12336,8 +12336,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 ""
@@ -12661,7 +12663,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
@@ -22655,12 +22659,13 @@ 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 "
+msgid "text"
 msgstr "文字"
 
 #: scfuncs.src
@@ -22675,6 +22680,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/zh-TW/sc/uiconfig/scalc/ui.po b/source/zh-TW/sc/uiconfig/scalc/ui.po
index 0529b939c49..9ccc5d296b1 100644
--- a/source/zh-TW/sc/uiconfig/scalc/ui.po
+++ b/source/zh-TW/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-02-20 03:40+0000\n"
-"Last-Translator: pesder <pesder@gmail.com>\n"
+"POT-Creation-Date: 2016-05-23 21:36+0200\n"
+"PO-Revision-Date: 2016-04-30 05:10+0000\n"
+"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
 "Language-Team: none\n"
 "Language: zh_TW\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=1; plural=0;\n"
-"X-Generator: Pootle 2.7\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1455939620.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1461993021.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"
@@ -8330,6 +8348,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"