update translations for master

and force-fix errors using pocheck

Change-Id: I04522500fe14e0d09925b196ccf7b7f94f3bfe64

1 files changed, 170 insertions, 74 deletions

diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index dba1706f24d..8ef88b031f1 100644
--- a/source/zh-TW/helpcontent2/source/text/scalc/01.po
+++ b/source/zh-TW/helpcontent2/source/text/scalc/01.po
@@ -3,9 +3,9 @@ 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: 2018-12-17 16:28+0100\n"
-"PO-Revision-Date: 2018-11-12 14:15+0000\n"
-"Last-Translator: Anonymous Pootle User\n"
+"POT-Creation-Date: 2019-04-24 18:25+0200\n"
+"PO-Revision-Date: 2018-12-24 16:49+0000\n"
+"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: zh_TW\n"
 "MIME-Version: 1.0\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=1; plural=0;\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1542032108.000000\n"
+"X-POOTLE-MTIME: 1545670192.000000\n"
 
 #: 01120000.xhp
 msgctxt ""
@@ -3429,8 +3429,8 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id8007446\n"
 "help.text"
-msgid "You can download the complete ODFF (OpenDocument Format Formula) specification from the <link href=\"http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula\">OASIS</link> web site."
-msgstr "您可以從 <link href=\"http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula\">OASIS</link> 網站下載完整的 ODFF (OpenDocument 格式公式) 規格。"
+msgid "You can download the complete ODFF (OpenDocument Format Formula) specification from the <link href=\"https://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt\"><emph>OASIS</emph></link> web site."
+msgstr ""
 
 #: 04060000.xhp
 msgctxt ""
@@ -3485,7 +3485,7 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3149378\n"
 "help.text"
-msgid "You can browse the full <link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\">List of Categories and Functions</link>"
+msgid "You can browse the full <link href=\"text/scalc/01/04060100.xhp\" name=\"List of Categories and Functions\"><emph>List of Categories and Functions</emph></link>."
 msgstr ""
 
 #: 04060000.xhp
@@ -3517,7 +3517,7 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3149566\n"
 "help.text"
-msgid "<ahelp hid=\"formula/ui/formuladialog/array\">Specifies that the selected function is inserted into the selected cell range as an array formula. </ahelp> Array formulas operate on multiple cells. Each cell in the array contains the formula, not as a copy but as a common formula shared by all matrix cells."
+msgid "<ahelp hid=\"formula/ui/formuladialog/array\">Specifies that the selected function is inserted into the selected cell range as an array formula.</ahelp> Array formulas operate on multiple cells. Each cell in the array contains the formula, not as a copy but as a common formula shared by all matrix cells."
 msgstr ""
 
 #: 04060000.xhp
@@ -3525,8 +3525,8 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3155959\n"
 "help.text"
-msgid "The <emph>Array</emph> option is identical to the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces { }."
-msgstr "<emph>[陣列]</emph> 選項等同於 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter 指令，可用於在工作表中輸入並確認公式。此公式會插入為陣列公式，以兩個大括號 { } 表示。"
+msgid "The <emph>Array</emph> option is identical to the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph> command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces: <emph>{ }</emph>."
+msgstr ""
 
 #: 04060000.xhp
 msgctxt ""
@@ -3549,8 +3549,8 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3145587\n"
 "help.text"
-msgid "When you double-click a function, the argument input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell, or drag across the required range on the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using <link href=\"text/scalc/01/04060102.xhp\" name=\"date entries\">date entries</link>, make sure you use the correct format. Click OK to insert the result into the spreadsheet."
-msgstr "連按兩下某個函式後，其引數輸入欄位會顯示在對話方塊的右側。若要將儲存格參照選取為引數，請直接按一下此儲存格，或按住滑鼠按鈕，在試算表上拖曳所需的儲存格範圍。您也可以在對話方塊的對應欄位中，直接輸入數值與其他值或參照。使用<link href=\"text/scalc/01/04060102.xhp\" name=\"日期項目\">日期項目</link>時，請務必使用正確的格式。按一下 [確定] 以將結果插入試算表中。"
+msgid "When you double-click a function, the argument input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell, or drag across the required range on the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using <link href=\"text/scalc/01/04060102.xhp\" name=\"date entries\"><emph>date entries</emph></link>, make sure you use the correct format. Click <emph>OK</emph> to insert the result into the spreadsheet."
+msgstr ""
 
 #: 04060000.xhp
 msgctxt ""
