update translations for master

and force-fix errors using pocheck Change-Id: I6b444d20d156df4126666efaeb30a0902054362b
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2018-11-12 23:58:17 +0100
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2018-11-13 00:04:09 +0100
commit: dee42a39ff84aae292b56cf83137983da5c28975 (patch)
tree: d60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/ru/helpcontent2
parent: f14221545cf5a1be2c6f74915bcaff29db79a85d (diff)
10 files changed, 579 insertions, 747 deletions
diff --git a/source/ru/helpcontent2/source/text/scalc/01.po b/source/ru/helpcontent2/source/text/scalc/01.po
index 87926d6bf68..7dbc933790e 100644
--- a/source/ru/helpcontent2/source/text/scalc/01.po
+++ b/source/ru/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: 01\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: 2017-11-03 08:38+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\n"
 "Language-Team: Russian <l10n@ru.libreoffice.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+ВВОД. В результате все значения ячеек в массиве 3 x 3 (A1:C3) будут умножены на 10."
+msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14181,8 +14181,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3153392\n"
 "help.text"
-msgid "If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula."
-msgstr "Если вводить формулу массива напрямую в ячейку, вместо клавиши ВВОД необходимо воспользоваться комбинацией клавиш SHIFT+<switchinline select=\"sys\"><caseinline select=\"MAC\">COMMAND</caseinline><defaultinline>CTRL</defaultinline></switchinline>+ВВОД. Только после этого формула станет формулой массива."
+msgid "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -14269,8 +14269,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id6757103\n"
 "help.text"
-msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
-msgstr "Для ввода этого массива из констант необходимо выбрать три ячейки в строке, затем ввести формулу <item type=\"input\">={1;2;3}</item> с фигурными скобками и точками с запятой, а затем нажать <switchinline select=\"sys\"><caseinline select=\"MAC\">COMMAND</caseinline><defaultinline>CTRL</defaultinline></switchinline>+SHIFT+ВВОД."
+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,24 +14333,24 @@ 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."
-msgstr "Выберите диапазон или массив ячеек с формулой массива. Чтобы выбрать весь массив, расположите курсор в пределах массива, а затем нажмите <switchinline select=\"sys\"><caseinline select=\"MAC\">COMMAND</caseinline><defaultinline>CTRL</defaultinline></switchinline>+ /, где / означает клавишу деления на цифровой клавиатуре."
+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
 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+ВВОД."
+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+ВВОД. Выбранный диапазон теперь содержит формулу массива."
+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,8 +14453,8 @@ 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."
-msgstr "Можно создать копию формулы массива в данном диапазоне, удерживая клавишу <switchinline select=\"sys\"><caseinline select=\"MAC\">COMMAND</caseinline><defaultinline>CTRL</defaultinline></switchinline>."
+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
 msgctxt ""
@@ -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+ВВОД</caseinline><defaultinline>SHIFT+CTRL+ВВОД</defaultinline></switchinline>. Или, если используется <emph>Мастер функций</emph>, установите флажок <emph>Массив</emph>. Транспонированный массив появится в выбранном целевом диапазоне и будет автоматически защищён от внесения изменений."
+msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes."
+msgstr ""
 
 #: 04060107.xhp
 msgctxt ""
@@ -15461,7 +15461,7 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id3178518\n"
 "help.text"
-msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift+Command+Enter</emph></caseinline><defaultinline><emph>Shift+Ctrl+Enter</emph></defaultinline></switchinline>. The result will be as follows:"
+msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:"
 msgstr ""
 
 #: 04060107.xhp
@@ -15541,8 +15541,8 @@ msgctxt ""
 "04060107.xhp\n"
 "par_id0811200804502261\n"
 "help.text"
-msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return)."
-msgstr "LINEST возвращает таблицу (массив) статистических данных, как показано ниже, и должна быть введена в виде формулы массива (например, при помощи комбинации клавиш <switchinline select=\"sys\"><caseinline select=\"MAC\">COMMAND</caseinline><defaultinline>CTRL</defaultinline></switchinline>+SHIFT+ВВОД вместо одной клавиши ВВОД)."
+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>Массив1, Массив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>Тип линии</emph>(необязательно). Если тип линии = 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>ОК</emph>."
+msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
+msgstr ""
 
 #: 04060108.xhp
 msgctxt ""
