update translations for 6.1.0 rc1

Change-Id: Ibff5b92a1b44ed2546d3ad25312e272ada2fa350

13 files changed, 1304 insertions, 282 deletions

diff --git a/source/fr/helpcontent2/source/auxiliary.po b/source/fr/helpcontent2/source/auxiliary.po
index a992f57cf9d..4063f134146 100644
--- a/source/fr/helpcontent2/source/auxiliary.po
+++ b/source/fr/helpcontent2/source/auxiliary.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-16 16:54+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-05-22 20:31+0000\n"
 "Last-Translator: Jean-Baptiste Faure <jbfaure@libreoffice.org>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1527021093.000000\n"
 
 #: sbasic.tree
@@ -59,6 +59,14 @@ msgstr "Liste alphabétique des fonctions, déclarations et opérateurs"
 #: sbasic.tree
 msgctxt ""
 "sbasic.tree\n"
+"070205\n"
+"node.text"
+msgid "Advanced Basic Libraries"
+msgstr ""
+
+#: sbasic.tree
+msgctxt ""
+"sbasic.tree\n"
 "0703\n"
 "node.text"
 msgid "Guides"
diff --git a/source/fr/helpcontent2/source/text/sbasic/shared.po b/source/fr/helpcontent2/source/text/sbasic/shared.po
index bd0875e5755..beb2159d694 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: 2018-05-16 16:54+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-05-25 15:00+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1527260413.000000\n"
 
@@ -476,6 +476,22 @@ msgstr "Blanc transparent"
 #: 00000003.xhp
 msgctxt ""
 "00000003.xhp\n"
+"par_id631529000528928\n"
+"help.text"
+msgid "Open <item type=\"menuitem\">Tools - Macros - %PRODUCTNAME Basic - Edit</item>  and select <item type=\"menuitem\">%PRODUCTNAME Macros</item> container."
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id971529072633266\n"
+"help.text"
+msgid "<variable id=\"basiclibrarynote\">This library must be loaded before execution. Place the following statement before the first macro in your module:</variable>"
+msgstr ""
+
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
 "par_id051920171018124524\n"
 "help.text"
 msgid "This function or constant is enabled with the statement <item type=\"literal\">Option VBASupport 1</item> placed before the executable program code in a module."
@@ -35612,6 +35628,22 @@ msgstr "Travailler avec des macros VBA"
 #: main0601.xhp
 msgctxt ""
 "main0601.xhp\n"
+"hd_id51528998827009\n"
+"help.text"
+msgid "%PRODUCTNAME internal Basic macro libraries"
+msgstr ""
+
+#: main0601.xhp
+msgctxt ""
+"main0601.xhp\n"
+"par_id441528998842556\n"
+"help.text"
+msgid "%PRODUCTNAME installs a set of Basic macro libraries that can be accessed from your Basic macros."
+msgstr ""
+
+#: main0601.xhp
+msgctxt ""
+"main0601.xhp\n"
 "hd_id3148473\n"
 "help.text"
 msgid "Help about the Help"
