update translations for 6.0 beta2

and force-fix errors using pocheck

Change-Id: I47e8da2f3c05fe79e9d5f79b5e1be051f479d567
(cherry picked from commit 624987b5ec5daaf270b065048dcf11f487edfd4d)

7 files changed, 926 insertions, 110 deletions

diff --git a/source/nl/helpcontent2/source/text/sbasic/shared.po b/source/nl/helpcontent2/source/text/sbasic/shared.po
index d067154381e..048408ea4d3 100644
--- a/source/nl/helpcontent2/source/text/sbasic/shared.po
+++ b/source/nl/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2017-11-22 13:53+0100\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
 "PO-Revision-Date: 2017-11-10 20:52+0000\n"
 "Last-Translator: vpanter <leo.moons@telenet.be>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -181,8 +181,8 @@ msgctxt ""
 "00000003.xhp\n"
 "par_id3153381\n"
 "help.text"
-msgid "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."
-msgstr "U kunt de locale instellingen die worden gebruikt voor het beheren van de opmaak van getallen, datums en valuta instellen in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Voorkeuren</emph></caseinline><defaultinline><emph>Extra - Opties</emph></defaultinline></switchinline><emph> - Taalinstellingen - Talen</emph>. In opmaakcodes in Basic wordt altijd de decimale punt (<emph>.</emph>) gebruikt als <emph>tijdelijke aanduiding</emph> voor het decimale scheidingsteken dat is gedefinieerd in uw locale instellingen en zal door het overeenkomende teken worden vervangen."
+msgid "You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character."
+msgstr "U kunt de locale instellingen die worden gebruikt voor het beheren van de opmaak van getallen, datums en valuta instellen in $[officename] Basic in <emph><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Voorkeuren</caseinline><defaultinline>Extra - Opties</defaultinline></switchinline> - Taalinstellingen - Talen</emph>. In opmaakcodes in Basic wordt altijd de decimale punt (<emph>.</emph>) gebruikt als <emph>tijdelijke aanduiding</emph> voor het decimale scheidingsteken dat is gedefinieerd in uw locale instellingen en zal door het overeenkomende teken worden vervangen."
 
 #: 00000003.xhp
 msgctxt ""
@@ -477,8 +477,8 @@ msgctxt ""
 "00000003.xhp\n"
 "par_id051920171018124524\n"
 "help.text"
-msgid "This function is enabled with the statement <item type=\"literal\">Option VBASupport 1</item> placed before the executable program code in a module."
-msgstr "Deze functie wordt ingeschakeld met de opdracht <item type=\"literal\">Option VBASupport 1</item> vóór de uitvoerbare programmacode in een module."
+msgid "This function or constant is enabled with the statement <item type=\"literal\">Option VBASupport 1</item> placed before the executable program code in a module."
+msgstr ""
 
 #: 00000003.xhp
 msgctxt ""
@@ -517,8 +517,40 @@ msgctxt ""
 "00000003.xhp\n"
 "par_id06142017015837916\n"
 "help.text"
-msgid "<variable id=\"VBA-Financial\"><link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financial functions</link></variable>"
-msgstr "<variable id=\"VBA-Financial\"><link href=\"text/sbasic/shared/special_vba_func.xhp\">VBA financiële functies</link></variable>"
+msgid "<variable id=\"VBA-Financial\"><link href=\"text/sbasic/shared/special_vba_func.xhp#VBAFinancial\">VBA financial functions</link></variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id06142017016837917\n"
+"help.text"
+msgid "<variable id=\"VBATimeAndDate\"><link href=\"text/sbasic/shared/special_vba_func.xhp#VBADateTime\">VBA Time and Date functions</link></variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id06142017016837918\n"
+"help.text"
+msgid "<variable id=\"VBAIO\"><link href=\"text/sbasic/shared/special_vba_func.xhp#VBAIO\">VBA I/O functions</link></variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id06142017016837919\n"
+"help.text"
+msgid "<variable id=\"VBAMath\"><link href=\"text/sbasic/shared/special_vba_func.xhp#VBAMath\">VBA Mathematical functions</link></variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id06142017016837920\n"
+"help.text"
+msgid "<variable id=\"VBAObject\"><link href=\"text/sbasic/shared/special_vba_func.xhp#VBAObject\">VBA Object functions</link></variable>"
+msgstr ""
 
 #: 00000003.xhp
 msgctxt ""
@@ -15045,8 +15077,8 @@ msgctxt ""
 "03040000.xhp\n"
 "bm_id051720170831387233\n"
 "help.text"
-msgid "<bookmark_value>Pi;Basic constant</bookmark_value>  <bookmark_value>Null;Basic constant</bookmark_value>  <bookmark_value>Empty;Basic constant</bookmark_value>  <bookmark_value>Nothing;Basic constant</bookmark_value>  <bookmark_value>Basic constant;Nothing</bookmark_value>  <bookmark_value>Basic constant;Null</bookmark_value>  <bookmark_value>Basic constant;Empty</bookmark_value>  <bookmark_value>Basic constant;Pi</bookmark_value>  <bookmark_value>Basic constant;False</bookmark_value>  <bookmark_value>Basic constant;True</bookmark_value>"
-msgstr "<bookmark_value>Pi;Basic-constante</bookmark_value>  <bookmark_value>Null;Basic-constante</bookmark_value>  <bookmark_value>Leeg;Basic-constante</bookmark_value>  <bookmark_value>Niets;Basic-constante</bookmark_value>  <bookmark_value>Basic-constante;Niets</bookmark_value>  <bookmark_value>Basic-constante;Null</bookmark_value>  <bookmark_value>Basic-constante;Leeg</bookmark_value>  <bookmark_value>Basic-constante;Pi</bookmark_value>  <bookmark_value>Basic-constante;Onwaar</bookmark_value>  <bookmark_value>Basic-constante;Waar</bookmark_value>"
+msgid "<bookmark_value>Pi;Basic constant</bookmark_value>            <bookmark_value>Null;Basic constant</bookmark_value>            <bookmark_value>Empty;Basic constant</bookmark_value>            <bookmark_value>Nothing;Basic constant</bookmark_value>            <bookmark_value>Basic constant;Nothing</bookmark_value>            <bookmark_value>Basic constant;Null</bookmark_value>            <bookmark_value>Basic constant;Empty</bookmark_value>            <bookmark_value>Basic constant;Pi</bookmark_value>            <bookmark_value>Basic constant;False</bookmark_value>            <bookmark_value>Basic constant;True</bookmark_value>            <bookmark_value>VBA Exclusive constants</bookmark_value>"
+msgstr ""
 
 #: 03040000.xhp
 msgctxt ""