@@ -24325,8 +24325,8 @@ msgctxt ""
 "04060115.xhp\n"
 "par_id3156294\n"
 "help.text"
-msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit."
-msgstr "<emph>UpperLimit</emph> - дополнительный параметр. Это верхний предел интеграла. Если значение не указано, расчёт выполняется для диапазона от 0 до нижнего предела."
+msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes place between 0 and the lower limit."
+msgstr ""
 
 #: 04060115.xhp
 msgctxt ""
@@ -24373,8 +24373,8 @@ 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."
-msgstr "<emph>Нижний предел</emph> - предел интеграла. Вычисление происходит между 0 и этим пределом."
+msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit."
+msgstr ""
 
 #: 04060115.xhp
 msgctxt ""
@@ -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/ru/helpcontent2/source/text/shared/01.po b/source/ru/helpcontent2/source/text/shared/01.po
index acfeafa5d19..560ac7f1d78 100644
--- a/source/ru/helpcontent2/source/text/shared/01.po
+++ b/source/ru/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: 01\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-21 20:57+0200\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
 "PO-Revision-Date: 2018-02-09 16:01+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\n"
 "Language-Team: Russian <l10n@ru.libreoffice.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/ru/helpcontent2/source/text/shared/02.po b/source/ru/helpcontent2/source/text/shared/02.po
index b9b0ece603b..1760dc5205a 100644
--- a/source/ru/helpcontent2/source/text/shared/02.po
+++ b/source/ru/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: 2016-10-08 09:09+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\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/ru/helpcontent2/source/text/shared/explorer/database.po b/source/ru/helpcontent2/source/text/shared/explorer/database.po
index f7be8dbeb70..0cd84ff9a47 100644
--- a/source/ru/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/ru/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: 2016-10-08 09:10+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\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 "Чтобы задать тип ссылки в диалоговом окне <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Связи\"><emph>Связи</emph></link>, дважды щёлкните линию, соединяющую два связанных поля, или вызовите команду меню <emph>Вставка - Создать связь</emph>."
+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, который будет отображаться вместо имени."
+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 "Здесь можно ввести дополнительное условия для фильтрации каждой строки. Несколько условий в одном столбце будут соединены с помощью оператора \"ИЛИ\"."
+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(столбец): Назначение имени поля в качестве аргумента, учитывающего только те поля, в которых данное имя поля содержит значение. Нулевые значения (пустые поля) не учитываются."
+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 "МАКС"
-
-#: 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 "МИН"
-
-#: 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 "СУММ"
-
-#: 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 "ГРУППИРОВАТЬ ПО"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3149438\n"
 "help.text"
-msgid "Groups query data according to the field name selected. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING."
-msgstr "Группировка данных запроса согласно выбранному имени поля. Выполнение функций происходит в соответствии с указанными группами. В SQL этот параметр соответствует разделу GROUP BY. Если условие добавлено, его запись появляется в SQL HAVING."
+msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1181,24 +1125,24 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3159205\n"
 "help.text"
-msgid "Except for the <emph>Group</emph> function, the above functions are so-called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database system in use and on the current state of the Base driver."
-msgstr "За исключение функции <emph>Группа</emph>, вышеуказанные функции имеют общее название \"Агрегатные функции\". Это функции, которые выполняют расчёт данных для создания сводных данных на основании полученных результатов. Могут быть также доступны дополнительные функции, не указанные в поле со списком. Это зависит от конкретной используемой системы базы данных и состояния драйвера Base."
+msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148651\n"
 "help.text"
-msgid "To use other functions not listed in the list box, you must enter them under <emph>Field</emph>."
-msgstr "Чтобы использовать другие функции, не указанные в поле со списком, их необходимо указать в <emph>Поле</emph>."
+msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155098\n"
 "help.text"