diff --git a/source/fr/helpcontent2/source/text/sbasic/shared/03.po b/source/fr/helpcontent2/source/text/sbasic/shared/03.po
new file mode 100644
index 00000000000..61aa84495bd
--- /dev/null
+++ b/source/fr/helpcontent2/source/text/sbasic/shared/03.po
@@ -0,0 +1,510 @@
+#. extracted from helpcontent2/source/text/sbasic/shared/03
+msgid ""
+msgstr ""
+"Project-Id-Version: PACKAGE VERSION\n"
+"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
+"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
+"Language-Team: LANGUAGE <LL@li.org>\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"X-Accelerator-Marker: ~\n"
+"X-Generator: LibreOffice\n"
+
+#: lib_depot.xhp
+msgctxt ""
+"lib_depot.xhp\n"
+"tit\n"
+"help.text"
+msgid "DEPOT Library"
+msgstr ""
+
+#: lib_depot.xhp
+msgctxt ""
+"lib_depot.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"depot_lib\"><link href=\"text/sbasic/shared/03/lib_depot.xhp\" name=\"Depot library\">The <item type=\"literal\">Depot</item> Library</link></variable>"
+msgstr ""
+
+#: lib_euro.xhp
+msgctxt ""
+"lib_euro.xhp\n"
+"tit\n"
+"help.text"
+msgid "EURO Library"
+msgstr ""
+
+#: lib_euro.xhp
+msgctxt ""
+"lib_euro.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"euro_lib\"><link href=\"text/sbasic/shared/03/lib_euro.xhp\" name=\"Euro library\">The <item type=\"literal\">Euro</item> Library</link></variable>"
+msgstr ""
+
+#: lib_euro.xhp
+msgctxt ""
+"lib_euro.xhp\n"
+"bm_id231529070133574\n"
+"help.text"
+msgid "<bookmark_value>BASIC Euro library</bookmark_value>"
+msgstr ""
+
+#: lib_formwizard.xhp
+msgctxt ""
+"lib_formwizard.xhp\n"
+"tit\n"
+"help.text"
+msgid "FORMWIZARD Library"
+msgstr ""
+
+#: lib_formwizard.xhp
+msgctxt ""
+"lib_formwizard.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"formwizard_lib\"><link href=\"text/sbasic/shared/03/lib_formwizard.xhp\" name=\"FormWizard library\">The <item type=\"literal\">FormWizard</item> Library</link></variable>"
+msgstr ""
+
+#: lib_gimnicks.xhp
+msgctxt ""
+"lib_gimnicks.xhp\n"
+"tit\n"
+"help.text"
+msgid "GIMNICKS Library"
+msgstr ""
+
+#: lib_gimnicks.xhp
+msgctxt ""
+"lib_gimnicks.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"gimnicks_lib\"><link href=\"text/sbasic/shared/03/lib_gimnicks.xhp\" name=\"Gimnicks library\">The <item type=\"literal\">Gimnicks</item> Library</link></variable>"
+msgstr ""
+
+#: lib_gimnicks.xhp
+msgctxt ""
+"lib_gimnicks.xhp\n"
+"bm_id951529070357301\n"
+"help.text"
+msgid "<bookmark_value>BASIC Gimnicks library</bookmark_value>"
+msgstr ""
+
+#: lib_schedule.xhp
+msgctxt ""
+"lib_schedule.xhp\n"
+"tit\n"
+"help.text"
+msgid "SCHEDULE Library"
+msgstr ""
+
+#: lib_schedule.xhp
+msgctxt ""
+"lib_schedule.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"schedule_lib\"><link href=\"text/sbasic/shared/03/lib_schedule.xhp\" name=\"Schedule library\">The <item type=\"literal\">Schedule</item> Library</link></variable>"
+msgstr ""
+
+#: lib_schedule.xhp
+msgctxt ""
+"lib_schedule.xhp\n"
+"bm_id671529070099646\n"
+"help.text"
+msgid "<bookmark_value>BASIC Template library</bookmark_value>"
+msgstr ""
+
+#: lib_script.xhp
+msgctxt ""
+"lib_script.xhp\n"
+"tit\n"
+"help.text"
+msgid "SCRIPTBINDINGLIBRARY Library"
+msgstr ""
+
+#: lib_script.xhp
+msgctxt ""
+"lib_script.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"script_lib\"><link href=\"text/sbasic/shared/03/lib_script.xhp\" name=\"ScriptBindingLibrary library\">The <item type=\"literal\">ScriptBindingLibrary</item> Library</link></variable>"
+msgstr ""
+
+#: lib_script.xhp
+msgctxt ""
+"lib_script.xhp\n"
+"bm_id851529070366056\n"
+"help.text"
+msgid "<bookmark_value>BASIC ScriptBindingLibrary library</bookmark_value>"
+msgstr ""
+
+#: lib_template.xhp
+msgctxt ""
+"lib_template.xhp\n"
+"tit\n"
+"help.text"
+msgid "TEMPLATE Library"
+msgstr ""
+
+#: lib_template.xhp
+msgctxt ""
+"lib_template.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"template_lib\"><link href=\"text/sbasic/shared/03/lib_template.xhp\" name=\"Template library\">The <item type=\"literal\">Template</item> Library</link></variable>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"tit\n"
+"help.text"
+msgid "Tools Library"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id31529004750471\n"
+"help.text"
+msgid "<variable id=\"tools_lib\"><link href=\"text/sbasic/shared/03/lib_tools.xhp\" name=\"Tools library\">The <item type=\"literal\">Tools</item> Library</link></variable>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id491529070339774\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id161529001339405\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#debug_module\" name=\"debug module\"><item type=\"literal\">Debug</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id41529001348561\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#listbox_module\" name=\"listbox module\"><item type=\"literal\">ListBox</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id341529001354451\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#misc_module\" name=\"misc module\"><item type=\"literal\">Misc</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id311529001362049\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#modulecontrols_module\" name=\"module controls module\"><item type=\"literal\">ModuleControls</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id701529001368064\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#strings_module\" name=\"strings module\"><item type=\"literal\">Strings</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id251529001373426\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/lib_tools.xhp#ucb_module\" name=\"ucb module\"><item type=\"literal\">UCB</item> Module</link>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id271529062442803\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;Debug module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id371529000826947\n"
+"help.text"
+msgid "<item type=\"literal\">Debug</item>  Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id441529064369519\n"
+"help.text"
+msgid "Functions and subroutines for debugging Basic macros"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id801529001004856\n"
+"help.text"
+msgid "<variable id=\"macro_name\">Macro</variable>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id41529001004856\n"
+"help.text"
+msgid "<variable id=\"call_param\">Calling parameters and comments</variable>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id131529062501888\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;ListBox module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id11529005753099\n"
+"help.text"
+msgid "<item type=\"literal\">ListBox</item>  Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id381529064415052\n"
+"help.text"
+msgid "Functions and subroutines for handling ListBox elements."
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id571529062538621\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;Misc module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id341529005758494\n"
+"help.text"
+msgid "<item type=\"literal\">Misc</item>  Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id681529064596175\n"
+"help.text"
+msgid "Miscellaneous functions and subroutines."
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id821529007072253\n"
+"help.text"
+msgid "' Opens a Document, checks beforehand, whether it has to be loaded or whether it is already on the desktop. If the parameter bDisposable is set to False then then returned document should not be disposed afterwards, because it is already opened."
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id81529007245965\n"
+"help.text"
+msgid "' Retrieves a FileName out of a StarOffice-Document"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id801529007338550\n"
+"help.text"
+msgid "' Gets a special configured PathSetting"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id761529007616982\n"
+"help.text"
+msgid "' Gets the fully qualified path to a subdirectory of the Template Directory, e. g. with the parameter \"wizard/bitmap\"  The parameter must be passed over in Url-scription. The return-Value is in Urlscription"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id311529007997114\n"
+"help.text"
+msgid "' Deletes the content of all cells that are softformatted according to the 'InputStyleName'"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id261529008090521\n"
+"help.text"
+msgid "' Inserts a certain String to all cells of a Range that ist passed over either as an object or as the RangeName"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547271480\n"
+"help.text"
+msgid "' Returns the Value of the first cell of a Range"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547275159\n"
+"help.text"
+msgid "' Returns the String of the first cell of a Range"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547271588\n"
+"help.text"
+msgid "' Returns a named Cell"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547288384\n"
+"help.text"
+msgid "' Changes the numeric Value of a cell by transmitting the String of the numeric Value"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547292068\n"
+"help.text"
+msgid "' Dis-or enables a Window and adjusts the mousepointer accordingly"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547295117\n"
+"help.text"
+msgid "' Note To set a one lined frame you have to set the inner width to 0 In the API all Units that refer to pt-Heights are \"1/100mm\" The convert factor from 1pt to 1/100 mm is approximately 35"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547306757\n"
+"help.text"
+msgid "'returns the type of the office application FatOffice = 0, WebTop = 1 This routine has to be changed if the Product Name is being changed!"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547308844\n"
+"help.text"
+msgid "' This Sub has been used in order to ensure that after disposing a document from the backing window it is returned to the backing window, so the office won't be closed"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id061420180547311590\n"
+"help.text"
+msgid "'Function to calculate if the year is a leap year"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id21529062611375\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;ModuleControl module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id451529005764422\n"
+"help.text"
+msgid "<item type=\"literal\">ModuleControls</item>  Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id841529064645990\n"
+"help.text"
+msgid "Functions and subroutines for module control."
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id271529062660965\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;Strings module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id461529005770576\n"
+"help.text"
+msgid "<item type=\"literal\">Strings</item> Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id631529064722315\n"
+"help.text"
+msgid "Advanced functions and subroutines for string manipulation."
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"bm_id731529062695476\n"
+"help.text"
+msgid "<bookmark_value>BASIC Tools library;UCB module</bookmark_value>"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"hd_id461529005780299\n"
+"help.text"
+msgid "<item type=\"literal\">UCB</item> Module"
+msgstr ""
+
+#: lib_tools.xhp
+msgctxt ""
+"lib_tools.xhp\n"
+"par_id131529064870824\n"
+"help.text"
+msgid "<emph>Universal Content Broker</emph> functions and subroutines."
+msgstr ""
diff --git a/source/fr/helpcontent2/source/text/scalc/00.po b/source/fr/helpcontent2/source/text/scalc/00.po
index b757e764996..3986dfcf7fe 100644
--- a/source/fr/helpcontent2/source/text/scalc/00.po
+++ b/source/fr/helpcontent2/source/text/scalc/00.po
@@ -4,7 +4,7 @@ msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
 "POT-Creation-Date: 2017-11-22 13:53+0100\n"