@@ -15099,14 +15131,6 @@ msgstr "Waarde"
 #: 03040000.xhp
 msgctxt ""
 "03040000.xhp\n"
-"hd_id051620171114566623\n"
-"help.text"
-msgid "Example"
-msgstr "Voorbeeld"
-
-#: 03040000.xhp
-msgctxt ""
-"03040000.xhp\n"
 "hd_id051620171114573549\n"
 "help.text"
 msgid "Mathematical constant"
@@ -15139,14 +15163,6 @@ msgstr "Waarde"
 #: 03040000.xhp
 msgctxt ""
 "03040000.xhp\n"
-"hd_id051620171114571721\n"
-"help.text"
-msgid "Example"
-msgstr "Voorbeeld"
-
-#: 03040000.xhp
-msgctxt ""
-"03040000.xhp\n"
 "hd_id051620171114576454\n"
 "help.text"
 msgid "Object Constants"
@@ -15203,10 +15219,130 @@ msgstr "Wijs het object <emph>Niets</emph> aan een variabele toe om een vorige t
 #: 03040000.xhp
 msgctxt ""
 "03040000.xhp\n"
-"hd_id051620171114572289\n"
+"hd_id661512312593832\n"
 "help.text"
-msgid "Example"
-msgstr "Voorbeeld"
+msgid "Additional VBA constants"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id111512312705893\n"
+"help.text"
+msgid "The following constants are avalable when VBA compatibility mode is enabled"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id901512312880723\n"
+"help.text"
+msgid "Named constant"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id891512312916493\n"
+"help.text"
+msgid "Hexadecimal (decimal) value"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id991512312965968\n"
+"help.text"
+msgid "Desccription"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id241512313723033\n"
+"help.text"
+msgid "\\x0D (13)"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id611512313731233\n"
+"help.text"
+msgid "CR - Carriage return"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id961512313881937\n"
+"help.text"
+msgid "CRLF - Carriage return and line feed"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id221512313889077\n"
+"help.text"
+msgid "FF - Form feed"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id621512313896169\n"
+"help.text"
+msgid "LF - Line feed"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id521512319135830\n"
+"help.text"
+msgid "\\x0D\\x0A (13 10) for Windows 32 bits"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id61512319163913\n"
+"help.text"
+msgid "\\x0A (10) for other 64 bits systems"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id151512313904989\n"
+"help.text"
+msgid "LF or CRLF"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id741512313911049\n"
+"help.text"
+msgid "Null string"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id951512313918356\n"
+"help.text"
+msgid "HT - Horizontal tab"
+msgstr ""
+
+#: 03040000.xhp
+msgctxt ""
+"03040000.xhp\n"
+"par_id351512313924593\n"
+"help.text"
+msgid "VT - Vertical tab"
+msgstr ""
 
 #: 03050000.xhp
 msgctxt ""
@@ -22131,14 +22267,6 @@ msgstr "Syntaxis:"
 #: 03090411.xhp
 msgctxt ""
 "03090411.xhp\n"
-"par_id3145609\n"
-"help.text"
-msgid "With Object Statement block End With"
-msgstr "With Object Instructieblok End With"
-
-#: 03090411.xhp
-msgctxt ""
-"03090411.xhp\n"
 "hd_id3154924\n"
 "help.text"
 msgid "Parameters:"
@@ -22320,6 +22448,54 @@ msgctxt ""
 msgid "Exit For ' sItem found"
 msgstr "Exit For ' sItem gevonden"
 
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"tit\n"
+"help.text"
+msgid "Type Statement [Runtime]"
+msgstr ""
+
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"bm_id3153311\n"
+"help.text"
+msgid "<bookmark_value>Type statement</bookmark_value>"
+msgstr ""
+
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"hd_id3153311\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03090413.xhp\" name=\"Type Statement [Runtime]\">Type Statement [Runtime]</link>"
+msgstr ""
+
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"par_id3159158\n"
+"help.text"
+msgid "Define non-UNO data structures (structs)."
+msgstr ""
+
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"par_id311512206747401\n"
+"help.text"
+msgid "A struct is an ordered collection of data fields, that can be manipulated as a single item."
+msgstr ""
+
+#: 03090413.xhp
+msgctxt ""
+"03090413.xhp\n"
+"par_id211512215755793\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03132400.xhp\" name=\"CreateObject function\">CreateObject function</link>"
+msgstr ""
+
 #: 03100000.xhp
 msgctxt ""
 "03100000.xhp\n"
@@ -31933,8 +32109,8 @@ msgctxt ""
 "03131600.xhp\n"
 "par_idN1060F\n"
 "help.text"
-msgid "For a list of available services, go to: http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html"
-msgstr "Voor een lijst met beschikbare services gaat u naar: http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html"
+msgid "For a list of available services, go to: <link href=\"http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html\" name=\"linkname\">http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html</link>"
+msgstr ""
 
 #: 03131600.xhp
 msgctxt ""
