update translations for 6.4.0 Beta1 libreoffice-6-4-branch-point

and force-fix errors using pocheck

Change-Id: Ibdda3a07311750204fbd7bf07294c5217b8e9f49

5 files changed, 341 insertions, 270 deletions

diff --git a/source/fr/helpcontent2/source/text/sbasic/shared.po b/source/fr/helpcontent2/source/text/sbasic/shared.po
index 5377546a4e4..fd8aca905df 100644
--- a/source/fr/helpcontent2/source/text/sbasic/shared.po
+++ b/source/fr/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: 2019-11-08 19:34+0100\n"
+"POT-Creation-Date: 2019-11-13 13:46+0100\n"
 "PO-Revision-Date: 2019-09-02 17:20+0000\n"
 "Last-Translator: Jean-Baptiste Faure <jbfaure@libreoffice.org>\n"
 "Language-Team: French <https://vm137.documentfoundation.org/projects/libo_help-master/textsbasicshared/fr/>\n"
@@ -28907,15 +28907,6 @@ msgctxt ""
 msgid "Returns the lower boundary of an array."
 msgstr "Renvoie la limite inférieure d'une matrice."
 
-#. GEEe7
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"hd_id3148538\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxe :"
-
 #. FcGvD
 #: 03102900.xhp
 msgctxt ""
@@ -28925,33 +28916,6 @@ msgctxt ""
 msgid "LBound (ArrayName [, Dimension])"
 msgstr "LBound (NomMatrice [, Dimension])"
 
-#. HhGs4
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"hd_id3150984\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valeur de retour :"
-
-#. YBMcU
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_id3153126\n"
-"help.text"
-msgid "Long"
-msgstr ""
-
-#. KdfgY
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"hd_id3144500\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paramètres :"
-
 #. KUDkg
 #: 03102900.xhp
 msgctxt ""
@@ -28970,24 +28934,6 @@ msgctxt ""
 msgid "<emph>[Dimension]:</emph> Integer that specifies which dimension to return the upper (<emph>Ubound</emph>) or the lower (<emph>LBound</emph>) boundary for. If a value is not specified, the first dimension is assumed."
 msgstr "<emph>[Dimension] :</emph> nombre entier indiquant la dimension pour laquelle la limite (<emph>Ubound</emph>) supérieure ou (<emph>LBound</emph>) inférieure doit être renvoyée. Si aucune valeur n'est indiquée, c'est la limite de la première dimension qui est renvoyée."
 
-#. AfeR2
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"hd_id3145171\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple :"
-
-#. CuAie
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_idm1206770608\n"
-"help.text"
-msgid "Sub VectorBounds"
-msgstr ""
-
 #. FEgDA
 #: 03102900.xhp
 msgctxt ""
@@ -28997,60 +28943,6 @@ msgctxt ""
 msgid "Print LBound(v()) ' returns 10"
 msgstr ""
 
-#. QkxEG
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_idm1206766048\n"
-"help.text"
-msgid "End Sub ' VectorBounds"
-msgstr ""
-
-#. iTot3
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_idm1206763792\n"
-"help.text"
-msgid "Sub TableBounds"
-msgstr ""
-
-#. tBDDP
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_id3145365\n"
-"help.text"
-msgid "Print LBound(t), UBound(t()) ' returns 10  20"
-msgstr ""
-
-#. LerBr
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_id3149665\n"
-"help.text"
-msgid "Print LBound(t(),2) ' returns - 5"
-msgstr ""
-
-#. HfdoX
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_id3159154\n"
-"help.text"
-msgid "Print UBound(t,2) ' returns 70"
-msgstr ""
-
-#. DPEj5
-#: 03102900.xhp
-msgctxt ""
-"03102900.xhp\n"
-"par_idm1206754912\n"
-"help.text"
-msgid "End Sub ' TableBounds"
-msgstr ""
-
 #. 6GB8Z
 #: 03103000.xhp
 msgctxt ""