-"PO-Revision-Date: 2017-11-22 17:59+0000\n"
+"PO-Revision-Date: 2018-06-19 10:29+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
 "Language: fr\n"
@@ -14,7 +14,7 @@ msgstr ""
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
 "X-Generator: Pootle 2.8\n"
-"X-POOTLE-MTIME: 1511373592.000000\n"
+"X-POOTLE-MTIME: 1529404196.000000\n"
 
 #: 00000004.xhp
 msgctxt ""
@@ -558,7 +558,7 @@ msgctxt ""
 "par_id3145214\n"
 "help.text"
 msgid "<variable id=\"einaei\">Choose <emph>Sheet - Named Ranges and Expressions - Insert</emph></variable>"
-msgstr "<variable id=\"einaei\">Choisissez <emph>Freuille - Plages nommées et expressions - Insérer</emph></variable>"
+msgstr "<variable id=\"einaei\">Choisissez <emph>Feuille - Plages nommées et expressions - Insérer</emph></variable>"
 
 #: 00000404.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/scalc/01.po b/source/fr/helpcontent2/source/text/scalc/01.po
index 305ca41326d..1eea106a79b 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: 2018-05-08 15:11+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-05-25 15:41+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1527262881.000000\n"
 
 #: 01120000.xhp
@@ -14645,8 +14645,8 @@ msgctxt ""
 "04060106.xhp\n"
 "hd_id3163596\n"
 "help.text"
-msgid "SUM"
-msgstr "SOMME"
+msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -14773,8 +14773,8 @@ msgctxt ""
 "04060106.xhp\n"
 "hd_id3151957\n"
 "help.text"
-msgid "SUMIF"
-msgstr "SOMME.SI"
+msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -19731,14 +19731,6 @@ msgstr "<item type=\"input\">=ADRESSE(1;1;2;;\"Feuille2\")</item> renvoie : Feui
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
-"par_id3159260\n"
-"help.text"
-msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6."
-msgstr "Si la cellule A1 de la feuille 2 contient la valeur <item type=\"input\">-6</item>, vous pouvez référer indirectement à la cellule référencée en utilisant la fonction en B2 en saisissant <item type=\"input\">=ABS(INDIRECT(B2))</item>. Le résultat est la valeur absolue de la cellule référencée spécifiée en B2, qui dans ce cas est 6."
-
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
 "bm_id3150372\n"
 "help.text"
 msgid "<bookmark_value>AREAS function</bookmark_value>"
@@ -20275,6 +20267,14 @@ msgstr "<item type=\"input\">=SOMME(INDIRECT(\"a1:\" & ADRESSE(1;3)))</item> tot
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
+"par_id3159260\n"
+"help.text"
+msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6."
+msgstr "Si la cellule A1 de la feuille 2 contient la valeur <item type=\"input\">-6</item>, vous pouvez référer indirectement à la cellule référencée en utilisant la fonction en B2 en saisissant <item type=\"input\">=ABS(INDIRECT(B2))</item>. Le résultat est la valeur absolue de la cellule référencée spécifiée en B2, qui dans ce cas est 6."
+
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
 "bm_id3154818\n"
 "help.text"
 msgid "<bookmark_value>COLUMN function</bookmark_value>"
@@ -35549,8 +35549,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3148437\n"
 "help.text"
-msgid "COUNT"
-msgstr "NB"
+msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35621,8 +35621,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3149729\n"
 "help.text"
-msgid "COUNTA"
-msgstr "NBVAL"
+msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35693,8 +35693,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3150896\n"
 "help.text"
-msgid "COUNTBLANK"
-msgstr "NB.VIDE"
+msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35757,8 +35757,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3164897\n"
 "help.text"
-msgid "COUNTIF"
-msgstr "NB.SI"
+msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -41173,8 +41173,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3154511\n"
 "help.text"
-msgid "MAX"
-msgstr "MAX"
+msgid "<variable id=\"max_head\"><link href=\"text/scalc/01/04060184.xhp#max\">MAX</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41253,8 +41253,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3166426\n"
 "help.text"
-msgid "MAXA"
-msgstr "MAX"
+msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41333,8 +41333,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3153820\n"
 "help.text"
-msgid "MEDIAN"
-msgstr "MEDIANE"
+msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41405,8 +41405,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3154541\n"
 "help.text"
-msgid "MIN"
-msgstr "MIN"
+msgid "<variable id=\"min_head\"><link href=\"text/scalc/01/04060184.xhp#min\">MIN</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41477,8 +41477,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3147504\n"
 "help.text"