@@ -34256,6 +34432,494 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/04060103.xhp#bm_id3152978\">SYD function in CALC</link>"
 msgstr ""
 
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"tit\n"
+"help.text"
+msgid "FormatDateTime Function [Runtime - VBA]"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"bm_id3150499\n"
+"help.text"
+msgid "<bookmark_value>FormatDateTime function</bookmark_value>"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"hd_id3150499\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03150000.xhp\" name=\"FormatDateTime Function [Runtime - VBA]\">FormatDateTime Function [Runtime - VBA]</link>"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "Applies a date and/or time format to a date expression and returns the result as a string."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>DateExpression</emph>: The date expression to be formatted."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id24072017011739895\n"
+"help.text"
+msgid "<emph>NamedFormat</emph>: An optional <emph>vbDateTimeFormat</emph> enumeration specifying the format that is to be applied to the date and time exression. If omitted, the value <emph>vbGeneralDate</emph> is used."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"hd_id811512136434300\n"
+"help.text"
+msgid "Date and Time formats (vbDateTimeFormat enumeration)"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id201512137337536\n"
+"help.text"
+msgid "Named Constant"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id481512137342798\n"
+"help.text"
+msgid "Value"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id781512137345583\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id991512137353869\n"
+"help.text"
+msgid "Displays a date and/or time as defined in your system's General Date setting. If a date only, no time is displayed; If a time only, no date is displayed."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id841512137597989\n"
+"help.text"
+msgid "Display a date using the long date format specified in your computer's regional settings."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id841512137397989\n"
+"help.text"
+msgid "Display a date using the short date format specified in your computer's regional settings."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id841512147597989\n"
+"help.text"
+msgid "Displays a time as defined in your system's Long Time settings."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id841517137597989\n"
+"help.text"
+msgid "Display a time using the 24-hour format (hh:mm)."
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id541512148446032\n"
+"help.text"
+msgid "msgbox(\"General date format : \" & FormatDateTime(d))"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id71512148472413\n"
+"help.text"
+msgid "msgbox(\"Long date format : \" & FormatDateTime(d,vbLongDate))"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id561512148491949\n"
+"help.text"
+msgid "msgbox(\"Short date format : \" & FormatDateTime(d,vbShortDate))"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id521512148501199\n"
+"help.text"
+msgid "msgbox(\"Long time format : \" & FormatDateTime(d,3))"
+msgstr ""
+
+#: 03150000.xhp
+msgctxt ""
+"03150000.xhp\n"
+"par_id521512148513930\n"
+"help.text"
+msgid "msgbox(\"Short time format : \" & FormatDateTime(d,vbShortTime))"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"tit\n"
+"help.text"
+msgid "WeekdayName Function [Runtime - VBA]"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"bm_id3150499\n"
+"help.text"
+msgid "<bookmark_value>WeekdayName function</bookmark_value>"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"hd_id3150499\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03150001.xhp\" name=\"WeekdayName Function [Runtime - VBA]\">WeekdayName Function [Runtime - VBA]</link>"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "The WeekdayName function returns the weekday name of a specified day of the week."
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>Weekday</emph>: Value from 1 to 7, Mon­day to Sun­day, whose Week Day Name need to be cal­cu­lated."
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id24072017011739895\n"
+"help.text"
+msgid "<emph>Abbreviate</emph>: Optional. A Boolean value that indicates if the weekday name is to be abbreviated."
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id240720170117395610\n"
+"help.text"
+msgid "<emph>FirstDayofWeek</emph>: Optional. Specifies the first day of the week."
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"hd_id521512154797683\n"
+"help.text"
+msgid "First day of Week:"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id921512153192034\n"
+"help.text"
+msgid "Named constant"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id611512153251598\n"
+"help.text"
+msgid "Value"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id491512153274624\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id611512153338316\n"
+"help.text"
+msgid "Use National Language Support (NLS) API setting"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id151512153594420\n"
+"help.text"
+msgid "Sun­day (default)"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id211512153874765\n"
+"help.text"
+msgid "Monday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id801512153944376\n"
+"help.text"
+msgid "Tueday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id551512153998501\n"
+"help.text"
+msgid "Wednesday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id121512154054207\n"
+"help.text"
+msgid "Thursday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id571512154112044\n"
+"help.text"
+msgid "Friday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id541512154172107\n"
+"help.text"
+msgid "Saturday"
+msgstr ""
+
+#: 03150001.xhp
+msgctxt ""
+"03150001.xhp\n"
+"par_id171512156115581\n"
+"help.text"
+msgid "None"
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"tit\n"
+"help.text"
+msgid "MonthName Function [Runtime - VBA]"
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"bm_id3150499\n"
+"help.text"
+msgid "<bookmark_value>MonthName function</bookmark_value>"
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"hd_id3150499\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03150002.xhp\" name=\"MonthName Function [Runtime - VBA]\">MonthName Function [Runtime - VBA]</link>"
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "The MonthName function returns the localized month name of a specified month number."
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>Month</emph>: Value from 1 to 12, January to December, whose localized month name need to be returned."
+msgstr ""
+
+#: 03150002.xhp
+msgctxt ""
+"03150002.xhp\n"
+"par_id24072017011739895\n"
+"help.text"
+msgid "<emph>Abbreviate</emph>: Optional. A Boolean value that indicates if the month name is to be abbreviated."
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Input Function [Runtime - VBA]"
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"bm_id3150499\n"
+"help.text"
+msgid "<bookmark_value>Input function</bookmark_value>"
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"hd_id3150499\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03160000.xhp\" name=\"Input Function [Runtime - VBA]\">Input Function [Runtime - VBA]</link>"
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "Returns the open stream of an Input or Binary file (String)."
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>Number</emph>: Required. Numeric expression specifying the number of characters to return."
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"par_id24072017011739895\n"
+"help.text"
+msgid "<emph>#</emph>: Optional."
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"par_id240720170117395610\n"
+"help.text"
+msgid "<emph>FileNumber</emph>: Required. Any valid file number."
+msgstr ""
+
+#: 03160000.xhp
+msgctxt ""
+"03160000.xhp\n"
+"par_id061420170153186192\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03020202.xhp\">Input# statement</link>"
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Round Function [Runtime - VBA]"
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"bm_id3150499\n"
+"help.text"
+msgid "<bookmark_value>Round function</bookmark_value>"
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"hd_id3150499\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03170000.xhp\" name=\"Round Function [Runtime - VBA]\">Round Function [Runtime - VBA]</link>"
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "The Round function returns a number rounded to a specified number of digits."
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id240720170117391741\n"
+"help.text"
+msgid "<emph>expression</emph>: Required. The numeric expression to be rounded."
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id240720170117395610\n"
+"help.text"
+msgid "<emph>numdecimalplaces</emph>: Optional. Specifies how many places to the right of the decimal are included in the rounding. Default is 0."
+msgstr ""
+
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id061420170153186193\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/04060106.xhp#bm_id3158121\">Calc ROUND function</link>"
+msgstr ""
+
 #: 05060700.xhp
 msgctxt ""
 "05060700.xhp\n"