@@ -29087,15 +28979,6 @@ msgctxt ""
 msgid "Returns the upper boundary of an array."
 msgstr "Renvoie la limite supérieure d'une matrice."
 
-#. FupXX
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"hd_id3150984\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxe :"
-
 #. M5RWy
 #: 03103000.xhp
 msgctxt ""
@@ -29105,15 +28988,6 @@ msgctxt ""
 msgid "UBound (ArrayName [, Dimension])"
 msgstr "UBound (NomMatrice [, Dimension])"
 
-#. DHhp6
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"hd_id3153897\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valeur de retour :"
-
 #. xVQ87
 #: 03103000.xhp
 msgctxt ""
@@ -29123,15 +28997,6 @@ msgctxt ""
 msgid "Long"
 msgstr ""
 
-#. GgECq
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paramètres :"
-
 #. Svuit
 #: 03103000.xhp
 msgctxt ""
@@ -29150,24 +29015,6 @@ msgctxt ""
 msgid "<emph>[Dimension]:</emph> Integer that specifies which dimension to return the upper(<emph>Ubound</emph>) or lower (<emph>LBound</emph>) boundary for. If no value is specified, the boundary of the first dimension is returned."
 msgstr "<emph>[Dimension] :</emph> nombre entier indiquant la dimension pour laquelle la limite supérieure (<emph>Ubound</emph>) ou inférieure (<emph>LBound</emph>) doit être renvoyée. Si aucune valeur n'est indiquée, c'est la limite de la première dimension qui est renvoyée."
 
-#. mfhYd
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"hd_id3153192\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple :"
-
-#. EFwDh
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"par_idm1206770608\n"
-"help.text"
-msgid "Sub VectorBounds"
-msgstr ""
-
 #. HPb5a
 #: 03103000.xhp
 msgctxt ""
@@ -29177,24 +29024,6 @@ msgctxt ""
 msgid "Print LBound(v()) ' returns 10"
 msgstr ""
 
-#. kmEXM
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"par_idm1206766048\n"
-"help.text"
-msgid "End Sub ' VectorBounds"
-msgstr ""
-
-#. khUqL
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"par_idm1206763792\n"
-"help.text"
-msgid "Sub TableBounds"
-msgstr ""
-
 #. aaaDh
 #: 03103000.xhp
 msgctxt ""
@@ -29222,15 +29051,6 @@ msgctxt ""
 msgid "Print UBound(t,2) ' returns 70"
 msgstr ""
 
-#. AkaCg
-#: 03103000.xhp
-msgctxt ""
-"03103000.xhp\n"
-"par_idm1206754912\n"
-"help.text"
-msgid "End Sub ' TableBounds"
-msgstr ""
-
 #. QHhrj
 #: 03103100.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/scalc/01.po b/source/fr/helpcontent2/source/text/scalc/01.po
index 4096150a9fc..c0873b3a36f 100644
--- a/source/fr/helpcontent2/source/text/scalc/01.po
+++ b/source/fr/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: 2019-11-08 20:19+0100\n"
+"POT-Creation-Date: 2019-11-13 13:46+0100\n"
 "PO-Revision-Date: 2019-11-05 11:58+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: French <https://vm137.documentfoundation.org/projects/libo_help-master/textscalc01/fr/>\n"
@@ -14461,15 +14461,6 @@ msgctxt ""
 msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()."
 msgstr "Pour des exemples de syntaxe supplémentaires utilisables avec SOMME.SI(), voir NB.SI()."
 
-#. Z8TrQ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id72921259523046\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>"
-msgstr ""
-
 #. BHGzQ
 #: 04060106.xhp
 msgctxt ""