@@ -3565,8 +3565,8 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3155809\n"
 "help.text"
-msgid "As soon you enter arguments in the function, the result is calculated. This preview informs you if the calculation can be carried out with the arguments given. If the arguments result in an error, the corresponding <link href=\"text/scalc/05/02140000.xhp\" name=\"error code\">error code</link> is displayed."
-msgstr "您在函式中輸入自變數後，便會開始執行計算。您可透過預覽功能得知，含所輸入自變數的函式計算是否可執行。若自變數導致錯誤發生，您會在此得到一個對應的<link href=\"text/scalc/05/02140000.xhp\" name=\"錯誤碼\">錯誤碼</link>。"
+msgid "As soon you enter arguments in the function, the result is calculated. This preview informs you if the calculation can be carried out with the arguments given. If the arguments result in an error, the corresponding <link href=\"text/scalc/05/02140000.xhp\" name=\"error code\"><emph>error code</emph></link> is displayed."
+msgstr ""
 
 #: 04060000.xhp
 msgctxt ""
@@ -3677,7 +3677,7 @@ msgctxt ""
 "04060000.xhp\n"
 "par_id3149316\n"
 "help.text"
-msgid "<ahelp hid=\"formula/ui/formuladialog/next\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next </emph>button, the selection appears in the formula window."
+msgid "<ahelp hid=\"formula/ui/formuladialog/next\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next</emph> button, the selection appears in the formula window."
 msgstr ""
 
 #: 04060000.xhp
@@ -5091,6 +5091,14 @@ msgstr ""
 #: 04060102.xhp
 msgctxt ""
 "04060102.xhp\n"
+"par_id651547654187646\n"
+"help.text"
+msgid "Time zone information is not used in Date and Time functions and cells."
+msgstr ""
+
+#: 04060102.xhp
+msgctxt ""
+"04060102.xhp\n"
 "par_idN1067A\n"
 "help.text"
 msgid "Functions"
@@ -6349,16 +6357,16 @@ msgctxt ""
 "04060103.xhp\n"
 "bm_id3159147\n"
 "help.text"
-msgid "<bookmark_value>annual net interest rates</bookmark_value>         <bookmark_value>calculating; annual net interest rates</bookmark_value>         <bookmark_value>net annual interest rates</bookmark_value>         <bookmark_value>EFFECTIVE function</bookmark_value>"
-msgstr "<bookmark_value>年淨利率</bookmark_value>         <bookmark_value>計算; 年淨利率</bookmark_value>         <bookmark_value>淨年利率</bookmark_value>         <bookmark_value>EFFECTIVE 函式</bookmark_value>"
+msgid "<bookmark_value>annual net interest rates</bookmark_value>         <bookmark_value>calculating; annual net interest rates</bookmark_value>         <bookmark_value>net annual interest rates</bookmark_value>         <bookmark_value>EFFECT function</bookmark_value>"
+msgstr ""
 
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "hd_id3159147\n"
 "help.text"
-msgid "EFFECTIVE"
-msgstr "EFFECTIVE"
+msgid "EFFECT"
+msgstr ""
 
 #: 04060103.xhp
 msgctxt ""
@@ -6381,8 +6389,8 @@ msgctxt ""
 "04060103.xhp\n"
 "par_id3148805\n"
 "help.text"
-msgid "EFFECTIVE(Nom; P)"
-msgstr "EFFECTIVE(Nom; P)"
+msgid "EFFECT(Nom; P)"
+msgstr ""
 
 #: 04060103.xhp
 msgctxt ""
@@ -6413,8 +6421,8 @@ msgctxt ""
 "04060103.xhp\n"
 "par_id3150772\n"
 "help.text"