@@ -34965,8 +35629,8 @@ msgctxt ""
 "special_vba_func.xhp\n"
 "bm_id051920170350145208\n"
 "help.text"
-msgid "<bookmark_value>VBA Functions</bookmark_value>"
-msgstr "<bookmark_value>VBA-functies</bookmark_value>"
+msgid "<bookmark_value>VBA Functions;Introduction</bookmark_value>"
+msgstr ""
 
 #: special_vba_func.xhp
 msgctxt ""
@@ -34989,8 +35653,8 @@ msgctxt ""
 "special_vba_func.xhp\n"
 "hd_id051820170407499827\n"
 "help.text"
-msgid "These exclusive VBA functions are enabled when <item type=\"literal\">Option VBASupport 1</item> is the first line of a %PRODUCTNAME Basic module."
-msgstr "Deze exclusieve VBA-functies zijn ingeschakeld wanneer <item type=\"literal\">Option VBASupport 1</item> de eerste regel is in een %PRODUCTNAME Basic-module."
+msgid "These exclusive VBA functions are enabled when the statement <item type=\"literal\">Option VBASupport 1</item> is placed before the first macro of a %PRODUCTNAME Basic module."
+msgstr ""
 
 #: special_vba_func.xhp
 msgctxt ""
@@ -35027,6 +35691,14 @@ msgstr "Financiële functies"
 #: special_vba_func.xhp
 msgctxt ""
 "special_vba_func.xhp\n"
+"bm_id051920170358102074\n"
+"help.text"
+msgid "<bookmark_value>VBA Functions;Date and Time  Functions</bookmark_value>"
+msgstr ""
+
+#: special_vba_func.xhp
+msgctxt ""
+"special_vba_func.xhp\n"
 "par_id051820170356005357\n"
 "help.text"
 msgid "Date and time functions"
diff --git a/source/nl/helpcontent2/source/text/scalc/00.po b/source/nl/helpcontent2/source/text/scalc/00.po
index a4628035ae3..ad1a0c034f1 100644
--- a/source/nl/helpcontent2/source/text/scalc/00.po
+++ b/source/nl/helpcontent2/source/text/scalc/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: 2017-11-22 13:53+0100\n"
-"PO-Revision-Date: 2017-06-16 10:55+0000\n"
+"PO-Revision-Date: 2017-12-02 07:40+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: 1497610519.000000\n"
+"X-Generator: Pootle 2.8\n"
+"X-POOTLE-MTIME: 1512200407.000000\n"
 
 #: 00000004.xhp
 msgctxt ""
@@ -134,7 +134,7 @@ msgctxt ""
 "par_id3150400\n"
 "help.text"
 msgid "<variable id=\"baustab\">Choose <emph>Sheet - Fill Cells - Sheets</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"baustab\">Kies <emph>Blad - Cellen vullen - Bladen</emph></variable>"
 
 #: 00000402.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/scalc/01.po b/source/nl/helpcontent2/source/text/scalc/01.po
index 10109f84825..1acdd4340b8 100644
--- a/source/nl/helpcontent2/source/text/scalc/01.po
+++ b/source/nl/helpcontent2/source/text/scalc/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: 2017-11-22 13:53+0100\n"
-"PO-Revision-Date: 2017-10-29 09:56+0000\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
+"PO-Revision-Date: 2017-12-02 12:07+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: 1509271009.000000\n"
+"X-POOTLE-MTIME: 1512216436.000000\n"
 
 #: 01120000.xhp
 msgctxt ""
@@ -1078,7 +1078,7 @@ msgctxt ""
 "tit\n"
 "help.text"
 msgid "Fill Sheets"
-msgstr ""
+msgstr "Bladen vullen"
 
 #: 02140500.xhp
 msgctxt ""
@@ -1086,7 +1086,7 @@ msgctxt ""
 "hd_id3153897\n"
 "help.text"
 msgid "Fill Sheets"
-msgstr ""
+msgstr "Bladen vullen"
 
 #: 02140500.xhp
 msgctxt ""
@@ -1094,7 +1094,7 @@ msgctxt ""
 "par_id3150791\n"
 "help.text"
 msgid "<variable id=\"tabellenfuellentext\"><ahelp hid=\".uno:FillTable\">Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets.</ahelp></variable>"
-msgstr ""
+msgstr "<variable id=\"tabellenfuellentext\"><ahelp hid=\".uno:FillTable\">Hiermee geeft u de opties op voor het overbrengen van bladen of bereiken van een bepaald blad, naar dezelfde cellen op andere geselecteerde bladen.</ahelp></variable>"
 
 #: 02140500.xhp
 msgctxt ""
@@ -1102,7 +1102,7 @@ msgctxt ""
 "par_id3150768\n"
 "help.text"
 msgid "This menu command is only active if you have selected at least two sheets in the document."
