aboutsummaryrefslogtreecommitdiff
path: root/source/ko/helpcontent2
diff options
context:
space:
mode:
Diffstat (limited to 'source/ko/helpcontent2')
-rw-r--r--source/ko/helpcontent2/source/text/scalc/01.po122
-rw-r--r--source/ko/helpcontent2/source/text/shared/01.po136
-rw-r--r--source/ko/helpcontent2/source/text/shared/02.po10
-rw-r--r--source/ko/helpcontent2/source/text/shared/explorer/database.po998
-rw-r--r--source/ko/helpcontent2/source/text/shared/guide.po20
-rw-r--r--source/ko/helpcontent2/source/text/shared/help.po4
-rw-r--r--source/ko/helpcontent2/source/text/shared/optionen.po14
-rw-r--r--source/ko/helpcontent2/source/text/smath.po6
-rw-r--r--source/ko/helpcontent2/source/text/smath/01.po14
-rw-r--r--source/ko/helpcontent2/source/text/swriter/guide.po8
10 files changed, 582 insertions, 750 deletions
diff --git a/source/ko/helpcontent2/source/text/scalc/01.po b/source/ko/helpcontent2/source/text/scalc/01.po
index 9b5d6c3a3aa..9b35dc52ff9 100644
--- a/source/ko/helpcontent2/source/text/scalc/01.po
+++ b/source/ko/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-04-12 04:09+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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 키를 입력하십시오. 그러면 예전 배열의 값에 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 "배열 수식을 셀에 직접 입력하는 경우 Enter 키 대신 Shift + <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + 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 "배열 상수값을 넣으려면, 행의 3개 셀을 선택합니다. 그리고 중괄호와 세미콜론을 사용하여 수식 <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> 이 함수는 클래스 배열에서 지정된 값의 범위 내에 있는 데이터 배열의 값 수를 계산합니다."
+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 는 통계 표(배열)을 반환하고 반드시 배열 수식으로써 입력되어야 합니다.(예를 들어, Enter 키가 아닌 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + Shift + Enter 를 사용함)"
+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(배열1; 배열2...배열30)"
+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>배열, 배열2...배열30</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이면 선은 영점을 통과하도록 계산될 것입니다. 0이 아닐 경우 영점을 통과하지 않도록 계산됩니다. 기본적으로 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>함수형</emph>은 선택입력사항입니다. 만일 함수형이 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 "이 함수는 배열을 반환하며, 다른 배열 함수를 취급하는 것과 같은 방식으로 다루면 됩니다. 답을 출력하기 위한 범위를 정하고 함수를 선택합니다. 원한다면 데이터Y를 택하고 기타 파라미터를 입력합니다. <emph>배열</emph>을 선택한 후 <emph>OK</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>상한값</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/ko/helpcontent2/source/text/shared/01.po b/source/ko/helpcontent2/source/text/shared/01.po
index 8ef7c874c71..0e83e188510 100644
--- a/source/ko/helpcontent2/source/text/shared/01.po
+++ b/source/ko/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-09-29 16:00+0000\n"
"Last-Translator: DaeHyun Sung(성대현, 成大鉉) <sungdh86@gmail.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>를 선택하여 미디어 플레이어를 열 수 있습니다. 지원되는 모든 미디어 파일을 미리 보려면 미디어 플레이어를 사용하십시오. 현재 미디어 파일을 문서에 삽입하려면 미디어 플레이어 창에서 적용 버튼을 클릭합니다."
+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/ko/helpcontent2/source/text/shared/02.po b/source/ko/helpcontent2/source/text/shared/02.po
index c27541af562..e663d68fde3 100644
--- a/source/ko/helpcontent2/source/text/shared/02.po
+++ b/source/ko/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-04-12 04:10+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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/ko/helpcontent2/source/text/shared/explorer/database.po b/source/ko/helpcontent2/source/text/shared/explorer/database.po
index 65ab49e42cf..b81bc9aaaf3 100644
--- a/source/ko/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/ko/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-04-19 05:50+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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\">Command</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> 마우스를 눌러 셀을 활성화하면 필드를 선택할 수 있는 화살표 버튼이 표시됩니다. \"테이블 이름.*\" 옵션은 모든 데이터 필드를 선택하며 모든 테이블 필드에서 기준이 유효합니다."
+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 "옵션"
#: 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): 데이터 필드를 인수로 이용할 경우 각 데이터 필드에 하나의 값이 포함되는 필드만 계산됩니다. 이 때 0 값(비어 있는 필드)은 포함되지 않습니다."
+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> 기능을 제외한 위의 기능은 소위 총계 기능이라고 합니다. 이것은 계산을 통하여 데이터를 결과로 통합하는 기능입니다. 목록 필드에 열거되지 않은 다른 기능도 사용할 수 있습니다. 이 기능은 사용자가 사용하는 특수 데이터베이스 시스템에 따라 좌우됩니다. 드라이버 특유의 기능에 대한 정보를 얻으려면 사용자 데이터베이스 시스템의 문서를 보십시오."
+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,16 +1421,16 @@ 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>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">쿼리 결과값의 레코드 수를 최대로 설정할 수 있습니다.</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
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>Limit</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 "...의 경우 조건이 충족됩니다"
#: 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 "연산자 = 는 쿼리 필드에 표시되지 않습니다. 연산자없이 값을 입력하면 자동으로 연산자 = 이 적용됩니다."
-
-#: 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 "...의 경우 조건이 충족됩니다"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3154275\n"
-"help.text"
-msgid "IS EMPTY"
-msgstr "IS BLANK"
-
-#: 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,24 +1621,8 @@ 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)."
-msgstr "... 데이터 필드가 비어 있습니다. 세 개의 상태가 있는 [예/아니요] 필드의 경우, 이 명령어는 불특정한 상태를 확인합니다 (예도 아니고 아니요도 아님)."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146940\n"
-"help.text"
-msgid "IS NOT EMPTY"
-msgstr "IS NOT EMPTY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3147471\n"
-"help.text"
-msgid "IS NOT NULL"
-msgstr "IS NOT NULL"
+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 ""
@@ -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 "='여성'"
-
-#: 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 "\"여성\"이라는 필드 내용이 있는 데이터 필드를 제공
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id315379A\n"
-"help.text"
-msgid "<'2001-01-10'"
-msgstr "<'2001-01-10'"
-
-#: 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 "2001년 1월 10일 이전 날짜를 구합니다."
#: 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 ('뮐러')"
+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 "\"뮐러\"를 포함하지 않는 데이터 필드를 제공합니다."
+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 "{D'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 "{t 'HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559474\n"
-"help.text"
-msgid "'HH:MI:SS[.SS]'"
-msgstr "'HH:MI:SS[.SS]'"
-
-#: 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 "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509644\n"
-"help.text"
-msgid "'YYYY-MM-DD HH:MI:SS[.SS]'"
-msgstr "'YYYY-MM-DD HH:MI:SS[.SS]'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3149539\n"
"help.text"
msgid "Example: select {d '1999-12-31'} from world.years"
@@ -2429,8 +2037,8 @@ 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.)"
-msgstr "모든 날짜 표현(문자)는 반드시 따옴표로 감싸야 합니다.(특정 데이터베이스나 사용중인 커넥터에 관한 더 자세한 내용은 관련 문서를 참조하십시오.)"
+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
msgctxt ""
@@ -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 구문으로 자동 변환합니다. <emph>디자인 보기 적용/해제</emph> 버튼을 사용하면 SQL 보기로 변경하여 이전에 만든 쿼리에 대한 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 코드를 직접 손으로 입력할 경우 <emph>쿼리 초안</emph>의 그래픽 인터페이스가 지원하지 않는 SQL 특유의 쿼리를 만들 수 있습니다. 이 쿼리는 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=\".\">키워드 NATURAL을 관계 정의 SQL 문에 삽입합니다. 관계는 두 테이블에서 열 이름이 동일한 모든 열을 연결합니다. 연결된 결과 테이블에는 이름이 같은 열의 각 쌍에 해당하는 열이 한 개만 포함됩니다.</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 "기본 키 필드와 다른 키 필드를 연결하는 선에 의해 모든 기존 관계가 관계 창에 표시됩니다. 한 테이블의 필드를 끌어서 다른 테이블 필드에 놓는 방식으로, 끌어서 놓기를 사용하여 관계를 추가할 수 있습니다. 관계를 선택하고 Delete 키를 삭제하면 관계가 다시 제거됩니다."
+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/ko/helpcontent2/source/text/shared/guide.po b/source/ko/helpcontent2/source/text/shared/guide.po
index d65d0019677..81e703c4e11 100644
--- a/source/ko/helpcontent2/source/text/shared/guide.po
+++ b/source/ko/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-04-12 04:10+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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 "OpenDocument 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/ko/helpcontent2/source/text/shared/help.po b/source/ko/helpcontent2/source/text/shared/help.po
index f9e38601e47..05cb3c26e39 100644
--- a/source/ko/helpcontent2/source/text/shared/help.po
+++ b/source/ko/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/ko/helpcontent2/source/text/shared/optionen.po b/source/ko/helpcontent2/source/text/shared/optionen.po
index e02f8b8dac3..9208e7e244d 100644
--- a/source/ko/helpcontent2/source/text/shared/optionen.po
+++ b/source/ko/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-04-20 04:14+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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/ko/helpcontent2/source/text/smath.po b/source/ko/helpcontent2/source/text/smath.po
index 53c313a298e..798293f94f3 100644
--- a/source/ko/helpcontent2/source/text/smath.po
+++ b/source/ko/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: 2018-04-11 14:37+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@gmail.com>\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 "<link href=\"http://www.dmaths.org\">www.dmaths.org</link>를 살펴 보면 추가적인 %PRODUCTNAME 수식 편집기 아이콘과 매크로를 확인할 수 있습니다."
+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/ko/helpcontent2/source/text/smath/01.po b/source/ko/helpcontent2/source/text/smath/01.po
index 41bf35db266..8c27072fd2d 100644
--- a/source/ko/helpcontent2/source/text/smath/01.po
+++ b/source/ko/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-04-18 01:54+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12365,16 +12365,16 @@ 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>."
-msgstr "다른 프로그램에서 만든 MathML 파일을 가져올 수 있습니다. MathML 소스에는 <item type=\"code\">xmlns</item> 속성이 포함된 <item type=\"code\">math</item> 요소가 있어야 합니다. 그리고 해당 속성의 값은 \"http://www.w3.org/1998/Math/MathML\" 이어야 합니다. MathML 언어와 StarMath은 완벽하게 호환되지는 않습니다. 따라서 가져온 결과를 일부 수정해야 할 수도 있습니다. MathML 언어에 대한 더 자세한 내용은 <link href=\"http://www.w3.org/TR/#tr_MathML\">사양</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
msgctxt ""
@@ -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>."
-msgstr "이 명령은 MathML 내용만 처리합니다. %PRODUCTNAME Math 수식을 클립보드로 복사한 경우에는 '<emph>편집</emph> - <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">붙여넣기</link>' 메뉴를 사용하여 삽입하십시오."
+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/ko/helpcontent2/source/text/swriter/guide.po b/source/ko/helpcontent2/source/text/swriter/guide.po
index 6f198af1488..d44d67342d0 100644
--- a/source/ko/helpcontent2/source/text/swriter/guide.po
+++ b/source/ko/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-04-17 13:30+0000\n"
"Last-Translator: Jihui Choi <jihui.choi@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,7 +10933,7 @@ msgctxt ""
"print_preview.xhp\n"
"par_id3149847\n"
"help.text"
-msgid "Choose <emph>File</emph> - <emph>Print Preview</emph>."
+msgid "Choose <emph>File - Print Preview</emph>."
msgstr ""
#: print_preview.xhp