-msgid "MINA"
-msgstr "MINA"
+msgid "<variable id=\"mina_head\"><link href=\"text/scalc/01/04060184.xhp#mina\">MINA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41557,8 +41557,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3166465\n"
 "help.text"
-msgid "AVEDEV"
-msgstr "ECART.MOYEN"
+msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41621,8 +41621,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3145824\n"
 "help.text"
-msgid "AVERAGE"
-msgstr "MOYENNE"
+msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41685,8 +41685,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3148754\n"
 "help.text"
-msgid "AVERAGEA"
-msgstr "MOYENNEA"
+msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -56896,6 +56896,78 @@ msgctxt ""
 msgid "not"
 msgstr "non"
 
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id1191767622119\n"
+"help.text"
+msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id961527953004850\n"
+"help.text"
+msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>"
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id94162948227556\n"
+"help.text"
+msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id14734320631377\n"
+"help.text"
+msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id23526994221948\n"
+"help.text"
+msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id190621657742\n"
+"help.text"
+msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id317001803813193\n"
+"help.text"
+msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id191527781733238\n"
+"help.text"
+msgid "The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them."
+msgstr ""
+
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id175721789527973\n"
+"help.text"
+msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)."
+msgstr ""
+
 #: exponsmooth_embd.xhp
 msgctxt ""
 "exponsmooth_embd.xhp\n"
@@ -58184,14 +58256,6 @@ msgctxt ""
 msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145."
 msgstr "Cette fonction recherche quelles cellules de la plage B2:B6 sont inférieures à la valeur spécifiée dans E2 et calcule la moyenne des valeurs correspondantes à partir de la plage C2:C6. Si E2=35, cette fonction renvoie 145."
 
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id171371269326270\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>"
-msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">MOYENNE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">MOYENNEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">GRANDE.VALEUR</link>, <link href=\"text/scalc/01/04060183.xhp#small\">PETITE.VALEUR</link>"
-
 #: func_averageifs.xhp
 msgctxt ""
 "func_averageifs.xhp\n"
@@ -58237,72 +58301,16 @@ msgctxt ""
 "func_averageifs.xhp\n"
 "par_id21050267713178\n"
 "help.text"
-msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])"
-msgstr "MOYENNE.SI.ENS(plage_critère;plage_critère1;critère1[;plage_critère2;critère2[;...]])"
+msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
 
 #: func_averageifs.xhp
 msgctxt ""
 "func_averageifs.xhp\n"
 "par_id165832700711773\n"
 "help.text"
-msgid "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean."
-msgstr "<emph>plage_critère</emph> – argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant les valeurs pour le calcul de la moyenne."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id23557225011065\n"
-"help.text"
-msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion."
-msgstr "<emph>plage_critère1</emph> – argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant les valeurs permettant de trouver le critère correspondant?"
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id115612745015792\n"
-"help.text"
-msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
-msgstr "<emph>critère1</emph> – argument requis. Une condition de la forme d'une expression ou une référence de cellule à une expression qui définit quelles cellules doivent être utilisées pour calculer la moyenne. L'expression peut contenir du texte, des nombres, des expressions régulières (si activées dans les options de calcul) ou des caractères génériques (si activés dans les options de calcul)."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id249477513695\n"
-"help.text"
-msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1."
-msgstr "<emph>plage_critère2</emph> – facultatif. Plage_critère2 et tous les autres ont la même signification que plage_critère1."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id157492744623347\n"
-"help.text"
-msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
-msgstr "<emph>critère2</emph> – facultatif. Critère2 et tous les autres ont la même signification que critère1."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id262061474420658\n"
-"help.text"
-msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it."
-msgstr "La relation logique entre critères peut être définie comme ET logique (conjonction). En d'autres termes, si et seulement si tous les critères donnés correspondent, une valeur de la cellule correspondante de la plage_moyenne donnée est prise dans le calcul de la moyenne.<br/>Le <emph>critère</emph> doit être une expression de chaîne, en particulier, le <emph>critère</emph> doit être entouré de guillemets (\"critère\") à l'exception des noms de fonctions, références de cellules et l'opérateur de concaténation de chaînes (&).<br/>Les opérateurs égal à (=), différent de (<>), supérieur à (>), supérieur ou égal à (>=), inférieur à (<) et inférieur ou égal à (<=) peuvent être utilisés comme arguments de critère pour la comparaison des nombres.<br/>La fonction peut avoir jusqu'à 255 arguments, cela signifie que vous pouvez lui spécifier 127 plages de critères et critères."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id51531273215056\n"
-"help.text"
-msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502."
-msgstr "Si une cellule dans une plage de valeurs pour calculer la moyenne est vide ou contient du texte, la fonction MOYENNE.SI.ENS ignore cette cellule.<br/>Si une cellule contient VRAI, elle est traitée comme 1, si une cellule contient FAUX – comme zéro (0).<br/>Si la plage entière est vide, contient uniquement du texte ou que toutes les valeurs de la plage ne satisfont pas à la condition (ou toutes leurs combinaisons), la fonction renvoie l'erreur #DIV/0!.<br/>Si la plage de valeurs pour calculer la moyenne et toute plage pour trouver le critère une une taille différente, la fonction renvoie err:502."
-
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id151201977228038\n"
-"help.text"
-msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text."
-msgstr "Dans tous les exemples ci-dessous, les plages pour le calcul de la moyenne contient la ligne #6, mais elle est ignorée parce qu'elle contient du texte."
+msgid "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean."
+msgstr ""
 
 #: func_averageifs.xhp
 msgctxt ""
@@ -58416,14 +58424,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Si E2=crayon, la fonction renvoie 65 parce que le lien à la cellule est substitué par son contenu."
 
-#: func_averageifs.xhp
-msgctxt ""
-"func_averageifs.xhp\n"
-"par_id1279148769260\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">MOYENNE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">MOYENNEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_color.xhp
 msgctxt ""
 "func_color.xhp\n"
@@ -58541,8 +58541,8 @@ msgctxt ""
 "func_countifs.xhp\n"
 "par_id462646264626\n"
 "help.text"
-msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>"
-msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Renvoie le nombre de lignes et colonnes qui correspondent aux critères dans des plages multiples.</variable></ahelp>"
+msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
 
 #: func_countifs.xhp
 msgctxt ""
@@ -58571,42 +58571,10 @@ msgstr "<emph>plage_1</emph> - argument requis. C'est une plage de cellules, un
 #: func_countifs.xhp
 msgctxt ""
 "func_countifs.xhp\n"
-"par_id23526994221948\n"
-"help.text"
-msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
-msgstr "<emph>critère_1</emph> - argument requis. Une condition sous la forme d'une expression ou une référence de cellule à une expression qui définit quelles cellules doivent être utilisées pour compter. L'expression peut contenir du texte, des nombres, des expressions régulières (si activées dans les options de calcul) ou des caractères génériques (si activés dans les options de calcul)."
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id190621657742\n"
-"help.text"
-msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1."
-msgstr "<emph>Plage2</emph> – Facultatif. Plage2 et tous les arguments suivants ont la même signification que Plage1."
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id317001803813193\n"
-"help.text"
-msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
-msgstr "<emph>critère2</emph> – facultatif. Critère2 et tous les autres ont la même signification que critère1."
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id14223137501158\n"
-"help.text"
-msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria."
-msgstr "La relation logique entre critères peut être définie comme un ET logique (conjonction). En d'autres termes, si et seulement si tous les critères donnés correspondent, une ligne ou une colonne est prise en compte.<br/>Le <emph>critère</emph> doit être une expression de chaînes, en particulier, le <emph>critère</emph> doit être entouré par des guillemets (\"critère\") à l'exception des noms de fonctions, des références de cellules et de l'opérateur de concaténation de chaîne (&).<br/>Les opérateurs égal à (=), différent de (<>), supérieur à (>), supérieur ou égal à (>=), inféreur à (>), inférieur ou égal à (>=) peuvent être utilisés en arguments de critère pour la comparaison des nombres.<br/> La fonction peut avoir jusqu'à 500 arguments, signifiant que vous pouvez spécifier 250 plages de paires et de critères."
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id16654883224356\n"
+"par_id14734320631377\n"
 "help.text"
-msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502."
-msgstr "Si une cellule contient VRAIE, elle est traitée comme 1, si une cellule contient FAUX - comme 0 (zéro).<br/>Si les plages pour les arguments <emph>plage</emph> et <emph>critère</emph> ont une taille différente, la fonction renvoie err:502."
+msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
+msgstr ""
 
 #: func_countifs.xhp
 msgctxt ""
@@ -58736,14 +58704,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above."
 msgstr "Si E2=crayon, la fonction renvoie 1 parce que le lien à la cellule est substitué par son contenu et cela fonctionne comme une fonction ci-dessus."
 
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id14337286612130\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">NB</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">NB.SI</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">NBVAL</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_date.xhp
 msgctxt ""
 "func_date.xhp\n"
@@ -61544,6 +61504,342 @@ msgctxt ""
 msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04."
 msgstr "=NO.SEMAINE.ISO(DATE(1;1;1999)) renvoie 53. La semaine 1 commence le lundi 04/01/1999."
 
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "MAXIFS function"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"bm_id658066580665806\n"
+"help.text"
+msgid "<bookmark_value>MAXIFS function</bookmark_value>  <bookmark_value>maximum;satisfying conditions</bookmark_value>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id658866588665886\n"
+"help.text"
+msgid "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id659756597565975\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id660246602466024\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id11655988824213\n"
+"help.text"
+msgid "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id59901690530236\n"
+"help.text"
+msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum."
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id193452436229521\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id94321051525036\n"
+"help.text"
+msgid "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id28647227259438\n"
+"help.text"
+msgid "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion."
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id36952767622741\n"
+"help.text"
+msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id189772445525114\n"
+"help.text"
+msgid "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion."
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id30455222431067\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id307691022525348\n"
+"help.text"
+msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id27619246864839\n"
+"help.text"
+msgid "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria."
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id220502883332563\n"
+"help.text"
+msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id15342189586295\n"
+"help.text"
+msgid "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria."
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id8168283329426\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id50762995519951\n"
+"help.text"
+msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id135761606425300\n"
+"help.text"
+msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"par_id30574750215839\n"
+"help.text"
+msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "MINIFS function"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"bm_id658066580665806\n"
+"help.text"
+msgid "<bookmark_value>MINIFS function</bookmark_value>  <bookmark_value>minimum;satisfying conditions</bookmark_value>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id658866588665886\n"
+"help.text"
+msgid "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id659756597565975\n"
+"help.text"
+msgid "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id660246602466024\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id11655988824213\n"
+"help.text"
+msgid "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id59901690530236\n"
+"help.text"
+msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id193452436229521\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id94321051525036\n"
+"help.text"
+msgid "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id28647227259438\n"
+"help.text"
+msgid "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id36952767622741\n"
+"help.text"
+msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id189772445525114\n"
+"help.text"
+msgid "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id30455222431067\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id307691022525348\n"
+"help.text"
+msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id27619246864839\n"
+"help.text"
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id220502883332563\n"
+"help.text"
+msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id15342189586295\n"
+"help.text"
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180."
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id8168283329426\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id50762995519951\n"
+"help.text"
+msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id135761606425300\n"
+"help.text"
+msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>"
+msgstr ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"par_id30574750215839\n"
+"help.text"
+msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content."
+msgstr ""
+
 #: func_minute.xhp
 msgctxt ""
 "func_minute.xhp\n"
@@ -62581,80 +62877,16 @@ msgctxt ""
 "func_sumifs.xhp\n"
 "par_id11655988824213\n"
 "help.text"
-msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])"
-msgstr "SOMME.SI.ENS(plage_somme;critère_plage1;critère1[;critère_plage2;critère2[;...]])"
+msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
 
 #: func_sumifs.xhp
 msgctxt ""
 "func_sumifs.xhp\n"
 "par_id59901690530236\n"
 "help.text"