-msgstr ""
+msgstr "Deze menu-opdracht is alleen actief als u minstens twee bladen in het document geselecteerd heeft."
 
 #: 02140500.xhp
 msgctxt ""
@@ -1110,7 +1110,7 @@ msgctxt ""
 "par_id3150769\n"
 "help.text"
 msgid "To select multiple sheets, click each sheet tab while pressing <switchinline select=\"sys\"> <caseinline select=\"MAC\">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> or Shift."
-msgstr ""
+msgstr "Om meerdere bladen te selecteren, klikt u op elke bladtab terwijl u <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> of Shift ingedrukt houdt."
 
 #: 02140500.xhp
 msgctxt ""
@@ -1118,7 +1118,7 @@ msgctxt ""
 "par_id3150767\n"
 "help.text"
 msgid "In contrast to copying an area to the clipboard, you can filter certain information and calculate values."
-msgstr ""
+msgstr "In tegenstelling tot het kopiëren van een gebied naar het klembord, kunt u bepaalde informatie filteren en waarden berekenen."
 
 #: 02140500.xhp
 msgctxt ""
@@ -1150,7 +1150,7 @@ msgctxt ""
 "par_id3147436\n"
 "help.text"
 msgid "Select the command <emph>Sheet - Fill Cells - Sheets</emph>. In the dialog which appears, the check box <emph>Numbers</emph> must be selected (or <emph>Paste All</emph>) if you want to combine operations with the values. You can also choose the desired operation here."
-msgstr ""
+msgstr "Selecteer de opdracht <emph>Blad - Cellen vullen - Bladen</emph>. In het dialoogvenster dat verschijnt, moet het keuzevakje <emph>Getallen</emph> geselecteerd zijn (of <emph>Alles plakken</emph>) als u verschillende bewerkingen met de waarden wilt uitvoeren. U kunt hier ook de gewenste bewerking kiezen."
 
 #: 02140500.xhp
 msgctxt ""
@@ -1166,7 +1166,7 @@ msgctxt ""
 "par_id3156283\n"
 "help.text"
 msgid "This dialog is similar to the <link href=\"text/shared/01/02070000.xhp\" name=\"Paste Special\">Paste Special</link> dialog, where you can find additional tips."
-msgstr ""
+msgstr "Het dialoogvenster is vergelijkbaar met het dialoogvenster <link href=\"text/shared/01/02070000.xhp\" name=\"Paste Special\">Alles plakken</link>, waarin u aanvullende tips kunt vinden."
 
 #: 02140600.xhp
 msgctxt ""
@@ -1526,7 +1526,7 @@ msgctxt ""
 "par_id2308201415431525817\n"
 "help.text"
 msgid "<ahelp hid=\".\">Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Een celbereik voorzien van automatisch gegenereerde pseudo-willekeurige getallen met de geselecteerde verdelingsfunctie en zijn parameters.</ahelp>"
 
 #: 02140700.xhp
 msgctxt ""
@@ -1542,7 +1542,7 @@ msgctxt ""
 "par_id2308201415500176457\n"
 "help.text"
 msgid "Choose <item type=\"menuitem\">Sheet - Fill Cells - Random Number</item>"
-msgstr ""
+msgstr "Kies <item type=\"menuitem\">Blad - Cellen vullen - Reeks</item>."
 
 #: 02140700.xhp
 msgctxt ""
@@ -1566,7 +1566,7 @@ msgctxt ""
 "par_id2308201415431811111\n"
 "help.text"
 msgid "<ahelp hid=\".\">Define the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Definieer het celbereik dat gevuld moet worden met willekeurige getallen. Als u eerder een bereik geselecteerd heeft dan wordt dat hier weergegeven.</ahelp>"
 
 #: 02140700.xhp
 msgctxt ""
@@ -1846,7 +1846,7 @@ msgctxt ""
 "par_id2308201415431841782\n"
 "help.text"
 msgid "<ahelp hid=\".\">Set the initial value of the random number generator to a known value <emph>Seed.</emph></ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">De initiële waarde van de willekeurige getalgenerator naar een bekende <emph>Beginwaarde</emph> instellen.</ahelp>"
 
 #: 02140700.xhp
 msgctxt ""
@@ -1862,7 +1862,7 @@ msgctxt ""
 "par_id2308201415431834837\n"
 "help.text"
 msgid "<ahelp hid=\".\">Value set to initiate the random number generator algorithm. It is used to initialize (seed) the random number generator in order to reproduce the same sequence of pseudorandom numbers. Specify a positive integer number (1, 2, ...) to produce a specific sequence, or leave the field blank if you don't need this particular feature.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Waarde om de algoritme van de willekeurige getalgenerator te initiëren. Het wordt gebruikt om de willekeurige getalgenerator te initialiseren (beginwaarde), om dezelfde opeenvolging van pseudo-willekeurige getallen te reproduceren. Geef een positief geheel getal (1, 2, ...) om een specifieke volgorde te produceren of laat het veld leeg als u deze bepaalde functie niet nodig hebt.</ahelp>"
 
 #: 02140700.xhp
 msgctxt ""
@@ -1878,7 +1878,7 @@ msgctxt ""
 "par_id2308201415431822157\n"
 "help.text"
 msgid "<ahelp hid=\".\">Truncate the number to a given number of <emph>Decimal Places</emph>.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Breekt het getal af op het opgegeven <emph>Aantal decimalen</emph>.</ahelp>"
 
 #: 02140700.xhp
 msgctxt ""
@@ -1894,7 +1894,7 @@ msgctxt ""
 "par_id2308201415431820502\n"
 "help.text"
 msgid "<ahelp hid=\".\">Number of decimal places of the numbers generated.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Aantal decimalen van de gegenereerde getallen.</ahelp>"
 
 #: 02150000.xhp
 msgctxt ""