@@ -19051,14 +19042,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order."
 msgstr "<ahelp hid=\"HID_FUNC_SVERWEIS\">Recherche verticale avec référence aux cellules adjacentes à droite.</ahelp> Cette fonction vérifie si une valeur spécifique est contenue dans la première colonne d'une matrice. La fonction renvoie alors la valeur dans la même ligne de la colonne nommée par <item type=\"literal\">Index</item>. Si le paramètre <item type=\"literal\">trié</item> est omis ou défini sur VRAI ou un, on suppose que les données sont triées en ordre croissant. Dans ce cas, si le <item type=\"literal\">critère_de_recherche</item> exact n'est pas trouvé, la dernière valeur qui est inférieure au critère est renvoyée. Si <item type=\"literal\">trié</item> est paramétré sur FAUX ou zéro, une correspondance exacte doit être trouvée, sinon il en résulte l'erreur <emph>Erreur: valeur non disponible</emph>. Ainsi, avec une valeur de zéro, les données n'ont pas besoin d'être triées dans l'ordre croissant."
 
-#. zQ7nD
+#. qkLkD
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3150156\n"
 "help.text"
-msgid "=VLOOKUP(SearchCriterion; Array; Index; Sorted)"
-msgstr "=RECHERCHEV(critère_de_recherche;matrice;index;trié)"
+msgid "=VLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)"
+msgstr ""
 
 #. 7FsgG
 #: 04060109.xhp
@@ -19087,14 +19078,14 @@ msgctxt ""
 msgid "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1."
 msgstr "<emph>index</emph> est le numéro de la colonne dans la matrice qui contient les valeurs devant être renvoyées. La première colonne a le numéro 1."
 
-#. y3UFE
+#. QV6iE
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3151208\n"
 "help.text"
-msgid "<emph>Sorted</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>."
-msgstr "<emph>Trié</emph> est un paramètre facultatif qui indique si la première colonne de la matrice est triée dans l'ordre croissant. Saisissez la valeur logique FAUX ou zéro si la première colonne n'est pas triée dans l'ordre croissant. La recherche sur les colonnes triées est plus rapide et la fonction renvoie toujours une valeur, même si la valeur recherchée ne correspond pas exactement, si elle est supérieure à la valeur la plus basse de la liste triée. Dans les listes non triées, la valeur recherchée doit correspondre exactement. Sinon, la fonction renvoie #N/D avec le message :  <emph>Erreur : valeur non disponible</emph>."
+msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>."
+msgstr ""
 
 #. fJQRf
 #: 04060109.xhp
@@ -19762,14 +19753,14 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column."
 msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">Effectue la recherche d'une valeur et d'une référence aux cellules situées sous la zone sélectionnée.</ahelp> Cette fonction vérifie si la première ligne d'une matrice comporte une valeur spécifique. La fonction renvoie alors la valeur dans une ligne de la matrice, nommée dans la même colonne de l'<emph>index</emph>."
 
-#. LjjvU
+#. yxeCS
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3146070\n"
 "help.text"
-msgid "HLOOKUP(SearchCriterion; Array; Index; Sorted)"
-msgstr "RECHERCHEH(critère_de_recherche;matrice;index;trié)"
+msgid "HLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)"
+msgstr ""
 
 #. nhwwF
 #: 04060109.xhp
@@ -21346,14 +21337,14 @@ msgctxt ""
 msgid "<bookmark_value>LEFTB function</bookmark_value>"
 msgstr "<bookmark_value>GAUCHEB, fonction</bookmark_value>"
 
-#. 43HxJ
+#. zjvg5
 #: 04060110.xhp
 msgctxt ""
 "04060110.xhp\n"
 "hd_id2947083\n"
 "help.text"
-msgid "LEFTB"
-msgstr "GAUCHEB"
+msgid "<variable id=\"leftbvar\"><link href=\"text/scalc/01/04060110.xhp#leftb\" name=\"LEFTB\">LEFTB</link></variable>"
+msgstr ""
 
 #. f3mWg
 #: 04060110.xhp
@@ -21508,14 +21499,14 @@ msgctxt ""
 msgid "<bookmark_value>LENB function</bookmark_value>"
 msgstr "<bookmark_value>NBCARB, fonction</bookmark_value>"
 
-#. tE3dg
+#. e5FBE
 #: 04060110.xhp
 msgctxt ""
 "04060110.xhp\n"
 "hd_id2956110\n"
 "help.text"
