aboutsummaryrefslogtreecommitdiff
path: root/source/nl/helpcontent2/source/text/scalc
diff options
context:
space:
mode:
Diffstat (limited to 'source/nl/helpcontent2/source/text/scalc')
-rw-r--r--source/nl/helpcontent2/source/text/scalc/00.po26
-rw-r--r--source/nl/helpcontent2/source/text/scalc/01.po234
-rw-r--r--source/nl/helpcontent2/source/text/scalc/02.po34
-rw-r--r--source/nl/helpcontent2/source/text/scalc/05.po10
-rw-r--r--source/nl/helpcontent2/source/text/scalc/guide.po42
5 files changed, 218 insertions, 128 deletions
diff --git a/source/nl/helpcontent2/source/text/scalc/00.po b/source/nl/helpcontent2/source/text/scalc/00.po
index 2dbef8e2bab..ec08d3203ba 100644
--- a/source/nl/helpcontent2/source/text/scalc/00.po
+++ b/source/nl/helpcontent2/source/text/scalc/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: 2020-10-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-10-17 21:35+0000\n"
"Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
"Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/nl/>\n"
@@ -664,14 +664,23 @@ msgctxt ""
msgid "Format Menu"
msgstr "Menu Opmaak"
-#. HP9LA
+#. TmWCz
#: 00000405.xhp
msgctxt ""
"00000405.xhp\n"
"par_id3154685\n"
"help.text"
-msgid "<variable id=\"fozelle\">Choose <emph>Format - Cells</emph>.</variable>"
-msgstr "<variable id=\"fozelle\">Kies <emph>Opmaak - Cellen </emph>.</variable>"
+msgid "Choose <menuitem>Format - Cells</menuitem>."
+msgstr ""
+
+#. DEPHV
+#: 00000405.xhp
+msgctxt ""
+"00000405.xhp\n"
+"par_id61593556839601\n"
+"help.text"
+msgid "Press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+1</keycode>."
+msgstr ""
#. HR2kd
#: 00000405.xhp
@@ -1933,6 +1942,15 @@ msgctxt ""
msgid "This function is available since %PRODUCTNAME 7.0."
msgstr "Deze functie is beschikbaar sinds %PRODUCTNAME 7.0."
+#. 3FGD2
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id651551401041666\n"
+"help.text"
+msgid "This function is available since %PRODUCTNAME 7.1."
+msgstr ""
+
#. LSPBz
#: sheet_menu.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/scalc/01.po b/source/nl/helpcontent2/source/text/scalc/01.po
index e5a7b624518..4a539295070 100644
--- a/source/nl/helpcontent2/source/text/scalc/01.po
+++ b/source/nl/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-10-23 13:36+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-07-11 09:34+0000\n"
"Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
"Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/nl/>\n"
@@ -12589,13 +12589,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_LOG\">Geeft het logaritme van een getal tot de gespecificeerde basis.</ahelp>"
-#. ShWCR
+#. uDAq7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3144732\n"
"help.text"
-msgid "LOG(Number[; Base])"
+msgid "LOG(Number [; Base])"
msgstr ""
#. Eiqiq
@@ -12841,6 +12841,15 @@ msgctxt ""
msgid "<item type=\"literal\">Base^Exponent</item>"
msgstr "<item type=\"literal\">Basis^Macht</item>"
+#. dRQh7
+#: 04060106.xhp
+msgctxt ""
+"04060106.xhp\n"
+"par_id241599040594931\n"
+"help.text"
+msgid "<literal>=POWER(0,0)</literal> returns 1."
+msgstr ""
+
#. D3Ghv
#: 04060106.xhp
msgctxt ""
@@ -13246,13 +13255,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">Rondt een getal af op een bepaald aantal decimalen.</ahelp>"
-#. p64i9
+#. kj4B7
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3158182\n"
"help.text"
-msgid "ROUND(Number[; Count])"
+msgid "ROUND(Number [; Count])"
msgstr ""
#. yE5Jb
@@ -13345,13 +13354,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rondt een getal af naar beneden, in de richting van nul, tot een bepaalde precisie.</ahelp>"
-#. uqe8Y
+#. MnKJo
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3146051\n"
"help.text"
-msgid "ROUNDDOWN(Number[; Count])"
+msgid "ROUNDDOWN(Number [; Count])"
msgstr ""
#. EXn4P
@@ -13435,13 +13444,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rondt een getal af, weg van nul, tot een bepaalde precisie.</ahelp>"
-#. smgCC
+#. Gz3SM
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3163328\n"
"help.text"
-msgid "ROUNDUP(Number[; Count])"
+msgid "ROUNDUP(Number [; Count])"
msgstr ""
#. x59Ls
@@ -13912,13 +13921,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value."
msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Telt de cellen op die door een bepaald criterium gespecificeerd zijn.</ahelp> Deze functie wordt gebruikt om door een bereik te bladeren wanneer u een bepaalde waarde zoekt."
-#. PcPNo
+#. KsFtX
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3152028\n"
"help.text"
-msgid "SUMIF(Range; Criteria[; SumRange])"
+msgid "SUMIF(Range; Criteria [; SumRange])"
msgstr ""
#. rYzXG
@@ -14434,13 +14443,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converteert oude Europese nationale valuta naar en van Euro's.</ahelp>"
-#. qh8S5
+#. G7CMF
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id3143748\n"
"help.text"
-msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])"
+msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\" [; full_precision [; triangulation_precision]])"
msgstr ""
#. 4KJUc
@@ -14542,14 +14551,14 @@ msgctxt ""
msgid "At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies."
msgstr "De lijst van conversiefactoren bevatte eens de oude Europese valuta en de Euro (zie de voorbeelden hieronder). We stellen voor de nieuwe functie EURO.CONVERTEREN te gebruiken voor het converteren van die valuta."
-#. GhdsH
+#. o7nsC
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131191\n"
"help.text"
-msgid "CONVERT_OOO(value;\"text\";\"text\")"
-msgstr "CONVERTEREN_OOO(waarde;\"tekst\";\"tekst\")"
+msgid "CONVERT_OOO(value; \"text\"; \"text\")"
+msgstr ""
#. egbGd
#: 04060106.xhp
@@ -17224,13 +17233,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">Berekent de punten van een exponentiële trend in een matrix.</ahelp>"
-#. 8VMBq
+#. GMVAK
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3166377\n"
"help.text"
-msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])"
+msgid "GROWTH(DataY [; [ DataX ] [; [ NewDataX ] [; FunctionType ] ] ])"
msgstr ""
#. CA3qD
@@ -18979,31 +18988,31 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_WAHL\">Gebruikt een index om een waarde uit een lijst met tot 30 waarden te geven.</ahelp>"
-#. r7bDk
+#. V8cAu
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3155425\n"
"help.text"
-msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])"
+msgid "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])"
msgstr ""
-#. dt8SY
+#. CNK7e
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3144755\n"
"help.text"
-msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list."
-msgstr ""
+msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list."
+msgstr "<emph>Index</emph> is een verwijzing of getal tussen 1 en 30 waarmee aangegeven wordt welke waarde uit de lijst genomen moet worden."
-#. nR3mX
+#. GGWDt
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149939\n"
"help.text"
-msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values."
+msgid "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values."
msgstr ""
#. s64Du
@@ -27961,13 +27970,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_VDB\">Geeft als resultaat de afschrijving van activa over een bepaalde periode of gedeelte van een periode met behulp van de variabel afnemende balansmethode.</ahelp>"
-#. DSd3v
+#. pUVVr
#: 04060118.xhp
msgctxt ""
"04060118.xhp\n"
"par_id3149025\n"
"help.text"
-msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])"
+msgid "VDB(Cost; Salvage; Life; Start; End [; Factor [; NoSwitch]])"
msgstr ""
#. zGhDb
@@ -42262,6 +42271,15 @@ msgctxt ""
msgid "Name"
msgstr "Naam"
+#. 3juWm
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id401599494815994\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. PcMRq
#: 04060199.xhp
msgctxt ""
@@ -42487,6 +42505,15 @@ msgctxt ""
msgid "Name"
msgstr "Naam"
+#. CCsqC
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599495083374\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. AdNBV
#: 04060199.xhp
msgctxt ""
@@ -42685,6 +42712,15 @@ msgctxt ""
msgid "Name"
msgstr "Naam"
+#. Y4cRR
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id201599494708332\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. s2CGS
#: 04060199.xhp
msgctxt ""
@@ -42766,6 +42802,15 @@ msgctxt ""
msgid "Name"
msgstr "Naam"
+#. tfD9G
+#: 04060199.xhp
+msgctxt ""
+"04060199.xhp\n"
+"par_id521599494740206\n"
+"help.text"
+msgid "Example"
+msgstr ""
+
#. 52L2C
#: 04060199.xhp
msgctxt ""
@@ -43783,24 +43828,6 @@ msgctxt ""
msgid "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Allows you to specify a variety of formatting options and to apply attributes to the selected cells.</ahelp></variable>"
msgstr "<variable id=\"zellattributetext\"><ahelp hid=\".uno:FormatCellDialog\">Gebruik deze opdracht om uit een verscheidenheid van opmaakopties te kiezen en om eigenschappen aan de geselecteerde cellen toe te kennen.</ahelp></variable>"
-#. C3jH9
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3145785\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020300.xhp\" name=\"Numbers\">Numbers</link>"
-msgstr "<link href=\"text/shared/01/05020300.xhp\" name=\"Getallen\">Getallen</link>"
-
-#. ZgrYD
-#: 05020000.xhp
-msgctxt ""
-"05020000.xhp\n"
-"hd_id3146119\n"
-"help.text"
-msgid "<link href=\"text/shared/01/05020100.xhp\" name=\"Font\">Font</link>"
-msgstr "<link href=\"text/shared/01/05020100.xhp\" name=\"Lettertype\">Lettertype</link>"
-
#. BW9bs
#: 05020600.xhp
msgctxt ""
@@ -44638,6 +44665,15 @@ msgctxt ""
msgid "Page Style"
msgstr "Pagina-opmaakprofiel"
+#. vEZHA
+#: 05070000.xhp
+msgctxt ""
+"05070000.xhp\n"
+"bm_id651593596384469\n"
+"help.text"
+msgid "<bookmark_value>style;page</bookmark_value><bookmark_value>page;style</bookmark_value><bookmark_value>format;page</bookmark_value><bookmark_value>formatting;page</bookmark_value>"
+msgstr ""
+
#. YjqDi
#: 05070000.xhp
msgctxt ""
@@ -45367,32 +45403,32 @@ msgctxt ""
msgid "<ahelp hid=\".uno:AddPrintArea\">Adds the current selection to the defined print areas.</ahelp>"
msgstr "<ahelp hid=\".uno:AddPrintArea\">Gebruik deze opdracht om de huidige selectie toe te voegen aan de reeds vastgestelde afdrukbereiken.</ahelp>"
-#. fcvcu
+#. U9JPr
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"tit\n"
"help.text"
-msgid "Styles"
-msgstr "Opmaakprofielen"
+msgid "Styles in Calc"
+msgstr ""
-#. 3fyBn
+#. rJpRh
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"bm_id3150447\n"
"help.text"
-msgid "<bookmark_value>Stylist, see Styles window</bookmark_value> <bookmark_value>Styles window</bookmark_value> <bookmark_value>formats; Styles window</bookmark_value> <bookmark_value>formatting; Styles window</bookmark_value> <bookmark_value>paint can for applying styles</bookmark_value>"
-msgstr "<bookmark_value>Stylist, zie venster Stijlen en opmaak</bookmark_value> <bookmark_value>Stijlen en opmaak-venster</bookmark_value> <bookmark_value>opmaak; venster Stijlen en opmaak</bookmark_value> <bookmark_value>opmaken; venster Stijlen en opmaak</bookmark_value> <bookmark_value>gietermodus voor toepassen van opmaakprofielen</bookmark_value>"
+msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
+msgstr ""
-#. eA3vo
+#. WerNG
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"hd_id3150447\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
-msgstr "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Opmaakprofielen</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
+msgstr ""
#. bBG57
#: 05100000.xhp
@@ -45439,23 +45475,14 @@ msgctxt ""
msgid "Double-click the style in the Styles window."
msgstr "Dubbelklik op het opmaakprofiel in het venster Stijlen en opmaak."
-#. DCJfB
-#: 05100000.xhp
-msgctxt ""
-"05100000.xhp\n"
-"hd_id3153877\n"
-"help.text"
-msgid "Cell Styles"
-msgstr ""
-
-#. DAX9B
+#. SbgEE
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3145801\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>"
-msgstr "<ahelp hid=\".\">Geeft de lijst met de beschikbare celopmaakprofielen weer voor <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirecte celopmaak\">indirecte celopmaak</link>.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles.</ahelp>"
+msgstr ""
#. JcMEc
#: 05100000.xhp
@@ -45475,23 +45502,23 @@ msgctxt ""
msgid "Cell Styles"
msgstr "Celopmaakprofielen"
-#. hkDXo
+#. 7FwJf
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
-"hd_id3153963\n"
+"hd_id171593598056580\n"
"help.text"
-msgid "Page Styles"
+msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"page styles\">Page Styles</link>"
msgstr ""
-#. DxrsL
+#. 4XFww
#: 05100000.xhp
msgctxt ""
"05100000.xhp\n"
"par_id3147003\n"
"help.text"
-msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>"
-msgstr "<ahelp hid=\".\">Geeft de pagina-opmaakprofielen voor indirecte pagina-opmaak weer.</ahelp>"
+msgid "<ahelp hid=\".\">Displays the Page Styles available.</ahelp>"
+msgstr ""
#. cM9f4
#: 05100000.xhp
@@ -52162,6 +52189,15 @@ msgctxt ""
msgid "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp>"
msgstr "<ahelp hid=\"modules/scalc/ui/datafieldoptionsdialog/hierarchy\">Selecteer de hiërarchie die u wilt gebruiken. De draaitabel moet gebaseerd worden op een externe gegevensbron die gegevenshiërarchieën bevat.</ahelp>"
+#. ZjDq9
+#: 12090106.xhp
+msgctxt ""
+"12090106.xhp\n"
+"par_id681598453957935\n"
+"help.text"
+msgid "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details\"."
+msgstr ""
+
#. B9FE5
#: 12090200.xhp
msgctxt ""
@@ -53152,6 +53188,15 @@ msgctxt ""
msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
msgstr "Deze functie maakt deel uit van het Open Document Format voor Office Applications (OpenDocument) standaard versie 1.2. (ISO/IEC 26300: 2-2015)"
+#. BFcB6
+#: ODFF.xhp
+msgctxt ""
+"ODFF.xhp\n"
+"hd_id1000013\n"
+"help.text"
+msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3."
+msgstr ""
+
#. SGHPh
#: calculate.xhp
msgctxt ""
@@ -53179,6 +53224,24 @@ msgctxt ""
msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
msgstr ""
+#. J8xZD
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"tit\n"
+"help.text"
+msgid "Cell Styles"
+msgstr ""
+
+#. 8o4Ez
+#: cell_styles.xhp
+msgctxt ""
+"cell_styles.xhp\n"
+"hd_id811593560413206\n"
+"help.text"
+msgid "<link href=\"text/scalc/01/cell_styles.xhp\" name=\"Cell Style\">Cell Styles</link>"
+msgstr ""
+
#. AZNrM
#: common_func.xhp
msgctxt ""
@@ -54529,6 +54592,15 @@ msgctxt ""
msgid "<emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells."
msgstr ""
+#. 4BGvn
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id1001601332672155\n"
+"help.text"
+msgid "This function is always recalculated whenever a recalculation occurs."
+msgstr ""
+
#. 8DbP2
#: func_aggregate.xhp
msgctxt ""
@@ -55168,15 +55240,6 @@ msgctxt ""
msgid "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error."
msgstr "Als een cel in een bereik van waarden voor het berekenen van het gemiddelde leeg is of tekst bevat, negeert de functie GEMIDDELDE.ALS deze cel.<br/> Als de hele reeks leeg is, alleen tekst bevat of alle waarden van de reeks voldoen niet aan de voorwaarde (of een combinatie hiervan), geeft de functie de fout #DIV/0!."
-#. HSE9d
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id38832436828097\n"
-"help.text"
-msgid "In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text."
-msgstr "In alle onderstaande berekeningen, bevat het bereik voor de berekening van gemiddelden de rij #6, maar deze wordt genegeerd, omdat deze tekst bevat."
-
#. u7E4B
#: func_averageif.xhp
msgctxt ""
@@ -64366,6 +64429,15 @@ msgctxt ""
msgid "Calculation"
msgstr "Berekening"
+#. Q8ewH
+#: func_yearfrac.xhp
+msgctxt ""
+"func_yearfrac.xhp\n"
+"par_id3154502\n"
+"help.text"
+msgid "0 or missing"
+msgstr ""
+
#. CkPny
#: func_yearfrac.xhp
msgctxt ""
diff --git a/source/nl/helpcontent2/source/text/scalc/02.po b/source/nl/helpcontent2/source/text/scalc/02.po
index 24062fd56ba..5cf3a3ea070 100644
--- a/source/nl/helpcontent2/source/text/scalc/02.po
+++ b/source/nl/helpcontent2/source/text/scalc/02.po
@@ -4,8 +4,8 @@ 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: 2020-06-29 13:08+0200\n"
-"PO-Revision-Date: 2020-02-23 19:15+0000\n"
-"Last-Translator: kees538 <kees538@gmail.com>\n"
+"PO-Revision-Date: 2020-10-25 19:35+0000\n"
+"Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
"Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc02/nl/>\n"
"Language: nl\n"
"MIME-Version: 1.0\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: LibreOffice\n"
+"X-Generator: Weblate 4.1.1\n"
"X-POOTLE-MTIME: 1547980420.000000\n"
#. aSE5T
@@ -401,7 +401,7 @@ msgctxt ""
"hd_id3157909\n"
"help.text"
msgid "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Select Function</link>"
-msgstr ""
+msgstr "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Functie selecteren</link>"
#. KEkiG
#: 06030000.xhp
@@ -410,7 +410,7 @@ msgctxt ""
"par_id3150543\n"
"help.text"
msgid "<ahelp hid=\"HID_INSWIN_SUMME\">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"HID_INSWIN_SUMME\">Voeg een functie van een celbereik in de huidige cel in. De functie kan zijn Som, Gemiddelde, Minimum, Maximum en Aantal. Klik in een cel, klik op dit pictogram, selecteer de functie in de keuzelijst en pas eventueel het celbereik aan. Of selecteer enkele cellen waarin de functiewaarde wordt ingevoegd en klik vervolgens op het pictogram. Het resultaat van de functie wordt onderaan het bereik toegevoegd.</ahelp>"
#. KDxsW
#: 06030000.xhp
@@ -419,7 +419,7 @@ msgctxt ""
"par_id3153770\n"
"help.text"
msgid "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3147434\">Icon Select Function</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3147434\">Pictogram Functie selecteren</alt></image>"
#. DaEgA
#: 06030000.xhp
@@ -428,7 +428,7 @@ msgctxt ""
"par_id3152577\n"
"help.text"
msgid "Select Function"
-msgstr ""
+msgstr "Functie selecteren"
#. SpBhw
#: 06030000.xhp
@@ -437,7 +437,7 @@ msgctxt ""
"hd_id161592658402954\n"
"help.text"
msgid "Select Function applied with no selected range"
-msgstr ""
+msgstr "Selecteer de toegepaste functie zonder selectie van het bereik"
#. 59eGX
#: 06030000.xhp
@@ -446,7 +446,7 @@ msgctxt ""
"par_id3156444\n"
"help.text"
msgid "$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function."
-msgstr ""
+msgstr "$[officename] suggereert automatisch een celbereik, op voorwaarde dat het werkblad gegevens bevat. Als het celbereik al een functie bevat, kunt u deze combineren met de nieuwe functie die op de bereikgegevens wordt toegepast. Als het bereik filters bevat, wordt de functie Subtotaal ingevoegd in plaats van de geselecteerde functie."
#. vpnqf
#: 06030000.xhp
@@ -455,7 +455,7 @@ msgctxt ""
"par_id3153189\n"
"help.text"
msgid "Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>."
-msgstr ""
+msgstr "Klik op het pictogram <emph>Aanvaarden</emph> om de formule te gebruiken die wordt weergegeven in de invoerregel of <emph>Annuleren</emph>."
#. TVD6h
#: 06030000.xhp
@@ -464,7 +464,7 @@ msgctxt ""
"par_id231592663499228\n"
"help.text"
msgid "<image src=\"cmd/sc_ok.svg\" id=\"img_id521592663499228\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id171592663499228\">Accept Icon</alt></image>"
-msgstr ""
+msgstr "<image src=\"cmd/sc_ok.svg\" id=\"img_id521592663499228\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id171592663499228\">Pictogram Aanvaarden</alt></image>"
#. iHTEW
#: 06030000.xhp
@@ -473,7 +473,7 @@ msgctxt ""
"par_id481592663499228\n"
"help.text"
msgid "Accept"
-msgstr ""
+msgstr "Aanvaarden"
#. VFj6u
#: 06030000.xhp
@@ -482,7 +482,7 @@ msgctxt ""
"par_id311592663828848\n"
"help.text"
msgid "<image src=\"cmd/sc_cancel.svg\" id=\"img_id641592663828848\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id111592663828848\">Icon Cancel</alt></image>"
-msgstr ""
+msgstr "<image src=\"cmd/sc_cancel.svg\" id=\"img_id641592663828848\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id111592663828848\">Pictogram Annuleren</alt></image>"
#. 7xGcL
#: 06030000.xhp
@@ -491,7 +491,7 @@ msgctxt ""
"par_id431592663828848\n"
"help.text"
msgid "Cancel"
-msgstr ""
+msgstr "Annuleren"
#. GPtKR
#: 06030000.xhp
@@ -500,7 +500,7 @@ msgctxt ""
"hd_id261592658395518\n"
"help.text"
msgid "Select Function applied on a selected range"
-msgstr ""
+msgstr "Selecteer de functie die is toegepast op een geselecteerd bereik"
#. JPrPQ
#: 06030000.xhp
@@ -509,7 +509,7 @@ msgctxt ""
"par_id911592658130888\n"
"help.text"
msgid "When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column."
-msgstr ""
+msgstr "Wanneer het geselecteerde bereik twee of meer rijen heeft, wordt de functie voor elke kolom berekend. De resultaten worden in lege cellen op de eerste beschikbare rij onder het bereik geplaatst, één resultaat per kolom."
#. iHksB
#: 06030000.xhp
@@ -518,7 +518,7 @@ msgctxt ""
"par_id991592658144387\n"
"help.text"
msgid "When the selected range has one row, the function result is placed in the first available cell on the right of the selected range."
-msgstr ""
+msgstr "Wanneer het geselecteerde bereik één rij heeft, wordt het functieresultaat in de eerste beschikbare cel rechts van het geselecteerde bereik geplaatst."
#. NYGR7
#: 06040000.xhp
diff --git a/source/nl/helpcontent2/source/text/scalc/05.po b/source/nl/helpcontent2/source/text/scalc/05.po
index 6b49a6e55b3..9693f4bd962 100644
--- a/source/nl/helpcontent2/source/text/scalc/05.po
+++ b/source/nl/helpcontent2/source/text/scalc/05.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: 2020-03-31 10:35+0200\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
"PO-Revision-Date: 2020-10-19 12:35+0000\n"
"Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
"Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc05/nl/>\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: Weblate 4.1.1\n"
+"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1562917680.000000\n"
#. Cxzki
@@ -322,14 +322,14 @@ msgctxt ""
msgid "String overflow"
msgstr "Tekenreeksoverschrijding"
-#. h9Kok
+#. XbagT
#: 02140000.xhp
msgctxt ""
"02140000.xhp\n"
"par_id3145635\n"
"help.text"
-msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size."
-msgstr "<emph>Compiler:</emph> een identifier in de formule is groter dan 64 KB. <emph>Interpreter:</emph> een resultaat van een tekenreeksbewerking is groter dan 64 KB."
+msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 kB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 kB in size."
+msgstr ""
#. E7ohJ
#: 02140000.xhp
diff --git a/source/nl/helpcontent2/source/text/scalc/guide.po b/source/nl/helpcontent2/source/text/scalc/guide.po
index 0e27dccf3cf..88e0c063fc0 100644
--- a/source/nl/helpcontent2/source/text/scalc/guide.po
+++ b/source/nl/helpcontent2/source/text/scalc/guide.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: 2020-10-23 13:36+0200\n"
-"PO-Revision-Date: 2020-03-02 09:15+0000\n"
+"POT-Creation-Date: 2020-10-27 12:31+0100\n"
+"PO-Revision-Date: 2020-10-27 11:34+0000\n"
"Last-Translator: vpanter <Leo.Moons@proximus.be>\n"
"Language-Team: Dutch <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/nl/>\n"
"Language: nl\n"
@@ -583,23 +583,23 @@ msgctxt ""
msgid "Defining Background Colors or Background Graphics"
msgstr "Definiëren van achtergrondkleuren of achtergrondafbeeldingen"
-#. g2JnS
+#. PE8wQ
#: background.xhp
msgctxt ""
"background.xhp\n"
"bm_id3149346\n"
"help.text"
-msgid "<bookmark_value>spreadsheets; backgrounds</bookmark_value> <bookmark_value>backgrounds;cell ranges</bookmark_value> <bookmark_value>tables; backgrounds</bookmark_value> <bookmark_value>cells; backgrounds</bookmark_value> <bookmark_value>rows, see also cells</bookmark_value> <bookmark_value>columns, see also cells</bookmark_value>"
-msgstr "<bookmark_value>werkbladen; achtergronden</bookmark_value> <bookmark_value>achtergronden;celbereiken</bookmark_value> <bookmark_value>tabellen; achtergronden</bookmark_value> <bookmark_value>cellen; achtergronden</bookmark_value> <bookmark_value>rijen, zie ook cellen</bookmark_value> <bookmark_value>kolommen, zie ook cellen</bookmark_value>"
+msgid "<bookmark_value>spreadsheets; backgrounds</bookmark_value><bookmark_value>backgrounds;cell ranges</bookmark_value><bookmark_value>tables; backgrounds</bookmark_value><bookmark_value>cells; backgrounds</bookmark_value><bookmark_value>rows, see also cells</bookmark_value><bookmark_value>columns, see also cells</bookmark_value>"
+msgstr ""
-#. CqqcG
+#. tMFWU
#: background.xhp
msgctxt ""
"background.xhp\n"
"hd_id3149346\n"
"help.text"
-msgid "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Defining Background Colors or Background Graphics\">Defining Background Colors or Background Graphics</link></variable>"
-msgstr "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Definiëren van een achtergrondkleur of -afbeelding\">Definiëren van een achtergrondkleur of -afbeelding</link></variable>"
+msgid "<variable id=\"background\"><link href=\"text/scalc/guide/background.xhp\" name=\"Defining Background Colors or Background Graphics\">Defining Background Colors or Background Graphics</link> </variable>"
+msgstr ""
#. gwwiM
#: background.xhp
@@ -673,14 +673,14 @@ msgctxt ""
msgid "Select the graphic and click <emph>Open</emph>."
msgstr "Selecteer de afbeelding en klik op <emph>Openen</emph>."
-#. SDYSQ
+#. 2BGVn
#: background.xhp
msgctxt ""
"background.xhp\n"
"par_id3153575\n"
"help.text"
-msgid "The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <emph>Arrange - To Background</emph> command to place this in the background. To select a graphic that has been placed in the background, use the <switchinline select=\"appl\"><caseinline select=\"CALC\"><link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link></caseinline><defaultinline>Navigator</defaultinline></switchinline>."
-msgstr "De afbeelding wordt ingevoegd en verankerd aan de huidige cel. U kunt de afbeelding verplaatsen en de grootte wijzigen zoals u dat wilt. In uw contextmenu kunt u de opdracht <emph>Schikken - Naar achtergrond</emph> gebruiken om het op de achtergrond te plaatsen. Gebruik de <switchinline select=\"appl\"><caseinline select=\"CALC\"><link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link></caseinline><defaultinline>Navigator</defaultinline></switchinline> om een afbeelding te selecteren die op de achtergrond is geplaatst."
+msgid "The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <menuitem>Arrange - To Background</menuitem> command to place this in the background. To select a graphic that has been placed in the background, use the <link href=\"text/scalc/01/02110000.xhp\" name=\"Navigator\">Navigator</link>."
+msgstr ""
#. vTxFX
#: background.xhp
@@ -691,14 +691,14 @@ msgctxt ""
msgid "<link href=\"text/shared/guide/background.xhp\">Watermarks</link>"
msgstr "<link href=\"text/shared/guide/background.xhp\">Watermerken</link>"
-#. jQFQC
+#. R8Ctk
#: background.xhp
msgctxt ""
"background.xhp\n"
"par_id3156180\n"
"help.text"
-msgid "<link href=\"text/shared/01/05030600.xhp\" name=\"Background tab page\"><emph>Background</emph> tab page</link>"
-msgstr "<link href=\"text/shared/01/05030600.xhp\" name=\"tabblad Achtergrond\"> tabblad <emph>Achtergrond</emph></link>"
+msgid "<link href=\"text/shared/01/05210100.xhp\" name=\"Background tab page\"><emph>Background</emph> tab page</link>"
+msgstr ""
#. owozX
#: background.xhp
@@ -2471,7 +2471,7 @@ msgctxt ""
"par_id3147383\n"
"help.text"
msgid "The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href=\"text/shared/optionen/01060900.xhp\">Formula options page</link>."
-msgstr ""
+msgstr "Het voorbeeld gebruikt de formule syntaxis van Calc. Het is ook mogelijk om de formule syntaxis van Excel A1 of R1C1 te gebruiken; deze is geconfigureerd op <link href=\"text/shared/optionen/01060900.xhp\">Pagina Formule-opties</link>."
#. mK8vG
#: cellreferences.xhp
@@ -3524,7 +3524,7 @@ msgctxt ""
"par_idN108A5\n"
"help.text"
msgid "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <emph>Filter</emph> box"
-msgstr ""
+msgstr "Als het CSV-bestand een andere extensie heeft, selecteer dan het bestand en selecteer vervolgens \"Tekst CSV\" in het vak <emph>Filter</emph>."
#. FEBAD
#: csv_files.xhp
@@ -3650,7 +3650,7 @@ msgctxt ""
"par_idN1090D\n"
"help.text"
msgid "In the <emph>Filter</emph> box, select \"Text CSV\"."
-msgstr ""
+msgstr "In het vak <emph>Filter</emph> selecteert u \"Tekst CSV\"."
#. 2JC8V
#: csv_files.xhp
@@ -5686,14 +5686,14 @@ msgctxt ""
msgid "With \"Values\" you will find the results of the calculations."
msgstr "Met 'Waarden' vindt u alle resultaten van de berekeningen."
-#. xQ5ou
+#. FMaXJ
#: finding.xhp
msgctxt ""
"finding.xhp\n"
"par_id3163853\n"
"help.text"
-msgid "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. You see the currency symbol in the cell, but you cannot search for it."
-msgstr "Celinhoud kan op verschillende manieren opgemaakt worden. Zo kan een getal als valuta opgemaakt worden en weergegeven worden met een valutasymbool. U ziet het valutasymbool in de cel, maar u kunt er niet naar zoeken."
+msgid "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. These symbols are included in searches when the Formatted Display search option is activated."
+msgstr ""
#. Z4ABm
#: finding.xhp
@@ -8429,7 +8429,7 @@ msgctxt ""
"par_id6478774\n"
"help.text"
msgid "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">what-if sheet area</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">wat-als blad gebied</alt></image>."
#. KavvR
#: multioperation.xhp