-msgid "<item type=\"input\">=EFFECTIVE(9.75%;4)</item> = 10.11% The annual effective rate is therefore 10.11%."
-msgstr "<item type=\"input\">=EFFECTIVE(9.75%;4)</item> = 10.11%。因此，實際年利率為 10.11%。"
+msgid "<item type=\"input\">=EFFECT(9.75%;4)</item> = 10.11% The annual effective rate is therefore 10.11%."
+msgstr ""
 
 #: 04060103.xhp
 msgctxt ""
@@ -9885,8 +9893,8 @@ msgctxt ""
 "04060106.xhp\n"
 "par_id3154297\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_ARCTAN2\">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_ARCTAN2\">傳回指定的 x 與 y 座標的反正切值。</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_ARCTAN2\">Returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY).</ahelp>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -9899,10 +9907,10 @@ msgstr "ATAN2(NumberX; NumberY)"
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"par_id3151168\n"
+"par_id3001800\n"
 "help.text"
 msgid "<emph>NumberX</emph> is the value of the x coordinate."
-msgstr "<emph>NumberX</emph> 是 X 座標的數值。"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -9915,34 +9923,74 @@ msgstr "<emph>NumberY</emph> 是 Y 座標的數值。"
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"par_id5036164\n"
+"par_id5036168\n"
 "help.text"
-msgid "ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI."
-msgstr "ATAN2 傳回反三角正切值，亦即 X 軸與點 (NumberX, NumberY) 到原點間直線的角度 (弧度)。傳回的角度介於 -PI 與 PI 之間。"
+msgid "Programming languages have usually the opposite order of arguments for their atan2() function."
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
-"par_id3001800\n"
+"par_id5036165\n"
 "help.text"
-msgid "To return the angle in degrees, use the DEGREES function."
-msgstr "若要得出角度，請使用 DEGREES 函式。"
+msgid "ATAN2 returns the angle (in radians) between the x-axis and a line from the origin to the point (NumberX|NumberY)"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
 "par_id3154692\n"
 "help.text"
-msgid "<item type=\"input\">=ATAN2(20;20)</item> returns 0.785398163397448 (PI/4 radians)."
-msgstr "<item type=\"input\">=ATAN2(20;20)</item> 傳回 0.785398163397448 (PI/4 弧度)。"
+msgid "<item type=\"input\">=ATAN2(-5;9)</item> returns 2.07789 radians."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036166\n"
+"help.text"
+msgid "To get the angle in degrees apply the DEGREES function to the result."
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
 "par_id1477095\n"
 "help.text"
-msgid "<item type=\"input\">=DEGREES(ATAN2(12.3;12.3))</item> returns 45. The tangent of 45 degrees is 1."
-msgstr "<item type=\"input\">=DEGREES(ATAN2(12.3;12.3))</item> 傳回 45。45 度的正切值為 1。"
+msgid "<input>=DEGREES(ATAN2(12.3;12.3))</input> returns 45. The tangent of 45 degrees is 1."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036167\n"
+"help.text"
+msgid "%PRODUCTNAME results 0 for ATAN2(0;0)."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036169\n"
+"help.text"
+msgid "The function can be used in converting cartesian coordinates to polar coordinates."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036170\n"
+"help.text"
+msgid "=DEGREES(ATAN2(-8;5)) returns φ =  147.9 degrees"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id5036171\n"
+"help.text"
+msgid "<image id=\"img_id3150758\" src=\"media/helpimg/scalc/coordinates-to-polar-01.svg\" width=\"2.5inch\" height=\"1.5inch\"><alt id=\"alt_id3150758\">Cartesian coordinates to polar coordinates example</alt></image>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -17917,8 +17965,8 @@ msgctxt ""
 "04060109.xhp\n"
 "par_id3153884\n"
 "help.text"
-msgid "<emph>Array</emph> is the reference, which is to comprise at least two columns."
-msgstr "<emph>Array</emph> 是參照，至少包含兩欄。"
+msgid "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument."
+msgstr ""
 
 #: 04060109.xhp
 msgctxt ""
@@ -27197,8 +27245,8 @@ msgctxt ""
 "04060118.xhp\n"
 "par_id3150525\n"
 "help.text"