-msgid "LENB"
-msgstr "NBCARB"
+msgid "<variable id=\"lenbvar\"><link href=\"text/scalc/01/04060110.xhp#lenb\" name=\"LENB\">LENB</link></variable>"
+msgstr ""
 
 #. Cwz9S
 #: 04060110.xhp
@@ -21724,14 +21715,14 @@ msgctxt ""
 msgid "<bookmark_value>MIDB function</bookmark_value>"
 msgstr "<bookmark_value>STXTB, fonction</bookmark_value>"
 
-#. wekeb
+#. BxEFF
 #: 04060110.xhp
 msgctxt ""
 "04060110.xhp\n"
 "hd_id2954589\n"
 "help.text"
-msgid "MIDB"
-msgstr "STXTB"
+msgid "<variable id=\"midbvar\"><link href=\"text/scalc/01/04060110.xhp#midb\" name=\"MIDB\">MIDB</link></variable>"
+msgstr ""
 
 #. Qe8mw
 #: 04060110.xhp
@@ -22165,14 +22156,14 @@ msgctxt ""
 msgid "<bookmark_value>RIGHTB function</bookmark_value>"
 msgstr "<bookmark_value>DROITEB, fonction</bookmark_value>"
 
-#. qocbt
+#. YMkyY
 #: 04060110.xhp
 msgctxt ""
 "04060110.xhp\n"
 "hd_id2949805\n"
 "help.text"
-msgid "RIGHTB"
-msgstr "DROITEB"
+msgid "<variable id=\"rightbvar\"><link href=\"text/scalc/01/04060110.xhp#rightb\" name=\"RIGHTB\">RIGHTB</link></variable>"
+msgstr ""
 
 #. gvrHM
 #: 04060110.xhp
@@ -33172,15 +33163,6 @@ msgctxt ""
 msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>"
 msgstr "Pour additionner uniquement des valeurs négatives : <item type=\"input\">=SOMME.SI(A1:A10;\"<0\")</item>"
 
-#. jGBjw
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"hd_id224412044220134\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>"
-msgstr ""
-
 #. GWdLd
 #: 04060181.xhp
 msgctxt ""
@@ -55780,14 +55762,14 @@ msgctxt ""
 msgid "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean."
 msgstr "<emph>plage_moyenne</emph> - facultatif. C'est une plage de valeurs pour calculer la moyenne."
 
-#. brAso
+#. kCbPD
 #: func_averageif.xhp
 msgctxt ""
 "func_averageif.xhp\n"
 "par_id45123108916423\n"
 "help.text"
-msgid "Note that if the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If the <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the mean calculation.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and an operation of a string concatenation (&)."
-msgstr "Remarquez que si <emph>plage_moyenne</emph> n'est pas spécifié, <emph>plage</emph> est utilisé pour les deux, le calcul de la moyenne et la recherche en fonction de la condition. Si <emph>plage_moyenne</emph> est spécifié, l'argument <emph>plage</emph> est utilisé uniquement pour la condition de test, alors que <emph>plage_moyenne</emph> est utilisé pour le calcul de la moyenne.<br/>Le <emph>critère</emph> doit être une expression de chaîne entourée de guillemets (\"Critère\") à l'exception des noms de fonctions, références de cellules et une opération de concaténation des chaînes (&)."
+msgid "If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If  <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation."
+msgstr ""
 
 #. 8v8Zv
 #: func_averageif.xhp
@@ -57787,6 +57769,87 @@ msgctxt ""
 msgid "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error codes\">Error codes</link>"
 msgstr "<link href=\"text/scalc/05/02140000.xhp\" name=\"Codes d'erreur\">Codes d'erreur</link>"
 