-msgid "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum."
-msgstr "<emph>plage_somme</emph> - argument requis. C'est une plage de cellules, un nom d'une plage nommée ou une étiquette de colonne ou de ligne contenant des valeurs pour calculer la somme."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id14445505532098\n"
-"help.text"
-msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion."
-msgstr "<emph>critère_plage1</emph> – argument requis. C'est une plage de  cellules, un nom d'une palge nommée ou une étiquette de colonne ou de ligne contenant les valeurs pour rechercher le critères correspondant."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id24470258022447\n"
-"help.text"
-msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
-msgstr "<emph>critère1</emph> – argument requis. Une condition sous la forme d'une expression ou une référence de cellule à une expression qui définit quelles cellules doivent être utilisées pour calculer la somme. L'expression peut contenir du texte, des nombres des expressions régulières (si activées dans les options de calcul) ou des caractères génériques (si activés dans les options de calcul)."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id111151356820933\n"
-"help.text"
-msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1."
-msgstr "<emph>plage_critère2</emph> – facultatif. Plage_critère2 et tous les autres ont la même signification que plage_critère1."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id14734320631376\n"
-"help.text"
-msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
-msgstr "<emph>critère2</emph> – facultatif. Critère2 et tous les autres ont la même signification que critère1."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id14734320631377\n"
-"help.text"
-msgid "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument."
-msgstr "<emph>plage_somme</emph> et <emph>critère_plage1; critère_plage2...</emph> doivent avoir la même taille ou la fonction renvoie err:502 - argument incorrect."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id94162948227556\n"
-"help.text"
-msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them."
-msgstr "La relation logique entre critères peut être définie comme ET logique (conjonction). En d'autres termes, si et seulement si tous les critères donnés correspondent, une valeur de la cellule correspondante de la <emph>plage_somme</emph> donnée est prise dans le calcul de la somme.<br/>Le <emph>critère</emph> doit être une expression de chaîne, en particulier, le <emph>critère</emph> doit être entouré de guillemets (\"critère\") à l'exception des noms de fonctions, références de cellules et l'opérateur de concaténation de chaînes (&).<br/>Les opérateurs égal à (=), différent de (<>), supérieur à (>), supérieur ou égal à (>=), inférieur à (<) et inférieur ou égal à (<=) peuvent être utilisés comme arguments de critère pour la comparaison des nombres.<br/>La fonction peut avoir jusqu'à 255 arguments, cela signifie que vous pouvez lui spécifier 127 plages de critères et critères."
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id175721789527973\n"
-"help.text"
-msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)."
-msgstr "Si une cellule contient VRAI, elle est traitée comme 1, si une cellule contient FAUX - comme 0 (zéro)"
-
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id1191767622119\n"
-"help.text"
-msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text."
-msgstr "Dans tous les exemples ci-dessous, les plages pour le calcul de la somme contient la ligne #6, mais elle est ignorée parce qu'elle contient du texte."
+msgid "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum."
+msgstr ""
 
 #: func_sumifs.xhp
 msgctxt ""
@@ -62768,14 +63000,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Si E2=crayon, la fonction renvoie 65 parce que le lien à la cellule est substitué par son contenu."
 
-#: func_sumifs.xhp
-msgctxt ""
-"func_sumifs.xhp\n"
-"par_id11921178730928\n"
-"help.text"
-msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SOMME</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SOMME.SI</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_time.xhp
 msgctxt ""
 "func_time.xhp\n"
diff --git a/source/fr/helpcontent2/source/text/scalc/06.po b/source/fr/helpcontent2/source/text/scalc/06.po
index 0637feb6288..ebb66a76a1e 100644
--- a/source/fr/helpcontent2/source/text/scalc/06.po
+++ b/source/fr/helpcontent2/source/text/scalc/06.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-08 15:11+0200\n"
+"POT-Creation-Date: 2018-06-14 17:23+0200\n"
 "PO-Revision-Date: 2018-05-25 12:44+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1527252252.000000\n"
 
 #: calcsamplefiles.xhp
@@ -47,3 +47,11 @@ msgctxt ""
 "help.text"
 msgid "<object data=\"media/files/scalc/pivot.ods\" id=\"ods_id61521547603544\" type=\"application/vnd.oasis.opendocument.spreadsheet\"/>"
 msgstr "<object data=\"media/files/scalc/pivot.ods\" id=\"ods_id61521547603544\" type=\"application/vnd.oasis.opendocument.spreadsheet\"/>"
+
+#: calcsamplefiles.xhp
+msgctxt ""
+"calcsamplefiles.xhp\n"
+"par_id721528312694192\n"
+"help.text"
+msgid "<object data=\"media/files/scalc/functions_ifs.ods\" id=\"ods_id61521547603534\" type=\"application/vnd.oasis.opendocument.spreadsheet\"/>"
+msgstr ""
diff --git a/source/fr/helpcontent2/source/text/shared/00.po b/source/fr/helpcontent2/source/text/shared/00.po
index 13968383eb8..7421683f51d 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: 2018-06-04 15:42+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-06-06 14:34+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1528295668.000000\n"
 
@@ -9668,6 +9668,14 @@ msgstr "Choisissez <emph>Affichage - Styles</emph> - ouvrez le menu contextuel d
 #: 00040500.xhp
 msgctxt ""
 "00040500.xhp\n"
+"par_id981529886125676\n"
+"help.text"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><embedvar href=\"text/swriter/00/stylesmenu.xhp#sms\" markup=\"keep\"/></caseinline><defaultinline/></switchinline>"
+msgstr ""
+
+#: 00040500.xhp
+msgctxt ""
+"00040500.xhp\n"
 "par_id3147404\n"
 "help.text"
 msgid "Choose <emph>View - Styles</emph>"
diff --git a/source/fr/helpcontent2/source/text/shared/01.po b/source/fr/helpcontent2/source/text/shared/01.po
index 4d2c7e094c9..cbcde5e60d4 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: 2018-06-04 15:42+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-06-06 14:41+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1528296069.000000\n"
 