-msgid "Calculation of the net present value for the above-mentioned five payments for a notional internal rate of return of 6%."
-msgstr "計算上述五種支付方式，於算出的利率為 6% 時的資本額："
+msgid "Calculation of the net present value for the above-mentioned five payments for a national internal rate of return of 6%."
+msgstr ""
 
 #: 04060118.xhp
 msgctxt ""
@@ -41285,8 +41333,8 @@ msgctxt ""
 "05030300.xhp\n"
 "par_id3148645\n"
 "help.text"
-msgid "Select the rows or columns that you want to hide, and then choose <emph>Format - Row - Hide </emph>or<emph> Format - Column - Hide</emph>."
-msgstr "請您選取想要隱藏的列或欄，然後請在<emph>「格式」</emph>功能表中選取<emph>「列」-「隱藏」</emph>指令，或<emph>「欄」-「隱藏」</emph>。"
+msgid "Select the rows or columns that you want to hide, and then choose <emph>Format - Rows - Hide </emph>or<emph> Format - Columns - Hide</emph>."
+msgstr ""
 
 #: 05030300.xhp
 msgctxt ""
@@ -41325,8 +41373,8 @@ msgctxt ""
 "05030300.xhp\n"
 "par_id5532090\n"
 "help.text"
-msgid "Choose <link href=\"text/scalc/01/05030400.xhp\" name=\"Format - Row/Column - Show\">Format - Row/Column - Show</link> or <link href=\"text/scalc/01/05050300.xhp\" name=\"Format - Sheet - Show\">Format - Sheet - Show</link>."
-msgstr "選擇<link href=\"text/scalc/01/05030400.xhp\" name=\"格式 - 列/欄 - 顯示\">[格式] - [列]/[欄] - [顯示]</link> 或<link href=\"text/scalc/01/05050300.xhp\" name=\"格式 - 試算表 - 顯示\">[格式] - [試算表] - [顯示]</link>。"
+msgid "Choose <link href=\"text/scalc/01/05030400.xhp\" name=\"Format - Rows/Columns - Show\">Format - Rows/Columns - Show</link> or <link href=\"text/scalc/01/05050300.xhp\" name=\"Format - Sheet - Show\">Format - Sheet - Show</link>."
+msgstr ""
 
 #: 05030400.xhp
 msgctxt ""
@@ -41365,15 +41413,15 @@ msgctxt ""
 "05030400.xhp\n"
 "par_id3155131\n"
 "help.text"
-msgid "To show a column or row, select the range of rows or columns containing the hidden elements, then choose <emph>Format - Row - Show</emph> or <emph>Format - Column - Show</emph>."
-msgstr "您可選取包含已隱藏元素的列或欄區域來顯示列或欄，然後選取<emph>「格式」-「列」-「顯示」</emph>或是<emph>「格式」-「欄」-「顯示」</emph>指令。"
+msgid "To show a column or row, select the range of rows or columns containing the hidden elements, then choose <emph>Format - Rows - Show</emph> or <emph>Format - Columns - Show</emph>."
+msgstr ""
 
 #: 05030400.xhp
 msgctxt ""
 "05030400.xhp\n"
 "par_id3155132\n"
 "help.text"
-msgid "For example, to show the column B, click on the header of the column A, expand the selection to the column C, then chose <emph>Format - Column - Show</emph>. To show the column A previously hidden, click on the header of the column B, keep the mouse button pressed and drag on the left. The selected range displayed in the name area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Column - Show</emph>. Proceed the same way with rows."
+msgid "For example, to show the column B, click on the header of the column A, expand the selection to the column C, then chose <emph>Format - Columns - Show</emph>. To show the column A previously hidden, click on the header of the column B, keep the mouse button pressed and drag on the left. The selected range displayed in the name area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Columns - Show</emph>. Proceed the same way with rows."
 msgstr ""
 
 #: 05030400.xhp
@@ -41485,8 +41533,8 @@ msgctxt ""
 "05040200.xhp\n"
 "par_id3146120\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