+#. sUgSM
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"tit\n"
+"help.text"
+msgid "FINDB Function"
+msgstr ""
+
+#. EkUr2
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"bm_id141573508995071\n"
+"help.text"
+msgid "<bookmark_value>FINDB Function</bookmark_value>            <bookmark_value>find text;FINDB Function</bookmark_value>"
+msgstr ""
+
+#. WmZAa
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"hd_id771573508637966\n"
+"help.text"
+msgid "<variable id=\"findb\"><link href=\"text/scalc/01/func_findb.xhp\" name=\"findb\">FINDB</link></variable>"
+msgstr ""
+
+#. iW2EE
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id831573508637970\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable>"
+msgstr ""
+
+#. yA9fg
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id221573517641172\n"
+"help.text"
+msgid "FINDB( Find Text ; Text ; Position )"
+msgstr ""
+
+#. puQAw
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id241573517292388\n"
+"help.text"
+msgid "<emph>Find Text</emph>: The text or text expression to be found."
+msgstr ""
+
+#. YgyTW
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id991573517299918\n"
+"help.text"
+msgid "<emph>Text</emph>: the text in which the search is to be made."
+msgstr ""
+
+#. pfYPq
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id521573517305077\n"
+"help.text"
+msgid "<emph>Position</emph>: The position in the text where the search starts."
+msgstr ""
+
+#. VLM4H
+#: func_findb.xhp
+msgctxt ""
+"func_findb.xhp\n"
+"par_id481573517830373\n"
+"help.text"
+msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
+msgstr ""
+
 #. 2YcR7
 #: func_forecastetsadd.xhp
 msgctxt ""
@@ -60874,6 +60937,96 @@ msgctxt ""
 msgid "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>"
 msgstr "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">Expressions régulières ICU</link>"
 
+#. B64FM
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"tit\n"
+"help.text"
+msgid "REPLACEB Function"
+msgstr ""
+
+#. GfVed
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"bm_id141573508995071\n"
+"help.text"
+msgid "<bookmark_value>REPLACEB Function</bookmark_value>            <bookmark_value>replace text;REPLACEB Function</bookmark_value>"
+msgstr ""
+
+#. 5MutE
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"hd_id771573508637966\n"
+"help.text"
+msgid "<variable id=\"replaceb\"><link href=\"text/scalc/01/func_replaceb.xhp\" name=\"replaceb\">REPLACEB</link></variable>"
+msgstr ""
+
+#. djAL7
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id831573508637970\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns text where an old text is replaced with a new text, using byte positions.</ahelp></variable>"
+msgstr ""
+
+#. Fd4SC
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id701542231253817\n"
+"help.text"
+msgid "REPLACEB( Text ; Position ; Length ; NewText )"
+msgstr ""
+
+#. eY5FG
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id331573510857418\n"
+"help.text"
+msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the characters are to be replaced."
+msgstr ""
+
+#. bqPxd
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id431573510862075\n"
+"help.text"
+msgid "<emph>Position</emph>: the character position from which text is to be replaced."
+msgstr ""
+
+#. TtgNA
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id481573510866260\n"
+"help.text"
+msgid "<emph>Length</emph>: the number of characters to be replaced."
+msgstr ""
+
+#. UuACG
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id911573510871412\n"
+"help.text"
+msgid "<emph>NewText</emph>: the text to be inserted."
+msgstr ""
+
+#. QH3SH
+#: func_replaceb.xhp
+msgctxt ""
+"func_replaceb.xhp\n"
+"par_id431573515742206\n"
+"help.text"
+msgid "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> returns \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ."
+msgstr ""
+
 #. E7heY
 #: func_roundsig.xhp
 msgctxt ""
@@ -60991,6 +61144,87 @@ msgctxt ""
 msgid "See also <link href=\"text/scalc/01/04060106.xhp#Section21\" name=\"ROUND function\">ROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section7\" name=\"MROUND function\">MROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section19\" name=\"ROUNDUP function\">ROUNDUP</link>, <link href=\"text/scalc/01/04060106.xhp#Section20\" name=\"ROUNDDOWN function\">ROUNDDOWN</link>."
 msgstr "Voir également <link href=\"text/scalc/01/04060106.xhp#Section21\" name=\"ROUND function\">ARRONDI</link>, <link href=\"text/scalc/01/04060106.xhp#Section7\" name=\"MROUND function\">ARRONDI.AU.MULTIPLE</link>, <link href=\"text/scalc/01/04060106.xhp#Section19\" name=\"ROUNDUP function\">ARRONDI.SUP</link>; <link href=\"text/scalc/01/04060106.xhp#Section20\" name=\"ROUNDDOWN function\">ARRONDI.INF</link>."
 