@@ -2262,7 +2262,7 @@ msgctxt ""
 "par_id3145801\n"
 "help.text"
 msgid "You cannot delete a sheet while <emph>Edit - Track Changes - Record</emph> is activated."
-msgstr ""
+msgstr "U kunt een blad niet verwijderen als <emph>Bewerken - Wijzigingen bijhouden - Wijzigingen bijhouden</emph> is ingeschakeld."
 
 #: 02170000.xhp
 msgctxt ""
@@ -20798,7 +20798,7 @@ msgctxt ""
 "par_id3150826\n"
 "help.text"
 msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats have to be defined beforehand."
-msgstr ""
+msgstr "<ahelp hid=\"HID_FUNC_VORLAGE\">Past een opmaakprofiel op de cel met de formule toe.</ahelp> Na een ingestelde periode kan een ander opmaakprofiel toegepast worden. Deze functie geeft altijd de waarde 0, waardoor u hem aan een andere functie kunt toevoegen zonder de waarde te wijzigen. U kunt tegelijk met de functie HUIDIG een kleur op een cel toepassen, afhankelijk van de waarde. Voorbeeld: =...+OPMAAKPROFIEL(ALS(HUIDIG()>3;\"rood\";\"groen\")) past de stijl voor rood op de cel toe als de waarde groter is dan 3, zo niet dan wordt de stijl voor groen toegepast. Beide celopmaakprofielen moeten vooraf gedefinieerd worden."
 
 #: 04060109.xhp
 msgctxt ""
@@ -24166,7 +24166,7 @@ msgctxt ""
 "par_id3156074\n"
 "help.text"
 msgid "<item type=\"input\">=TRIM(\" hello      world \")</item> returns hello world without leading and trailing spaces and with single space between words."
-msgstr ""
+msgstr "<item type=\"input\">=TRIM(\" hallo      wereld \")</item> geeft hallo wereld terug zonder voorafgaande of volgende spaties en met een enkele spatie tussen de woorden."
 
 #: 04060110.xhp
 msgctxt ""
@@ -26974,7 +26974,7 @@ msgctxt ""
 "par_id050220171019078280\n"
 "help.text"
 msgid "=BESSELJ(3.45, 4.333), returns 0.196772639864984, same as above because the fractional part of N is ignored."
-msgstr ""
+msgstr "=BESSEL.J(3,45; 4,333), geeft 0,196772639864984, hetzelfde als hierboven, omdat het breukgedeelte van N wordt genegeerd."
 
 #: 04060115.xhp
 msgctxt ""
@@ -30694,7 +30694,7 @@ msgctxt ""
 "par_id3149025\n"
 "help.text"
 msgid "VDB(Cost; Salvage; Life; S; End; Factor; NoSwitch)"
-msgstr ""
+msgstr "VDB(Kosten; Restwaarde; Levensduur; S; Einde; Factor; GeenWissel)"
 
 #: 04060118.xhp
 msgctxt ""
@@ -54197,8 +54197,8 @@ msgctxt ""
 "12090103.xhp\n"
 "par_id3153093\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/connect2\" visibility=\"visible\">Select a logical operator for the filter.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/connect2\" visibility=\"visible\">Kies tussen de logische operatoren EN/OF.</ahelp>"
+msgid "<ahelp hid=\".\">Select a logical operator for the filter.</ahelp>"
+msgstr ""
 
 #: 12090103.xhp
 msgctxt ""
@@ -54213,8 +54213,8 @@ msgctxt ""
 "12090103.xhp\n"
 "par_id3155306\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/field3\" visibility=\"visible\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/field3\" visibility=\"visible\">Selecteer uit de keuzelijst de veldnaam van het actuele blad om in het filter te gebruiken. De kolomkoppen worden hier getoond als de teksten voor de namen van de velden niet bestaan.</ahelp>"
+msgid "<ahelp hid=\".\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
+msgstr ""
 
 #: 12090103.xhp
 msgctxt ""
@@ -54229,8 +54229,8 @@ msgctxt ""
 "12090103.xhp\n"
 "par_id3147394\n"
 "help.text"
-msgid "<ahelp visibility=\"visible\" hid=\"modules/scalc/ui/pivotfilterdialog/cond3\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
-msgstr "<ahelp visibility=\"visible\" hid=\"modules/scalc/ui/pivotfilterdialog/cond3\">Kies een vergelijkingsoperator om de items te koppelen in <emph>Veldnaam</emph> en <emph>Waarde</emph>.</ahelp>"
+msgid "<ahelp hid=\".\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
+msgstr ""
 
 #: 12090103.xhp
 msgctxt ""
@@ -54357,8 +54357,8 @@ msgctxt ""
 "12090103.xhp\n"
 "par_id3155506\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/val3\" visibility=\"visible\">Select the value that you want to compare to the selected field.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/val3\" visibility=\"visible\">Selecteer de waarde die u met het geselecteerde veld wilt vergelijken.</ahelp>"
+msgid "<ahelp hid=\".\">Select the value that you want to compare to the selected field.</ahelp>"
+msgstr ""
 
 #: 12090103.xhp
 msgctxt ""
@@ -56253,48 +56253,192 @@ msgctxt ""
 "data_form.xhp\n"
 "tit\n"
 "help.text"
-msgid "Data Form for Spreadsheet"
-msgstr "Gegevensformulier voor werkbladen"
+msgid "Data Entry Form for Spreadsheet"
+msgstr ""
 
 #: data_form.xhp
 msgctxt ""
 "data_form.xhp\n"
 "bm_id240920171018528200\n"
 "help.text"