-msgstr "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">定義最適欄寬以便顯示整個欄的內容。</ahelp> 最適欄寬的附加間隔預設為 0.1 英吋。"
+msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 2 mm."
+msgstr ""
 
 #: 05050000.xhp
 msgctxt ""
@@ -43085,7 +43133,7 @@ msgctxt ""
 "05120000.xhp\n"
 "par_id31494133\n"
 "help.text"
-msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set          explanations below, depending on which visual representation the conditional formatting should be represented."
+msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented."
 msgstr ""
 
 #: 05120000.xhp
@@ -43133,7 +43181,7 @@ msgctxt ""
 "05120000.xhp\n"
 "par_id31494139\n"
 "help.text"
-msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference.      If the cell reference is a value other than zero, the condition matches."
+msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches."
 msgstr ""
 
 #: 05120000.xhp
@@ -43341,7 +43389,7 @@ msgctxt ""
 "05120000.xhp\n"
 "par_id31546818\n"
 "help.text"
-msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>"
+msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>."
 msgstr ""
 
 #: 05120000.xhp
@@ -44413,8 +44461,8 @@ msgctxt ""
 "06070000.xhp\n"
 "bm_id3145673\n"
 "help.text"
-msgid "<bookmark_value>calculating; auto calculating sheets</bookmark_value><bookmark_value>recalculating;auto calculating sheets</bookmark_value><bookmark_value>AutoCalculate function in sheets</bookmark_value><bookmark_value>correcting sheets automatically</bookmark_value><bookmark_value>formulas;AutoCalculate function</bookmark_value><bookmark_value>cell contents;AutoCalculate function</bookmark_value>"
-msgstr "<bookmark_value>計算; 自動計算試算表</bookmark_value><bookmark_value>重新計算; 自動計算試算表</bookmark_value><bookmark_value>試算表中的自動計算功能</bookmark_value><bookmark_value>自動校正試算表</bookmark_value><bookmark_value>公式; 自動計算功能</bookmark_value><bookmark_value>儲存格內容; 自動計算功能</bookmark_value>"
+msgid "<bookmark_value>calculating; auto calculating sheets</bookmark_value><bookmark_value>recalculate;auto calculating sheets</bookmark_value><bookmark_value>recalculating;auto calculating sheets</bookmark_value><bookmark_value>AutoCalculate function in sheets</bookmark_value><bookmark_value>correcting sheets automatically</bookmark_value><bookmark_value>formulas;AutoCalculate function</bookmark_value><bookmark_value>cell contents;AutoCalculate function</bookmark_value>"
+msgstr ""
 
 #: 06070000.xhp
 msgctxt ""
@@ -44453,8 +44501,8 @@ msgctxt ""
 "06080000.xhp\n"
 "bm_id3157909\n"
 "help.text"
-msgid "<bookmark_value>recalculating;all formulas in sheets</bookmark_value><bookmark_value>formulas; recalculating manually</bookmark_value><bookmark_value>cell contents; recalculating</bookmark_value>"
-msgstr "<bookmark_value>重新計算; 試算表中的所有公式</bookmark_value><bookmark_value>公式; 手動重新計算</bookmark_value><bookmark_value>儲存格內容; 重新計算</bookmark_value>"
+msgid "<bookmark_value>recalculating;all formulas in sheets</bookmark_value><bookmark_value>recalculate;all formulas in sheets</bookmark_value><bookmark_value>formulas; recalculating manually</bookmark_value><bookmark_value>cell contents; recalculating</bookmark_value>"
+msgstr ""
 
 #: 06080000.xhp
 msgctxt ""
@@ -44469,8 +44517,24 @@ msgctxt ""
 "06080000.xhp\n"
 "par_id3154758\n"
 "help.text"