-msgid "You can also assign aliases to function calls. If the query is not to be displayed in the column header, enter the desired name under <emph>Alias</emph>."
-msgstr "Вызовам функций можно назначать псевдонимы. Чтобы не отображать запрос в заголовке столбца, введите нужное имя в поле <emph>Псевдоним</emph>."
+msgid "You can also assign aliases to function calls. If you not wish the query string to be displayed in the column header, enter a desired substitute name under <emph>Alias</emph>."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1237,8 +1181,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154610\n"
 "help.text"
-msgid "If you run this function, you cannot insert any additional columns for the query other than receiving these columns as a \"Group\" function."
-msgstr "При запуске этой функции дополнительные столбцы могут быть вставлены в запрос только с помощью получения этих столбцов как функции \"Группировать\"."
+msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1285,8 +1229,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3161652\n"
 "help.text"
-msgid "Double-click the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
-msgstr "Дважды щёлкните поле \"Номер элемента\" таблицы \"Элемент\". С помощью контекстного меню перейдите к строке <emph>Функция</emph> и выберите функцию \"Счёт\"."
+msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1389,8 +1333,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150414\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for selection of functions.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Отображение или скрытие строки для выбора функций.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1437,8 +1381,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3147500\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applies only distinct values to the query.</ahelp> This applies to records containing data that appears several times in the selected fields. If the <emph>Distinct Values</emph> command is active, you will see only one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Применение к запросу только отдельных значений.</ahelp> Запрос применяется к записям, содержащим данные, которые появляются в выбранных полях несколько раз. Если команда <emph>Отдельные значения</emph> активна, в запросе будет отображаться только одна запись (DISTINCT). В противном случае будут отображаться все записи, удовлетворяющие условиям запроса (ALL)."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1477,7 +1421,7 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3147501\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to maximize the number of records with which query returns.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>"
 msgstr ""
 
 #: 02010100.xhp
@@ -1485,7 +1429,7 @@ 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."
+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
@@ -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] система автоматически преобразует их в соответствующий синтаксис 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 EMPTY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149893\n"
-"help.text"
-msgid "IS NULL"
-msgstr "IS NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3143236\n"
 "help.text"
 msgid "is null"
@@ -1741,28 +1621,12 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154744\n"
 "help.text"
-msgid "... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No)."
+msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)."
 msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3146940\n"
-"help.text"
-msgid "IS NOT EMPTY"
-msgstr "IS NOT EMPTY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3147471\n"
-"help.text"
-msgid "IS NOT NULL"
-msgstr "IS NOT NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3151229\n"
 "help.text"
 msgid "is not empty"
@@ -1773,40 +1637,24 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3145304\n"
 "help.text"
-msgid "... the field name is not empty."
-msgstr "... имя поля не пустое."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3153578\n"
-"help.text"
-msgid "LIKE"
-msgstr "LIKE"
+msgid "... the field is not empty, i.e it contains data."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3153891\n"
 "help.text"
-msgid "(placeholder * for any number of characters"
-msgstr "(для любого числа символов используется местозаполнитель *,"
+msgid "placeholder (*) for any number of characters"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3148887\n"
 "help.text"
-msgid "placeholder ? for exactly one character)"
-msgstr "для одного символа - местозаполнитель ?)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148623\n"
-"help.text"
-msgid "LIKE"
-msgstr "LIKE"
+msgid "placeholder (?) for exactly one character"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1821,16 +1669,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3157985\n"
 "help.text"
-msgid "(% placeholder for any number of characters"
-msgstr "(для любого числа символов используется местозаполнитель %,"
+msgid "placeholder (%) for any number of characters"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3147422\n"
 "help.text"
-msgid "Placeholder _ for exactly one character)"
-msgstr "для одного символа - местозаполнитель _)"
+msgid "Placeholder (_) for exactly one character"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1845,32 +1693,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3156130\n"
 "help.text"
-msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the $[officename] interface."
-msgstr "... поле данных содержит указанное выражение. Местозаполнитель (*) означает, что выражение x встречается в начале (x*), в конце (*x) или внутри (*x*) содержимого поля. В качестве местозаполнителя в запросах SQL можно ввести символ SQL % или обычный местозаполнитель файловой системы (*) в интерфейсе $[officename]."
+msgid "... the data field must contain the indicated search string in the order given. The position of the (*) placeholder indicates whether the searched for string (x) occurs before the placeholder (x*), after the placeholder (*x) or between the placeholders (*x*). Instead of the familiar file system (*) placeholder, you can also use the SQL (%) character as a placeholder in SQL queries in the $[officename] interface."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3150271\n"
 "help.text"
-msgid "The * or % placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
-msgstr "Местозаполнитель * или % используется для любого числа символов. Вопросительный знак (?) в интерфейсе $[officename] или подчёркивание (_) в запросах SQL применяется для обозначения строго одного символа."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152954\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NOT LIKE"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3161669\n"
-"help.text"
-msgid "NOT LIKE"
-msgstr "NOT LIKE"
+msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1885,24 +1717,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3161664\n"
 "help.text"
-msgid "... the field name does not contain the specified expression."
-msgstr "... имя поля не содержит указанного выражения."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149185\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "BETWEEN x AND y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3151259\n"
-"help.text"
-msgid "BETWEEN x AND y"
-msgstr "BETWEEN x AND y"
+msgid "... the field does not contain data having the specified expression."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1917,24 +1733,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3154395\n"
 "help.text"
-msgid "... the field name contains a value that lies between the two values x and y."
-msgstr "... имя поля содержит значение, лежащее между значениями x и y."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3154561\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NOT BETWEEN x AND y"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148753\n"
-"help.text"
-msgid "NOT BETWEEN x AND y"
-msgstr "NOT BETWEEN x AND y"
+msgid "... the field contains a data value that lies between the two values x and y."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1949,32 +1749,16 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3148992\n"
 "help.text"
-msgid "... the field name contains a value that does not lie between the two values x and y."
-msgstr "... имя поля содержит значение, лежащее за пределами интервала между значениями x и y."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149995\n"
-"help.text"
-msgid "IN (a; b; c...)"
-msgstr "IN (a; b; c...)"
+msgid "... the field contains a data value that does not lie between the two values x and y."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3159167\n"
 "help.text"
-msgid "Note that the semicolons are used as separators in all value lists!"
-msgstr "Обратите внимание, что точка с запятой используется в качестве разделителя во всех списках значений"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3159085\n"
-"help.text"
-msgid "IN (a, b, c...)"
-msgstr "IN (a, b, c...)"
+msgid "Note that semicolons are used as separators in all value lists!"
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
@@ -1989,24 +1773,8 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3148399\n"
 "help.text"
-msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by an Or link. The expressions a, b, c... can be either numbers or characters"
-msgstr "... имя поля содержит одно из указанных выражений a, b, c,... Может быть указано любое число выражений; результат запроса определяется оператором \"Или\". Выражения 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 "=\"Ms.\""
-
-#: 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 "возвращает имена полей, содержащих \"Ms.\"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id315379A\n"
-"help.text"
-msgid "<'2001-01-10'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id315094A\n"
 "help.text"
 msgid "returns dates that occurred before January 10, 2001"
@@ -2131,82 +1851,42 @@ msgstr ""
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id3150333\n"
-"help.text"
-msgid "LIKE 'g?ve'"
-msgstr "LIKE 'g?ve'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3147332\n"
 "help.text"
-msgid "returns field names with field content such as \"give\" and \"gave\"."
-msgstr "возвращает имена полей, содержащих \"give\", \"gave\" и т. п."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146062\n"
-"help.text"
-msgid "LIKE 'S*'"
-msgstr "LIKE 'S*'"
+msgid "returns records with field content such as \"give\" and \"gave\"."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3155350\n"
 "help.text"
-msgid "returns data fields with field contents such as \"Sun\"."
-msgstr "возвращает поля данных, содержащие, например, \"Sun\"."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152883\n"
-"help.text"
-msgid "BETWEEN 10 AND 20"
-msgstr "BETWEEN 10 AND 20"
+msgid "returns records with field contents such as \"Sun\"."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3159406\n"
 "help.text"