+#. hkbrZ
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"tit\n"
+"help.text"
+msgid "SEARCHB Function"
+msgstr ""
+
+#. ennrh
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"bm_id141573508995071\n"
+"help.text"
+msgid "<bookmark_value>SEARCHB Function</bookmark_value>            <bookmark_value>search text;SEARCHB Function</bookmark_value>"
+msgstr ""
+
+#. AXnND
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"hd_id771573508637966\n"
+"help.text"
+msgid "<variable id=\"searchb\"><link href=\"text/scalc/01/func_searchb.xhp\" name=\"searchb\">SEARCHB</link></variable>"
+msgstr ""
+
+#. TySAy
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id831573508637970\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable>"
+msgstr ""
+
+#. jADhb
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id531573516878780\n"
+"help.text"
+msgid "SEARCHB( Find text ; Text ; Position)"
+msgstr ""
+
+#. 6Pmbf
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id241573517292388\n"
+"help.text"
+msgid "<emph>Find Text</emph>: The text or text expression to be found."
+msgstr ""
+
+#. ovdFE
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id991573517299918\n"
+"help.text"
+msgid "<emph>Text</emph>: the text in which the search is to be made."
+msgstr ""
+
+#. oDk8C
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id521573517305077\n"
+"help.text"
+msgid "<emph>Position</emph>: The position in the text where the search starts."
+msgstr ""
+
+#. 2E7js
+#: func_searchb.xhp
+msgctxt ""
+"func_searchb.xhp\n"
+"par_id561573517310749\n"
+"help.text"
+msgid "<input>=SEARCHB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 20."
+msgstr ""
+
 #. Mv5R9
 #: func_second.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/01.po b/source/fr/helpcontent2/source/text/shared/01.po
index f0e105b945e..dfc391ad6b3 100644
--- a/source/fr/helpcontent2/source/text/shared/01.po
+++ b/source/fr/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: 2019-11-08 19:34+0100\n"
+"POT-Creation-Date: 2019-11-13 13:46+0100\n"
 "PO-Revision-Date: 2019-07-03 10:09+0000\n"
 "Last-Translator: Jean-Baptiste Faure <jbfaure@libreoffice.org>\n"
 "Language-Team: ll.org\n"
@@ -13481,13 +13481,13 @@ msgctxt ""
 msgid "Comments"
 msgstr ""
 
-#. GpRhA
+#. Mzeni
 #: 04050000.xhp
 msgctxt ""
 "04050000.xhp\n"
 "bm_id3154100\n"
 "help.text"
-msgid "<bookmark_value>comments;inserting/editing/deleting/printing</bookmark_value>        <bookmark_value>inserting; comments</bookmark_value>        <bookmark_value>editing; comments</bookmark_value>        <bookmark_value>deleting;comments</bookmark_value>        <bookmark_value>Navigator;comments</bookmark_value>        <bookmark_value>printing;comments</bookmark_value>        <bookmark_value>records; inserting comments </bookmark_value>        <bookmark_value>remarks, see also comments</bookmark_value>"
+msgid "<bookmark_value>comments;inserting/editing/deleting/printing/resolving</bookmark_value>        <bookmark_value>comments;hide resolved</bookmark_value>        <bookmark_value>comments;resolve in text documents</bookmark_value>        <bookmark_value>inserting; comments</bookmark_value>        <bookmark_value>editing; comments</bookmark_value>        <bookmark_value>deleting;comments</bookmark_value>        <bookmark_value>Navigator;comments</bookmark_value>        <bookmark_value>printing;comments</bookmark_value>        <bookmark_value>resolving;comments</bookmark_value>        <bookmark_value>records; inserting comments </bookmark_value>        <bookmark_value>remarks, see also comments</bookmark_value>"
 msgstr ""
 
 #. t88DQ
