aboutsummaryrefslogtreecommitdiff
path: root/source/nl/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-11-12 23:58:17 +0100
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-11-13 00:04:09 +0100
commitdee42a39ff84aae292b56cf83137983da5c28975 (patch)
treed60b875d95ccd2f4b5b2157824ba2b2cebcc7b2a /source/nl/helpcontent2
parentf14221545cf5a1be2c6f74915bcaff29db79a85d (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I6b444d20d156df4126666efaeb30a0902054362b
Diffstat (limited to 'source/nl/helpcontent2')
-rw-r--r--source/nl/helpcontent2/source/text/sbasic/shared.po12
-rw-r--r--source/nl/helpcontent2/source/text/sbasic/shared/03.po6
-rw-r--r--source/nl/helpcontent2/source/text/scalc/01.po296
-rw-r--r--source/nl/helpcontent2/source/text/scalc/05.po96
-rw-r--r--source/nl/helpcontent2/source/text/scalc/guide.po14
-rw-r--r--source/nl/helpcontent2/source/text/shared/00.po38
-rw-r--r--source/nl/helpcontent2/source/text/shared/01.po152
-rw-r--r--source/nl/helpcontent2/source/text/shared/02.po10
-rw-r--r--source/nl/helpcontent2/source/text/shared/explorer/database.po1000
-rw-r--r--source/nl/helpcontent2/source/text/shared/guide.po22
-rw-r--r--source/nl/helpcontent2/source/text/shared/help.po6
-rw-r--r--source/nl/helpcontent2/source/text/shared/optionen.po16
-rw-r--r--source/nl/helpcontent2/source/text/smath.po6
-rw-r--r--source/nl/helpcontent2/source/text/smath/01.po14
-rw-r--r--source/nl/helpcontent2/source/text/swriter/guide.po10
15 files changed, 765 insertions, 933 deletions
diff --git a/source/nl/helpcontent2/source/text/sbasic/shared.po b/source/nl/helpcontent2/source/text/sbasic/shared.po
index eff04c76509..3ea21683552 100644
--- a/source/nl/helpcontent2/source/text/sbasic/shared.po
+++ b/source/nl/helpcontent2/source/text/sbasic/shared.po
@@ -4,7 +4,7 @@ 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"
-"PO-Revision-Date: 2018-07-17 06:56+0000\n"
+"PO-Revision-Date: 2018-10-29 08:23+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -14,7 +14,7 @@ msgstr ""
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1531810567.000000\n"
+"X-POOTLE-MTIME: 1540801430.000000\n"
#: 00000002.xhp
msgctxt ""
@@ -5486,7 +5486,7 @@ msgctxt ""
"par_id3149252\n"
"help.text"
msgid "<ahelp hid=\".\">Specify the order in which the controls receive the focus when the Tab key is pressed in the dialog.</ahelp> On entering a dialog, the control with the lowest order (0) receives the focus. Pressing the <emph>Tab</emph> key the successively focuses the other controls as specified by their order number."
-msgstr ""
+msgstr "<ahelp hid=\".\">Geef de volgorde op waarin de besturingselementen de focus krijgen wanneer de Tab-toets in het dialoogvenster ingedrukt wordt.</ahelp> Wanneer u een dialoogvenster opent, gaat de focus naar het besturingselement dat op de laagste plaats (0) staat. Wanneer u herhaaldelijk op de <emph>Tab</emph>-toets drukt, wordt de focus in de opgegeven volgorde door de andere besturingselementen verplaatst."
#: 01170101.xhp
msgctxt ""
@@ -8510,7 +8510,7 @@ msgctxt ""
"par_id3155132\n"
"help.text"
msgid "<emph>FileName: </emph>Name and path of the file to open. If you try to read a file that does not exist (Access = Read), an error message appears. If you try to write to a file that does not exist (Access = Write), a new file is created."
-msgstr ""
+msgstr "<emph>Bestandsnaam: </emph>Naam en pad van het te openen bestand. Indien u probeert om een bestand te lezen dat niet bestaat (Toegang krijgen = Lezen), verschijnt er een foutbericht. Indien u probeert om naar een bestand te schrijven dat niet bestaat (Toegang krijgen = Schrijven), verschijnt er een foutbericht."
#: 03020103.xhp
msgctxt ""
@@ -28518,7 +28518,7 @@ msgctxt ""
"par_id3154909\n"
"help.text"
msgid "' This example inserts the Greek letters alpha and omega in a string."
-msgstr ""
+msgstr "' Dit voorbeeld voegt de Griekse tekens Alfa en Omega in een tekenreeks in."
#: 03120112.xhp
msgctxt ""
@@ -34158,7 +34158,7 @@ msgctxt ""
"par_id3151384\n"
"help.text"
msgid "Returns the interest rate of a loan or an investment."
-msgstr ""
+msgstr "Geeft het rentepercentage van een lening of investering."
#: 03140010.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/sbasic/shared/03.po b/source/nl/helpcontent2/source/text/sbasic/shared/03.po
index 06eb09a4909..0d1446e4735 100644
--- a/source/nl/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/nl/helpcontent2/source/text/sbasic/shared/03.po
@@ -4,7 +4,7 @@ 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-12 15:02+0200\n"
-"PO-Revision-Date: 2018-07-24 08:33+0000\n"
+"PO-Revision-Date: 2018-10-29 07:56+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -14,7 +14,7 @@ msgstr ""
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
-"X-POOTLE-MTIME: 1532421202.000000\n"
+"X-POOTLE-MTIME: 1540799804.000000\n"
#: lib_depot.xhp
msgctxt ""
@@ -270,7 +270,7 @@ msgctxt ""
"par_id41529001004856\n"
"help.text"
msgid "<variable id=\"call_param\">Calling parameters and comments</variable>"
-msgstr ""
+msgstr "<variable id=\"call_param\">Parameters en commentaren oproepen</variable>"
#: lib_tools.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/scalc/01.po b/source/nl/helpcontent2/source/text/scalc/01.po
index 135eab05f9d..3fadc48eb8d 100644
--- a/source/nl/helpcontent2/source/text/scalc/01.po
+++ b/source/nl/helpcontent2/source/text/scalc/01.po
@@ -3,9 +3,9 @@ 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"
-"PO-Revision-Date: 2018-09-17 21:20+0000\n"
-"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
+"PO-Revision-Date: 2018-10-29 08:49+0000\n"
+"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
"MIME-Version: 1.0\n"
@@ -14,7 +14,7 @@ msgstr ""
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1537219218.000000\n"
+"X-POOTLE-MTIME: 1540802986.000000\n"
#: 01120000.xhp
msgctxt ""
@@ -3478,7 +3478,7 @@ msgctxt ""
"par_id3153417\n"
"help.text"
msgid "<variable id=\"kategorienliste\"><ahelp hid=\"formula/ui/functionpage/category\">Lists all the categories to which the different functions are assigned. Select a category to view the appropriate functions in the list field below.</ahelp> Select \"All\" to view all functions in alphabetical order, irrespective of category. \"Last Used\" lists the functions you have most recently used.</variable>"
-msgstr ""
+msgstr "<variable id=\"kategorienliste\"><ahelp hid=\"formula/ui/functionpage/category\">Somt alle categorieën op waaraan de verschillende functies zijn toegewezen. Selecteer een categorie om de toepasselijke functies in het lijstveld eronder te bekijken.</ahelp> Selecteer \"Alle\" om alle functies in alfabetische volgorde, los van de categorie, te bekijken. \"Als laatste gebruikt\" somt de functies op die u het meest recent heeft gebruikt.</variable>"
#: 04060000.xhp
msgctxt ""
@@ -6974,7 +6974,7 @@ msgctxt ""
"par_id9841608\n"
"help.text"
msgid "The type of the operating system. <br/>\"WNT\" for Microsoft Windows <br/>\"LINUX\" for Linux <br/>\"MACOSX\" for macOS<br/>\"SOLARIS\" for Solaris"
-msgstr ""
+msgstr "Het type besturingssysteem. <br/>\"WNT\" voor Microsoft Windows <br/>\"LINUX\" voor Linux <br/>\"MACOSX\" voor macOS <br/>\"SOLARIS\" voor Solaris"
#: 04060104.xhp
msgctxt ""
@@ -13822,7 +13822,7 @@ msgctxt ""
"par_id2855616\n"
"help.text"
msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9."
-msgstr ""
+msgstr "Deze functie levert een nieuw willekeurig getal steeds als Calc opnieuw berekent. Druk op F9 om handmatig te berekenen."
#: 04060106.xhp
msgctxt ""
@@ -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>matrices; functies</bookmark_value> <bookmark_value>FunctieAssistent; matrices</bookmark_value> <bookmark_value>matrixformules</bookmark_value><bookmark_value>in-regelige matrixconstanten</bookmark_value> <bookmark_value>formules;matrices</bookmark_value> <bookmark_value>functies;matrixfuncties</bookmark_value> <bookmark_value>bewerken; matrixformules</bookmark_value> <bookmark_value>kopiëren; matrixformules</bookmark_value> <bookmark_value>matrixbereiken aanpassen</bookmark_value> <bookmark_value>berekenen;voorwaardelijke berekeningen</bookmark_value> <bookmark_value>matrices; berekeningen</bookmark_value> <bookmark_value>voorwaardelijke berekeningen met matrices</bookmark_value> <bookmark_value>impliciete matrixafhandeling</bookmark_value> <bookmark_value>geforceerde matrixafhandeling</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 "U hoeft geen formule op elke individuele cel of waarde toe te passen om de waarden in de individuele cellen in bovenstaande matrix met 10 te vermenigvuldigen. In plaats daarvan hoeft u slechts één enkele matrixformule te gebruiken Selecteer een bereik van 3 x 3 cellen op een ander gedeelte van het werkblad, voer de formule <item type=\"input\">=10*A1:C3</item> in en bevestig deze invoer met de toetscombinatie <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. Het resultaat is een 3 x 3-matrix waarin de individuele waarden in het celbereik (A1:C3) zijn vermenigvuldigd met de factor 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 "Als u de matrixformule rechtstreeks in de cel invoert, moet u de toetsencombinatie Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter gebruiken in plaats van de Enter-toets. Alleen dan wordt de formule een matrixformule."
+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 "Selecteer drie cellen in een rij en type dan de formule <item type=\"input\">={1;2;3}</item> met gebruik van de accolades en de punt-komma's om deze matrixconstante in te voeren, en druk dan op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
+msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14333,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 "Selecteer het celbereik of matrix die de matrixformule bevat. Plaats, om de gehele matrix te selecteren, de celcursor binnen het matrixbereik en druk op <switchinline select=\"sys\"><caseinline select=\"MAC\">Commando</caseinline><defaultinline>Ctrl</defaultinline></switchinline> +/, waarbij / het deelteken is op het numerieke toetsenbord."
+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 "Druk op F2 of plaats de cursor op de invoerregel. Via beide handelingen kunt u de formule bewerken."
+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 "Nadat u wijzigingen hebt aangebracht, drukt u op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter."
+msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -14381,32 +14381,32 @@ msgctxt ""
"04060107.xhp\n"
"par_id3154619\n"
"help.text"
-msgid "Either press F2 or position the cursor in the input line."
-msgstr "Druk op F2 of plaats de cursor op de invoerregel."
+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 "Kopieer de formule naar de invoerregel door op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C te drukken."
+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 "Selecteer een cellenbereik waar de matrixformule ingevoegd moet worden en druk dan op F2 of plaats de cursor in de invoerregel."
+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 "Plak de formule in de geselecteerde ruimte door op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V te drukken en bevestig door op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter te drukken. Het geselecteerde bereik bevat nu de matrixformule."
+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 "Door de <switchinline select=\"sys\"><caseinline select=\"MAC\">Commando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-toets ingedrukt te houden, kunt u een kopie van de matrixformule maken in het opgegeven bereik."
+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\">Bepaalt de frequentieverdeling in een matrix met één kolom.</ahelp> De functie telt hoeveel waarden in de gegevensmatrix binnen de waarden liggen die door de klassenmatrix gegeven worden."
+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>DETERMINANT-functie</bookmark_value> <bookmark_value>determinanten</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>INVERSEMAT-functie</bookmark_value> <bookmark_value>inverse matrix</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 "Selecteer, in het werkblad, het bereik waarin de getransponeerde matrix moet verschijnen. Indien de originele matrix n rijen en m kolommen had, moet uw geselecteerde bereik tenminste m rijen en n kolommen hebben. Voer dan de formula direct in, selecteer de originele matrix en druk op <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Of, als u de <emph>Functie-Assistent</emph> gebruikt, markeer het keuzevak <emph>Matrix</emph>. De getransponeerde matrix verschijnt in het geselecteerde doelbereik en wordt automatisch beveiligd tegen wijzigingen."
+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,8 +15461,8 @@ 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:"
-msgstr "Vervolgens <emph>zorg ervoor dat u het invoert als matrixformule met </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift+Command+Enter</emph></caseinline><defaultinline><emph>Shift+Ctrl+Enter</emph></defaultinline></switchinline>. Het resultaat is als volgt:"
+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
msgctxt ""
@@ -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 "LIJNSCH geeft een tabel (matrix) van statistieken zoals hieronder terug en moet worden ingevoerd als een matrixformule (door bijvoorbeeld <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter te gebruiken, in plaats van alleen Enter)."
+msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>)."
+msgstr ""
#: 04060107.xhp
msgctxt ""
@@ -16061,8 +16061,8 @@ msgctxt ""
"04060107.xhp\n"
"par_id3158106\n"
"help.text"
-msgid "The formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>"
-msgstr "De formule in de <emph>Formule</emph>balk komt overeen met elke cel van de matrix LIJNSCH <item type=\"input\">{=LIJNSCH(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>stijgingen, zie ook regressielijnen</bookmark_value> <bookmark_value>regressielijnen;LIJNSCH-functie</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>standaardfouten;arrayfuncties</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>SOMPRODUCT-functie</bookmark_value> <bookmark_value>scalaire producten</bookmark_value> <bookmark_value>dot-producten</bookmark_value> <bookmark_value>inwendige producten</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 "SOMPRODUCT(Matrix1; Matrix2...Matrix30)"
+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>Matrix1; Matrix2...Matrix30</emph> vertegenwoordigen matrices waarvan de corresponderende elementen moeten worden vermenigvuldigd."
+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>Lineairtype</emph> (optioneel). Als Lineairtype = 0 worden lijnen berekend door het nulpunt. Anders worden daarbuiten vallende lijnen ook berekend. Standaard is Lineairtype <> 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 "Selecteer een werkbladbereik waarin de trendgegevens zullen verschijnen. Selecteer de functie. Voer de uitvoergegevens in of selecteer ze met de muis. Selecteer het veld <emph>Matrix</emph> en klik op <emph>OK</emph>. De trendgegevens die uit de uitvoergegevens berekend zijn, worden weergegeven."
+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>GROEI-functie</bookmark_value> <bookmark_value>exponentiële trends in matrices</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>Functietype</emph>(optioneel). Als Functietype = 0 zullen functies in de vorm y = m^x worden berekend. Anders worden y = b*m^x-functies berekend."
+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 "Deze functie geeft een matrix terug en wordt op dezelfde wijze afgehandeld als de andere matrixfuncties. Selecteer een bereik waar u wilt dat de antwoorden verschijnen en selecteer de functie. Selecteer GegevensY. Voer enkele andere parameters in, markeer <emph>Matrix</emph> en klik op <emph>OK</emph>."
+msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>."
+msgstr ""
#: 04060108.xhp
msgctxt ""
@@ -17254,7 +17254,7 @@ msgctxt ""
"par_id3159260\n"
"help.text"
msgid "If the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6."
-msgstr ""
+msgstr "Als bovenstaande formule in cel B2 staat en als de cel A1 in blad 2 de waarde <item type=\"input\">-6</item> bevat, kunt u indirect verwijzen naar de cel, waarnaar verwezen wordt met een functie in B2, door in te voeren <item type=\"input\">=ABS(INDIRECT(B2))</item>t. Het resultaat is de absolute waarde van de celverwijzing die is gespecificeerd in B2, wat in dit geval 6 is."
#: 04060109.xhp
msgctxt ""
@@ -17694,7 +17694,7 @@ msgctxt ""
"par_idN10CAE\n"
"help.text"
msgid "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT(\"[filename]sheetname!\"&B1) is not converted into the Calc address in INDIRECT(\"filename#sheetname.\"&B1)."
-msgstr ""
+msgstr "Als u een Excel-werkblad opent waarin indirecte adressen gebruikt worden die berekend zijn uit tekenreeksfuncties, worden de bladadressen niet automatisch vertaald. Zo wordt het Excel-adres in INDIRECT(\"[filename]sheetname!\"&B1) niet naar het Calc-adres in INDIRECT(\"filename#sheetname.\"&B1) geconverteerd."
#: 04060109.xhp
msgctxt ""
@@ -20862,7 +20862,7 @@ msgctxt ""
"par_id3148692\n"
"help.text"
msgid "<ahelp hid=\"HID_FUNC_SUCHEN\">Returns the position of a text segment within a character string.</ahelp> You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. If the text is not found, returns error 519 (#VALUE)."
-msgstr ""
+msgstr "<ahelp hid=\"HID_FUNC_SUCHEN\">Geeft de positie van een tekstsegment binnen een tekenreeks.</ahelp> U kunt het begin van de zoekactie als een optie instellen. De zoektekst kan een getal zijn of een reeks tekens. De zoekopdracht is niet hoofdlettergevoelig. Als de tekst niet gevonden wordt, wordt de foutcode 519 (#WAARDE) gegenereerd."
#: 04060110.xhp
msgctxt ""
@@ -21398,7 +21398,7 @@ msgctxt ""
"par_id3146120\n"
"help.text"
msgid "You will also find a <link href=\"text/scalc/01/04060112.xhp\">description of the $[officename] Calc add-in interface</link> in the Help. In addition, important functions and their parameters are described in the Help for the <switchinline select=\"sys\"><caseinline select=\"UNIX\">Shared Library</caseinline><defaultinline>$[officename] Calc add-in DLL</defaultinline></switchinline>."
-msgstr ""
+msgstr "De Help bevat ook een <link href=\"text/scalc/01/04060112.xhp\">beschrijving van de addin-interface van $[officename] Calc</link>. Daarnaast worden belangrijke functies en hun parameters beschreven in de Help voor de <switchinline select=\"sys\"><caseinline select=\"UNIX\">gedeelde bibliotheek</caseinline><defaultinline>$[officename] Calc-addin-DLL</defaultinline></switchinline>."
#: 04060111.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>Bovengrens</emph> is optioneel. Dit is de bovengrens van de integraal. Als deze waarde ontbreekt wordt berekend tussen 0 en de ondergrens."
+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>Ondergrens</emph> is de ondergrens van de integraal. De berekening vindt plaats tussen 0 en deze ondergrens."
+msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit."
+msgstr ""
#: 04060115.xhp
msgctxt ""
@@ -36678,7 +36678,7 @@ msgctxt ""
"par_id2653976\n"
"help.text"
msgid "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive."
-msgstr ""
+msgstr "Het verschil tussen <item type=\"input\">PERCENTILE.INC</item> en <item type=\"input\">PERCENTILE.EXC</item> is dat, in de <item type=\"input\">PERCENTILE.INC</item>-functie, de waarde van alpha binnen het bereik van 0 tot 1 inclusief is en de <item type=\"input\">PERCENTILE.EXC</item>-functie, de waarde van alpha binnen het bereik van 0 tot 1 exclusief is."
#: 04060184.xhp
msgctxt ""
@@ -36742,7 +36742,7 @@ msgctxt ""
"par_id2753976\n"
"help.text"
msgid "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive."
-msgstr ""
+msgstr "Het verschil tussen <item type=\"input\">PERCENTILE.INC</item> en <item type=\"input\">PERCENTILE.EXC</item> is dat, in de <item type=\"input\">PERCENTILE.INC</item>-functie, de waarde van alpha binnen het bereik van 0 tot 1 inclusief is en de <item type=\"input\">PERCENTILE.EXC</item>-functie, de waarde van alpha binnen het bereik van 0 tot 1 exclusief is."
#: 04060184.xhp
msgctxt ""
@@ -49358,7 +49358,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "Common Syntax and example"
-msgstr ""
+msgstr "Gebruikelijke syntaxis en voorbeeld"
#: common_func.xhp
msgctxt ""
@@ -49366,7 +49366,7 @@ msgctxt ""
"hd_id3152015\n"
"help.text"
msgid "Syntax"
-msgstr ""
+msgstr "Syntaxis"
#: common_func.xhp
msgctxt ""
@@ -49374,7 +49374,7 @@ msgctxt ""
"hd_id281171\n"
"help.text"
msgid "Example"
-msgstr ""
+msgstr "Voorbeeld"
#: common_func_workdaysintl.xhp
msgctxt ""
@@ -51886,7 +51886,7 @@ msgctxt ""
"par_id3252589\n"
"help.text"
msgid "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"y\")</item> yields 38."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMVERSCHIL(\"17-04-1974\";\"13-06-2012\";\"j\")</item> geeft 38."
#: func_datedif.xhp
msgctxt ""
@@ -51894,7 +51894,7 @@ msgctxt ""
"par_id451535132395328\n"
"help.text"
msgid "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"ym\")</item> yields 1."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMVERSCHIL(\"17-04-1974\";\"13-06-2012\";\"j\")</item> geeft 1."
#: func_datedif.xhp
msgctxt ""
@@ -51902,7 +51902,7 @@ msgctxt ""
"par_id611535132402642\n"
"help.text"
msgid "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"md\")</item> yields 27."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMVERSCHIL(\"17-04-1974\";\"13-06-2012\";\"md\")</item> geeft 27."
#: func_datedif.xhp
msgctxt ""
@@ -51910,7 +51910,7 @@ msgctxt ""
"par_id511535132411940\n"
"help.text"
msgid "So he is 38 years, 1 month and 27 days old."
-msgstr ""
+msgstr "Dus is hij 38 jaar, 1 maand en 27 dagen oud."
#: func_datedif.xhp
msgctxt ""
@@ -51918,7 +51918,7 @@ msgctxt ""
"par_id3352589\n"
"help.text"
msgid "<item type=\"input\">=DATEDIF(DATE(1974,4,17);\"2012-06-13\";\"m\")</item> yields 457, he has been living for 457 months."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMVERSCHIL(DATUM(13-06-1974\";\"13-06-2012\";\"m\")</item> geeft 457, hij leeft dus reeds 457 maanden."
#: func_datedif.xhp
msgctxt ""
@@ -51934,7 +51934,7 @@ msgctxt ""
"par_id3752589\n"
"help.text"
msgid "<item type=\"input\">=DATEDIF(\"1974-04-17\";DATE(2012;06;13);\"yd\")</item> yields 57, his birthday was 57 days ago."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMVERSCHIL(\"17-04-1974\";DATUM(13-06-2012);\"jd\")</item> geeft 57, zijn verjaardag was 57 dagen geleden."
#: func_datevalue.xhp
msgctxt ""
@@ -52006,7 +52006,7 @@ msgctxt ""
"par_id3155841\n"
"help.text"
msgid "<item type=\"input\">=DATEVALUE(\"1954-07-20\")</item> yields 19925."
-msgstr ""
+msgstr "<item type=\"input\">=DATUMWAARDE(\"20-07-1954\")</item> levert 19925 op."
#: func_day.xhp
msgctxt ""
@@ -52054,7 +52054,7 @@ msgctxt ""
"par_id3149443\n"
"help.text"
msgid "<emph>Number</emph> is the internal date number."
-msgstr ""
+msgstr "<emph>Getal</emph> is de interne datumwaarde."
#: func_day.xhp
msgctxt ""
@@ -52062,7 +52062,7 @@ msgctxt ""
"par_id3151200\n"
"help.text"
msgid "<item type=\"input\">=DAY(1)</item> returns 31 (since $[officename] starts counting at zero from December 30, 1899)"
-msgstr ""
+msgstr "<item type=\"input\">DAG(1)</item> geeft 31 terug (omdat $[officename] met 0 begint te tellen vanaf 30 december 1899)"
#: func_day.xhp
msgctxt ""
@@ -52070,7 +52070,7 @@ msgctxt ""
"par_id3154130\n"
"help.text"
msgid "<item type=\"input\">=DAY(NOW())</item> returns the current day."
-msgstr ""
+msgstr "<item type=\"input\">=DAG(NU())</item> geeft de huidige dag."
#: func_day.xhp
msgctxt ""
@@ -52078,7 +52078,7 @@ msgctxt ""
"par_id3159190\n"
"help.text"
msgid "<item type=\"input\">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter)."
-msgstr ""
+msgstr "<item type=\"input\">=DAG(C4)</item> geeft 5 terug als u 05-08-1901 invoert in cel C4 (de datumwaarde zou anders opgemaakt kunnen worden nadat u op Enter heeft gedrukt)."
#: func_days.xhp
msgctxt ""
@@ -52134,7 +52134,7 @@ msgctxt ""
"par_id3159101\n"
"help.text"
msgid "<item type=\"input\">=DAYS(\"2010-01-01\"; NOW())</item> returns the number of days from today until January 1, 2010."
-msgstr ""
+msgstr "<item type=\"input\">=DAGEN(\"01-01-2010\"; NU())</item> geeft het aantal dagen terug vanaf vandaag tot 1 januari 2010."
#: func_days.xhp
msgctxt ""
@@ -52142,7 +52142,7 @@ msgctxt ""
"par_id3163720\n"
"help.text"
msgid "<item type=\"input\">=DAYS(\"1990-10-10\";\"1980-10-10\")</item> returns 3652 days."
-msgstr ""
+msgstr "<item type=\"input\">=DAGEN(\"10-10-1990\";\"10-10-1980\")</item> geeft 3652 dagen."
#: func_days360.xhp
msgctxt ""
@@ -52206,7 +52206,7 @@ msgctxt ""
"par_id3156348\n"
"help.text"
msgid "<item type=\"input\">=DAYS360(\"2000-01-01\";NOW())</item> returns the number of interest days from January 1, 2000 until today."
-msgstr ""
+msgstr "<item type=\"input\">=DAGEN360(\"01-01-2000\"; NU())</item> geeft het aantal dagen terug vanaf 1 januari 2010 tot vandaag."
#: func_eastersunday.xhp
msgctxt ""
@@ -52294,7 +52294,7 @@ msgctxt ""
"par_id3154472\n"
"help.text"
msgid "<item type=\"input\">=EASTERSUNDAY(2000)</item> returns 2000-04-23."
-msgstr ""
+msgstr "<item type=\"input\">=EERSTEPAASDAG(2000)</item> geeft 13-04-2000."
#: func_eastersunday.xhp
msgctxt ""
@@ -52302,7 +52302,7 @@ msgctxt ""
"par_id3150940\n"
"help.text"
msgid "<item type=\"input\">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD."
-msgstr ""
+msgstr "<item type=\"input\">EERSTEPAASDAG(2000)+49</item> geeft het interne seriële getal 36688 terug. Het resultaat is 11-06-2000. Maak het seriële datumgetal op als een datum, bijvoorbeeld in de opmaak JJJJ-MM-DD."
#: func_edate.xhp
msgctxt ""
@@ -54174,7 +54174,7 @@ msgctxt ""
"par_id3149792\n"
"help.text"
msgid "<item type=\"input\">=ISOWEEKNUM(DATE(1995;1;1))</item> returns 52. Week 1 starts on Monday, 1995-01-02."
-msgstr ""
+msgstr "<item type=\"input\">=ISOWEEKNUM(DATUM(01-01-1995))</item> geeft 52. Week 1 start op maandag, 02-01-1995."
#: func_isoweeknum.xhp
msgctxt ""
@@ -54182,7 +54182,7 @@ msgctxt ""
"par_id3149794\n"
"help.text"
msgid "<item type=\"input\">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04."
-msgstr ""
+msgstr "<item type=\"input\">=ISOWEEKNUM(DATE(01-01-1990))</item> geeft 53. Week 1 start op maandag, 04-01-1999."
#: func_maxifs.xhp
msgctxt ""
@@ -54622,7 +54622,7 @@ msgctxt ""
"par_id3149485\n"
"help.text"
msgid "<emph>Number</emph> is the internal date number."
-msgstr ""
+msgstr "<emph>Getal</emph> is de interne datumwaarde."
#: func_month.xhp
msgctxt ""
@@ -54630,7 +54630,7 @@ msgctxt ""
"par_id3149244\n"
"help.text"
msgid "<item type=\"input\">=MONTH(NOW())</item> returns the current month."
-msgstr ""
+msgstr "<item type=\"input\">=MAAND(NU())</item> geeft de huidige maand."
#: func_month.xhp
msgctxt ""
@@ -54638,7 +54638,7 @@ msgctxt ""
"par_id3154790\n"
"help.text"
msgid "<item type=\"input\">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter)."
-msgstr ""
+msgstr "<item type=\"input\">=MAAND(C4)</item> geeft 7 terug als u 07-07-2000 invoert in cel C4 (de datumwaarde zou anders opgemaakt kunnen worden nadat u op Enter heeft gedrukt)."
#: func_networkdays.intl.xhp
msgctxt ""
@@ -54678,7 +54678,7 @@ msgctxt ""
"par_id231020162249539143\n"
"help.text"
msgid "NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)"
-msgstr ""
+msgstr "WERKDAG.INT(Begindatum; Einddatum; Weekend; Vakantiedagen)"
#: func_networkdays.intl.xhp
msgctxt ""
@@ -54710,7 +54710,7 @@ msgctxt ""
"par_id231020162249551234\n"
"help.text"
msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days."
-msgstr ""
+msgstr "<item type=\"input\">=NETTOWERKDAGEN.INT(C3;D3;;F3:J3)</item> geeft 21 werkdagen met standaard voor weekenddagen."
#: func_networkdays.intl.xhp
msgctxt ""
@@ -54718,7 +54718,7 @@ msgctxt ""
"par_id231020162249553109\n"
"help.text"
msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends."
-msgstr ""
+msgstr "<item type=\"input\">=NETTOWERKDAGEN.INT(C3;D3;11;F3:J3)</item> geeft 24 werkdagen met zondag alleen in het weekend."
#: func_networkdays.intl.xhp
msgctxt ""
@@ -54734,7 +54734,7 @@ msgctxt ""
"par_id231020162249553409\n"
"help.text"
msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> returns 24 workdays with Sunday only weekend."
-msgstr ""
+msgstr "<item type=\"input\">=NETTOWERKDAGEN.INT(C3;D3;\"0000001\";F3:J3)</item> geeft 24 werkdagen met zondag alleen in het weekend."
#: func_networkdays.intl.xhp
msgctxt ""
@@ -54750,7 +54750,7 @@ msgctxt ""
"par_id23102016224955931\n"
"help.text"
msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days."
-msgstr ""
+msgstr "<item type=\"input\">=NETTOWERKDAGEN.INT(C3;D3)</item> geeft 22 werkdagen."
#: func_networkdays.intl.xhp
msgctxt ""
@@ -56126,7 +56126,7 @@ msgctxt ""
"par_id3150317\n"
"help.text"
msgid "<item type=\"input\">=WEEKDAY(\"2000-06-14\")</item> returns 4 (the Type parameter is missing, therefore the standard count is used. The standard count starts with Sunday as day number 1. June 14, 2000 was a Wednesday and therefore day number 4)."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKDAG(\"14-06-2000\")</item> geeft 4 terug (de parameter Type ontbreekt, daarom wordt de standaardtelling gebruikt. De standaardtelling begint met zondag als dag 1. 14 juni 2000 was een woensdag en daarom dag 4)."
#: func_weekday.xhp
msgctxt ""
@@ -56134,7 +56134,7 @@ msgctxt ""
"par_id3153174\n"
"help.text"
msgid "<item type=\"input\">=WEEKDAY(\"1996-07-24\";2)</item> returns 3 (the Type parameter is 2, therefore Monday is day number 1. July 24, 1996 was a Wednesday and therefore day number 3)."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKDAG(\"24-07-1996\";2)</item> geeft 3 terug (de parameter Type is 2, daarom is maandag dag 1. 24 juli 1996 was een woensdag en daarom dag 3)."
#: func_weekday.xhp
msgctxt ""
@@ -56142,7 +56142,7 @@ msgctxt ""
"par_id3153525\n"
"help.text"
msgid "<item type=\"input\">=WEEKDAY(\"1996-07-24\";1)</item> returns 4 (the Type parameter is 1, therefore Sunday is day number 1. July 24, 1996 was a Wednesday and therefore day number 4)."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKDAG(\"24-07-1996\";2)</item> geeft 4 terug (de parameter Type is 1, daarom is zondag dag 1. 24 juli 1996 was een woensdag en daarom dag 4)."
#: func_weekday.xhp
msgctxt ""
@@ -56150,7 +56150,7 @@ msgctxt ""
"par_id050220170616006699\n"
"help.text"
msgid "<item type=\"input\">=WEEKDAY(\"2017-05-02\";14)</item> returns 6 (the Type parameter is 14, therefore Thursday is day number 1. May 2, 2017 was a Tuesday and therefore day number 6)"
-msgstr ""
+msgstr "<item type=\"input\">=WEEKDAG(\"02-05-2017\";14)</item> geeft 6 (de parameter Type is 14, daarom is donderdag dagnummer 1. 2 mei 2017 was een dinsdag en daarom dagnummer 6)"
#: func_weekday.xhp
msgctxt ""
@@ -56158,7 +56158,7 @@ msgctxt ""
"par_id3150575\n"
"help.text"
msgid "<item type=\"input\">=WEEKDAY(NOW())</item> returns the number of the current day."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKDAG(NU())</item> geeft het getal van de huidige dag."
#: func_weekday.xhp
msgctxt ""
@@ -56166,7 +56166,7 @@ msgctxt ""
"par_id3150588\n"
"help.text"
msgid "To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type=\"input\">IF(WEEKDAY(A1;2)<6;\"Business day\";\"Weekend\")</item>"
-msgstr ""
+msgstr "U kunt een functie maken om aan te geven of een dag in A1 een werkdag is door de functies ALS en WEEKDAG als volgt te gebruiken: <br/><item type=\"input\">ALS(WEEKDAG(A1;2)<6;\"Werkdag\";\"Weekend\")<6;\"Business day\";\"Weekend\")</item>"
#: func_weeknum.xhp
msgctxt ""
@@ -56214,7 +56214,7 @@ msgctxt ""
"par_id851535122363435\n"
"help.text"
msgid "System"
-msgstr ""
+msgstr "Systeem"
#: func_weeknum.xhp
msgctxt ""
@@ -56222,7 +56222,7 @@ msgctxt ""
"par_id691535122363437\n"
"help.text"
msgid "System 1"
-msgstr ""
+msgstr "Systeem 1"
#: func_weeknum.xhp
msgctxt ""
@@ -56230,7 +56230,7 @@ msgctxt ""
"par_id3147221\n"
"help.text"
msgid "The week containing January 1 is the first week of the year, and is numbered week 1."
-msgstr ""
+msgstr "De week die 1 januari bevat is de eerste week van het jaar en is weeknummer 1."
#: func_weeknum.xhp
msgctxt ""
@@ -56238,7 +56238,7 @@ msgctxt ""
"par_id741535122455285\n"
"help.text"
msgid "System 2"
-msgstr ""
+msgstr "Systeem 2"
#: func_weeknum.xhp
msgctxt ""
@@ -56246,7 +56246,7 @@ msgctxt ""
"par_id3147222\n"
"help.text"
msgid "The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday."
-msgstr ""
+msgstr "De week die de eerste donderdag van het jaar bevat is de eerste week van het jaar en is weeknummer 1. Dat betekent dat week 1 de week is van elk jaar waar 4 januari in zit. ISO 8601 definieert dit systeem en ook dat de week op maandag begint."
#: func_weeknum.xhp
msgctxt ""
@@ -56278,7 +56278,7 @@ msgctxt ""
"par_id961535122993923\n"
"help.text"
msgid "System"
-msgstr ""
+msgstr "Systeem"
#: func_weeknum.xhp
msgctxt ""
@@ -56286,7 +56286,7 @@ msgctxt ""
"par_id151535122633826\n"
"help.text"
msgid "Mode"
-msgstr ""
+msgstr "Modus"
#: func_weeknum.xhp
msgctxt ""
@@ -56294,7 +56294,7 @@ msgctxt ""
"par_id231535122633827\n"
"help.text"
msgid "Day of the week"
-msgstr ""
+msgstr "Dag van de week"
#: func_weeknum.xhp
msgctxt ""
@@ -56302,7 +56302,7 @@ msgctxt ""
"par_id531535124180000\n"
"help.text"
msgid "System 1"
-msgstr ""
+msgstr "Systeem 1"
#: func_weeknum.xhp
msgctxt ""
@@ -56310,7 +56310,7 @@ msgctxt ""
"par_id351535122633828\n"
"help.text"
msgid "Sunday"
-msgstr ""
+msgstr "zondag"
#: func_weeknum.xhp
msgctxt ""
@@ -56318,7 +56318,7 @@ msgctxt ""
"par_id591535122756686\n"
"help.text"
msgid "Monday"
-msgstr ""
+msgstr "maandag"
#: func_weeknum.xhp
msgctxt ""
@@ -56326,7 +56326,7 @@ msgctxt ""
"par_id881535122835126\n"
"help.text"
msgid "Monday"
-msgstr ""
+msgstr "maandag"
#: func_weeknum.xhp
msgctxt ""
@@ -56334,7 +56334,7 @@ msgctxt ""
"par_id241535122903569\n"
"help.text"
msgid "Tuesday"
-msgstr ""
+msgstr "dinsdag"
#: func_weeknum.xhp
msgctxt ""
@@ -56342,7 +56342,7 @@ msgctxt ""
"par_id31535124277973\n"
"help.text"
msgid "Wednesday"
-msgstr ""
+msgstr "woensdag"
#: func_weeknum.xhp
msgctxt ""
@@ -56350,7 +56350,7 @@ msgctxt ""
"par_id21535124310462\n"
"help.text"
msgid "Thursday"
-msgstr ""
+msgstr "donderdag"
#: func_weeknum.xhp
msgctxt ""
@@ -56358,7 +56358,7 @@ msgctxt ""
"par_id921535124365435\n"
"help.text"
msgid "Friday"
-msgstr ""
+msgstr "vrijdag"
#: func_weeknum.xhp
msgctxt ""
@@ -56366,7 +56366,7 @@ msgctxt ""
"par_id211535124416253\n"
"help.text"
msgid "Saturday"
-msgstr ""
+msgstr "zaterdag"
#: func_weeknum.xhp
msgctxt ""
@@ -56374,7 +56374,7 @@ msgctxt ""
"par_id461535124473824\n"
"help.text"
msgid "Sunday"
-msgstr ""
+msgstr "zondag"
#: func_weeknum.xhp
msgctxt ""
@@ -56382,7 +56382,7 @@ msgctxt ""
"par_id471535124489997\n"
"help.text"
msgid "System 2"
-msgstr ""
+msgstr "Systeem 2"
#: func_weeknum.xhp
msgctxt ""
@@ -56390,7 +56390,7 @@ msgctxt ""
"par_id391535124564520\n"
"help.text"
msgid "Monday (ISO 8601)"
-msgstr ""
+msgstr "maandag (ISO 8601)"
#: func_weeknum.xhp
msgctxt ""
@@ -56406,7 +56406,7 @@ msgctxt ""
"par_id3150704\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1"
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER(DATUM(1-1-1995);1)</item> geeft 1"
#: func_weeknum.xhp
msgctxt ""
@@ -56414,7 +56414,7 @@ msgctxt ""
"par_id3149792\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);2)</item> returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER(01-01-1995;2)</item> geeft 52 terug. Als de week op maandag begint, behoort zondag tot de laatste week van het vorige jaar."
#: func_weeknum.xhp
msgctxt ""
@@ -56422,7 +56422,7 @@ msgctxt ""
"par_id3149793\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);21)</item> returns 52. Week 1 starts on Monday, 1995-01-02."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER(DATUM(01-01-1995);21)</item> geeft 52. Week 1 start op maandag, 02-01-1995."
#: func_weeknum.xhp
msgctxt ""
@@ -56430,7 +56430,7 @@ msgctxt ""
"par_id3149794\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER(DATE(01-01-1990);21)</item> geeft 53. Week 1 start op maandag, 04-01-1999."
#: func_weeknum_ooo.xhp
msgctxt ""
@@ -56526,7 +56526,7 @@ msgctxt ""
"par_id3150704\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM_OOO(DATE(1995;1;1);1)</item> returns 1"
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER_OOO(DATUM(1-1-1995);1)</item> geeft 1"
#: func_weeknum_ooo.xhp
msgctxt ""
@@ -56534,7 +56534,7 @@ msgctxt ""
"par_id3149792\n"
"help.text"
msgid "<item type=\"input\">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts on Monday, 1995-01-02."
-msgstr ""
+msgstr "<item type=\"input\">=WEEKNUMMER_OOO(DATUM(01-01-1995);2)</item> geeft 52. Week 1 start op maandag, 02-01-1995."
#: func_weeknumadd.xhp
msgctxt ""
@@ -56654,7 +56654,7 @@ msgctxt ""
"par_id241020160008306838\n"
"help.text"
msgid "WORKDAY.INTL(StartDate; Days; Weekend; Holidays)"
-msgstr ""
+msgstr "WERKDAG.INTL(Begindatum; Dagen; Weekend; Vakantiedagen)"
#: func_workday.intl.xhp
msgctxt ""
@@ -56702,7 +56702,7 @@ msgctxt ""
"par_id241020160012177923\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3;;F3:J3)</item> returns January 11, 2017 in the result cell, say D6 (use date format for the cell)."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAGEN.INT(C3;D3;;F3:J3)</item> geeft 11 januari 2017 terug in de resultaatcel D6 (gebruik datumopmaakt voor deze cel)."
#: func_workday.intl.xhp
msgctxt ""
@@ -56718,7 +56718,7 @@ msgctxt ""
"par_id241020160012178562\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3;7;F3:J3)</item> returns January 15, 2017 with weekend parameter 7."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAG.INT(C3;D3;7;F3:J3)</item> geeft 15 januari 2017 met als weekendparameter 7."
#: func_workday.intl.xhp
msgctxt ""
@@ -56734,7 +56734,7 @@ msgctxt ""
"par_id241020160012181455\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3;11;F3:J3)</item> returns January 9, 2017."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAG.INT(C3;D3;\"0000001\";F3:J3)</item> geeft 9 januari 2017."
#: func_workday.intl.xhp
msgctxt ""
@@ -56750,7 +56750,7 @@ msgctxt ""
"par_id241020160012183680\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3;\"0000001\";F3:J3)</item> returns January 9, 2017."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAG.INT(C3;D3;\"0000001\";F3:J3)</item> geeft 9 januari 2017."
#: func_workday.intl.xhp
msgctxt ""
@@ -56766,7 +56766,7 @@ msgctxt ""
"par_id241020160012182048\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAG.INT(C3;D3)</item> geeft als resultaat: 10 januari 2017."
#: func_workday.intl.xhp
msgctxt ""
@@ -56878,7 +56878,7 @@ msgctxt ""
"par_id3146142\n"
"help.text"
msgid "<item type=\"input\">=WORKDAY(C3;D3;F3:J3)</item> returns 2001-12-28. Format the serial date number as a date, for example in the format YYYY-MM-DD."
-msgstr ""
+msgstr "<item type=\"input\">=WERKDAG(C3;D3;F3:J3)</item> geeft 28-12-2001 terug. Maak het seriële datumgetal op als een datum, bijvoorbeeld in de opmaak JJJJ-MM-DD."
#: func_workday.xhp
msgctxt ""
@@ -57110,7 +57110,7 @@ msgctxt ""
"par_id3154632\n"
"help.text"
msgid "<item type=\"input\">=YEARFRAC(\"2008-01-01\"; \"2008-07-01\";0)</item> returns 0.50."
-msgstr ""
+msgstr "<item type=\"input\">=JAAR.DEEL(\"01-01-2008\"; \"01-07-2008\";0)</item> geeft 0,50."
#: live_data_stream.xhp
msgctxt ""
@@ -59661,8 +59661,8 @@ msgctxt ""
"xml_source.xhp\n"
"hd_id240920171003006302\n"
"help.text"
-msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source (Experimental)</link>"
-msgstr ""
+msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source</link>"
+msgstr "<link href=\"text/scalc/01/xml_source.xhp\">XML-bron</link>"
#: xml_source.xhp
msgctxt ""
@@ -59686,7 +59686,7 @@ msgctxt ""
"par_id240920171007389295\n"
"help.text"
msgid "Choose <item type=\"menuitem\">Data - XML Source</item>."
-msgstr ""
+msgstr "Kies <item type=\"menuitem\">Gegevens – XML-bron...</item>"
#: xml_source.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/scalc/05.po b/source/nl/helpcontent2/source/text/scalc/05.po
index 1500a6b7e9e..0809acb400b 100644
--- a/source/nl/helpcontent2/source/text/scalc/05.po
+++ b/source/nl/helpcontent2/source/text/scalc/05.po
@@ -4,7 +4,7 @@ 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"
-"PO-Revision-Date: 2017-10-22 09:55+0000\n"
+"PO-Revision-Date: 2018-10-29 09:05+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -13,8 +13,8 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1508666110.000000\n"
+"X-Generator: Pootle 2.8\n"
+"X-POOTLE-MTIME: 1540803944.000000\n"
#: 02140000.xhp
msgctxt ""
@@ -750,7 +750,7 @@ msgctxt ""
"par_id291535142746121\n"
"help.text"
msgid "Case"
-msgstr ""
+msgstr "Geval"
#: empty_cells.xhp
msgctxt ""
@@ -758,7 +758,7 @@ msgctxt ""
"par_id441535142746121\n"
"help.text"
msgid "Formula"
-msgstr ""
+msgstr "Formule"
#: empty_cells.xhp
msgctxt ""
@@ -766,7 +766,7 @@ msgctxt ""
"par_id261535142746121\n"
"help.text"
msgid "Results and comments"
-msgstr ""
+msgstr "Resultaten en opmerkingen"
#: empty_cells.xhp
msgctxt ""
@@ -774,7 +774,7 @@ msgctxt ""
"par_id941535142746122\n"
"help.text"
msgid "A1: 1<br/>B1: <Empty>"
-msgstr ""
+msgstr "A1: 1<br/>B1: <Empty>"
#: empty_cells.xhp
msgctxt ""
@@ -782,7 +782,7 @@ msgctxt ""
"par_id851535142746123\n"
"help.text"
msgid "Displays 0"
-msgstr ""
+msgstr "Geeft 0 weer"
#: empty_cells.xhp
msgctxt ""
@@ -790,7 +790,7 @@ msgctxt ""
"par_id981535142948275\n"
"help.text"
msgid "<variable id=\"vtrue\">TRUE</variable>"
-msgstr ""
+msgstr "<variable id=\"vtrue\">WAAR</variable>"
#: empty_cells.xhp
msgctxt ""
@@ -798,7 +798,7 @@ msgctxt ""
"par_id1001535143031604\n"
"help.text"
msgid "TRUE (previously was FALSE)"
-msgstr ""
+msgstr "WAAR (was eerder ONWAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -806,7 +806,7 @@ msgctxt ""
"par_id201535143064244\n"
"help.text"
msgid "=ISNUMBER(B1)"
-msgstr ""
+msgstr "=ISGETAL(B1)"
#: empty_cells.xhp
msgctxt ""
@@ -814,7 +814,7 @@ msgctxt ""
"par_id421535143064245\n"
"help.text"
msgid "<variable id=\"vfalse\">FALSE</variable>"
-msgstr ""
+msgstr "<variable id=\"vfalse\">ONWAAR</variable>"
#: empty_cells.xhp
msgctxt ""
@@ -822,7 +822,7 @@ msgctxt ""
"par_id681535143124250\n"
"help.text"
msgid "=ISNUMBER(C1)"
-msgstr ""
+msgstr "=ISGETAL(C1)"
#: empty_cells.xhp
msgctxt ""
@@ -830,7 +830,7 @@ msgctxt ""
"par_id211535143124250\n"
"help.text"
msgid "FALSE (previously was TRUE)"
-msgstr ""
+msgstr "ONWAAR (was eerder WAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -838,7 +838,7 @@ msgctxt ""
"par_id221535143151829\n"
"help.text"
msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2))"
-msgstr ""
+msgstr "=ISGETAL(VERT.ZOEKEN(1;A1:C1;2))"
#: empty_cells.xhp
msgctxt ""
@@ -846,7 +846,7 @@ msgctxt ""
"par_id271535143151830\n"
"help.text"
msgid "FALSE (B1)"
-msgstr ""
+msgstr "ONWAAR (B1)"
#: empty_cells.xhp
msgctxt ""
@@ -854,7 +854,7 @@ msgctxt ""
"par_id861535143183196\n"
"help.text"
msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3))"
-msgstr ""
+msgstr "=ISGETAL(VERT.ZOEKEN(1;A1:C1;3))"
#: empty_cells.xhp
msgctxt ""
@@ -862,7 +862,7 @@ msgctxt ""
"par_id371535143183197\n"
"help.text"
msgid "FALSE (C1, previously was TRUE)"
-msgstr ""
+msgstr "ONWAAR (C1, was eerder WAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -870,7 +870,7 @@ msgctxt ""
"par_id191535143228538\n"
"help.text"
msgid "=ISTEXT(B1)"
-msgstr ""
+msgstr "=ISTEKST(B1)"
#: empty_cells.xhp
msgctxt ""
@@ -878,7 +878,7 @@ msgctxt ""
"par_id251535143279847\n"
"help.text"
msgid "=ISTEXT(C1)"
-msgstr ""
+msgstr "=ISTEKST(C1)"
#: empty_cells.xhp
msgctxt ""
@@ -886,7 +886,7 @@ msgctxt ""
"par_id641535143301636\n"
"help.text"
msgid "=ISTEXT(VLOOKUP(1;A1:C1;2))"
-msgstr ""
+msgstr "=ISTEKST(VERT.ZOEKEN(1;A1:C1;2))"
#: empty_cells.xhp
msgctxt ""
@@ -894,7 +894,7 @@ msgctxt ""
"par_id391535143301637\n"
"help.text"
msgid "FALSE (B1, previously was TRUE)"
-msgstr ""
+msgstr "ONWAAR (B1, was eerder WAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -902,7 +902,7 @@ msgctxt ""
"par_id661535143336012\n"
"help.text"
msgid "=ISTEXT(VLOOKUP(1;A1:C1;3))"
-msgstr ""
+msgstr "=ISTEKST(VERT.ZOEKEN(1;A1:C1;3))"
#: empty_cells.xhp
msgctxt ""
@@ -910,7 +910,7 @@ msgctxt ""
"par_id11535143336012\n"
"help.text"
msgid "FALSE (C1)"
-msgstr ""
+msgstr "ONWAAR (C1)"
#: empty_cells.xhp
msgctxt ""
@@ -918,7 +918,7 @@ msgctxt ""
"par_id661535143373396\n"
"help.text"
msgid "=ISBLANK(B1)"
-msgstr ""
+msgstr "=ISLEEG(B1)"
#: empty_cells.xhp
msgctxt ""
@@ -926,7 +926,7 @@ msgctxt ""
"par_id281535143396581\n"
"help.text"
msgid "=ISBLANK(C1)"
-msgstr ""
+msgstr "=ISLEEG(C1)"
#: empty_cells.xhp
msgctxt ""
@@ -934,7 +934,7 @@ msgctxt ""
"par_id31535143422248\n"
"help.text"
msgid "=ISBLANK(VLOOKUP(1;A1:C1;2))"
-msgstr ""
+msgstr "=ISLEEG(VERT.ZOEKEN(1;A1:C1;2))"
#: empty_cells.xhp
msgctxt ""
@@ -942,7 +942,7 @@ msgctxt ""
"par_id871535143422248\n"
"help.text"
msgid "TRUE (B1, previously was FALSE)"
-msgstr ""
+msgstr "WAAR (B1, was eerder ONWAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -950,7 +950,7 @@ msgctxt ""
"par_id731535143454577\n"
"help.text"
msgid "=ISBLANK(VLOOKUP(1;A1:C1;3))"
-msgstr ""
+msgstr "=ISLEEG(VERT.ZOEKEN(1;A1:C1;3))"
#: empty_cells.xhp
msgctxt ""
@@ -958,7 +958,7 @@ msgctxt ""
"par_id941535143454577\n"
"help.text"
msgid "FALSE (C1)"
-msgstr ""
+msgstr "ONWAAR (C1)"
#: empty_cells.xhp
msgctxt ""
@@ -974,7 +974,7 @@ msgctxt ""
"par_id251535143557533\n"
"help.text"
msgid "Case"
-msgstr ""
+msgstr "Geval"
#: empty_cells.xhp
msgctxt ""
@@ -982,7 +982,7 @@ msgctxt ""
"par_id441535143557533\n"
"help.text"
msgid "Formula"
-msgstr ""
+msgstr "Formule"
#: empty_cells.xhp
msgctxt ""
@@ -990,7 +990,7 @@ msgctxt ""
"par_id481535143557533\n"
"help.text"
msgid "Results and comments"
-msgstr ""
+msgstr "Resultaten en opmerkingen"
#: empty_cells.xhp
msgctxt ""
@@ -998,7 +998,7 @@ msgctxt ""
"par_id311535143557534\n"
"help.text"
msgid "A1: <Empty>"
-msgstr ""
+msgstr "A1: <Empty>"
#: empty_cells.xhp
msgctxt ""
@@ -1006,7 +1006,7 @@ msgctxt ""
"par_id961535143557535\n"
"help.text"
msgid "Displays 0, but is just a reference to an empty cell."
-msgstr ""
+msgstr "Geeft 0 weer, maar is slechts een verwijzing naar een lege cel"
#: empty_cells.xhp
msgctxt ""
@@ -1014,7 +1014,7 @@ msgctxt ""
"par_id441535143762523\n"
"help.text"
msgid "=ISNUMBER(A1)"
-msgstr ""
+msgstr "=ISGETAL(A1)"
#: empty_cells.xhp
msgctxt ""
@@ -1022,7 +1022,7 @@ msgctxt ""
"par_id751535143810734\n"
"help.text"
msgid "=ISTEXT(A1)"
-msgstr ""
+msgstr "=ISTEKST(A1)"
#: empty_cells.xhp
msgctxt ""
@@ -1030,7 +1030,7 @@ msgctxt ""
"par_id121535143920008\n"
"help.text"
msgid "=ISNUMBER(B1)"
-msgstr ""
+msgstr "=ISGETAL(B1)"
#: empty_cells.xhp
msgctxt ""
@@ -1038,7 +1038,7 @@ msgctxt ""
"par_id391535143920009\n"
"help.text"
msgid "FALSE (Microsoft Excel: TRUE)"
-msgstr ""
+msgstr "ONWAAR (Microsoft Excel: WAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -1046,7 +1046,7 @@ msgctxt ""
"par_id371535143961386\n"
"help.text"
msgid "=ISTEXT(B1)"
-msgstr ""
+msgstr "=ISTEKST(B1)"
#: empty_cells.xhp
msgctxt ""
@@ -1054,7 +1054,7 @@ msgctxt ""
"par_id111535144016852\n"
"help.text"
msgid "TRUE (Microsoft Excel: FALSE)"
-msgstr ""
+msgstr "WAAR (Microsoft-Excel: ONWAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -1062,7 +1062,7 @@ msgctxt ""
"par_id771535144043975\n"
"help.text"
msgid "C1: =VLOOKUP(...) with empty cell result"
-msgstr ""
+msgstr "C1: =VERT.ZOEKEN(...) met een lege cel als resultaat"
#: empty_cells.xhp
msgctxt ""
@@ -1070,7 +1070,7 @@ msgctxt ""
"par_id311535144043975\n"
"help.text"
msgid "displays empty (Microsoft Excel: displays 0)"
-msgstr ""
+msgstr "geeft leeg weer (Microsoft Excel: geeft 0 weer)"
#: empty_cells.xhp
msgctxt ""
@@ -1078,7 +1078,7 @@ msgctxt ""
"par_id761535144080504\n"
"help.text"
msgid "=ISNUMBER(VLOOKUP(...))"
-msgstr ""
+msgstr "=ISGETAL(VERT.ZOEKEN(...))"
#: empty_cells.xhp
msgctxt ""
@@ -1086,7 +1086,7 @@ msgctxt ""
"par_id11535144101388\n"
"help.text"
msgid "=ISTEXT(VLOOKUP(...))"
-msgstr ""
+msgstr "=ISTEKST(VERT.ZOEKEN(...))"
#: empty_cells.xhp
msgctxt ""
@@ -1094,7 +1094,7 @@ msgctxt ""
"par_id131535144123734\n"
"help.text"
msgid "=ISNUMBER(C1)"
-msgstr ""
+msgstr "=ISGETAL(C1)"
#: empty_cells.xhp
msgctxt ""
@@ -1102,7 +1102,7 @@ msgctxt ""
"par_id151535144123735\n"
"help.text"
msgid "FALSE (Microsoft Excel: TRUE)"
-msgstr ""
+msgstr "ONWAAR (Microsoft Excel: WAAR)"
#: empty_cells.xhp
msgctxt ""
@@ -1110,4 +1110,4 @@ msgctxt ""
"par_id981535144159183\n"
"help.text"
msgid "=ISTEXT(C1)"
-msgstr ""
+msgstr "=ISTEKST(C1)"
diff --git a/source/nl/helpcontent2/source/text/scalc/guide.po b/source/nl/helpcontent2/source/text/scalc/guide.po
index 6fa613cf239..fd819662971 100644
--- a/source/nl/helpcontent2/source/text/scalc/guide.po
+++ b/source/nl/helpcontent2/source/text/scalc/guide.po
@@ -4,7 +4,7 @@ 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"
-"PO-Revision-Date: 2018-06-19 08:21+0000\n"
+"PO-Revision-Date: 2018-10-29 09:00+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -13,8 +13,8 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1529396498.000000\n"
+"X-Generator: Pootle 2.8\n"
+"X-POOTLE-MTIME: 1540803657.000000\n"
#: address_auto.xhp
msgctxt ""
@@ -4814,7 +4814,7 @@ msgctxt ""
"bm_id3149456\n"
"help.text"
msgid "<bookmark_value>copying;values, to multiple sheets</bookmark_value><bookmark_value>pasting;values in multiple sheets</bookmark_value><bookmark_value>data;inserting in multiple sheets</bookmark_value><bookmark_value>sheets; simultaneous multiple filling</bookmark_value>"
-msgstr ""
+msgstr "<bookmark_value>kopiëren;waarden, naar meerdere bladen</bookmark_value><bookmark_value>plakken;waarden in meerdere bladen</bookmark_value><bookmark_value>gegevens;invoegen in meerdere bladen</bookmark_value><bookmark_value>bladen; meerdere gelijktijdig vullen</bookmark_value>"
#: edit_multitables.xhp
msgctxt ""
@@ -4822,7 +4822,7 @@ msgctxt ""
"hd_id3149456\n"
"help.text"
msgid "<variable id=\"edit_multitables\"><link href=\"text/scalc/guide/edit_multitables.xhp\" name=\"Copying to Multiple Sheets\">Copying to Multiple Sheets</link></variable>"
-msgstr ""
+msgstr "<variable id=\"edit_multitables\"><link href=\"text/scalc/guide/edit_multitables.xhp\" name=\"Naar meerdere bladen kopiëren\">Naar meerdere bladen kopiëren</link></variable>"
#: edit_multitables.xhp
msgctxt ""
@@ -4838,7 +4838,7 @@ msgctxt ""
"par_id3153768\n"
"help.text"
msgid "Select all desired sheets by holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white."
-msgstr ""
+msgstr "Selecteer alle gewenste bladen door de <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline>-toets ingedrukt te houden en te klikken op de betreffende bladtabs, die nog steeds grijs zijn aan de onderzijde van de werkruimte. Alle geselecteerde bladtabs zijn nu wit."
#: edit_multitables.xhp
msgctxt ""
@@ -4854,7 +4854,7 @@ msgctxt ""
"par_id3147435\n"
"help.text"
msgid "Now when you insert values, text or formulas into the active sheet, they will also appear in the identical positions in the other selected sheets. For example, data entered in cell \"A1\" of the active sheet is automatically entered into cell \"A1\" of any other selected sheet."
-msgstr ""
+msgstr "Wanneer u nu waarden, tekst of formules invoegt in het actieve werkblad, zullen die ook verschijnen op de identieke posities in de andere geselecteerde werkbladen. Gegevens die bijvoorbeeld worden ingevoegd in cel \"A1\" van het actieve werkblad worden automatisch ingevoegd in cel \"A1\" van elk ander geselecteerd werkblad."
#: filters.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/00.po b/source/nl/helpcontent2/source/text/shared/00.po
index 996c825252b..6adf0d45e33 100644
--- a/source/nl/helpcontent2/source/text/shared/00.po
+++ b/source/nl/helpcontent2/source/text/shared/00.po
@@ -4,7 +4,7 @@ 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"
-"PO-Revision-Date: 2018-07-24 10:15+0000\n"
+"PO-Revision-Date: 2018-10-29 09:14+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -14,7 +14,7 @@ msgstr ""
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1532427330.000000\n"
+"X-POOTLE-MTIME: 1540804452.000000\n"
#: 00000001.xhp
msgctxt ""
@@ -78,7 +78,7 @@ msgctxt ""
"par_id3149783\n"
"help.text"
msgid "By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the <emph>Close Window</emph> icon. Make the toolbar visible again by choosing <emph>View - Toolbars - (toolbar name)</emph>."
-msgstr ""
+msgstr "Als u op de pijl naast een pictogram klikt, wordt een werkbalk geopend. Als u een werkbalk wilt verplaatsen, sleept u de titelbalk. Zodra u de muisknop loslaat, blijft de werkbalk op de nieuwe positie aanwezig. Sleep de titelbalk naar een andere positie of sleep de werkbalk naar de rand van het venster, zodat de werkbalk wordt vastgezet. U kunt een werkbalk sluiten door op het pictogram <emph>Venster sluiten</emph> te klikken. U kunt de werkbalk opnieuw weergeven via <emph>Beeld - Werkbalken - (Naam van werkbalk)</emph>."
#: 00000001.xhp
msgctxt ""
@@ -102,7 +102,7 @@ msgctxt ""
"par_id7493209\n"
"help.text"
msgid "In the <emph>Basic IDE</emph>, a spin button is the name used for the numerical field together with the two arrow symbols."
-msgstr ""
+msgstr "In de <emph>Basic-IDE</emph> is een draaiknop de naam, die gebruikt wordt voor een numeriek veld tezamen met de twee pijlsymbolen."
#: 00000001.xhp
msgctxt ""
@@ -150,7 +150,7 @@ msgctxt ""
"par_id3156553\n"
"help.text"
msgid "<variable id=\"context\">To activate the context menu of an object, first click the object with the <switchinline select=\"sys\"><caseinline select=\"MAC\"></caseinline><defaultinline>left</defaultinline></switchinline> mouse button to select it, and then, <switchinline select=\"sys\"><caseinline select=\"MAC\">while holding down the <emph>Ctrl</emph> key or the <emph>Command</emph> and <emph>Option</emph> keys, click the mouse button again</caseinline><defaultinline> click the right mouse button</defaultinline></switchinline>. Some context menus can be called even if the object has not been selected. Context menus are found just about everywhere in $[officename].</variable>"
-msgstr ""
+msgstr "<variable id=\"context\">Als u het contextmenu van een object wilt activeren, klikt u eerst met de <switchinline select=\"sys\"><caseinline select=\"MAC\"></caseinline><defaultinline>linker</defaultinline></switchinline>muisknop op het object om dit te selecteren. Houd vervolgens de <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Ctrl</emph>-toets of de <emph>Command-</emph> en <emph>Option</emph>-toetsen ingedrukt, klik nogmaals met de muisknop en </caseinline><defaultinline>klik met de rechter muisknop</defaultinline></switchinline>. Sommige contextmenu's kunnen, zelfs als het object niet is geselecteerd, worden opgeroepen. Contextmenu's zijn bijna overal in $[officename] aanwezig.</variable>"
#: 00000001.xhp
msgctxt ""
@@ -198,7 +198,7 @@ msgctxt ""
"par_id3145345\n"
"help.text"
msgid "You can enter values in the input fields in different <link href=\"text/shared/00/00000003.xhp#metrik\" name=\"units of measurement\">units of measurement</link>. The default unit is inches. However, if you want a space of exactly 1 cm, then type \"1cm\". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value."
-msgstr ""
+msgstr "U kunt waarden in verschillende <link href=\"text/shared/00/00000003.xhp#metrik\" name=\"units of measurement\">maateenheden</link> invoeren in de invoervelden. De standaardeenheid is inches. Als u echter een spatie wilt van precies 1 cm, voert u 1 cm in. Aanvullende eenheden zijn beschikbaar volgens de context, bijvoorbeeld 12 pt voor een 12-punts spatiegrootte. Als de waarde van de nieuwe eenheid niet realistisch is, gebruikt het programma een voorgedefinieerde maximum- of minimumwaarde."
#: 00000001.xhp
msgctxt ""
@@ -262,7 +262,7 @@ msgctxt ""
"par_id3153087\n"
"help.text"
msgid "<ahelp hid=\".\">Click the <emph>Shrink</emph> icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the <emph>Maximize</emph> icon. Click it to restore the dialog to its original size.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Klik op het pictogram <emph>Verkleinen</emph> om de grootte van het dialoogvenster aan te passen aan de grootte van het invoerveld. U kunt dan de benodigde verwijzing in het blad gemakkelijker markeren. De pictogrammen worden vervolgens automatisch omgezet naar het pictogram <emph>Maximaliseren</emph>. Klik op dit pictogram om de oorspronkelijke grootte van het dialoogvenster te herstellen.</ahelp>"
#: 00000001.xhp
msgctxt ""
@@ -278,7 +278,7 @@ msgctxt ""
"par_id3157808\n"
"help.text"
msgid "<image id=\"img_id3148685\" src=\"formula/res/refinp1.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3148685\">Icon</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3148685\" src=\"formula/res/refinp1.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3148685\">Pictogram</alt></image>"
#: 00000001.xhp
msgctxt ""
@@ -294,7 +294,7 @@ msgctxt ""
"par_id3153349\n"
"help.text"
msgid "<image id=\"img_id3149784\" src=\"formula/res/refinp2.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3149784\">Icon</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3149784\" src=\"formula/res/refinp2.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3149784\">Pictogram</alt></image>"
#: 00000001.xhp
msgctxt ""
@@ -334,7 +334,7 @@ msgctxt ""
"par_id3152473\n"
"help.text"
msgid "<ahelp hid=\".\">Click the <emph>Next</emph> button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes <emph>Create</emph>.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Klik op de knop <emph>Volgende</emph>, waarna de huidige instellingen in het dialoogvenster in de Assistent worden gebruikt en wordt doorgegaan met de volgende stap. Als u bij de laatste stap bent, wordt deze knop gewijzigd in <emph>Maken</emph>.</ahelp>"
#: 00000001.xhp
msgctxt ""
@@ -446,7 +446,7 @@ msgctxt ""
"par_id3154331\n"
"help.text"
msgid "A confirmation query does not appear. If you confirm the dialog with <emph>OK</emph> all settings in this dialog are reset."
-msgstr ""
+msgstr "Er verschijnt geen bevestigingsvenster. Als u in het dialoogvenster op <emph>OK</emph> klikt, worden alle instellingen in het dialoogvenster hersteld."
#: 00000001.xhp
msgctxt ""
@@ -518,7 +518,7 @@ msgctxt ""
"par_id3147418\n"
"help.text"
msgid "<variable id=\"regulaer\">The search supports <link href=\"text/shared/01/02100001.xhp\" name=\"regular expressions\">regular expressions</link>. You can enter \"all.*\", for example to find the first location of \"all\" followed by any characters. If you want to search for a text that is also a regular expression, you must precede every character with a \"\\\" character. You can switch the automatic evaluation of regular expression on and off in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - </emph><link href=\"text/shared/optionen/01060500.xhp\"><emph>%PRODUCTNAME Calc - Calculate</emph></link>.</variable>"
-msgstr ""
+msgstr "<variable id=\"regulaer\">Zoeken ondersteunt <link href=\"text/shared/01/02100001.xhp\" name=\"reguliere uitdrukkingen\">reguliere uitdrukkingen</link>. U kunt bijvoorbeeld \"all.*\", invoeren om de eerste locatie van \"all\" te vinden, gevolgd door willekeurige tekens. Als u wilt zoeken naar een tekst die ook een reguliere uitdrukking is, moet u elk teken vooraf laten gaan door het teken \"\\\". U kunt de automatische evaluatie van reguliere uitdrukkingen in- en uitschakelen in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Voorkeuren</emph></caseinline><defaultinline><emph>Extra - Opties</emph></defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\"><emph>%PRODUCTNAME Calc - Berekenen</emph></link>.</variable>"
#: 00000001.xhp
msgctxt ""
@@ -550,7 +550,7 @@ msgctxt ""
"par_id9345377\n"
"help.text"
msgid "<variable id=\"ShiftF1\">Press <emph>Shift+F1</emph> and point to a control to learn more about that control.</variable>"
-msgstr ""
+msgstr "<variable id=\"ShiftF1\">Druk op <emph>Shift+F1</emph> en wijs een besturingselement aan om meer te weten te komen over dat besturingselement.</variable>"
#: 00000001.xhp
msgctxt ""
@@ -598,7 +598,7 @@ msgctxt ""
"par_id261527693436801\n"
"help.text"
msgid "Some options cannot be reset once edited. Either edit back the changes manually or click <emph>Cancel</emph> and reopen the <emph>Options</emph> dialog."
-msgstr ""
+msgstr "Sommige opties kunnen niet worden hersteld nadat ze zijn bewerkt. Bewerk de wijzigingen handmatig of klik op <emph>Annuleren</emph> en open het dialoogvenster <emph>Opties</emph> opnieuw."
#: 00000002.xhp
msgctxt ""
@@ -4782,7 +4782,7 @@ msgctxt ""
"par_id3156326\n"
"help.text"
msgid "<ahelp hid=\"modules/scalc/ui/textimportcsv/textdelimiter\">Select a character to delimit text data. You can also enter a character in the text box.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"modules/scalc/ui/textimportcsv/textdelimiter\">Selecteer een teken om tekstgegevens af te bakenen. U kunt ook een teken in het tekstvak invoeren.</ahelp>"
#: 00000208.xhp
msgctxt ""
@@ -6854,7 +6854,7 @@ msgctxt ""
"par_id3150749\n"
"help.text"
msgid "On the <emph>Form Design</emph> bar, click <emph>Record Search</emph> icon, then <emph>Similarity search</emph> check box,<br/>then click the <emph>Similarities</emph> button (form view)."
-msgstr ""
+msgstr "Klik op de werkbalk <emph>Formulierontwerp</emph> op het pictogram <emph>Zoeken naar record</emph>, dan op het selectievakje <emph>Overeenkomsten zoeken</emph> en klik dan op de knop <emph>Overeenkomsten</emph> (formulierweergave)."
#: 00000402.xhp
msgctxt ""
@@ -6862,7 +6862,7 @@ msgctxt ""
"par_id3152960\n"
"help.text"
msgid "Choose <emph>View - Navigator</emph>."
-msgstr ""
+msgstr "Kies <emph>Beeld - Navigator</emph>."
#: 00000402.xhp
msgctxt ""
@@ -6894,7 +6894,7 @@ msgctxt ""
"par_id3147338\n"
"help.text"
msgid "<variable id=\"litdat\">Choose <emph>Tools - Bibliography Database</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"litdat\">Kies <emph>Extra - Literatuurlijstdatabase</emph>.</variable>"
#: 00000402.xhp
msgctxt ""
@@ -6902,7 +6902,7 @@ msgctxt ""
"par_id3149281\n"
"help.text"
msgid "<variable id=\"link\">Choose <emph>Edit - Links</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"link\">Kies <emph>Bewerken - Koppelingen</emph>.</variable>"
#: 00000402.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/01.po b/source/nl/helpcontent2/source/text/shared/01.po
index 9dbaf5d45d8..691138b6806 100644
--- a/source/nl/helpcontent2/source/text/shared/01.po
+++ b/source/nl/helpcontent2/source/text/shared/01.po
@@ -3,8 +3,8 @@ 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"
-"PO-Revision-Date: 2018-06-19 08:32+0000\n"
+"POT-Creation-Date: 2018-11-12 12:22+0100\n"
+"PO-Revision-Date: 2018-11-11 11:56+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: nl\n"
@@ -14,7 +14,7 @@ msgstr ""
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1529397156.000000\n"
+"X-POOTLE-MTIME: 1541937418.000000\n"
#: 01010000.xhp
msgctxt ""
@@ -5094,7 +5094,7 @@ msgctxt ""
"hd_id3147291\n"
"help.text"
msgid "separated by"
-msgstr "gescheiden door"
+msgstr "Gescheiden door"
#: 01160300.xhp
msgctxt ""
@@ -37968,6 +37968,110 @@ msgctxt ""
msgid "<link href=\"text/shared/01/packagemanager.xhp\">Extension Manager</link>"
msgstr "<link href=\"text/shared/01/packagemanager.xhp\">Extensiebeheer</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>invoegen;films/geluiden</bookmark_value><bookmark_value>geluisdsbestanden</bookmark_value><bookmark_value>film- en geluidsbestanden afspelen</bookmark_value><bookmark_value>video's</bookmark_value><bookmark_value>films</bookmark_value> <bookmark_value>audio</bookmark_value><bookmark_value>muziek</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,16 +39213,16 @@ 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>."
-msgstr "Kies <emph>Invoegen - Media - Audio of video</emph>. Voor %PRODUCTNAME Impress, kies <emph>Invoegen - Audio of video</emph>."
+msgid "Choose <emph>Insert - Media - Audio or Video</emph>. For %PRODUCTNAME Impress, choose <emph>Insert - Audio or Video</emph>."
+msgstr ""
#: moviesound.xhp
msgctxt ""
"moviesound.xhp\n"
"par_idN10696\n"
"help.text"
-msgid "In the File Open dialog, select the file that you want to insert."
-msgstr "Selecteer het gewenste bestand in het dialoogvenster Bestand openen."
+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 "Als alternatief kunt u <item type=\"menuitem\">Extra - Mediaspeler</item> kiezen om de Mediaspeler te openen. Gebruik de Mediaspeler om voorbeelden weer te geven van alle ondersteunde mediabestanden. Klik op de knop Toepassen in het venster Mediaspeler om het huidige mediabestand in uw document in te voegen."
+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 "Als het pictogram op de achtergrond is geschikt, houdt dan Ctrl ingedrukt terwijl u klikt."
+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 "U kunt ook de balk Media afspelen gebruiken om het afspelen te pauzeren, te stoppen of te herhalen, en het volume bij te stellen of het geluid te dempen. De huidige afspeelpositie in het bestand wordt aangegeven door de linker schuifregelaar. Gebruik de rechter schuifregelaar om het volume bij te stellen. Voor filmbestanden bevat de werkbalk ook een keuzelijst waarin u de zoomfactor voor afspelen kunt selecteren."
+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,16 +39333,16 @@ 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>)."
-msgstr "<emph>Voor Microsoft Windows</emph>: %PRODUCTNAME kan eender wat openen waarvoor <emph>DirectShow</emph> filters geïnstalleerd werden (<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">lijst met standaard formaten</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
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>)."
-msgstr "<emph>Voor GNU/Linux</emph>: %PRODUCTNAME gebruikt <emph>gstreamer</emph>, zo wat u ook speelt met gstreamer kan gebruikt worden met %PRODUCTNAME (<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">lijst met gedefinieerde 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
msgctxt ""
@@ -39253,16 +39357,16 @@ 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>."
-msgstr "<link href=\"http://msdn.microsoft.com/en-us/library/ms787745%28VS.85%29.aspx\" name=\"linkname\">Lijst met standaard formaten voor 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
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>."
-msgstr "<link href=\"http://gstreamer.freedesktop.org/data/doc/gstreamer/head/pwg/html/section-types-definitions.html\" name=\"linkname\">Lijst met gedefinieerde types voor 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
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/02.po b/source/nl/helpcontent2/source/text/shared/02.po
index 02c6013c19e..12e0dbaf336 100644
--- a/source/nl/helpcontent2/source/text/shared/02.po
+++ b/source/nl/helpcontent2/source/text/shared/02.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-07 12:46+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
"PO-Revision-Date: 2018-06-19 08:34+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -885,8 +885,8 @@ msgctxt ""
"01170000.xhp\n"
"par_id3149123\n"
"help.text"
-msgid "<ahelp hid=\".uno:RadioButton\">Creates an option button.</ahelp> Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (<link href=\"text/shared/02/01170101.xhp\" name=\"Name\"><emph>Name</emph></link><emph>property</emph>). Normally, they are given a <link href=\"text/shared/02/01170000.xhp\" name=\"group box\">group box</link>."
-msgstr "<ahelp hid=\".uno:RadioButton\">Maakt een keuzerondje.</ahelp> Keuzerondjes laten de gebruiker één van meerdere keuzes kiezen. Keuzerondjes met dezelfde functionaliteit krijgen dezelfde naam (<emph>eigenschap</emph> <link href=\"text/shared/02/01170101.xhp\" name=\"Naam\"> <emph>Naam</emph></link>). Normaal gesproken krijgen zij een <link href=\"text/shared/02/01170000.xhp\" name=\"groepsvak\">groepsvak</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\">Pictogram</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/nl/helpcontent2/source/text/shared/explorer/database.po b/source/nl/helpcontent2/source/text/shared/explorer/database.po
index 7e11c1664a5..9b15b3826b4 100644
--- a/source/nl/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/nl/helpcontent2/source/text/shared/explorer/database.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-16 16:54+0200\n"
+"POT-Creation-Date: 2018-11-05 17:38+0100\n"
"PO-Revision-Date: 2018-06-19 08:34+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1529397261.000000\n"
#: 02000000.xhp
@@ -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 "Een \"query\" is een speciale weergave van een tabel. Een query kan bepaalde records of bepaalde velden uit records weergegeven; het kan deze records ook sorteren. Een query kan van toepassing zijn op één tabel of op meerdere tabellen, als deze zijn gekoppeld door gemeenschappelijke gegevensvelden."
+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 "In het onderste gedeelte van het ontwerpvenster kunt u de query <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"definiëren\">definiëren</link>. Als u een query wilt definiëren, geeft u aan welke <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"veldnamen\">veldnamen</link> van de database moeten worden opgenomen en welke <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> voor de weergave van velden u wilt gebruiken. Als u de kolommen in het onderste gedeelte van het ontwerpvenster opnieuw wilt schikken, sleept u de gewenste kolomkop naar de nieuwe locatie of selecteert u de gewenste kolom en drukt u op <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+pijltoets."
+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 "Als u bijvoorbeeld een werkblad hebt met artikelen waarbij elk artikel is voorzien van een artikelnummer en u een werkblad hebt met klanten waarin u bijhoudt welke klant welke artikelen heeft besteld, bestaat er een relatie tussen beide \"artikelnummers\". Wanneer u nu een query wilt maken die alle artikelen voor een bepaalde klant laat zien, dan moet u gegevens uit twee werkbladen halen. Stel in $[officename] in wat de relatie tussen de twee werkbladen is om dit te doen."
+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 "Wanneer u dit wilt doen, klikt u in een tabel op een veldnaam (bijvoorbeeld de veldnaam 'Itemnummer' in de tabel Klant), houdt u de muisknop ingedrukt en sleept u de veldnaam naar de veldnaam van de andere tabel (bijvoorbeeld 'Itemnummer' in de tabel Item). Wanneer u de muisknop loslaat, verschijnt er een lijn die de twee velden in de twee vensters met elkaar verbindt. De overeenkomstige voorwaarde dat de inhoud van de twee velden gelijk moet zijn, wordt in de resulterende SQL-query opgenomen."
+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 "Verbindingseigenschappen opgeven"
+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 "Als u dubbelklikt op de regel die twee gekoppelde velden verbindt of als u de menuopdracht <emph>Invoegen - Nieuwe relatie</emph> oproept, kunt u het type koppeling in het dialoogvenster <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relaties\"><emph>Relaties</emph></link> specificeren."
+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 "Query definiëren"
+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 "Velden opgeven"
+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 "Selecteer eerst alle velden die u in de query wilt weergeven. U kunt dit doen door te slepen met de muis of door te dubbelklikken op de veldnaam in het tabeloverzicht. Met slepen en neerzetten gebruikt u de muis om een veldnaam van het tabeloverzicht naar een kolom in het onderste gedeelte van het query-ontwerp te slepen. U kunt hierbij de veldnaam naar elke gewenste kolom slepen. Selecteer een veldnaam door erop te dubbelklikken. Het veld wordt vervolgens toegevoegd aan de volgende lege kolom."
+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 "Query opslaan"
+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 "Klik op het pictogram <emph>Opslaan</emph> op de werkbalk Standaard om de query op te slaan. Er verschijnt een dialoogvenster waarin u de naam voor de query invoert. Als de database schema's ondersteunt, kunt u tevens schema's opgeven."
+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 "Stel de gewenste voorkeuren in het onderste gebied van de ontwerpweergave in om gegevens voor de query te filteren. De volgende opties zijn hier mogelijk:"
+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\">Voer hier de naam van het gegevensveld in waarnaar u in de query hebt verwezen. Alle instellingen in de onderste rijen verwijzen naar dit veld.</ahelp> Als u een cel activeert door er met de muis in te klikken, ziet u een pijltjesknop. Hiermee kunt u een veld selecteren. De optie 'Tabelnaam.*' selecteert alle gegevensvelden en de criteria gelden dan ook voor alle velden."
+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\">Een alias opgeven. In plaats van de veldnaam wordt deze alias in de query weergegeven. Hierdoor wordt het mogelijk eigen kolomnamen te gebruiken.</ahelp> Als het gegevensveld in de tabel bijvoorbeeld de naam ArtikelNr heeft en u in plaats van deze naam de naam ArtikelNummer in de query wilt gebruiken, vult u bij alias ArtikelNummer in."
+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 "In een SQL-instructie wordt een alias als volgt gedefinieerd:"
+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\">De corresponderende databasetabel van het geselecteerde gegevensveld wordt hier weergegeven.</ahelp> Als u een cel met een muisklik activeert, verschijnt er een pijl waarmee u een andere tabel van de huidige query kunt selecteren."
+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\">Als u op de cel klikt, kunt u de sorteeropties selecteren: Oplopend, Aflopend en Niet gesorteerd.</ahelp> Tekstvelden worden alfabetisch gesorteerd en numerieke velden worden numeriek gesorteerd. Voor de meeste databases kunnen beheerders sorteeropties instellen."
+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\">Als u de eigenschap <emph>Zichtbaar</emph> voor een gegevensveld markeert, wordt dat veld afgebeeld in de query</ahelp>. Als u een gegevensveld alleen gebruikt voor het maken van een voorwaarde, hoeft dit veld niet per se te worden afgebeeld."
+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\">De <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>opgeven op basis waarvan de inhoud van het gegevensveld moet worden gefilterd.</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 "Hier kunt u in elke regel een aanvullend filtercriterium invullen. Meerdere criteria in een kolom worden verbonden via een OF-koppeling."
+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 "U kunt ook het contextmenu van de regelnamen in het onderste gedeelte van het query-ontwerpvenster gebruiken om een extra regel voor functies in te voegen:"
+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\">Selecteer de functie die in de query moet worden uitgevoerd.</ahelp> Welke functies u kunt selecteren, is afhankelijk van de database."
+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 "Als u met de HSQL-database werkt, bevat de keuzelijst in de rij <emph>Functie</emph> de volgende opties:"
+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 "Optie"
#: 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 "Gemiddelde"
#: 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 "Aantal"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3154260\n"
-"help.text"
-msgid "COUNT"
-msgstr "AANTAL"
-
-#: 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 "Bepaalt het aantal records in de tabel. Lege velden kunnen wel (a) of niet (b) worden geteld."
+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(kolom): Door de naam van een veld op te geven als argument, worden alleen die velden geteld die een waarde bevatten. Nulwaarden (lege velden) worden dus niet geteld."
+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 "Maximum"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3148840\n"
-"help.text"
-msgid "MAX"
-msgstr "MAX"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3159221\n"
"help.text"
-msgid "Determines the highest value of a field."
-msgstr "Bepaalt de hoogste waarde van een veld."
+msgid "Determines the highest value of a record for that field."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1083,18 +1051,10 @@ msgstr "Minimum"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3148604\n"
-"help.text"
-msgid "MIN"
-msgstr "MIN"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3157982\n"
"help.text"
-msgid "Determines the lowest value of a field."
-msgstr "Bepaalt de laagste waarde van een veld."
+msgid "Determines the lowest value of a record for that field."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1107,18 +1067,10 @@ msgstr "Som"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3147070\n"
-"help.text"
-msgid "SUM"
-msgstr "SUM"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3154536\n"
"help.text"
-msgid "Calculates the sum of values of associated fields."
-msgstr "Berekent de som van de waarden van de bijbehorende velden."
+msgid "Calculates the sum of the values of records for the associated fields."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1131,18 +1083,10 @@ msgstr "Groeperen"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3145375\n"
-"help.text"
-msgid "GROUP BY"
-msgstr "Groeperen"
-
-#: 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 "Groepeert querygegevens volgens de opgegeven veldnaam. Functies worden uitgevoerd volgens de opgegeven groepen. In SQL correspondeert dit met de GROUP BY-clausule. Wanneer een criterium wordt toegevoegd, wordt dit weergegeven in de opdracht 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 "Behalve de functie <emph>Groeperen</emph> zijn de bovenstaande functies zogenaamde verzamelfuncties. Dit zijn functies die gegevens berekenen om een overzicht van de resultaten te creëren. Er zijn ook nog functies mogelijk die niet in de lijst voorkomen. Deze zijn afhankelijk van het specifieke databasesysteem dat u gebruikt en de huidige status van het stuurprogramma van 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 "U moet, om andere functies, die niet zijn opgesomd in de keuzelijst, te gebruiken, die invoeren onder <emph>Veld</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 "U kunt ook een alias aan een functie-oproep toewijzen. Als de query niet in de kolomkop moet worden weergegeven, kunt u de gewenste naam onder <emph>Alias</emph> invoeren."
+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 "Als u deze functie uitvoert, kunt u geen extra kolommen aan de query toevoegen, anders dan deze kolommen als een groeperingsfunctie te ontvangen."
+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 "Dubbelklik op het veld \"Item_Nr\" van de \"item\"-tabel. Geef de regel <emph>Functie</emph> weer met behulp van het contextmenu en selecteer de functie Aantal."
+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\">Geeft een rij weer voor functies of verbergt deze.</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\">Alleen van toepassing op duidelijke waarden in de query.</ahelp> Deze opdracht is van toepassing op records waarin meerdere keren dezelfde waarden staan. Wanneer de functie <emph>Duidelijke waarden</emph> actief is, wordt maar een van deze dubbele records weergegeven (DISTINCT). Anders ziet u alle records, overeenkomend met het query-criterium (ALL)."
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1477,16 +1421,16 @@ msgctxt ""
"02010100.xhp\n"
"par_id3147501\n"
"help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to maximize the number of records with which query returns.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Hiermee kunt u het aantal records die de query oplevert maximaliseren.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>"
+msgstr ""
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
"par_id3152350\n"
"help.text"
-msgid "If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
-msgstr "Als er een <emph>Limiet</emph> wordt toegevoegd, krijgt u hooguit net zoveel rijen als het aantal dat u opgeeft. Anders zult u alle records zien, die met de query-criteria overeenkomen."
+msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1501,8 +1445,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3153162\n"
"help.text"
-msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:"
-msgstr "Voor het maken van filtervoorwaarden zijn verschillende opdrachten en operators beschikbaar. Naast de relationele operators zijn er SQL-specifieke operators beschikbaar waarmee de inhoud van databasevelden kan worden opgevraagd. Als u deze opdrachten in de $[officename]-syntaxis gebruikt, worden deze in $[officename] automatisch geconverteerd naar de bijbehorende SQL-syntaxis. U kunt ook direct een SQL-opdracht invoeren. In de volgende tabellen vindt u een overzicht van de operators en opdrachten:"
+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 "Aan de voorwaarde is voldaan als..."
#: 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 "De operator = wordt niet weergegeven in het queryveld. Als u een waarde zonder operator invoert, wordt automatisch het teken = gebruikt."
-
-#: 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 "... de inhoud van het veld niet overeenkomt met de opgegeven expressie."
#: 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 "... de inhoud van het veld groter is dan de opgegeven waarde."
#: 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 "... de inhoud van het veld kleiner is dan de opgegeven waarde."
#: 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 "... de inhoud van het veld groter is dan of gelijk is aan de opgegeven e
#: 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 "Aan de voorwaarde is voldaan als..."
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3154275\n"
-"help.text"
-msgid "IS EMPTY"
-msgstr "IS LEEG"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149893\n"
-"help.text"
-msgid "IS NULL"
-msgstr "IS NULL"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3143236\n"
"help.text"
msgid "is null"
@@ -1741,24 +1621,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3154744\n"
"help.text"
-msgid "... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No)."
-msgstr "... de veldnaam is leeg. Deze opdracht kijkt automatisch of er voor Ja/Nee-velden met drie statussen geen waarde is ingevuld (Geen ja en geen nee)."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146940\n"
-"help.text"
-msgid "IS NOT EMPTY"
-msgstr "IS NOT EMPTY"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3147471\n"
-"help.text"
-msgid "IS NOT NULL"
-msgstr "IS NOT NULL"
+msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -1773,40 +1637,24 @@ msgctxt ""
"02010100.xhp\n"
"par_id3145304\n"
"help.text"
-msgid "... the field name is not empty."
-msgstr "... de veldnaam is niet leeg."
-
-#: 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 "(tijdelijke aanduiding * voor een willekeurig aantal tekens"
+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 "tijdelijke aanduiding ? voor precies één teken)"
-
-#: 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 "(tijdelijke aanduiding % voor een willekeurig aantal tekens"
+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 "tijdelijke aanduiding _ voor precies één teken)"
+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 "... het veld de opgegeven expressie bevat. De tijdelijke aanduiding (*) geeft aan of de expressie x vooraan (x*), in het midden (*x*) of aan het einde (*x) van de veldinhoud staat. U kunt in SQL-query's zowel het SQL-teken % als de meer vertrouwde tijdelijke aanduiding (*) van het bestandssysteem in de $[officename]-interface invoeren."
+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 "De symbolen * en % staan voor een willekeurig aantal tekens. Het vraagteken (?) in de $[officename]-interface of het onderstrepingsteken (_) in SQL-query's staat voor één teken."
-
-#: 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 "... de veldnaam bevat niet de opgegeven expressie."
-
-#: 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 "... de veldnaam een waarde bevat die tussen de twee waarden x en y ligt."
-
-#: 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 "... de waarde van het veld niet tussen de waarden x en y ligt."
-
-#: 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 "In alle waardenlijsten worden puntkomma's als scheidingstekens gebruikt!"
-
-#: 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 "... het veld een van de waarde a, b, c,..... bevat. Er kan een willekeurige hoeveelheid expressies worden opgegeven en het resultaat van de query wordt bepaald met een OF koppeling. De expressies a, b, c, ... kunnen zowel cijfers als letters zijn"
-
-#: 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 "... de veldnaam bevat geen van de opgegeven expressies a, b, c,…"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3145145\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= WAAR"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146804\n"
-"help.text"
-msgid "= TRUE"
-msgstr "= WAAR"
+msgid "... the field does not contain one of the specified expressions a, b, c,..."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2059,22 +1811,6 @@ msgstr "... het veld heeft de waarde WAAR."
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3159212\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= ONWAAR"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3144751\n"
-"help.text"
-msgid "= FALSE"
-msgstr "= ONWAAR"
-
-#: 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 "... het veld heeft de waarde ONWAAR."
+msgid "... the field data value is set to false."
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2099,14 +1835,6 @@ msgstr "Voorbeelden"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3153792\n"
-"help.text"
-msgid "='Ms.'"
-msgstr "='Mw.'"
-
-#: 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 "geeft de velden terug die \"Mw.\" bevatten."
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id315379A\n"
-"help.text"
-msgid "<'2001-01-10'"
-msgstr "<'2001-01-10'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id315094A\n"
"help.text"
msgid "returns dates that occurred before January 10, 2001"
@@ -2131,82 +1851,42 @@ msgstr "geeft data terug die vóór 10 januari 2001 voorkomen"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id3150333\n"
-"help.text"
-msgid "LIKE 'g?ve'"
-msgstr "LIKE 'H?llo"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3147332\n"
"help.text"
-msgid "returns field names with field content such as \"give\" and \"gave\"."
-msgstr "geeft de velden die inhoud hebben als \"Hallo\" en \"Hello\""
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3146062\n"
-"help.text"
-msgid "LIKE 'S*'"
-msgstr "LIKE 'Z*'"
+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 "retourneert gegevensvelden met veldinhoud zoals 'Zon'."
-
-#: 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 "retourneert velden met veldinhoud die tussen de waarden 10 en 20 liggen. (De velden kunnen tekstvelden of getalvelden zijn)."
-
-#: 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 "geeft alle velden die 1, 3, 5 of 7 als waarde hebben. Als het veld bijvoorbeeld een artikelnummer bevat, kunt u een query maken waarmee het artikel met het opgegeven nummer als resultaat wordt gegeven."
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3152948\n"
-"help.text"
-msgid "NOT IN ('Smith')"
-msgstr "NOT IN ('Jansen')"
+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 "geeft alle velden die niet de waarde \"Jansen\" bevatten."
+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 "U kunt de inhoud van een tekstveld opvragen door de expressie tussen enkele aanhalingstekens te plaatsen. Of er onderscheid wordt gemaakt tussen hoofdletters en kleine letters, is afhankelijk van de gebruikte database. LIKE is per definitie hoofdlettergevoelig (hoewel deze regel in bepaalde databases niet zo strikt wordt genomen)."
+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 "Datum"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id315913112\n"
-"help.text"
-msgid "{D'YYYY-MM-DD'}"
-msgstr "{D'JJJJ-MM-DD'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975313\n"
-"help.text"
-msgid "{d 'YYYY-MM-DD'}"
-msgstr "{d JJJJ-MM-DD'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id314975314\n"
-"help.text"
-msgid "'YYYY-MM-DD'"
-msgstr "JJJJ-MM-DD"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id31559471\n"
"help.text"
msgid "Time"
@@ -2355,30 +2011,6 @@ msgstr "Tijd"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id31559472\n"
-"help.text"
-msgid "{D'HH:MM:SS'}"
-msgstr "{D'UU:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559473\n"
-"help.text"
-msgid "{t 'HH:MI:SS[.SS]'}"
-msgstr "{t 'HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31559474\n"
-"help.text"
-msgid "'HH:MI:SS[.SS]'"
-msgstr "'HH:MI:SS[.SS]'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id31509641\n"
"help.text"
msgid "DateTime"
@@ -2387,30 +2019,6 @@ msgstr "DatumTijd"
#: 02010100.xhp
msgctxt ""
"02010100.xhp\n"
-"par_id31509642\n"
-"help.text"
-msgid "{D'YYYY-MM-DD HH:MM:SS'}"
-msgstr "{D'JJJJ-MM-DD UU:MM:SS'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509643\n"
-"help.text"
-msgid "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}"
-msgstr "{ts 'JJJJ-MM-DD HH:MI:SS[.SS]'}"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id31509644\n"
-"help.text"
-msgid "'YYYY-MM-DD HH:MI:SS[.SS]'"
-msgstr "'JJJJ-MM-DD HH:MI:SS[.SS]'"
-
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
"par_id3149539\n"
"help.text"
msgid "Example: select {d '1999-12-31'} from world.years"
@@ -2429,8 +2037,8 @@ msgctxt ""
"02010100.xhp\n"
"par_id3150510\n"
"help.text"
-msgid "All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
-msgstr "Alle (letterlijke) datum uitdrukkingen moet worden ingesloten door enkele aanhalingstekens. (Raadpleeg de referentie voor de specifieke database en connector die u gebruikt, voor meer informatie.)"
+msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
+msgstr ""
#: 02010100.xhp
msgctxt ""
@@ -2661,32 +2269,32 @@ msgctxt ""
"02010100.xhp\n"
"par_id3152570\n"
"help.text"
-msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has been created previously."
-msgstr "In $[officename] hebt u voor de meeste query's geen kennis van SQL nodig. Als u een query maakt in het query-ontwerpvenster, worden de instructies in $[officename] automatisch geconverteerd naar de overeenkomstige SQL-syntaxis. Met behulp van de knop <emph>Ontwerpweergave aan/uit</emph> kunt u wisselen tussen de ontwerpweergave en de SQL-weergave, waarin de overeenkomstige SQL-instructie voor uw query wordt weergegeven."
+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 "U kunt de query ook direct in SQL opstellen. Let hierbij echter op dat de syntaxis per gebruikt databasesysteem kan verschillen."
+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 "Als u handmatig de SQL-code invoert, kunt u in het <emph>Query-ontwerp</emph> SQL-specifieke query's maken die niet worden ondersteund door de grafische interface. Deze query's moet worden uitgevoerd in de native SQL-modus."
+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 "Als u direct op het pictogram <link href=\"text/shared/02/14030000.xhp\" name=\"SQL-opdracht onmiddellijk uitvoeren\"><emph>SQL-opdracht onmiddellijk uitvoeren</emph></link> in de SQL-weergave klikt, kunt u een query formuleren die niet wordt verwerkt in $[officename]."
+msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename]and sent directly to the database engine."
+msgstr ""
#: 02010101.xhp
msgctxt ""
@@ -2773,8 +2381,8 @@ msgctxt ""
"02010101.xhp\n"
"par_id3152482\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the link type of the selected link.</ahelp> Some databases support only a subset of the possible types."
-msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specificeert het koppelingstype van de geselecteerde koppeling.</ahelp> Sommige databases ondersteunen alleen een subset van de mogelijke typen."
+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\">Bij de Binnenste join bevat de resultatentabel alleen de records waarvoor de inhoud van de gekoppelde velden hetzelfde is.</ahelp> In SQL van $[officename] wordt dit type koppeling door een corresponderende WHERE-component gemaakt."
+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\">Bij de Linkerjoin bevat de resultatentabel alle velden van de linkertabel en alleen die velden van de rechtertabel waarvoor de inhoud van de gekoppelde velden hetzelfde is.</ahelp> In de SQL van $[officename] komt dit type koppeling overeen met de opdracht 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\">Bij de Rechterjoin bevat de resultatentabel alle velden van de rechtertabel en alleen die velden van de linkertabel waarvoor de inhoud van de gekoppelde velden hetzelfde is.</ahelp> In SQL van $[officename] komt dit type koppeling overeen met de opdracht 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\">De resultatentabel bevat voor een volledige join alle velden van de linker- en rechtertabellen.</ahelp> In de SQL van $[officename] komt dit type koppeling overeen met de opdracht 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=\".\">Voegt het sleutelwoord NATURAL in de SQLinstructie in dat de relatie definieert. De relatie voegt alle kolommen samen die dezelfde kolomnaam in beide tabellen hebben. De resulterende samengevoegde tabel bevat slechts één kolom voor elk paar van gelijke genaamde kolommen.</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 "De werkbalk Besturingselementen biedt de benodigde hulpmiddelen om een formulier in een tekst, tabel, tekening of presentatiedocument te maken."
+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 "Bij het ontwerpen van formulieren kunt u <link href=\"text/shared/02/01170000.xhp\" name=\"besturingselementen invoegen\">besturingselementen invoegen</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"eigenschappen toepassen\">eigenschappen toepassen</link>, <link href=\"text/shared/02/01170200.xhp\" name=\"formuliereigenschappen\">formuliereigenschappen</link> definiëren en <link href=\"text/shared/02/01170203.xhp\" name=\"subformulieren definiëren\">subformulieren definiëren</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 "Het pictogram <emph>Formulier-navigator</emph> <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Pictogram</alt></image> op de balk Formulierontwerp opent de <link href=\"text/shared/02/01170600.xhp\" name=\"Formulier-navigator\"><emph>Formulier-navigator</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 "Met het pictogram <link href=\"text/shared/02/01171000.xhp\" name=\"In ontwerpmodus openen\"><emph>In ontwerpmodus openen</emph></link> <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Pictogram</alt></image> kunt u een formulierdocument zo opslaan dat het altijd geopend wordt in bewerkingsmodus."
+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 "Als er een fout optreedt wanneer u eigenschappen aan objecten in het formulier toekent, (bijvoorbeeld, wanneer u een niet bestaande databasetabel aan een object toekent), zult u een overeenkomstige foutboodschap zien. Deze foutboodschap kan een knop <emph>Meer</emph> hebben. <ahelp hid=\"dummy\">Als u op <emph>Meer</emph> klikt, zult u een dialoogvenster zien met meer informatie over het huidige probleem.</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 "In de tabellen van de gegevensbronnen ziet u uw gegevens in rijen onder elkaar. U kunt items toevoegen en verwijderen."
+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 "Het contextmenu van de tabelcontainer biedt verscheidene functies, die over het algemeen gebruikt kunnen worden voor alle databasetabellen. Om een specifieke tabel binnen de database te bewerken, selecteert u de overeenkomstige tabel en opent het contextmenu."
+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 "Afhankelijk van de context is het mogelijk dat voor uw huidige database niet alle functies verschijnen. Zo is bijvoorbeeld de opdracht <emph>Relaties</emph> voor het definiëren van relaties tussen verscheidene tabellen slechts beschikbaar bij relationele databases."
+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 "Voer een wachtwoord in en bevestig het in dit dialoogvenster. Als u een nieuwe gebruiker definieert, toets dan de naam in dit dialoogvenster in."
+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\">Voer het oude wachtwoord in.</ahelp> Dit veld is zichtbaar wanneer u het dialoogvenster via <emph>Wachtwoord wijzigen</emph> hebt opgeroepen."
+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 "In het <emph>Tabelontwerp</emph>venster definieert u nieuwe tabellen of bewerkt u de structuur van een bestaande tabel."
+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\">Voer hier de naam in voor het gegevensveld. Houd hierbij rekening met de beperkingen van het databasetype zoals bijvoorbeeld de lengte van de naam, speciale tekens en spaties.</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\">Selecteer hier het type van het veld.</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\">Voer een optionele beschrijving in.</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\">Voegt een lege rij in boven de huidige rij als de tabel nog niet is opgeslagen. Voegt een lege rij in aan het einde van de tabel als de tabel is opgeslagen.</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\">Als deze opdracht een vinkje heeft, is het gegevensveld in deze regel al een primaire sleutel.</ahelp> Door de opdracht aan te klikken activeert/deactiveert u de status. De opdracht is alleen zichtbaar als de gegevensbron primaire sleutels ondersteunt."
+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 "Voer de lengte van het gegevensveld in."
+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\">Hier ziet u de opmaakcode die u kunt selecteren met behulp van de knop<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\">Geeft helpteksten weer.</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\">In het dialoogvenster <emph>Indexontwerp</emph> bewerkt u de indices voor de huidige tabel.</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\">Geeft de huidige selectie weer. Selecteer een index in de keuzelijst om te bewerken. De bijzonderheden van de geselecteerde index worden in het dialoogvenster weergegeven.</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 "Zodra u een detail van de huidige index verandert en daarna een andere index selecteert, wordt de verandering meteen doorgegeven naar de gegevensbron. U kunt het dialoogvenster alleen sluiten of een andere index selecteren, als de verandering succesvol bevestigd is door de gegevensbron. U kunt echter de verandering ongedaan maken door op het pictogram <emph>Huidige index herstellen</emph> te klikken."
+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\">Bepaalt de sorteervolgorde.</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 "Wanneer u <emph>Extra - Relaties</emph> kiest, wordt er een venster geopend waarin alle bestaande relaties tussen de tabellen van de actuele database worden weergegeven. Als er nog geen relaties zijn gedefinieerd, of als u andere tabellen van de database aan elkaar wilt koppelen, klikt u op het pictogram <emph>Tabellen toevoegen</emph>. Het dialoogvenster <link href=\"text/shared/02/14020100.xhp\" name=\"Tabellen toevoegen\">Tabellen toevoegen</link> wordt geopend waarin u de gewenste tabellen kunt selecteren."
+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 "De geselecteerde tabellen worden weergegeven in het bovenste deel van het ontwerpvenster. U kunt een tabelvenster verwijderen via het contextmenu met de Delete-toets."
+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 "Primaire sleutel en andere sleutel"
+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 "Als u een relatie wilt definieren tussen verschillende tabellen moet u op zijn minst een <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primaire sleutel\">primaire sleutel</link> definieren die duidelijk een gegevensveld van de bestaande tabel definieert. U kunt naar de primaire sleutel van andere tabellen verwijzen om de gegevens van deze tabel aan te spreken. Alle gegevensvelden die naar deze primaire sleutel verwijzen zullen worden beschouwd als externe sleutel."
+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 "Alle bestaande relaties worden weergegeven in het relatiesvenster door een lijn die de primaire en andere sleutels met elkaar verbindt. U kunt een relatie toevoegen door de velden van de ene tabel naar de velden van de andere tabel te slepen. Een geselecteerde relatie wordt verwijderd door op de Delete-toets te drukken."
+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 "Als u $[officename] gebruikt als front-end voor een relationele database, wordt het maken en verwijderen van relaties niet in een tijdelijk geheugen geplaatst door $[officename], maar onmiddelijk naar de externe database verzonden."
+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 "U kunt op het datum- of tijdveld klikken en het naar een andere positie in hetzelfde gebied slepen of de eigenschappen bewerken in het venster Eigenschappen."
+#: 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 "Het venster Veld toevoegen opent automatisch en geeft alle velden van de geselecteerde tabel weer."
-
-#: rep_main.xhp
-msgctxt ""
-"rep_main.xhp\n"
-"par_id5927304\n"
-"help.text"
-msgid "To insert fields into the report"
-msgstr "Velden in het rapport invoegen"
-
-#: 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 "Het venster Veld toevoegen helpt u om de tabelitems in het rapport in te voegen. Klik op het pictogram Veld toevoegen op de werkbalk om het venster Veld toevoegen te openen."
-
-#: 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 "Versleep de veldnamen één voor één vanuit het venster Veld toevoegen in het gebied Detail van het rapport. Plaats de velden zoals u ze wilt. Gebruik de pictogrammen op de werkbalk om de velden uit te lijnen."
-
-#: 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 "Overlappende velden zijn niet mogelijk. Als u een tabelveld in het gebied Detail neerzet, dan worden een label en een tekstvak ingevoegd."
-
-#: 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 "U kunt ook tekst invoegen die op elke pagina van het rapport hetzelfde zou moeten zijn. Klik op het pictogram Labelveld<image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Pictogram</alt></image> en sleep dan een rechthoek in het gebied van de paginakop- of paginavoettekst van de pagina. Bewerk de eigenschap Label om de tekst weer te geven die u wilt."
+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=\".\">Het venster Veld toevoegen wordt automatisch getoond als u een tabel hebt geselecteerd in het vak Inhoud en u dat vak verlaat. U kunt ook op het pictogram Veld toevoegen op de werkbalk klikken, of <item type=\"menuitem\">Beeld - Veld toevoegen</item> kiezen.</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/nl/helpcontent2/source/text/shared/guide.po b/source/nl/helpcontent2/source/text/shared/guide.po
index 1b6807d6a7e..df267864e6a 100644
--- a/source/nl/helpcontent2/source/text/shared/guide.po
+++ b/source/nl/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-09-03 13:23+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-07-12 09:53+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -19253,8 +19253,8 @@ 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."
-msgstr "<link href=\"http://www.libreoffice.org/about-us/credits/\">Zie codelijsten en Wiki-ontwikkelaars</link> op de 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
msgctxt ""
@@ -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-filters testen</bookmark_value><bookmark_value>XML-filters;maken/testen</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 "Ga naar <link href=\"http://xml.openoffice.org/\">http://xml.openoffice.org/</link> voor meer informatie over de OpenDocument XML-indeling."
+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 "Als u een <emph>exportfilter</emph> wilt testen, voert u een van de volgende stappen uit in het gebied <emph>Exporteren</emph> van het dialoogvenster:"
+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 "Als u een <emph>importfilter</emph> wilt testen, klikt u op <emph>Bron tonen</emph> in het gebied <emph>Importeren</emph> van het dialoogvenster, selecteert u een document en klikt u op <emph>Doorzoeken</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/nl/helpcontent2/source/text/shared/help.po b/source/nl/helpcontent2/source/text/shared/help.po
index f8850b84782..29e292043f0 100644
--- a/source/nl/helpcontent2/source/text/shared/help.po
+++ b/source/nl/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: 2018-05-21 08:15+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -53,8 +53,8 @@ msgctxt ""
"browserhelp.xhp\n"
"par_id601525734140935\n"
"help.text"
-msgid "<variable id=\"index\">Index</variable>"
-msgstr "<variable id=\"index\">Index</variable>"
+msgid "<variable id=\"index\">Index of chosen module</variable>"
+msgstr ""
#: browserhelp.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/optionen.po b/source/nl/helpcontent2/source/text/shared/optionen.po
index 901f3650758..296d3978d4b 100644
--- a/source/nl/helpcontent2/source/text/shared/optionen.po
+++ b/source/nl/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-10-02 17:56+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-10-19 21:30+0000\n"
"Last-Translator: Cor Nouws <cor.nouws@documentfoundation.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1539984656.000000\n"
#: 01000000.xhp
@@ -7499,6 +7499,14 @@ msgstr "<ahelp hid=\"modules/swriter/ui/optcaptionpage/level\">Bepaalt de kop- o
#: 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=\".\">Specificeert het tekenopmaakprofiel.</ahelp>"
+msgid "<ahelp hid=\".\">Specifies the character style of the caption paragraph.</ahelp>"
+msgstr ""
#: 01041100.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/smath.po b/source/nl/helpcontent2/source/text/smath.po
index a8009b7bf08..a007d012c20 100644
--- a/source/nl/helpcontent2/source/text/smath.po
+++ b/source/nl/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: 2017-08-17 05:23+0000\n"
"Last-Translator: vpanter <leo.moons@telenet.be>\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 "Kijk op <link href=\"http://www.dmaths.org\">www.dmaths.org</link> voor een verzameling aanvullende %PRODUCTNAME Math iconen en macro's."
+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/nl/helpcontent2/source/text/smath/01.po b/source/nl/helpcontent2/source/text/smath/01.po
index 76f7b0b7118..a1a517a376b 100644
--- a/source/nl/helpcontent2/source/text/smath/01.po
+++ b/source/nl/helpcontent2/source/text/smath/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-07-31 14:10+0200\n"
+"POT-Creation-Date: 2018-11-12 12:23+0100\n"
"PO-Revision-Date: 2018-05-28 07:13+0000\n"
"Last-Translator: kees538 <kees538@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -12365,16 +12365,16 @@ msgctxt ""
"06020000.xhp\n"
"par_id3153916\n"
"help.text"
-msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
-msgstr "Het dialoogvenster <emph>Invoegen</emph> is net zo ingesteld als het dialoogvenster <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Openen</link> onder <emph>Bestand</emph>. Gebruik het dialoogvenster <emph>Invoegen</emph> om een formule die in het venster <emph>Opdrachten</emph> als bestand is opgeslagen, te laden, bewerken en tonen."
+msgid "The <emph>Insert</emph> dialog is set up like the <link href=\"text/shared/01/01020000.xhp\" name=\"Open\"><emph>Open</emph></link> dialog under <emph>File</emph>. Use the <emph>Insert</emph> dialog to load, edit and display a formula saved as a file in the <emph>Commands</emph> window."
+msgstr ""
#: 06020000.xhp
msgctxt ""
"06020000.xhp\n"
"par_id3153917\n"
"help.text"
-msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"http://www.w3.org/TR/#tr_MathML\">specification</link>."
-msgstr "U kunt ook MathML-bestanden, die door andere toepassingen gemaakt werden, importeren. De MathML bron moet een <item type=\"code\">math</item>-element met een <item type=\"code\">xmlns</item>-attribuut met de waarde \"http://www.w3.org/1998/Math/MathML\" hebben. De talen MathML en StarMath zijn niet volledig compatibel, daarom moet je het importresultaat herzien. Voor meer informatie over de taal MathML zie haar <link href=\"http://www.w3.org/TR/#tr_MathML\">specificatie</ link>."
+msgid "You can import MathML files created by other applications as well. The MathML source must have a <item type=\"code\">math</item> element with an <item type=\"code\">xmlns</item> attribute with value \"http://www.w3.org/1998/Math/MathML\". The languages MathML and StarMath are not fully compatible, therefore you should revise the import result. For details about the language MathML see its <link href=\"https://www.w3.org/TR/#tr_MathML\">specification</link>."
+msgstr ""
#: 06020000.xhp
msgctxt ""
@@ -12421,5 +12421,5 @@ msgctxt ""
"06020000.xhp\n"
"par_id3153919\n"
"help.text"
-msgid "This command handles only MathML content. If you have copied a %PRODUCTNAME Math formula to clipboard, insert it using the command <link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">Paste</link> under <emph>Edit</emph>."
-msgstr "Deze opdracht behandelt alleen MathML-inhoud. Als u een %PRODUCTNAME Math-formule naar het klembord heeft gekopieerd, plaatst u deze met de opdracht<link href=\"text/shared/01/02060000.xhp\" name=\"Paste\">Plakken</link> onder <emph>Bewerken</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/nl/helpcontent2/source/text/swriter/guide.po b/source/nl/helpcontent2/source/text/swriter/guide.po
index b91e569f98a..43ed5b4148e 100644
--- a/source/nl/helpcontent2/source/text/swriter/guide.po
+++ b/source/nl/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-08-27 15:35+0000\n"
"Last-Translator: Cor Nouws <cor.nouws@documentfoundation.org>\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 "Kies <emph>Invoegen - Record</emph>."
+msgid "Choose <emph>Data - Record</emph>."
+msgstr ""
#: indices_literature.xhp
msgctxt ""
@@ -10933,8 +10933,8 @@ msgctxt ""
"print_preview.xhp\n"
"par_id3149847\n"
"help.text"
-msgid "Choose <emph>File</emph> - <emph>Print Preview</emph>."
-msgstr "Kies <emph>Bestand</emph> - <emph>Afdrukvoorbeeld</emph>."
+msgid "Choose <emph>File - Print Preview</emph>."
+msgstr ""
#: print_preview.xhp
msgctxt ""