summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po478
1 files changed, 339 insertions, 139 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index 7cfbe44666b..10b69b8e3ef 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-05-30 09:54+0200\n"
+"POT-Creation-Date: 2017-10-04 11:48+0200\n"
"PO-Revision-Date: 2016-12-09 05:13+0000\n"
"Last-Translator: wck317 <wck317@pchome.com.tw>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12213,8 +12213,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3153257\n"
"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_GCD\"> The result is the greatest common divisor of a list of numbers.</ahelp>"
-msgstr "<ahelp hid=\"HID_AAI_FUNC_GCD\"> 結果為數字清單的最大公約數。</ahelp>"
+msgid "<ahelp hid=\"HID_AAI_FUNC_GCD\">The result is the greatest common divisor of a list of numbers.</ahelp>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -12341,8 +12341,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3149036\n"
"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_LCM\"> The result is the lowest common multiple of a list of numbers.</ahelp>"
-msgstr "<ahelp hid=\"HID_AAI_FUNC_LCM\"> 結果為數字清單的最小公倍數。</ahelp>"
+msgid "<ahelp hid=\"HID_AAI_FUNC_LCM\">The result is the lowest common multiple of a list of numbers.</ahelp>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -12621,8 +12621,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 "<emph>可視</emph>的結果小數點位置,指定於 <switchinline select=\"sys\"><caseinline select=\"MAC\">[%PRODUCTNAME] - [喜好設定]</caseinline><defaultinline>[工具] - [選項]</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\">[%PRODUCTNAME Calc] - [計算]</link> 之中。"
+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 ""
#: 04060106.xhp
msgctxt ""
@@ -12933,7 +12933,7 @@ msgctxt ""
"04060106.xhp\n"
"par_id3163792\n"
"help.text"
-msgid "If the spreadsheet is exported to MS Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
msgstr ""
#: 04060106.xhp
@@ -13189,8 +13189,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id3152454\n"
"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\"> Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp>"
-msgstr "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\"> 傳回引數階乘的乘積所除引數小計的階乘。</ahelp>"
+msgid "<ahelp hid=\"HID_AAI_FUNC_MULTINOMIAL\">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -14453,8 +14453,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 "為將此輸入為陣列公式,您必須按 Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command </caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter 組合鍵,而非只按 Enter 鍵關閉公式。然後在 <emph>[公式]</emph> 列中將會顯示此公式,且前後括有大括號。"
+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 ""
#: 04060106.xhp
msgctxt ""
@@ -14779,50 +14779,50 @@ msgstr "<emph>函式索引</emph>"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165806\n"
+"par_id20082017081856189\n"
"help.text"
-msgid "Function"
-msgstr "函式"
+msgid "(includes hidden values)"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165833\n"
+"par_id200820170716337755\n"
"help.text"
-msgid "1"
+msgid "Function index"
msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165856\n"
+"par_id200820170818568679\n"
"help.text"
-msgid "AVERAGE"
-msgstr "AVERAGE"
+msgid "(ignores hidden values)"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165883\n"
+"par_id3165806\n"
"help.text"
-msgid "2"
-msgstr ""
+msgid "Function"
+msgstr "函式"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165906\n"
+"par_id3165856\n"
"help.text"
-msgid "COUNT"
-msgstr "COUNT"
+msgid "AVERAGE"
+msgstr "AVERAGE"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165933\n"
+"par_id3165906\n"
"help.text"
-msgid "3"
-msgstr ""
+msgid "COUNT"
+msgstr "COUNT"
#: 04060106.xhp
msgctxt ""
@@ -14835,162 +14835,170 @@ msgstr "COUNTA"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3165983\n"
+"par_id3166006\n"
"help.text"
-msgid "4"
-msgstr ""
+msgid "MAX"
+msgstr "MAX"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3166006\n"
+"par_id3166056\n"
"help.text"
-msgid "MAX"
-msgstr "MAX"
+msgid "MIN"
+msgstr "MIN"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3166033\n"
+"par_id3143339\n"
"help.text"
-msgid "5"
-msgstr ""
+msgid "PRODUCT"
+msgstr "PRODUCT"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3166056\n"
+"par_id3143389\n"
"help.text"
-msgid "MIN"
-msgstr "MIN"
+msgid "STDEV"
+msgstr "STDEV"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143316\n"
+"par_id3143439\n"
"help.text"
-msgid "6"
-msgstr ""
+msgid "STDEVP"
+msgstr "STDEVP"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143339\n"
+"par_id3143489\n"
"help.text"
-msgid "PRODUCT"
-msgstr "PRODUCT"
+msgid "SUM"
+msgstr "SUM"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143366\n"
+"par_id3143539\n"
"help.text"
-msgid "7"
-msgstr ""
+msgid "VAR"
+msgstr "VAR"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143389\n"
+"par_id3143589\n"
"help.text"
-msgid "STDEV"
-msgstr "STDEV"
+msgid "VARP"
+msgstr "VARP"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143416\n"
+"par_id20082017075115609\n"
"help.text"
-msgid "8"
+msgid "Use numbers 1-11 to include manually hidden rows or 101-111 to exclude them; filtered-out cells are always excluded."
msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143439\n"
+"par_id3143606\n"
"help.text"
-msgid "STDEVP"
-msgstr "STDEVP"
+msgid "<emph>Range</emph> is the range whose cells are included."
+msgstr "<emph>Range</emph> 是要加入其儲存格的區域。"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143466\n"
+"hd_id3143625\n"
"help.text"
-msgid "9"
-msgstr ""
+msgid "Example"
+msgstr "範例"
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143489\n"
+"par_id3143638\n"
"help.text"
-msgid "SUM"
-msgstr "SUM"
+msgid "You have a table in the cell range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143516\n"
+"par_id200820170751186696\n"
"help.text"
-msgid "10"
-msgstr "10"
+msgid "<emph>ITEM</emph>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143539\n"
+"par_id20082017075118422\n"
"help.text"
-msgid "VAR"
-msgstr "VAR"
+msgid "<emph>QUANTITY</emph>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143566\n"
+"par_id200820170751195726\n"
"help.text"
-msgid "11"
-msgstr "11"
+msgid "Pen"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143589\n"
+"par_id200820170751195912\n"
"help.text"
-msgid "VARP"
-msgstr "VARP"
+msgid "Pencil"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143606\n"
+"par_id200820170751199399\n"
"help.text"
-msgid "<emph>Range</emph> is the range whose cells are included."
-msgstr "<emph>Range</emph> 是要加入其儲存格的區域。"
+msgid "Notebook"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"hd_id3143625\n"
+"par_id200820170751201323\n"
"help.text"
-msgid "Example"
-msgstr "範例"
+msgid "Rubber"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
-"par_id3143638\n"
+"par_id200820170751204884\n"
"help.text"
-msgid "You have a table in the cell range A1:B5 containing cities in column A and accompanying figures in column B. You have used an AutoFilter so that you only see rows containing the city Hamburg. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:"
-msgstr "表格的儲存格範圍 A1:B5 中,欄 A 包含城市,欄 B 包含對應的數字。經過自動篩選後,您僅能看到包含城市 Hamburg 的列。您要檢視所顯示數值的總和,也就是說,只檢視篩選出的列之小計。在此種情況下,正確的公式是:"
+msgid "Sharpener"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3143658\n"
"help.text"
-msgid "<item type=\"input\">=SUBTOTAL(9;B2:B5)</item>"
-msgstr "<item type=\"input\">=SUBTOTAL(9;B2:B5)</item>"
+msgid "<item type=\"input\">=SUBTOTAL(9;B2:B6) returns 50.</item>"
+msgstr ""
+
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id200820170751218092\n"
+"help.text"
+msgid "<item type=\"input\">=SUBTOTAL(109;B2:B6) returns 40.</item>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -15093,16 +15101,16 @@ msgctxt ""
"04060106.xhp\n"
"bm_id0908200902090676\n"
"help.text"
-msgid "<bookmark_value>CONVERT function</bookmark_value>"
-msgstr "<bookmark_value>CONVERT 函式</bookmark_value>"
+msgid "<bookmark_value>CONVERT_OOO function</bookmark_value>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"hd_id0908200902074836\n"
"help.text"
-msgid "CONVERT"
-msgstr "CONVERT"
+msgid "CONVERT_OOO"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -15133,8 +15141,8 @@ msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT(value;\"text\";\"text\")"
-msgstr "CONVERT(value;\"text\";\"text\")"
+msgid "CONVERT_OOO(value;\"text\";\"text\")"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -15149,16 +15157,16 @@ msgctxt ""
"04060106.xhp\n"
"par_id090820090213112\n"
"help.text"
-msgid "<item type=\"input\">=CONVERT(100;\"ATS\";\"EUR\")</item> returns the Euro value of 100 Austrian Schillings."
-msgstr "<item type=\"input\">=CONVERT(100;\"ATS\";\"EUR\")</item> 傳回 100 奧地利先令的歐元值。"
+msgid "<item type=\"input\">=CONVERT_OOO(100;\"ATS\";\"EUR\")</item> returns the Euro value of 100 Austrian Schillings."
+msgstr ""
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902475431\n"
"help.text"
-msgid "=CONVERT(100;\"EUR\";\"DEM\") converts 100 Euros into German Marks."
-msgstr "=CONVERT(100;\"EUR\";\"DEM\") 可將 100 歐元轉換為德國馬克。"
+msgid "=CONVERT_OOO(100;\"EUR\";\"DEM\") converts 100 Euros into German Marks."
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -15389,7 +15397,7 @@ msgctxt ""
"04060106.xhp\n"
"par_id3163894\n"
"help.text"
-msgid "If the spreadsheet is exported to MS Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
msgstr ""
#: 04060106.xhp
@@ -15781,8 +15789,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 "此函式會在每次 Calc 重新計算時產生新的隨機數。若要手動強制 Calc 重新計算,請按 Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9。"
+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 ""
#: 04060106.xhp
msgctxt ""
@@ -16211,6 +16219,14 @@ msgstr "欄分隔符(一列中的分隔元素)與列分隔符有賴語言與
#: 04060107.xhp
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>."
+msgstr ""
+
+#: 04060107.xhp
+msgctxt ""
+"04060107.xhp\n"
"par_id1877498\n"
"help.text"
msgid "Arrays can not be nested."
@@ -29301,16 +29317,16 @@ msgctxt ""
"04060116.xhp\n"
"bm_id3148446\n"
"help.text"
-msgid "<bookmark_value>CONVERT_ADD function</bookmark_value>"
-msgstr "<bookmark_value>CONVERT_ADD 函式</bookmark_value>"
+msgid "<bookmark_value>CONVERT function</bookmark_value>"
+msgstr ""
#: 04060116.xhp
msgctxt ""
"04060116.xhp\n"
"hd_id3148446\n"
"help.text"
-msgid "CONVERT_ADD"
-msgstr "CONVERT_ADD"
+msgid "CONVERT"
+msgstr ""
#: 04060116.xhp
msgctxt ""
@@ -29973,8 +29989,8 @@ msgctxt ""
"04060116.xhp\n"
"par_id3153695\n"
"help.text"
-msgid "CONVERT_ADD(Number; \"FromUnit\"; \"ToUnit\")"
-msgstr "CONVERT_ADD(Number; \"FromUnit\"; \"ToUnit\")"
+msgid "CONVERT(Number; \"FromUnit\"; \"ToUnit\")"
+msgstr ""
#: 04060116.xhp
msgctxt ""
@@ -30013,16 +30029,16 @@ msgctxt ""
"04060116.xhp\n"
"par_id3156336\n"
"help.text"
-msgid "<item type=\"input\">=CONVERT_ADD(10;\"HP\";\"PS\") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS."
-msgstr "<item type=\"input\">=CONVERT_ADD(10;\"HP\";\"PS\") </item>傳回 (四捨五入到兩位數小數點位數) 10.14。10 HP 等於 10.14 PS。"
+msgid "<item type=\"input\">=CONVERT(10;\"HP\";\"PS\") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS."
+msgstr ""
#: 04060116.xhp
msgctxt ""
"04060116.xhp\n"
"par_id3154834\n"
"help.text"
-msgid "<item type=\"input\">=CONVERT_ADD(10;\"km\";\"mi\") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3."
-msgstr "<item type=\"input\">=CONVERT_ADD(10;\"km\";\"mi\") </item>傳回 (四捨五入到兩位小數點位數) 6.21。10 公里等於 6.21 英哩。k 是係數 10^3 所允許的前綴字元。"
+msgid "<item type=\"input\">=CONVERT(10;\"km\";\"mi\") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3."
+msgstr ""
#: 04060116.xhp
msgctxt ""
@@ -49125,31 +49141,31 @@ msgctxt ""
"05100000.xhp\n"
"tit\n"
"help.text"
-msgid "Styles and Formatting"
-msgstr "樣式和格式"
+msgid "Styles"
+msgstr ""
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"bm_id3150447\n"
"help.text"
-msgid "<bookmark_value>Stylist, see Styles and Formatting window</bookmark_value> <bookmark_value>Styles and Formatting window</bookmark_value> <bookmark_value>formats; Styles and Formatting window</bookmark_value> <bookmark_value>formatting; Styles and Formatting window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
-msgstr "<bookmark_value>樣式表, 請參閱 [樣式和格式] 視窗</bookmark_value> <bookmark_value>[樣式和格式] 視窗</bookmark_value> <bookmark_value>格式; [樣式和格式] 視窗</bookmark_value> <bookmark_value>格式; [樣式和格式] 視窗</bookmark_value> <bookmark_value>套用樣式的油漆桶</bookmark_value>"
+msgid "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
+msgstr ""
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"hd_id3150447\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles and Formatting\">Styles and Formatting</link>"
-msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"樣式和格式\">樣式和格式</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
+msgstr ""
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3147434\n"
"help.text"
-msgid "Use the Styles and Formatting deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles."
+msgid "Use the Styles deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles."
msgstr ""
#: 05100000.xhp
@@ -49157,8 +49173,8 @@ msgctxt ""
"05100000.xhp\n"
"par_id3149665\n"
"help.text"
-msgid "The Styles and Formatting <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link> can remain open while editing the document."
-msgstr "[樣式和格式] <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"可停駐視窗\">可停駐視窗</link>在編輯文件時可保持開啟。"
+msgid "The Styles <link href=\"text/shared/00/00000005.xhp#andocken\" name=\"dockable window\">dockable window</link> can remain open while editing the document."
+msgstr ""
#: 05100000.xhp
msgctxt ""
@@ -49181,8 +49197,8 @@ msgctxt ""
"05100000.xhp\n"
"par_id3145749\n"
"help.text"
-msgid "Double-click the style in the Styles and Formatting window."
-msgstr "連按兩下 [樣式和格式] 視窗中的樣式。"
+msgid "Double-click the style in the Styles window."
+msgstr ""
#: 05100000.xhp
msgctxt ""
@@ -49261,7 +49277,7 @@ msgctxt ""
"05100000.xhp\n"
"par_id3155531\n"
"help.text"
-msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.</ahelp>"
+msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles window.</ahelp>"
msgstr ""
#: 05100000.xhp
@@ -49293,8 +49309,8 @@ msgctxt ""
"05100000.xhp\n"
"par_id3145078\n"
"help.text"
-msgid "Select the desired style from the Styles and Formatting window."
-msgstr "從 [樣式和格式] 視窗選取想要的樣式。"
+msgid "Select the desired style from the Styles window."
+msgstr ""
#: 05100000.xhp
msgctxt ""
@@ -49365,7 +49381,7 @@ msgctxt ""
"05100000.xhp\n"
"par_id3154707\n"
"help.text"
-msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.</ahelp>"
+msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles window with the current formatting of the selected object.</ahelp>"
msgstr ""
#: 05100000.xhp
@@ -50565,8 +50581,8 @@ msgctxt ""
"06030900.xhp\n"
"par_id3151041\n"
"help.text"
-msgid "If <emph>Tools - Detective - Update Automatically</emph> is turned on, every time formulas are changed in the document."
-msgstr "當<emph>「工具」-「偵探」-「自動更新」</emph>在文件中公式的每個變更時開啟。"
+msgid "If <emph>Tools - Detective - AutoRefresh</emph> is turned on, every time formulas are changed in the document."
+msgstr ""
#: 06031000.xhp
msgctxt ""
@@ -56216,6 +56232,102 @@ msgctxt ""
msgid "<emph>Holidays</emph> is an optional list of dates that must be counted as non-working days. The list can be given in a cell range."
msgstr ""
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"tit\n"
+"help.text"
+msgid "Data Form for Spreadsheet"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"bm_id240920171018528200\n"
+"help.text"
+msgid "<bookmark_value>data forms;for spreadsheets</bookmark_value> <bookmark_value>data forms;insert data in spreadsheets</bookmark_value> <bookmark_value>insert data;data forms for spreadsheets</bookmark_value> <bookmark_value>spreadsheet;form to insert data</bookmark_value>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id240920171003006302\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Forms for Spreasheets</link>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id240920171003293400\n"
+"help.text"
+msgid "<ahelp hid=\".\">Data Forms for Spreasheets</ahelp>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id240920171007389295\n"
+"help.text"
+msgid "Menu <item type=\"menuitem\">Data – Form...</item>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id240920171007419799\n"
+"help.text"
+msgid "Form"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"tit\n"
+"help.text"
+msgid "Data Provider for Spreadsheet"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"bm_id240920171018528200\n"
+"help.text"
+msgid "<bookmark_value>data provider;for spreadsheets</bookmark_value>"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"hd_id240920171003006302\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/data_provider.xhp\">Data Provider for Spreadsheets</link>"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"par_id240920171003293400\n"
+"help.text"
+msgid "<ahelp hid=\".\">Data Provider for Spreadsheets</ahelp>"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"par_id240920171007389295\n"
+"help.text"
+msgid "Menu <item type=\"menuitem\">Data – Data Provider...</item>"
+msgstr ""
+
+#: data_provider.xhp
+msgctxt ""
+"data_provider.xhp\n"
+"par_id240920171007419799\n"
+"help.text"
+msgid "Data Provider"
+msgstr ""
+
#: ex_data_stat_func.xhp
msgctxt ""
"ex_data_stat_func.xhp\n"
@@ -57861,7 +57973,7 @@ msgctxt ""
"func_color.xhp\n"
"bm_id1102201617201921\n"
"help.text"
-msgid "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>"
+msgid "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>"
msgstr ""
#: func_color.xhp
@@ -60808,14 +60920,6 @@ msgctxt ""
msgid "<item type=\"input\">=IMSINH(2)</item><br/>returns 3.62686040784702 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>"
msgstr ""
-#: func_imsinh.xhp
-msgctxt ""
-"func_imsinh.xhp\n"
-"par_id2773214341302\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>,<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>,<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>"
-msgstr "<embedvar href=\"text/scalc/01/func_imsin.xhp#imsin_head\"/>,<embedvar href=\"text/scalc/01/func_imcos.xhp#imcos_head\"/>,<embedvar href=\"text/scalc/01/func_imcosh.xhp#imcosh_head\"/>"
-
#: func_imtan.xhp
msgctxt ""
"func_imtan.xhp\n"
@@ -61637,7 +61741,7 @@ msgctxt ""
"func_rawsubtract.xhp\n"
"bm_2016112109230\n"
"help.text"
-msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value> <bookmark_value>RAWSUBTRACT function</bookmark_value>"
+msgid "<bookmark_value>rawsubtract;subtraction</bookmark_value> <bookmark_value>RAWSUBTRACT function</bookmark_value>"
msgstr ""
#: func_rawsubtract.xhp
@@ -61645,7 +61749,7 @@ msgctxt ""
"func_rawsubtract.xhp\n"
"hd_2016112109231\n"
"help.text"
-msgid "<variable id=\"rawsubtract_head\"><link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link></variable>"
+msgid "<link href=\"text/scalc/01/func_rawsubtract.xhp\">RAWSUBTRACT</link>"
msgstr ""
#: func_rawsubtract.xhp
@@ -61653,7 +61757,7 @@ msgctxt ""
"func_rawsubtract.xhp\n"
"par_2016112109232\n"
"help.text"
-msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors. </ahelp>"
+msgid "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp>"
msgstr ""
#: func_rawsubtract.xhp
@@ -63792,6 +63896,54 @@ msgctxt ""
msgid "=YEARFRAC(\"2008-01-01\"; \"2008-07-01\";0) returns 0.50."
msgstr "=YEARFRAC(\"2008-01-01\"; \"2008-07-01\";0) 傳回 0.50。"
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"tit\n"
+"help.text"
+msgid "Live Data Stream"
+msgstr ""
+
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"bm_id240920171018528200\n"
+"help.text"
+msgid "<bookmark_value>Data Stream;Live data stream</bookmark_value>"
+msgstr ""
+
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"hd_id240920171003006302\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/live_data_stream.xhp\">Live Data Stream</link>"
+msgstr ""
+
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id240920171003293400\n"
+"help.text"
+msgid "<ahelp hid=\".\">Live data stream for spreadsheets</ahelp>"
+msgstr ""
+
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id240920171007389295\n"
+"help.text"
+msgid "Menu <item type=\"menuitem\">Data – Streams...</item>"
+msgstr ""
+
+#: live_data_stream.xhp
+msgctxt ""
+"live_data_stream.xhp\n"
+"par_id240920171007419799\n"
+"help.text"
+msgid "Data streams"
+msgstr ""
+
#: solver.xhp
msgctxt ""
"solver.xhp\n"
@@ -66311,3 +66463,51 @@ msgctxt ""
"help.text"
msgid "In the example, you select the comma as a delimiter character. Cells A1 and A2 will be expanded to four columns each. A1 contains 1, B1 contains 2, and so on."
msgstr "在範例中,您選取逗號做為分隔字元。儲存格 A1 和 A2 會擴展為四欄。A1 包含 1,B1 包含 2,依此類推。"
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"tit\n"
+"help.text"
+msgid "Live Data Stream"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"bm_id240920171018528200\n"
+"help.text"
+msgid "<bookmark_value>XML Source;load XML data in spreadsheets</bookmark_value>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"hd_id240920171003006302\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source</link>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id240920171003293400\n"
+"help.text"
+msgid "<ahelp hid=\".\">Live data stream for spreadsheets</ahelp>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id240920171007389295\n"
+"help.text"
+msgid "Menu <item type=\"menuitem\">Data – XML Source...</item>"
+msgstr ""
+
+#: xml_source.xhp
+msgctxt ""
+"xml_source.xhp\n"
+"par_id240920171007419799\n"
+"help.text"
+msgid "XML Source"
+msgstr ""