-msgid "<ahelp hid=\".uno:Calculate\">Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.</ahelp>"
-msgstr "<ahelp hid=\".uno:Calculate\">重新計算所有已變更的公式。若啟用 [自動計算]，則 [重新計算] 指令僅適用於如 RAND 或 NOW 等公式。</ahelp>"
+msgid "<ahelp hid=\".uno:Calculate\">If AutoCalculate is disabled, the Recalculate command recalculates all (so-called dirty) formula cells that depend on changed cell content and their dependents, and formula cells containing volatile functions such as RAND() or NOW() and formula cells that depend on them.</ahelp>"
+msgstr ""
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3154759\n"
+"help.text"
+msgid "<ahelp hid=\".uno:Calculate\">If AutoCalculate is enabled, the Recalculate command applies only to formula cells containing volatile functions like RAND() or NOW() and formula cells that depend on them.</ahelp>"
+msgstr ""
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3154753\n"
+"help.text"
+msgid "<ahelp hid=\".uno:Calculate\">In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.</ahelp>"
+msgstr ""
 
 #: 06080000.xhp
 msgctxt ""
@@ -44485,15 +44549,31 @@ msgctxt ""
 "06080000.xhp\n"
 "par_id3150793\n"
 "help.text"
-msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
-msgstr "重新計算文件後，會重新整理顯示內容。同時也會重新整理所有圖表。"
+msgid "Recalculation options are, Recalculation on File Load, with values:"
+msgstr ""
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3150795\n"
+"help.text"
+msgid "Always recalculate, Never recalculate (default option), Prompt user."
+msgstr ""
 
 #: 06080000.xhp
 msgctxt ""
 "06080000.xhp\n"
 "par_id315475855\n"
 "help.text"
-msgid "Volatile (delivering different results on each call) Add-In functions currently cannot respond to the Recalculate command or F9. Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas, including the Add-In functions."
+msgid "Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells."
+msgstr ""
+
+#: 06080000.xhp
+msgctxt ""
+"06080000.xhp\n"
+"par_id3150799\n"
+"help.text"
+msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
 msgstr ""
 
 #: 06130000.xhp
@@ -44789,8 +44869,8 @@ msgctxt ""
 "12010100.xhp\n"
 "par_id3154684\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>."
-msgstr "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">向資料庫中加入新資料條目時，文件內的資料庫範圍中會自動插入新的列或欄。</ahelp>若要手動更新資料庫範圍，請選擇 <emph>[資料] - [重新整理範圍]</emph>。"
+msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh Range</emph>."
+msgstr ""
 
 #: 12010100.xhp
 msgctxt ""
@@ -45550,7 +45630,7 @@ msgctxt ""
 "hd_id3145272\n"
 "help.text"
 msgid "Regular expression"
-msgstr "常規表達"
+msgstr "常規表述式"
 
 #: 12040201.xhp
 msgctxt ""
@@ -45558,7 +45638,7 @@ msgctxt ""
 "par_id3152576\n"
 "help.text"
 msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/regexp\">Allows you to use regular expressions in the filter definition.</ahelp> For a list of the regular expressions that $[officename] supports, click <link href=\"text/shared/01/02100001.xhp\" name=\"here\">here</link>."
-msgstr "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/regexp\">允許您在篩選定義中使用萬用字元。</ahelp>如果需要 $[officename] 支援的常規表示式之清單，請在 <link href=\"text/shared/01/02100001.xhp\" name=\"此處\">[此處]</link> 按一下。"
+msgstr "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/regexp\">允許您在篩選定義中使用萬用字元。</ahelp>如果需要 $[officename] 支援的常規表述式之清單，請在 <link href=\"text/shared/01/02100001.xhp\" name=\"此處\">此處</link> 按一下。"
 
 #: 12040201.xhp
 msgctxt ""
@@ -45566,7 +45646,7 @@ msgctxt ""
 "par_id3149377\n"
 "help.text"
 msgid "If the <emph>Regular Expressions</emph> check box is selected, you can use regular expressions in the Value field if the Condition list box is set to '=' EQUAL or '<>' UNEQUAL. This also applies to the respective cells that you reference for an advanced filter."
-msgstr "如果已選取 <emph>[常規表示式]</emph> 核取方塊，也可以在 [條件] 清單設定為 '=' EQUAL 或 '<>' UNEQUAL 的情況下，在 [值] 欄位中使用常規表示式。此情況也適用於進階篩選器之參照的個別的儲存格。"
+msgstr "如果已選取「<emph>常規表述式</emph>」核取方塊，也可以在「條件」清單設定為 '=' EQUAL 或 '<>' UNEQUAL 的情況下，在「值」欄位中使用常規表示式。此情況也適用於進階篩選器之參照的個別的儲存格。"
 
 #: 12040201.xhp
 msgctxt ""