-msgid "<bookmark_value>data forms;for spreadsheets</bookmark_value>  <bookmark_value>data forms;insert data in spreadsheets</bookmark_value>  <bookmark_value>insert data;data forms for spreadsheets</bookmark_value>  <bookmark_value>spreadsheet;form to insert data</bookmark_value>"
-msgstr "<bookmark_value>gegevensformulieren;voor werkbladen</bookmark_value>  <bookmark_value>gegevensformulieren;gegevens in werkbladen invoeren</bookmark_value>  <bookmark_value>gegevens invoerendata;gegevensformulieren voor werkbladen</bookmark_value>  <bookmark_value>werkblad;formulier om gegevens in te voeren</bookmark_value>"
+msgid "<bookmark_value>data entry forms;for spreadsheets</bookmark_value>            <bookmark_value>data entry forms;insert data in spreadsheets</bookmark_value>            <bookmark_value>insert data;data entry forms for spreadsheets</bookmark_value>            <bookmark_value>spreadsheet;form for inserting data</bookmark_value>"
+msgstr ""
 
 #: data_form.xhp
 msgctxt ""
 "data_form.xhp\n"
 "hd_id240920171003006302\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Forms for Spreasheets</link>"
-msgstr "<link href=\"text/scalc/01/data_form.xhp\">Gegevensformulieren voor werkbladen</link>"
+msgid "<link href=\"text/scalc/01/data_form.xhp\">Data Entry Forms for Spreasheets</link>"
+msgstr ""
 
 #: data_form.xhp
 msgctxt ""
 "data_form.xhp\n"
 "par_id240920171003293400\n"
 "help.text"
-msgid "<ahelp hid=\".\">Data Forms for Spreasheets</ahelp>"
-msgstr "<ahelp hid=\".\">Gegevensformulieren voor werkbladen</ahelp>"
+msgid "<ahelp hid=\".\">Data Entry Form is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide."
+msgstr ""
 
 #: data_form.xhp
 msgctxt ""
 "data_form.xhp\n"
 "par_id240920171007389295\n"
 "help.text"
-msgid "Menu <item type=\"menuitem\">Data – Form...</item>"
-msgstr "Menu <item type=\"menuitem\">Gegevens - Formulier...</item>"
+msgid "Choose <item type=\"menuitem\">Data – Form...</item>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id291512503277077\n"
+"help.text"
+msgid "Preparing the data entry form"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id221512503284514\n"
+"help.text"
+msgid "To be effective, the Calc data table should have a header row, where each cell contents is the label of the column. The header cells contents becomes the label of each data field in the form."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id531512503300666\n"
+"help.text"
+msgid "Activating the form"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id551512503358101\n"
+"help.text"
+msgid "Place the cursor in the header row of the table."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id11512503369875\n"
+"help.text"
+msgid "Choose <item type=\"menutiem\">Data - Form...</item>."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id361512503457039\n"
+"help.text"
+msgid "Filling the form with data"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id111512507319306\n"
+"help.text"
+msgid "Form dialog buttons"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id981512503964001\n"
+"help.text"
+msgid "<emph>New</emph>: fill the record (table row cells) with the form fields contents and jump to the next record or add a new record in the bottom of the table."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id91512503864256\n"
+"help.text"
+msgid "<emph>Delete</emph>: deletes the current record."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id11512503887586\n"
+"help.text"
+msgid "<emph>Restore</emph>: when a form field is edited, restore the record contents to its initial state."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id301512503881314\n"
+"help.text"
+msgid "<emph>Previous record</emph>: move to the previous record (table row)."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id51512503877397\n"
+"help.text"
+msgid "<emph>Next record</emph>: move to the next record."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id971512503871672\n"
+"help.text"
+msgid "<emph>Close</emph>: close the form."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id951512509971073\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sc_data_form01.png\" id=\"img_id951512509971073\">            <alt id=\"alt_id951512509971073\">The form dialog box and header row cells as field labels</alt>        </image>"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id351512558748321\n"
+"help.text"
+msgid "Use the <item type=\"input\">Tab</item> and <item type=\"input\">Shift-Tab</item> keys to jump forth and back between text boxes of the form dialog."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id731512558741034\n"
+"help.text"
+msgid "You also can use the form scroll bar to move between text boxes."
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"hd_id701512558977465\n"
+"help.text"
+msgid "Reopening the form dialog"
+msgstr ""
+
+#: data_form.xhp
+msgctxt ""
+"data_form.xhp\n"
+"par_id181512558987528\n"
+"help.text"
+msgid "To reopen the form dialog, place the cursor on the header row and open the form. The displayed record in the form dialog is the fisrt data record. Move to the last record before entering new data otherwise the current record will be edited."
+msgstr ""
 
 #: data_form.xhp
 msgctxt ""
 "data_form.xhp\n"
 "par_id240920171007419799\n"
 "help.text"
-msgid "Form"
-msgstr "Formulier"
+msgid "<link href=\"text/shared/guide/data_forms.xhp\" name=\"Forms\">Document Forms</link>"
+msgstr ""
 
 #: data_provider.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/shared/01.po b/source/nl/helpcontent2/source/text/shared/01.po
index c02e39661bf..4f531a20e86 100644
--- a/source/nl/helpcontent2/source/text/shared/01.po
+++ b/source/nl/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2017-11-22 13:53+0100\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
 "PO-Revision-Date: 2017-11-14 18:54+0000\n"
 "Last-Translator: Cor Nouws <cor.nouws@documentfoundation.org>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -21685,8 +21685,8 @@ msgctxt ""
 "05100200.xhp\n"
 "par_id3083451\n"
 "help.text"
-msgid "<variable id=\"teilentext\"><ahelp hid=\".uno:SplitCell\">Splits the cell or group of cells horizontally or vertically into the number of cells that you enter.</ahelp></variable>"
-msgstr "<variable id=\"teilentext\"><ahelp hid=\".uno:SplitCell\">Splitst de cel of groep cellen horizontaal of verticaal in het aantal cellen dat u invoert.</ahelp></variable>"
+msgid "<variable id=\"teilentext\"><ahelp hid=\".\">Splits the cell or group of cells horizontally or vertically into the number of cells that you enter.</ahelp></variable>"
+msgstr ""
 
 #: 05100200.xhp
 msgctxt ""
