aboutsummaryrefslogtreecommitdiff
path: root/source/fr/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-03-30 18:31:40 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-03-30 18:40:10 +0200
commit7b43a13473ab1c692d33577af1ec191179e9079a (patch)
tree56ede03f882794ba911a3733e2f4b165693f59a2 /source/fr/helpcontent2
parent943a62baf90a015aac8846f3b8d88c8a49787fe7 (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I84eb112a5f299d0c0ec33a280ab490cf22ae6d46
Diffstat (limited to 'source/fr/helpcontent2')
-rw-r--r--source/fr/helpcontent2/source/text/sbasic/shared.po251
-rw-r--r--source/fr/helpcontent2/source/text/sbasic/shared/03.po744
-rw-r--r--source/fr/helpcontent2/source/text/scalc/01.po1268
-rw-r--r--source/fr/helpcontent2/source/text/scalc/guide.po16
-rw-r--r--source/fr/helpcontent2/source/text/sdatabase.po722
-rw-r--r--source/fr/helpcontent2/source/text/shared/00.po83
-rw-r--r--source/fr/helpcontent2/source/text/shared/01.po11
-rw-r--r--source/fr/helpcontent2/source/text/shared/explorer/database.po722
-rw-r--r--source/fr/helpcontent2/source/text/shared/guide.po14
-rw-r--r--source/fr/helpcontent2/source/text/simpress/guide.po6
-rw-r--r--source/fr/helpcontent2/source/text/swriter.po10
-rw-r--r--source/fr/helpcontent2/source/text/swriter/01.po29
-rw-r--r--source/fr/helpcontent2/source/text/swriter/02.po6
-rw-r--r--source/fr/helpcontent2/source/text/swriter/guide.po134
14 files changed, 1927 insertions, 2089 deletions
diff --git a/source/fr/helpcontent2/source/text/sbasic/shared.po b/source/fr/helpcontent2/source/text/sbasic/shared.po
index cc60679937e..7814f146875 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: 2021-03-19 17:31+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-02-21 17:36+0000\n"
"Last-Translator: Jean-Baptiste Faure <jbfaure@libreoffice.org>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/fr/>\n"
@@ -1988,14 +1988,14 @@ msgctxt ""
msgid "Using Variables"
msgstr "Utilisation des variables"
-#. TjAJy
+#. Wdrgx
#: 01020100.xhp
msgctxt ""
"01020100.xhp\n"
"bm_id3149346\n"
"help.text"
-msgid "<bookmark_value>names of variables</bookmark_value> <bookmark_value>variables; using</bookmark_value> <bookmark_value>types of variables</bookmark_value> <bookmark_value>declaring variables</bookmark_value> <bookmark_value>values;of variables</bookmark_value> <bookmark_value>literals;integer</bookmark_value> <bookmark_value>literals;hexadecimal</bookmark_value> <bookmark_value>literals;integer</bookmark_value> <bookmark_value>literals;octal</bookmark_value> <bookmark_value>literals;&h notation</bookmark_value> <bookmark_value>literals;&o notation</bookmark_value> <bookmark_value>literals;floating-point</bookmark_value> <bookmark_value>constants</bookmark_value> <bookmark_value>arrays;declaring</bookmark_value> <bookmark_value>defining;constants</bookmark_value>"
-msgstr "<bookmark_value>Noms des variables</bookmark_value><bookmark_value>Variables;utilisation</bookmark_value><bookmark_value>Types de variables</bookmark_value><bookmark_value>Déclaration des variables</bookmark_value><bookmark_value>Valeurs;des variables</bookmark_value> <bookmark_value>Literals;entier</bookmark_value><bookmark_value>Literals;hexadécimal</bookmark_value> <bookmark_value>Literals;entiers</bookmark_value><bookmark_value>Literals;octal</bookmark_value> <bookmark_value>Literals;&h notation</bookmark_value><bookmark_value>Literals;&o notation</bookmark_value><bookmark_value>Literals;point flottan</bookmark_value> <bookmark_value>Constantes</bookmark_value><bookmark_value>Matrices;déclaration</bookmark_value> <bookmark_value>Définition;constantes</bookmark_value>"
+msgid "<bookmark_value>names of variables</bookmark_value> <bookmark_value>variables; using</bookmark_value> <bookmark_value>types of variables</bookmark_value> <bookmark_value>declaring variables</bookmark_value> <bookmark_value>values;of variables</bookmark_value> <bookmark_value>literals;date</bookmark_value> <bookmark_value>literals;integer</bookmark_value> <bookmark_value>literals;hexadecimal</bookmark_value> <bookmark_value>literals;integer</bookmark_value> <bookmark_value>literals;octal</bookmark_value> <bookmark_value>literals;&h notation</bookmark_value> <bookmark_value>literals;&o notation</bookmark_value> <bookmark_value>literals;floating-point</bookmark_value> <bookmark_value>constants</bookmark_value> <bookmark_value>arrays;declaring</bookmark_value> <bookmark_value>defining;constants</bookmark_value>"
+msgstr ""
#. VAkCC
#: 01020100.xhp
@@ -2483,6 +2483,60 @@ msgctxt ""
msgid "Date variables can only contain dates and time values stored in an internal format. Values assigned to Date variables with <link href=\"text/sbasic/shared/03030101.xhp\" name=\"Dateserial\"><emph>Dateserial</emph></link>, <link href=\"text/sbasic/shared/03030102.xhp\" name=\"Datevalue\"><emph>Datevalue</emph></link>, <link href=\"text/sbasic/shared/03030205.xhp\" name=\"Timeserial\"><emph>Timeserial</emph></link> or <link href=\"text/sbasic/shared/03030206.xhp\" name=\"Timevalue\"><emph>Timevalue</emph></link> are automatically converted to the internal format. Date-variables are converted to normal numbers by using the <link href=\"text/sbasic/shared/03030103.xhp\" name=\"Day\"><emph>Day</emph></link>, <link href=\"text/sbasic/shared/03030104.xhp\" name=\"Month\"><emph>Month</emph></link>, <link href=\"text/sbasic/shared/03030106.xhp\" name=\"Year\"><emph>Year</emph></link> or the <link href=\"text/sbasic/shared/03030201.xhp\" name=\"Hour\"><emph>Hour</emph></link>, <link href=\"text/sbasic/shared/03030202.xhp\" name=\"Minute\"><emph>Minute</emph></link>, <link href=\"text/sbasic/shared/03030204.xhp\" name=\"Second\"><emph>Second</emph></link> function. The internal format enables a comparison of date/time values by calculating the difference between two numbers. These variables can only be declared with the key word <emph>Date</emph>."
msgstr "Les variables de date ne peuvent contenir que des valeurs de date et d'heure stockées dans un format interne. Les valeurs assignées aux variables de date par <link href=\"text/sbasic/shared/03030101.xhp\" name=\"Dateserial\"><emph>Dateserial</emph></link>, <link href=\"text/sbasic/shared/03030102.xhp\" name=\"Datevalue\"><emph>Datevalue</emph></link>, <link href=\"text/sbasic/shared/03030205.xhp\" name=\"Timeserial\"><emph>Timeserial</emph></link> oo <link href=\"text/sbasic/shared/03030206.xhp\" name=\"Timevalue\"><emph>Timevalue</emph></link> sont automatiquement converties au format interne. Les variables de date sont converties en nombres normaux à l'aide de la fonction <link href=\"text/sbasic/shared/03030103.xhp\" name=\"Day\"><emph>Day</emph></link>, <link href=\"text/sbasic/shared/03030104.xhp\" name=\"Month\"><emph>Month</emph></link>, <link href=\"text/sbasic/shared/03030106.xhp\" name=\"Year\"><emph>Year</emph></link>, <link href=\"text/sbasic/shared/03030201.xhp\" name=\"Hour\"><emph>Hour</emph></link>, <link href=\"text/sbasic/shared/03030202.xhp\" name=\"Minute\"><emph>Minute</emph></link> ou <link href=\"text/sbasic/shared/03030204.xhp\" name=\"Second\"><emph>Second</emph></link>. Le format interne permet de comparer des valeurs date/heure par calcul de la différence entre deux nombres. Ces variables ne peuvent être déclarées qu'avec le mot-clé <emph>Date</emph>."
+#. x883R
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"hd_DateLiterals\n"
+"help.text"
+msgid "Literals for Dates"
+msgstr ""
+
+#. 5FGDA
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id151616083357363\n"
+"help.text"
+msgid "Date literals allow to specify unambiguous date variables that are independent from the current language. Literals are enclosed between hash signs <literal>#</literal>. Possible formats are:"
+msgstr ""
+
+#. 6nnHF
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id41616083766108\n"
+"help.text"
+msgid "#<literal>yyyy-mm-dd</literal>#"
+msgstr ""
+
+#. oRsER
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id271616083874773\n"
+"help.text"
+msgid "<literal>#mm/dd/yyyy#</literal>"
+msgstr ""
+
+#. targE
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id201616314705492\n"
+"help.text"
+msgid "zeroDay = #12/30/1899#"
+msgstr ""
+
+#. DZK5o
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id616163714705267\n"
+"help.text"
+msgid "dob = #2010-09-28#"
+msgstr ""
+
#. kGGKi
#: 01020100.xhp
msgctxt ""
@@ -14464,32 +14518,23 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03030110.xhp\">DateAdd Function</link>"
msgstr "<link href=\"text/sbasic/shared/03030110.xhp\">Fonction DateAdd</link>"
-#. R9EVm
+#. HhA3U
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN10558\n"
"help.text"
-msgid "Adds a date interval to a given date a number of times and returns the resulting date."
-msgstr "Ajoute plusieurs fois à une date donnée un intervalle de dates, puis renvoie la date obtenue."
-
-#. 32PPG
-#: 03030110.xhp
-msgctxt ""
-"03030110.xhp\n"
-"par_idN1055B\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxe :"
+msgid "Adds a date or time interval to a given date a number of times and returns the resulting date."
+msgstr ""
-#. DJGhH
+#. YAQVF
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN1055F\n"
"help.text"
-msgid "DateAdd (Add, Count, Date)"
-msgstr "DateAdd (Ajouter, Nombre, Date)"
+msgid "DateAdd (interval As String, number As Long, date As Date) As Date"
+msgstr ""
#. Gt9cm
#: 03030110.xhp
@@ -14509,32 +14554,23 @@ msgctxt ""
msgid "A Variant containing a date."
msgstr "Un variant contenant une date."
-#. pMyfk
-#: 03030110.xhp
-msgctxt ""
-"03030110.xhp\n"
-"par_idN10625\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paramètres :"
-
-#. ifRp8
+#. q4zev
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN10629\n"
"help.text"
-msgid "<emph>Add</emph> - A string expression from the following table, specifying the date interval."
-msgstr "<emph>Ajouter</emph> : expression de chaîne provenant de la table suivante, spécifiant l'intervalle de dates."
+msgid "<emph>interval</emph> - A string expression from the following table, specifying the date or time interval."
+msgstr ""
-#. XG5fJ
+#. yKYH5
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN10636\n"
"help.text"
-msgid "Add (string value)"
-msgstr "Ajouter (valeur de chaîne)"
+msgid "interval (string value)"
+msgstr ""
#. BrkDy
#: 03030110.xhp
@@ -14725,32 +14761,23 @@ msgctxt ""
msgid "Second"
msgstr "Seconde"
-#. 7CC9B
+#. heZE2
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN106C1\n"
"help.text"
-msgid "<emph>Count</emph> - A numerical expression specifying how often the Add interval will be added (Count is positive) or subtracted (Count is negative)."
-msgstr "<emph>Nombre</emph> : expression numérique spécifiant la fréquence à laquelle l'intervalle d'ajout est ajouté (nombre positif) ou soustrait (nombre négatif)."
+msgid "<emph>number</emph> - A numerical expression specifying how often the <literal>interval</literal> value will be added when positive or subtracted when negative."
+msgstr ""
-#. fxLyq
+#. 5LaBf
#: 03030110.xhp
msgctxt ""
"03030110.xhp\n"
"par_idN106C4\n"
"help.text"
-msgid "<emph>Date</emph> - A given date or the name of a Variant variable containing a date. The Add value will be added Count times to this value."
-msgstr "<emph>Date</emph> : date spécifiée ou nom de la variable Variant contenant une date. La valeur d'ajout est ajoutée à cette valeur du nombre de fois correspondant au paramètre Nombre."
-
-#. fEW8A
-#: 03030110.xhp
-msgctxt ""
-"03030110.xhp\n"
-"par_idN106C7\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple :"
+msgid "<emph>date</emph> - A given date or the name of a Variant variable containing a date. The <literal>interval</literal> value will be added <literal>number</literal> times to this date."
+msgstr ""
#. kvCPX
#: 03030111.xhp
@@ -15373,32 +15400,23 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03030120.xhp\">DateDiff Function</link>"
msgstr "<link href=\"text/sbasic/shared/03030120.xhp\">Fonction DateDiff</link>"
-#. MsJG6
+#. kAC7A
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN10546\n"
"help.text"
-msgid "Returns the number of date intervals between two given date values."
-msgstr "Renvoie le nombre d'intervalles de dates compris entre deux valeurs de dates spécifiées."
-
-#. jwneU
-#: 03030120.xhp
-msgctxt ""
-"03030120.xhp\n"
-"par_idN10549\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxe :"
+msgid "Returns the number of date or time intervals between two given date values."
+msgstr ""
-#. 23hun
+#. AzmeS
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN10648\n"
"help.text"
-msgid "DateDiff (Add, Date1, Date2 [, Week_start [, Year_start]])"
-msgstr "DateDiff (Ajouter, Date1, Date2 [, Semaine_début [, Année_début]])"
+msgid "DateDiff (interval As String, date1 As Date, date2 As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Double"
+msgstr ""
#. BPDH8
#: 03030120.xhp
@@ -15418,50 +15436,41 @@ msgctxt ""
msgid "A number."
msgstr "un nombre."
-#. PhvCn
-#: 03030120.xhp
-msgctxt ""
-"03030120.xhp\n"
-"par_idN10652\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paramètres :"
-
-#. VPj7H
+#. pnAQD
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN10656\n"
"help.text"
-msgid "<emph>Add</emph> - A string expression from the following table, specifying the date interval."
-msgstr "<emph>Ajouter</emph> : expression de chaîne provenant de la table suivante, spécifiant l'intervalle de dates."
+msgid "<emph>interval</emph> - A string expression from the following table, specifying the date or time interval."
+msgstr ""
-#. DDkPg
+#. Exz6j
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN10664\n"
"help.text"
-msgid "<emph>Date1, Date2</emph> - The two date values to be compared."
-msgstr "<emph>Date1, Date2</emph> : les deux valeurs de dates à comparer."
+msgid "<emph>date1, date2</emph> - The two date values to be compared."
+msgstr ""
-#. pxADB
+#. yVo8Q
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN1066A\n"
"help.text"
-msgid "<emph>Week_start</emph> - An optional parameter that specifies the starting day of a week."
-msgstr "<emph>Semaine_début</emph> : paramètre facultatif spécifiant le premier jour de la semaine."
+msgid "<emph>firstDayOfWeek</emph> - An optional parameter that specifies the starting day of a week."
+msgstr ""
-#. NtgAZ
+#. dDoRU
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN1067A\n"
"help.text"
-msgid "Week_start value"
-msgstr "Valeur de Semaine_début"
+msgid "firstDayOfWeek value"
+msgstr ""
#. gmaR8
#: 03030120.xhp
@@ -15616,23 +15625,23 @@ msgctxt ""
msgid "Saturday"
msgstr "Samedi"
-#. sVAum
+#. BLhqf
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN106EB\n"
"help.text"
-msgid "<emph>Year_start</emph> - An optional parameter that specifies the starting week of a year."
-msgstr "<emph>Année_début</emph> : paramètre optionnel spécifiant la première semaine de l'année."
+msgid "<emph>firstWeekOfYear</emph> - An optional parameter that specifies the starting week of a year."
+msgstr ""
-#. rKUUc
+#. KGncd
#: 03030120.xhp
msgctxt ""
"03030120.xhp\n"
"par_idN106FB\n"
"help.text"
-msgid "Year_start value"
-msgstr "Valeur de Année_début"
+msgid "firstWeekOfYear value"
+msgstr ""
#. zAFFS
#: 03030120.xhp
@@ -15715,15 +15724,6 @@ msgctxt ""
msgid "Week 1 is the first week containing only days of the new year"
msgstr "La semaine 1 est la première semaine contenant uniquement des jours de la nouvelle année"
-#. fpPpz
-#: 03030120.xhp
-msgctxt ""
-"03030120.xhp\n"
-"par_idN10738\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple :"
-
#. pA2jY
#: 03030130.xhp
msgctxt ""
@@ -15760,23 +15760,14 @@ msgctxt ""
msgid "The DatePart function returns a specified part of a date."
msgstr "La fonction DatePart renvoie la partie spécifiée de la date."
-#. FKbf2
-#: 03030130.xhp
-msgctxt ""
-"03030130.xhp\n"
-"par_idN10549\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaxe :"
-
-#. GaBLY
+#. GWMCJ
#: 03030130.xhp
msgctxt ""
"03030130.xhp\n"
"par_idN105E8\n"
"help.text"
-msgid "DatePart (Add, Date [, Week_start [, Year_start]])"
-msgstr "DatePart (Ajouter, Date [, Semaine_début [, Année_début]])"
+msgid "DatePart (interval As String, date As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Long"
+msgstr ""
#. wi5B9
#: 03030130.xhp
@@ -15787,50 +15778,32 @@ msgctxt ""
msgid "Return value:"
msgstr "Valeur de retour :"
-#. rL6eH
+#. V53FC
#: 03030130.xhp
msgctxt ""
"03030130.xhp\n"
"par_idN105EF\n"
"help.text"
-msgid "A Variant containing a date."
-msgstr "Un variant contenant une date."
-
-#. uFBWR
-#: 03030130.xhp
-msgctxt ""
-"03030130.xhp\n"
-"par_idN105F2\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Paramètres :"
+msgid "The extracted part for the given date."
+msgstr ""
-#. zrGbe
+#. fT65v
#: 03030130.xhp
msgctxt ""
"03030130.xhp\n"
"par_idN105F6\n"
"help.text"
-msgid "<emph>Add</emph> - A string expression from the following table, specifying the date interval."
-msgstr "<emph>Ajouter</emph> : expression de chaîne provenant de la table suivante, spécifiant l'intervalle de dates."
+msgid "<emph>interval</emph> - A string expression from the following table, specifying the date interval."
+msgstr ""
-#. rDG6m
+#. CFxRq
#: 03030130.xhp
msgctxt ""
"03030130.xhp\n"
"par_idN10604\n"
"help.text"
-msgid "<emph>Date</emph> - The date from which the result is calculated."
-msgstr "<emph>Date</emph> : date à partir de laquelle est calculé le résultat."
-
-#. 9DCFV
-#: 03030130.xhp
-msgctxt ""
-"03030130.xhp\n"
-"par_idN10611\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemple :"
+msgid "<emph>date</emph> - The date from which the result is calculated."
+msgstr ""
#. tzm8A
#: 03030200.xhp
diff --git a/source/fr/helpcontent2/source/text/sbasic/shared/03.po b/source/fr/helpcontent2/source/text/sbasic/shared/03.po
index 857819034e0..83172d308f9 100644
--- a/source/fr/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/fr/helpcontent2/source/text/sbasic/shared/03.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: 2021-03-23 11:44+0100\n"
+"POT-Creation-Date: 2021-03-30 18:07+0200\n"
"PO-Revision-Date: 2021-02-09 20:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/fr/>\n"
@@ -5947,15 +5947,6 @@ msgctxt ""
msgid "The <literal>DialogControl</literal> service is available for these control types:"
msgstr ""
-#. ScLTk
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id171612698897514\n"
-"help.text"
-msgid "TreeControl"
-msgstr ""
-
#. 7xddb
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6019,15 +6010,6 @@ msgctxt ""
msgid "No"
msgstr ""
-#. jqpFz
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id231598538847029\n"
-"help.text"
-msgid "Button"
-msgstr ""
-
#. aTyMC
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6631,15 +6613,6 @@ msgctxt ""
msgid "UNO<br/>object"
msgstr ""
-#. 3Dmwo
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id25161269944611\n"
-"help.text"
-msgid "TreeControl"
-msgstr ""
-
#. 7XckG
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6685,15 +6658,6 @@ msgctxt ""
msgid "Description"
msgstr ""
-#. kfK2B
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id271598543254590\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
#. jEyx9
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6721,15 +6685,6 @@ msgctxt ""
msgid "0, False: not checked<br/>1, True: checked<br/>2: grayed, don't know"
msgstr ""
-#. EKHtH
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id781598543254887\n"
-"help.text"
-msgid "String"
-msgstr ""
-
#. nZVA5
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6748,24 +6703,6 @@ msgctxt ""
msgid "Numeric"
msgstr ""
-#. DoCfT
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id401598543254743\n"
-"help.text"
-msgid "Date"
-msgstr ""
-
-#. XzBhY
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id731598543254544\n"
-"help.text"
-msgid "String"
-msgstr ""
-
#. kgfXR
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6811,15 +6748,6 @@ msgctxt ""
msgid "Numeric"
msgstr ""
-#. CCkkF
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id81598543254625\n"
-"help.text"
-msgid "String"
-msgstr ""
-
#. YvPAp
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6838,15 +6766,6 @@ msgctxt ""
msgid "Must be within the predefined bounds"
msgstr ""
-#. veFie
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id561598543254115\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
#. ZragT
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6874,15 +6793,6 @@ msgctxt ""
msgid "Must be within the predefined bounds"
msgstr ""
-#. 5VuCQ
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id751598543254299\n"
-"help.text"
-msgid "String"
-msgstr ""
-
#. a9AMF
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -6892,15 +6802,6 @@ msgctxt ""
msgid "The text appearing in the field"
msgstr ""
-#. wGGjL
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id341598543254600\n"
-"help.text"
-msgid "Date"
-msgstr ""
-
#. CABLr
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -7414,22 +7315,22 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event."
msgstr ""
-#. t5Kcc
+#. BSnCr
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id541613670199211\n"
"help.text"
-msgid "One argument out of <literal>DisplayValue</literal>or <literal>DataValue</literal> must be specified. If both present, one match is sufficient to select the node."
+msgid "One argument out of <literal>DisplayValue</literal> or <literal>DataValue</literal> must be specified. If both present, one match is sufficient to select the node."
msgstr ""
-#. KMPVF
+#. fYkEn
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id591612781589560\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The pattern to be matched. See the <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"Sting service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method. When equal to the zero-length string (default), this display value is not searched for."
+msgid "<emph>DisplayValue</emph>: The pattern to be matched. See the <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"String service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method. When equal to the zero-length string (default), this display value is not searched for."
msgstr ""
#. CF4o6
@@ -7486,13 +7387,13 @@ msgctxt ""
msgid "An error is raised if the actual control is not of the type <literal>TextField</literal> or is not multiline."
msgstr ""
-#. AKiEA
+#. jmBh7
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id1001584541257789\n"
"help.text"
-msgid "<emph>Line</emph>: The string to insert. Default is an empty line."
+msgid "<emph>Line</emph>: The string to insert. Default is an empty line."
msgstr ""
#. opNus
@@ -10366,15 +10267,6 @@ msgctxt ""
msgid "<emph>Filter</emph>: A string containing wildcards (\"?\" and \"*\") that will be applied to the resulting list of files (default = \"\")."
msgstr ""
-#. HJ9vL
-#: sf_filesystem.xhp
-msgctxt ""
-"sf_filesystem.xhp\n"
-"bas_id451583944327508\n"
-"help.text"
-msgid "filesList = FSO.Files(\"/home/user/\", \"*.txt\")"
-msgstr ""
-
#. zG7ec
#: sf_filesystem.xhp
msgctxt ""
@@ -10699,13 +10591,13 @@ msgctxt ""
msgid "<emph>Destination</emph>: If <literal>Source</literal> is a <literal>FileName</literal> then this parameter indicates the new path and file name of the moved file."
msgstr ""
-#. E7BHq
+#. E4opD
#: sf_filesystem.xhp
msgctxt ""
"sf_filesystem.xhp\n"
"par_id31613063334246\n"
"help.text"
-msgid "If the move operation involves multiple files, then Destination must be a folder name. If it does not exist, it is created."
+msgid "If the move operation involves multiple files, then <literal>Destination</literal> must be a folder name. If it does not exist, it is created."
msgstr ""
#. BvhBP
@@ -10780,13 +10672,13 @@ msgctxt ""
msgid "<emph>Destination</emph>: If the move operation involves a single folder, then <literal>Destination</literal> is the name and path of the moved folder and it must not exist."
msgstr ""
-#. upwt8
+#. rNbq3
#: sf_filesystem.xhp
msgctxt ""
"sf_filesystem.xhp\n"
"par_id11613072890641\n"
"help.text"
-msgid "If multiple folders are being moved, then <literal>Destination</literal> designates where the folders in <literal>Source</literal> will be moved into. If <literal>Source</literal> does not exist, it is created."
+msgid "If multiple folders are being moved, then <literal>Destination</literal> designates where the folders in <literal>Source</literal> will be moved into. If <literal>Destination</literal> does not exist, it is created."
msgstr ""
#. DFBsa
@@ -11230,15 +11122,6 @@ msgctxt ""
msgid "The example below specifies the folder containing the PO files. Because the locale is not defined, the service instance will use the current %PRODUCTNAME locale settings."
msgstr ""
-#. RmYkJ
-#: sf_l10n.xhp
-msgctxt ""
-"sf_l10n.xhp\n"
-"bas_id451614358683971\n"
-"help.text"
-msgid "Set myPO = CreateScriptService(\"L10N\", \"C:\\myPOFiles\\\")"
-msgstr ""
-
#. Ab7iH
#: sf_l10n.xhp
msgctxt ""
@@ -11275,15 +11158,6 @@ msgctxt ""
msgid "It is recommended to free resources after use:"
msgstr ""
-#. M9GLd
-#: sf_l10n.xhp
-msgctxt ""
-"sf_l10n.xhp\n"
-"bm_id871614359551930\n"
-"help.text"
-msgid "<bookmark_value>L10N service;Folder</bookmark_value> <bookmark_value>L10N service;Languages</bookmark_value> <bookmark_value>L10N service;Locale</bookmark_value>"
-msgstr ""
-
#. 6mcLb
#: sf_l10n.xhp
msgctxt ""
@@ -11608,31 +11482,13 @@ msgctxt ""
msgid "Consider the following code is running on a %PRODUCTNAME installation with locale set to \"es-ES\". Additionally, there is a file \"es-ES.po\" inside the specified folder that translates the string passed to the <literal>GetText</literal> method:"
msgstr ""
-#. Kz4S7
-#: sf_l10n.xhp
-msgctxt ""
-"sf_l10n.xhp\n"
-"bas_id171614366110835\n"
-"help.text"
-msgid "myPO = CreateScriptService(\"L10N\", \"c:\\MyPOFolder\\\")"
-msgstr ""
-
-#. EcBzr
-#: sf_l10n.xhp
-msgctxt ""
-"sf_l10n.xhp\n"
-"bas_id1001586166834936\n"
-"help.text"
-msgid "' \"¡Bienvenido John! Espero que disfrutes de este programa\""
-msgstr ""
-
-#. H4aXx
+#. zJaES
#: sf_l10n.xhp
msgctxt ""
"sf_l10n.xhp\n"
"par_id301613075694148\n"
"help.text"
-msgid "<link href=\"text/sbasic/guide/translation.xhp\" name=\"Controls Translation\"> Translation of Controls in the Dialog Editor</link>"
+msgid "<link href=\"text/sbasic/guide/translation.xhp\" name=\"Controls Translation\">Translation of Controls in the Dialog Editor</link>"
msgstr ""
#. Ah5Gj
@@ -11680,13 +11536,13 @@ msgctxt ""
msgid "Operating system information (OS type, release, version, etc)"
msgstr ""
-#. uPLtj
+#. 6sN8Q
#: sf_platform.xhp
msgctxt ""
"sf_platform.xhp\n"
"par_id67160078807676\n"
"help.text"
-msgid "The LibreOffice version"
+msgid "The %PRODUCTNAME version"
msgstr ""
#. BrEr7
@@ -11815,13 +11671,13 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. g5EUJ
+#. v3N6U
#: sf_platform.xhp
msgctxt ""
"sf_platform.xhp\n"
"par_id541600788076645\n"
"help.text"
-msgid "The number of central processor units."
+msgid "The number of central processing units."
msgstr ""
#. 89Lo8
@@ -11869,13 +11725,13 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. 9uRw8
+#. WLRju
#: sf_platform.xhp
msgctxt ""
"sf_platform.xhp\n"
"par_id521600788076371\n"
"help.text"
-msgid "The actual LibreOffice version expressed as<br/>'<literal>LibreOffice w.x.y.z (The Document Foundation)</literal>'."
+msgid "The actual %PRODUCTNAME version expressed as<br/>' <literal>%PRODUCTNAME w.x.y.z (The Document Foundation)</literal>'."
msgstr ""
#. 4bpcJ
@@ -12166,13 +12022,13 @@ msgctxt ""
msgid "Called to register a library event manager by <literal>RegisterScriptServices</literal>."
msgstr ""
-#. VC4em
+#. sZBHB
#: sf_services.xhp
msgctxt ""
"sf_services.xhp\n"
"par_id741582712156448\n"
"help.text"
-msgid "Called by user scripts to get an object giving access to the service given as argument. <br/>All services should be invoked thru the <literal>CreateScriptService</literal> method."
+msgid "Called by user scripts to get an object giving access to the service given as argument. <br/>All services should be invoked through the <literal>CreateScriptService</literal> method."
msgstr ""
#. 9Geac
@@ -12229,24 +12085,6 @@ msgctxt ""
msgid "or a set of methods and properties gathered in a Basic class module."
msgstr ""
-#. tR7ys
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id431582714020044\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. SpGFT
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id251582714020044\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. VuLrG
#: sf_services.xhp
msgctxt ""
@@ -12265,15 +12103,6 @@ msgctxt ""
msgid "<emph>arg0, ...</emph>: A list of arguments required by the invoked service. <br/>If the first argument refers to an event manager, then arg0 is mandatory and must be the UNO object representing the event provided as argument to the user macro."
msgstr ""
-#. imGjJ
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id91582714020046\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. wuR7S
#: sf_services.xhp
msgctxt ""
@@ -12400,15 +12229,6 @@ msgctxt ""
msgid "\"LibraryName.ModuleName.FunctionName\" ' String"
msgstr ""
-#. 8QWvK
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id351582722979618\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. uej6R
#: sf_services.xhp
msgctxt ""
@@ -12481,24 +12301,6 @@ msgctxt ""
msgid "The method returns <literal>True</literal> if the name-value pair given as argument could be registered successfully."
msgstr ""
-#. hm3aY
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id701595857355894\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. 7U5MA
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id1159585735573\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. ELGxD
#: sf_services.xhp
msgctxt ""
@@ -12517,15 +12319,6 @@ msgctxt ""
msgid "<emph>ServiceReference</emph>: A service reference is either:"
msgstr ""
-#. EnhtA
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id481595857355966\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. cmHCE
#: sf_services.xhp
msgctxt ""
@@ -12553,24 +12346,6 @@ msgctxt ""
msgid "The method returns <literal>True</literal> if the name-value pair given as argument could be registered successfully."
msgstr ""
-#. hXBCv
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id151596299279417\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. biZdX
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id421596299279275\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. Ky8rX
#: sf_services.xhp
msgctxt ""
@@ -12589,15 +12364,6 @@ msgctxt ""
msgid "<emph>ServiceReference</emph>: A string designating the function to execute to get an instance of the service. It is in fact the function containing the <literal>New</literal> keyword of a <link href=\"text/sbasic/shared/03103700.xhp\" name=\"Set statement\">Set</link> statement creating the instance.:"
msgstr ""
-#. 3DmHk
-#: sf_services.xhp
-msgctxt ""
-"sf_services.xhp\n"
-"hd_id631596299279349\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. FKFAC
#: sf_services.xhp
msgctxt ""
@@ -12814,24 +12580,6 @@ msgctxt ""
msgid "If the script is not found, or if it returns nothing, the returned value is <literal>Empty</literal>."
msgstr ""
-#. QqRGF
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id931582815407230\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. DSXJQ
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id491582815407231\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. bWiEa
#: sf_session.xhp
msgctxt ""
@@ -12859,15 +12607,6 @@ msgctxt ""
msgid "<emph>arg0, ...</emph>: The arguments to provide to the called script."
msgstr ""
-#. sMGpX
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id831582815407231\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. bvuhY
#: sf_session.xhp
msgctxt ""
@@ -12886,24 +12625,6 @@ msgctxt ""
msgid "Execute a Calc function using its English name and based on the given arguments. <br/>If the arguments are arrays, the function is executed as an <link href=\"text/scalc/01/04060107.xhp\" name=\"array formula\">array formula</link>."
msgstr ""
-#. njbYK
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id391582816585182\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. BDHmP
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id711582816585182\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. gG7vu
#: sf_session.xhp
msgctxt ""
@@ -12922,15 +12643,6 @@ msgctxt ""
msgid "<emph>arg0, ...</emph>: The arguments to provide to the called Calc function. Each argument must be either a string, a numeric value or an array of arrays combining those types."
msgstr ""
-#. 8bZb8
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id891582816585184\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. XMfUD
#: sf_session.xhp
msgctxt ""
@@ -12958,24 +12670,6 @@ msgctxt ""
msgid "If the script is not found, or if it returns nothing, the returned value is <literal>Empty</literal>."
msgstr ""
-#. yxEDA
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id741582818023245\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. oCchM
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id81582818023246\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. JsjbE
#: sf_session.xhp
msgctxt ""
@@ -13039,15 +12733,6 @@ msgctxt ""
msgid "<emph>arg0, ...</emph>: The arguments to provide to the called script."
msgstr ""
-#. CBkpV
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id141582818023247\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. Lv4iA
#: sf_session.xhp
msgctxt ""
@@ -13057,24 +12742,6 @@ msgctxt ""
msgid "Returns <literal>True</literal> if an UNO object contains the given method. Returns <literal>False</literal> when the method is not found or when an argument is invalid."
msgstr ""
-#. KfxYm
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id381587477335874\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. mgr64
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id471587477335769\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. AmYDH
#: sf_session.xhp
msgctxt ""
@@ -13093,15 +12760,6 @@ msgctxt ""
msgid "<emph>MethodName</emph>: the method as a case-sensitive string"
msgstr ""
-#. BQT9v
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id601587477335985\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. gDBRB
#: sf_session.xhp
msgctxt ""
@@ -13111,24 +12769,6 @@ msgctxt ""
msgid "Returns <literal>True</literal> if a UNO object has the given property. Returns <literal>False</literal> when the property is not found or when an argument is invalid."
msgstr ""
-#. XrebG
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id761587477832670\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. CJ3LD
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id531587477832125\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. 4Sgnh
#: sf_session.xhp
msgctxt ""
@@ -13147,15 +12787,6 @@ msgctxt ""
msgid "<emph>PropertyName</emph>: the property as a case-sensitive string"
msgstr ""
-#. Akcut
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id511587477832273\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. QWaTF
#: sf_session.xhp
msgctxt ""
@@ -13165,24 +12796,6 @@ msgctxt ""
msgid "Open a Uniform Resource Locator (<link href=\"text/shared/00/00000002.xhp#URL\" name=\"URL\">URL</link>) in the default browser."
msgstr ""
-#. 5HDfw
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id121601129640417\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. JQgBi
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id861601129640232\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. JD25Y
#: sf_session.xhp
msgctxt ""
@@ -13192,15 +12805,6 @@ msgctxt ""
msgid "<emph>URL</emph>: The URL to open."
msgstr ""
-#. GrJkD
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id521601129640783\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. hmMBt
#: sf_session.xhp
msgctxt ""
@@ -13210,24 +12814,6 @@ msgctxt ""
msgid "Executes an arbitrary system command and returns <literal>True </literal> if it was launched successfully."
msgstr ""
-#. ME7P8
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id751582819697897\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. gwrTf
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id531582819697898\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. QgJxa
#: sf_session.xhp
msgctxt ""
@@ -13246,15 +12832,6 @@ msgctxt ""
msgid "<emph>Parameters</emph>: A list of space separated parameters as a single string. The method does not validate the given parameters, but only passes them to the specified command."
msgstr ""
-#. xhTtd
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id511582819697899\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. 2hTM7
#: sf_session.xhp
msgctxt ""
@@ -13264,24 +12841,6 @@ msgctxt ""
msgid "Send a message - with optional attachments - to recipients from the user's mail client. The message may be edited by the user before sending or, alternatively, be sent immediately."
msgstr ""
-#. FnAQD
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id881601030349531\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. NNCCH
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id351601030349768\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. qdmqa
#: sf_session.xhp
msgctxt ""
@@ -13336,22 +12895,13 @@ msgctxt ""
msgid "<emph>FileNames</emph>: a comma-separated list of file names. Each file name must respect the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. TDLGA
+#. k3Ssx
#: sf_session.xhp
msgctxt ""
"sf_session.xhp\n"
"par_id161601032784063\n"
"help.text"
-msgid "<emph>EditMessage</emph>: When True (default), the message is edited before being sent."
-msgstr ""
-
-#. RyBiX
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id761601030349355\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
+msgid "<emph>EditMessage</emph>: When <literal>True</literal> (default), the message is edited before being sent."
msgstr ""
#. HtzHP
@@ -13363,24 +12913,6 @@ msgctxt ""
msgid "Returns a list of the methods callable from an UNO object. The list is a zero-based array of strings and may be empty."
msgstr ""
-#. vACC5
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id701587478024912\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. LtvTX
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id751587478024878\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. C7NYy
#: sf_session.xhp
msgctxt ""
@@ -13390,15 +12922,6 @@ msgctxt ""
msgid "<emph>UnoObject</emph>: The object to inspect."
msgstr ""
-#. Ltj9y
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id961587478024752\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. sL6Ri
#: sf_session.xhp
msgctxt ""
@@ -13408,24 +12931,6 @@ msgctxt ""
msgid "Returns a list of the properties of an UNO object. The list is a zero-based array of strings and may be empty."
msgstr ""
-#. 29XiU
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id871587478343121\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. CipCt
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id511587478343219\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. FfvFC
#: sf_session.xhp
msgctxt ""
@@ -13435,15 +12940,6 @@ msgctxt ""
msgid "<emph>UnoObject</emph>: The object to inspect."
msgstr ""
-#. jnwET
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id42158747834340\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. Cm4eK
#: sf_session.xhp
msgctxt ""
@@ -13453,24 +12949,6 @@ msgctxt ""
msgid "Identify the type of a UNO object as a string."
msgstr ""
-#. MBEmJ
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id571582820251348\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. 237PZ
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id21582820251349\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. SudxH
#: sf_session.xhp
msgctxt ""
@@ -13480,15 +12958,6 @@ msgctxt ""
msgid "<emph>UnoObject</emph>: The object to identify."
msgstr ""
-#. 4wB2f
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id51582820251350\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. UAy4i
#: sf_session.xhp
msgctxt ""
@@ -13498,24 +12967,6 @@ msgctxt ""
msgid "Get some web content from a URI."
msgstr ""
-#. g4PxN
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id661582821057373\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
-msgstr ""
-
-#. BA7gi
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id591582821057374\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
-msgstr ""
-
#. C2AxK
#: sf_session.xhp
msgctxt ""
@@ -13525,15 +12976,6 @@ msgctxt ""
msgid "<emph>URI</emph>: URI text of the web service."
msgstr ""
-#. hJFL3
-#: sf_session.xhp
-msgctxt ""
-"sf_session.xhp\n"
-"hd_id711582821057375\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. gn6AM
#: sf_string.xhp
msgctxt ""
@@ -13741,15 +13183,6 @@ msgctxt ""
msgid "ASCII number"
msgstr ""
-#. RDZhY
-#: sf_string.xhp
-msgctxt ""
-"sf_string.xhp\n"
-"par_id771611948706049\n"
-"help.text"
-msgid "\\n <br/> \\r <br/> \\t"
-msgstr ""
-
#. fS24a
#: sf_string.xhp
msgctxt ""
@@ -13759,13 +13192,13 @@ msgctxt ""
msgid "Line feed<br/> Carriage return<br/> Horizontal tab"
msgstr ""
-#. 6cwNJ
+#. wAbkt
#: sf_string.xhp
msgctxt ""
"sf_string.xhp\n"
"par_id251611949474763\n"
"help.text"
-msgid "To have the escape sequence \"\\n\" interpreted as an actual string, simply use \"\\\\n\" instead of \"\\\" & Chr(10)."
+msgid "To have the escape sequence \"\\n\" interpreted as an actual string, simply use \"\\\\n\" instead of <literal>\"\\\" & Chr(10).</literal>"
msgstr ""
#. AYQbH
@@ -14029,24 +13462,6 @@ msgctxt ""
msgid "<emph>InputStr</emph>: The string to be capitalized."
msgstr ""
-#. YLZDS
-#: sf_string.xhp
-msgctxt ""
-"sf_string.xhp\n"
-"bm_id421582384432626\n"
-"help.text"
-msgid "<bookmark_value>String service;Count</bookmark_value>"
-msgstr ""
-
-#. Uf2TJ
-#: sf_string.xhp
-msgctxt ""
-"sf_string.xhp\n"
-"hd_id1001582384527265\n"
-"help.text"
-msgid "Count"
-msgstr ""
-
#. DB982
#: sf_string.xhp
msgctxt ""
@@ -14299,13 +13714,13 @@ msgctxt ""
msgid "<emph>Regex</emph>: The regular expression"
msgstr ""
-#. 5dD3S
+#. vBGPG
#: sf_string.xhp
msgctxt ""
"sf_string.xhp\n"
"par_id881579876394584\n"
"help.text"
-msgid "<emph>Start</emph>: The position in the string where the search will begin. This parameter is passed by reference, so after execution the value of Start will point to the first character of the found substring. If no matching substring is found, Start will be set to 0."
+msgid "<emph>Start</emph>: The position in the string where the search will begin. This parameter is passed by reference, so after execution the value of <literal>Start</literal> will point to the first character of the found substring. If no matching substring is found, <literal>Start</literal> will be set to 0."
msgstr ""
#. 8ACCG
@@ -14326,13 +13741,13 @@ msgctxt ""
msgid "<emph>Forward</emph>: Determines the direction of the search. If <literal>True</literal>, search moves forward. If <literal>False</literal> search moves backwards (Default = <literal>True</literal>)"
msgstr ""
-#. 6Qzy2
+#. 24fyo
#: sf_string.xhp
msgctxt ""
"sf_string.xhp\n"
"par_id451612309155653\n"
"help.text"
-msgid "At the first iteration, if <literal>Forward = True</literal>, then Start should be equal to 1, whereas if <literal>Forward = False</literal> then Start should be equal to <literal>Len(InputStr)</literal>"
+msgid "At the first iteration, if <literal>Forward = True</literal>, then <literal>Start</literal> should be equal to 1, whereas if <literal>Forward = False</literal> then <literal>Start</literal> should be equal to <literal>Len(InputStr)</literal>"
msgstr ""
#. gv3oo
@@ -14497,13 +13912,13 @@ msgctxt ""
msgid "Alphabetic characters are those characters defined in the <link href=\"https://unicode.org/reports/tr44/\" name=\"Unicode documentation\">Unicode Character Database</link> as <literal>Letter</literal>."
msgstr ""
-#. CLTDC
+#. VMZud
#: sf_string.xhp
msgctxt ""
"sf_string.xhp\n"
"par_id11579881691826\n"
"help.text"
-msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
msgstr ""
#. KaLGv
@@ -15505,15 +14920,6 @@ msgctxt ""
msgid "<emph>QuoteChar</emph> : Either the single (') or double (\") quote."
msgstr ""
-#. dVPPE
-#: sf_string.xhp
-msgctxt ""
-"sf_string.xhp\n"
-"bas_id351612388312049\n"
-"help.text"
-msgid "' a = Array(\"abc\", \"\"\"def\\\"\",ghi\"\"\")"
-msgstr ""
-
#. 6Q2tJ
#: sf_string.xhp
msgctxt ""
@@ -15829,15 +15235,6 @@ msgctxt ""
msgid "The file must be closed with the <literal>CloseFile</literal> method after all read or write operations have been executed:"
msgstr ""
-#. uCC2B
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bas_id91613599192241\n"
-"help.text"
-msgid "myFile.CloseFile()"
-msgstr ""
-
#. zNveN
#: sf_textstream.xhp
msgctxt ""
@@ -15847,15 +15244,6 @@ msgctxt ""
msgid "Optionally, the resources used by the <literal>TextStream</literal> instance can be released using the <literal>Dispose</literal> method:"
msgstr ""
-#. LnYGk
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bas_id761613599333614\n"
-"help.text"
-msgid "Set myFile = myFile.Dispose()"
-msgstr ""
-
#. nsGCZ
#: sf_textstream.xhp
msgctxt ""
@@ -15874,15 +15262,6 @@ msgctxt ""
msgid "Properties"
msgstr ""
-#. aZttT
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bm_id1001613600572485\n"
-"help.text"
-msgid "<bookmark_value>TextStream service;AtEndOfStream</bookmark_value> <bookmark_value>TextStream service;Encoding</bookmark_value> <bookmark_value>TextStream service;FileName</bookmark_value> <bookmark_value>TextStream service;IOMode</bookmark_value> <bookmark_value>TextStream service;Line</bookmark_value> <bookmark_value>TextStream service;NewLine</bookmark_value>"
-msgstr ""
-
#. aN9zM
#: sf_textstream.xhp
msgctxt ""
@@ -16117,33 +15496,6 @@ msgctxt ""
msgid "'Opens the text file with the names to be read"
msgstr ""
-#. fArny
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bas_id651613595641754\n"
-"help.text"
-msgid "Set inputFile = FSO.OpenTextFile(\"~/Documents/Students.txt\")"
-msgstr ""
-
-#. 9sFB5
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bas_id81613595642474\n"
-"help.text"
-msgid "Dim allData as String"
-msgstr ""
-
-#. a9b3r
-#: sf_textstream.xhp
-msgctxt ""
-"sf_textstream.xhp\n"
-"bas_id191613595642766\n"
-"help.text"
-msgid "allData = inputFile.ReadAll()"
-msgstr ""
-
#. 7Fq9E
#: sf_textstream.xhp
msgctxt ""
@@ -16324,13 +15676,13 @@ msgctxt ""
msgid "The <literal>Timer</literal> service measures the amount of time it takes to run user scripts."
msgstr ""
-#. kNcKc
+#. qDa8E
#: sf_timer.xhp
msgctxt ""
"sf_timer.xhp\n"
"par_id181582733781323\n"
"help.text"
-msgid "A Timer measures <emph>durations</emph>. It can be:"
+msgid "A <literal>Timer</literal> measures <emph>durations</emph>. It can be:"
msgstr ""
#. ErpLm
@@ -16360,13 +15712,13 @@ msgctxt ""
msgid "Resumed, to continue tracking running time after the Timer has been suspended."
msgstr ""
-#. zvNdv
+#. DVCBM
#: sf_timer.xhp
msgctxt ""
"sf_timer.xhp\n"
"par_id31582733781344\n"
"help.text"
-msgid "Restarted, which will cancel previous measurements and start the Timer at zero."
+msgid "Restarted, which will cancel previous measurements and start the <literal>Timer</literal> at zero."
msgstr ""
#. dm7yA
@@ -16603,13 +15955,13 @@ msgctxt ""
msgid "Returned value"
msgstr ""
-#. C2QQ4
+#. 6DJTP
#: sf_timer.xhp
msgctxt ""
"sf_timer.xhp\n"
"par_id301582734180676\n"
"help.text"
-msgid "Resumes the Timer if it has been suspended"
+msgid "Resumes the <literal>Timer</literal> if it has been suspended"
msgstr ""
#. ixF7A
@@ -16621,13 +15973,13 @@ msgctxt ""
msgid "<literal>False</literal> if the timer is not suspended"
msgstr ""
-#. nkUs3
+#. AAozF
#: sf_timer.xhp
msgctxt ""
"sf_timer.xhp\n"
"par_id821582734649305\n"
"help.text"
-msgid "Terminates the timer and discard its current property values, restarting as a new clean Timer"
+msgid "Terminates the <literal>Timer</literal> and discards its current property values, restarting as a new clean <literal>Timer</literal>"
msgstr ""
#. UtCTT
@@ -16693,15 +16045,6 @@ msgctxt ""
msgid "<literal>False</literal> if the timer is neither started nor suspended"
msgstr ""
-#. Axxez
-#: sf_timer.xhp
-msgctxt ""
-"sf_timer.xhp\n"
-"hd_id651582735695110\n"
-"help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
-msgstr ""
-
#. UgBnC
#: sf_timer.xhp
msgctxt ""
@@ -16909,15 +16252,6 @@ msgctxt ""
msgid "Definitions"
msgstr ""
-#. o4Eq6
-#: sf_ui.xhp
-msgctxt ""
-"sf_ui.xhp\n"
-"hd_id761587913266887\n"
-"help.text"
-msgid "WindowName"
-msgstr ""
-
#. L8Ate
#: sf_ui.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/scalc/01.po b/source/fr/helpcontent2/source/text/scalc/01.po
index d35253c5196..f5184dff969 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: 2021-03-23 11:44+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-03-05 01:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/fr/>\n"
@@ -4399,14 +4399,14 @@ msgctxt ""
msgid "Database Functions"
msgstr "Fonctions de base de données"
-#. fFN63
+#. ASfzE
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3148946\n"
"help.text"
-msgid "<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value>"
-msgstr "<bookmark_value>Assistant Fonctions;bases de données</bookmark_value><bookmark_value>Fonctions;fonctions de base de données</bookmark_value><bookmark_value>Bases de données;fonctions dans $[officename] Calc</bookmark_value>"
+msgid "<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value>"
+msgstr ""
#. BX97Y
#: 04060101.xhp
@@ -4417,446 +4417,833 @@ msgctxt ""
msgid "Database Functions"
msgstr "Fonctions de base de données"
-#. qLyAL
+#. v9KEM
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id721616440441374\n"
+"help.text"
+msgid "Overview"
+msgstr ""
+
+#. RGkxy
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3145173\n"
"help.text"
-msgid "<variable id=\"datenbanktext\">This section deals with functions used with data organized as one row of data for one record.</variable>"
-msgstr "<variable id=\"datenbanktext\">Cette section présente les fonctions utilisées avec des données organisées sur une seule ligne de données pour chaque enregistrement. </variable>"
+msgid "<variable id=\"datenbanktext\">The twelve functions in the Database category help you to analyze a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.</variable> The header cell of each column displays the name of the column and that name usually reflects the contents of each cell in that column."
+msgstr ""
-#. yT4m3
+#. 8NQZ9
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3154016\n"
+"par_id631615842419413\n"
"help.text"
-msgid "The Database category may be confused with a database integrated in $[officename]. However, there is no connection between a database in $[officename] and the Database category in $[officename] Calc."
-msgstr "La catégorie Base de données peut être confondue avec la base de données intégrée à $[officename]. Cependant, il n'y a aucune connexion entre une base de données dans $[officename] et une catégorie Base de données dans $[officename] Calc."
+msgid "The functions in the Database category take three arguments as follows:"
+msgstr ""
-#. jEaEF
+#. pmE4Y
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"hd_id3150329\n"
+"par_id761615842549780\n"
"help.text"
-msgid "Example Data:"
-msgstr "Données exemples :"
+msgid "<emph>Database</emph>. The cell range of the database."
+msgstr ""
-#. CTcsw
+#. nw3ya
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153713\n"
+"par_id601615842657372\n"
"help.text"
-msgid "The following data will be used in some of the function description examples:"
-msgstr "Dans les descriptions de fonction, les données suivantes sont utilisées dans certains exemples :"
+msgid "<emph>DatabaseField</emph>. The column containing the data to be used in the function’s calculations."
+msgstr ""
-#. rxm7X
+#. D5P4G
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3155766\n"
+"par_id471615842721059\n"
"help.text"
-msgid "The range A1:E10 lists the children invited to Joe's birthday party. The following information is given for each entry: column A shows the name, B the grade, then age in years, distance to school in meters and weight in kilograms."
-msgstr "La plage de cellules A1:E10 indique les enfants invités à la fête d'anniversaire de Rémi. Les informations suivantes sont fournies pour chacune des entrées : la colonne A indique le nom de l'invité, et les colonnes B, C, D et E respectivement sa classe, son âge (en années), la distance entre son domicile et l'école (en mètres) et son poids (en kg)."
+msgid "<emph>SearchCriteria</emph>. The cell range of a separate area of the spreadsheet containing search criteria."
+msgstr ""
-#. bD6uT
+#. RT3mc
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3145232\n"
+"par_id101615842794525\n"
"help.text"
-msgid "A"
-msgstr "A"
+msgid "These arguments are described more fully below."
+msgstr ""
-#. H97m2
+#. ykxDt
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3146316\n"
+"par_id241615842810077\n"
"help.text"
-msgid "B"
-msgstr "B"
+msgid "All functions have the same outline concept of operation. The first logical step is to use the specified <emph>SearchCriteria</emph> to identify the subset of records in the <emph>Database</emph> that are to be used during subsequent calculations. The second step is to extract the data values and perform the calculations associated with the specific function (average, sum, product, and so on). The values processed are those in the <emph>DatabaseField</emph> column of the selected records."
+msgstr ""
-#. AFfUx
+#. oErum
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150297\n"
+"par_id981615978852310\n"
"help.text"
-msgid "C"
-msgstr "C"
+msgid "Calc treats dates and logical values (TRUE and FALSE) as numeric when calculating with these functions."
+msgstr ""
-#. teF2d
+#. qZFoo
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150344\n"
+"hd_id911615888814785\n"
"help.text"
-msgid "D"
-msgstr "D"
+msgid "Database Function Arguments"
+msgstr ""
-#. ZCffn
+#. XzUDg
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150785\n"
+"par_id911615888833104\n"
"help.text"
-msgid "E"
-msgstr "E"
+msgid "The following argument definitions apply for all functions in the Database category:"
+msgstr ""
-#. vcyaR
+#. EHkEz
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150090\n"
+"par_id21615889071992\n"
"help.text"
-msgid "1"
-msgstr "1"
+msgid "<emph>Database argument</emph>"
+msgstr ""
+
+#. fxMgf
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id31615889105463\n"
+"help.text"
+msgid "<emph>Database</emph> specifies the range of cells occupied by the database table. The first row of the range contains the field names, and subsequent rows are records with corresponding field values."
+msgstr ""
+
+#. zpzi9
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id521615889152497\n"
+"help.text"
+msgid "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. An example might be A1:E10."
+msgstr ""
+
+#. WD55p
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id761615889163416\n"
+"help.text"
+msgid "The <emph>Database</emph> argument may also be specified by passing the name of a named range or database range. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. If the name does not match the name of a defined range, Calc reports a #NAME? error."
+msgstr ""
+
+#. 7L4XM
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id601615889176137\n"
+"help.text"
+msgid "Other errors that might be reported as a result of an invalid <emph>Database</emph> argument are #VALUE! and Err:504 (error in parameter list)."
+msgstr ""
+
+#. rsj3e
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id201615889390777\n"
+"help.text"
+msgid "<emph>DatabaseField argument</emph>"
+msgstr ""
+
+#. 7Eorp
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id431615889426480\n"
+"help.text"
+msgid "<emph>DatabaseField</emph> specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. It is not related to the search criteria."
+msgstr ""
+
+#. Z9Qfp
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id661615889458032\n"
+"help.text"
+msgid "Specify the <emph>DatabaseField</emph> argument in any of the following ways:"
+msgstr ""
+
+#. RMwzE
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id981615889517841\n"
+"help.text"
+msgid "By entering a reference to a header cell within the <emph>Database</emph> area. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. If the name does not match the name of a defined range, Calc reports a #NAME? error. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list)."
+msgstr ""
+
+#. 6EGoq
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id551615889661457\n"
+"help.text"
+msgid "By entering a number to specify the column within the <emph>Database</emph> area, starting with 1. For example, if a <emph>Database</emph> occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. Calc expects an integer value that lies between 1 and the number of columns defined within <emph>Database</emph> and ignores any digits after a decimal point. If the value is less than 1, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in <emph>Database</emph>, Calc reports a #VALUE! error."
+msgstr ""
+
+#. qSkvo
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id561615889738472\n"
+"help.text"
+msgid "By entering the literal column header name from the first row of the <emph>Database</emph> range, placing quotation marks around the header name. For example, “Distance to School”. If the string does not match one of the <emph>Database</emph> area’s column headings, Calc reports Err:504 (error in parameter list). You can also provide a reference to an arbitrary cell (not within the <emph>Database</emph> and <emph>SearchCriteria</emph> areas) that contains the required string."
+msgstr ""
+
+#. AUEy6
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id181615889841279\n"
+"help.text"
+msgid "The <emph>DatabaseField</emph> argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions."
+msgstr ""
+
+#. Af4va
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id841615891322513\n"
+"help.text"
+msgid "<emph>SearchCriteria argument</emph>"
+msgstr ""
+
+#. 9eBBv
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id351615891337585\n"
+"help.text"
+msgid "<emph>SearchCriteria</emph> specifies the range of cells containing search criteria. Like <emph>Database</emph>, its first row is also field names, and subsequent rows are conditions for related fields. The <emph>Database</emph> and <emph>SearchCriteria</emph> areas need not be adjacent, or even on the same sheet."
+msgstr ""
+
+#. iuFJF
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id401615891342289\n"
+"help.text"
+msgid "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, A13:B14. The cell range may also be specified by passing the name of a defined named range or database range. If the name does not match the name of a defined range, Calc reports a #NAME? error."
+msgstr ""
+
+#. 2BE4W
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id861615891345281\n"
+"help.text"
+msgid "Err:504 (error in parameter list) may also be reported as a result of an invalid <emph>SearchCriteria</emph> argument."
+msgstr ""
+
+#. D6TBP
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id901615891349688\n"
+"help.text"
+msgid "The contents of the <emph>SearchCriteria</emph> area are described in more detail in the next section."
+msgstr ""
+
+#. vj96q
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id481615892281210\n"
+"help.text"
+msgid "Defining Search Criteria"
+msgstr ""
+
+#. zTQX5
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id691615892329680\n"
+"help.text"
+msgid "The number of columns occupied by the <emph>SearchCriteria</emph> area need not be the same as the width of the <emph>Database</emph> area. All headings that appear in the first row of <emph>SearchCriteria</emph> must be identical to headings in the first row of <emph>Database</emph>. However, not all headings in <emph>Database</emph> need appear in the first row of <emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can appear multiple times in the first row of <emph>SearchCriteria</emph>."
+msgstr ""
+
+#. AeGHn
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id541615892358897\n"
+"help.text"
+msgid "Search criteria are entered into the cells of the second and subsequent rows of the <emph>SearchCriteria</emph> area, below the row containing headings. Blank cells within the <emph>SearchCriteria</emph> area are ignored."
+msgstr ""
+
+#. MddCQ
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id151615892882441\n"
+"help.text"
+msgid "Create criteria in the cells of the <emph>SearchCriteria</emph> area using the comparison operators <, <=, =, <>, >=, and >. = is assumed if a cell is not empty but does not start with a comparison operator."
+msgstr ""
+
+#. 4NDMd
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id561615893059337\n"
+"help.text"
+msgid "If you write several criteria in one row, they are connected by AND. If you write several criteria in different rows, they are connected by OR."
+msgstr ""
+
+#. xymRZ
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id401615893095178\n"
+"help.text"
+msgid "Criteria can be created using wildcards, providing that wildcards have been enabled via the <menuitem>Enable wildcards in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled."
+msgstr ""
+
+#. darZG
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id921615893158111\n"
+"help.text"
+msgid "Even more powerful criteria can be created using regular expressions, providing that regular expressions have been enabled via the <menuitem>Enable regular expressions in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog."
+msgstr ""
+
+#. YkSzL
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id881615893236930\n"
+"help.text"
+msgid "Another setting that affects how the search criteria are handled is the <menuitem>Search criteria = and <> must apply to whole cells</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. This option controls whether the search criteria you set for the Database functions must match the whole cell exactly. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled."
+msgstr ""
-#. QMBdD
+#. 4sbmh
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id3150329\n"
+"help.text"
+msgid "Examples of Database Function Use"
+msgstr ""
+
+#. hyFuY
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id3153713\n"
+"help.text"
+msgid "The following table provides an example database table that is utilized to demonstrate how to use the functions in the Database category. The cell range A1:E10 contains fictitious information about the guests invited to Joe's birthday party. The following information is given for each guest - name, school grade, age in years, distance to school in meters, and weight in kilograms."
+msgstr ""
+
+#. Y2HFt
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152992\n"
"help.text"
-msgid "<item type=\"input\">Name</item>"
-msgstr "<item type=\"input\">Nom</item>"
+msgid "<emph>Name</emph>"
+msgstr ""
-#. QPBrB
+#. ChBDv
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3155532\n"
"help.text"
-msgid "<item type=\"input\">Grade</item>"
-msgstr "<item type=\"input\">Classe</item>"
+msgid "<emph>Grade</emph>"
+msgstr ""
-#. Pm46W
+#. mt5xM
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3156448\n"
"help.text"
-msgid "<item type=\"input\">Age</item>"
-msgstr "<item type=\"input\">Âge</item>"
+msgid "<emph>Age</emph>"
+msgstr ""
-#. 78ZeE
+#. Svp8Q
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3154486\n"
"help.text"
-msgid "<item type=\"input\">Distance to School</item>"
-msgstr "<item type=\"input\">Distance de l'école</item>"
+msgid "<emph>Distance</emph>"
+msgstr ""
-#. dnu9K
+#. BShmH
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152899\n"
"help.text"
-msgid "<item type=\"input\">Weight</item>"
-msgstr "<item type=\"input\">Poids</item>"
+msgid "<emph>Weight</emph>"
+msgstr ""
-#. FnT35
+#. FUGeA
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3151240\n"
"help.text"
-msgid "<item type=\"input\">Andy</item>"
-msgstr "<item type=\"input\">André</item>"
+msgid "Andy"
+msgstr ""
-#. cAc3y
+#. eQx2T
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152870\n"
"help.text"
-msgid "<item type=\"input\">Betty</item>"
-msgstr "<item type=\"input\">Betty</item>"
+msgid "Betty"
+msgstr ""
-#. AFNrM
+#. HKBAA
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3155596\n"
"help.text"
-msgid "<item type=\"input\">Charles</item>"
-msgstr "<item type=\"input\">Charles</item>"
+msgid "Charles"
+msgstr ""
-#. JZYTT
+#. WCaYH
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3147296\n"
"help.text"
-msgid "<item type=\"input\">Daniel</item>"
-msgstr "<item type=\"input\">Daniel</item>"
+msgid "Daniel"
+msgstr ""
-#. 3ADGE
+#. L3gMx
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3150456\n"
"help.text"
-msgid "<item type=\"input\">Eva</item>"
-msgstr "<item type=\"input\">Eva</item>"
+msgid "Eva"
+msgstr ""
-#. EBQHZ
+#. bwR2v
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3145826\n"
"help.text"
-msgid "<item type=\"input\">Frank</item>"
-msgstr "<item type=\"input\">Mohamed</item>"
+msgid "Frank"
+msgstr ""
-#. LBimT
+#. TwrgJ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3146137\n"
"help.text"
-msgid "<item type=\"input\">Greta</item>"
-msgstr "<item type=\"input\">Aminata</item>"
+msgid "Greta"
+msgstr ""
-#. o28cC
+#. TmomQ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3153078\n"
"help.text"
-msgid "<item type=\"input\">Harry</item>"
-msgstr "<item type=\"input\">Amir</item>"
+msgid "Harry"
+msgstr ""
-#. yyNPe
+#. qBHps
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148761\n"
"help.text"
-msgid "<item type=\"input\">Irene</item>"
-msgstr "<item type=\"input\">Irène</item>"
+msgid "Irene"
+msgstr ""
-#. 3QgTw
+#. UDuZW
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153544\n"
+"par_id221616245476190\n"
"help.text"
-msgid "<item type=\"input\">Name</item>"
-msgstr "<item type=\"input\">Nom</item>"
+msgid "The following six examples use the database table above, combined with different search criteria areas."
+msgstr ""
-#. rZnhU
+#. sPtvb
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3158414\n"
+"hd_id861616245631924\n"
"help.text"
-msgid "<item type=\"input\">Grade</item>"
-msgstr "<item type=\"input\">Classe</item>"
+msgid "Example 1"
+msgstr ""
-#. KKHzB
+#. cEWAG
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3152820\n"
+"par_id891616245640933\n"
"help.text"
-msgid "<item type=\"input\">Age</item>"
-msgstr "<item type=\"input\">Âge</item>"
+msgid "<emph>Name</emph>"
+msgstr ""
-#. RAMzS
+#. AsoFd
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3154866\n"
+"par_id451616245640933\n"
+"help.text"
+msgid "<emph>Grade</emph>"
+msgstr ""
+
+#. Dw3a2
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id151616245818988\n"
"help.text"
-msgid "<item type=\"input\">Distance to School</item>"
-msgstr "<item type=\"input\">Distance de l'école</item>"
+msgid "<emph>Age</emph>"
+msgstr ""
-#. eQCiE
+#. TdY66
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150471\n"
+"par_id481616245878460\n"
"help.text"
-msgid "<item type=\"input\">Weight</item>"
-msgstr "<item type=\"input\">Poids</item>"
+msgid "<emph>Distance</emph>"
+msgstr ""
-#. vqwJP
+#. ggUUj
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3163823\n"
+"par_id741616245891772\n"
"help.text"
-msgid "<item type=\"input\">DCOUNT</item>"
-msgstr "<item type=\"input\">BDNB</item>"
+msgid "<emph>Weight</emph>"
+msgstr ""
-#. bLCC5
+#. BdjTH
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3149282\n"
+"par_id41616246075884\n"
"help.text"
-msgid "The formula in cell B16 is =DCOUNT(A1:E10;D1;A13:E14)"
-msgstr "La formule figurant dans la cellule B16 est =BDNB(A1:E10;0;A13:E14)"
+msgid ">600"
+msgstr ""
-#. hk3qQ
+#. 4SkNQ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"hd_id3150962\n"
+"par_id451616246535763\n"
"help.text"
-msgid "Database Function Parameters:"
-msgstr "Paramètres des fonctions de base de données :"
+msgid "As in this simple example, it is sometimes desirable (but not essential) to place the search criteria area directly under the database table, with the columns of the two areas vertically aligned. Blank entries in the search criteria area are ignored. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests travel further than 600 meters to school. The value 5 is returned (counting Betty, Daniel, Eva, Harry, and Irene)."
+msgstr ""
-#. Ruyj7
+#. bBHFr
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3155837\n"
+"par_id731616246561901\n"
"help.text"
-msgid "The following items are the parameter definitions for all database functions:"
-msgstr "Les paramètres des différentes fonctions de base de données sont définis comme suit :"
+msgid "Note also that the formula <item type=\"input\">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly the same value, demonstrating that it is only necessary for the search criteria area to contain relevant column headings."
+msgstr ""
-#. GJ7fw
+#. VyrBb
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3149453\n"
+"hd_id191616246773750\n"
"help.text"
-msgid "<emph>Database</emph> is the cell range defining the database. The first row of the range contains the field names, and following rows are records with corresponding field values."
-msgstr "<emph>Base de données</emph> est la plage de cellules définissant la base de données. La première ligne de la place contient les noms de champ, et les lignes suivantes sont des enregistrements avec des valeurs de champ correspondantes."
+msgid "Example 2"
+msgstr ""
-#. aZFWB
+#. V4PCC
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3151272\n"
+"par_id71616246804093\n"
"help.text"
-msgid "<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. <variable id=\"quotes\">For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name (from the first row of <emph>Database</emph> range), place quotation marks around the header name.</variable>"
-msgstr "<emph>champs_base_de_données</emph> spécifie la colonne où la fonction opère après que le critère de recherche du premier paramètre est appliqué et que les lignes de données sont sélectionnées. Ce n'est pas relatif au critère de recherche en lui-même. <variable id=\"quotes\">Pour le paramètre champ_base_de_données, vous pouvez saisir une référence à une cellule d'en-tête ou un nombre pour spécifier la colonne dans la zone de base de données, en commençant par 1. Pour référencer une colonne par le nom de l'en-tête de colonne (à partir de la première ligne de la plage <emph>champ_base_de_données</emph>), placez le nom d'en-tête entre guillemets. </variable>"
+msgid "<emph>Age</emph>"
+msgstr ""
-#. UwQMN
+#. KjH3p
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3147083\n"
+"par_id41616250394431\n"
"help.text"
-msgid "<emph>SearchCriteria</emph> is the cell range containing search criteria. Like <emph>Database</emph>, its first row is also field names, and following rows are conditions for related fields. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored."
-msgstr "<emph>critère_de_recherche</emph> est la plage de cellules contenant les critères de recherche. Comme pour <emph>Base de données</emph>, sa première ligne est également des noms de champs, et les lignes suivantes sont des conditions pour les champs associés. Si vous écrivez plusieurs critères sur une ligne, ils sont connectés par ET. Si vous écrivez les critères dans différentes lignes, ils sont connectés par OU. Les cellules vides dans la plage de critères de recherche seront ignorées."
+msgid "<emph>Grade</emph>"
+msgstr ""
-#. k58yy
+#. FsLvK
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3151188\n"
+"par_id71616250414319\n"
"help.text"
-msgid "Choose <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> to define how $[officename] Calc acts when searching for identical entries."
-msgstr "Choisissez <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Préférences</menuitem></caseinline><defaultinline><menuitem>Outils - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculer</menuitem></link> pour définir la façon dont $[officename] Calc agit lors de la recherche d'entrées identiques."
+msgid ">7"
+msgstr ""
-#. GCPCd
+#. hfPeb
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3882869\n"
+"par_id361616251794063\n"
"help.text"
-msgid "See also the Wiki page about <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation\">Conditional Counting and Summation</link>."
-msgstr "Voir également la page de Wiki à propos des <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation\">Sommes et calculs conditionnels</link>."
+msgid "In this example the search criteria area contains only two headings and these are not vertically aligned with the corresponding headings in the example database table. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are in grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and Irene)."
+msgstr ""
-#. JFBkY
+#. 6Tfyk
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"bm_id3150882\n"
+"hd_id221616251986854\n"
"help.text"
-msgid "<bookmark_value>DCOUNT function</bookmark_value> <bookmark_value>counting rows;with numeric values</bookmark_value>"
-msgstr "<bookmark_value>BDNB, fonction</bookmark_value><bookmark_value>Comptage des lignes;avec des valeurs numériques</bookmark_value>"
+msgid "Example 3"
+msgstr ""
-#. DLGGD
+#. kAXbc
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"hd_id3150882\n"
+"par_id141616251871487\n"
"help.text"
-msgid "DCOUNT"
-msgstr "BDNB"
+msgid "<emph>Age</emph>"
+msgstr ""
-#. HVBLr
+#. CQA2G
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3156133\n"
+"par_id351616252313215\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values in the DatabaseField column.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBANZAHL\">BDNB compte le nombre de lignes (enregistrements) dans une base de données correspondant aux critères de recherche spécifiés. Cette fonction comporte des valeurs numériques.</ahelp>"
+msgid "In this example the search criteria area contains only one heading. Since there are two conditions in consecutive rows, these are connected by OR. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are either 9 or 10 years old. The value 4 is returned (counting Andy, Betty, Charles, and Harry)."
+msgstr ""
-#. EetM7
+#. GFADM
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153218\n"
+"hd_id71616252395407\n"
"help.text"
-msgid "DCOUNT(Database; [DatabaseField]; SearchCriteria)"
-msgstr "BDNB(base_de_données;[champs_base_de_données];critère_de_recherche)"
+msgid "Example 4"
+msgstr ""
-#. uSA7w
+#. kNw3F
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153273\n"
+"par_id451616252413665\n"
"help.text"
-msgid "If the DatabaseField argument is omitted, DCOUNT returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
-msgstr "Si l'argument champ_base_de_données est omis, BDNB renvoie le nombre de tous les enregistrements qui satisfont à critère.<embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
+msgid "<emph>Age</emph>"
+msgstr ""
+
+#. QPqDb
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id431616252540783\n"
+"help.text"
+msgid "<emph>Age</emph>"
+msgstr ""
+
+#. 5zWEA
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id411616252568693\n"
+"help.text"
+msgid ">=8"
+msgstr ""
+
+#. ceFqk
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id441616252573495\n"
+"help.text"
+msgid "<=10"
+msgstr ""
-#. ckYe4
+#. 6Dk9D
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id301587321851330\n"
+"par_id991616252981928\n"
"help.text"
-msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNT(Database; ; SearchCriteria)."
-msgstr "Si vous choisissez d'omettre l'argument champ_base_de_données, la formule sera de la forme =BDNB(base_de_données;;critère_de_recherche)."
+msgid "In this example the search criteria area contains two occurrences of the same heading. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are aged between 8 and 10 (inclusive). The value 6 is returned (counting Andy, Betty, Charles, Eva, Harry, and Irene)."
+msgstr ""
+
+#. vgeRe
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id561616253067881\n"
+"help.text"
+msgid "Example 5"
+msgstr ""
-#. F7cy4
+#. yvXQo
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id301616253073598\n"
+"help.text"
+msgid "<emph>Name</emph>"
+msgstr ""
+
+#. uDvpq
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id251616253264022\n"
+"help.text"
+msgid "F*"
+msgstr ""
+
+#. qBB4C
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id91616253394127\n"
+"help.text"
+msgid "This simple example shows the use of wildcards. For this example to work as intended, select to enable wildcards at <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letter “F”. The value 1 is returned (counting Frank)."
+msgstr ""
+
+#. BAnVJ
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id121616253593255\n"
+"help.text"
+msgid "Example 6"
+msgstr ""
+
+#. 3RcET
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id731616253599063\n"
+"help.text"
+msgid "<emph>Name</emph>"
+msgstr ""
+
+#. PJCE2
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id761616253649791\n"
+"help.text"
+msgid "[ABC].*"
+msgstr ""
+
+#. NyqFV
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id631616253692350\n"
+"help.text"
+msgid "This simple example shows the use of regular expressions. For this example to work as intended, select to enable regular expressions at <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and Charles)."
+msgstr ""
+
+#. jLLao
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"bm_id3150882\n"
+"help.text"
+msgid "<bookmark_value>DCOUNT function</bookmark_value> <bookmark_value>counting rows;with numeric values</bookmark_value>"
+msgstr ""
+
+#. DLGGD
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"hd_id3150882\n"
+"help.text"
+msgid "DCOUNT"
+msgstr "BDNB"
+
+#. RAGuV
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id3156133\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> However, if no column is specified, DCOUNT returns the count of all records that match the specified search criteria irrespective of their contents."
+msgstr ""
+
+#. EetM7
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id3153218\n"
+"help.text"
+msgid "DCOUNT(Database; [DatabaseField]; SearchCriteria)"
+msgstr "BDNB(base_de_données;[champs_base_de_données];critère_de_recherche)"
+
+#. KYvAJ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3153623\n"
"help.text"
-msgid "In the example above (scroll up, please), we want to know how many children have to travel more than 600 meters to school. The result is to be stored in cell B16. Set the cursor in cell B16. Enter the formula <item type=\"input\">=DCOUNT(A1:E10;D1;A13:E14)</item> in B16. The <emph>Function Wizard</emph> helps you to input ranges."
-msgstr "Dans l'exemple ci-dessus (faites défiler vers le haut), nous souhaitons savoir combien d'enfants doivent se déplacer de plus de 600 m de l'école. Le résultat sera stocké dans la cellule B16. Saisissez la formule <item type=\"input\">=BDNB(A1:E10;D1;A13:E14)</item> dans B16. L'<emph>assistant Fonction</emph> vous aide à saisir les plages."
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)."
+msgstr ""
-#. D8qKE
+#. kVciZ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3149142\n"
+"par_id441616368480646\n"
"help.text"
-msgid "<emph>Database</emph> is the range of data to be evaluated, including its headers: in this case A1:E10. <emph>DatabaseField</emph> specifies the column for the search criteria: in this case, the column with the numerical distance values. <emph>SearchCriteria</emph> is the range where you can enter the search parameters: in this case, A13:E14."
-msgstr "<emph>base_de_données</emph> est la plage de données devant être évaluée, incluant ses en-têtes : dans ce cas A1:E10. <emph>champs_base_de_données</emph> spécifie la colonne pour le critère de recherche : dans ce cas, la colonne avec les valeurs de distance numériques. <emph>critère_de_recherche</emph> est la plage où vous pouvez saisir les paramètres de recherche : dans ce cas A13:E14."
+msgid "Insert the formula <input>=DCOUNT(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned."
+msgstr ""
-#. 7rvXg
+#. UZFcp
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3145652\n"
+"par_id361616368488119\n"
"help.text"
-msgid "To learn how many children in second grade are over 7 years of age, delete the entry >600 in cell D14 and enter <item type=\"input\">2</item> in cell B14 under Grade, and enter <item type=\"input\">>7</item> in cell C14 to the right. The result is 2. Two children are in second grade and over 7 years of age. As both criteria are in the same row, they are connected by AND."
-msgstr "Pour savoir combien d'enfants de la classe seconde ont plus de 7 ans, supprimez l'entrée >600 dans la cellule D14, saisissez<item type=\"input\">2</item> dans la cellule B14 sous Classe et saisissez <item type=\"input\">>7</item> dans la cellule C14 à droite. Le résultat est 2. Deux enfants de la classe seconde ont plus de 7 ans. Comme les deux critères sont sur la même ligne, ils sont connectés par ET."
+msgid "The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; \"Distance\"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; \"Name\"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric."
+msgstr ""
-#. G2Eds
+#. m4a6A
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3156123\n"
"help.text"
-msgid "<bookmark_value>DCOUNTA function</bookmark_value> <bookmark_value>records;counting in Calc databases</bookmark_value> <bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>"
-msgstr "<bookmark_value>BDNBVAL, fonction</bookmark_value><bookmark_value>Enregistrement;comptage dans les bases de données Calc</bookmark_value><bookmark_value>Comptage des lignes;avec des valeurs numériques ou alphanumériques</bookmark_value>"
+msgid "<bookmark_value>DCOUNTA function</bookmark_value> <bookmark_value>records;counting in Calc databases</bookmark_value> <bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>"
+msgstr ""
#. aJdyL
#: 04060101.xhp
@@ -4867,14 +5254,14 @@ msgctxt ""
msgid "DCOUNTA"
msgstr "BDNBVAL"
-#. AXuF5
+#. T7ebL
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3156110\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBANZAHL2\">DCOUNTA counts the number of rows (records) in a database that match the specified search conditions, and contain numeric or alphanumeric values.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBANZAHL2\">BDNBVAL compte le nombre de lignes (enregistrements) dans une base de données correspondant aux conditions de recherche spécifiées. Cette fonction comporte en outre des valeurs numériques et alphanumériques.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBANZAHL2\">DCOUNTA counts the number of cells (fields) of the specified column that are not blank, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells of the specified column are not counted. However, if no column is specified, DCOUNTA returns the count of all records that match the specified search criteria irrespective of their contents."
+msgstr ""
#. CxWGV
#: 04060101.xhp
@@ -4885,41 +5272,41 @@ msgctxt ""
msgid "DCOUNTA(Database; [DatabaseField]; SearchCriteria)"
msgstr "BDNBVAL(base_de_données; [champ_base_de_données]; critère_de_recherche)"
-#. EnTi8
+#. dLvi2
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153274\n"
+"par_id3153982\n"
"help.text"
-msgid "If the DatabaseField argument is omitted, DCOUNTA returns the count of all records that satisfy Criteria. <embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
-msgstr "Si l'argument champ_base_de_données est omis, BDNBVAM renvoie le nombre de tous les enregistrements qui satisfont à critère.<embedvar href=\"text/scalc/01/04060101.xhp#quotes\"/>"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)."
+msgstr ""
-#. ESpfH
+#. SSD7D
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id31587322048553\n"
+"par_id61616368616093\n"
"help.text"
-msgid "If you choose to omit the DatabaseField argument, your formula should be of the form =DCOUNTA(Database; ; SearchCriteria)."
-msgstr "Si vous choisissez d'omettre l'argument champ_base_de_données, la formule devrait de la forme =BDNBVAL(base_de_données;;critère_de_recherche)."
+msgid "Insert the formula <input>=DCOUNTA(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned."
+msgstr ""
-#. xX6ve
+#. WyEGc
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153982\n"
+"par_id841616368623207\n"
"help.text"
-msgid "In the example above (scroll up, please), you can search for the number of children whose name starts with an E or a subsequent letter. Edit the formula in B16 to read <item type=\"input\">=DCOUNTA(A1:E10;\"Name\";A13:E14)</item>. Delete the old search criteria and enter <item type=\"input\">>=E</item> under Name in field A14. The result is 5. If you now delete all number values for Greta in row 8, the result changes to 4. Row 8 is no longer included in the count because it does not contain any values. The name Greta is text, not a value. Note that the DatabaseField parameter must point to a column that can contain values."
-msgstr "Dans l'exemple ci-dessus (faites défiler vers le haut), vous pouvez rechercher le nombre d'enfants dont le prénom commence par E ou une lettre équivalente. Éditez la formule en B16 pour lire <item type=\"input\">=BDNBVAL(A1:E10;\"Nom\";A13:E14)</item>. Supprimez l'ancien critère de recherche et saisissez <item type=\"input\">>=E</item> sous Nom dans le champ A14. Le résultat est 5. Si vous supprimez maintenant toutes les valeurs pour Aminata dans la ligne 8, le résultat est modifié à 4. La ligne 8 n'est plus incluse dans le compte parce qu'elle ne contient plus aucune valeur. Le nom Aminata est du texte, pas une valeur. Remarquez que le paramètre champ_base_de_données doit pointer sur une colonne qui peut contenir des valeurs."
+msgid "The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; \"Distance\"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; \"Name\"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument."
+msgstr ""
-#. eBniZ
+#. ZFJzE
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3147256\n"
"help.text"
-msgid "<bookmark_value>DGET function</bookmark_value> <bookmark_value>cell contents;searching in Calc databases</bookmark_value> <bookmark_value>searching;cell contents in Calc databases</bookmark_value>"
-msgstr "<bookmark_value>BDLIRE, fonction</bookmark_value><bookmark_value>Contenu des cellules;recherche dans les bases de données Calc</bookmark_value><bookmark_value>Recherche;contenu de cellule dans les bases de données Calc</bookmark_value>"
+msgid "<bookmark_value>DGET function</bookmark_value> <bookmark_value>cell contents;searching in Calc databases</bookmark_value> <bookmark_value>searching;cell contents in Calc databases</bookmark_value>"
+msgstr ""
#. wj7ck
#: 04060101.xhp
@@ -4930,14 +5317,23 @@ msgctxt ""
msgid "DGET"
msgstr "BDLIRE"
-#. 33Sss
+#. WwRCV
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152801\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBAUSZUG\">DGET returns the contents of the referenced cell in a database which matches the specified search criteria.</ahelp> In case of an error, the function returns either #VALUE! for no row found, or Err502 for more than one cell found."
-msgstr "<ahelp hid=\"HID_FUNC_DBAUSZUG\">BDLIRE renvoie le contenu de la cellule référencée dans une base de données correspondant aux critères de recherche spécifiés.</ahelp> En cas d'erreur, la fonction renvoie soit #VALEUR! (si aucune ligne n'est détectée), soit Err502 (si plusieurs cellules sont détectées)."
+msgid "<ahelp hid=\"HID_FUNC_DBAUSZUG\">DGET returns the contents of the cell (field) of the specified column, for the single row (database record) that matches the specified search criteria.</ahelp>"
+msgstr ""
+
+#. GxBWY
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id171616180137385\n"
+"help.text"
+msgid "Calc reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE! error (wrong data type) if no matches are found. A #VALUE! error is also reported if a single match is found but the relevant cell is empty."
+msgstr ""
#. oFi8J
#: 04060101.xhp
@@ -4948,68 +5344,41 @@ msgctxt ""
msgid "DGET(Database; DatabaseField; SearchCriteria)"
msgstr "BDLIRE(base_de_données;champs_base_de_données;critère_de_recherche)"
-#. weNSC
+#. G2EsJ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3155388\n"
"help.text"
-msgid "In the above example (scroll up, please), we want to determine what grade a child is in, whose name was entered in cell A14. The formula is entered in cell B16 and differs slightly from the earlier examples because only one column (one database field) can be entered for <emph>DatabaseField</emph>. Enter the following formula:"
-msgstr "Dans l'exemple ci-dessus (faites défiler vers le haut), nous voulons déterminer à quelle classe appartient un enfant, dont le nom a été saisi dans la cellule A14. La formule est saisie dans la cellule B16 et diffère légèrement du précédent exemple parce qu'une seule colonne (un champ de base de données) peut être saisie pour <emph>champ_base_de_données</emph>. Saisissez la formule suivante :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \"11\" (this search criterion will match records in the database table that have a value of 11 in the Age column)."
+msgstr ""
-#. jVr8U
+#. A942C
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3153096\n"
"help.text"
-msgid "<item type=\"input\">=DGET(A1:E10;\"Grade\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDLIRE(A1:E10;\"Classe\";A13:E14)</item>"
+msgid "Insert the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the name of Joe’s party guest who is age 11. The name Daniel is returned."
+msgstr ""
-#. nAfKt
+#. 6AKoj
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3150524\n"
"help.text"
-msgid "Enter the name <item type=\"input\">Frank</item> in A14, and you see the result 2. Frank is in second grade. Enter <item type=\"input\">\"Age\"</item> instead of \"Grade\" and you will get Frank's age."
-msgstr "Saisissez le nom <item type=\"input\">Frank</item> en A14 et vous obtenez le résultat 2. Franck est en classe seconde. Saisissez <item type=\"input\">\"Âge\"</item> au lieu de \"Classe\" et vous obtiendrez l'âge de Franck."
-
-#. pZx2V
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3148833\n"
-"help.text"
-msgid "Or enter the value <item type=\"input\">11</item> in cell C14 only, and delete the other entries in this row. Edit the formula in B16 as follows:"
-msgstr "Ou saisissez la valeur <item type=\"input\">11</item>dans la cellule C14 seulement et supprimez les autres saisies dans la ligne. Éditez la formule en B16 comme ci-après :"
-
-#. mG8tC
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3149912\n"
-"help.text"
-msgid "<item type=\"input\">=DGET(A1:E10;\"Name\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDLIRE(A1:E10;\"Nom\";A13:E14)</item>"
-
-#. fRPeY
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3148813\n"
-"help.text"
-msgid "Instead of the grade, the name is queried. The answer appears at once: Daniel is the only child aged 11."
-msgstr "Le système demande maintenant le nom au lieu de la classe. La réponse s'affiche de suite. Daniel est le seul enfant âgé de 11 ans."
+msgid "If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10)."
+msgstr ""
-#. 8VqRF
+#. umeGw
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3149766\n"
"help.text"
-msgid "<bookmark_value>DMAX function</bookmark_value> <bookmark_value>maximum values in Calc databases</bookmark_value> <bookmark_value>searching;maximum values in columns</bookmark_value>"
-msgstr "<bookmark_value>BDMAX, fonction</bookmark_value><bookmark_value>Valeurs maximales dans les bases de données Calc</bookmark_value><bookmark_value>Recherche;valeurs maximales dans les colonnes</bookmark_value>"
+msgid "<bookmark_value>DMAX function</bookmark_value> <bookmark_value>maximum values in Calc databases</bookmark_value> <bookmark_value>searching;maximum values in columns</bookmark_value>"
+msgstr ""
#. MDBf2
#: 04060101.xhp
@@ -5020,14 +5389,23 @@ msgctxt ""
msgid "DMAX"
msgstr "BDMAX"
-#. VWvHG
+#. 9ek2J
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3154903\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBMAX\">DMAX returns the maximum content of a cell (field) in a database (all records) that matches the specified search conditions.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBMAX\">BDMAX renvoie le contenu maximal d'une cellule (champ) dans une base de données (tous les enregistrements) correspondant aux conditions de recherche spécifiées.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBMAX\">DMAX calculates the maximum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included."
+msgstr ""
+
+#. pUGwd
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id51616180409281\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. ho2GW
#: 04060101.xhp
@@ -5038,41 +5416,32 @@ msgctxt ""
msgid "DMAX(Database; DatabaseField; SearchCriteria)"
msgstr "BDMAX(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. 7XFbM
+#. S57iG
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148442\n"
"help.text"
-msgid "To find out how much the heaviest child in each grade weighed in the above example (scroll up, please), enter the following formula in B16:"
-msgstr "Pour connaître le poids de l'enfant le plus lourd dans chacune des classes de l'exemple ci-dessus, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. dbBD3
+#. Mqocw
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148804\n"
"help.text"
-msgid "<item type=\"input\">=DMAX(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDMAX(A1:E10;\"Poids\";A13:E14)</item>"
-
-#. FyUsB
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3150510\n"
-"help.text"
-msgid "Under Grade, enter <item type=\"input\">1, 2, 3,</item> and so on, one after the other. After entering a grade number, the weight of the heaviest child in that grade appears."
-msgstr "Sous Classe, saisissez <item type=\"input\">1, 2, 3,</item> et ainsi de suite, un après l'autre. Après avoir saisi un numéro de classe, le poids de l'enfant le plus lourd dans cette classe apparaît."
+msgid "Insert the formula <input>=DMAX(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned."
+msgstr ""
-#. A9voG
+#. 5cyyS
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3159141\n"
"help.text"
-msgid "<bookmark_value>DMIN function</bookmark_value> <bookmark_value>minimum values in Calc databases</bookmark_value> <bookmark_value>searching;minimum values in columns</bookmark_value>"
-msgstr "<bookmark_value>BDMIN, fonction</bookmark_value><bookmark_value>Valeurs minimales dans les bases de données Calc</bookmark_value><bookmark_value>Recherche;valeurs minimales dans les colonnes</bookmark_value>"
+msgid "<bookmark_value>DMIN function</bookmark_value> <bookmark_value>minimum values in Calc databases</bookmark_value> <bookmark_value>searching;minimum values in columns</bookmark_value>"
+msgstr ""
#. iGV4a
#: 04060101.xhp
@@ -5083,14 +5452,23 @@ msgctxt ""
msgid "DMIN"
msgstr "BDMIN"
-#. YPGYd
+#. kv5Gb
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3154261\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBMIN\">DMIN returns the minimum content of a cell (field) in a database that matches the specified search criteria.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBMIN\">BDMIN renvoie le contenu minimal d'une cellule (champ) dans une base de données correspondant aux critères de recherche spécifiés.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBMIN\">DMIN calculates the minimum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included."
+msgstr ""
+
+#. yYJTa
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id901616180605426\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. QxBsV
#: 04060101.xhp
@@ -5101,41 +5479,32 @@ msgctxt ""
msgid "DMIN(Database; DatabaseField; SearchCriteria)"
msgstr "BDMIN(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. eVzZu
+#. p4YQB
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148925\n"
"help.text"
-msgid "To find the shortest distance to school for the children in each grade in the above example (scroll up, please), enter the following formula in B16:"
-msgstr "Pour connaître le chemin le plus court entre l'école et le domicile des enfants dans chacune des classes de l'exemple ci-dessus, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. wvi9R
+#. LrfjC
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3149161\n"
"help.text"
-msgid "<item type=\"input\">=DMIN(A1:E10;\"Distance to School\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDMIN(A1:E10;\"Distance de l'école\";A13:E14)</item>"
-
-#. Jtw7m
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3148917\n"
-"help.text"
-msgid "In row 14, under Grade, enter <item type=\"input\">1, 2, 3,</item> and so on, one after the other. The shortest distance to school for each grade appears."
-msgstr "Dans la ligne 14, sous Classe, saisissez <item type=\"input\">1, 2, 3,</item> et ainsi de suite, un après l'autre. La plus courte distance de l'école pour chaque classe apparaît."
+msgid "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned."
+msgstr ""
-#. RCFqd
+#. WppQu
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3154274\n"
"help.text"
-msgid "<bookmark_value>DAVERAGE function</bookmark_value> <bookmark_value>averages; in Calc databases</bookmark_value> <bookmark_value>calculating;averages in Calc databases</bookmark_value>"
-msgstr "<bookmark_value>BDMOYENNE, fonction</bookmark_value><bookmark_value>Moyennes;dans les bases de données Calc</bookmark_value><bookmark_value>Calcul;moyennes dans les bases de données Calc</bookmark_value>"
+msgid "<bookmark_value>DAVERAGE function</bookmark_value> <bookmark_value>averages; in Calc databases</bookmark_value> <bookmark_value>calculating;averages in Calc databases</bookmark_value>"
+msgstr ""
#. dQciw
#: 04060101.xhp
@@ -5146,59 +5515,59 @@ msgctxt ""
msgid "DAVERAGE"
msgstr "BDMOYENNE"
-#. bb43d
+#. Y7wdv
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3166453\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">DAVERAGE returns the average of the values of all cells (fields) in all rows (database records) that match the specified search criteria.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">BDMOYENNE renvoie la moyenne des valeurs de toutes les cellules (champs) pour toutes les lignes (enregistrements de la base de données) correspondant aux critères de recherche spécifiés.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">DAVERAGE calculates the average of the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values in those cells are ignored."
+msgstr ""
-#. PPkBD
+#. 87qxe
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3150710\n"
+"par_id31615978739452\n"
"help.text"
-msgid "DAVERAGE(Database; DatabaseField; SearchCriteria)"
-msgstr "BDMOYENNE(base_de_données;champ_base_de_données;critère_de_recherche)"
+msgid "Returns a #DIV/0! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
-#. x8oHK
+#. PPkBD
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3149104\n"
+"par_id3150710\n"
"help.text"
-msgid "To find the average weight of all children of the same age in the above example (scroll up, please), enter the following formula in B16:"
-msgstr "Pour connaître le poids moyen de tous les enfants du même âge dans l'exemple ci-dessus, saisissez la formule suivante dans la cellule B16 :"
+msgid "DAVERAGE(Database; DatabaseField; SearchCriteria)"
+msgstr "BDMOYENNE(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. 4SN7D
+#. PcjTP
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3153688\n"
+"par_id3149104\n"
"help.text"
-msgid "<item type=\"input\">=DAVERAGE(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDMOYENNE(A1:E10;\"Poids\";A13:E14)</item>"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. ETJh3
+#. CjTGB
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
-"par_id3155587\n"
+"par_id201616368312277\n"
"help.text"
-msgid "In row 14, under Age, enter <item type=\"input\">7, 8, 9,</item> and so on, one after the other. The average weight of all children of the same age appears."
-msgstr "À la ligne 14, sous Âge, saisissez <item type=\"input\">7, 8, 9,</item> et ainsi de suite, l'un après l'autre. La moyenne du poids de tous les enfants du même âge apparaît."
+msgid "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned."
+msgstr ""
-#. brDoK
+#. B6fYC
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3159269\n"
"help.text"
-msgid "<bookmark_value>DPRODUCT function</bookmark_value> <bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>"
-msgstr "<bookmark_value>BDPRODUIT, fonction</bookmark_value><bookmark_value>Multiplication;contenu des cellules dans les bases de données Calc</bookmark_value>"
+msgid "<bookmark_value>DPRODUCT function</bookmark_value> <bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>"
+msgstr ""
#. gvW9Q
#: 04060101.xhp
@@ -5209,14 +5578,23 @@ msgctxt ""
msgid "DPRODUCT"
msgstr "BDPRODUIT"
-#. V8GCj
+#. oJApo
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152879\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT multiplies all cells of a data range where the cell contents match the search criteria.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBPRODUKT\">BDPRODUIT multiplie toutes les cellules d'une plage de données dont le contenu correspond aux critères de recherche.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT calculates the product of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included."
+msgstr ""
+
+#. oUsZD
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id741616180868336\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. PgAsj
#: 04060101.xhp
@@ -5227,23 +5605,32 @@ msgctxt ""
msgid "DPRODUCT(Database; DatabaseField; SearchCriteria)"
msgstr "BDPRODUIT(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. jcTBE
+#. oGQtm
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148986\n"
"help.text"
-msgid "With the birthday party example above (scroll up, please), there is no meaningful application of this function."
-msgstr "Cette fonction ne trouve aucune application pratique dans l'exemple de la fête d'anniversaire ci-dessus."
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. 3oyGS
+#. iaoUA
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id91616368981807\n"
+"help.text"
+msgid "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned."
+msgstr ""
+
+#. QGMit
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3148462\n"
"help.text"
-msgid "<bookmark_value>DSTDEV function</bookmark_value> <bookmark_value>standard deviations in databases;based on a sample</bookmark_value>"
-msgstr "<bookmark_value>BDECARTYPE, fonction</bookmark_value><bookmark_value>Écarts types dans les bases de données;basés sur un échantillon</bookmark_value>"
+msgid "<bookmark_value>DSTDEV function</bookmark_value> <bookmark_value>standard deviations in databases;based on a sample</bookmark_value>"
+msgstr ""
#. EvGNP
#: 04060101.xhp
@@ -5254,14 +5641,32 @@ msgctxt ""
msgid "DSTDEV"
msgstr "BDECARTYPE"
-#. mcwAC
+#. 56CsG
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3154605\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the standard deviation of a population based on a sample, using the numbers in a database column that match the given conditions.</ahelp> The records are treated as a sample of data. That means that the children in the example represent a cross section of all children. Note that a representative result can not be obtained from a sample of less than one thousand."
-msgstr "<ahelp hid=\"HID_FUNC_DBSTDABW\">La fonction BDECARTYPE calcule, à partir d'un échantillon, l'écart type d'une population donnée. À cet effet, elle utilise les nombres d'une colonne de la base de données qui correspondent aux conditions spécifiées.</ahelp> Les enregistrements sont traités en tant qu'échantillons. Ainsi, les enfants cités dans l'exemple sont considérés comme une coupe transversale de l'ensemble des enfants. Notez que, pour qu'un résultat soit représentatif, l'échantillon doit compter au moins un millier d'éléments."
+msgid "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the sample standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored."
+msgstr ""
+
+#. RACag
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id121616181037440\n"
+"help.text"
+msgid "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records."
+msgstr ""
+
+#. r6onB
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id931616181041535\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. GgdKD
#: 04060101.xhp
@@ -5272,41 +5677,32 @@ msgctxt ""
msgid "DSTDEV(Database; DatabaseField; SearchCriteria)"
msgstr "BDECARTYPE(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. CwkrB
+#. q4kzs
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3149934\n"
"help.text"
-msgid "To find the standard deviation of the weight for all children of the same age in the example (scroll up, please), enter the following formula in B16:"
-msgstr "Pour connaître l'écart type du poids de tous les enfants du même âge dans cet exemple, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. 2fFkp
+#. SXqfH
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3150630\n"
"help.text"
-msgid "<item type=\"input\">=DSTDEV(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDECARTYPE(A1:E10;\"Poids\";A13:E14)</item>"
-
-#. cApCx
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3153536\n"
-"help.text"
-msgid "In row 14, under Age, enter <item type=\"input\">7, 8, 9,</item> and so on, one after the other. The result shown is the standard deviation of the weight of all children of this age."
-msgstr "À la ligne 14, sous Âge, saisissez <item type=\"input\">7, 8, 9,</item> et ainsi de suite, l'un après l'autre. Le résultat affiché est la déviation standard du poids de tous les enfants de cet âge."
+msgid "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned."
+msgstr ""
-#. hkC4r
+#. A72yR
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3150429\n"
"help.text"
-msgid "<bookmark_value>DSTDEVP function</bookmark_value> <bookmark_value>standard deviations in databases;based on populations</bookmark_value>"
-msgstr "<bookmark_value>BDECARTYPEP, fonction</bookmark_value><bookmark_value>Écarts types dans les bases de données;basés sur des populations</bookmark_value>"
+msgid "<bookmark_value>DSTDEVP function</bookmark_value> <bookmark_value>standard deviations in databases;based on populations</bookmark_value>"
+msgstr ""
#. FpESx
#: 04060101.xhp
@@ -5317,14 +5713,23 @@ msgctxt ""
msgid "DSTDEVP"
msgstr "BDECARTYPEP"
-#. DCq49
+#. Cfkn3
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3145598\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the standard deviation of a population based on all cells of a data range which match the search criteria.</ahelp> The records from the example are treated as the whole population."
-msgstr "<ahelp hid=\"HID_FUNC_DBSTDABWN\">BDECARTYPEP calcule l'écart type d'une population donnée à partir de toutes les cellules comprises dans une plage de données correspondant aux critères de recherche.</ahelp> Les enregistrements de l'exemple sont considérés comme constituant une population complète."
+msgid "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored."
+msgstr ""
+
+#. TjThw
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id541616181205698\n"
+"help.text"
+msgid "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. uGaWp
#: 04060101.xhp
@@ -5335,41 +5740,32 @@ msgctxt ""
msgid "DSTDEVP(Database; DatabaseField; SearchCriteria)"
msgstr "BDECARTYPEP(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. GAj3B
+#. jm7Bx
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3155431\n"
"help.text"
-msgid "To find the standard deviation of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16:"
-msgstr "Pour obtenir l'écart type des données de poids de tous les enfants du même âge présents à la fête d'anniversaire de Rémi, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. J4DhB
+#. 6eisL
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3148411\n"
"help.text"
-msgid "<item type=\"input\">=DSTDEVP(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDECARTYPEP(A1:E10;\"Poids\";A13:E14)</item>"
-
-#. gBZGK
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3143271\n"
-"help.text"
-msgid "In row 14, under Age, enter <item type=\"input\">7, 8, 9,</item> and so on, one after the other. The result is the standard deviation of the weight for all same-aged children whose weight was checked."
-msgstr "À la ligne 14, sous Âge, saisissez <item type=\"input\">7, 8, 9,</item> et ainsi de suite, l'un après l'autre. Le résultat affiché est la déviation standard du poids de tous les enfants du même âge dont le poids a été vérifié."
+msgid "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned."
+msgstr ""
-#. fA3Lj
+#. gXoTJ
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3154794\n"
"help.text"
-msgid "<bookmark_value>DSUM function</bookmark_value> <bookmark_value>calculating;sums in Calc databases</bookmark_value> <bookmark_value>sums;cells in Calc databases</bookmark_value>"
-msgstr "<bookmark_value>BDSOMME, fonction</bookmark_value><bookmark_value>Calcul;sommes dans les bases de données Calc</bookmark_value><bookmark_value>Sommes;cellules dans les bases de données Calc</bookmark_value>"
+msgid "<bookmark_value>DSUM function</bookmark_value> <bookmark_value>calculating;sums in Calc databases</bookmark_value> <bookmark_value>sums;cells in Calc databases</bookmark_value>"
+msgstr ""
#. ybMg9
#: 04060101.xhp
@@ -5380,14 +5776,23 @@ msgctxt ""
msgid "DSUM"
msgstr "BDSOMME"
-#. CBcVo
+#. pqV9N
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3149591\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM returns the total of all cells in a database field in all rows (records) that match the specified search criteria.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_DBSUMME\">BDSOMME renvoie le total de toutes les cellules d'un champ de base de données dans toutes les lignes (enregistrements) remplissant les critères de recherche.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included."
+msgstr ""
+
+#. PEAvG
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id691616181332088\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. LD8jB
#: 04060101.xhp
@@ -5398,41 +5803,32 @@ msgctxt ""
msgid "DSUM(Database; DatabaseField; SearchCriteria)"
msgstr "BDSOMME(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. eqDCU
+#. G9FsG
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3152766\n"
"help.text"
-msgid "To find the length of the combined distance to school of all children at Joe's birthday party (scroll up, please) who are in second grade, enter the following formula in B16:"
-msgstr "Pour connaître la longueur que représente le cumul des distances parcourues par chaque enfant de la classe 2 invités à l'anniversaire de Rémi pour aller à l'école, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. ErLuv
+#. riVB4
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3151312\n"
"help.text"
-msgid "<item type=\"input\">=DSUM(A1:E10;\"Distance to School\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDSOMME(A1:E10;\"Distance de l'école\";A13:E14)</item>"
-
-#. z7LF6
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3150596\n"
-"help.text"
-msgid "Enter <item type=\"input\">2</item> in row 14 under Grade. The sum (1950) of the distances to school of all the children who are in second grade is displayed."
-msgstr "Saisissez <item type=\"input\">2</item> à la ligne 14 sous Classe. La somme (1950) des distances de l'école de tous les enfants qui sont en seconde classe est affichée."
+msgid "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned."
+msgstr ""
-#. ZFAu8
+#. fbsJf
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3155614\n"
"help.text"
-msgid "<bookmark_value>DVAR function</bookmark_value> <bookmark_value>variances;based on samples</bookmark_value>"
-msgstr "<bookmark_value>BDVAR, fonction</bookmark_value><bookmark_value>Variances;basées sur des échantillons</bookmark_value>"
+msgid "<bookmark_value>DVAR function</bookmark_value> <bookmark_value>variances;based on samples</bookmark_value>"
+msgstr ""
#. G6ZBW
#: 04060101.xhp
@@ -5443,14 +5839,32 @@ msgctxt ""
msgid "DVAR"
msgstr "BDVAR"
-#. qPBM4
+#. QN7LU
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3154418\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR returns the variance of all cells of a database field in all records that match the specified search criteria.</ahelp> The records from the example are treated as a sample of data. A representative result cannot be obtained from a sample population of less than one thousand."
-msgstr "<ahelp hid=\"HID_FUNC_DBVARIANZ\">BDVAR renvoie la variance de toutes les cellules d'un certain champ de base de données de tous les enregistrements satisfaisant les critères de recherche.</ahelp> Les enregistrements de l'exemple sont traités comme un échantillon de données. Pour qu'un résultat soit représentatif, l'échantillon doit compter au moins un milliers d'éléments."
+msgid "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored."
+msgstr ""
+
+#. yytCQ
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id301616181465164\n"
+"help.text"
+msgid "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records."
+msgstr ""
+
+#. gW4LZ
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id741616181469136\n"
+"help.text"
+msgid "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. hLSuf
#: 04060101.xhp
@@ -5461,41 +5875,32 @@ msgctxt ""
msgid "DVAR(Database; DatabaseField; SearchCriteria)"
msgstr "BDVAR(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. CKayC
+#. TyAAP
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3153701\n"
"help.text"
-msgid "To find the variance of the weight of all children of the same age of the above example (scroll up, please), enter the following formula in B16:"
-msgstr "Pour connaître la variance du poids moyen de tous les enfants du même âge dans l'exemple ci-dessus, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. DWkzL
+#. bRDWF
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3153676\n"
"help.text"
-msgid "<item type=\"input\">=DVAR(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDVAR(A1:E10;\"Poids\";A13:E14)</item>"
-
-#. D6bmo
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3153798\n"
-"help.text"
-msgid "In row 14, under Age, enter <item type=\"input\">7, 8, 9,</item> and so on, one after the other. You will see as a result the variance of the weight values for all children of this age."
-msgstr "À la ligne 14, sous Âge, saisissez <item type=\"input\">7, 8, 9,</item> et ainsi de suite, l'un après l'autre. Vous verrez s'afficher la variance des valeurs de poids pour tous les enfants de cet âge."
+msgid "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned."
+msgstr ""
-#. hEbwx
+#. sGiDz
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3153880\n"
"help.text"
-msgid "<bookmark_value>DVARP function</bookmark_value> <bookmark_value>variances;based on populations</bookmark_value>"
-msgstr "<bookmark_value>BDVARP, fonction</bookmark_value><bookmark_value>Variances;basées sur des populations</bookmark_value>"
+msgid "<bookmark_value>DVARP function</bookmark_value> <bookmark_value>variances;based on populations</bookmark_value>"
+msgstr ""
#. XpcPC
#: 04060101.xhp
@@ -5506,14 +5911,23 @@ msgctxt ""
msgid "DVARP"
msgstr "BDVARP"
-#. f9qMk
+#. nfgrg
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3155119\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the variance of all cell values in a database field in all records that match the specified search criteria.</ahelp> The records are from the example are treated as an entire population."
-msgstr "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">BDVARP calcule la variance de toutes les valeurs contenues dans les cellules d'un certain champ de base de données de tous les enregistrements satisfaisant les critères de recherche.</ahelp> Les enregistrements de l'exemple sont traités comme une population complète."
+msgid "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored."
+msgstr ""
+
+#. ERRmG
+#: 04060101.xhp
+msgctxt ""
+"04060101.xhp\n"
+"par_id301616181648263\n"
+"help.text"
+msgid "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records."
+msgstr ""
#. BygUf
#: 04060101.xhp
@@ -5524,32 +5938,23 @@ msgctxt ""
msgid "DVARP(Database; DatabaseField; SearchCriteria)"
msgstr "BDVARP(base_de_données;champ_base_de_données;critère_de_recherche)"
-#. MvqGc
+#. STcMa
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3147099\n"
"help.text"
-msgid "To find the variance of the weight for all children of the same age at Joe's birthday party (scroll up, please), enter the following formula in B16:"
-msgstr "Pour obtenir la variance des données de poids de tous les enfants du même âge présents à la fête d'anniversaire de Rémi, saisissez la formule suivante dans la cellule B16 :"
+msgid "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)."
+msgstr ""
-#. zGf8r
+#. 8puR2
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"par_id3147322\n"
"help.text"
-msgid "<item type=\"input\">=DVARP(A1:E10;\"Weight\";A13:E14)</item>"
-msgstr "<item type=\"input\">=BDVARP(A1:E10;\"Poids\";A13:E14)</item>"
-
-#. vAunu
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id3146902\n"
-"help.text"
-msgid "In row 14, under Age, enter <item type=\"input\">7, 8, 9,</item> and so on, one after the other. The variance of the weight values for all children of this age attending Joe's birthday party appears."
-msgstr "À la ligne 14, sous Âge, saisissez <item type=\"input\">7, 8, 9,</item> et ainsi de suite, l'un après l'autre. La variance des valeurs de poids pour tous les enfants de cet âge assistant à la fête d'anniversaire de Rémi s'affiche."
+msgid "Insert the formula <input>=DVARP(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the population variance of the distances in meters that Joe’s party guests travel to school. The value 171666.67 is returned."
+msgstr ""
#. n99gx
#: 04060102.xhp
@@ -5911,6 +6316,15 @@ msgctxt ""
msgid "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units."
msgstr ""
+#. AvpDv
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id851616615176815\n"
+"help.text"
+msgid "Beware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel."
+msgstr ""
+
#. UCPgp
#: 04060103.xhp
msgctxt ""
@@ -13858,15 +14272,6 @@ msgctxt ""
msgid "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)"
msgstr "SOMME(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)"
-#. fsBfG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id151567608802604\n"
-"help.text"
-msgid "SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href=\"text/scalc/01/03080000.xhp\" name=\"value highlight\">value highlighting</link> feature to highlight the text contents in the range that may represent a number."
-msgstr "SOMME ignore tout texte ou cellules vides dans une plage ou une matrice. Si vous suspectez un résultat faux de la fonction SOMME, recherchez du texte dans les plages de données. Utilisez la fonction <link href=\"text/scalc/01/03080000.xhp\" name=\"value highlight\">Mise en évidence des valeurs</link> pour mettre en surbrillance les contenus texte dans la plage qui peuvent représenter un nombre."
-
#. VRBzD
#: 04060106.xhp
msgctxt ""
@@ -53458,6 +53863,15 @@ msgctxt ""
msgid "Example"
msgstr "Exemple"
+#. STMGF
+#: common_func.xhp
+msgctxt ""
+"common_func.xhp\n"
+"par_id301616845402409\n"
+"help.text"
+msgid "This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href=\"text/scalc/01/03080000.xhp\" name=\"value highlight\">value highlighting</link> feature."
+msgstr ""
+
#. GAPGX
#: common_func_workdaysintl.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/scalc/guide.po b/source/fr/helpcontent2/source/text/scalc/guide.po
index bd7d8eaf9cf..c5f94a2ce64 100644
--- a/source/fr/helpcontent2/source/text/scalc/guide.po
+++ b/source/fr/helpcontent2/source/text/scalc/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: 2021-02-17 15:58+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-03-20 17:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textscalcguide/fr/>\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.4.2\n"
+"X-Generator: LibreOffice\n"
"X-Project-Style: openoffice\n"
"X-POOTLE-MTIME: 1558541914.000000\n"
@@ -3275,14 +3275,14 @@ msgctxt ""
msgid "<emph>To Cell:</emph> the image will move along with the cell, when copying, sorting or inserting and deleting cells above and on the left of the cell holding the anchor."
msgstr "<emph>À la cellule :</emph> l'image ne se déplacera pas avec la cellule, lors de la copie, du tri, de l'insertion ou de la suppression de cellules au-dessus et à la gauche de la cellule contenant l'ancre."
-#. 99BBj
+#. aFqrk
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id871607809971823\n"
"help.text"
-msgid "<emph>To Cell(resize with cell):</emph> the image will move along with the cell. In addition, the image height and width will be resized if the cell holding the anchor is later resized. The aspect ratio of the image follows the later aspect ratio of the cell holding the anchor."
-msgstr "<emph>À la cellule (redimensionnement avec la cellule) :</emph> l'image se déplacera avec la cellule. De plus, la hauteur et la largeur de l'image seront redimensionnées si la cellule contenant l'ancre est redimensionnée par la suite. Le ratio de l'image suit le ratio de la cellule contenant l'ancre."
+msgid "<emph>To Cell (resize with cell):</emph> the image will move along with the cell. In addition, the image height and width will be resized if the cell holding the anchor is later resized. The aspect ratio of the image follows the later aspect ratio of the cell holding the anchor."
+msgstr ""
#. DGAiK
#: change_image_anchor.xhp
@@ -3311,14 +3311,14 @@ msgctxt ""
msgid "Select the image and choose <menuitem>Format - Anchor</menuitem>, or, on the context menu of the image choose <menuitem>Anchor</menuitem>"
msgstr "Sélectionnez l'image et choisissez <menuitem>Format - Ancre</menuitem> ou, dans le menu contextuel de l'image, choisissez <menuitem>Ancre</menuitem>"
-#. pSQWf
+#. HUHPb
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id761607809520625\n"
"help.text"
-msgid "The original size of the image and cell is preserved while pasting the entire row or entire column for both <emph>To Cell</emph> and <emph>To Cell(resize with cell)</emph> options."
-msgstr "La taille originale de l'image et de la cellule sont préservées lors du collage d'une ligne ou d'une colonne entière pour les deux options <emph>À la cellule</emph> et <emph>À la cellule (redimensionnement avec la cellule)</emph>."
+msgid "The original size of the image and cell is preserved while pasting the entire row or entire column for both <emph>To Cell</emph> and <emph>To Cell (resize with cell)</emph> options."
+msgstr ""
#. G5Dfz
#: consolidate.xhp
diff --git a/source/fr/helpcontent2/source/text/sdatabase.po b/source/fr/helpcontent2/source/text/sdatabase.po
index 5cc08d26110..e26612d1f45 100644
--- a/source/fr/helpcontent2/source/text/sdatabase.po
+++ b/source/fr/helpcontent2/source/text/sdatabase.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: 2021-03-08 14:39+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-02-12 12:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/fr/>\n"
@@ -4254,6 +4254,726 @@ msgctxt ""
msgid "<ahelp hid=\"dbaccess/ui/relationdialog/deldefault\">If you delete the corresponding primary key, a set value will be set to all external key fields.</ahelp>"
msgstr ""
+#. x8A6E
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Copy a Table by Drag-and-Drop"
+msgstr ""
+
+#. VdcaB
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"hd_id3154894\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030000.xhp\" name=\"Copy Query or Table by Drag-and-Drop\">Copy Query or Table by Drag-and-Drop</link>"
+msgstr ""
+
+#. nDG9W
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"bm_id3155535\n"
+"help.text"
+msgid "<bookmark_value>queries; copying (Base)</bookmark_value><bookmark_value>tables in databases; copying database tables (Base)</bookmark_value>"
+msgstr ""
+
+#. n82rc
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"par_id3155535\n"
+"help.text"
+msgid "Dragging-and-dropping a query or table opens the <emph>Copy Table </emph>dialog, which allows you to define the options for copying a query or a table."
+msgstr ""
+
+#. CzRJq
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"par_id3148539\n"
+"help.text"
+msgid "With the <emph>Copy Table </emph>dialog you can:"
+msgstr ""
+
+#. G45TE
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"par_id3153147\n"
+"help.text"
+msgid "copy the data from the table into another table,"
+msgstr ""
+
+#. 9Kvqa
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"par_id3150504\n"
+"help.text"
+msgid "use the structure of the table as the basis for creating a new table."
+msgstr ""
+
+#. dDRmD
+#: 05030000.xhp
+msgctxt ""
+"05030000.xhp\n"
+"par_id3155628\n"
+"help.text"
+msgid "You can copy within the same database or between different databases."
+msgstr ""
+
+#. Ed5rp
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Copy Table"
+msgstr ""
+
+#. kkUkn
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3085157\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030100.xhp\" name=\"Copy Table\">Copy Table</link>"
+msgstr ""
+
+#. sBC76
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3149264\n"
+"help.text"
+msgid "You can copy a table by dragging and dropping the table onto the table area of a database file window. The <emph>Copy table </emph>dialog appears."
+msgstr ""
+
+#. ciK5F
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3154926\n"
+"help.text"
+msgid "Table name"
+msgstr ""
+
+#. iFF9F
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3144740\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/name\">Specifies a name for the copy.</ahelp> Some databases only accept names containing eight or fewer characters."
+msgstr ""
+
+#. x78x3
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3154228\n"
+"help.text"
+msgid "Options"
+msgstr ""
+
+#. JvNbF
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3157898\n"
+"help.text"
+msgid "Definition and data"
+msgstr ""
+
+#. TqTmF
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3150178\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/defdata\">Creates a 1:1 copy of the database table.</ahelp> The table definition and the complete data are copied. The table definition includes the table structure and format from different data fields, including special field properties. The field contents supply the data."
+msgstr ""
+
+#. hezaD
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3149346\n"
+"help.text"
+msgid "Definition"
+msgstr ""
+
+#. b2GpC
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3156426\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/def\">Copies only the table definition and not the corresponding data.</ahelp>"
+msgstr ""
+
+#. RCvEj
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3143267\n"
+"help.text"
+msgid "As table view"
+msgstr ""
+
+#. BNNHr
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3153311\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/view\">If the database supports Views and you selected this option, a query will be created in the table container as a table. This option allows you to view the query results as a normal table view.</ahelp> The table will be filtered in the view with a \"Select\" SQL statement."
+msgstr ""
+
+#. yJmgp
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3155535\n"
+"help.text"
+msgid "Append data"
+msgstr ""
+
+#. aB4JD
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3166410\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/data\">Appends the data of the table to be copied to an existing table.</ahelp>"
+msgstr ""
+
+#. AnYQg
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3147275\n"
+"help.text"
+msgid "The table definition must be exactly the same so that data can be copied. Data cannot be copied if a data field in the target table has another format than the data field in the source table."
+msgstr ""
+
+#. ADGPK
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3156117\n"
+"help.text"
+msgid "Match the data field names in the<emph> Copy Table</emph> dialog on the <link href=\"text/sdatabase/05030400.xhp\" name=\"Apply Columns\">Apply Columns</link> page."
+msgstr ""
+
+#. toArF
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3153252\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/data\">If the data cannot be attached, you will see a list of fields in the <emph>Column Info</emph> dialog whose data cannot be copied.</ahelp> If you confirm this dialog with OK, only the data that does not appear in the list will be attached."
+msgstr ""
+
+#. 8JYz8
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3158430\n"
+"help.text"
+msgid "If the fields of the target table have a smaller field length than in the source table when data is being attached, the source data fields will automatically be truncated to match the field lengths in the target table."
+msgstr ""
+
+#. 6oNSE
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"bm_id3149164\n"
+"help.text"
+msgid "<bookmark_value>primary keys; defining</bookmark_value>"
+msgstr ""
+
+#. odQAJ
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3149164\n"
+"help.text"
+msgid "Create primary key"
+msgstr ""
+
+#. T7Dmr
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3155922\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/primarykey\">Automatically generates a primary key data field and fills it with values.</ahelp> You should always use this field, since a primary key must always be available in order to edit the table."
+msgstr ""
+
+#. EhRtD
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"hd_id3146794\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. v9USa
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3156343\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/copytablepage/keyname\">Specifies a name for the primary key generated. This name is optional.</ahelp>"
+msgstr ""
+
+#. seBiB
+#: 05030100.xhp
+msgctxt ""
+"05030100.xhp\n"
+"par_id3151056\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030200.xhp\" name=\"Next page\">Next page</link>"
+msgstr ""
+
+#. DDJC9
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"tit\n"
+"help.text"
+msgid "Apply columns"
+msgstr ""
+
+#. FnB9J
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3150445\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030200.xhp\" name=\"Apply columns\">Apply columns</link>"
+msgstr ""
+
+#. 6b9Li
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3147143\n"
+"help.text"
+msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog."
+msgstr ""
+
+#. 8r9yc
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3155552\n"
+"help.text"
+msgid "Existing columns"
+msgstr ""
+
+#. NDcVA
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3154751\n"
+"help.text"
+msgid "Left list box"
+msgstr ""
+
+#. AkHFX
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3147088\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/applycolpage/from\">Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click the > button. To copy all of the fields, click the <emph>>></emph> button.</ahelp>"
+msgstr ""
+
+#. FYG4i
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3154823\n"
+"help.text"
+msgid "Right list box"
+msgstr ""
+
+#. KgGGQ
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3156426\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/applycolpage/to\">Lists the fields that you want to include in the copied table.</ahelp>"
+msgstr ""
+
+#. VyQwS
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"hd_id3147242\n"
+"help.text"
+msgid "Buttons"
+msgstr ""
+
+#. NT8C3
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3146797\n"
+"help.text"
+msgid "<ahelp hid=\".\">Adds or removes the selected field (> or < button) or all of the fields (<< or >> button).</ahelp>"
+msgstr ""
+
+#. CuqBd
+#: 05030200.xhp
+msgctxt ""
+"05030200.xhp\n"
+"par_id3153561\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030300.xhp\" name=\"Next page\">Next page</link>"
+msgstr ""
+
+#. gTg68
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"tit\n"
+"help.text"
+msgid "Type formatting"
+msgstr ""
+
+#. ybz5D
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3163829\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030300.xhp\" name=\"Type formatting\">Type formatting</link>"
+msgstr ""
+
+#. EkSPG
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3150247\n"
+"help.text"
+msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The<emph> Type formatting </emph>dialog is the third window of the <emph>Copy table</emph> dialog."
+msgstr ""
+
+#. mnHDq
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3152801\n"
+"help.text"
+msgid "List box"
+msgstr ""
+
+#. EqDjY
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3145313\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/columnnames\">Lists the data fields that will be included in to the copied table.</ahelp>"
+msgstr ""
+
+#. NCTje
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3155535\n"
+"help.text"
+msgid "Column information"
+msgstr ""
+
+#. eiXTf
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3156426\n"
+"help.text"
+msgid "Field name"
+msgstr ""
+
+#. MNzaq
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3153681\n"
+"help.text"
+msgid "<ahelp hid=\".\">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp>"
+msgstr ""
+
+#. GhbYj
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3156113\n"
+"help.text"
+msgid "Field type"
+msgstr ""
+
+#. MmakP
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3149811\n"
+"help.text"
+msgid "<ahelp hid=\".\">Select a field type.</ahelp>"
+msgstr ""
+
+#. E9Z9q
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3149763\n"
+"help.text"
+msgid "Length"
+msgstr ""
+
+#. BE8Ct
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3155449\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enter the number of characters for the data field.</ahelp>"
+msgstr ""
+
+#. FqaDj
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3159176\n"
+"help.text"
+msgid "Decimal places"
+msgstr ""
+
+#. 4pH6B
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3153666\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.</ahelp>"
+msgstr ""
+
+#. 8H7Yy
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3150276\n"
+"help.text"
+msgid "Default value"
+msgstr ""
+
+#. uF2x5
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3147620\n"
+"help.text"
+msgid "<ahelp hid=\".\">Select the default value for a Yes/No field.</ahelp>"
+msgstr ""
+
+#. H7JCy
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3153087\n"
+"help.text"
+msgid "Automatic type recognition"
+msgstr ""
+
+#. KTPFP
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3153561\n"
+"help.text"
+msgid "$[officename] can automatically recognize field contents when you copy database tables by drag and drop."
+msgstr ""
+
+#. XbBEn
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3156023\n"
+"help.text"
+msgid "(max.) lines"
+msgstr ""
+
+#. 9uGo7
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3155923\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/auto\">Enter the number of lines to use for automatic type recognition.</ahelp>"
+msgstr ""
+
+#. ZojMW
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"hd_id3154347\n"
+"help.text"
+msgid "Auto"
+msgstr ""
+
+#. KXrRC
+#: 05030300.xhp
+msgctxt ""
+"05030300.xhp\n"
+"par_id3152361\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/autobutton\">Enables automatic type recognition.</ahelp>"
+msgstr ""
+
+#. U6GAf
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"tit\n"
+"help.text"
+msgid "Assign columns"
+msgstr ""
+
+#. qFHro
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3151100\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05030400.xhp\" name=\"Assign columns\">Assign columns</link>"
+msgstr ""
+
+#. EkAFg
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3156027\n"
+"help.text"
+msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. If you select the <emph>Attach data </emph>check box on the first page of the <emph>Copy table </emph>dialog, the <emph>Assign columns </emph>dialog opens as the second window. You can use this dialog to map the contents of a data field in the source table to a different data field in the destination table."
+msgstr ""
+
+#. fGrH7
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3157958\n"
+"help.text"
+msgid "Source table"
+msgstr ""
+
+#. XA5ur
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3145071\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/left\">Lists the data fields in the source table. To include a data field from the source table in the destination table, select the check box in front of the data field name. To map the contents of a data field in the source table to a different data field in the destination table, click the data field in the source table list, and then click the up or down arrow.</ahelp> To include all of the source data fields in the destination table, click <emph>All</emph>."
+msgstr ""
+
+#. Kn5tW
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3166410\n"
+"help.text"
+msgid "Destination table"
+msgstr ""
+
+#. CHq7j
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3154749\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/right\">Lists the possible data fields in the destination table. Only the data fields that are selected in the source table list will be included the destination table.</ahelp>"
+msgstr ""
+
+#. yGCzC
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3150670\n"
+"help.text"
+msgid "up"
+msgstr ""
+
+#. AoHnF
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3155628\n"
+"help.text"
+msgid "<ahelp hid=\".\">Moves the selected entry up one position in the list.</ahelp>"
+msgstr ""
+
+#. BsfZK
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3149580\n"
+"help.text"
+msgid "down"
+msgstr ""
+
+#. XUyNh
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3150984\n"
+"help.text"
+msgid "<ahelp hid=\".\">Moves the selected entry down one position in the list.</ahelp>"
+msgstr ""
+
+#. DqTjR
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3156156\n"
+"help.text"
+msgid "all"
+msgstr ""
+
+#. FBk6i
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3154514\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/all\">Selects all of the data fields in the list.</ahelp>"
+msgstr ""
+
+#. eFJ6S
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"hd_id3153541\n"
+"help.text"
+msgid "none"
+msgstr ""
+
+#. LYsDF
+#: 05030400.xhp
+msgctxt ""
+"05030400.xhp\n"
+"par_id3148563\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/none\">Clears all of the check boxes in the list.</ahelp>"
+msgstr ""
+
#. cLmBi
#: main.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/00.po b/source/fr/helpcontent2/source/text/shared/00.po
index d74928da01a..ab16bee6371 100644
--- a/source/fr/helpcontent2/source/text/shared/00.po
+++ b/source/fr/helpcontent2/source/text/shared/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: 2021-03-22 13:58+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-03-20 17:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textshared00/fr/>\n"
@@ -530,6 +530,87 @@ msgctxt ""
msgid "A confirmation does not appear before the defaults are reloaded."
msgstr "Aucune demande de confirmation ne s'affiche avant le rechargement des valeurs par défaut."
+#. DPmE5
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"hd_id811616711038538\n"
+"help.text"
+msgid "Cancel"
+msgstr ""
+
+#. TcFYz
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"par_id651616711045219\n"
+"help.text"
+msgid "Closes dialog and discards changes on all tabs. If <emph>Apply</emph> was used, then changes after the last use of Apply are discarded."
+msgstr ""
+
+#. wFkFQ
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"hd_id601616709204188\n"
+"help.text"
+msgid "Reset"
+msgstr ""
+
+#. YmYPB
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"par_id691616710270371\n"
+"help.text"
+msgid "Resets modified values on the current tab back to the values when the dialog was opened. If <emph>Apply</emph> is used before closing the dialog, then values are reset to those after the last use of Apply."
+msgstr ""
+
+#. emuSf
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"hd_id541616711560721\n"
+"help.text"
+msgid "Apply"
+msgstr ""
+
+#. pjHJH
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"par_id691616711586248\n"
+"help.text"
+msgid "Applies modifications on all tabs without closing dialog. Cannot be reverted with <emph>Reset</emph>."
+msgstr ""
+
+#. A8G37
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"hd_id851616061478033\n"
+"help.text"
+msgid "Reset to Parent"
+msgstr ""
+
+#. WGWyN
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"par_id581616061494132\n"
+"help.text"
+msgid "Values for the current tab are set to those found in the corresponding tab of the style specified in “Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None -”, current tab values specified in “Contains” are removed."
+msgstr ""
+
+#. 3brfZ
+#: 00000001.xhp
+msgctxt ""
+"00000001.xhp\n"
+"par_id131583023830621\n"
+"help.text"
+msgid "This option appears only for Paragraph Style, Character Style, and Frame Style."
+msgstr ""
+
#. wUEEa
#: 00000001.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/01.po b/source/fr/helpcontent2/source/text/shared/01.po
index b658d9f7fc0..f4ed26cb870 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: 2021-03-23 11:44+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-01-30 10:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/fr/>\n"
@@ -15056,6 +15056,15 @@ msgctxt ""
msgid "You can also change the locale setting for cells (choose <emph>Format - Cells - Numbers</emph>)."
msgstr "Vous pouvez aussi modifier les paramètres linguistiques pour les cellules (choisissez <emph>Format - Cellules - Nombres</emph>)."
+#. FASWt
+#: 05020100.xhp
+msgctxt ""
+"05020100.xhp\n"
+"par_id341616754767611\n"
+"help.text"
+msgid "The following buttons appear only for Paragraph Style and Character Style."
+msgstr ""
+
#. ZqG5G
#: 05020100.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/explorer/database.po b/source/fr/helpcontent2/source/text/shared/explorer/database.po
index 9ab88776ba6..bfa3dc8c812 100644
--- a/source/fr/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/fr/helpcontent2/source/text/shared/explorer/database.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-03-19 17:31+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-03-19 16:40+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsharedexplorerdatabase/fr/>\n"
@@ -16,726 +16,6 @@ msgstr ""
"X-Generator: LibreOffice\n"
"X-POOTLE-MTIME: 1559571105.000000\n"
-#. x8A6E
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Copy a Table by Drag-and-Drop"
-msgstr "Copier une table par glisser-déposer"
-
-#. 5wteJ
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"hd_id3154894\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030000.xhp\" name=\"Copy Query or Table by Drag-and-Drop\">Copy Query or Table by Drag-and-Drop</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030000.xhp\" name=\"Copie de requête ou de table par glisser-déposer\">Copie de requête ou de table par glisser-déposer</link>"
-
-#. nDG9W
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"bm_id3155535\n"
-"help.text"
-msgid "<bookmark_value>queries; copying (Base)</bookmark_value><bookmark_value>tables in databases; copying database tables (Base)</bookmark_value>"
-msgstr "<bookmark_value>Requêtes;copie (Base)</bookmark_value><bookmark_value>Tables de bases de données;copie de tables de bases de données</bookmark_value>"
-
-#. n82rc
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"par_id3155535\n"
-"help.text"
-msgid "Dragging-and-dropping a query or table opens the <emph>Copy Table </emph>dialog, which allows you to define the options for copying a query or a table."
-msgstr "Le glisser-déposer d'une requête ou d'une table entraîne l'ouverture de la boîte de dialogue <emph>Copier la table</emph>, qui permet de définir les options de copie d'une requête ou d'une table."
-
-#. CzRJq
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"par_id3148539\n"
-"help.text"
-msgid "With the <emph>Copy Table </emph>dialog you can:"
-msgstr "Avec la boîte de dialogue <emph>Copier la table </emph>, vous pouvez effectuer les opérations suivantes :"
-
-#. G45TE
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"par_id3153147\n"
-"help.text"
-msgid "copy the data from the table into another table,"
-msgstr "copier les données de la table vers une autre table,"
-
-#. 9Kvqa
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"par_id3150504\n"
-"help.text"
-msgid "use the structure of the table as the basis for creating a new table."
-msgstr "utiliser la structure d'une table comme base d'une nouvelle table."
-
-#. dDRmD
-#: 05030000.xhp
-msgctxt ""
-"05030000.xhp\n"
-"par_id3155628\n"
-"help.text"
-msgid "You can copy within the same database or between different databases."
-msgstr "Vous pouvez effectuer des copies à l'intérieur d'une même base de données ou entre des bases de données différentes."
-
-#. Ed5rp
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"tit\n"
-"help.text"
-msgid "Copy Table"
-msgstr "Copier une table"
-
-#. zTpis
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3085157\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030100.xhp\" name=\"Copy Table\">Copy Table</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030100.xhp\" name=\"Copier la table\">Copier la table</link>"
-
-#. sBC76
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3149264\n"
-"help.text"
-msgid "You can copy a table by dragging and dropping the table onto the table area of a database file window. The <emph>Copy table </emph>dialog appears."
-msgstr "Vous pouvez copier une table par glisser-déposer dans la zone de table de la fenêtre d'un fichier de base de données. La boîte de dialogue <emph>Copier la table</emph> s'affiche."
-
-#. ciK5F
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3154926\n"
-"help.text"
-msgid "Table name"
-msgstr "Nom de la table"
-
-#. iFF9F
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3144740\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/name\">Specifies a name for the copy.</ahelp> Some databases only accept names containing eight or fewer characters."
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/name\">Spécifie un nom pour la copie.</ahelp> Certaines bases de données n'acceptent que des noms limités à huit caractères."
-
-#. x78x3
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3154228\n"
-"help.text"
-msgid "Options"
-msgstr "Options"
-
-#. JvNbF
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3157898\n"
-"help.text"
-msgid "Definition and data"
-msgstr "Définition et données"
-
-#. TqTmF
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3150178\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/defdata\">Creates a 1:1 copy of the database table.</ahelp> The table definition and the complete data are copied. The table definition includes the table structure and format from different data fields, including special field properties. The field contents supply the data."
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/defdata\">Crée une copie 1:1 de la table de base de données.</ahelp> La définition de la table et l'intégralité des données sont copiées. La définition de table comprend la structure de la table et le format des différents champs de données, notamment les propriétés spécifiques des champs. Le contenu des champs fournit les données."
-
-#. hezaD
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3149346\n"
-"help.text"
-msgid "Definition"
-msgstr "Définition"
-
-#. b2GpC
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3156426\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/def\">Copies only the table definition and not the corresponding data.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/def\">Copie uniquement la définition de la table, et non les données correspondantes.</ahelp>"
-
-#. RCvEj
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3143267\n"
-"help.text"
-msgid "As table view"
-msgstr "Comme vue de la table"
-
-#. BNNHr
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3153311\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/view\">If the database supports Views and you selected this option, a query will be created in the table container as a table. This option allows you to view the query results as a normal table view.</ahelp> The table will be filtered in the view with a \"Select\" SQL statement."
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/view\">Si la base de données prend en charge les vues et que vous avez sélectionné cette option, une requête est créée comme table dans le container de table. Cette option permet de voir les résultats d'une requête dans une vue de table normale.</ahelp> La table sera filtrée dans dans la vue avec l'instruction SQL \"Select\"."
-
-#. yJmgp
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3155535\n"
-"help.text"
-msgid "Append data"
-msgstr "Ajouter des données"
-
-#. aB4JD
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3166410\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/data\">Appends the data of the table to be copied to an existing table.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/data\">Ajoute les données de la table à copier dans une table existante.</ahelp>"
-
-#. AnYQg
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3147275\n"
-"help.text"
-msgid "The table definition must be exactly the same so that data can be copied. Data cannot be copied if a data field in the target table has another format than the data field in the source table."
-msgstr "Pour que les données puissent être copiées, les définitions des tables doivent être identiques. Il est impossible de copier les données si le format d'un champ de données de la table cible diffère de celui de la table source."
-
-#. EDuqm
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3156117\n"
-"help.text"
-msgid "Match the data field names in the<emph> Copy Table</emph> dialog on the <link href=\"text/shared/explorer/database/05030400.xhp\" name=\"Apply Columns\">Apply Columns</link> page."
-msgstr "Mettez en correspondance les noms de champs de données figurant dans la boîte de dialogue <emph>Copier la table</emph> avec la page <link href=\"text/shared/explorer/database/05030400.xhp\" name=\"Application de colonnes\">Application de colonnes</link>."
-
-#. toArF
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3153252\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/data\">If the data cannot be attached, you will see a list of fields in the <emph>Column Info</emph> dialog whose data cannot be copied.</ahelp> If you confirm this dialog with OK, only the data that does not appear in the list will be attached."
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/data\">S'il s'avère impossible de joindre les données, la liste des champs dont les données ne peuvent pas être copiées s'affiche dans la boîte de dialogue <emph>Information sur les colonnes</emph>.</ahelp> Si vous confirmez cette boîte de dialogue en cliquant sur OK, seules les données qui ne figurent pas dans la liste sont jointes."
-
-#. 8JYz8
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3158430\n"
-"help.text"
-msgid "If the fields of the target table have a smaller field length than in the source table when data is being attached, the source data fields will automatically be truncated to match the field lengths in the target table."
-msgstr "Lors de l'ajout de données, si les champs de la table cible sont moins longs que ceux de la table source, les champs source sont automatiquement tronqués à la longueur des champs cible."
-
-#. 6oNSE
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"bm_id3149164\n"
-"help.text"
-msgid "<bookmark_value>primary keys; defining</bookmark_value>"
-msgstr "<bookmark_value>Clés primaires;définition</bookmark_value>"
-
-#. odQAJ
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3149164\n"
-"help.text"
-msgid "Create primary key"
-msgstr "Créer une clé primaire"
-
-#. T7Dmr
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3155922\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/primarykey\">Automatically generates a primary key data field and fills it with values.</ahelp> You should always use this field, since a primary key must always be available in order to edit the table."
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/primarykey\">Génère automatiquement un champ de données de clé primaire et le remplit de valeurs.</ahelp> Vous devriez toujours utiliser ce champ dans la mesure ou une clé primaire doit toujours être disponible afin de pouvoir éditer la table."
-
-#. EhRtD
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"hd_id3146794\n"
-"help.text"
-msgid "Name"
-msgstr "Nom"
-
-#. v9USa
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3156343\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/copytablepage/keyname\">Specifies a name for the primary key generated. This name is optional.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/copytablepage/keyname\">Spécifie un nom pour la clé primaire générée. Ce nom est facultatif.</ahelp>"
-
-#. tQ7WE
-#: 05030100.xhp
-msgctxt ""
-"05030100.xhp\n"
-"par_id3151056\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030200.xhp\" name=\"Next page\">Next page</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030200.xhp\" name=\"Page suivante\">Page suivante</link>"
-
-#. DDJC9
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"tit\n"
-"help.text"
-msgid "Apply columns"
-msgstr "Appliquer des colonnes"
-
-#. JEQ6K
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3150445\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030200.xhp\" name=\"Apply columns\">Apply columns</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030200.xhp\" name=\"Application de colonnes\">Application de colonnes</link>"
-
-#. 6b9Li
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3147143\n"
-"help.text"
-msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog."
-msgstr "Dans le navigateur de sources de données, vous pouvez copier une table par glisser-déposer dans le container de table. La boîte de dialogue <emph>Application de colonnes</emph> est la seconde fenêtre de la boîte de dialogue <emph>Copier la table</emph>."
-
-#. 8r9yc
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3155552\n"
-"help.text"
-msgid "Existing columns"
-msgstr "Colonnes disponibles"
-
-#. NDcVA
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3154751\n"
-"help.text"
-msgid "Left list box"
-msgstr "Zone de liste gauche"
-
-#. AkHFX
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3147088\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/applycolpage/from\">Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click the > button. To copy all of the fields, click the <emph>>></emph> button.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/applycolpage/from\">Liste les champs de données disponibles que vous pouvez inclure dans la table copiée. Pour copier un champ de données, cliquez sur le nom correspondant, puis sur le bouton >. Pour copier tous les champs, cliquez sur le bouton <emph>>></emph>.</ahelp>"
-
-#. FYG4i
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3154823\n"
-"help.text"
-msgid "Right list box"
-msgstr "Zone de liste droite"
-
-#. KgGGQ
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3156426\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/applycolpage/to\">Lists the fields that you want to include in the copied table.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/applycolpage/to\">Liste les champs à inclure dans la table copiée.</ahelp>"
-
-#. VyQwS
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"hd_id3147242\n"
-"help.text"
-msgid "Buttons"
-msgstr "Boutons"
-
-#. NT8C3
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3146797\n"
-"help.text"
-msgid "<ahelp hid=\".\">Adds or removes the selected field (> or < button) or all of the fields (<< or >> button).</ahelp>"
-msgstr "<ahelp hid=\".\">Ajoute ou supprime le champ sélectionné (bouton > ou <) ou tous les champs (bouton << ou >>).</ahelp>"
-
-#. MdoBx
-#: 05030200.xhp
-msgctxt ""
-"05030200.xhp\n"
-"par_id3153561\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030300.xhp\" name=\"Next page\">Next page</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030300.xhp\" name=\"Page suivante\">Page suivante</link>"
-
-#. gTg68
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"tit\n"
-"help.text"
-msgid "Type formatting"
-msgstr "Formatage de type"
-
-#. rQCk7
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3163829\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030300.xhp\" name=\"Type formatting\">Type formatting</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030300.xhp\" name=\"Formatage de type\">Formatage de type</link>"
-
-#. EkSPG
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3150247\n"
-"help.text"
-msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The<emph> Type formatting </emph>dialog is the third window of the <emph>Copy table</emph> dialog."
-msgstr "Dans le navigateur de sources de données, vous pouvez copier une table par glisser-déposer dans le container de table. La boîte de dialogue <emph>Formatage de type</emph> est la troisième fenêtre de la boîte de dialogue <emph>Copier la table</emph>."
-
-#. mnHDq
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3152801\n"
-"help.text"
-msgid "List box"
-msgstr "Zone de liste"
-
-#. EqDjY
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3145313\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/columnnames\">Lists the data fields that will be included in to the copied table.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/typeselectpage/columnnames\">Liste les champs de données qui seront inclus dans la table copiée.</ahelp>"
-
-#. NCTje
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3155535\n"
-"help.text"
-msgid "Column information"
-msgstr "Information sur la colonne"
-
-#. eiXTf
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3156426\n"
-"help.text"
-msgid "Field name"
-msgstr "Nom de champ"
-
-#. MNzaq
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3153681\n"
-"help.text"
-msgid "<ahelp hid=\".\">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp>"
-msgstr "<ahelp hid=\".\">Affiche le nom du champ de données sélectionné. Vous pouvez lui attribuer un nouveau nom.</ahelp>"
-
-#. GhbYj
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3156113\n"
-"help.text"
-msgid "Field type"
-msgstr "Type de champ"
-
-#. MmakP
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3149811\n"
-"help.text"
-msgid "<ahelp hid=\".\">Select a field type.</ahelp>"
-msgstr "<ahelp hid=\".\">Sélectionnez un type de champ.</ahelp>"
-
-#. E9Z9q
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3149763\n"
-"help.text"
-msgid "Length"
-msgstr "Longueur"
-
-#. BE8Ct
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3155449\n"
-"help.text"
-msgid "<ahelp hid=\".\">Enter the number of characters for the data field.</ahelp>"
-msgstr "<ahelp hid=\".\">Saisissez le nombre de caractères du champ de données.</ahelp>"
-
-#. FqaDj
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3159176\n"
-"help.text"
-msgid "Decimal places"
-msgstr "Décimales"
-
-#. 4pH6B
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3153666\n"
-"help.text"
-msgid "<ahelp hid=\".\">Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.</ahelp>"
-msgstr "<ahelp hid=\".\">Saisissez le nombre de décimales du champ de données. Cette option n'est disponible que pour les champs de données numériques ou décimales.</ahelp>"
-
-#. 8H7Yy
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3150276\n"
-"help.text"
-msgid "Default value"
-msgstr "Valeur par défaut"
-
-#. uF2x5
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3147620\n"
-"help.text"
-msgid "<ahelp hid=\".\">Select the default value for a Yes/No field.</ahelp>"
-msgstr "<ahelp hid=\".\">Sélectionnez la valeur par défaut pour un champ Oui/Non.</ahelp>"
-
-#. H7JCy
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3153087\n"
-"help.text"
-msgid "Automatic type recognition"
-msgstr "Reconnaissance automatique du type"
-
-#. KTPFP
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3153561\n"
-"help.text"
-msgid "$[officename] can automatically recognize field contents when you copy database tables by drag and drop."
-msgstr "$[officename] reconnaît automatiquement le contenu d'un champ lorsque vous copiez les tables de bases de données par glisser-déposer."
-
-#. XbBEn
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3156023\n"
-"help.text"
-msgid "(max.) lines"
-msgstr "Lignes (max.)"
-
-#. 9uGo7
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3155923\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/auto\">Enter the number of lines to use for automatic type recognition.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/typeselectpage/auto\">Saisissez le nombre de lignes à utiliser pour la reconnaissance automatique du type.</ahelp>"
-
-#. ZojMW
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"hd_id3154347\n"
-"help.text"
-msgid "Auto"
-msgstr "Auto"
-
-#. KXrRC
-#: 05030300.xhp
-msgctxt ""
-"05030300.xhp\n"
-"par_id3152361\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/typeselectpage/autobutton\">Enables automatic type recognition.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/typeselectpage/autobutton\">Active la reconnaissance automatique du type.</ahelp>"
-
-#. U6GAf
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"tit\n"
-"help.text"
-msgid "Assign columns"
-msgstr "Assigner les colonnes"
-
-#. yYvst
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3151100\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05030400.xhp\" name=\"Assign columns\">Assign columns</link>"
-msgstr "<link href=\"text/shared/explorer/database/05030400.xhp\" name=\"Assigner les colonnes\">Assigner les colonnes</link>"
-
-#. EkAFg
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3156027\n"
-"help.text"
-msgid "In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. If you select the <emph>Attach data </emph>check box on the first page of the <emph>Copy table </emph>dialog, the <emph>Assign columns </emph>dialog opens as the second window. You can use this dialog to map the contents of a data field in the source table to a different data field in the destination table."
-msgstr "Dans le navigateur de sources de données, vous pouvez copier une table par glisser-déposer dans le container de table. Si vous cochez la case <emph>Joindre des données</emph> dans la première page de la boîte de dialogue <emph>Copier la table</emph>, la boîte de dialogue <emph>Assigner les colonnes</emph> s'affiche en tant que deuxième fenêtre. Utilisez cette boîte de dialogue pour faire correspondre le contenu d'un champ de données de la table source à un autre champ de données dans la table cible."
-
-#. fGrH7
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3157958\n"
-"help.text"
-msgid "Source table"
-msgstr "Table source"
-
-#. XA5ur
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3145071\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/left\">Lists the data fields in the source table. To include a data field from the source table in the destination table, select the check box in front of the data field name. To map the contents of a data field in the source table to a different data field in the destination table, click the data field in the source table list, and then click the up or down arrow.</ahelp> To include all of the source data fields in the destination table, click <emph>All</emph>."
-msgstr "<ahelp hid=\"dbaccess/ui/namematchingpage/left\">Liste les champs de données de la table source. Pour inclure un champ de données dans la table cible à partir de la table source, cochez la case située devant le nom du champ de données. Pour faire correspondre le contenu d'un champ de données de la table source à un autre champ de données de la table cible, cliquez sur le champ de données dans la liste de la table source puis cliquez sur la flèche vers le haut ou vers le bas.</ahelp> Pour inclure tous les champs de données source dans la table cible, cliquez sur <emph>Tous</emph>."
-
-#. Kn5tW
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3166410\n"
-"help.text"
-msgid "Destination table"
-msgstr "Table cible"
-
-#. CHq7j
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3154749\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/right\">Lists the possible data fields in the destination table. Only the data fields that are selected in the source table list will be included the destination table.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/namematchingpage/right\">Liste les champs de données possibles dans la table cible. Seuls les champs de données sélectionnés dans la liste de la table source sont inclus dans la table cible.</ahelp>"
-
-#. yGCzC
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3150670\n"
-"help.text"
-msgid "up"
-msgstr "haut"
-
-#. AoHnF
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3155628\n"
-"help.text"
-msgid "<ahelp hid=\".\">Moves the selected entry up one position in the list.</ahelp>"
-msgstr "<ahelp hid=\".\">Déplace l'entrée sélectionnée d'une position vers le haut dans la liste.</ahelp>"
-
-#. BsfZK
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3149580\n"
-"help.text"
-msgid "down"
-msgstr "bas"
-
-#. XUyNh
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3150984\n"
-"help.text"
-msgid "<ahelp hid=\".\">Moves the selected entry down one position in the list.</ahelp>"
-msgstr "<ahelp hid=\".\">Déplace l'entrée sélectionnée d'une position vers le bas dans la liste.</ahelp>"
-
-#. DqTjR
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3156156\n"
-"help.text"
-msgid "all"
-msgstr "tout"
-
-#. FBk6i
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3154514\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/all\">Selects all of the data fields in the list.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/namematchingpage/all\">Sélectionne tous les champs de données dans la liste.</ahelp>"
-
-#. eFJ6S
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"hd_id3153541\n"
-"help.text"
-msgid "none"
-msgstr "aucun(e)"
-
-#. LYsDF
-#: 05030400.xhp
-msgctxt ""
-"05030400.xhp\n"
-"par_id3148563\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/none\">Clears all of the check boxes in the list.</ahelp>"
-msgstr "<ahelp hid=\"dbaccess/ui/namematchingpage/none\">Décoche toutes les cases de la liste.</ahelp>"
-
#. rxCsN
#: 05040000.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/guide.po b/source/fr/helpcontent2/source/text/shared/guide.po
index ac1afa539f7..8bccab3072e 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: 2021-03-19 17:31+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-02-21 17:36+0000\n"
"Last-Translator: Jean-Baptiste Faure <jbfaure@libreoffice.org>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsharedguide/fr/>\n"
@@ -20402,23 +20402,23 @@ msgctxt ""
msgid "<emph>High</emph>: 30% of codewords can be restored."
msgstr "<emph>Haute</emph> : 30% des mots codés peuvent être restaurés."
-#. F32vf
+#. S5CKs
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"hd_id701566316879046\n"
"help.text"
-msgid "Border"
-msgstr "Bordure"
+msgid "Margin"
+msgstr ""
-#. wz9kT
+#. MUEWe
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id981566316947064\n"
"help.text"
-msgid "The width in dots of the border surrounding the QR code."
-msgstr "La largeur en points de la bordure entourant le QR code."
+msgid "The width of the margin surrounding the QR code."
+msgstr ""
#. kZPNW
#: qrcode.xhp
diff --git a/source/fr/helpcontent2/source/text/simpress/guide.po b/source/fr/helpcontent2/source/text/simpress/guide.po
index 28d57e2e94e..abe9d8944bc 100644
--- a/source/fr/helpcontent2/source/text/simpress/guide.po
+++ b/source/fr/helpcontent2/source/text/simpress/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: 2021-03-23 11:45+0100\n"
+"POT-Creation-Date: 2021-03-29 16:02+0200\n"
"PO-Revision-Date: 2021-03-19 16:40+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textsimpressguide/fr/>\n"
@@ -2770,13 +2770,13 @@ msgctxt ""
msgid "To start a Slide Show"
msgstr ""
-#. 3vhZG
+#. o6aBw
#: keyboard.xhp
msgctxt ""
"keyboard.xhp\n"
"par_id3150650\n"
"help.text"
-msgid "To start a slide show from the begining, press <keycode>F5</keycode>."
+msgid "To start a slide show from the beginning, press <keycode>F5</keycode>."
msgstr ""
#. WaqYV
diff --git a/source/fr/helpcontent2/source/text/swriter.po b/source/fr/helpcontent2/source/text/swriter.po
index 9f11d8ae54a..0e1b3ab2038 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: 2021-03-19 17:31+0100\n"
+"POT-Creation-Date: 2021-03-29 16:03+0200\n"
"PO-Revision-Date: 2021-03-20 17:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textswriter/fr/>\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.4.2\n"
+"X-Generator: LibreOffice\n"
"X-Project-Style: openoffice\n"
"X-POOTLE-MTIME: 1546876370.000000\n"
@@ -2582,14 +2582,14 @@ msgctxt ""
msgid "<link href=\"text/swriter/main0206.xhp\" name=\"Bullets and Numbering Bar\">Bullets and Numbering Bar</link>"
msgstr "<link href=\"text/swriter/main0206.xhp\" name=\"Barre Puces et numérotation\">Barre Puces et numérotation</link>"
-#. GnEX6
+#. qVzcD
#: main0206.xhp
msgctxt ""
"main0206.xhp\n"
"par_id3154277\n"
"help.text"
-msgid "<ahelp hid=\"HID_NUM_TOOLBOX\">The <emph>Bullets and Numbering</emph> bar contains functions to modify the structure of numbered paragraphs, including changing the order of paragraphs and defining different paragraph levels.</ahelp>"
-msgstr "<ahelp hid=\"HID_NUM_TOOLBOX\">La barre <emph>Puces et numérotation</emph> comporte des fonctions qui permettent de modifier la structure des paragraphes numérotés, notamment de changer l'ordre des paragraphes et de définir des niveaux de paragraphe différents.</ahelp>"
+msgid "<ahelp hid=\"HID_NUM_TOOLBOX\">The <emph>Bullets and Numbering</emph> bar contains functions to modify the structure of list paragraphs, including changing their order and list level.</ahelp>"
+msgstr ""
#. do6CG
#: main0208.xhp
diff --git a/source/fr/helpcontent2/source/text/swriter/01.po b/source/fr/helpcontent2/source/text/swriter/01.po
index ef459ed87a0..39d3d779a8b 100644
--- a/source/fr/helpcontent2/source/text/swriter/01.po
+++ b/source/fr/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: 2021-03-23 11:45+0100\n"
+"POT-Creation-Date: 2021-03-29 16:03+0200\n"
"PO-Revision-Date: 2021-01-21 14:36+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textswriter01/fr/>\n"
@@ -16154,14 +16154,14 @@ msgctxt ""
msgid "<ahelp hid=\"modules/swriter/ui/numparapage/comboLB_OUTLINE_LEVEL\">Assigns an outline level from 1 to 10 to the selected paragraphs or Paragraph Style.</ahelp> Select <emph>Text Body</emph> to reset the outline level."
msgstr "<ahelp hid=\"modules/swriter/ui/numparapage/comboLB_OUTLINE_LEVEL\">Assigne un niveau de plan de 1 à 10 aux paragraphes sélectionnés ou au style de paragraphe.</ahelp> Sélectionnez <emph>Corps de texte</emph> pour réinitialiser le niveau de plan."
-#. GaPuE
+#. sdLZj
#: 05030800.xhp
msgctxt ""
"05030800.xhp\n"
"hd_id3143283\n"
"help.text"
-msgid "Numbering"
-msgstr "Numérotation"
+msgid "Apply List Style"
+msgstr ""
#. fFAFo
#: 05030800.xhp
@@ -16190,14 +16190,14 @@ msgctxt ""
msgid "Edit Style"
msgstr "Éditer le style"
-#. ScSSA
+#. PmMzY
#: 05030800.xhp
msgctxt ""
"05030800.xhp\n"
"par_id3155179\n"
"help.text"
-msgid "<ahelp hid=\"modules/swriter/ui/numparapage/editnumstyle\">Edit the properties of the selected numbering style.</ahelp> These properties will apply to all paragraphs formatted with the given numbering style."
-msgstr "<ahelp hid=\"modules/swriter/ui/numparapage/editnumstyle\">Éditer les propriétés du style de numérotation sélectionné.</ahelp> Ces propriétés s'appliqueront à tous les paragraphes formatés avec le style de numérotation donné."
+msgid "<ahelp hid=\"modules/swriter/ui/numparapage/editnumstyle\">Edit the properties of the selected list style.</ahelp> These properties will apply to all paragraphs formatted with the given list style."
+msgstr ""
#. dxBEA
#: 05030800.xhp
@@ -16226,14 +16226,14 @@ msgctxt ""
msgid "This section only appears when you edit the properties of the current paragraph by choosing <emph>Format - Paragraph</emph>."
msgstr "Cette section n'est disponible que si vous éditez les propriétés du paragraphe actif via le menu <emph>Format - Paragraphe</emph>."
-#. oNKzj
+#. 3c6ZA
#: 05030800.xhp
msgctxt ""
"05030800.xhp\n"
"hd_id3151250\n"
"help.text"
-msgid "Restart at this paragraph"
-msgstr "Recommencer avec ce paragraphe"
+msgid "Restart numbering at this paragraph"
+msgstr ""
#. Fqcca
#: 05030800.xhp
@@ -16352,6 +16352,15 @@ msgctxt ""
msgid "<ahelp hid=\"modules/swriter/ui/numparapage/spinNF_RESTART_PARA\">Enter the number at which to restart the line numbering</ahelp>"
msgstr "<ahelp hid=\"modules/swriter/ui/numparapage/spinNF_RESTART_PARA\">Entrez le numéro à partir duquel vous souhaitez reprendre la numérotation des lignes</ahelp>"
+#. 7JGYU
+#: 05030800.xhp
+msgctxt ""
+"05030800.xhp\n"
+"par_id551616756044690\n"
+"help.text"
+msgid "The following buttons appear only for Paragraph Style."
+msgstr ""
+
#. jAnkr
#: 05040000.xhp
msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/swriter/02.po b/source/fr/helpcontent2/source/text/swriter/02.po
index 9123bf209bf..a8b9777a539 100644
--- a/source/fr/helpcontent2/source/text/swriter/02.po
+++ b/source/fr/helpcontent2/source/text/swriter/02.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-03-23 11:45+0100\n"
+"POT-Creation-Date: 2021-03-29 16:03+0200\n"
"PO-Revision-Date: 2021-03-19 16:40+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textswriter02/fr/>\n"
@@ -863,13 +863,13 @@ msgctxt ""
msgid "To remove the numbering restart, apply the command again in the paragraph where the numbering was restarted."
msgstr ""
-#. bEE4F
+#. 7h49d
#: 06140000.xhp
msgctxt ""
"06140000.xhp\n"
"par_id261616371203225\n"
"help.text"
-msgid "To restart numbering with a number greater than 1, right-click in the paragraph where you want to restart numbering, choose <menuitem>Paragraph - </menuitem><embedvar href=\"textswriter/01/05030800.xhp#outlinelisth1\"/> tab, select <menuitem>Restart numbering at this paragraph</menuitem> and enter the start number in <menuitem>Start with</menuitem>."
+msgid "To restart numbering with a number greater than 1, right-click in the paragraph where you want to restart numbering, choose <menuitem>Paragraph - Paragraph - </menuitem><embedvar href=\"text/swriter/01/05030800.xhp#outlinelisth1\"/> tab, select <menuitem>Restart numbering at this paragraph</menuitem> and enter the start number in <menuitem>Start with</menuitem>."
msgstr ""
#. qCdhk
diff --git a/source/fr/helpcontent2/source/text/swriter/guide.po b/source/fr/helpcontent2/source/text/swriter/guide.po
index f005a502047..b258cf59076 100644
--- a/source/fr/helpcontent2/source/text/swriter/guide.po
+++ b/source/fr/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-03-23 11:45+0100\n"
+"POT-Creation-Date: 2021-03-29 16:03+0200\n"
"PO-Revision-Date: 2021-03-19 16:40+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: French <https://translations.documentfoundation.org/projects/libo_help-master/textswriterguide/fr/>\n"
@@ -9557,14 +9557,14 @@ msgctxt ""
msgid "Follow the scanning instructions."
msgstr "Suivez les instructions fournies."
-#. FobBn
+#. AwAKw
#: insert_tab_innumbering.xhp
msgctxt ""
"insert_tab_innumbering.xhp\n"
"tit\n"
"help.text"
-msgid "Changing the Chapter Level of Numbered and Bulleted Lists"
-msgstr "Modification du niveau de plan des listes numérotées et des listes à puces"
+msgid "Changing the List Level of a List Paragraph"
+msgstr ""
#. NDiP8
#: insert_tab_innumbering.xhp
@@ -9575,32 +9575,32 @@ msgctxt ""
msgid "<bookmark_value>tab stops; inserting in lists</bookmark_value><bookmark_value>numbering; changing the level of</bookmark_value><bookmark_value>lists;changing levels</bookmark_value><bookmark_value>levels;changing chapter levels</bookmark_value><bookmark_value>bullet lists;changing levels</bookmark_value><bookmark_value>lowering chapter levels</bookmark_value><bookmark_value>rising chapter levels</bookmark_value><bookmark_value>changing;chapter levels</bookmark_value><bookmark_value>promote level;in lists</bookmark_value><bookmark_value>demote level;in lists</bookmark_value>"
msgstr "<bookmark_value>Tabulations;insertion dans les listes</bookmark_value><bookmark_value>Numérotation;modifier le niveau de</bookmark_value><bookmark_value>Listes;modifier les niveaux</bookmark_value><bookmark_value>Niveaux;modifier les niveaux de chapitres</bookmark_value><bookmark_value>Listes à puces;changer les niveaux</bookmark_value><bookmark_value>Abaisser les niveaux de chapitres</bookmark_value><bookmark_value>Hausser les niveaux de chapitres</bookmark_value><bookmark_value>Modifier;niveaux de chapitre</bookmark_value><bookmark_value>Hausser le niveau;dans les listes</bookmark_value><bookmark_value>Baisser le niveau;dans les listes</bookmark_value>"
-#. ngzwj
+#. tr48L
#: insert_tab_innumbering.xhp
msgctxt ""
"insert_tab_innumbering.xhp\n"
"hd_id3145078\n"
"help.text"
-msgid "<variable id=\"insert_tab_innumbering\"><link href=\"text/swriter/guide/insert_tab_innumbering.xhp\" name=\"Changing the Outline Level of Numbered and Bulleted Lists\">Changing the Chapter Level of Numbered and Bulleted Lists</link></variable>"
-msgstr "<variable id=\"insert_tab_innumbering\"><link href=\"text/swriter/guide/insert_tab_innumbering.xhp\" name=\"Changement du niveau de plan des listes numérotées ou à puces\">Changement du niveau de plan des listes numérotées ou à puces</link></variable>"
+msgid "<variable id=\"insert_tab_innumbering\"><link href=\"text/swriter/guide/insert_tab_innumbering.xhp\" name=\"Changing the Outline Level of Numbered and Bulleted Lists\">Changing the List Level of a List Paragraph</link></variable>"
+msgstr ""
-#. Ru3Cb
+#. epGvP
#: insert_tab_innumbering.xhp
msgctxt ""
"insert_tab_innumbering.xhp\n"
"par_id3155909\n"
"help.text"
-msgid "To move a numbered or bulleted paragraph down one chapter level, click at the beginning of the paragraph, and then press <keycode>Tab</keycode>."
-msgstr "Pour déplacer un paragraphe numéroté ou à puce d'un niveau vers le bas, cliquez au début du paragraphe et appuyez ensuite sur la touche <keycode>Tab</keycode>."
+msgid "To move a numbered or bulleted list paragraph down one list level, click at the beginning of the paragraph, and then press <keycode>Tab</keycode>."
+msgstr ""
-#. HD77j
+#. 9onR5
#: insert_tab_innumbering.xhp
msgctxt ""
"insert_tab_innumbering.xhp\n"
"par_id3155859\n"
"help.text"
-msgid "To move a numbered or bulleted paragraph up one chapter level, click at the beginning of the paragraph, and then press <keycode>Shift+Tab</keycode>."
-msgstr "Pour déplacer un paragraphe numéroté ou à puce d'un niveau vers le haut, cliquez au début du paragraphe et appuyez ensuite sur les touches <keycode>Maj+Tab</keycode>."
+msgid "To move a numbered or bulleted list paragraph up one list level, click at the beginning of the paragraph, and then press <keycode>Shift+Tab</keycode>."
+msgstr ""
#. A6CtC
#: insert_tab_innumbering.xhp
@@ -18566,13 +18566,13 @@ msgctxt ""
msgid "On the <emph>Formatting</emph> Bar, click the <emph>Toggle Ordered List</emph> icon (<keycode>F12</keycode>)"
msgstr ""
-#. dpmx5
+#. EaSQT
#: using_numbered_lists2.xhp
msgctxt ""
"using_numbered_lists2.xhp\n"
"par_id211615764184529\n"
"help.text"
-msgid "Right-click, choose <menuitem>Lists</menuitem>, then select a list style."
+msgid "Right-click, choose <menuitem>List</menuitem>, then select a list style."
msgstr ""
#. dQ6VP
@@ -18629,13 +18629,13 @@ msgctxt ""
msgid "Click in the list, then choose <menuitem>Format - Bullets and Numbering</menuitem>."
msgstr ""
-#. ThdUE
+#. xAc7B
#: using_numbered_lists2.xhp
msgctxt ""
"using_numbered_lists2.xhp\n"
"par_id161615765280165\n"
"help.text"
-msgid "Right-click in the list, then choose <menuitem>Lists - Bullets and Numbering</menuitem>."
+msgid "Right-click in the list, then choose <menuitem>List - Bullets and Numbering</menuitem>."
msgstr ""
#. xgmVR
@@ -18656,32 +18656,32 @@ msgctxt ""
msgid "Copying or moving an item from a numbered list to a new location continues the list numbering. To start a new numbering with the pasted item, click <emph>Toggle Ordered List</emph> twice. Any formatting on the pasted item is reset to default."
msgstr ""
-#. MAprK
+#. kPFQQ
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"tit\n"
"help.text"
-msgid "Numbering and Numbering Styles"
-msgstr "Numérotation et styles de numérotation"
+msgid "Numbering and Paragraph Styles"
+msgstr ""
-#. 6emSb
+#. FfEcT
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"bm_id3155174\n"
"help.text"
-msgid "<bookmark_value>numbering; manually/by styles</bookmark_value> <bookmark_value>manual numbering in text</bookmark_value> <bookmark_value>paragraph styles;numbering</bookmark_value>"
-msgstr "<bookmark_value>Numérotation;manuellement/par les styles</bookmark_value><bookmark_value>Numérotation manuelle dans le texte</bookmark_value><bookmark_value>Styles de paragraphe;numérotation</bookmark_value>"
+msgid "<bookmark_value>numbering;manually/by styles</bookmark_value><bookmark_value>list styles</bookmark_value><bookmark_value>manual numbering in text</bookmark_value><bookmark_value>paragraph styles;numbering</bookmark_value>"
+msgstr ""
-#. DGTBD
+#. FizBP
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"hd_id3155174\n"
"help.text"
-msgid "<variable id=\"using_numbering\"><link href=\"text/swriter/guide/using_numbering.xhp\" name=\"Numbering and Numbering Styles\">Numbering and Numbering Styles</link></variable>"
-msgstr "<variable id=\"using_numbering\"><link href=\"text/swriter/guide/using_numbering.xhp\" name=\"Numbering and Numbering Styles\">Numérotation et styles de numérotation</link></variable>"
+msgid "<variable id=\"using_numbering\"><link href=\"text/swriter/guide/using_numbering.xhp\" name=\"Numbering and Numbering Styles\">Numbering and Paragraph Styles</link></variable>"
+msgstr ""
#. DeMXq
#: using_numbering.xhp
@@ -18692,6 +18692,15 @@ msgctxt ""
msgid "You can apply numbering to a paragraph manually or with a paragraph style."
msgstr "Vous pouvez appliquer une numérotation à un paragraphe soit manuellement, soit à l'aide d'un style de paragraphe."
+#. QEp87
+#: using_numbering.xhp
+msgctxt ""
+"using_numbering.xhp\n"
+"par_id31616154131555\n"
+"help.text"
+msgid "If you want numbered headings, use <menuitem>Tools - </menuitem><embedvar href=\"text/swriter/01/06060000.xhp#ChapNumh1\"/>, instead of numbering manually."
+msgstr ""
+
#. Dh8sW
#: using_numbering.xhp
msgctxt ""
@@ -18701,14 +18710,14 @@ msgctxt ""
msgid "To Apply Numbering Manually"
msgstr "Pour appliquer manuellement une numérotation"
-#. XgBso
+#. uCaGG
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"par_id3155866\n"
"help.text"
-msgid "To apply numbering manually, click in the paragraph, and then click the <item type=\"menuitem\">Numbering On/Off</item> icon on the <item type=\"menuitem\">Formatting</item> Bar."
-msgstr "Pour appliquer manuellement une numérotation, cliquez dans le paragraphe, puis cliquez sur l'icône <item type=\"menuitem\">(Dés)Activer la numérotation</item> dans la barre <item type=\"menuitem\">Formatage</item>."
+msgid "To apply numbering manually, click in the paragraph, and then click the <menuitem>Toggle Ordered List</menuitem> icon on the <menuitem>Formatting</menuitem> bar, or use the dropdown box on the icon to select a numbering format."
+msgstr ""
#. m2kdH
#: using_numbering.xhp
@@ -18728,15 +18737,6 @@ msgctxt ""
msgid "When you press Enter in a numbered or bulleted list, <item type=\"productname\">%PRODUCTNAME</item> automatically numbers the next paragraph. To remove the numbering or bullet from the new paragraph, press Enter again."
msgstr "Si vous appuyez sur Entrée dans une liste numérotée ou à puces, <item type=\"productname\">%PRODUCTNAME</item> numérote automatiquement le paragraphe suivant. Pour supprimer le numéro ou la puce du nouveau paragraphe, appuyez de nouveau sur Entrée."
-#. GEvN8
-#: using_numbering.xhp
-msgctxt ""
-"using_numbering.xhp\n"
-"par_idN1072B\n"
-"help.text"
-msgid "To change the hierarchical level of a bullet in a list, click in front of the paragraph, then press the Tab key."
-msgstr "Pour modifier le niveau hiérarchique d'une puce dans une liste, cliquez devant le paragraphe et appuyez sur la touche de tabulation."
-
#. qSgCG
#: using_numbering.xhp
msgctxt ""
@@ -18755,23 +18755,32 @@ msgctxt ""
msgid "To change the bullet or numbering format for all paragraphs in the list, ensure that the cursor is in the list, choose <item type=\"menuitem\">Format - Bullets and Numbering</item>, and then click a new format."
msgstr "Pour modifier le format de numérotation ou de puces de tous les paragraphes de la liste, vérifiez que le curseur se trouve à l'intérieur de la liste, choisissez <item type=\"menuitem\">Format - Puces et numérotation</item>, puis cliquez sur un nouveau format."
-#. oXAse
+#. VVXeQ
+#: using_numbering.xhp
+msgctxt ""
+"using_numbering.xhp\n"
+"par_idN1073A\n"
+"help.text"
+msgid "Use the commands on the <link href=\"text/swriter/main0206.xhp\" name=\"Numbering Object Bar\">Bullets and Numbering</link> bar to change the order and level of list paragraphs."
+msgstr ""
+
+#. f48BU
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
-"par_idN10737\n"
+"par_id791616153048415\n"
"help.text"
-msgid "To apply the same bullet or numbering format to all paragraphs in the list, select all paragraphs, choose <item type=\"menuitem\">Format - Bullets and Numbering</item>, and then click a format."
-msgstr "Pour appliquer le même format de numérotation ou de puces à tous les paragraphes de la liste, sélectionnez tous les paragraphes, choisissez <item type=\"menuitem\">Format - Puces et numérotation</item>, puis cliquez sur un format."
+msgid "To see which paragraphs are in the same list, click to the left of a number or symbol at the beginning of a list paragraph, with <link href=\"text/swriter/01/03080000.xhp\" name=\"Shadings\"><menuitem>View - Field Shadings</menuitem> </link> (<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+F8</keycode>) enabled."
+msgstr ""
-#. PmyyA
+#. Egm22
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
-"par_idN1073A\n"
+"par_id751615828987862\n"
"help.text"
-msgid "You can also use the commands on the <link href=\"text/swriter/main0206.xhp\" name=\"Numbering Object Bar\">Bullets and Numbering</link> toolbar to edit a numbered or bulleted list. To change the numbering or bullet format, click the <emph>Bullets and Numbering</emph> icon."
-msgstr "Vous pouvez également utiliser les commandes de la <link href=\"text/swriter/main0206.xhp\" name=\"barre d'objets de numérotation\">barre d'outils Puces et numérotation</link> pour éditer une liste numérotée ou à puces. Pour modifier le format de numérotation ou celui des puces, cliquez sur l'icône <emph>Puces et numérotation</emph>."
+msgid "To add selected paragraphs to an existing list, use <link href=\"text/swriter/02/add_to_list.xhp\" name=\"Add to Previous List\"><menuitem>Format - Lists - Add to List</menuitem></link>."
+msgstr ""
#. qFAkZ
#: using_numbering.xhp
@@ -18782,14 +18791,14 @@ msgctxt ""
msgid "To Apply Numbering With a Paragraph Style"
msgstr "Pour appliquer une numérotation à l'aide d'un style de paragraphe"
-#. FqYE3
+#. GmcBA
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"par_id3153137\n"
"help.text"
-msgid "Paragraph Styles give you greater control over numbering that you apply in a document. When you change the numbering format of the style, all paragraphs using the style are automatically updated."
-msgstr "L'utilisation de styles de paragraphe permet de mieux contrôler la numérotation appliquée à un document. En effet, lorsque vous modifiez le format de numérotation d'un style, tous les paragraphes formatés avec ce style sont automatiquement actualisés."
+msgid "Paragraph Styles give you greater control over numbering that you apply in a document. When you change the list style assigned to a paragraph style, then the numbering format in the list style is applied automatically to all paragraphs using the paragraph style."
+msgstr ""
#. M3VEp
#: using_numbering.xhp
@@ -18809,23 +18818,23 @@ msgctxt ""
msgid "Right-click the paragraph style that you want to apply numbering to, and then choose <emph>Modify</emph>."
msgstr "Cliquez avec le bouton droit de la souris sur le style de paragraphe auquel appliquer la numérotation, puis choisissez <emph>Modifier</emph>."
-#. oEjFY
+#. RbEBA
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"par_id3149850\n"
"help.text"
-msgid "Click the <item type=\"menuitem\">Outline & Numbering</item> tab."
-msgstr "Cliquez sur l'onglet <item type=\"menuitem\">Plan et numérotation</item>."
+msgid "Click the <item type=\"menuitem\">Outline & List</item> tab."
+msgstr ""
-#. Gd8ia
+#. pnM3U
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"par_id3149874\n"
"help.text"
-msgid "In the <item type=\"menuitem\">Numbering Style</item> box, select the type of numbering that you want to use."
-msgstr "Dans le champ <item type=\"menuitem\">Style de numérotation</item>, sélectionnez le type de numérotation à utiliser."
+msgid "In the <menuitem>List style</menuitem> box, select the list style to apply."
+msgstr ""
#. r8dBG
#: using_numbering.xhp
@@ -18836,14 +18845,23 @@ msgctxt ""
msgid "Click <emph>OK</emph>."
msgstr "Cliquez sur <emph>OK</emph>."
-#. rdJpP
+#. K36gj
#: using_numbering.xhp
msgctxt ""
"using_numbering.xhp\n"
"par_id3149589\n"
"help.text"
-msgid "Apply the style to the paragraphs that you want to add numbering to."
-msgstr "Appliquez le style aux paragraphes à numéroter."
+msgid "Apply the paragraph style to the paragraphs that you want to add numbering to."
+msgstr ""
+
+#. HBCBV
+#: using_numbering.xhp
+msgctxt ""
+"using_numbering.xhp\n"
+"par_id401616165733544\n"
+"help.text"
+msgid "<link href=\"text/swriter/01/05130004.xhp\" name=\"List Style\">List Style</link>"
+msgstr ""
#. 8s2hg
#: using_thesaurus.xhp