-msgid "returns field names with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
-msgstr "возвращает имена полей, содержащих значения от 10 и 20. (Поля могут быть как текстовыми, так и числовыми.)"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148765\n"
-"help.text"
-msgid "IN (1; 3; 5; 7)"
-msgstr "IN (1; 3; 5; 7)"
+msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3149712\n"
 "help.text"
-msgid "returns field names with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number."
-msgstr "возвращает имена полей со значениями 1, 3, 5, 7. Если имя поля содержит, к примеру, номер элемента, можно создать запрос, возвращающий элемент с указанным номером."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "NOT IN ('Smith')"
-msgstr "NOT IN ('Smith')"
+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 "возвращает имена полей, не содержащих \"Smith\"."
+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 "Чтобы запросить содержимое текстового поля, необходимо поместить выражение в одинарные кавычки. Различение прописных и строчных букв зависит от используемой базы данных. При использовании \"LIKE\" регистр учитывается по определению (в некоторых базах данных это соблюдается не так строго)."
+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 "{Д'ГГГГ-ММ-ДД'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975313\n"
-"help.text"
-msgid "{d 'YYYY-MM-DD'}"
-msgstr "{д 'ГГГГ-ММ-ДД'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975314\n"
-"help.text"
-msgid "'YYYY-MM-DD'"
-msgstr "{Д'ГГГГ-ММ-ДД'}"
-
-#: 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 "{Д'ЧЧ:ММ:СС'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559473\n"
-"help.text"
-msgid "{t 'HH:MI:SS[.SS]'}"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559474\n"
-"help.text"
-msgid "'HH:MI:SS[.SS]'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id31509641\n"
 "help.text"
 msgid "DateTime"
@@ -2387,30 +2019,6 @@ msgstr "Дата и время"
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
-"par_id31509642\n"
-"help.text"
-msgid "{D'YYYY-MM-DD HH:MM:SS'}"
-msgstr "{Д'ГГГГ-ММ-ДД ЧЧ:ММ:СС'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509643\n"
-"help.text"
-msgid "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509644\n"
-"help.text"
-msgid "'YYYY-MM-DD HH:MI:SS[.SS]'"
-msgstr ""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
 "par_id3149539\n"
 "help.text"
 msgid "Example: select {d '1999-12-31'} from world.years"
@@ -2429,7 +2037,7 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3150510\n"
 "help.text"
-msgid "All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
+msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
 msgstr ""
 
 #: 02010100.xhp
@@ -2661,32 +2269,32 @@ msgctxt ""
 "02010100.xhp\n"
 "par_id3152570\n"
 "help.text"
-msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has been created previously."
-msgstr "Для большинства запросов в $[officename] знание SQL не является необходимым, поскольку не нужно вводить код SQL. При создании запроса в конструкторе запросов $[officename] автоматически преобразует введенные инструкции в соответствующий синтаксис SQL. Чтобы просмотреть команды SQL для запроса, созданного ранее, перейдите к представлению SQL с помощью кнопки <emph>Включение и выключение режима конструктора</emph>."
+msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3152412\n"
 "help.text"
-msgid "You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
-msgstr "Можно сформулировать запрос непосредственно в коде SQL. Однако следует помнить, что особенности синтаксиса могут зависеть от используемой системы баз данных."
+msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3146842\n"
 "help.text"
-msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in <emph>Query design</emph>. These queries must be executed in native SQL mode."
-msgstr "При вводе кода SQL вручную можно создавать запросы SQL, которые не поддерживаются графическим интерфейсом <emph>конструктора запросов</emph>. Эти запросы должны быть выполнимы в режиме Native SQL."
+msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode."
+msgstr ""
 
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3149632\n"
 "help.text"
-msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]."
-msgstr "Чтобы сформулировать запрос, не обрабатываемый $[officename], щёлкните значок <link href=\"text/shared/02/14030000.xhp\" name=\"Выполнить команду SQL непосредственно\"><emph>Выполнить команду SQL непосредственно</emph></link>."
+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/ru/helpcontent2/source/text/shared/guide.po b/source/ru/helpcontent2/source/text/shared/guide.po
index 0231be23aa3..7eb49a13fc4 100644
--- a/source/ru/helpcontent2/source/text/shared/guide.po
+++ b/source/ru/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: 2016-10-08 09:13+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\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 "Дополнительные сведения об XML-формате OpenDocument см. на веб-сайте <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/ru/helpcontent2/source/text/shared/help.po b/source/ru/helpcontent2/source/text/shared/help.po
index f9e38601e47..05cb3c26e39 100644
--- a/source/ru/helpcontent2/source/text/shared/help.po
+++ b/source/ru/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/ru/helpcontent2/source/text/shared/optionen.po b/source/ru/helpcontent2/source/text/shared/optionen.po
index a74038199eb..3b9a84b8db6 100644
--- a/source/ru/helpcontent2/source/text/shared/optionen.po
+++ b/source/ru/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: 2016-10-08 09:11+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\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/ru/helpcontent2/source/text/smath.po b/source/ru/helpcontent2/source/text/smath.po
index 040848b918a..b2949f943f8 100644
--- a/source/ru/helpcontent2/source/text/smath.po
+++ b/source/ru/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: 2015-11-01 20:12+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -61,8 +61,8 @@ msgctxt ""
 "main0000.xhp\n"
 "par_id3143269\n"
 "help.text"
-msgid "Have a look at <link href=\"http://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
-msgstr "Для получения информации о ряде дополнительных математических значков и макросов %PRODUCTNAME см. <link href=\"http://www.dmaths.org\">www.dmaths.org</link>."
+msgid "Have a look at <link href=\"https://www.dmaths.org\">www.dmaths.org</link> for a set of additional %PRODUCTNAME Math icons and macros."
+msgstr ""
 
 #: main0100.xhp
 msgctxt ""
diff --git a/source/ru/helpcontent2/source/text/smath/01.po b/source/ru/helpcontent2/source/text/smath/01.po
index d167cfacfb1..c8712cb2939 100644
--- a/source/ru/helpcontent2/source/text/smath/01.po
+++ b/source/ru/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: 2017-11-02 11:41+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12365,15 +12365,15 @@ msgctxt ""
 "06020000.xhp\n"
 "par_id3153916\n"
 "help.text"
-msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
-msgstr "Диалоговое окно <emph>Вставить</emph> аналогично диалоговому окну <link href=\"text/shared/01/01020000.xhp\" name=\"Открыть\">Открыть</link>, которое открывается из меню <emph>Файл</emph>. Используйте диалоговое окно <emph>Вставить</emph> для загрузки, редактирования и отображения формул, сохраненных в виде файлов из окна <emph>Команды</emph>."
+msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\"><emph>Open</emph></link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
+msgstr ""
 
 #: 06020000.xhp
 msgctxt ""
 "06020000.xhp\n"
 "par_id3153917\n"
 "help.text"
-msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"http://www.w3.org/TR/#tr_MathML\">specification</link>."
+msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"https://www.w3.org/TR/#tr_MathML\">specification</link>."
 msgstr ""
 
 #: 06020000.xhp
@@ -12421,5 +12421,5 @@ msgctxt ""
 "06020000.xhp\n"
 "par_id3153919\n"
 "help.text"
-msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">Paste</link> under <emph>Edit</emph>."
+msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\"><emph>Paste</emph></link> under <emph>Edit</emph>."
 msgstr ""
diff --git a/source/ru/helpcontent2/source/text/swriter/guide.po b/source/ru/helpcontent2/source/text/swriter/guide.po
index 2f23acb07aa..71d94d070a2 100644
--- a/source/ru/helpcontent2/source/text/swriter/guide.po
+++ b/source/ru/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
 "PO-Revision-Date: 2018-02-09 16:02+0000\n"
 "Last-Translator: bormant <bormant@mail.ru>\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
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2018-11-12 23:58:17 +0100
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2018-11-13 00:04:09 +0100
commit	dee42a39ff84aae292b56cf83137983da5c28975 (patch)
tree	d60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/ru/helpcontent2
parent	f14221545cf5a1be2c6f74915bcaff29db79a85d (diff)