@@ -37949,16 +37949,16 @@ msgctxt ""
 "gallery.xhp\n"
 "par_id3149783\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_ICONVIEW\">Displays the contents of the <emph>Gallery </emph>as icons.</ahelp>"
-msgstr "<ahelp hid=\"SVX_HID_GALLERY_ICONVIEW\">De inhoud van de <emph>Galerij</emph> als pictogrammen weergeven.</ahelp>"
+msgid "<ahelp hid=\"SVX_HID_GALLERY_ICONVIEW\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as icons.</ahelp>"
+msgstr ""
 
 #: gallery.xhp
 msgctxt ""
 "gallery.xhp\n"
 "par_id3148983\n"
 "help.text"
-msgid "<ahelp hid=\"SVX_HID_GALLERY_LISTVIEW\">Displays the contents of the <emph>Gallery </emph>as small icons, with title and path information.</ahelp>"
-msgstr "<ahelp hid=\"SVX_HID_GALLERY_LISTVIEW\">De inhoud van de <emph>Galerij</emph> als kleine pictogrammen weergeven, met titel en padgegevens.</ahelp>"
+msgid "<ahelp hid=\"SVX_HID_GALLERY_LISTVIEW\" visibility=\"hidden\">Displays the contents of the <emph>Gallery </emph>as small icons, with title and path information.</ahelp>"
+msgstr ""
 
 #: gallery.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/swriter/00.po b/source/nl/helpcontent2/source/text/swriter/00.po
index 978310e9075..834a357083c 100644
--- a/source/nl/helpcontent2/source/text/swriter/00.po
+++ b/source/nl/helpcontent2/source/text/swriter/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2017-11-22 13:53+0100\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
 "PO-Revision-Date: 2017-11-10 13:49+0000\n"
 "Last-Translator: kees538 <kees538@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -285,8 +285,8 @@ msgctxt ""
 "00000402.xhp\n"
 "par_id3153737\n"
 "help.text"
-msgid "Choose <emph>Edit - Index Entry</emph>"
-msgstr "Kies <emph>Bewerken - Indexitem</emph>"
+msgid "Choose <emph>Edit - Reference - Index Entry...</emph>"
+msgstr ""
 
 #: 00000402.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/swriter/01.po b/source/nl/helpcontent2/source/text/swriter/01.po
index 89fe3bab3ee..48f29e5ed31 100644
--- a/source/nl/helpcontent2/source/text/swriter/01.po
+++ b/source/nl/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2017-11-22 13:53+0100\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
 "PO-Revision-Date: 2017-11-12 13:15+0000\n"
 "Last-Translator: kees538 <kees538@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -9549,8 +9549,8 @@ msgctxt ""
 "04120100.xhp\n"
 "par_id3147571\n"
 "help.text"
-msgid "To edit an index entry, place the cursor in front of the index field, and then choose <link href=\"text/swriter/01/02160000.xhp\" name=\"Edit - Index Entry\"><emph>Edit - Index Entry</emph></link>"
-msgstr "Wilt u een indexitem bewerken, dan zet u de cursor voor het indexveld en kiest u <link href=\"text/swriter/01/02160000.xhp\" name=\"Bewerken - Indexitem\"><emph>Bewerken - Indexitem</emph></link>"
+msgid "To edit an index entry, place the cursor in front of the index field, and then choose <link href=\"text/swriter/01/02160000.xhp\" name=\"Edit - Reference - Index Entry...\"><emph>Edit - Reference - Index Entry...</emph></link>"
+msgstr ""
 
 #: 04120100.xhp
 msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/swriter/guide.po b/source/nl/helpcontent2/source/text/swriter/guide.po
index e19cc4dee1e..454f0c5e229 100644
--- a/source/nl/helpcontent2/source/text/swriter/guide.po
+++ b/source/nl/helpcontent2/source/text/swriter/guide.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: 2017-10-04 11:48+0200\n"
-"PO-Revision-Date: 2017-11-14 18:57+0000\n"
-"Last-Translator: Cor Nouws <cor.nouws@documentfoundation.org>\n"
+"POT-Creation-Date: 2017-12-06 15:59+0100\n"
+"PO-Revision-Date: 2017-12-07 19:34+0000\n"
+"Last-Translator: Anonymous Pootle User\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: Pootle 2.8\n"
-"X-POOTLE-MTIME: 1510685844.000000\n"
+"X-POOTLE-MTIME: 1512675258.000000\n"
 
 #: anchor_object.xhp
 msgctxt ""
@@ -910,7 +910,7 @@ msgctxt ""
 "par_id3145615\n"
 "help.text"
 msgid "Choose <link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\"><emph>Tools - AutoText</emph></link>."
-msgstr "Kies <link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\"><emph>Bewerken - AutoTekst</emph></link>."
+msgstr "Kies <link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\"><emph>Extra - AutoTekst</emph></link>."
 
 #: autotext.xhp
 msgctxt ""
@@ -1022,7 +1022,7 @@ msgctxt ""
 "par_id3154995\n"
 "help.text"
 msgid "<link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\">Tools - AutoText</link>"
-msgstr "<link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\">Bewerken - AutoTekst</link>"
+msgstr "<link href=\"text/swriter/01/02120000.xhp\" name=\"Tools - AutoText\">Extra - AutoTekst</link>"
 
 #: autotext.xhp
 msgctxt ""
@@ -7029,8 +7029,8 @@ msgctxt ""
 "indices_delete.xhp\n"
 "par_id3155526\n"
 "help.text"
-msgid "Choose <emph>Edit - Index Entry</emph>, and do one of the following:"
-msgstr "Kies <emph>Bewerken - Indexitem</emph> en doe het volgende:"
+msgid "Choose <emph>Edit - Reference - Index Entry...</emph>, and do one of the following:"
+msgstr ""
 
 #: indices_delete.xhp
 msgctxt ""