@@ -13706,6 +13706,24 @@ msgctxt ""
 msgid "Every user with write permission to the document can edit and delete comments of all authors."
 msgstr "Chaque utilisateur ayant les droits d'écriture dans le document texte peut éditer et supprimer les commentaires de tous les auteurs."
 
+#. qJE7L
+#: 04050000.xhp
+msgctxt ""
+"04050000.xhp\n"
+"par_id0302200901430918\n"
+"help.text"
+msgid "In the <emph>Find & Replace</emph> dialog of text documents, you can select to include the comments texts in your searches."
+msgstr "Dans la boîte de dialogue <emph>Rechercher & Remplacer</emph>, sélectionnez pour inclure les textes des commentaires dans vos recherches."
+
+#. TtJvG
+#: 04050000.xhp
+msgctxt ""
+"04050000.xhp\n"
+"hd_id601573488847729\n"
+"help.text"
+msgid "Replying comments"
+msgstr ""
+
 #. XjKE5
 #: 04050000.xhp
 msgctxt ""
@@ -13715,14 +13733,32 @@ msgctxt ""
 msgid "If the comment in a text document was written by another author, there is a <emph>Reply</emph> command in the context menu. <ahelp hid=\".\">This command inserts a new comment adjacent to the comment to which you want to reply.</ahelp> The comment anchor is the same for both comments. Type your reply text in the new comment. Save and send your document to other authors, then those authors can add replies, too."
 msgstr "Si le commentaire a été écrit par un autre auteur, une commande <emph>Répondre</emph> est présente dans le menu contextuel. <ahelp hid=\".\">Cette commande insère un nouveau commentaire adjacent à celui auquel vous voulez répondre.</ahelp> L'ancre de commentaire est la même pour les deux commentaires. Saisissez le texte de la réponse dans le nouveau commentaire. Enregistrez et envoyez le document aux autres auteurs, ces auteurs pourront alors également ajouter une réponse."
 
-#. qJE7L
+#. gPtB2
 #: 04050000.xhp
 msgctxt ""
 "04050000.xhp\n"
-"par_id0302200901430918\n"
+"hd_id201573491050815\n"
 "help.text"
-msgid "In the <emph>Find & Replace</emph> dialog of text documents, you can select to include the comments texts in your searches."
-msgstr "Dans la boîte de dialogue <emph>Rechercher & Remplacer</emph>, sélectionnez pour inclure les textes des commentaires dans vos recherches."
+msgid "Marking comments resolved"
+msgstr ""
+
+#. F4jJK
+#: 04050000.xhp
+msgctxt ""
+"04050000.xhp\n"
+"par_id961573491046250\n"
+"help.text"
+msgid "When the document has been reviewed and commented and requires your action in its contents, you can mark the comment  <emph>Resolved</emph> or <emph>Unresolved</emph>. Open the comment context menu or click on the comment dropdown list to mark the Resolved checkbox. When you mark the comment resolved, the word <literal>Resolved</literal> is inserted under the date in the comment box. When marking unresolved, the word <literal>Resolved</literal> is removed."
+msgstr ""
+
+#. UBwT2
+#: 04050000.xhp
+msgctxt ""
+"04050000.xhp\n"
+"par_id521573491035753\n"
+"help.text"
+msgid "You can toggle the display of all resolved comments in the document. Hidden resolved comments are not displayed in the page margin but are not deleted. You can display back all hidden comments. Choose and mark <menuitem>View - Resolved comments</menuitem> to display the resolved comments. Unmark to hide resolved comments. The default is to display all resolved comments."
+msgstr ""
 
 #. SJFLT
 #: 04050000.xhp