@@ -47702,7 +47782,7 @@ msgctxt ""
 "hd_id3156327\n"
 "help.text"
 msgid "Regular Expression"
-msgstr "常規表達"
+msgstr "常規表述式"
 
 #: 12090104.xhp
 msgctxt ""
@@ -47718,7 +47798,7 @@ msgctxt ""
 "par_id3147264\n"
 "help.text"
 msgid "If the <emph>Regular Expression</emph> check box is selected, you can use EQUAL (=) and NOT EQUAL (<>) also in comparisons. You can also use the following functions: DCOUNTA, DGET, MATCH, COUNTIF, SUMIF, LOOKUP, VLOOKUP and HLOOKUP."
-msgstr "如果已選取<emph>[常規表達]</emph>核取方塊，您可以在比較運算中使用 EQUAL (=) 和 NOT EQUAL (<>)。您還可以使用下列函式：DCOUNTA、DGET、MATCH、COUNTIF、SUMIF、LOOKUP、VLOOKUP 和 HLOOKUP。"
+msgstr "如果已選取「<emph>常規表述式</emph>」核取方塊，您可以在比較運算中使用 EQUAL (=) 和 NOT EQUAL (<>)。您還可以使用下列函式：DCOUNTA、DGET、MATCH、COUNTIF、SUMIF、LOOKUP、VLOOKUP 和 HLOOKUP。"
 
 #: 12090104.xhp
 msgctxt ""
@@ -47758,7 +47838,7 @@ msgctxt ""
 "par_id3154011\n"
 "help.text"
 msgid "<link href=\"text/shared/01/02100001.xhp\" name=\"List of Regular Expressions\">List of Regular Expressions</link>"
-msgstr "<link href=\"text/shared/01/02100001.xhp\" name=\"常規表示式的清單\">常規表示式的清單</link>"
+msgstr "<link href=\"text/shared/01/02100001.xhp\" name=\"常規表述式的清單\">常規表述式的清單</link>"
 
 #: 12090105.xhp
 msgctxt ""
@@ -49331,10 +49411,10 @@ msgstr "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/errorMsg\">輸入當儲�
 #: 12120300.xhp
 msgctxt ""
 "12120300.xhp\n"
-"par_id3150752\n"
+"hd_id881545240342781\n"
 "help.text"
-msgid "<emph>Sample macro:</emph>"
-msgstr "<emph>示例巨集：</emph>"
+msgid "Sample macro:"
+msgstr ""
 
 #: ODFF.xhp
 msgctxt ""
@@ -52133,7 +52213,7 @@ msgctxt ""
 "func_days.xhp\n"
 "par_id3159101\n"
 "help.text"
-msgid "<item type=\"input\">=DAYS(\"2010-01-01\"; NOW())</item>  returns the number of days from today until January 1, 2010."
+msgid "<item type=\"input\">=DAYS(NOW();\"2010-01-01\"))</item> returns the number of days from January 1, 2010 until today."
 msgstr ""
 
 #: func_days.xhp
@@ -58219,6 +58299,14 @@ msgstr ""
 #: statistics.xhp
 msgctxt ""
 "statistics.xhp\n"
+"par_id841554943563747\n"
+"help.text"
+msgid "F-critical"
+msgstr ""
+
+#: statistics.xhp
+msgctxt ""
+"statistics.xhp\n"
 "par_id1001610\n"
 "help.text"
 msgid "Between Groups"
@@ -58227,6 +58315,14 @@ msgstr ""
 #: statistics.xhp
 msgctxt ""
 "statistics.xhp\n"
+"par_id411554944014360\n"
+"help.text"
+msgid "3.340385558"
+msgstr ""
+
+#: statistics.xhp
+msgctxt ""
+"statistics.xhp\n"
 "par_id1001670\n"
 "help.text"
 msgid "Within Groups"