@@ -7478,8 +7478,8 @@ msgctxt ""
 "02100001.xhp\n"
 "par_id3147397\n"
 "help.text"
-msgid "Represents an alphabetic character. Use [:alpha:]+ to find one of them."
-msgstr "Correspond à un caractère de l'alphabet. Utilisez [:aplha:]+ pour trouver l'un d'eux."
+msgid "Represents an alphabetic character. Use [:alpha:]+ to find one or more of them."
+msgstr ""
 
 #: 02100001.xhp
 msgctxt ""
@@ -7494,8 +7494,8 @@ msgctxt ""
 "02100001.xhp\n"
 "par_id3150010\n"
 "help.text"
-msgid "Represents a decimal digit. Use [:digit:]+ to find one of them."
-msgstr "Correspond à un chiffre décimal. Utilisez [:digit:]+ pour trouver l'un d'eux."
+msgid "Represents a decimal digit. Use [:digit:]+ to find one or more of them."
+msgstr ""
 
 #: 02100001.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/shared/optionen.po b/source/fr/helpcontent2/source/text/shared/optionen.po
index a9f1ff72919..eb23cfa5c17 100644
--- a/source/fr/helpcontent2/source/text/shared/optionen.po
+++ b/source/fr/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-06-04 15:42+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-06-06 14:44+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1528296264.000000\n"
 
@@ -9134,8 +9134,8 @@ msgctxt ""
 "01060500.xhp\n"
 "par_id3154319\n"
 "help.text"
-msgid "=B6*0,15"
-msgstr "=B6*0,206"
+msgid "=B6*0.15"
+msgstr ""
 
 #: 01060500.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/swriter.po b/source/fr/helpcontent2/source/text/swriter.po
index f415b801978..3a607bf9a2f 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: 2018-04-05 11:28+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-04-05 17:11+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1522948274.000000\n"
 
@@ -1566,24 +1566,200 @@ msgctxt ""
 "main0115.xhp\n"
 "par_idN10563\n"
 "help.text"
-msgid "<ahelp hid=\".\">Contains commands to set, create, edit, update, load, and manage styles in a text document.</ahelp>"
-msgstr "<ahelp hid=\".\">Contient des commandes pour assigner, créer, éditer, mettre à jour, importer et gérer les styles d'un document texte.</ahelp>"
+msgid "<ahelp hid=\".\">Contains commands to apply, create, edit, update, load, and manage <link href=\"text/swriter/01/05130000.xhp\" name=\"styles\">styles</link> in a text document.</ahelp>"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"hd_id121529878513674\n"
+"help.text"
+msgid "Text styles entries"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id411529878520742\n"
+"help.text"
+msgid "The entries includes most common paragraph, character and list styles. Click on the style to apply."
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id451529878529005\n"
+"help.text"
+msgid "You can customize the list of styles entries using menu <link href=\"text/shared/01/06140100.xhp\" name=\"customize menu\"><emph>Tools - Customize</emph></link>. Because custom styles belongs to the actual document, remember to store the customized menu in the document scope."
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"hd_id991529881414793\n"
+"help.text"
+msgid "Edit Style"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id111529881420452\n"
+"help.text"
+msgid "Opens the Paragraph Style dialog box of the current paragraph."
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"hd_id111529881431158\n"
+"help.text"
+msgid "Update Style"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id971529881437377\n"
+"help.text"
+msgid "Update the paragraph style with the <link href=\"text/shared/00/00000005.xhp#Section7\" name=\"direct formatting\">direct formatting</link> applied to the current paragraph."
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"hd_id191529881446409\n"
+"help.text"
+msgid "New style"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id331529881457275\n"
+"help.text"
+msgid "Adds a paragraph style with the settings of the current selection. You will be prompted to enter the style name."
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"hd_id351529881470044\n"
+"help.text"
+msgid "Load Styles"
+msgstr ""
 
 #: main0115.xhp
 msgctxt ""
 "main0115.xhp\n"
-"hd_id0903201507192919\n"
+"par_id551529883682302\n"
 "help.text"
-msgid "Default"
-msgstr "Par défaut"
+msgid "<link href=\"text/swriter/guide/load_styles.xhp\" name=\"import style\">Import styles</link> from another document or template into the current document."
+msgstr ""
 
 #: main0115.xhp
 msgctxt ""
 "main0115.xhp\n"
-"par_id090320150719290\n"
+"hd_id361529881482828\n"
 "help.text"
-msgid "Set the current paragraph or selected paragraphs to the default style."
-msgstr "Assigne le style par défaut au paragraphe actuel ou aux paragraphes sélectionnés."
+msgid "Manage Styles"
+msgstr ""
+
+#: main0115.xhp
+msgctxt ""
+"main0115.xhp\n"
+"par_id901529883673111\n"
+"help.text"
+msgid "Opens the <link href=\"text/swriter/01/05140000.xhp\" name=\"linkname\">Styles deck</link> in the sidebar."
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"tit\n"
+"help.text"
+msgid "Form Menu"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"hd_id111529755027117\n"
+"help.text"
+msgid "<link href=\"text/swriter/main0120.xhp\" name=\"Form menu\">Form</link>"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"par_id991529755027118\n"
+"help.text"
+msgid "<variable id=\"variable name\"><ahelp hid=\"hid path or command\">Contains commands for activate form design mode, open control wizards and insert form controls in your text document.</ahelp></variable>"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"hd_id551529758534136\n"
+"help.text"
+msgid "Design Mode"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"par_id791529758540932\n"
+"help.text"
+msgid "Enable or disable form design mode."
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"hd_id121529758546072\n"
+"help.text"
+msgid "Control Wizards"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"par_id271529758552229\n"
+"help.text"
+msgid "Enable or disable control wizards."
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"hd_id571529784049416\n"
+"help.text"
+msgid "More fields"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"par_id951529784060420\n"
+"help.text"
+msgid "Date, time, numerical, currency and pattern form fields."
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"hd_id811529763403256\n"
+"help.text"
+msgid "Automatic Control Focus"
+msgstr ""
+
+#: main0120.xhp
+msgctxt ""
+"main0120.xhp\n"
+"par_id281529763411414\n"
+"help.text"
+msgid "Enable or disable Automatic Control Focus"
+msgstr ""
 
 #: main0200.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/swriter/00.po b/source/fr/helpcontent2/source/text/swriter/00.po