diff --git a/source/fr/helpcontent2/source/text/shared/guide.po b/source/fr/helpcontent2/source/text/shared/guide.po
index b087a8e8957..493d7a1852f 100644
--- a/source/fr/helpcontent2/source/text/shared/guide.po
+++ b/source/fr/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: 2019-11-08 19:34+0100\n"
+"POT-Creation-Date: 2019-11-13 13:46+0100\n"
 "PO-Revision-Date: 2019-05-31 14:24+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -22850,15 +22850,6 @@ msgctxt ""
 msgid "Meaning"
 msgstr ""
 
-#. iVFrU
-#: start_parameters.xhp
-msgctxt ""
-"start_parameters.xhp\n"
-"par_id51571706970244\n"
-"help.text"
-msgid "<emph>--record</emph>"
-msgstr ""
-
 #. iAEUa
 #: start_parameters.xhp
 msgctxt ""
@@ -22868,15 +22859,6 @@ msgctxt ""
 msgid "An enhanced debugger."
 msgstr ""
 
-#. BUvrW
-#: start_parameters.xhp
-msgctxt ""
-"start_parameters.xhp\n"
-"par_id751571707080685\n"
-"help.text"
-msgid "<emph>--backtrace</emph>"
-msgstr ""
-
 #. VQCLF
 #: start_parameters.xhp
 msgctxt ""
@@ -22886,15 +22868,6 @@ msgctxt ""
 msgid "Prints the backtrace of the entire stack."
 msgstr ""
 
-#. hBvXq
-#: start_parameters.xhp
-msgctxt ""
-"start_parameters.xhp\n"
-"par_id171571707097883\n"
-"help.text"
-msgid "<emph>--strace</emph>"
-msgstr ""
-
 #. EybYK
 #: start_parameters.xhp
 msgctxt ""
@@ -22904,15 +22877,6 @@ msgctxt ""
 msgid "strace is a diagnostic, debugging and instructional userspace utility for Linux."
 msgstr ""
 
-#. BGjMr
-#: start_parameters.xhp
-msgctxt ""
-"start_parameters.xhp\n"
-"par_id81571707115501\n"
-"help.text"
-msgid "<emph>--valgrind</emph>"
-msgstr ""
-
 #. vGFFD
 #: start_parameters.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/swriter.po b/source/fr/helpcontent2/source/text/swriter.po
index ad4d86b342b..03165a11807 100644
--- a/source/fr/helpcontent2/source/text/swriter.po
+++ b/source/fr/helpcontent2/source/text/swriter.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: 2019-08-21 21:37+0200\n"
+"POT-Creation-Date: 2019-11-13 13:46+0100\n"
 "PO-Revision-Date: 2019-01-07 15:52+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -872,6 +872,24 @@ msgctxt ""
 msgid "Show or hide a document's comments and replies to them."
 msgstr "Affiche ou masque les commentaires d'un document et leurs réponses."
 
+#. EWoyn
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"hd_id981573492083329\n"
+"help.text"
+msgid "Resolved comments"
+msgstr ""
+
+#. DGBcc
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"par_id331573492076499\n"
+"help.text"
+msgid "Show or hide <link href=\"text/shared/01/04050000.xhp#resolvecomments\" name=\"resolve comments\">resolved comments</link>."
+msgstr ""
+
 #. DAXRW
 #: main0103.xhp
 msgctxt ""
@@ -3040,4 +3058,3 @@ msgctxt ""
 "help.text"
 msgid "You can use the <link href=\"text/shared/05/00000110.xhp\" name=\"Help system\">Help system</link> as a complete reference for $[officename] applications, including <link href=\"text/swriter/guide/main.xhp\" name=\"instructions\">instructions</link> for simple and complex tasks."
 msgstr "Vous pouvez vous servir du <link href=\"text/shared/05/00000110.xhp\" name=\"système d'aide\">système d'aide</link> comme d'une référence complète pour les applications $[officename]. Vous y trouverez notamment des <link href=\"text/swriter/guide/main.xhp\" name=\"instructions\">instructions</link> sur les tâches simples et celles plus complexes."
-