summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-11-12 23:58:17 +0100
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-11-13 00:04:09 +0100
commitdee42a39ff84aae292b56cf83137983da5c28975 (patch)
treed60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/zh-TW/helpcontent2/source/text
parentf14221545cf5a1be2c6f74915bcaff29db79a85d (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I6b444d20d156df4126666efaeb30a0902054362b
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text')
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po122
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/01.po136
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/02.po10
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/explorer/database.po992
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/guide.po20
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/help.po4
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/optionen.po14
-rw-r--r--source/zh-TW/helpcontent2/source/text/smath.po6
-rw-r--r--source/zh-TW/helpcontent2/source/text/smath/01.po10
-rw-r--r--source/zh-TW/helpcontent2/source/text/swriter/guide.po10
10 files changed, 578 insertions, 746 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index ebb5becb145..8c2f67e2082 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: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\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"
@@ -13909,8 +13909,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3147273\n"
"help.text"
-msgid "<bookmark_value>matrices; functions</bookmark_value> <bookmark_value>Function Wizard; arrays</bookmark_value> <bookmark_value>array formulas</bookmark_value> <bookmark_value>inline array constants</bookmark_value> <bookmark_value>formulas;arrays</bookmark_value> <bookmark_value>functions;array functions</bookmark_value> <bookmark_value>editing; array formulas</bookmark_value> <bookmark_value>copying; array formulas</bookmark_value> <bookmark_value>adjusting array ranges</bookmark_value> <bookmark_value>calculating;conditional calculations</bookmark_value> <bookmark_value>matrices; calculations</bookmark_value> <bookmark_value>conditional calculations with arrays</bookmark_value> <bookmark_value>implicit array handling</bookmark_value> <bookmark_value>forced array handling</bookmark_value>"
-msgstr "<bookmark_value>陣列; 函式</bookmark_value><bookmark_value>函式精靈; 陣列</bookmark_value><bookmark_value>陣列公式</bookmark_value><bookmark_value>內嵌陣列常數</bookmark_value><bookmark_value>公式; 陣列</bookmark_value><bookmark_value>函式; 陣列函式</bookmark_value><bookmark_value>編輯; 陣列公式</bookmark_value><bookmark_value>複製; 陣列公式</bookmark_value><bookmark_value>調整陣列範圍</bookmark_value><bookmark_value>計算; 條件式計算</bookmark_value><bookmark_value>陣列; 計算</bookmark_value><bookmark_value>使用陣列的條件式計算</bookmark_value><bookmark_value>隱式陣列處理</bookmark_value><bookmark_value>強制陣列處理</bookmark_value>"
+msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14101,8 +14101,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3158432\n"
"help.text"
-msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10."
-msgstr "若要在上述陣列中將個別儲存格的值乘以 10,您不需要將公式分別套用至每個儲存格或值,而只要使用單一陣列公式即可。在試算表的其他部分選取 3 x 3 儲存格範圍,輸入 <item type=\"input\">=10*A1:C3</item> 公式,然後使用組合鍵 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter 確認此輸入。結果會是 3 x 3 陣列,其儲存格範圍 (A1:C3) 中的每個值會分別乘以係數 10。"
+msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14181,8 +14181,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3153392\n"
"help.text"
-msgid "If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula."
-msgstr "若直接在儲存格中輸入陣列公式,則必須使用 Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter 而非 Enter 鍵。唯有如此,輸入的公式才會成為陣列公式。"
+msgid "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14269,8 +14269,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id6757103\n"
"help.text"
-msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
-msgstr "若要輸入此陣列常數,請選取一列連續的三個儲存格,然後用大括號及分號輸入公式 <item type=\"input\">={1;2;3}</item>,然後按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter。"
+msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14333,7 +14333,7 @@ msgctxt ""
"04060107.xhp\n"
"par_id3149241\n"
"help.text"
-msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+/, where / is the Division key on the numeric keypad."
+msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + /</emph>, where <emph>/</emph> is the <emph>Division</emph> key on the numeric keypad."
msgstr ""
#: 04060107.xhp
@@ -14341,16 +14341,16 @@ msgctxt ""
"04060107.xhp\n"
"par_id3143274\n"
"help.text"
-msgid "Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula."
-msgstr "按下 F2 或將游標放在輸入欄中。這兩個動作都能讓您編輯公式。"
+msgid "Either press <emph>F2</emph> or position the cursor in the input line. Both of these actions let you edit the formula."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3154798\n"
"help.text"
-msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
-msgstr "在變更之後,按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter。"
+msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14381,32 +14381,32 @@ msgctxt ""
"04060107.xhp\n"
"par_id3154619\n"
"help.text"
-msgid "Either press F2 or position the cursor in the input line."
-msgstr "按下 F2 或將游標放在輸入欄中。"
+msgid "Either press <emph>F2</emph> or position the cursor in the input line."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3150994\n"
"help.text"
-msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C."
-msgstr "按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C 將公式複製到輸入行。"
+msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + C</emph>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3146787\n"
"help.text"
-msgid "Select a range of cells where you want to insert the array formula and either press F2 or position the cursor in the input line."
-msgstr "選取要插入陣列公式的儲存格範圍,然後按 F2 鍵或將游標放置在輸入欄中。"
+msgid "Select a range of cells where you want to insert the array formula and either press <emph>F2</emph> or position the cursor in the input line."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3154419\n"
"help.text"
-msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The selected range now contains the array formula."
-msgstr "按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V 將公式貼上所選位置,並按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>Shift+Enter 進行確認。選取的範圍就會包含此陣列公式。"
+msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The selected range now contains the array formula."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14453,7 +14453,7 @@ msgctxt ""
"04060107.xhp\n"
"par_id3146080\n"
"help.text"
-msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key, you can create a copy of the array formula in the given range."
+msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> key, you can create a copy of the array formula in the given range."
msgstr ""
#: 04060107.xhp
@@ -14853,7 +14853,7 @@ msgctxt ""
"04060107.xhp\n"
"par_id3150403\n"
"help.text"
-msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift+Command+Enter</item> </caseinline><defaultinline><item type=\"keycode\">Shift+Ctrl+Enter</item></defaultinline></switchinline>."
+msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>."
msgstr ""
#: 04060107.xhp
@@ -14885,8 +14885,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3145777\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array."
-msgstr "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">指示一個頻率分佈,以單欄陣列的形式顯示結果。</ahelp>函式統計 Data 陣列中在 Classes 陣列各值之內的值的個數。"
+msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the <emph>Data</emph> array that are within the values given by the <emph>Classes</emph> array."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -15237,8 +15237,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3151030\n"
"help.text"
-msgid "<bookmark_value>MDETERM function</bookmark_value> <bookmark_value>determinants</bookmark_value>"
-msgstr "<bookmark_value>MDETERM 函式</bookmark_value><bookmark_value>行列式</bookmark_value>"
+msgid "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -15285,8 +15285,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3151348\n"
"help.text"
-msgid "<bookmark_value>MINVERSE function</bookmark_value> <bookmark_value>inverse arrays</bookmark_value>"
-msgstr "<bookmark_value>MINVERSE 函式</bookmark_value><bookmark_value>逆陣列</bookmark_value>"
+msgid "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -15437,8 +15437,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3159366\n"
"help.text"
-msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
-msgstr "在試算表中,選取轉置後的陣列可顯示之範圍。若原先的陣列有 n 列 m 欄,則所選取的範圍至少要有 m 列 n 欄。然後直接輸入公式,選取原來的陣列並按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>。或者,若使用 <emph>[函式精靈]</emph>,則請標記 <emph>[陣列]</emph> 核取方塊。轉置後的陣列會顯示在選取的目標範圍中,且會自動受保護而無法變更。"
+msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -15461,7 +15461,7 @@ msgctxt ""
"04060107.xhp\n"
"par_id3178518\n"
"help.text"
-msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift+Command+Enter</emph></caseinline><defaultinline><emph>Shift+Ctrl+Enter</emph></defaultinline></switchinline>. The result will be as follows:"
+msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:"
msgstr ""
#: 04060107.xhp
@@ -15541,8 +15541,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id0811200804502261\n"
"help.text"
-msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return)."
-msgstr "LINEST 會傳回如下的統計表 (陣列),且必須以陣列公式的方式輸入 (例如使用 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return,而不只是 Return 鍵)。"
+msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>)."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16061,8 +16061,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3158106\n"
"help.text"
-msgid "The formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>"
-msgstr "<emph>[公式]</emph> 列中的公式對應至 LINEST 陣列 <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item> 的各儲存格。"
+msgid "The formula in the <emph>Formula</emph> bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16077,8 +16077,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3158146\n"
"help.text"
-msgid "<bookmark_value>slopes, see also regression lines</bookmark_value> <bookmark_value>regression lines;LINEST function</bookmark_value>"
-msgstr "<bookmark_value>斜率, 另請參閱迴歸線</bookmark_value><bookmark_value>迴歸線; LINEST 函式</bookmark_value>"
+msgid "<bookmark_value>slopes, see also regression lines</bookmark_value><bookmark_value>regression lines; LINEST function</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16101,8 +16101,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3158204\n"
"help.text"
-msgid "<bookmark_value>standard errors;array functions</bookmark_value>"
-msgstr "<bookmark_value>標準誤差; 陣列函式</bookmark_value>"
+msgid "<bookmark_value>standard errors; array functions</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16253,8 +16253,8 @@ msgctxt ""
"04060107.xhp\n"
"bm_id3163286\n"
"help.text"
-msgid "<bookmark_value>SUMPRODUCT function</bookmark_value> <bookmark_value>scalar products</bookmark_value> <bookmark_value>dot products</bookmark_value> <bookmark_value>inner products</bookmark_value>"
-msgstr "<bookmark_value>SUMPRODUCT 函式</bookmark_value><bookmark_value>數量積</bookmark_value><bookmark_value>點乘積</bookmark_value><bookmark_value>內積</bookmark_value>"
+msgid "<bookmark_value>SUMPRODUCT function</bookmark_value><bookmark_value>scalar products</bookmark_value><bookmark_value>dot products</bookmark_value><bookmark_value>inner products</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16277,16 +16277,16 @@ msgctxt ""
"04060107.xhp\n"
"par_id3163347\n"
"help.text"
-msgid "SUMPRODUCT(Array1; Array2...Array30)"
-msgstr "SUMPRODUCT(Array1; Array2...Array30)"
+msgid "SUMPRODUCT(Array1; Array2; ...; Array30)"
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3163362\n"
"help.text"
-msgid "<emph>Array1, Array2...Array30</emph> represent arrays whose corresponding elements are to be multiplied."
-msgstr "<emph>Array1, Array2...Array30</emph> 表示對應的元素將相乘的陣列。"
+msgid "<emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16685,24 +16685,24 @@ msgctxt ""
"04060107.xhp\n"
"par_id3166196\n"
"help.text"
-msgid "<emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0."
-msgstr "<emph>LinearType</emph>(選擇性)。若 LinearType = 0,則會計算通過零的直線。否則,也會計算偏移線。預設值為 LinearType <> 0。"
+msgid "<emph>LinearType</emph> (optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3166245\n"
"help.text"
-msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated from the output data is displayed."
-msgstr "選取一個用於顯示趨勢資料的試算表範圍。選取函式。輸入匯出資料,或透過滑鼠選取匯出資料。標記 <emph>[陣列]</emph> 欄位,並按一下 <emph>[確定]</emph>。螢幕上會顯示依匯出資料計算而得的趨勢資料。"
+msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field, click <emph>OK</emph>. The trend data calculated from the output data is displayed."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"bm_id3166317\n"
"help.text"
-msgid "<bookmark_value>GROWTH function</bookmark_value> <bookmark_value>exponential trends in arrays</bookmark_value>"
-msgstr "<bookmark_value>GROWTH 函式</bookmark_value><bookmark_value>陣列中的指數趨勢</bookmark_value>"
+msgid "<bookmark_value>GROWTH function</bookmark_value><bookmark_value>exponential trends in arrays</bookmark_value>"
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16757,16 +16757,16 @@ msgctxt ""
"04060107.xhp\n"
"par_id3173817\n"
"help.text"
-msgid "<emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated."
-msgstr "<emph>FunctionType</emph> (選擇性)。若 FunctionType = 0,將以格式 y = m^x 計算函式。否則會以 y = b*m^x 計算函式。"
+msgid "<emph>FunctionType</emph> (optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated."
+msgstr ""
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3173852\n"
"help.text"
-msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
-msgstr "此函式會傳回一個陣列,並以與其他陣列函式相同的方式進行處理。選取要顯示答案的範圍,然後依序選取函式與 DataY。輸入其他參數,核取 <emph>[陣列]</emph>,然後按一下 <emph>[確定]</emph>。"
+msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
+msgstr ""
#: 04060108.xhp
msgctxt ""
@@ -24325,8 +24325,8 @@ msgctxt ""
"04060115.xhp\n"
"par_id3156294\n"
"help.text"
-msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit."
-msgstr "<emph>UpperLimit</emph> 是選用項目。此為整數的上限。若缺少此值,會在 0 與下限之間進行計算。"
+msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes place between 0 and the lower limit."
+msgstr ""
#: 04060115.xhp
msgctxt ""
@@ -24373,7 +24373,7 @@ msgctxt ""
"04060115.xhp\n"
"par_id2949715\n"
"help.text"
-msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes places between 0 and this limit."
+msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit."
msgstr ""
#: 04060115.xhp
@@ -59661,7 +59661,7 @@ msgctxt ""
"xml_source.xhp\n"
"hd_id240920171003006302\n"
"help.text"
-msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source (Experimental)</link>"
+msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source</link>"
msgstr ""
#: xml_source.xhp
diff --git a/source/zh-TW/helpcontent2/source/text/shared/01.po b/source/zh-TW/helpcontent2/source/text/shared/01.po
index 37635ce3210..4733f3fb9bc 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/01.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/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: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
"PO-Revision-Date: 2018-02-05 11:57+0000\n"
"Last-Translator: Richard_Ng <richardng1126@hotmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -37968,6 +37968,110 @@ msgctxt ""
msgid "<link href=\"text/shared/01/packagemanager.xhp\">Extension Manager</link>"
msgstr "<link href=\"text/shared/01/packagemanager.xhp\">擴充軟體管理程式</link>"
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"tit\n"
+"help.text"
+msgid "OpenType Font Features"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"bm_id991541772077660\n"
+"help.text"
+msgid "<bookmark_value>font features</bookmark_value> <bookmark_value>font features;OpenType</bookmark_value> <bookmark_value>OpenType;font features</bookmark_value>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id581541769624076\n"
+"help.text"
+msgid "<link href=\"text/shared/01/font_features.xhp\" name=\"Features\">Font Features</link>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id501541769624078\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">Select and apply font typographical features to characters.</ahelp></variable>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id661541784477179\n"
+"help.text"
+msgid "Then press <emph>Features...</emph>"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id321541773889428\n"
+"help.text"
+msgid "%PRODUCTNAME supports OpenType font format. The two main benefits of the OpenType format are its cross-platform compatibility, and its ability to support widely expanded character sets and layout features, which provide richer linguistic support and advanced typographic control."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id531541778397964\n"
+"help.text"
+msgid "OpenType fonts can include an expanded character set and layout features, providing broader linguistic support and more precise typographic control."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id31541774826256\n"
+"help.text"
+msgid "The features displayed in the Font Features dialog depends on the selected font."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id81541778714507\n"
+"help.text"
+msgid "Font features box"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id991541778707882\n"
+"help.text"
+msgid "The font features box contains the configurable features available for the font."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"hd_id511541778721077\n"
+"help.text"
+msgid "Font feature visualization window"
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id31541778666390\n"
+"help.text"
+msgid "The feature visualization window displays a default text where the selected features can be inspected."
+msgstr ""
+
+#: font_features.xhp
+msgctxt ""
+"font_features.xhp\n"
+"par_id801541774734588\n"
+"help.text"
+msgid "<link href=\"https://en.wikipedia.org/wiki/OpenType\" name=\"OpenType\">Wikipedia on OpenType</link>"
+msgstr ""
+
#: formatting_mark.xhp
msgctxt ""
"formatting_mark.xhp\n"
@@ -39069,8 +39173,8 @@ msgctxt ""
"moviesound.xhp\n"
"bm_id1907712\n"
"help.text"
-msgid "<bookmark_value>inserting;movies/sounds</bookmark_value> <bookmark_value>sound files</bookmark_value> <bookmark_value>playing movies and sound files</bookmark_value> <bookmark_value>videos</bookmark_value> <bookmark_value>movies</bookmark_value> <bookmark_value>audio</bookmark_value> <bookmark_value>music</bookmark_value>"
-msgstr "<bookmark_value>插入; 影片/聲音</bookmark_value> <bookmark_value>聲音檔</bookmark_value> <bookmark_value>播放電影及聲音檔</bookmark_value> <bookmark_value>影片</bookmark_value> <bookmark_value>電影</bookmark_value> <bookmark_value>音訊</bookmark_value> <bookmark_value>音樂</bookmark_value>"
+msgid "<bookmark_value>inserting; movies/sounds</bookmark_value><bookmark_value>sound files</bookmark_value><bookmark_value>playing movies and sound files</bookmark_value><bookmark_value>videos</bookmark_value><bookmark_value>movies</bookmark_value><bookmark_value>audio</bookmark_value><bookmark_value>music</bookmark_value>"
+msgstr ""
#: moviesound.xhp
msgctxt ""
@@ -39109,7 +39213,7 @@ msgctxt ""
"moviesound.xhp\n"
"par_idN1068E\n"
"help.text"
-msgid "Choose <emph>Insert - Media - Audio or Video</emph>. For %PRODUCTNAME Impress, choose <emph>Insert - Audio or video</emph>."
+msgid "Choose <emph>Insert - Media - Audio or Video</emph>. For %PRODUCTNAME Impress, choose <emph>Insert - Audio or Video</emph>."
msgstr ""
#: moviesound.xhp
@@ -39117,8 +39221,8 @@ msgctxt ""
"moviesound.xhp\n"
"par_idN10696\n"
"help.text"
-msgid "In the File Open dialog, select the file that you want to insert."
-msgstr "在 [檔案] [開啟舊檔] 對話方塊中,選取要插入的檔案。"
+msgid "In the <emph>File Open</emph> dialog, select the file that you want to insert."
+msgstr ""
#: moviesound.xhp
msgctxt ""
@@ -39149,8 +39253,8 @@ msgctxt ""
"moviesound.xhp\n"
"par_id0120200912190948\n"
"help.text"
-msgid "Alternatively, you can choose <item type=\"menuitem\">Tools - Media Player</item> to open the Media Player. Use the Media Player to preview all supported media files. Click the Apply button in the Media Player window to insert the current media file into your document."
-msgstr "或者,您可選擇 <item type=\"menuitem\">[工具] - [媒體播放機]</item> 以開啟 [媒體播放機]。使用 Media Player 可預覽所有支援的媒體檔案。按一下 Media Player 視窗中的 [套用] 按鈕,可將目前的媒體檔插入您的文件。"
+msgid "Alternatively, you can choose <emph>Tools - Media Player</emph> to open the Media Player. Use the Media Player to preview all supported media files. Click the <emph>Apply</emph> button in the Media Player window to insert the current media file into your document."
+msgstr ""
#: moviesound.xhp
msgctxt ""
@@ -39173,8 +39277,8 @@ msgctxt ""
"moviesound.xhp\n"
"par_id0120200912190940\n"
"help.text"
-msgid "If the icon is arranged on the background, hold down Ctrl while you click."
-msgstr "若圖示排列於背景中,請於按一下時按住 Ctrl 鍵。"
+msgid "If the icon is arranged on the background, hold down <emph>Ctrl</emph> while you click."
+msgstr ""
#: moviesound.xhp
msgctxt ""
@@ -39205,8 +39309,8 @@ msgctxt ""
"moviesound.xhp\n"
"par_idN106D0\n"
"help.text"
-msgid "You can also use the Media Playback Bar to pause, to stop, to loop, as well as to adjust the volume or to mute the playback of the file. The current playback position in the file is indicated on the left slider. Use the right slider to adjust the playback volume. For movie files, the bar also contains a list box where you can select the zoom factor for the playback."
-msgstr "此外,使用「媒體播放」列可以暫停 、停止、循環播放,也可以調整音量或關閉播放檔案的聲音。檔案正在播放的位置會標示在左邊滑動軸中。使用右邊滑動軸來調整播放音量。如果是電影檔案,此列還提供清單方塊,好讓您選取播放的顯示比例。"
+msgid "You can also use the <emph>Media Playback</emph> bar to pause, to stop, to loop, as well as to adjust the volume or to mute the playback of the file. The current playback position in the file is indicated on the left slider. Use the right slider to adjust the playback volume. For movie files, the bar also contains a list box where you can select the zoom factor for the playback."
+msgstr ""
#: moviesound.xhp
msgctxt ""
@@ -39229,7 +39333,7 @@ msgctxt ""
"moviesound.xhp\n"
"par_id231511209745892\n"
"help.text"
-msgid "<emph>For Microsoft Windows</emph>: %PRODUCTNAME can open anything for which <emph>DirectShow</emph> filters are installed (<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">list of default formats</link>)."
+msgid "<emph>For Microsoft Windows</emph>: %PRODUCTNAME can open anything for which <emph>DirectShow</emph> filters are installed (<link href=\"https://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">list of default formats</link>)."
msgstr ""
#: moviesound.xhp
@@ -39237,7 +39341,7 @@ msgctxt ""
"moviesound.xhp\n"
"par_id601511209768414\n"
"help.text"
-msgid "<emph>For GNU/Linux</emph>: %PRODUCTNAME uses <emph>gstreamer</emph>, so whatever you can play using gstreamer can be used with %PRODUCTNAME (<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">list of defined types</link>)."
+msgid "<emph>For GNU/Linux</emph>: %PRODUCTNAME uses <emph>gstreamer</emph>, so whatever you can play using gstreamer can be used with %PRODUCTNAME (<link href=\"https://gstreamer.freedesktop.org/documentation/plugin-development/advanced/media-types.html#list-of-defined-types\" name=\"linkname\">list of defined types</link>)."
msgstr ""
#: moviesound.xhp
@@ -39253,7 +39357,7 @@ msgctxt ""
"moviesound.xhp\n"
"par_id391511209364018\n"
"help.text"
-msgid "<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">List of default formats for Microsoft Windows DirectShow </link>."
+msgid "<link href=\"https://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">List of default formats for Microsoft Windows DirectShow</link>."
msgstr ""
#: moviesound.xhp
@@ -39261,7 +39365,7 @@ msgctxt ""
"moviesound.xhp\n"
"par_id921511209448360\n"
"help.text"
-msgid "<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">List of defined types for gstreamer in GNU/Linux </link>."
+msgid "<link href=\"https://gstreamer.freedesktop.org/documentation/plugin-development/advanced/media-types.html#list-of-defined-types\" name=\"linkname\">List of defined types for gstreamer in GNU/Linux</link>."
msgstr ""
#: moviesound.xhp
diff --git a/source/zh-TW/helpcontent2/source/text/shared/02.po b/source/zh-TW/helpcontent2/source/text/shared/02.po
index f167c9bd20c..abef69e34cc 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/02.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/02.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: 2018-09-07 12:46+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
"PO-Revision-Date: 2018-02-05 11:59+0000\n"
"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -885,8 +885,8 @@ msgctxt ""
"01170000.xhp\n"
"par_id3149123\n"
"help.text"
-msgid "<ahelp hid=\".uno:RadioButton\">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href=\"text/shared/02/01170101.xhp\" name=\"Name\"><emph>Name</emph></link><emph>property</emph>). Normally, they are given a <link href=\"text/shared/02/01170000.xhp\" name=\"group box\">group box</link>."
-msgstr "<ahelp hid=\".uno:RadioButton\">建立選項按鈕。</ahelp>使用選項按鈕,使用者可以選擇數個選項之一。功能相同的選項按鈕具有相同的名稱 (<link href=\"text/shared/02/01170101.xhp\" name=\"[名稱]\"><emph>[名稱]</emph></link><emph> 屬性</emph>)。通常,它們稱為<link href=\"text/shared/02/01170000.xhp\" name=\"群組方塊\">群組方塊</link>。"
+msgid "<ahelp hid=\".uno:RadioButton\">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href=\"text/shared/02/01170101.xhp\" name=\"Name\"><emph>Name</emph></link> <emph>property</emph>). Normally, they are given a <link href=\"text/shared/02/01170000.xhp\" name=\"group box\">group box</link>."
+msgstr ""
#: 01170000.xhp
msgctxt ""
@@ -15509,8 +15509,8 @@ msgctxt ""
"18030000.xhp\n"
"par_id3150040\n"
"help.text"
-msgid "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\"><alt id=\"alt_id3150808\">Icon</alt></image>"
-msgstr "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\"><alt id=\"alt_id3150808\">圖示</alt></image>"
+msgid "<image src=\"cmd/sc_spellonline.png\" id=\"img_id3150808\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150808\">Automatic Spell Checking On/Off</alt></image>"
+msgstr ""
#: 18030000.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po b/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po
index 6181bb97c14..b4b168ceb50 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/explorer/database.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: 2018-05-16 16:54+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
"PO-Revision-Date: 2018-02-05 12:06+0000\n"
"Last-Translator: Igli Manaj <manajigli@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -45,8 +45,8 @@ msgctxt ""
"02000000.xhp\n"
"par_id3150499\n"
"help.text"
-msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table to multiple tables, if they are linked by common data fields."
-msgstr "「查詢」是表格的特殊檢視。查詢可以顯示選擇的條目或條目內選擇的欄位,亦可排序這些條目。查詢可套用至一到多個表格 (如果這些表格由共用資料欄位所連結)。"
+msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields."
+msgstr ""
#: 02000000.xhp
msgctxt ""
@@ -405,8 +405,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3150255\n"
"help.text"
-msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
-msgstr "設計檢視的下方窗格是<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"定義\">定義</link>查詢的位置。若要定義查詢,請指定要包括的資料庫<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"欄位名稱\">欄位名稱</link>和用於顯示這些欄位的<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"條件\">條件</link>。若要重新安排設計檢視下方窗格中的欄,請將欄標頭拖曳至新的位置,或選取欄並按 <switchinline select=\"sys\"><caseinline select=\"MAC\">指令</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+方向鍵。"
+msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -581,16 +581,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3152577\n"
"help.text"
-msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must tell $[officename] what the relationship exists between the data in the two spreadsheets."
-msgstr "例如,如果您具有透過商品號碼識別的商品的試算表,以及透過對應的商品號碼記錄了客戶訂購的全部商品的客戶試算表,則在這兩個「商品號碼」資料欄位之間就存在關係。現在,如果要建立返回客戶訂購的所有商品的查詢,您必須從兩個試算表文件中擷取資料。若要如此,您必須告知 $[officename] 這兩個試算表中的資料所存在的關係。"
+msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3155302\n"
"help.text"
-msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields in the two windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query."
-msgstr "按一下表格的資料欄位 (例如,客戶表中的「商品編號」資料欄位) 然後按住滑鼠鍵拖曳到另一個表格的資料欄位上 (商品表的「商品編號」)。當您現在放開滑鼠鍵時,便會看到一條線,連接兩個視窗中的兩個欄位。在產生結果的 SQL 查詢中會輸入對應的條件,指定兩個資料欄位的內容必須相同。"
+msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -613,16 +613,16 @@ msgctxt ""
"02010100.xhp\n"
"hd_id3153279\n"
"help.text"
-msgid "Specifying link type"
-msgstr "設定連結類型"
+msgid "Specifying the relation type"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3154791\n"
"help.text"
-msgid "If you double-click the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of link in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
-msgstr "如果您連按兩下連結兩個欄位的線條,或呼叫功能表指令<emph>[插入] - [新增關係]</emph>,您就可以在<link href=\"text/shared/explorer/database/02010101.xhp\" name=\"[關係]\"><emph>[關係]</emph></link>對話方塊中指定連結的類型。"
+msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -661,8 +661,8 @@ msgctxt ""
"02010100.xhp\n"
"hd_id3151208\n"
"help.text"
-msgid "Define query"
-msgstr "定義查詢"
+msgid "Defining the query"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -677,16 +677,16 @@ msgctxt ""
"02010100.xhp\n"
"hd_id3154161\n"
"help.text"
-msgid "Specify field name"
-msgstr "設定資料欄位"
+msgid "Specifying field names"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3146791\n"
"help.text"
-msgid "First, select all field names from the tables that you want to add to the query. You can do this either with drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design. As you do this, you can decide which column you want to add the field to. Select a field name by double-clicking. It will then be added to the next free column."
-msgstr "首先,從表格中選取要加入此查詢的所有欄位的名稱。拖放表格視窗中的欄位名稱,或將其按兩下,都可達到這一目的。拖放方法,就是使用滑鼠將欄位名稱從表格視窗拖到此查詢設計的下方區域中。拖放時,您可以決定要將此欄位加入哪個欄中。透過按兩下來選取欄位名稱,即可將其加入下一個空白欄中。"
+msgid "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -709,16 +709,16 @@ msgctxt ""
"02010100.xhp\n"
"hd_id3155764\n"
"help.text"
-msgid "Save query"
-msgstr "儲存查詢"
+msgid "Saving the query"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3148481\n"
"help.text"
-msgid "Use the <emph>Save</emph> icon on the Standard Bar to save the query. You see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema."
-msgstr "使用 [標準] 列上的<emph>儲存</emph>圖示來儲存此查詢。您會看見一個對話方塊,要求您輸入查詢的名稱。如果資料庫支援概要,您也可以輸入概要。"
+msgid "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -765,8 +765,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154964\n"
"help.text"
-msgid "To filter data for the query, set the desired preferences in the lower area of the Design View. The following lines are available:"
-msgstr "若要篩選此查詢的資料,請在設計檢視的下方區域中設定所需的偏好。下列行可用:"
+msgid "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -781,8 +781,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3156372\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that you referred to in the Query. All settings made in the lower rows refer to this field.</ahelp> If you activate a cell with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields and the criteria is valid for all table fields."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">輸入您在此查詢中所參照資料欄位的名稱。在下方的列中所做的所有設定都參照此欄位。</ahelp>如果您透過按一下滑鼠來啟動儲存格,您將看見一個箭頭按鈕,您可以使用該按鈕選取欄位。「Table name.*」選項選取所有的資料欄位,此條件對於所有的表格欄位都有效。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -797,16 +797,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3146315\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in a query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field has the name PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as alias."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">指定別名。查詢中將列出此別名,而不是欄位名稱。如此將使其能夠使用使用者定義的欄標籤。</ahelp>例如,如果資料欄位已經擁有名稱 PtNo(而非該名稱),而您希望查詢中出現 PartNum,請將 PartNum 輸入為別名。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3155959\n"
"help.text"
-msgid "In an SQL statement, aliases are defined as following:"
-msgstr "在 SQL 陳述式中,代用名設定如下:"
+msgid "In a SQL statement, aliases are defined as follows:"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -845,8 +845,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3163665\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate the a cell with a mouse click, an arrow will appear which enables you to select another table of the current query."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">在此將列出與所選資料欄位對應的資料庫表格。</ahelp>如果您透過按一下滑鼠來啟動儲存格,則會出現一個箭頭,使用它您可以選取目前查詢中的另一個表格。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -861,8 +861,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3150979\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click the cell, you can select among the sorting options: ascending, descending and not sorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">如果您按一下此儲存格,可以在排序選項中進行選取:向上、向下和不排序。</ahelp>文字欄位將依字母順序排序,而數字欄位將依數字順序排序。管理員可設定大部分資料庫的排序選項。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -877,8 +877,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3146133\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visible in the query</ahelp>. If you only use a data field to formulate a condition, you do not necessarily need to show it."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">如果您將資料欄位標示為 <emph>[可見的]</emph> 特性,該欄位在查詢中將會是可見狀態</ahelp>。如果您僅使用資料欄位來建立條件,您不一定需要顯示它。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -893,8 +893,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3145134\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field should be filtered.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">指定篩選資料欄位內容的<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"條件\">條件</link>。</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -909,16 +909,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154585\n"
"help.text"
-msgid "Here you can enter one additional criterion for filtering in each line. Multiple criteria in one column will be connected by an OR link."
-msgstr "您可以在此於每一列中輸入用於篩選的另一個條件。欄中的許多條件會以 OR 連結。"
+msgid "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3148800\n"
"help.text"
-msgid "You can also use the context menu of the line headers in the lower area of the query design to insert another line for functions:"
-msgstr "此外,您可以透過列標題的右鍵功能表於查詢設計下方區域中,再插入用於功能的一列:"
+msgid "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -933,16 +933,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3153233\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query here.</ahelp> The functions you can run here depend on the database."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">選取要在此處的查詢中執行的功能。</ahelp>您可以在此處執行的功能要視資料庫而定。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id8760818\n"
"help.text"
-msgid "If you are working with the HSQL database, the list box in the <emph>Function</emph> row offers you the following options:"
-msgstr "若正使用 HSQL 資料庫,則<emph>功能</emph>列中的清單方塊將提供您以下選項:"
+msgid "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -955,14 +955,6 @@ msgstr "<emph>選項</emph>"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3166430\n"
-"help.text"
-msgid "SQL"
-msgstr "執行 SQL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3152993\n"
"help.text"
msgid "Effect"
@@ -995,14 +987,6 @@ msgstr "平均值"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3145268\n"
-"help.text"
-msgid "AVG"
-msgstr "AVG"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3154486\n"
"help.text"
msgid "Calculates the arithmetic mean of a field."
@@ -1019,18 +1003,10 @@ msgstr "數目"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3154260\n"
-"help.text"
-msgid "COUNT"
-msgstr "COUNT"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3155810\n"
"help.text"
-msgid "Determines the number of records in the table. Empty fields can either be counted (a) or not (b)."
-msgstr "決定表格中的資料條目數。空欄位的數目可以計數 (a) 或不計數 (b)。"
+msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1045,8 +1021,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3152889\n"
"help.text"
-msgid "b) COUNT(column): Passing a field name as an argument counts only fields in which the field name in question contains a value. Null values (empty fields) will not be counted."
-msgstr "b) COUNT(column):如果您代入資料欄位作為自變數,則只會計算其中每個資料欄位包含一個值的欄位。在此零值 (空欄位) 不會計入。"
+msgid "b) COUNT(column): Passing a field name as an argument counts only those records for fields in which the field name in question contains a value. Records with fields having Null values (i.e. fields containing no characters) will not be counted."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1059,18 +1035,10 @@ msgstr "最大值"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3148840\n"
-"help.text"
-msgid "MAX"
-msgstr "MAX"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3159221\n"
"help.text"
-msgid "Determines the highest value of a field."
-msgstr "計算出某個欄位的最高值。"
+msgid "Determines the highest value of a record for that field."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1083,18 +1051,10 @@ msgstr "最小值"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3148604\n"
-"help.text"
-msgid "MIN"
-msgstr "MIN"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3157982\n"
"help.text"
-msgid "Determines the lowest value of a field."
-msgstr "計算出某個欄位的最低值。"
+msgid "Determines the lowest value of a record for that field."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1107,18 +1067,10 @@ msgstr "總計"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3147070\n"
-"help.text"
-msgid "SUM"
-msgstr "SUM"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3154536\n"
"help.text"
-msgid "Calculates the sum of values of associated fields."
-msgstr "計算所屬欄位值的總計。"
+msgid "Calculates the sum of the values of records for the associated fields."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1131,18 +1083,10 @@ msgstr "群組"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3145375\n"
-"help.text"
-msgid "GROUP BY"
-msgstr "GROUP BY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3149438\n"
"help.text"
-msgid "Groups query data according to the field name selected. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING."
-msgstr "依據選取的欄位名稱,分組查詢資料。函式依據指定的群組執行。在 SQL 中,此選項對應於 GROUP BY 子句。如果加入規則,此條目會出現在 SQL HAVING 中。"
+msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1181,24 +1125,24 @@ msgctxt ""
"02010100.xhp\n"
"par_id3159205\n"
"help.text"
-msgid "Except for the <emph>Group</emph> function, the above functions are so-called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database system in use and on the current state of the Base driver."
-msgstr "除了<emph>「群組」</emph>功能外,上述功能均關係到所謂的「集合」功能。這些功能即為透過計算資料從結果建立摘要的功能。其它未列於清單方塊中的功能亦可使用。這些功能視您所使用的特定資料庫系統以及 Base 驅動程式目前的狀態而定。"
+msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3148651\n"
"help.text"
-msgid "To use other functions not listed in the list box, you must enter them under <emph>Field</emph>."
-msgstr "若要使用清單方塊中未列出的其他功能,您必須在 <emph>[欄位]</emph> 下輸入這些功能。"
+msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3155098\n"
"help.text"
-msgid "You can also assign aliases to function calls. If the query is not to be displayed in the column header, enter the desired name under <emph>Alias</emph>."
-msgstr "您同樣可以為功能呼叫配上代用名。如果在欄標題中查詢不應顯示為功能名稱,則在<emph>「別名」</emph>下輸入所要的名稱。"
+msgid "You can also assign aliases to function calls. If you not wish the query string to be displayed in the column header, enter a desired substitute name under <emph>Alias</emph>."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1237,8 +1181,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154610\n"
"help.text"
-msgid "If you run this function, you cannot insert any additional columns for the query other than receiving these columns as a \"Group\" function."
-msgstr "當您執行一個功能時,您可以不必為查詢插入其他欄,除非這些欄位是當作「群組」功能取得。"
+msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1285,8 +1229,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3161652\n"
"help.text"
-msgid "Double-click the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
-msgstr "按兩下「商品」表中的「商品_No」欄位。透過右鍵功能表顯示<emph>「功能」</emph>列,並選取「數目」功能。"
+msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1389,8 +1333,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3150414\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for selection of functions.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">顯示或隱藏功能選取的列。</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1437,8 +1381,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3147500\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applies only distinct values to the query.</ahelp> This applies to records containing data that appears several times in the selected fields. If the <emph>Distinct Values</emph> command is active, you will see only one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">僅將明確的數值套用至查詢。</ahelp>這適用於其資料在所選欄位中數次出現的記錄。如果已啟動 <emph>[明確的數值]</emph> 指令,您僅能在查詢 (DISTINCT) 中看到一條記錄。否則,您將看到對應於查詢條件 (ALL) 的全部記錄。"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1477,7 +1421,7 @@ msgctxt ""
"02010100.xhp\n"
"par_id3147501\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to maximize the number of records with which query returns.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>"
msgstr ""
#: 02010100.xhp
@@ -1485,8 +1429,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3152350\n"
"help.text"
-msgid "If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
-msgstr "如果有限制<emph>極限值</emph>,會得到和指定數值一樣多的列數。否則會得到與查詢條件相應的全部記錄。"
+msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1501,8 +1445,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3153162\n"
"help.text"
-msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:"
-msgstr "當建立篩選條件時,您可以使用各種運算子和指令。除可使用關係運算子外,還可使用查詢資料庫欄位內容的 SQL 特定指令。如果您按 $[officename] 語法使用這些指令,$[officename] 會自動將它們轉換為對應的 SQL 語法。您也可以直接輸入 SQL 指令。以下表格給出了這些運算子和指令的摘要:"
+msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1531,14 +1475,6 @@ msgstr "<emph>條件滿足,如果...</emph>"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3156161\n"
-"help.text"
-msgid "="
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3153026\n"
"help.text"
msgid "equal to"
@@ -1557,16 +1493,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3153120\n"
"help.text"
-msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the operator = will be automatically adopted."
-msgstr "運算子 <emph>=</emph> 不會在查詢欄位中顯示;如果您輸入一個不帶運算子的值,便會接受運算子 <emph>=</emph>。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3150470\n"
-"help.text"
-msgid "<>"
-msgstr "<>"
+msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1587,14 +1515,6 @@ msgstr "... 欄位內容不符合指定的表示式。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3153015\n"
-"help.text"
-msgid ">"
-msgstr ">"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3146815\n"
"help.text"
msgid "greater than"
@@ -1611,14 +1531,6 @@ msgstr "... 欄位內容大於指定的表示式。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3147270\n"
-"help.text"
-msgid "<"
-msgstr "<"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3147379\n"
"help.text"
msgid "less than"
@@ -1635,14 +1547,6 @@ msgstr "... 欄位內容小於指定的表示式。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3149787\n"
-"help.text"
-msgid ">="
-msgstr ">="
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3150636\n"
"help.text"
msgid "greater than or equal to"
@@ -1659,14 +1563,6 @@ msgstr "... 欄位內容大於或等於指定的表示式。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3157964\n"
-"help.text"
-msgid "<="
-msgstr "<="
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3154052\n"
"help.text"
msgid "less than or equal to"
@@ -1715,22 +1611,6 @@ msgstr "<emph>條件滿足,如果...</emph>"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3154275\n"
-"help.text"
-msgid "IS EMPTY"
-msgstr "ISBLANK"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149893\n"
-"help.text"
-msgid "IS NULL"
-msgstr "IS NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3143236\n"
"help.text"
msgid "is null"
@@ -1741,28 +1621,12 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154744\n"
"help.text"
-msgid "... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No)."
+msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)."
msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3146940\n"
-"help.text"
-msgid "IS NOT EMPTY"
-msgstr "IS NOT NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3147471\n"
-"help.text"
-msgid "IS NOT NULL"
-msgstr "IS NOT NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3151229\n"
"help.text"
msgid "is not empty"
@@ -1773,40 +1637,24 @@ msgctxt ""
"02010100.xhp\n"
"par_id3145304\n"
"help.text"
-msgid "... the field name is not empty."
-msgstr "... 資料欄位不是空缺。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3153578\n"
-"help.text"
-msgid "LIKE"
-msgstr "LIKE"
+msgid "... the field is not empty, i.e it contains data."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3153891\n"
"help.text"
-msgid "(placeholder * for any number of characters"
-msgstr "(萬用字元 * 可用於任意數目的字元"
+msgid "placeholder (*) for any number of characters"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3148887\n"
"help.text"
-msgid "placeholder ? for exactly one character)"
-msgstr "萬用字元 ? 僅用於一個字元)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148623\n"
-"help.text"
-msgid "LIKE"
-msgstr "LIKE"
+msgid "placeholder (?) for exactly one character"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1821,16 +1669,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3157985\n"
"help.text"
-msgid "(% placeholder for any number of characters"
-msgstr "(% 萬用字元表示任意數目的字元"
+msgid "placeholder (%) for any number of characters"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3147422\n"
"help.text"
-msgid "Placeholder _ for exactly one character)"
-msgstr "萬用字元 _ 僅用於一個字元)"
+msgid "Placeholder (_) for exactly one character"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1845,32 +1693,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3156130\n"
"help.text"
-msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the $[officename] interface."
-msgstr "... 資料欄位含有指定的表示式。在此萬用字元 (*) 指定表示式 x 要出現在開頭 (x*)、在尾端 (*x) 或於欄位內容中 (*x*)。您可以在 SQL 查詢中輸入 SQL 字元 % 作為萬用字元,在 $[officename] 平面則輸入檔案系統所熟悉的萬用字元 (*)。"
+msgid "... the data field must contain the indicated search string in the order given. The position of the (*) placeholder indicates whether the searched for string (x) occurs before the placeholder (x*), after the placeholder (*x) or between the placeholders (*x*). Instead of the familiar file system (*) placeholder, you can also use the SQL (%) character as a placeholder in SQL queries in the $[officename] interface."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3150271\n"
"help.text"
-msgid "The * or % placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
-msgstr "萬用字元 * 或 % 表示任意數目的字元。針對僅一個字元則可在 $[officename] 平面中使用問號 (?) 或於 SQL 查詢中使用底線 (_) 當作萬用字元。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152954\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NOT LIKE"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3161669\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NOT LIKE"
+msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1885,24 +1717,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3161664\n"
"help.text"
-msgid "... the field name does not contain the specified expression."
-msgstr "... 資料欄位不包含指定的表示式。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149185\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "BETWEEN x AND y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3151259\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "BETWEEN x AND y"
+msgid "... the field does not contain data having the specified expression."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1917,24 +1733,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154395\n"
"help.text"
-msgid "... the field name contains a value that lies between the two values x and y."
-msgstr "... 資料欄位包含一個介於 x 和 y 兩者之間的數值。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3154561\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NOT BETWEEN x AND y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148753\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NOT BETWEEN x AND y"
+msgid "... the field contains a data value that lies between the two values x and y."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1949,32 +1749,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3148992\n"
"help.text"
-msgid "... the field name contains a value that does not lie between the two values x and y."
-msgstr "... 資料欄位包含一個不在 x 和 y 兩者之間的數值。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149995\n"
-"help.text"
-msgid "IN (a; b; c...)"
-msgstr "IN (a; b; c...)"
+msgid "... the field contains a data value that does not lie between the two values x and y."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3159167\n"
"help.text"
-msgid "Note that the semicolons are used as separators in all value lists!"
-msgstr "請注意,分號於所有數值清單中代表分隔符!"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3159085\n"
-"help.text"
-msgid "IN (a, b, c...)"
-msgstr "IN (a, b, c...)"
+msgid "Note that semicolons are used as separators in all value lists!"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1989,24 +1773,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3148399\n"
"help.text"
-msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by an Or link. The expressions a, b, c... can be either numbers or characters"
-msgstr "... 資料欄位包含指定的表示式 a、b、c、... 之一。您可指定任意數目的表示式,查詢結果會透過 OR 連結得出。表示式 a、b、c... 可以是數字,也可以是字元"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3154112\n"
-"help.text"
-msgid "NOT IN (a; b; c...)"
-msgstr "NOT IN (a; b; c...)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3153544\n"
-"help.text"
-msgid "NOT IN (a, b, c...)"
-msgstr "NOT IN (a, b, c...)"
+msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2021,24 +1789,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3158439\n"
"help.text"
-msgid "... the field name does not contain one of the specified expressions a, b, c,..."
-msgstr "... 資料欄位不包含指定的表示式 a、b、c、... 的任何一個。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3145145\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= TRUE"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146804\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= TRUE"
+msgid "... the field does not contain one of the specified expressions a, b, c,..."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2059,22 +1811,6 @@ msgstr "... 資料欄位擁有數值 TRUE。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3159212\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= FALSE"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3144751\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= FALSE"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3149955\n"
"help.text"
msgid "has the value false"
@@ -2085,8 +1821,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3146850\n"
"help.text"
-msgid "... the field name has the value false."
-msgstr "... 資料欄位擁有數值 FALSE。"
+msgid "... the field data value is set to false."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2099,14 +1835,6 @@ msgstr "範例"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3153792\n"
-"help.text"
-msgid "='Ms.'"
-msgstr "='Frau'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3150948\n"
"help.text"
msgid "returns field names with the field content \"Ms.\""
@@ -2115,14 +1843,6 @@ msgstr "得出欄位內容為「Frau」的資料欄位。"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id315379A\n"
-"help.text"
-msgid "<'2001-01-10'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id315094A\n"
"help.text"
msgid "returns dates that occurred before January 10, 2001"
@@ -2131,82 +1851,42 @@ msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3150333\n"
-"help.text"
-msgid "LIKE 'g?ve'"
-msgstr "LIKE 'g?ve'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3147332\n"
"help.text"
-msgid "returns field names with field content such as \"give\" and \"gave\"."
-msgstr "返回具有如「give」和「gave」欄位內容的欄位名稱。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146062\n"
-"help.text"
-msgid "LIKE 'S*'"
-msgstr "LIKE 'S*'"
+msgid "returns records with field content such as \"give\" and \"gave\"."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3155350\n"
"help.text"
-msgid "returns data fields with field contents such as \"Sun\"."
-msgstr "得出欄位內容為「Sun」的資料欄位。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152883\n"
-"help.text"
-msgid "BETWEEN 10 AND 20"
-msgstr "BETWEEN 10 AND 20"
+msgid "returns records with field contents such as \"Sun\"."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3159406\n"
"help.text"
-msgid "returns field names with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
-msgstr "得出欄位內容介於數值 10 和 20 之間的資料欄位。(亦可為文字欄位和數字欄位相關。)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148765\n"
-"help.text"
-msgid "IN (1; 3; 5; 7)"
-msgstr "IN (1; 3; 5; 7)"
+msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3149712\n"
"help.text"
-msgid "returns field names with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
-msgstr "得出含數值 1、3、5、7 的資料欄位。如果資料欄位包含一個商品編號,您可以建立得出包含指定編號的特定商品查詢。"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "NOT IN ('Smith')"
-msgstr "NOT IN ('Mler')"
+msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3147279\n"
"help.text"
-msgid "returns field names that do not contain \"Smith\"."
-msgstr "得出不含「Mler」的資料欄位。"
+msgid "returns records that do not contain \"Smith\"."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2261,8 +1941,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3149134\n"
"help.text"
-msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't see it that strict)."
-msgstr "若要查詢文字欄位的內容,您必須以單引號括起表示式。大小寫則不予區分。"
+msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2323,30 +2003,6 @@ msgstr "日期"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id315913112\n"
-"help.text"
-msgid "{D'YYYY-MM-DD'}"
-msgstr "{D'YYYY-MM-DD'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975313\n"
-"help.text"
-msgid "{d 'YYYY-MM-DD'}"
-msgstr "{d 'YYYY-MM-DD'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975314\n"
-"help.text"
-msgid "'YYYY-MM-DD'"
-msgstr "'YYYY-MM-DD'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id31559471\n"
"help.text"
msgid "Time"
@@ -2355,30 +2011,6 @@ msgstr "時間"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id31559472\n"
-"help.text"
-msgid "{D'HH:MM:SS'}"
-msgstr "{D'HH:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559473\n"
-"help.text"
-msgid "{t 'HH:MI:SS[.SS]'}"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559474\n"
-"help.text"
-msgid "'HH:MI:SS[.SS]'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id31509641\n"
"help.text"
msgid "DateTime"
@@ -2387,30 +2019,6 @@ msgstr "日期時間"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id31509642\n"
-"help.text"
-msgid "{D'YYYY-MM-DD HH:MM:SS'}"
-msgstr "{D'YYYY-MM-DD HH:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509643\n"
-"help.text"
-msgid "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509644\n"
-"help.text"
-msgid "'YYYY-MM-DD HH:MI:SS[.SS]'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3149539\n"
"help.text"
msgid "Example: select {d '1999-12-31'} from world.years"
@@ -2429,7 +2037,7 @@ msgctxt ""
"02010100.xhp\n"
"par_id3150510\n"
"help.text"
-msgid "All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
+msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
msgstr ""
#: 02010100.xhp
@@ -2661,32 +2269,32 @@ msgctxt ""
"02010100.xhp\n"
"par_id3152570\n"
"help.text"
-msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has been created previously."
-msgstr "在 $[officename] 中,對於大多數查詢您無需任何 SQL 的知識,因為您不必輸入 SQL 程式碼。如果您在查詢設計中建立查詢,$[officename] 自動將您的指令轉換成對應的 SQL 語法。如果您變更至 SQL 檢視 (藉助 <emph>[啟動或關閉設計檢視]</emph> 按鈕),您可以查看先前所建立查詢的 SQL 指令。"
+msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3152412\n"
"help.text"
-msgid "You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
-msgstr "您可以直接在 SQL 程式碼中建立您的查詢。但是要注意的是,特殊語法需視您使用的資料庫系統而定。"
+msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3146842\n"
"help.text"
-msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in <emph>Query design</emph>. These queries must be executed in native SQL mode."
-msgstr "如果您手動輸入 SQL 程式碼,便可以建立特殊的 SQL 查詢,但是<emph>查詢設計</emph>中的圖形平面則不支援。這些查詢必須以「Native SQL」模式執行。"
+msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode."
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3149632\n"
"help.text"
-msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]."
-msgstr "透過按一下 SQL 檢視中的<link href=\"text/shared/02/14030000.xhp\" name=\"直接執行 SQL 指令\"><emph>直接執行 SQL 指令</emph></link>圖示,您可以用公式表示未經 $[officename] 處理的查詢。"
+msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]and sent directly to the database engine."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2773,8 +2381,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3152482\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the link type of the selected link.</ahelp> Some databases support only a subset of the possible types."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">指定所選連結的連結類型。</ahelp>某些資料庫只支援可能類型的子集。"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2789,8 +2397,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3155936\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the internal join, the results table contains only the records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">透過內部連結,結果表格僅包含表格中已連結欄位內容相同的記錄。</ahelp>在 $[officename] SQL 中,此連結類型由對應的 WHERE 子句建立。"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2805,8 +2413,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3166450\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the left join, the results table contains all fields of the left table and only those fields of the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">透過左連結,結果表格包含左表格的所有欄位和右表格中已連結欄位內容相同的那些欄位。</ahelp>在 $[officename] SQL 中,此連結類型對應於 LEFT OUTER JOIN 指令。"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2821,8 +2429,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3150647\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the right join, the results table contains all fields of the right table and only those fields of the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">透過右連結,結果表格包含右表格的所有欄位和左表格中已連結欄位內容相同的那些欄位。</ahelp>在 $[officename] SQL 中,此連結類型對應於 RIGHT OUTER JOIN 指令。"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2837,8 +2445,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3163665\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">For a full join, the results table contains all fields of the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">對於完整連結,結果表格包含左右表格的所有欄位。</ahelp>在 $[officename] SQL 中,此連結類型對應於 FULL OUTER JOIN 指令。"
+msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2853,8 +2461,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id0305200912031977\n"
"help.text"
-msgid "<ahelp hid=\".\">Inserts the keyword NATURAL into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
-msgstr "<ahelp hid=\".\">在定義關係的 SQL 敘述中插入關鍵字 NATURAL。關係會連結兩個表格中具有相同欄的所有欄。所產生的連結表格針對每對同名欄僅會包含一個欄。</ahelp>"
+msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>"
+msgstr ""
#: 04000000.xhp
msgctxt ""
@@ -2909,8 +2517,8 @@ msgctxt ""
"04000000.xhp\n"
"par_id3156156\n"
"help.text"
-msgid "The Form Controls toolbar offers the tools required to create a form in a text, table, drawing, or presentation document."
-msgstr "[表單控制項] 工具列可提供建立文字型態之表單、表格、繪圖或簡報文件所需的工具。"
+msgid "The Form Controls toolbar provides the tools required to create a form in a text, table, drawing, or presentation document."
+msgstr ""
#: 04000000.xhp
msgctxt ""
@@ -2997,32 +2605,32 @@ msgctxt ""
"04030000.xhp\n"
"par_id3153146\n"
"help.text"
-msgid "In the form design you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>."
-msgstr "在表單設計中,您可以<link href=\"text/shared/02/01170000.xhp\" name=\"包含控制項\">包含控制項</link>、對它們<link href=\"text/shared/02/01170100.xhp\" name=\"採用屬性\">採用屬性</link>、定義<link href=\"text/shared/02/01170200.xhp\" name=\"表單屬性\">表單屬性</link>以及<link href=\"text/shared/02/01170203.xhp\" name=\"定義子表單\">定義子表單</link>。"
+msgid "In form design mode you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>."
+msgstr ""
#: 04030000.xhp
msgctxt ""
"04030000.xhp\n"
"par_id3154924\n"
"help.text"
-msgid "The<emph> Form Navigator</emph> icon <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>."
-msgstr "[表單設計] 列上的 <emph>[表單助手]</emph> 圖示 <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">圖示</alt></image> 可開啟 <link href=\"text/shared/02/01170600.xhp\" name=\"[表單助手]\"><emph>[表單助手]</emph></link>。"
+msgid "The<emph> Form Navigator</emph> icon<image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>."
+msgstr ""
#: 04030000.xhp
msgctxt ""
"04030000.xhp\n"
"par_id3153968\n"
"help.text"
-msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in editing mode."
-msgstr "<link href=\"text/shared/02/01171000.xhp\" name=\"以設計模式開啟\"><emph>[以設計模式開啟]</emph></link> 圖示 <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">圖示</alt></image> 可讓您儲存表單文件,使其永遠以編輯模式開啟。"
+msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon<image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in form design mode."
+msgstr ""
#: 04030000.xhp
msgctxt ""
"04030000.xhp\n"
"par_id3154948\n"
"help.text"
-msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>"
-msgstr "如果在將特性指定給表單包含的物件時 (例如,在將不存在的資料庫表格指定給物件) 發生錯誤,則螢幕上會出現對應的錯誤訊息。此錯誤訊息可能包含<emph>[更多]</emph> 按鈕。<ahelp hid=\"dummy\">如果您按一下 <emph>[更多]</emph>,螢幕上會出現一個對話方塊,其中顯示了有關目前問題的更多資訊。</ahelp>"
+msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click on <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>"
+msgstr ""
#: 05000000.xhp
msgctxt ""
@@ -3045,8 +2653,8 @@ msgctxt ""
"05000000.xhp\n"
"par_id3147102\n"
"help.text"
-msgid "Data sources tables allow you see your data line by line. You can make new entries and deletions."
-msgstr "資料源表格允許您逐行查看資料。您可以建立新的條目和進行刪除。"
+msgid "Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records."
+msgstr ""
#: 05000000.xhp
msgctxt ""
@@ -3101,16 +2709,16 @@ msgctxt ""
"05000001.xhp\n"
"par_id3163829\n"
"help.text"
-msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a special table within the database, select the corresponding table and open its context menu."
-msgstr "此表格容器的右鍵功能表提供適用於所有資料庫表格的各種功能。若要編輯資料庫中的特殊表格,請選取對應的表格並開啟其右鍵功能表。"
+msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu."
+msgstr ""
#: 05000001.xhp
msgctxt ""
"05000001.xhp\n"
"par_id3146958\n"
"help.text"
-msgid "Depending on the context, it is possible that not all the functions for your current database are listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases."
-msgstr "依據上下文,可能不會在右鍵功能表中列出目前資料庫的所有功能。例如,用於定義各種表格之間關係的<emph>[關係]</emph>指令,僅可用於關係資料庫。"
+msgid "Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases."
+msgstr ""
#: 05000001.xhp
msgctxt ""
@@ -3149,8 +2757,8 @@ msgctxt ""
"05000003.xhp\n"
"par_id3148520\n"
"help.text"
-msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user's name in this dialog."
-msgstr "允許您輸入和確認新的或已變更的密碼。如果您已定義了新使用者,請在此對話方塊中輸入該使用者的名稱。"
+msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog."
+msgstr ""
#: 05000003.xhp
msgctxt ""
@@ -3181,8 +2789,8 @@ msgctxt ""
"05000003.xhp\n"
"par_id3147576\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password.</ahelp> This field is visible when you have started the dialog via <emph>Change password</emph>."
-msgstr "<ahelp hid=\"dbaccess/ui/password/oldpassword\">輸入舊密碼。</ahelp>當您透過<emph>[變更密碼]</emph> 啟動此對話方塊時,可看到此欄位。"
+msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password here.</ahelp> This field is visible when you have opened the dialog via <emph>Change password</emph>."
+msgstr ""
#: 05000003.xhp
msgctxt ""
@@ -3237,8 +2845,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3152363\n"
"help.text"
-msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of a table."
-msgstr "在<emph>「表格設計」</emph>視窗中定義新的表格或編輯表格的結構。"
+msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table."
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3277,8 +2885,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3156113\n"
"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. Note the database restrictions, such as the length of the name, special characters and spaces.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">指定資料欄位的名稱。注意資料庫的限制,比如名稱長度、特殊字元及空格。</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp>"
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3293,8 +2901,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3154897\n"
"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">指定欄位類型。</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type. The available field types are limited by the database engine being used.</ahelp>"
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3309,8 +2917,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3145315\n"
"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">指定可選擇的描述。</ahelp>"
+msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>"
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3397,8 +3005,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3149456\n"
"help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has been saved.</ahelp>"
-msgstr "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">若該表格尚未儲存,請在目列的列上插入一空列。若該表格已儲存,則請在表格結尾插入空列。</ahelp>"
+msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp>"
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3413,8 +3021,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3150398\n"
"help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field in this line is a primary key.</ahelp> By clicking the command you activate/deactivate the status. The command is only visible if the data source supports primary keys."
-msgstr "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">如果此指令有一個核取標記,則在此行中的資料欄位為主關鍵字。</ahelp> 按一下指令可在啟動/關閉狀態間切換。僅當資料源支援主關鍵字時,才顯示此指令。"
+msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys."
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3445,8 +3053,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3144761\n"
"help.text"
-msgid "Specifies the length of the data field."
-msgstr "輸入資料欄位的長度。"
+msgid "Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters."
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3493,8 +3101,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3155131\n"
"help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code that you can select with the<emph> ... </emph>button.</ahelp>"
-msgstr "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">顯示可用 <emph>[...]</emph> 按鈕選取的格式碼。</ahelp>"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp>"
+msgstr ""
#: 05010000.xhp
msgctxt ""
@@ -3525,8 +3133,8 @@ msgctxt ""
"05010000.xhp\n"
"par_id3150685\n"
"help.text"
-msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays help texts.</ahelp>"
-msgstr "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">顯示說明文字。</ahelp>"
+msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays a help string or hint defined by the database designer for the given field.</ahelp>"
+msgstr ""
#: 05010100.xhp
msgctxt ""
@@ -3549,8 +3157,8 @@ msgctxt ""
"05010100.xhp\n"
"par_id3166460\n"
"help.text"
-msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you edit the indexes for the current table.</ahelp>"
-msgstr "<ahelp hid=\".uno:DBIndexDesign\"><emph>[索引設計]</emph> 對話方塊可讓您編輯目前表格的索引。</ahelp>"
+msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp>"
+msgstr ""
#: 05010100.xhp
msgctxt ""
@@ -3565,8 +3173,8 @@ msgctxt ""
"05010100.xhp\n"
"par_id3155342\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays the available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">顯示可用的索引。從清單中選取要編輯的索引。對話方塊中會顯示所選索引的詳細資訊。</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
+msgstr ""
#: 05010100.xhp
msgctxt ""
@@ -3661,8 +3269,8 @@ msgctxt ""
"05010100.xhp\n"
"par_id3154938\n"
"help.text"
-msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
-msgstr "一旦在變更目前索引的詳細資訊後再選取其他索引,便會立即將變更傳送至資料來源。如果資料來源已成功確認此變更,則只能離開對話方塊或選取其他索引。但是,可以按一下 <emph>[重設目前的索引] </emph>圖示以復原變更。"
+msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
+msgstr ""
#: 05010100.xhp
msgctxt ""
@@ -3725,8 +3333,8 @@ msgctxt ""
"05010100.xhp\n"
"par_id3149561\n"
"help.text"
-msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order.</ahelp>"
-msgstr "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">決定排序順序。</ahelp>"
+msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>"
+msgstr ""
#: 05010100.xhp
msgctxt ""
@@ -3797,8 +3405,8 @@ msgctxt ""
"05020000.xhp\n"
"par_id3149235\n"
"help.text"
-msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables that you want."
-msgstr "當您選擇了 <emph>[工具] – [關係]</emph> 時,就會開啟一個視窗,其中會顯示目前資料庫各表格之間所有現有的關係。如果尚未定義關係,或您要建立資料庫其他表格之間的相互關係,請按一下 <emph>[新增表格]</emph> 圖示。此時會開啟 <link href=\"text/shared/02/14020100.xhp\" name=\"新增表格\">[新增表格]</link> 對話方塊,在此您可以選取需要的表格。"
+msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click on the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables with which to create a relation."
+msgstr ""
#: 05020000.xhp
msgctxt ""
@@ -3813,8 +3421,8 @@ msgctxt ""
"05020000.xhp\n"
"par_id3150541\n"
"help.text"
-msgid "The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key."
-msgstr "所選取的表格會在設計檢視的上方區域顯示。您可以透過右鍵功能表或利用 (Delete) 鍵再移除表格視窗。"
+msgid "The selected tables are shown in the top area of the relation design view. You can close a table window through the context menu or with the Delete key."
+msgstr ""
#: 05020000.xhp
msgctxt ""
@@ -3829,16 +3437,16 @@ msgctxt ""
"05020000.xhp\n"
"hd_id3148922\n"
"help.text"
-msgid "Primary key and other key"
-msgstr "主關鍵字和其他關鍵字"
+msgid "Primary key and foreign keys"
+msgstr ""
#: 05020000.xhp
msgctxt ""
"05020000.xhp\n"
"par_id3149168\n"
"help.text"
-msgid "If you want to define a relation among the different tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key."
-msgstr "如果要在不同的表格間定義關係,您應當輸入可清楚識別現有表格之資料欄位的<link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"主關鍵字\">主關鍵字</link>。您可以從其他表格參照主關鍵字來存取此表格的資料。參照此主關鍵字的所有資料欄位將被識別為外部關鍵字。"
+msgid "If you want to define a relation among the various tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that uniquely identifies a data field of an existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as a foreign key."
+msgstr ""
#: 05020000.xhp
msgctxt ""
@@ -3869,8 +3477,8 @@ msgctxt ""
"05020000.xhp\n"
"par_id3155430\n"
"help.text"
-msgid "All existing relations are shown in the relations windows by a line that connects the primary and other key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key."
-msgstr "所有現有的關係都透過連結主關鍵字欄位和其他關鍵字欄位的線條顯示在關係視窗中。您可以使用拖放,將一個表格的欄位拖曳到其他表格的欄位上,從而加入關係。選取關係並按 DEL 鍵,可再次移除此關係。"
+msgid "All existing relations are shown in the relations windows by a line that connects the primary and foreign key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key."
+msgstr ""
#: 05020000.xhp
msgctxt ""
@@ -3885,8 +3493,8 @@ msgctxt ""
"05020000.xhp\n"
"par_id3153093\n"
"help.text"
-msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the external database."
-msgstr "如果使用 $[officename] 作為關係資料庫的前端,則 $[officename] 不會將建立和刪除的關係放在中間記憶體中,而是直接放到外部資料庫中。"
+msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the database."
+msgstr ""
#: 05020000.xhp
msgctxt ""
@@ -11016,6 +10624,158 @@ msgctxt ""
msgid "You can click the date or time field and drag to another position within the same area, or edit the properties in the Properties window."
msgstr "您可以按一下日期或時間欄位,並拖向相同區域內的其他位置,或編輯 [特性] 視窗中的特性。"
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"tit\n"
+"help.text"
+msgid "Insert Fields"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"bm_id61540566967968\n"
+"help.text"
+msgid "<bookmark_value>insert fields;in report design</bookmark_value> <bookmark_value>add fields;in report design</bookmark_value> <bookmark_value>report design;add fields to report</bookmark_value>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"hd_id361540562942432\n"
+"help.text"
+msgid "<variable id=\"addfields\"><link href=\"text/shared/explorer/database/rep_insertfield.xhp\" name=\"Add Fields\">Add fields to report</link></variable>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3587145\n"
+"help.text"
+msgid "<ahelp hid=\".\">The Add Field window helps you to insert the table entries in the report.</ahelp>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id4503921\n"
+"help.text"
+msgid "The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id171540674707522\n"
+"help.text"
+msgid "Choose <item type=\"menuitem\">View - Add Field</item>."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id991540674901837\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/lc_addfield.svg\" id=\"img_id621540674901837\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id491540674901837\">Add field icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id121540674874655\n"
+"help.text"
+msgid "Click the Add Field icon on the toolbar."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id141540563922693\n"
+"help.text"
+msgid "Select the field in the Add Field dialog and click <emph>Insert</emph>. You can select multiples fields pressing the <switchinline select=\"sys\"> <caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline> </switchinline> key while clicking on the fields name or using the Shift key while pressing the mouse button. Click <emph>Insert</emph> in the toolbar to add the fields to the report."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id4051026\n"
+"help.text"
+msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3397320\n"
+"help.text"
+msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id3059785\n"
+"help.text"
+msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon <image id=\"img_id5605334\" src=\"media/icon-themes/cmd/lc_addfield.svg\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"hd_id251540563929787\n"
+"help.text"
+msgid "Sorting fields names"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id651540564204840\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/sc_sortascending.svg\" id=\"img_id631540564204841\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id141540564204841\">Sort Ascending icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540563992665\n"
+"help.text"
+msgid "Sort names ascending."
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id811540564184191\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/sc_sortdescending.svg\" id=\"img_id391540564184192\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id571540564184192\">Sort descending icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540563942665\n"
+"help.text"
+msgid "Sort names descending,"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id851540564212907\n"
+"help.text"
+msgid "<image src=\"media/icon-themes/cmd/lc_removefiltersort.svg\" id=\"img_id41540564212907\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id421540564212908\">Undo sorting icon</alt></image>"
+msgstr ""
+
+#: rep_insertfield.xhp
+msgctxt ""
+"rep_insertfield.xhp\n"
+"par_id401540533942665\n"
+"help.text"
+msgid "Restore original sorting"
+msgstr ""
+
#: rep_main.xhp
msgctxt ""
"rep_main.xhp\n"
@@ -11277,48 +11037,8 @@ msgctxt ""
"rep_main.xhp\n"
"par_id2531815\n"
"help.text"
-msgid "The Add Field window opens automatically and shows all fields of the selected table."
-msgstr "[增加欄位] 視窗會自動開啟,並顯示選取表格的所有欄位。"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id5927304\n"
-"help.text"
-msgid "To insert fields into the report"
-msgstr "將欄位插入報表"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id4503921\n"
-"help.text"
-msgid "The Add Field window helps you to insert the table entries in the report. Click the Add Field icon in the toolbar to open the Add Field window."
-msgstr "[增加欄位] 視窗可協助您將表格項目插入報表。按一下工具列中的 [增加欄位] 圖示以開啟 [增加欄位] 視窗。"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id4051026\n"
-"help.text"
-msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields."
-msgstr "從 [增加欄位] 視窗逐一拖放欄位名稱到報表的 [細節] 區域。視需要調整欄位位置。使用工具列中的圖示對齊欄位。"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id3397320\n"
-"help.text"
-msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted."
-msgstr "您無法重疊欄位。如果您在 [細節] 區域中放入表格欄位,則會插入標籤與文字方塊。"
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id3059785\n"
-"help.text"
-msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon<image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want."
-msgstr "您也可以插入在報表每一頁皆應相同的文字。按一下 [標籤欄位] 圖示 <image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">圖示</alt></image>,然後在 [頁首] 或 [頁尾] 區域中拖曳出一個矩形。編輯 [標籤] 特性即可顯示所需的文字。"
+msgid "The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/> window opens automatically and shows all fields of the selected table."
+msgstr ""
#: rep_main.xhp
msgctxt ""
@@ -12029,8 +11749,8 @@ msgctxt ""
"rep_prop.xhp\n"
"par_id3587145\n"
"help.text"
-msgid "<ahelp hid=\".\">The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>"
-msgstr "<ahelp hid=\".\">在 [內容] 方塊中選取一個表格並離開該方塊後,會自動顯示 [增加欄位] 視窗。您也可以按一下工具列上的 [增加欄位] 圖示,或選擇 <item type=\"menuitem\">[檢視] - [增加欄位]</item>。</ahelp>"
+msgid "<ahelp hid=\".\">The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/> window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>"
+msgstr ""
#: rep_prop.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/shared/guide.po b/source/zh-TW/helpcontent2/source/text/shared/guide.po
index c6d87042524..4ed52926e31 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/guide.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/guide.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: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-02-05 12:05+0000\n"
"Last-Translator: marklh9 <marklh9@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -19253,7 +19253,7 @@ msgctxt ""
"version_number.xhp\n"
"par_id3147008\n"
"help.text"
-msgid "<link href=\"http://www.libreoffice.org/about-us/credits/\">See lists of code and Wiki contributors</link> on the LibreOffice website."
+msgid "<link href=\"https://www.libreoffice.org/about-us/credits/\">See lists of code and Wiki contributors</link> on the LibreOffice website."
msgstr ""
#: viewing_file_properties.xhp
@@ -19709,8 +19709,8 @@ msgctxt ""
"xsltfilter_create.xhp\n"
"bm_id7007583\n"
"help.text"
-msgid "<bookmark_value>testing XML filters</bookmark_value><bookmark_value>XML filters;creating/testing</bookmark_value>"
-msgstr "<bookmark_value>測試 XML 篩選器</bookmark_value><bookmark_value>XML 篩選器; 建立/測試</bookmark_value>"
+msgid "<bookmark_value>testing XML filters</bookmark_value><bookmark_value>XML filters; creating/testing</bookmark_value>"
+msgstr ""
#: xsltfilter_create.xhp
msgctxt ""
@@ -19741,8 +19741,8 @@ msgctxt ""
"xsltfilter_create.xhp\n"
"par_idN109B0\n"
"help.text"
-msgid "For more information about the OpenDocument XML format, go to <link href=\"http://xml.openoffice.org/\">http://xml.openoffice.org/</link>."
-msgstr "如需有關 Open Office XML 格式的詳細資訊,請轉至以下網站:<link href=\"http://xml.openoffice.org/\">http://xml.openoffice.org/</link>。"
+msgid "For more information about the OpenDocument XML format, go to <link href=\"https://www.openoffice.org/xml/\">https://www.openoffice.org/xml/</link>."
+msgstr ""
#: xsltfilter_create.xhp
msgctxt ""
@@ -19973,8 +19973,8 @@ msgctxt ""
"xsltfilter_create.xhp\n"
"par_idN10A82\n"
"help.text"
-msgid "To test an <emph>Export</emph> Filter, do one of the following in the <emph>Export</emph> area of the dialog:"
-msgstr "若要測試 <emph>[匯出]</emph> 篩選器,請在對話方塊的 <emph>[匯出]</emph> 區塊中執行下列任一動作:"
+msgid "To test an <emph>Export</emph> filter, do one of the following in the <emph>Export</emph> area of the dialog:"
+msgstr ""
#: xsltfilter_create.xhp
msgctxt ""
@@ -19997,8 +19997,8 @@ msgctxt ""
"xsltfilter_create.xhp\n"
"par_idN10A99\n"
"help.text"
-msgid "To test an <emph>Import</emph> Filter, click <emph>Browse</emph> in the <emph>Import</emph> area of the dialog, select a document, and click <emph>Open</emph>."
-msgstr "若要測試一個<emph>匯入</emph>篩選器,請按一下對話方塊的 <emph>[匯入]</emph> 區塊中的 <emph>[瀏覽]</emph>,選取一個文件,然後按一下 <emph>[開啟舊檔]</emph>。"
+msgid "To test an <emph>Import</emph> filter, click <emph>Browse</emph> in the <emph>Import</emph> area of the dialog, select a document, and click <emph>Open</emph>."
+msgstr ""
#: xsltfilter_create.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/shared/help.po b/source/zh-TW/helpcontent2/source/text/shared/help.po
index f9e38601e47..05cb3c26e39 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/help.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/help.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: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -50,7 +50,7 @@ msgctxt ""
"browserhelp.xhp\n"
"par_id601525734140935\n"
"help.text"
-msgid "<variable id=\"index\">Index</variable>"
+msgid "<variable id=\"index\">Index of chosen module</variable>"
msgstr ""
#: browserhelp.xhp
diff --git a/source/zh-TW/helpcontent2/source/text/shared/optionen.po b/source/zh-TW/helpcontent2/source/text/shared/optionen.po
index 4d06a790dfe..3a512172269 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/optionen.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/optionen.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: 2018-10-02 17:56+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-01-25 15:18+0000\n"
"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7499,6 +7499,14 @@ msgstr ""
#: 01041100.xhp
msgctxt ""
"01041100.xhp\n"
+"hd_id661541680699404\n"
+"help.text"
+msgid "Separator"
+msgstr ""
+
+#: 01041100.xhp
+msgctxt ""
+"01041100.xhp\n"
"par_id3153524\n"
"help.text"
msgid "<ahelp hid=\"modules/swriter/ui/optcaptionpage/chapseparator\">Defines the character to be displayed after the number of the heading or chapter level.</ahelp>"
@@ -7525,8 +7533,8 @@ msgctxt ""
"01041100.xhp\n"
"par_idN106B4\n"
"help.text"
-msgid "<ahelp hid=\".\">Specifies the character style.</ahelp>"
-msgstr "<ahelp hid=\".\">指定字元樣式。</ahelp>"
+msgid "<ahelp hid=\".\">Specifies the character style of the caption paragraph.</ahelp>"
+msgstr ""
#: 01041100.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/smath.po b/source/zh-TW/helpcontent2/source/text/smath.po
index 7f7d6ec9687..754f22b4763 100644
--- a/source/zh-TW/helpcontent2/source/text/smath.po
+++ b/source/zh-TW/helpcontent2/source/text/smath.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: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2016-12-09 01:55+0000\n"
"Last-Translator: wck317 <wck317@pchome.com.tw>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -61,8 +61,8 @@ msgctxt ""
"main0000.xhp\n"
"par_id3143269\n"
"help.text"
-msgid "Have a look at <link href=\"http://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
-msgstr "如需其他 %PRODUCTNAME Math 圖示集和巨集,請造訪 <link href=\"http://www.dmaths.org\">www.dmaths.org</link>。"
+msgid "Have a look at <link href=\"https://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
+msgstr ""
#: main0100.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/smath/01.po b/source/zh-TW/helpcontent2/source/text/smath/01.po
index 6030240cb0b..8772e6b20d1 100644
--- a/source/zh-TW/helpcontent2/source/text/smath/01.po
+++ b/source/zh-TW/helpcontent2/source/text/smath/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: 2018-07-31 14:10+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-01-22 14:38+0000\n"
"Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12365,15 +12365,15 @@ msgctxt ""
"06020000.xhp\n"
"par_id3153916\n"
"help.text"
-msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
-msgstr "<emph>[插入]</emph>對話方塊的設定與<emph>[檔案]</emph>下的<link href=\"text/shared/01/01020000.xhp\" name=\"[開啟舊檔]\">[開啟舊檔]</link>對話方塊的設定相同。使用<emph>[插入]</emph>對話方塊,載入、編輯和顯示<emph>[指令]</emph>視窗中已儲存為檔案的公式。"
+msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\"><emph>Open</emph></link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
+msgstr ""
#: 06020000.xhp
msgctxt ""
"06020000.xhp\n"
"par_id3153917\n"
"help.text"
-msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"http://www.w3.org/TR/#tr_MathML\">specification</link>."
+msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"https://www.w3.org/TR/#tr_MathML\">specification</link>."
msgstr ""
#: 06020000.xhp
@@ -12421,5 +12421,5 @@ msgctxt ""
"06020000.xhp\n"
"par_id3153919\n"
"help.text"
-msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">Paste</link> under <emph>Edit</emph>."
+msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\"><emph>Paste</emph></link> under <emph>Edit</emph>."
msgstr ""
diff --git a/source/zh-TW/helpcontent2/source/text/swriter/guide.po b/source/zh-TW/helpcontent2/source/text/swriter/guide.po
index 9d005de8e6d..16b6616417a 100644
--- a/source/zh-TW/helpcontent2/source/text/swriter/guide.po
+++ b/source/zh-TW/helpcontent2/source/text/swriter/guide.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: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
"PO-Revision-Date: 2018-02-05 11:44+0000\n"
"Last-Translator: marklh9 <marklh9@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7549,8 +7549,8 @@ msgctxt ""
"indices_literature.xhp\n"
"par_id3155900\n"
"help.text"
-msgid "Choose <emph>Insert - Record</emph>."
-msgstr "選擇<emph>[插入] - [資料條目]</emph>。"
+msgid "Choose <emph>Data - Record</emph>."
+msgstr ""
#: indices_literature.xhp
msgctxt ""
@@ -10933,8 +10933,8 @@ msgctxt ""
"print_preview.xhp\n"
"par_id3149847\n"
"help.text"
-msgid "Choose <emph>File</emph> - <emph>Print Preview</emph>."
-msgstr "從 <emph>[檔案]</emph> 功能表中選取 <emph>[列印預覽]</emph> 指令。"
+msgid "Choose <emph>File - Print Preview</emph>."
+msgstr ""
#: print_preview.xhp
msgctxt ""