index e2e01b9bdba..21dc736ee51 100644
--- a/source/fr/helpcontent2/source/text/swriter/00.po
+++ b/source/fr/helpcontent2/source/text/swriter/00.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-22 13:17+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-05-24 15:12+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1527174735.000000\n"
 
@@ -2448,3 +2448,51 @@ msgctxt ""
 "help.text"
 msgid "Mail Merge"
 msgstr "Mailing"
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"tit\n"
+"help.text"
+msgid "The styles menu"
+msgstr ""
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"par_id941529884998705\n"
+"help.text"
+msgid "<variable id=\"ses\">Choose <emph>Styles - Edit Styles</emph></variable>."
+msgstr ""
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"par_id511529885005747\n"
+"help.text"
+msgid "<variable id=\"sus\">Choose <emph>Styles - Update Style</emph> or <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+ Shift + F11</emph></variable>."
+msgstr ""
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"par_id411529885010612\n"
+"help.text"
+msgid "<variable id=\"sns\">Choose <emph>Styles - New Style</emph> or <emph>Shift + F11</emph></variable>."
+msgstr ""
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"par_id221529885015598\n"
+"help.text"
+msgid "<variable id=\"sls\">Choose <emph>Styles - Load Styles</emph></variable>."
+msgstr ""
+
+#: stylesmenu.xhp
+msgctxt ""
+"stylesmenu.xhp\n"
+"par_id391529885020996\n"
+"help.text"
+msgid "<variable id=\"sms\">Choose <emph>Styles - Manage Styles</emph> or F11</variable>."
+msgstr ""
diff --git a/source/fr/helpcontent2/source/text/swriter/04.po b/source/fr/helpcontent2/source/text/swriter/04.po
index bb7c49cc15c..0dcc326f7ea 100644
--- a/source/fr/helpcontent2/source/text/swriter/04.po
+++ b/source/fr/helpcontent2/source/text/swriter/04.po
@@ -4,7 +4,7 @@ msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
 "POT-Creation-Date: 2018-04-05 11:28+0200\n"
-"PO-Revision-Date: 2017-11-14 16:17+0000\n"
+"PO-Revision-Date: 2018-06-16 16:27+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: fr\n"
@@ -13,8 +13,8 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
-"X-POOTLE-MTIME: 1510676226.000000\n"
+"X-Generator: Pootle 2.8\n"
+"X-POOTLE-MTIME: 1529166455.000000\n"
 
 #: 01020000.xhp
 msgctxt ""
@@ -1910,7 +1910,7 @@ msgctxt ""
 "par_id8539384\n"
 "help.text"
 msgid "If no whole cell is selected and the cursor is at the end of the table, the paragraph following the table will be deleted, unless it is the last paragraph in the document."
-msgstr "Si aucune cellule complète n'est sélectionnée et que le curseur est à la fin du tableau, le paragraphe suivant le tableau est supprimé, à moins que ce ne soit le dernier paragraphe du document."
+msgstr "Si une partie de la cellule est sélectionnée et que le curseur est à la fin du tableau, le paragraphe suivant le tableau est supprimé, à moins que ce ne soit le dernier paragraphe du document."
 
 #: 01020000.xhp
 msgctxt ""
diff --git a/source/fr/helpcontent2/source/text/swriter/guide.po b/source/fr/helpcontent2/source/text/swriter/guide.po
index cc886973413..5b5cd9ef4b9 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: 2018-05-08 15:11+0200\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
 "PO-Revision-Date: 2018-05-14 15:26+0000\n"
 "Last-Translator: sophie <gautier.sophie@gmail.com>\n"
 "Language-Team: ll.org\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n > 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
+"X-Generator: LibreOffice\n"
 "X-Project-Style: openoffice\n"
 "X-POOTLE-MTIME: 1526311583.000000\n"
 
@@ -8732,26 +8732,34 @@ msgstr "Vous pouvez importer des styles dans le document ouvert à partir d'un a
 #: load_styles.xhp
 msgctxt ""
 "load_styles.xhp\n"
+"par_id731529889382463\n"
+"help.text"
+msgid "Open the <emph>Load Styles</emph> dialog box by either"
+msgstr ""
+
+#: load_styles.xhp
+msgctxt ""
+"load_styles.xhp\n"
 "par_id3155910\n"
 "help.text"
-msgid "Choose <emph>View - Styles</emph> to open the <emph>Styles</emph> sidebar deck."
-msgstr "Pour ouvrir le panneau <emph>Styles</emph> du volet latéral, choisissez <emph>Affichage - Styles</emph>."
+msgid "Choose <emph>View - Styles</emph> or"
+msgstr ""
 
 #: load_styles.xhp
 msgctxt ""
 "load_styles.xhp\n"
-"par_idN10703\n"
+"par_id441529889103330\n"
 "help.text"
-msgid "Click the arrow next to the <emph>New Style from Selection</emph> icon to open the submenu."
-msgstr "Pour ouvrir le sous-menu, cliquez sur la flèche située en regard de l'icône <emph>Nouveau style à partir de la sélection</emph>."
+msgid "<embedvar href=\"text/swriter/00/stylesmenu.xhp#sms\" markup=\"keep\"/> to open the <emph>Styles</emph> sidebar deck."
+msgstr ""
 
 #: load_styles.xhp
 msgctxt ""
 "load_styles.xhp\n"
-"par_idN1070B\n"
+"par_idN10703\n"
 "help.text"
-msgid "Choose <emph>Load styles</emph>."
-msgstr "Choisissez <emph>Charger les styles</emph>."
+msgid "Click the arrow next to the <emph>New Style from Selection</emph> icon to open the submenu."
+msgstr "Pour ouvrir le sous-menu, cliquez sur la flèche située en regard de l'icône <emph>Nouveau style à partir de la sélection</emph>."
 
 #: load_styles.xhp
 msgctxt ""