summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-04-25 22:51:37 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-04-25 23:06:53 +0200
commit61991bde16235b2c9c4028466bcdc51a352e7bc5 (patch)
treeb2d7059a15a64a79ef1f2dd05566586eebdaaf1a /source/zh-TW/helpcontent2/source/text/scalc/01.po
parente3802bb90081c3cc63ca8ec9726772d8e42299b0 (diff)
update translatiosn for 6.1.0 alpha1
Change-Id: I0ed5d948cf89a4260c8771057d463448b76a4527
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po1196
1 files changed, 910 insertions, 286 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index fa37d73f704..80b0618b6ce 100644
--- a/source/zh-TW/helpcontent2/source/text/scalc/01.po
+++ b/source/zh-TW/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ 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: 2017-12-18 12:32+0100\n"
+"POT-Creation-Date: 2018-04-25 13:24+0200\n"
"PO-Revision-Date: 2018-02-05 09:13+0000\n"
"Last-Translator: leo <loveohead@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\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.8\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1517822010.000000\n"
#: 01120000.xhp
@@ -1189,8 +1189,8 @@ msgctxt ""
"02140600.xhp\n"
"par_id3148797\n"
"help.text"
-msgid "<variable id=\"reihenfuellentext\"><ahelp hid=\".uno:FillSeries\">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp></variable>"
-msgstr "<variable id=\"reihenfuellentext\"><ahelp hid=\".uno:FillSeries\">在此對話方塊自動產生具有選項的排列。決定方向、遞增、時間單位與排列類型。</ahelp></variable>"
+msgid "<variable id=\"reihenfuellentext\"><ahelp hid=\".uno:FillSeries\">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp> </variable>"
+msgstr ""
#: 02140600.xhp
msgctxt ""
@@ -1405,8 +1405,8 @@ msgctxt ""
"02140600.xhp\n"
"par_id3148605\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/filldlg/day\">Use the <emph>Date</emph> series type and this option to create a series using seven days.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/day\">使用 <emph>[日期]</emph> 系列類型和此選項建立以 7 天為時間單位的系列。</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/filldlg/day\">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp>"
+msgstr ""
#: 02140600.xhp
msgctxt ""
@@ -1421,8 +1421,8 @@ msgctxt ""
"02140600.xhp\n"
"par_id3150108\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/filldlg/week\">Use the <emph>Date</emph> series type and this option to create a series of five day sets.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/week\">使用 <emph>[日期]</emph> 排列類型和此選項建立以五天為一組的排列。</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/filldlg/week\">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp>"
+msgstr ""
#: 02140600.xhp
msgctxt ""
@@ -1437,8 +1437,8 @@ msgctxt ""
"02140600.xhp\n"
"par_id3149126\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/filldlg/month\">Use the <emph>Date</emph> series type and this option to form a series from the names or abbreviations of the months.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/month\">使用 <emph>[日期]</emph> 系列類型和此選項依照月份名稱或其縮寫建立以月為時間單位的系列。</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/filldlg/month\">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp>"
+msgstr ""
#: 02140600.xhp
msgctxt ""
@@ -1453,8 +1453,8 @@ msgctxt ""
"02140600.xhp\n"
"par_id3151300\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/filldlg/year\">Use the <emph>Date</emph> series type and this option to create a series of years.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/year\">使用 <emph>[日期]</emph> 排列類型和此選項建立以年為單位的排列。</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/filldlg/year\">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp>"
+msgstr ""
#: 02140600.xhp
msgctxt ""
@@ -2643,6 +2643,14 @@ msgstr "若要移除色彩標明,請取消標記此功能表條目。"
#: 03080000.xhp
msgctxt ""
"03080000.xhp\n"
+"par_id3145784\n"
+"help.text"
+msgid "By default:"
+msgstr ""
+
+#: 03080000.xhp
+msgctxt ""
+"03080000.xhp\n"
"par_id3145785\n"
"help.text"
msgid "Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted."
@@ -2651,6 +2659,14 @@ msgstr "文字儲存格的格式設定為黑色,公式為綠色,數字儲存
#: 03080000.xhp
msgctxt ""
"03080000.xhp\n"
+"par_id3145786\n"
+"help.text"
+msgid "These colors can be customized in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME - Application Colors</item>."
+msgstr ""
+
+#: 03080000.xhp
+msgctxt ""
+"03080000.xhp\n"
"par_id3153188\n"
"help.text"
msgid "If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again."
@@ -4213,7 +4229,7 @@ msgctxt ""
"04060101.xhp\n"
"par_id3882869\n"
"help.text"
-msgid "See also the Wiki page about <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\">Conditional Counting and Summation</link>."
+msgid "See also the Wiki page about <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation\">Conditional Counting and Summation</link>."
msgstr ""
#: 04060101.xhp
@@ -9933,8 +9949,56 @@ msgctxt ""
"04060105.xhp\n"
"par_id3149312\n"
"help.text"
-msgid "<variable id=\"logischtext\">This category contains the <emph>Logical</emph> functions. </variable>"
-msgstr "<variable id=\"logischtext\">此分類包含<emph>邏輯</emph>函式。 </variable>"
+msgid "<variable id=\"logischtext\">This category contains the <emph>Logical</emph> functions.</variable>"
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"hd_id631520887352751\n"
+"help.text"
+msgid "Handling non-logical arguments in logical functions"
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"par_id431520887384579\n"
+"help.text"
+msgid "Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE."
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"par_id881520887475288\n"
+"help.text"
+msgid "Empty cells and text in cells are ignored."
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"par_id461520887504085\n"
+"help.text"
+msgid "A #VALUE error is raised if all arguments are ignored."
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"par_id591520888006686\n"
+"help.text"
+msgid "A #VALUE error is raised if one argument is direct text (not text in a cell)."
+msgstr ""
+
+#: 04060105.xhp
+msgctxt ""
+"04060105.xhp\n"
+"par_id321520889630477\n"
+"help.text"
+msgid "Errors as argument lead to an error."
+msgstr ""
#: 04060105.xhp
msgctxt ""
@@ -9989,8 +10053,8 @@ msgctxt ""
"04060105.xhp\n"
"par_id3150038\n"
"help.text"
-msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row. The result is TRUE if the logical value in all cells within the cell range is TRUE."
-msgstr "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> 是指要檢查的條件。所有條件可以是 TRUE 或 FALSE。若輸入範圍作為參數,函式會使用目前欄範圍或列範圍的值。若儲存格範圍內所有儲存格的邏輯值為 TRUE,則結果為 TRUE。"
+msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE."
+msgstr ""
#: 04060105.xhp
msgctxt ""
@@ -10285,8 +10349,8 @@ msgctxt ""
"04060105.xhp\n"
"par_id3155819\n"
"help.text"
-msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row."
-msgstr "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> 是指要檢查的條件。所有條件可以是 TRUE 或 FALSE。若輸入範圍作為參數,函式會使用目前欄範圍或列範圍的值。"
+msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range."
+msgstr ""
#: 04060105.xhp
msgctxt ""
@@ -12645,8 +12709,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3148548\n"
"help.text"
-msgid "The <emph>visible</emph> decimal places of the result are specified in <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences </caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">%PRODUCTNAME Calc - Calculate</link>."
-msgstr ""
+msgid "The <emph>visible</emph> decimal places of the result are specified in <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">%PRODUCTNAME Calc - Calculate</link>."
+msgstr "<emph>可視</emph>的結果小數點位置,指定於 <switchinline select=\"sys\"><caseinline select=\"MAC\">[%PRODUCTNAME] - [喜好設定]</caseinline><defaultinline>[工具] - [選項]</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">[%PRODUCTNAME Calc] - [計算]</link> 之中。"
#: 04060106.xhp
msgctxt ""
@@ -13067,6 +13131,206 @@ msgstr "<item type=\"input\">=CEILING(-11;-2)</item> 傳回 -10。"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
+"bm_id911516997198644\n"
+"help.text"
+msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id91516997330445\n"
+"help.text"
+msgid "CEILING.MATH"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id81516997342088\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id971516997377435\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id841516997669932\n"
+"help.text"
+msgid "CEILING.MATH(Number; Significance; Mode)"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id651516997706287\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded up."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id491516997725772\n"
+"help.text"
+msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id451516997742909\n"
+"help.text"
+msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id561516997761868\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id111516997803684\n"
+"help.text"
+msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id1001516997821483\n"
+"help.text"
+msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id641516997837754\n"
+"help.text"
+msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"bm_id921516998608939\n"
+"help.text"
+msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id411516998838823\n"
+"help.text"
+msgid "CEILING.XCL"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id811516998845826\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id361516998851918\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id251516998856873\n"
+"help.text"
+msgid "CEILING.XCL(Number; Significance)"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id671516998874263\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id151516998882622\n"
+"help.text"
+msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id341516998889754\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions."
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"hd_id81516998896303\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id91516998917254\n"
+"help.text"
+msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id761516998929693\n"
+"help.text"
+msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id671516998958873\n"
+"help.text"
+msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
"bm_id8952518\n"
"help.text"
msgid "<bookmark_value>ISO.CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
@@ -13693,8 +13957,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id7985168\n"
"help.text"
-msgid "QUOTIENT is equivalent to <item type=\"literal\">INT(numerator/denominator)</item>, except that it may report errors with different error codes."
-msgstr "QUOTIENT 相當於 <item type=\"literal\">INT(分子/分母)</item>,所不同者為其可能使用不同的錯誤碼報告錯誤。"
+msgid "QUOTIENT is equivalent to <item type=\"literal\">INT(numerator/denominator)</item> for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to <item type=\"literal\">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>."
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -14477,8 +14741,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3151828\n"
"help.text"
-msgid "In order to enter this as an array formula, you must press the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command </caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the <emph>Formula</emph> bar enclosed in braces."
-msgstr ""
+msgid "In order to enter this as an array formula, you must press the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the <emph>Formula</emph> bar enclosed in braces."
+msgstr "為將此輸入為陣列公式,您必須按 Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command </caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter 組合鍵,而非只按 Enter 鍵關閉公式。然後在 <emph>[公式]</emph> 列中將會顯示此公式,且前後括有大括號。"
#: 04060106.xhp
msgctxt ""
@@ -15813,8 +16077,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id2855616\n"
"help.text"
-msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9."
-msgstr ""
+msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9."
+msgstr "此函式會在每次 Calc 重新計算時產生新的隨機數。若要手動強制 Calc 重新計算,請按 Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9。"
#: 04060106.xhp
msgctxt ""
@@ -16245,7 +16509,7 @@ msgctxt ""
"04060107.xhp\n"
"par_id936615\n"
"help.text"
-msgid "The row and column separator can be seen and altered in <item type=\"menuitem\">Tools - Options - Calc - Formula - Separators</item>."
+msgid "You can view and change the row and column separator in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Calc - Formula - Separators</emph>."
msgstr ""
#: 04060107.xhp
@@ -19333,8 +19597,8 @@ msgctxt ""
"04060109.xhp\n"
"par_id1027200802301521\n"
"help.text"
-msgid "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth paramater will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted."
-msgstr "開啟 ODF 1.0/1.1 格式的文件時,將工作表名稱顯示為第四個參數的 ADDRESS 函式,會將該工作表名稱移到第五個參數,並新插入值為 1 的第四個參數。"
+msgid "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted."
+msgstr ""
#: 04060109.xhp
msgctxt ""
@@ -20805,7 +21069,7 @@ msgctxt ""
"04060109.xhp\n"
"par_id3150826\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats have to be defined beforehand."
+msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand."
msgstr ""
#: 04060109.xhp
@@ -20869,8 +21133,8 @@ msgctxt ""
"04060109.xhp\n"
"par_id8056886\n"
"help.text"
-msgid "Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example"
-msgstr "由於 STYLE() 的傳回數值為零,此傳回值會附加到字串。如下例所示,使用 T() 可避免此情形。"
+msgid "Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example:"
+msgstr ""
#: 04060109.xhp
msgctxt ""
@@ -20941,8 +21205,8 @@ msgctxt ""
"04060109.xhp\n"
"par_id3149939\n"
"help.text"
-msgid "<emph>Value1...Value30</emph> is the list of values entered as a reference to a cell or as individual values."
-msgstr "<emph>Value1...Value30</emph> 是作為儲存格參照或是作為個別值的數值清單。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values."
+msgstr ""
#: 04060109.xhp
msgctxt ""
@@ -21333,8 +21597,8 @@ msgctxt ""
"04060109.xhp\n"
"par_id2958769\n"
"help.text"
-msgid "<item type=\"input\">=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</item>displays the text Go to Writer bookmark, loads the specified text document and jumps to bookmark \"Specification\"."
-msgstr "<item type=\"input\">=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"進入 Writer 書籤\")</item>顯示 [進入 Writer 書籤] 的文字,載入指定的文字文件並跳至書籤「Specification」。"
+msgid "<item type=\"input\">=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</item> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"."
+msgstr ""
#: 04060109.xhp
msgctxt ""
@@ -21645,8 +21909,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id9912411\n"
"help.text"
-msgid "See <link href=\"http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
-msgstr "轉換映射表請見 <link href=\"http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>。"
+msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
+msgstr ""
#: 04060110.xhp
msgctxt ""
@@ -22573,8 +22837,8 @@ msgctxt ""
"04060110.xhp\n"
"par_id1551561\n"
"help.text"
-msgid "See <link href=\"http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
-msgstr "轉換映射表請見 <link href=\"http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>。"
+msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table."
+msgstr ""
#: 04060110.xhp
msgctxt ""
@@ -24461,8 +24725,8 @@ msgctxt ""
"04060111.xhp\n"
"par_id3147427\n"
"help.text"
-msgid "<variable id=\"addintext\">The following describes and lists some of the available add-in functions. </variable>"
-msgstr "<variable id=\"addintext\">以下列出部份可用的 Add-In 函式,並提供說明。 </variable>"
+msgid "<variable id=\"addintext\">The following describes and lists some of the available add-in functions.</variable>"
+msgstr ""
#: 04060111.xhp
msgctxt ""
@@ -25037,8 +25301,8 @@ msgctxt ""
"04060111.xhp\n"
"par_id3149351\n"
"help.text"
-msgid "Add-ins can also be implemented through the %PRODUCTNAME <link href=\"http://api.libreoffice.org/\">API</link>."
-msgstr "附加元件也可以透過 %PRODUCTNAME <link href=\"http://api.libreoffice.org/\">API</link> 來實作。"
+msgid "Add-ins can also be implemented through the %PRODUCTNAME <link href=\"https://api.libreoffice.org/\" name=\"api.libreoffice.org\">API</link>."
+msgstr ""
#: 04060112.xhp
msgctxt ""
@@ -33661,8 +33925,8 @@ msgctxt ""
"04060119.xhp\n"
"par_id3153321\n"
"help.text"
-msgid "NPV(Rate; Value1; Value2; ...)"
-msgstr "NPV(Rate; Value1; Value2; ...)"
+msgid "NPV(Rate; Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060119.xhp
msgctxt ""
@@ -33677,8 +33941,8 @@ msgctxt ""
"04060119.xhp\n"
"par_id3150427\n"
"help.text"
-msgid "<emph>Value1;...</emph> are up to 30 values, which represent deposits or withdrawals."
-msgstr "<emph>Value1;...</emph> 是指可多達 30 個表示存款或提款的值。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals."
+msgstr ""
#: 04060119.xhp
msgctxt ""
@@ -33693,8 +33957,8 @@ msgctxt ""
"04060119.xhp\n"
"par_id3154800\n"
"help.text"
-msgid "What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were payed as -40 currency units."
-msgstr "貼現率為 8.75 %,各期支付額分別為 10、20 和 30 貨幣單位,第零期支付的成本為 -40 貨幣單位,則淨現值為多少?"
+msgid "What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units."
+msgstr ""
#: 04060119.xhp
msgctxt ""
@@ -35309,16 +35573,16 @@ msgctxt ""
"04060181.xhp\n"
"par_id3148585\n"
"help.text"
-msgid "COUNT(Value1; Value2; ... Value30)"
-msgstr "COUNT(Value1; Value2; ... Value30)"
+msgid "COUNT(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id3155827\n"
"help.text"
-msgid "<emph>Value1; Value2, ...</emph> are 1 to 30 values or ranges representing the values to be counted."
-msgstr "<emph>Value1; Value2, ...</emph> 是指 1 到 30 個表示要計算數值的數值或範圍。"
+msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 values or ranges representing the values to be counted."
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -35381,16 +35645,16 @@ msgctxt ""
"04060181.xhp\n"
"par_id3153111\n"
"help.text"
-msgid "COUNTA(Value1; Value2; ... Value30)"
-msgstr "COUNTA(Value1; Value2; ... Value30)"
+msgid "COUNTA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id3150001\n"
"help.text"
-msgid "<emph>Value1; Value2, ...</emph> are 1 to 30 arguments representing the values to be counted."
-msgstr "<emph>Value1; Value2, ...</emph> 是指 1 到 30 個表示要計算的引數。"
+msgid "<emph>Value1; Value2, ..., Value30</emph> are 1 to 30 arguments representing the values to be counted."
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -35557,40 +35821,40 @@ msgctxt ""
"04060181.xhp\n"
"par_id3581652\n"
"help.text"
-msgid "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - this returns 1"
-msgstr "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - 傳回 1。"
+msgid "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - this returns 1."
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id708639\n"
"help.text"
-msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1"
-msgstr "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - 傳回 1。"
+msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1."
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id5169225\n"
"help.text"
-msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- this returns 4"
-msgstr "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- 傳回 4。"
+msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\")</item> - this returns 4."
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id2118594\n"
"help.text"
-msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6"
-msgstr "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - 當 B1 包含 <item type=\"input\">2006</item> 時,此函式傳回 6。"
+msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6."
+msgstr ""
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id166020\n"
"help.text"
-msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006"
-msgstr "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> 其中儲存格 C2 包含文字 <item type=\"input\">>2006</item>,計算範圍 A1:A10 中 >2006 的儲存格數。"
+msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006."
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -36061,8 +36325,8 @@ msgctxt ""
"04060181.xhp\n"
"par_id3156118\n"
"help.text"
-msgid "<item type=\"input\">=BETADIST(0.75;3;4)</item> returns the value 0.96"
-msgstr "<item type=\"input\">=BETADIST(0.75;3;4)</item> 傳回值 0.96。"
+msgid "<item type=\"input\">=BETADIST(0.75;3;4)</item> returns the value 0.96."
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -37445,7 +37709,7 @@ msgctxt ""
"04060181.xhp\n"
"par_id2745774\n"
"help.text"
-msgid "<item type=\"input\">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3"
+msgid "<item type=\"input\">=CHISQ.DIST(3; 2; 1) </item>equals 0.7768698399, the cumulative chi-square distribution with 2 degrees of freedom, at the value x = 3."
msgstr ""
#: 04060181.xhp
@@ -38949,8 +39213,8 @@ msgctxt ""
"04060182.xhp\n"
"par_id3151015\n"
"help.text"
-msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution"
-msgstr "<emph>Beta</emph> 為 GAMMA 分佈的參數 Beta。"
+msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution."
+msgstr ""
#: 04060182.xhp
msgctxt ""
@@ -39053,8 +39317,8 @@ msgctxt ""
"04060182.xhp\n"
"par_id2406201422390458\n"
"help.text"
-msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution"
-msgstr "<emph>Beta</emph> 為 GAMMA 分佈的參數 Beta。"
+msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution."
+msgstr ""
#: 04060182.xhp
msgctxt ""
@@ -39197,16 +39461,16 @@ msgctxt ""
"04060182.xhp\n"
"par_id3153720\n"
"help.text"
-msgid "GEOMEAN(Number1; Number2; ...Number30)"
-msgstr "GEOMEAN(Number1; Number2; ...Number30)"
+msgid "GEOMEAN(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060182.xhp
msgctxt ""
"04060182.xhp\n"
"par_id3152585\n"
"help.text"
-msgid "<emph>Number1, Number2,...Number30</emph> are numeric arguments or ranges that represent a random sample."
-msgstr "<emph>Number1, Number2,...Number30</emph> 是指代表隨機取樣的數值引數或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample."
+msgstr ""
#: 04060182.xhp
msgctxt ""
@@ -39365,8 +39629,8 @@ msgctxt ""
"04060182.xhp\n"
"par_id0305200911372999\n"
"help.text"
-msgid "See also the <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function\">Wiki page</link>."
-msgstr "也請參見 <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function\">Wiki 頁面</link>。"
+msgid "See also the <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/ZTEST function\">Wiki page</link>."
+msgstr ""
#: 04060182.xhp
msgctxt ""
@@ -39485,16 +39749,16 @@ msgctxt ""
"04060182.xhp\n"
"par_id3149287\n"
"help.text"
-msgid "HARMEAN(Number1; Number2; ...Number30)"
-msgstr "HARMEAN(Number1; Number2; ...Number30)"
+msgid "HARMEAN(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060182.xhp
msgctxt ""
"04060182.xhp\n"
"par_id3154303\n"
"help.text"
-msgid "<emph>Number1,Number2,...Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean."
-msgstr "<emph>Number1,Number2,...Number30</emph> 是指可多達 30 個用以計算調合平均值的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean."
+msgstr ""
#: 04060182.xhp
msgctxt ""
@@ -40509,16 +40773,16 @@ msgctxt ""
"04060183.xhp\n"
"par_id3154508\n"
"help.text"
-msgid "KURT(Number1; Number2; ...Number30)"
-msgstr "KURT(Number1; Number2; ...Number30)"
+msgid "KURT(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060183.xhp
msgctxt ""
"04060183.xhp\n"
"par_id3145167\n"
"help.text"
-msgid "<emph>Number1,Number2,...Number30</emph> are numeric arguments or ranges representing a random sample of distribution."
-msgstr "<emph>Number1、Number2...Number30</emph> 是指表示分佈之隨機抽樣的數值引數或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges representing a random sample of distribution."
+msgstr ""
#: 04060183.xhp
msgctxt ""
@@ -40941,16 +41205,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3147340\n"
"help.text"
-msgid "MAX(Number1; Number2; ...Number30)"
-msgstr "MAX(Number1; Number2; ...Number30)"
+msgid "MAX(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3149568\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41021,16 +41285,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3166431\n"
"help.text"
-msgid "MAXA(Value1; Value2; ... Value30)"
-msgstr "MAXA(Value1; Value2; ... Value30)"
+msgid "MAXA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3150202\n"
"help.text"
-msgid "<emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0."
-msgstr "<emph>Value1; Value2;...Value30</emph> 是數值或範圍。文字的值為 0。"
+msgid "<emph>Value1; Value2;...; Value30</emph> are values or ranges. Text has the value of 0."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41093,16 +41357,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3155264\n"
"help.text"
-msgid "MEDIAN(Number1; Number2; ...Number30)"
-msgstr "MEDIAN(Number1; Number2; ...Number30)"
+msgid "MEDIAN(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3150109\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是指代表樣本的數值或範圍。每個數字也可由參照取代。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges, which represent a sample. Each number can also be replaced by a reference."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41173,16 +41437,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3146964\n"
"help.text"
-msgid "MIN(Number1; Number2; ...Number30)"
-msgstr "MIN(Number1; Number2; ...Number30)"
+msgid "MIN(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3153486\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41245,16 +41509,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3153336\n"
"help.text"
-msgid "MINA(Value1; Value2; ... Value30)"
-msgstr "MINA(Value1; Value2; ... Value30)"
+msgid "MINA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3146098\n"
"help.text"
-msgid "<emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0."
-msgstr "<emph>Value1; Value2;...Value30</emph> 是數值或範圍。文字的值為 0。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41317,16 +41581,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3145636\n"
"help.text"
-msgid "AVEDEV(Number1; Number2; ...Number30)"
-msgstr "AVEDEV(Number1; Number2; ...Number30)"
+msgid "AVEDEV(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3157871\n"
"help.text"
-msgid "<emph>Number1, Number2,...Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference."
-msgstr "<emph>Number1, Number2,...Number30</emph> 是指代表樣本的數值或範圍。每個數字也可由參照取代。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are values or ranges that represent a sample. Each number can also be replaced by a reference."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41381,15 +41645,15 @@ msgctxt ""
"04060184.xhp\n"
"par_id3154679\n"
"help.text"
-msgid "AVERAGE(Number1; Number2; ...Number30)"
-msgstr "AVERAGE(Number1; Number2; ...Number30)"
+msgid "AVERAGE(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3150741\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
msgstr ""
#: 04060184.xhp
@@ -41445,16 +41709,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3149734\n"
"help.text"
-msgid "AVERAGEA(Value1; Value2; ... Value30)"
-msgstr "AVERAGEA(Value1; Value2; ... Value30)"
+msgid "AVERAGEA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3155260\n"
"help.text"
-msgid "<emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0."
-msgstr "<emph>Value1; Value2;...Value30</emph> 是數值或範圍。文字的值為 0。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges. Text has the value of 0."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41509,16 +41773,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id3155950\n"
"help.text"
-msgid "MODE(Number1; Number2; ...Number30)"
-msgstr "MODE(Number1; Number2; ...Number30)"
+msgid "MODE(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id3150337\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41573,16 +41837,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id2955950\n"
"help.text"
-msgid "MODE.SNGL(Number1; Number2; ...Number30)"
-msgstr "MODE(Number1; Number2; ...Number30)"
+msgid "MODE.SNGL(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id2950337\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41645,16 +41909,16 @@ msgctxt ""
"04060184.xhp\n"
"par_id2855950\n"
"help.text"
-msgid "MODE.MULT(Number1; Number2; ...Number30)"
-msgstr "MODE(Number1; Number2; ...Number30)"
+msgid "MODE.MULT(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060184.xhp
msgctxt ""
"04060184.xhp\n"
"par_id2850337\n"
"help.text"
-msgid "<emph>Number1; Number2;...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1; Number2;...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -43605,16 +43869,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3151191\n"
"help.text"
-msgid "SKEW(Number1; Number2; ...Number30)"
-msgstr "SKEW(Number1; Number2; ...Number30)"
+msgid "SKEW(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3155757\n"
"help.text"
-msgid "<emph>Number1, Number2...Number30</emph> are numerical values or ranges."
-msgstr "<emph>Number1, Number2...Number30</emph> 是數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -43829,16 +44093,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3149946\n"
"help.text"
-msgid "STDEV(Number1; Number2; ...Number30)"
-msgstr "STDEV(Number1; Number2; ...Number30)"
+msgid "STDEV(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3157904\n"
"help.text"
-msgid "<emph>Number1, Number2, ... Number30</emph> are numerical values or ranges representing a sample based on an entire population."
-msgstr "<emph>Number1, Number2, ... Number30</emph> 是指代表根據整個總體之樣本的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -43893,16 +44157,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3147422\n"
"help.text"
-msgid "STDEVA(Value1;Value2;...Value30)"
-msgstr "STDEVA(Value1;Value2;...Value30)"
+msgid "STDEVA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3154547\n"
"help.text"
-msgid "<emph>Value1, Value2, ...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0."
-msgstr "<emph>Value1, Value2, ...Value30</emph> 是指代表衍生自整個總體之樣本的數值或範圍。文字的值為 0。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -43957,16 +44221,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3154392\n"
"help.text"
-msgid "STDEVP(Number1;Number2;...Number30)"
-msgstr "STDEVP(Number1;Number2;...Number30)"
+msgid "STDEVP(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3155261\n"
"help.text"
-msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -44021,16 +44285,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id2954392\n"
"help.text"
-msgid "STDEV.P(Number1;Number2;...Number30)"
-msgstr "STDEVP(Number1;Number2;...Number30)"
+msgid "STDEV.P(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id2955261\n"
"help.text"
-msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -44085,16 +44349,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id2854392\n"
"help.text"
-msgid "STDEV.S(Number1;Number2;...Number30)"
-msgstr "STDEVP(Number1;Number2;...Number30)"
+msgid "STDEV.S(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id2855261\n"
"help.text"
-msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample of the population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample of the population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -44149,16 +44413,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3146851\n"
"help.text"
-msgid "STDEVPA(Value1;Value2;...Value30)"
-msgstr "STDEVPA(Value1;Value2;...Value30)"
+msgid "STDEVPA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3153109\n"
"help.text"
-msgid "<emph>Value1,value2,...value30</emph> are values or ranges representing an entire population. Text has the value 0."
-msgstr "<emph>Value1, Value2,...Value30</emph> 是指代表衍生自整個總體之樣本的數值或範圍。文字的值為 0。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population. Text has the value 0."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -44717,16 +44981,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3146790\n"
"help.text"
-msgid "DEVSQ(Number1; Number2; ...Number30)"
-msgstr "DEVSQ(Number1; Number2; ...Number30)"
+msgid "DEVSQ(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3155995\n"
"help.text"
-msgid "<emph>Number1, Number2, ...Number30</emph> numerical values or ranges representing a sample."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表樣本的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45477,16 +45741,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3153054\n"
"help.text"
-msgid "VAR(Number1; Number2; ...Number30)"
-msgstr "VAR(Number1; Number2; ...Number30)"
+msgid "VAR(Number1 ; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3148938\n"
"help.text"
-msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表根據整個總體之樣本的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45541,16 +45805,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id2953054\n"
"help.text"
-msgid "VAR.S(Number1; Number2; ...Number30)"
-msgstr "VAR(Number1; Number2; ...Number30)"
+msgid "VAR.S(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id2948938\n"
"help.text"
-msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing a sample based on an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表根據整個總體之樣本的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing a sample based on an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45605,16 +45869,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3149999\n"
"help.text"
-msgid "VARA(Value1; Value2; ...Value30)"
-msgstr "VARA(Value1; Value2; ...Value30)"
+msgid "VARA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3158421\n"
"help.text"
-msgid "<emph>Value1, Value2,...Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0."
-msgstr "<emph>Value1, Value2,...Value30</emph> 是指代表衍生自整個總體之樣本的數值或範圍。文字的值為 0。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45669,16 +45933,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3147282\n"
"help.text"
-msgid "VARP(Number1; Number2; ...Number30)"
-msgstr "VARP(Number1; Number2; ...Number30)"
+msgid "VARP(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3149793\n"
"help.text"
-msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45733,16 +45997,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id2947282\n"
"help.text"
-msgid "VAR.P(Number1; Number2; ...Number30)"
-msgstr "VARP(Number1; Number2; ...Number30)"
+msgid "VAR.P(Number1; Number2; ...; Number30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id2949793\n"
"help.text"
-msgid "<emph>Number1, Number2, ...Number30</emph> are numerical values or ranges representing an entire population."
-msgstr "<emph>Number1, Number2, ...Number30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Number1, Number2, ..., Number30</emph> are numerical values or ranges representing an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -45797,16 +46061,16 @@ msgctxt ""
"04060185.xhp\n"
"par_id3149967\n"
"help.text"
-msgid "VARPA(Value1; Value2; ...Value30)"
-msgstr "VARPA(Value1; Value2; ...Value30)"
+msgid "VARPA(Value1; Value2; ...; Value30)"
+msgstr ""
#: 04060185.xhp
msgctxt ""
"04060185.xhp\n"
"par_id3149920\n"
"help.text"
-msgid "<emph>Value1,value2,...Value30</emph> are values or ranges representing an entire population."
-msgstr "<emph>Value1,value2,...Value30</emph> 是指代表整個總體的數值或範圍。"
+msgid "<emph>Value1, Value2, ..., Value30</emph> are values or ranges representing an entire population."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -46053,8 +46317,8 @@ msgctxt ""
"04060185.xhp\n"
"par_id3153694\n"
"help.text"
-msgid "<emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start </emph>value is calculated."
-msgstr "<emph>End</emph> (選擇性) 是要加總其機率的數值區間結束值。若缺少此參數,會以 <emph>Start</emph> 計算機率。"
+msgid "<emph>End</emph> (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the <emph>Start</emph> value is calculated."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -46189,8 +46453,8 @@ msgctxt ""
"04060185.xhp\n"
"par_id0305200911372899\n"
"help.text"
-msgid "See also the <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\">Wiki page</link>."
-msgstr "也請參見 <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function\">Wiki 頁面</link>。"
+msgid "See also the <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/WEIBULL function\">Wiki page</link>."
+msgstr ""
#: 04060185.xhp
msgctxt ""
@@ -46309,8 +46573,8 @@ msgctxt ""
"04060185.xhp\n"
"par_id2905200911372899\n"
"help.text"
-msgid "See also the <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\">Wiki page</link>."
-msgstr "也請參見 <link href=\"http://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_ZTEST_function\">Wiki 頁面</link>。"
+msgid "See also the <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_WEIBULL_function\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/WEIBULL function\">Wiki page</link>."
+msgstr ""
#: 04060199.xhp
msgctxt ""
@@ -47669,8 +47933,8 @@ msgctxt ""
"04090000.xhp\n"
"par_id3149262\n"
"help.text"
-msgid "<ahelp hid=\".uno:InsertExternalDataSourc\">Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp>"
-msgstr "<ahelp hid=\".uno:InsertExternalDataSourc\">將 HTML、Calc 或 Excel 檔案中的資料以連結插入目前試算表中。這些資料必須位於已命名的區域內。</ahelp>"
+msgid "<ahelp hid=\".uno:InsertExternalDataSourc\">Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp>"
+msgstr ""
#: 04090000.xhp
msgctxt ""
@@ -47685,8 +47949,16 @@ msgctxt ""
"04090000.xhp\n"
"par_id3145366\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/externaldata/url\">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/externaldata/url\">輸入包含想要插入之資料的 URL 或檔案名稱,然後按 Enter 鍵。</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/externaldata/url\">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Only then the URL will be requested from the network or file system."
+msgstr ""
+
+#: 04090000.xhp
+msgctxt ""
+"04090000.xhp\n"
+"par_id621519313666202\n"
+"help.text"
+msgid "<link href=\"text/shared/00/00000208.xhp\" name=\"linkname\">A dialog for CSV data import</link> appears when linking to external CSV file."
+msgstr ""
#: 04090000.xhp
msgctxt ""
@@ -48469,7 +48741,7 @@ msgctxt ""
"05060000.xhp\n"
"par_id1001240\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/mergecellsdialog/MergeCellsDialog\">Three options are available:</ahelp>"
+msgid "Three options are available:"
msgstr ""
#: 05060000.xhp
@@ -48477,7 +48749,7 @@ msgctxt ""
"05060000.xhp\n"
"par_id3155879\n"
"help.text"
-msgid "<emph>Move the contents of the hidden cells into the first cell</emph>: the actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated."
+msgid "<emph>Move the contents of the hidden cells into the first cell</emph>: <ahelp hid=\".\">The actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated.</ahelp>"
msgstr ""
#: 05060000.xhp
@@ -48485,7 +48757,7 @@ msgctxt ""
"05060000.xhp\n"
"par_id3155878\n"
"help.text"
-msgid "<emph>Keep the contents of the hidden cells</emph>: the contents of the hidden cells are kept; the results of formulas referring to the hidden cells will not change."
+msgid "<emph>Keep the contents of the hidden cells</emph>: <ahelp hid=\".\">The contents of the hidden cells are kept; the results of formulas referring to the hidden cells will not change.</ahelp>"
msgstr ""
#: 05060000.xhp
@@ -48493,7 +48765,7 @@ msgctxt ""
"05060000.xhp\n"
"par_id3155877\n"
"help.text"
-msgid "<emph>Empty the contents of the hidden cells</emph>: the contents of the hidden cells are removed; the results of formulas referring to the hidden cells will be updated."
+msgid "<emph>Empty the contents of the hidden cells</emph>: <ahelp hid=\".\">The contents of the hidden cells are removed; the results of formulas referring to the hidden cells will be updated.</ahelp>"
msgstr ""
#: 05060000.xhp
@@ -49581,16 +49853,40 @@ msgctxt ""
"05110000.xhp\n"
"par_id3154017\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/add\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <link href=\"text/shared/01/05150101.xhp\" name=\"Add AutoFormat\">Add AutoFormat</link> dialog then appears."
-msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/add\">讓您能將至少 4 x 4 儲存格範圍的目前格式增加至預先定義的「自動格式」清單。</ahelp> 然後會顯示 <link href=\"text/shared/01/05150101.xhp\" name=\"新增自動格式\">[新增自動格式]</link> 對話方塊。"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/add\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <emph>Add AutoFormat</emph> dialog then appears."
+msgstr ""
#: 05110000.xhp
msgctxt ""
"05110000.xhp\n"
"par_id3153708\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_AUTOFMT_NAME\">Enter a name and click <emph>OK</emph>. </ahelp>"
-msgstr "<ahelp hid=\"HID_SC_AUTOFMT_NAME\">輸入名稱並按一下 <emph>[確定]</emph>。 </ahelp>"
+msgid "<ahelp hid=\".\">Enter a name and click <emph>OK</emph>. </ahelp>"
+msgstr ""
+
+#: 05110000.xhp
+msgctxt ""
+"05110000.xhp\n"
+"hd_id3159223\n"
+"help.text"
+msgid "Rename"
+msgstr "重新命名"
+
+#: 05110000.xhp
+msgctxt ""
+"05110000.xhp\n"
+"par_id3153064\n"
+"help.text"
+msgid "<ahelp hid=\".\">Opens a dialog where you can change the name of the selected AutoFormat.</ahelp>"
+msgstr ""
+
+#: 05110000.xhp
+msgctxt ""
+"05110000.xhp\n"
+"par_id3153912\n"
+"help.text"
+msgid "The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid=\".\"> Enter the new name of the AutoFormat here.</ahelp>"
+msgstr ""
#: 05110000.xhp
msgctxt ""
@@ -49704,46 +50000,6 @@ msgctxt ""
msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/autofitcb\">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp>"
msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/autofitcb\">標記時,指定您要保留所選格式之所選儲存格的寬度和高度。</ahelp>"
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"hd_id3159223\n"
-"help.text"
-msgid "Rename"
-msgstr "重新命名"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"par_id3153064\n"
-"help.text"
-msgid "<ahelp hid=\"HID_SC_RENAME_AUTOFMT\">Opens a dialog where you can change the specification of the selected AutoFormat.</ahelp> The button is only visible if you clicked the <emph>More</emph> button."
-msgstr "<ahelp hid=\"HID_SC_RENAME_AUTOFMT\">開啟對話方塊,在此您可以變更所選「自動格式」的規格。</ahelp> 如果您按了 <emph>[其他]</emph> 按鈕才看得見此按鈕。"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"par_id3153912\n"
-"help.text"
-msgid "The <emph>Rename AutoFormat</emph> dialog opens.<ahelp hid=\"HID_SC_REN_AFMT_NAME\"> Enter the new name of the AutoFormat here.</ahelp>"
-msgstr "會開啟 <emph>[重新命名自動格式]</emph> 對話方塊。<ahelp hid=\"HID_SC_REN_AFMT_NAME\">在此處輸入「自動格式」的新名稱。</ahelp>"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"hd_id3155264\n"
-"help.text"
-msgid "More"
-msgstr "其他"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"par_id3159094\n"
-"help.text"
-msgid "Closes the <emph>Formatting</emph> options section, if it is currently open."
-msgstr "如果<emph>[格式化]</emph>選項區域目前處於開啟狀態,請將其關閉。"
-
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
@@ -49765,7 +50021,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id3163710\n"
"help.text"
-msgid "<variable id=\"bedingtetext\"><ahelp hid=\".uno:ConditionalFormatDialog\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used."
+msgid "<variable id=\"bedingtetext\"><ahelp hid=\".\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used."
msgstr ""
#: 05120000.xhp
@@ -49795,6 +50051,30 @@ msgstr "<bookmark_value>條件式格式; 條件</bookmark_value>"
#: 05120000.xhp
msgctxt ""
"05120000.xhp\n"
+"par_id3149413\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">List of the conditions defined for the cell range in order of evaluation.</ahelp>"
+msgstr ""
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"par_id3149414\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Increase priority of the selected condition.</ahelp>"
+msgstr ""
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"par_id3149415\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Decrease priority of the selected condition.</ahelp>"
+msgstr ""
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
"hd_id31531891\n"
"help.text"
msgid "Condition"
@@ -49853,7 +50133,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id31494137\n"
"help.text"
-msgid "Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition."
+msgid "<ahelp hid=\".\">Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition.</ahelp>"
msgstr ""
#: 05120000.xhp
@@ -49861,7 +50141,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id31494138\n"
"help.text"
-msgid "In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected."
+msgid "<ahelp hid=\".\">In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting.</ahelp> Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected."
msgstr ""
#: 05120000.xhp
@@ -49917,7 +50197,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id3155605\n"
"help.text"
-msgid "For a detailed explanation and examples, please visit <link href=\"http://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page in TDF Wiki</link>."
+msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki."
msgstr ""
#: 05120000.xhp
@@ -50013,7 +50293,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id3155606\n"
"help.text"
-msgid "For a detailed explanation and examples, please visit <link href=\"http://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formating page in TDF Wiki</link>."
+msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formatting page</link> in TDF Wiki."
msgstr ""
#: 05120000.xhp
@@ -50069,7 +50349,7 @@ msgctxt ""
"05120000.xhp\n"
"par_id3155906\n"
"help.text"
-msgid "This dialog allows you to see all the conditional formatting defined in the spreadsheet."
+msgid "<ahelp hid=\".\">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</ahelp>"
msgstr ""
#: 05120000.xhp
@@ -50085,7 +50365,15 @@ msgctxt ""
"05120000.xhp\n"
"par_id3155907\n"
"help.text"
-msgid "The <emph>Manage Conditional Formatting</emph> dialog box opens. Here you can add, edit or remove one or several conditional formattings."
+msgid "The <emph>Manage Conditional Formatting</emph> dialog box opens. <ahelp hid=\".\">Here you can add, edit or remove one or several conditional formattings.</ahelp>"
+msgstr ""
+
+#: 05120000.xhp
+msgctxt ""
+"05120000.xhp\n"
+"par_id3155909\n"
+"help.text"
+msgid "<ahelp hid=\".\">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet.</ahelp> Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range."
msgstr ""
#: 05120000.xhp
@@ -52653,8 +52941,8 @@ msgctxt ""
"12050200.xhp\n"
"par_id3154124\n"
"help.text"
-msgid "<ahelp hid=\"HID_SCPAGE_SUBT_OPTIONS\">Specify the settings for calculating and presenting subtotals.</ahelp>"
-msgstr "<ahelp hid=\"HID_SCPAGE_SUBT_OPTIONS\">指定計算的設定並顯示小計。</ahelp>"
+msgid "<ahelp hid=\".\">Specify the settings for calculating and presenting subtotals.</ahelp>"
+msgstr ""
#: 12050200.xhp
msgctxt ""
@@ -52741,8 +53029,8 @@ msgctxt ""
"12050200.xhp\n"
"par_id3149400\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/lbuserdef\">Uses a custom sorting order that you defined in the Options dialog box at <emph>%PRODUCTNAME Calc - Sort Lists</emph>.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/lbuserdef\">使用您在 [選項] 對話方塊之 <emph>[%PRODUCTNAME Calc] - [排序清單]</emph> 中定義的自訂排序順序。</ahelp>"
+msgid "<ahelp hid=\".\">Uses a custom sorting order that you defined in the Options dialog box at <emph>%PRODUCTNAME Calc - Sort Lists</emph>.</ahelp>"
+msgstr ""
#: 12050200.xhp
msgctxt ""
@@ -56277,7 +56565,7 @@ msgctxt ""
"data_form.xhp\n"
"hd_id240920171003006302\n"
"help.text"
-msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Entry Forms for Spreasheets</link>"
+msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Entry Forms for Spreadsheets</link>"
msgstr ""
#: data_form.xhp
@@ -56347,6 +56635,14 @@ msgstr ""
#: data_form.xhp
msgctxt ""
"data_form.xhp\n"
+"par_id361512503457039\n"
+"help.text"
+msgid "Enter the data in the text fields. Press Enter or click <item type=\"literal\">New</item> to add it to the table."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
"hd_id111512507319306\n"
"help.text"
msgid "Form dialog buttons"
@@ -56629,7 +56925,7 @@ msgctxt ""
"exponsmooth_embd.xhp\n"
"par_id0403201618694537\n"
"help.text"
-msgid "See the <link href=\"http://en.wikipedia.org/wiki/Exponential_smoothing\">Wikipedia on Exponential smoothing algorithms</link> for more information."
+msgid "See the <link href=\"https://en.wikipedia.org/wiki/Exponential_smoothing\" name=\"English Wikipedia: Exponential smoothing\">Wikipedia on Exponential smoothing algorithms</link> for more information."
msgstr ""
#: exponsmooth_embd.xhp
@@ -58189,7 +58485,7 @@ msgctxt ""
"func_color.xhp\n"
"par_id1102201617001888\n"
"help.text"
-msgid "<item type=\"literal\">COLOR(255;255;255;1)</item> returns 33554431"
+msgid "<item type=\"input\">COLOR(255;255;255;1)</item> returns 33554431"
msgstr ""
#: func_color.xhp
@@ -58197,7 +58493,7 @@ msgctxt ""
"func_color.xhp\n"
"par_id1102201618185378\n"
"help.text"
-msgid "<item type=\"literal\">COLOR(0;0;255;0)</item> returns 255"
+msgid "<item type=\"input\">COLOR(0;0;255;0)</item> returns 255"
msgstr ""
#: func_color.xhp
@@ -58205,7 +58501,7 @@ msgctxt ""
"func_color.xhp\n"
"par_id1102201618185326\n"
"help.text"
-msgid "<item type=\"literal\">COLOR(0;0;255;255)</item> returns 4278190335"
+msgid "<item type=\"input\">COLOR(0;0;255;255)</item> returns 4278190335"
msgstr ""
#: func_color.xhp
@@ -58213,7 +58509,7 @@ msgctxt ""
"func_color.xhp\n"
"par_id1102201618188326\n"
"help.text"
-msgid "<item type=\"literal\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255."
+msgid "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255."
msgstr ""
#: func_countifs.xhp
@@ -61960,6 +62256,110 @@ msgctxt ""
msgid "<item type=\"literal\">RAWSUBTRACT(0.987654321098765)</item> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers."
msgstr ""
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"tit\n"
+"help.text"
+msgid "ROUNDSIG Function"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"bm_id151519154954070\n"
+"help.text"
+msgid "<bookmark_value>ROUNDSIG Function</bookmark_value>"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"hd_id351519154702177\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/func_roundsig.xhp\" name=\"command name\">ROUNDSIG</link>"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id921519154702177\n"
+"help.text"
+msgid "<variable id=\"roundsig\"><ahelp hid=\"HID_FUNC_ROUNDSIG\">Returns a number rounded to a specified number of significant decimal digits of its normalized floating point notation.</ahelp></variable>"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id291519155534115\n"
+"help.text"
+msgid "ROUNDSIG( Value; Digits )"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id51519155217204\n"
+"help.text"
+msgid "<emph>Value</emph>: the number to be rounded."
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id321519155209912\n"
+"help.text"
+msgid "<emph>Digits</emph>: the number of decimal places to round."
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id371519155264297\n"
+"help.text"
+msgid "<emph>Digits</emph> must be an integer greater than 0."
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id691519155470333\n"
+"help.text"
+msgid "<item type=\"input\">=ROUNDSIG(123.456789; 5)</item> returns 123.46."
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id821519155475673\n"
+"help.text"
+msgid "<item type=\"input\">=ROUNDSIG(0.000123456789; 5)</item> returns 0.00012346"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id381519155481234\n"
+"help.text"
+msgid "<item type=\"input\">=ROUNDSIG(123456789012345; 2)</item> returns 1.2E14"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id231519155486155\n"
+"help.text"
+msgid "<item type=\"input\">=ROUNDSIG(123456789; 4)</item> returns 123500000 or 123.5E6"
+msgstr ""
+
+#: func_roundsig.xhp
+msgctxt ""
+"func_roundsig.xhp\n"
+"par_id51519156941987\n"
+"help.text"
+msgid "See also <link href=\"text/scalc/01/04060106.xhp#Section21\" name=\"ROUND function\">ROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section7\" name=\"MROUND function\">MROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section19\" name=\"ROUNDUP function\">ROUNDUP</link>, <link href=\"text/scalc/01/04060106.xhp#Section20\" name=\"ROUNDDOWN function\">ROUNDDOWN</link>."
+msgstr ""
+
#: func_second.xhp
msgctxt ""
"func_second.xhp\n"
@@ -62077,8 +62477,8 @@ msgctxt ""
"func_skewp.xhp\n"
"par_id27421466710275\n"
"help.text"
-msgid "SKEWP(Number1; Number2;..., Number30)"
-msgstr "SKEW(Number1; Number2; ...Number30)"
+msgid "SKEWP(Number1; Number2; ...; Number30)"
+msgstr ""
#: func_skewp.xhp
msgctxt ""
@@ -62117,7 +62517,7 @@ msgctxt ""
"func_skewp.xhp\n"
"par_id1102201618185326\n"
"help.text"
-msgid "<item type=\"literal\">SKEWP(Number1;Number2)</item> returns zero always, if Number1 and Number2 results in two numbers."
+msgid "<item type=\"literal\">SKEWP(Number1; Number2)</item> always returns zero, if Number1 and Number2 results in two numbers."
msgstr ""
#: func_skewp.xhp
@@ -62645,7 +63045,7 @@ msgctxt ""
"func_webservice.xhp\n"
"tit\n"
"help.text"
-msgid "WEBSERVICE"
+msgid "URI Functions"
msgstr ""
#: func_webservice.xhp
@@ -62709,7 +63109,7 @@ msgctxt ""
"func_webservice.xhp\n"
"par_id3146142\n"
"help.text"
-msgid "=WEBSERVICE(\"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\")"
+msgid "<item type=\"input\">=WEBSERVICE(\"wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss\")</item>"
msgstr ""
#: func_webservice.xhp
@@ -62717,7 +63117,7 @@ msgctxt ""
"func_webservice.xhp\n"
"par_id3146143\n"
"help.text"
-msgid "Returns the web page content of \"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\""
+msgid "Returns the web page content of \"https://wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss\"."
msgstr ""
#: func_webservice.xhp
@@ -62789,7 +63189,7 @@ msgctxt ""
"func_webservice.xhp\n"
"par_id2946142\n"
"help.text"
-msgid "=FILTERXML(WEBSERVICE(\"http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dk&mode=xml&units=metric\");\"number(/weatherdata/forecast/time[2]/temperature/@value)\")"
+msgid "<item type=\"input\">=FILTERXML(WEBSERVICE(\"wiki.documentfoundation.org/api.php?hidebots=1&days=7&limit=50&action=feedrecentchanges&feedformat=rss\");\"//lastBuildDate\")</item>"
msgstr ""
#: func_webservice.xhp
@@ -62797,7 +63197,87 @@ msgctxt ""
"func_webservice.xhp\n"
"par_id2946143\n"
"help.text"
-msgid "Returns information on Copenhagen weather temperature."
+msgid "Returns information on the last build date of the wiki."
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"bm_id811517136840444\n"
+"help.text"
+msgid "<bookmark_value>ENCODEURL function</bookmark_value>"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"hd_id671517132649769\n"
+"help.text"
+msgid "ENCODEURL function"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id51517132649769\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_ENCODEURL\">Returns a URL-encoded string.</ahelp>"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id721517134647880\n"
+"help.text"
+msgid "Use this function to transform text with symbols of national alphabets (for example accented characters, non-ASCII alphabets or Asian words) to a string of URL-standard symbols."
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"hd_id351517132879400\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id351517132879400\n"
+"help.text"
+msgid "ENCODEURL(Text)"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id921517132924079\n"
+"help.text"
+msgid "<emph>Text</emph>: String to encode to a sequence of URL-standard symbols."
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"hd_id901517132933934\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id651517132994921\n"
+"help.text"
+msgid "If cell A1 contains the Cyrillic text \"автомобиль\", <item type=\"input\">=ENCODEURL(A1)</item> returns %D0%B0%D0%B2%D1%82%D0%BE%D0%BC%D0%BE%D0%B1%D0%B8%D0%BB%D1%8C (the word \"автомобиль\" means car in Russian)."
+msgstr ""
+
+#: func_webservice.xhp
+msgctxt ""
+"func_webservice.xhp\n"
+"par_id991517133057478\n"
+"help.text"
+msgid "If cell B1 contains the text \"車\", <item type=\"input\">=ENCODEURL(B1)</item> returns %E8%BB%8A (\"車\" means car in Japanese)."
msgstr ""
#: func_weekday.xhp
@@ -64709,7 +65189,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1000670\n"
"help.text"
-msgid "For more information on descriptive statistics, refer to the <link href=\"http://en.wikipedia.org/wiki/Descriptive_statistics\">corresponding Wikipedia article</link>."
+msgid "For more information on descriptive statistics, refer to the <link href=\"https://en.wikipedia.org/wiki/Descriptive_statistics\" name=\"English Wikipedia: Descriptive statistics\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -64893,7 +65373,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1001270\n"
"help.text"
-msgid "For more information on ANOVA, refer to the <link href=\"http://en.wikipedia.org/wiki/ANOVA\">corresponding Wikipedia article</link>."
+msgid "For more information on ANOVA, refer to the <link href=\"https://en.wikipedia.org/wiki/ANOVA\" name=\"English Wikipedia: ANOVA\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65157,7 +65637,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1001790\n"
"help.text"
-msgid "For more information on statistical correlation, refer to the <link href=\"http://en.wikipedia.org/wiki/Correlation\">corresponding Wikipedia article</link>."
+msgid "For more information on statistical correlation, refer to the <link href=\"https://en.wikipedia.org/wiki/Correlation\" name=\"English Wikipedia: Correlation\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65269,7 +65749,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1001970\n"
"help.text"
-msgid "For more information on statistical covariance, refer to the <link href=\"http://en.wikipedia.org/wiki/Covariance\">corresponding Wikipedia article</link>."
+msgid "For more information on statistical covariance, refer to the <link href=\"https://en.wikipedia.org/wiki/Covariance\" name=\"English Wikipedia: Covariance\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65381,7 +65861,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1002150\n"
"help.text"
-msgid "For more information on exponential smoothing, refer to the <link href=\"http://en.wikipedia.org/wiki/Exponential_smoothing\">corresponding Wikipedia article</link>."
+msgid "For more information on exponential smoothing, refer to the <link href=\"https://en.wikipedia.org/wiki/Exponential_smoothing\" name=\"English Wikipedia: Exponential smoothing\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65469,7 +65949,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1002520\n"
"help.text"
-msgid "For more information on the moving average, refer to the <link href=\"http://en.wikipedia.org/wiki/Moving_average\">corresponding Wikipedia article</link>."
+msgid "For more information on the moving average, refer to the <link href=\"https://en.wikipedia.org/wiki/Moving_average\" name=\"English Wikipedia: Moving average\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65589,7 +66069,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1002850\n"
"help.text"
-msgid "For more information on paired t-tests, refer to the <link href=\"http://en.wikipedia.org/wiki/T-test\">corresponding Wikipedia article</link>."
+msgid "For more information on paired t-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/T-test\" name=\"English Wikipedia: T-test\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -65821,7 +66301,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1003270\n"
"help.text"
-msgid "For more information on F-tests, refer to the <link href=\"http://en.wikipedia.org/wiki/F-test\">corresponding Wikipedia article</link>."
+msgid "For more information on F-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/F-test\" name=\"English Wikipedia: F-test\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -66029,7 +66509,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1003660\n"
"help.text"
-msgid "For more information on Z-tests, refer to the <link href=\"http://en.wikipedia.org/wiki/Z-test\">corresponding Wikipedia article</link>."
+msgid "For more information on Z-tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Z-test\" name=\"English Wikipedia: Z-test\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -66253,7 +66733,7 @@ msgctxt ""
"statistics.xhp\n"
"par_id1004000\n"
"help.text"
-msgid "For more information on chi-square tests, refer to the <link href=\"http://en.wikipedia.org/wiki/Chi-square_test\">corresponding Wikipedia article</link>."
+msgid "For more information on chi-square tests, refer to the <link href=\"https://en.wikipedia.org/wiki/Chi-square_test\" name=\"English Wikipedia: Chi-square_test\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics.xhp
@@ -66389,7 +66869,7 @@ msgctxt ""
"statistics_regression.xhp\n"
"par_id1001270\n"
"help.text"
-msgid "For more information on regression analysis, refer to the <link href=\"http://en.wikipedia.org/wiki/Regression_analysis\">corresponding Wikipedia article</link>."
+msgid "For more information on regression analysis, refer to the <link href=\"https://en.wikipedia.org/wiki/Regression_analysis\" name=\"English Wikipedia: Regression analysis\">corresponding Wikipedia article</link>."
msgstr ""
#: statistics_regression.xhp
@@ -66637,7 +67117,7 @@ msgctxt ""
"xml_source.xhp\n"
"tit\n"
"help.text"
-msgid "Live Data Stream"
+msgid "XML Data"
msgstr ""
#: xml_source.xhp
@@ -66661,7 +67141,15 @@ msgctxt ""
"xml_source.xhp\n"
"par_id240920171003293400\n"
"help.text"
-msgid "<ahelp hid=\".\">Live data stream for spreadsheets</ahelp>"
+msgid "<ahelp hid=\".\">Import XML data in a spreadsheet.</ahelp>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id861521496523519\n"
+"help.text"
+msgid "The XML Source feature allows to import data from arbitrarily structured XML content into cells in an existing spreadsheet document. It allows XML content to be imported either partially or in full, depending on the structure of the XML content and the map definitions that the user defines. The user can specify multiple non-overlapping sub-structures to be mapped to different cell positions within the same document. The user can import either element contents, attribute values or both."
msgstr ""
#: xml_source.xhp
@@ -66675,7 +67163,143 @@ msgstr ""
#: xml_source.xhp
msgctxt ""
"xml_source.xhp\n"
+"hd_id801521494731764\n"
+"help.text"
+msgid "XML Source Dialog"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id2521\n"
+"help.text"
+msgid "<image id=\"img_id35279\" src=\"media/screenshots/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog.png\" width=\"16cm\" height=\"13cm\"><alt id=\"alt_id55711\">XML Source Dialog</alt></image>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id291521494762812\n"
+"help.text"
+msgid "The dialog consists of four parts."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"hd_id601521494755603\n"
+"help.text"
+msgid "Source file"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id161521494769832\n"
+"help.text"
+msgid "This lets you specify the path to the XML file that you wish to import into your document."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"hd_id491521494788029\n"
+"help.text"
+msgid "Map to Document"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id211521494776007\n"
+"help.text"
+msgid "This pane shows the structure of the source XML content as a tree. This is initially empty, and gets populated when you specify the source file."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id161521494796604\n"
+"help.text"
+msgid "Each element in the tree can be one of three types:"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id931521494810426\n"
+"help.text"
+msgid "attribute, represented by the symbol <emph>@</emph>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id521521494825665\n"
+"help.text"
+msgid "single non-recurring element, represented by the symbol <emph></></emph>, and"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id691521494844848\n"
+"help.text"
+msgid "recurring element, represented by the symbol <emph><//></emph>."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id451521494864514\n"
+"help.text"
+msgid "A non-recurring element is an element that can only occur once under the same parent. It is mapped to a single cell in the document."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id361521494872103\n"
+"help.text"
+msgid "A recurring element is an element that can appear multiple times under the same parent. It serves as an enclosing parent of a single record entry of multiple record entries. These entries are imported into a range those height equals the number of entries plus one additional header row."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"hd_id581521494885433\n"
+"help.text"
+msgid "Mapped cell"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id661521494897796\n"
+"help.text"
+msgid "This field specifies the position of a cell in the document that an element or an attribute is linked to. If it is a non-recurring element or an attribute, it simply points to the cell where the value of the linked element/attribute will get imported. If it is a recurring element, it points to the top-left cell of the range where the whole record entries plus header will get imported."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"hd_id151521553082338\n"
+"help.text"
+msgid "Import"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id131521553077261\n"
+"help.text"
+msgid "Pressing the Import button starts the import process based on the link definitions that the user has provided. Once the import finishes, the dialog will close."
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
"par_id240920171007419799\n"
"help.text"
-msgid "XML Source"
+msgid "<link href=\"https://wiki.documentfoundation.org/Development/Calc/XMLSource\" target=\"_blank\" name=\"Wiki page on XML Source\">Wiki page on XML Source</link>"
msgstr ""