summaryrefslogtreecommitdiff
path: root/source/ca/helpcontent2/source/text
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-07-03 13:37:55 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2018-07-03 13:57:36 +0200
commited578ffce83e204db7ea027489e00e6ceed21d3b (patch)
tree73fafeca743505cf1fc678970579f326246249b5 /source/ca/helpcontent2/source/text
parent2aa8e04733181b9e3c3cceb5ecb8fecee1106b24 (diff)
update translations for 6.1.0 rc1
Change-Id: Ibff5b92a1b44ed2546d3ad25312e272ada2fa350
Diffstat (limited to 'source/ca/helpcontent2/source/text')
-rw-r--r--source/ca/helpcontent2/source/text/sbasic/guide.po14
-rw-r--r--source/ca/helpcontent2/source/text/sbasic/shared.po90
-rw-r--r--source/ca/helpcontent2/source/text/sbasic/shared/03.po510
-rw-r--r--source/ca/helpcontent2/source/text/scalc/01.po688
-rw-r--r--source/ca/helpcontent2/source/text/scalc/06.po12
-rw-r--r--source/ca/helpcontent2/source/text/schart/01.po10
-rw-r--r--source/ca/helpcontent2/source/text/sdraw/00.po12
-rw-r--r--source/ca/helpcontent2/source/text/shared/00.po46
-rw-r--r--source/ca/helpcontent2/source/text/shared/01.po70
-rw-r--r--source/ca/helpcontent2/source/text/shared/04.po6
-rw-r--r--source/ca/helpcontent2/source/text/shared/optionen.po26
-rw-r--r--source/ca/helpcontent2/source/text/swriter.po204
-rw-r--r--source/ca/helpcontent2/source/text/swriter/00.po70
-rw-r--r--source/ca/helpcontent2/source/text/swriter/01.po14
-rw-r--r--source/ca/helpcontent2/source/text/swriter/guide.po26
15 files changed, 1406 insertions, 392 deletions
diff --git a/source/ca/helpcontent2/source/text/sbasic/guide.po b/source/ca/helpcontent2/source/text/sbasic/guide.po
index b0780004d49..bff609fa60f 100644
--- a/source/ca/helpcontent2/source/text/sbasic/guide.po
+++ b/source/ca/helpcontent2/source/text/sbasic/guide.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-25 13:24+0200\n"
-"PO-Revision-Date: 2018-06-12 08:09+0000\n"
+"PO-Revision-Date: 2018-06-19 11:53+0000\n"
"Last-Translator: AssumptaAn <assumptaanglada@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1528790947.000000\n"
+"X-POOTLE-MTIME: 1529409186.000000\n"
#: access2base.xhp
msgctxt ""
@@ -79,7 +79,7 @@ msgctxt ""
"par_idA2B007\n"
"help.text"
msgid "<emph>The library is documented online on </emph><link href=\"http://www.access2base.com\" name=\"http://www.access2base.com\"><emph>http://www.access2base.com</emph></link>."
-msgstr ""
+msgstr "<emph>La biblioteca està documentada al web </emph><link href=\"http://www.access2base.com\" name=\"http://www.access2base.com\"><emph>http://www.access2base.com</emph></link>"
#: access2base.xhp
msgctxt ""
@@ -95,7 +95,7 @@ msgctxt ""
"par_idA2B009\n"
"help.text"
msgid "a simplified and extensible API for <emph>forms</emph>, <emph>dialogs</emph> and <emph>controls</emph> manipulations similar with the Microsoft Access object model,"
-msgstr ""
+msgstr "una API simplificada i extensible per a la manipulació de <emph>formularis</emph>, <emph>diàlegs</emph> i <emph>controls</emph> similar al model d'objectes del Microsoft Access"
#: access2base.xhp
msgctxt ""
@@ -103,7 +103,7 @@ msgctxt ""
"par_idA2B010\n"
"help.text"
msgid "an API for database access with the <emph>table</emph>, <emph>query</emph>, <emph>recordset</emph> and <emph>field</emph> objects,"
-msgstr ""
+msgstr "una API per a l'accés a bases de dades amb <emph>taules</emph>, <emph>consultes</emph>, <emph>conjunts de registres</emph> i <emph>objectes</emph> de camp,"
#: access2base.xhp
msgctxt ""
@@ -111,7 +111,7 @@ msgctxt ""
"par_idA2B011\n"
"help.text"
msgid "a number of <emph>actions</emph> with a syntax identical to their corresponding Microsoft Access macros/actions,"
-msgstr ""
+msgstr "un nombre d'<emph>accions</emph>amb una sintaxi idèntica a les macros i accions del Microsoft Access corresponents"
#: access2base.xhp
msgctxt ""
@@ -119,7 +119,7 @@ msgctxt ""
"par_idA2B012\n"
"help.text"
msgid "the <emph>DLookup</emph>, <emph>DSum</emph>, ... database functions,"
-msgstr ""
+msgstr "les funcions de base de dades <emph>DLookup</emph>, <emph>DSum</emph>, ..."
#: access2base.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/sbasic/shared.po b/source/ca/helpcontent2/source/text/sbasic/shared.po
index 848364f4596..61c9ee5db57 100644
--- a/source/ca/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ca/helpcontent2/source/text/sbasic/shared.po
@@ -3,8 +3,8 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-16 16:54+0200\n"
-"PO-Revision-Date: 2018-05-23 11:11+0000\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-06-22 06:50+0000\n"
"Last-Translator: Joan Montané <joan@montane.cat>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
@@ -13,9 +13,9 @@ 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-Language: ca\n"
-"X-POOTLE-MTIME: 1527073910.000000\n"
+"X-POOTLE-MTIME: 1529650250.000000\n"
#: 00000002.xhp
msgctxt ""
@@ -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."
@@ -7847,7 +7863,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "QBColor Function"
-msgstr ""
+msgstr "Funció QBColor"
#: 03010304.xhp
msgctxt ""
@@ -7855,7 +7871,7 @@ msgctxt ""
"hd_id3149670\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03010304.xhp\" name=\"QBColor Function\">QBColor Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03010304.xhp\" name=\"QBColor Function\">Funció QBColor</link>"
#: 03010304.xhp
msgctxt ""
@@ -10383,7 +10399,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "FileAttr Function"
-msgstr ""
+msgstr "Funció FileAttr"
#: 03020405.xhp
msgctxt ""
@@ -10399,7 +10415,7 @@ msgctxt ""
"hd_id3153380\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03020405.xhp\" name=\"FileAttr Function\">FileAttr Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03020405.xhp\" name=\"FileAttr Function\">Funció FileAttr</link>"
#: 03020405.xhp
msgctxt ""
@@ -11791,7 +11807,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "DateSerial Function"
-msgstr ""
+msgstr "Funció DateSerial"
#: 03030101.xhp
msgctxt ""
@@ -11807,7 +11823,7 @@ msgctxt ""
"hd_id3157896\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030101.xhp\" name=\"DateSerial Function\">DateSerial Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030101.xhp\" name=\"DateSerial Function\">Funció DateSerial</link>"
#: 03030101.xhp
msgctxt ""
@@ -11943,7 +11959,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "DateValue Function"
-msgstr ""
+msgstr "Funció DateValue"
#: 03030102.xhp
msgctxt ""
@@ -11959,7 +11975,7 @@ msgctxt ""
"hd_id3156344\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030102.xhp\" name=\"DateValue Function\">DateValue Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030102.xhp\" name=\"DateValue Function\">Funció DateValue</link>"
#: 03030102.xhp
msgctxt ""
@@ -12031,7 +12047,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "Day Function"
-msgstr ""
+msgstr "Funció Day"
#: 03030103.xhp
msgctxt ""
@@ -12047,7 +12063,7 @@ msgctxt ""
"hd_id3153345\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030103.xhp\" name=\"Day Function\">Day Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030103.xhp\" name=\"Day Function\">Funció Day</link>"
#: 03030103.xhp
msgctxt ""
@@ -12143,7 +12159,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "Month Function"
-msgstr ""
+msgstr "Funció Month"
#: 03030104.xhp
msgctxt ""
@@ -12159,7 +12175,7 @@ msgctxt ""
"hd_id3153127\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030104.xhp\" name=\"Month Function\">Month Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030104.xhp\" name=\"Month Function\">Funció Month</link>"
#: 03030104.xhp
msgctxt ""
@@ -12255,7 +12271,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "WeekDay Function"
-msgstr ""
+msgstr "Funció WeekDay"
#: 03030105.xhp
msgctxt ""
@@ -12271,7 +12287,7 @@ msgctxt ""
"hd_id3153127\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030105.xhp\" name=\"WeekDay Function\">WeekDay Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030105.xhp\" name=\"WeekDay Function\">Funció WeekDay</link>"
#: 03030105.xhp
msgctxt ""
@@ -12423,7 +12439,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "Year Function"
-msgstr ""
+msgstr "Funció Year"
#: 03030106.xhp
msgctxt ""
@@ -12439,7 +12455,7 @@ msgctxt ""
"hd_id3148664\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030106.xhp\" name=\"Year Function\">Year Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030106.xhp\" name=\"Year Function\">Funció Year</link>"
#: 03030106.xhp
msgctxt ""
@@ -12535,7 +12551,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "CDateToIso Function"
-msgstr ""
+msgstr "Funció CDateTolso"
#: 03030107.xhp
msgctxt ""
@@ -12551,7 +12567,7 @@ msgctxt ""
"hd_id3150620\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030107.xhp\" name=\"CDateToIso Function\">CDateToIso Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030107.xhp\" name=\"CDateToIso Function\">Funció CDateToIso</link>"
#: 03030107.xhp
msgctxt ""
@@ -12575,7 +12591,7 @@ msgctxt ""
"par_id3151099\n"
"help.text"
msgid "Years less than 100 and greater than 9999 are supported since %PRODUCTNAME 5.4."
-msgstr ""
+msgstr "Es permet l'ús d'anys inferiors a 100 i superiors a 9999 des del %PRODUCTNAME 5.4"
#: 03030107.xhp
msgctxt ""
@@ -12647,7 +12663,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "CDateFromIso Function"
-msgstr ""
+msgstr "Funció CDateFromIso"
#: 03030108.xhp
msgctxt ""
@@ -12663,7 +12679,7 @@ msgctxt ""
"hd_id3153127\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030108.xhp\" name=\"CDateFromIso Function\">CDateFromIso Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030108.xhp\" name=\"CDateFromIso Function\">Funció CDateFromIso</link>"
#: 03030108.xhp
msgctxt ""
@@ -12695,7 +12711,7 @@ msgctxt ""
"par_id3148553\n"
"help.text"
msgid "When converting a date serial number to a printable string, for example for the Print or MsgBox command, the locale's default calendar is used and at that 1582-10-15 cutover date may switch to the Julian calendar, which can result in a different date being displayed than expected. Use the <link href=\"text/sbasic/shared/03030107.xhp\" name=\"CDateToIso Function\">CDateToIso Function</link> to convert such date number to a string representation in the proleptic Gregorian calendar."
-msgstr ""
+msgstr "Quan es converteix un número de sèrie d'una data en una cadena imprimible, per exemple per a l'ordre Impressió o MsgBox, es fa servir el calendari per defecte de la configuració local i a la data de transició del 1582-10-15 por canviar al calendari julià, la qual cosa pot fer que es mostri una data diferent de l'esperada. Feu servir la <link href=\"text/sbasic/shared/03030107.xhp\" name=\"CDateToIso Function\">Funció CDateToIso</link> per convertir el número d'aquesta data en una representació de cadena del calendari gregorià prolèptic."
#: 03030108.xhp
msgctxt ""
@@ -12767,7 +12783,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "DateAdd Function"
-msgstr ""
+msgstr "Funció DateAdd"
#: 03030110.xhp
msgctxt ""
@@ -12783,7 +12799,7 @@ msgctxt ""
"par_idN10548\n"
"help.text"
msgid "<link href=\"text/sbasic/shared/03030110.xhp\">DateAdd Function</link>"
-msgstr ""
+msgstr "<link href=\"text/sbasic/shared/03030110.xhp\">Funció DateAdd</link>"
#: 03030110.xhp
msgctxt ""
@@ -12839,7 +12855,7 @@ msgctxt ""
"par_idN10629\n"
"help.text"
msgid "<emph>Add</emph> - A string expression from the following table, specifying the date interval."
-msgstr ""
+msgstr "<emph>Add</emph> - Una expressió de cadena de la taula següent, que especifica l'interval de dates."
#: 03030110.xhp
msgctxt ""
@@ -35612,6 +35628,22 @@ msgstr ""
#: 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/ca/helpcontent2/source/text/sbasic/shared/03.po b/source/ca/helpcontent2/source/text/sbasic/shared/03.po
new file mode 100644
index 00000000000..61aa84495bd
--- /dev/null
+++ b/source/ca/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/ca/helpcontent2/source/text/scalc/01.po b/source/ca/helpcontent2/source/text/scalc/01.po
index 7a414663194..3c19f9563ba 100644
--- a/source/ca/helpcontent2/source/text/scalc/01.po
+++ b/source/ca/helpcontent2/source/text/scalc/01.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-08 15:11+0200\n"
-"PO-Revision-Date: 2018-06-12 08:08+0000\n"
-"Last-Translator: AssumptaAn <assumptaanglada@gmail.com>\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-07-02 06:35+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1528790894.000000\n"
+"X-POOTLE-MTIME: 1530513302.000000\n"
#: 01120000.xhp
msgctxt ""
@@ -14646,8 +14646,8 @@ msgctxt ""
"04060106.xhp\n"
"hd_id3163596\n"
"help.text"
-msgid "SUM"
-msgstr "SUMA"
+msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -14774,8 +14774,8 @@ msgctxt ""
"04060106.xhp\n"
"hd_id3151957\n"
"help.text"
-msgid "SUMIF"
-msgstr "SUMASI"
+msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>"
+msgstr ""
#: 04060106.xhp
msgctxt ""
@@ -19732,14 +19732,6 @@ msgstr "<item type=\"input\">=ADREÇA(1;1;2;\"Full2\")</item> retorna: Full2.A$1
#: 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 cel·la A1 del full 2 conté el valor <item type=\"input\">-6</item>, podeu fer referència indirectament a la cel·la referenciada si introduïu la funció <item type=\"input\">=ABS(INDIRECTE(B2)) a B2</item>. El resultat és el valor absolut de la referència de cel·la indicada a B2, que en aquest cas és 6."
-
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
"bm_id3150372\n"
"help.text"
msgid "<bookmark_value>AREAS function</bookmark_value>"
@@ -20276,6 +20268,14 @@ msgstr "<item type=\"input\">=SUMA(INDIRECTE(\"a1:\" & ADREÇA(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 cel·la A1 del full 2 conté el valor <item type=\"input\">-6</item>, podeu fer referència indirectament a la cel·la referenciada si introduïu la funció <item type=\"input\">=ABS(INDIRECTE(B2)) a B2</item>. El resultat és el valor absolut de la referència de cel·la indicada a B2, que en aquest cas és 6."
+
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
"bm_id3154818\n"
"help.text"
msgid "<bookmark_value>COLUMN function</bookmark_value>"
@@ -35550,8 +35550,8 @@ msgctxt ""
"04060181.xhp\n"
"hd_id3148437\n"
"help.text"
-msgid "COUNT"
-msgstr "COMPTA"
+msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>"
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -35622,8 +35622,8 @@ msgctxt ""
"04060181.xhp\n"
"hd_id3149729\n"
"help.text"
-msgid "COUNTA"
-msgstr "COMPTAA"
+msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>"
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -35694,8 +35694,8 @@ msgctxt ""
"04060181.xhp\n"
"hd_id3150896\n"
"help.text"
-msgid "COUNTBLANK"
-msgstr "COMPTABUIDES"
+msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>"
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -35758,8 +35758,8 @@ msgctxt ""
"04060181.xhp\n"
"hd_id3164897\n"
"help.text"
-msgid "COUNTIF"
-msgstr "COMPTASI"
+msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>"
+msgstr ""
#: 04060181.xhp
msgctxt ""
@@ -41174,8 +41174,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 ""
@@ -41254,8 +41254,8 @@ msgctxt ""
"04060184.xhp\n"
"hd_id3166426\n"
"help.text"
-msgid "MAXA"
-msgstr "MAXA"
+msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>"
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41334,8 +41334,8 @@ msgctxt ""
"04060184.xhp\n"
"hd_id3153820\n"
"help.text"
-msgid "MEDIAN"
-msgstr "MEDIANA"
+msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>"
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41406,8 +41406,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 ""
@@ -41478,8 +41478,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 ""
@@ -41558,8 +41558,8 @@ msgctxt ""
"04060184.xhp\n"
"hd_id3166465\n"
"help.text"
-msgid "AVEDEV"
-msgstr "DESVMITJ"
+msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>"
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41622,8 +41622,8 @@ msgctxt ""
"04060184.xhp\n"
"hd_id3145824\n"
"help.text"
-msgid "AVERAGE"
-msgstr "MITJANA"
+msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>"
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -41686,8 +41686,8 @@ msgctxt ""
"04060184.xhp\n"
"hd_id3148754\n"
"help.text"
-msgid "AVERAGEA"
-msgstr "MITJANAA"
+msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>"
+msgstr ""
#: 04060184.xhp
msgctxt ""
@@ -56367,7 +56367,7 @@ msgctxt ""
"hd_id1000010\n"
"help.text"
msgid "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)"
-msgstr ""
+msgstr "Aquesta funció forma part de l'estàndard Open Document Format for Office Applications (OpenDocument), versió 1.2 (ISO/IEC 26300:2-2015)."
#: common_func_workdaysintl.xhp
msgctxt ""
@@ -56897,6 +56897,78 @@ msgctxt ""
msgid "not"
msgstr "no"
+#: 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"
@@ -58185,14 +58257,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 ""
-#: 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 ""
-
#: func_averageifs.xhp
msgctxt ""
"func_averageifs.xhp\n"
@@ -58238,7 +58302,7 @@ msgctxt ""
"func_averageifs.xhp\n"
"par_id21050267713178\n"
"help.text"
-msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])"
+msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
msgstr ""
#: func_averageifs.xhp
@@ -58246,63 +58310,7 @@ 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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."
+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
@@ -58417,14 +58425,6 @@ msgctxt ""
msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
msgstr "Si E2 = llapis, la funció retorna 65, perquè l'enllaç a la cel·la se substitueix amb el seu contingut."
-#: 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 ""
-
#: func_color.xhp
msgctxt ""
"func_color.xhp\n"
@@ -58542,7 +58542,7 @@ 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>"
+msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>"
msgstr ""
#: func_countifs.xhp
@@ -58572,46 +58572,14 @@ msgstr ""
#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
-"par_id14223137501158\n"
+"par_id14734320631377\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."
+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 ""
"func_countifs.xhp\n"
-"par_id16654883224356\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 una cel·la conté CERT, es tracta com a 1, si una cel·la conté FALS – com a 0 (zero).<br/>Si els intervals dels arguments <emph>Interval</emph> tenen mides desiguals, la funció retorna err:502."
-
-#: func_countifs.xhp
-msgctxt ""
-"func_countifs.xhp\n"
"hd_id3861259759512\n"
"help.text"
msgid "Simple usage"
@@ -58737,14 +58705,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 = llapis, la funció retorna 1, perquè l'enllaç a la cel·la se substitueix amb el seu contingut i funciona com a funció a dalt."
-#: 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\">COMPTA</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COMPTASI</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COMPTAA</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"
@@ -61545,6 +61505,342 @@ msgctxt ""
msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04."
msgstr "=NUMSETMANA(DATA(1999;1;1);21) retorna 53. Si la setmana 1 comença el dilluns,1999-01-04."
+#: 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"
@@ -62582,7 +62878,7 @@ msgctxt ""
"func_sumifs.xhp\n"
"par_id11655988824213\n"
"help.text"
-msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])"
+msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
msgstr ""
#: func_sumifs.xhp
@@ -62590,71 +62886,7 @@ 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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 ""
-
-#: 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."
+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
@@ -62769,14 +63001,6 @@ msgctxt ""
msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
msgstr "Si E2 = llapis, la funció retorna 65, perquè l'enllaç a la cel·la se substitueix amb el seu contingut."
-#: 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 ""
-
#: func_time.xhp
msgctxt ""
"func_time.xhp\n"
diff --git a/source/ca/helpcontent2/source/text/scalc/06.po b/source/ca/helpcontent2/source/text/scalc/06.po
index e6fc2b4e591..12fd17cf148 100644
--- a/source/ca/helpcontent2/source/text/scalc/06.po
+++ b/source/ca/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-18 09:09+0000\n"
"Last-Translator: Joan Montané <joan@montane.cat>\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: 1526634579.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/ca/helpcontent2/source/text/schart/01.po b/source/ca/helpcontent2/source/text/schart/01.po
index 4b3ac306104..6562b191f84 100644
--- a/source/ca/helpcontent2/source/text/schart/01.po
+++ b/source/ca/helpcontent2/source/text/schart/01.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-02-27 13:56+0100\n"
-"PO-Revision-Date: 2018-05-28 12:18+0000\n"
+"PO-Revision-Date: 2018-06-22 06:43+0000\n"
"Last-Translator: Joan Montané <joan@montane.cat>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1527509914.000000\n"
+"X-POOTLE-MTIME: 1529649804.000000\n"
#: 03010000.xhp
msgctxt ""
@@ -1679,7 +1679,7 @@ msgctxt ""
"par_id394299\n"
"help.text"
msgid "The <emph>logarithmic regression</emph> follows the equation <item type=\"literal\">y=a*ln(x)+b</item>."
-msgstr ""
+msgstr "La <emph>regressió logarítmica</emph> segueix l'equació <item type=\"literal\">y=a*ln(x)+b</item>."
#: 04050100.xhp
msgctxt ""
@@ -1727,7 +1727,7 @@ msgctxt ""
"par_id9112216\n"
"help.text"
msgid "The exponential regression follows the equation <item type=\"literal\">y=b*exp(a*x)</item> or <item type=\"literal\">y=b*m</item><sup><item type=\"literal\">x</item></sup>, which is transformed to <item type=\"literal\">ln(y)=ln(b)+a*x</item> or <item type=\"literal\">ln(y)=ln(b)+ln(m)*x</item> respectively."
-msgstr ""
+msgstr "La regressió exponencial segueix les equacions <item type=\"literal\">y=b*exp(a*x)</item> o <item type=\"literal\">y=b*m</item><sup><item type=\"literal\">x</item></sup>, que es transformen en <item type=\"literal\">ln(y)=ln(b)+a*x</item> o <item type=\"literal\">ln(y)=ln(b)+ln(m)*x</item>, respectivament."
#: 04050100.xhp
msgctxt ""
@@ -4751,7 +4751,7 @@ msgctxt ""
"par_id9038972\n"
"help.text"
msgid "<ahelp hid=\".\">Set the light sources for the 3D view.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Defineix les fonts d'il·luminació per a la visualització 3D.</ahelp>"
#: three_d_view.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/sdraw/00.po b/source/ca/helpcontent2/source/text/sdraw/00.po
index ec5f6c75a14..dbe190c235e 100644
--- a/source/ca/helpcontent2/source/text/sdraw/00.po
+++ b/source/ca/helpcontent2/source/text/sdraw/00.po
@@ -4,8 +4,8 @@ msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
"POT-Creation-Date: 2017-05-09 16:45+0200\n"
-"PO-Revision-Date: 2013-05-24 08:07+0000\n"
-"Last-Translator: Joan Montané <joan@montane.cat>\n"
+"PO-Revision-Date: 2018-07-02 06:35+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -13,9 +13,9 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1369382846.000000\n"
+"X-POOTLE-MTIME: 1530513312.000000\n"
#: 00000004.xhp
msgctxt ""
@@ -23,7 +23,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "To access this command..."
-msgstr "Per accedir a aquesta ordre..."
+msgstr "Per a accedir a aquesta ordre..."
#: 00000004.xhp
msgctxt ""
@@ -31,4 +31,4 @@ msgctxt ""
"hd_id3156024\n"
"help.text"
msgid "<variable id=\"wie\">To access this command...</variable>"
-msgstr "<variable id=\"wie\">Per accedir a aquesta ordre...</variable>"
+msgstr "<variable id=\"wie\">Per a accedir a aquesta ordre...</variable>"
diff --git a/source/ca/helpcontent2/source/text/shared/00.po b/source/ca/helpcontent2/source/text/shared/00.po
index 0a8729de4eb..61f3c6a818b 100644
--- a/source/ca/helpcontent2/source/text/shared/00.po
+++ b/source/ca/helpcontent2/source/text/shared/00.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-06-04 15:42+0200\n"
-"PO-Revision-Date: 2018-05-29 06:48+0000\n"
-"Last-Translator: Joan Montané <joan@montane.cat>\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-07-02 06:35+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -13,9 +13,9 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: LibreOffice\n"
+"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1527576483.000000\n"
+"X-POOTLE-MTIME: 1530513319.000000\n"
#: 00000001.xhp
msgctxt ""
@@ -567,7 +567,7 @@ msgctxt ""
"hd_id831527692839432\n"
"help.text"
msgid "OK"
-msgstr ""
+msgstr "D'acord"
#: 00000001.xhp
msgctxt ""
@@ -631,7 +631,7 @@ msgctxt ""
"par_id3155577\n"
"help.text"
msgid "If you are a newcomer to the Internet, you will be confronted with unfamiliar terms: browser, bookmark, e-mail, homepage, search engine, and many others. To make your first steps easier, this glossary explains some of the more important terminology you may find in the Internet, intranet, mail and news."
-msgstr ""
+msgstr "Si sou nouvingut al món d'Internet, us trobareu amb paraules que us poden ser poc familiars: navegador, marcador, correu electrònic, pàgina inicial, cercador i moltes altres. Perquè els vostres primers passos siguin més fàcils, aquest glossari explica alguns dels termes més importants que podeu trobar a Internet, a intranets, al correu electrònic i a les notícies."
#: 00000002.xhp
msgctxt ""
@@ -727,7 +727,7 @@ msgctxt ""
"par_id3147335\n"
"help.text"
msgid "FTP stands for File Transfer Protocol and is the standard transfer protocol for files in the Internet. An FTP server is a program on a computer connected to the Internet which stores files to be transmitted with the aid of FTP. While FTP is responsible for transmitting and downloading Internet files, <link href=\"text/shared/00/00000002.xhp#http\" name=\"HTTP\">HTTP</link> (Hypertext Transfer Protocol) provides the connection setup and data transfer between WWW servers and clients."
-msgstr ""
+msgstr "FTP vol dir protocol de transferència de fitxers i és el protocol de transferència estàndard per baixar fitxers d'Internet. Un servidor FTP és un programa que es troba en un ordinador connectat a Internet i que emmagatzema fitxers que es transmetran amb l'ajuda de l'FTP. Mentre que l'FTP és responsable de transmetre i baixar fitxers d'Internet, l'<link href=\"text/shared/00/00000002.xhp#http\" name=\"HTTP\">HTTP</link> (protocol de transferència d'hipertext, de l'anglès Hypertext Transfer Protocol) fa possible la connexió i la transferència de fitxers entre servidors WWW i clients."
#: 00000002.xhp
msgctxt ""
@@ -751,7 +751,7 @@ msgctxt ""
"par_id3161459\n"
"help.text"
msgid "HTML (Hypertext Markup Language) is a document code language, which is used as the file format for WWW documents. It is derived from <link href=\"text/shared/00/00000002.xhp#sgml\" name=\"SGML\">SGML</link> and integrates text, graphics, videos and sound."
-msgstr ""
+msgstr "L'HTML (Hypertext Markup Language, llenguatge d'etiquetatge d'hipertext) és un llenguatge per a codificar documents que s'utilitza com a format de fitxer dels documents WWW. Deriva de l'<link href=\"text/shared/00/00000002.xhp#sgml\" name=\"SGML\">SGML</link> i integra text, gràfics, vídeos i so."
#: 00000002.xhp
msgctxt ""
@@ -759,7 +759,7 @@ msgctxt ""
"par_id3154346\n"
"help.text"
msgid "If you want to type HTML commands directly, for example when doing exercises from one of the many available HTML books, remember that HTML pages are pure text files. Save your document under the document type <emph>Text </emph>and give it the file name extension .HTML. Be sure there are no umlauts or other special characters of the extended character set. If you want to re-open this file in $[officename] and edit the HTML code, you must load it with the file type <emph>Text</emph> and not with the file type <emph>Web pages</emph>."
-msgstr ""
+msgstr "Si voleu teclejar ordres HTML directament, per exemple quan feu exercicis d'un dels molts llibres que existeixen sobre HTML, recordeu que les pàgines HTML són fitxers de text pur. Deseu el document en format <emph>Text</emph> i doneu-li l'extensió .HTML al nom del fitxer. Assegureu-vos que no hi ha dièresis alemanyes o altres caràcters especials del joc de caràcters ampliat. Si voleu tornar a obrir aquest fitxer al $[officename] i editar el codi HTML, heu de carregar el fitxer amb el tipus <emph>Text</emph> i no amb el tipus <emph>Pàgina web</emph>."
#: 00000002.xhp
msgctxt ""
@@ -767,7 +767,7 @@ msgctxt ""
"par_id3153960\n"
"help.text"
msgid "There are several references on the Internet providing an introduction to the HTML language."
-msgstr ""
+msgstr "Hi ha moltes referències a Internet que ofereixen una introducció al llenguatge HTML."
#: 00000002.xhp
msgctxt ""
@@ -1295,7 +1295,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "To access this command..."
-msgstr "Per accedir a aquesta ordre..."
+msgstr "Per a accedir a aquesta ordre..."
#: 00000004.xhp
msgctxt ""
@@ -1303,7 +1303,7 @@ msgctxt ""
"hd_id3160447\n"
"help.text"
msgid "<variable id=\"wie\">To access this command...</variable>"
-msgstr "<variable id=\"wie\">Per accedir a aquesta ordre...</variable>"
+msgstr "<variable id=\"wie\">Per a accedir a aquesta ordre...</variable>"
#: 00000004.xhp
msgctxt ""
@@ -7791,7 +7791,7 @@ msgctxt ""
"par_id3155419\n"
"help.text"
msgid "<variable id=\"rechtschreibungmenue\">Choose <emph>Tools - Spelling</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"rechtschreibungmenue\">Trieu <emph>Eines ▸ Ortografia</emph></variable>"
#: 00000406.xhp
msgctxt ""
@@ -7799,7 +7799,7 @@ msgctxt ""
"par_id3150771\n"
"help.text"
msgid "<variable id=\"zoptionen\">Choose <emph>Tools - Spelling</emph>, then click <emph>Options</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"zoptionen\">Trieu <emph>Eines ▸ Ortografia</emph>; tot seguit feu clic a <emph>Opcions</emph>.</variable>"
#: 00000406.xhp
msgctxt ""
@@ -7823,7 +7823,7 @@ msgctxt ""
"par_id3153320\n"
"help.text"
msgid "Choose <emph>Tools - Color Replacer</emph> ($[officename] Draw and $[officename] Impress)."
-msgstr ""
+msgstr "Trieu <emph>Eines ▸ Reemplaçament de color</emph> (al $[officename] Draw i al $[officename] Impress)"
#: 00000406.xhp
msgctxt ""
@@ -7831,7 +7831,7 @@ msgctxt ""
"par_idN107E9\n"
"help.text"
msgid "<variable id=\"mediaplayer\">Choose <emph>Tools - Media Player</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"mediaplayer\">Trieu <emph>Eines ▸ Reproductor multimèdia</emph>.</variable>"
#: 00000406.xhp
msgctxt ""
@@ -8167,7 +8167,7 @@ msgctxt ""
"par_id3150717\n"
"help.text"
msgid "<variable id=\"scripting\">Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - Security</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"scripting\">Trieu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ $[officename] ▸ Seguretat</emph></variable>"
#: 00000406.xhp
msgctxt ""
@@ -8335,7 +8335,7 @@ msgctxt ""
"par_id3147359\n"
"help.text"
msgid "<variable id=\"internet\">Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Internet</emph>.</variable>"
-msgstr ""
+msgstr "<variable id=\"internet\">Trieu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ Internet</emph></variable>"
#: 00000406.xhp
msgctxt ""
@@ -9668,6 +9668,14 @@ msgstr ""
#: 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/ca/helpcontent2/source/text/shared/01.po b/source/ca/helpcontent2/source/text/shared/01.po
index 8374cdce278..b8ec6363ad5 100644
--- a/source/ca/helpcontent2/source/text/shared/01.po
+++ b/source/ca/helpcontent2/source/text/shared/01.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-06-04 15:42+0200\n"
-"PO-Revision-Date: 2018-06-12 13:01+0000\n"
-"Last-Translator: AssumptaAn <assumptaanglada@gmail.com>\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-07-02 06:36+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1528808505.000000\n"
+"X-POOTLE-MTIME: 1530513375.000000\n"
#: 01010000.xhp
msgctxt ""
@@ -695,7 +695,7 @@ msgctxt ""
"par_id3149750\n"
"help.text"
msgid "<ahelp hid=\".\">Select the database field that you want, and then click the arrow to the left of this box to insert the field into the <emph>Label text</emph> box.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Seleccioneu el camp de base de dades que vulgueu i feu clic a la fletxa situada a l'esquerra del quadre per a inserir el camp en el quadre <emph>Text de l'etiqueta</emph>.</ahelp>"
#: 01010201.xhp
msgctxt ""
@@ -719,7 +719,7 @@ msgctxt ""
"par_id3149762\n"
"help.text"
msgid "You can select a pre-defined size format for your label or a size format that you specify on the <emph>Format </emph>tab."
-msgstr ""
+msgstr "Podeu seleccionar una mida predefinida per a l'etiqueta o una mida que definiu a la pestanya <emph>Format</emph>."
#: 01010201.xhp
msgctxt ""
@@ -1047,7 +1047,7 @@ msgctxt ""
"par_id3155355\n"
"help.text"
msgid "<ahelp hid=\"modules/swriter/ui/labeloptionspage/entirepage\" visibility=\"visible\">Creates a full page of labels or business cards.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"modules/swriter/ui/labeloptionspage/entirepage\" visibility=\"visible\">Crea tota una pàgina d'etiquetes o de targetes de visita.</ahelp>"
#: 01010203.xhp
msgctxt ""
@@ -1063,7 +1063,7 @@ msgctxt ""
"par_id3155535\n"
"help.text"
msgid "<ahelp hid=\"modules/swriter/ui/labeloptionspage/singlelabel\" visibility=\"visible\">Prints a single label or business card on a page.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"modules/swriter/ui/labeloptionspage/singlelabel\" visibility=\"visible\">Imprimeix una sola etiqueta o targeta de visita en una pàgina.</ahelp>"
#: 01010203.xhp
msgctxt ""
@@ -1111,7 +1111,7 @@ msgctxt ""
"par_id3155342\n"
"help.text"
msgid "<ahelp visibility=\"visible\" hid=\"modules/swriter/ui/labeloptionspage/synchronize\">Allows you to edit a single label or business card and updates the contents of the remaining labels or business cards on the page when you click the <emph>Synchronize Labels </emph>button.</ahelp>"
-msgstr "<ahelp visibility=\"visible\" hid=\" hid=\"modules/swriter/ui/labeloptionspage/synchronize\">Permet editar una sola etiqueta o targeta de visita i actualitza el contingut de les altres etiquetes o targetes de visita de la pàgina quan feu clic al botó <emph>Sincronitza les etiquetes</emph>.</ahelp>"
+msgstr "<ahelp visibility=\"visible\" hid=\"modules/swriter/ui/labeloptionspage/synchronize\">Permet editar una sola etiqueta o targeta de visita i actualitza el contingut de les altres etiquetes o targetes de visita de la pàgina quan feu clic al botó <emph>Sincronitza les etiquetes</emph>.</ahelp>"
#: 01010203.xhp
msgctxt ""
@@ -1247,7 +1247,7 @@ msgctxt ""
"par_id3150279\n"
"help.text"
msgid "<ahelp hid=\".\">Prints business cards on continuous paper.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Imprimeix les targetes de visita en paper continu.</ahelp>"
#: 01010301.xhp
msgctxt ""
@@ -1263,7 +1263,7 @@ msgctxt ""
"par_id3148731\n"
"help.text"
msgid "<ahelp hid=\".\">Prints business cards on individual sheets.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\".\">Imprimeix les targetes de visita en fulls individuals.</ahelp>"
#: 01010301.xhp
msgctxt ""
@@ -2007,7 +2007,7 @@ msgctxt ""
"par_id3146905\n"
"help.text"
msgid "all template folders as defined in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - </emph><link href=\"text/shared/optionen/01010300.xhp\" name=\"%PRODUCTNAME - Paths\"><emph>%PRODUCTNAME - Paths</emph></link>"
-msgstr "totes les carpetes de plantilles, tal com s'han definit a <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ </emph><link href=\"text/shared/optionen/01010300.xhp\" name=\"%PRODUCTNAME ▸ Camins\"><emph>%PRODUCTNAME ▸ Camins</link></emph>"
+msgstr "totes les carpetes de plantilles, tal com s'han definit a <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ </emph><link href=\"text/shared/optionen/01010300.xhp\" name=\"%PRODUCTNAME ▸ Paths\"><emph>%PRODUCTNAME ▸ Camins</emph></link>"
#: 01020000.xhp
msgctxt ""
@@ -2151,7 +2151,7 @@ msgctxt ""
"par_id951513629981585\n"
"help.text"
msgid "<link href=\"text/shared/guide/cmis-remote-files.xhp\" name=\"CMIS\">Opening and saving files in remote servers</link>"
-msgstr ""
+msgstr "<link href=\"text/shared/guide/cmis-remote-files.xhp\" name=\"CMIS\">Obertura i desament de fitxers a servidors remots</link>"
#: 01020101.xhp
msgctxt ""
@@ -2423,7 +2423,7 @@ msgctxt ""
"par_id771513629025613\n"
"help.text"
msgid "<variable id=\"saveremote1\"><ahelp hid=\".uno:SaveRemote\">Saves a document located in a remote file service.</ahelp></variable>"
-msgstr ""
+msgstr "<variable id=\"saveremote1\"><ahelp hid=\".uno:SaveRemote\">Desa un document ubicat en un servei de fitxers remots.</ahelp></variable>"
#: 01060001.xhp
msgctxt ""
@@ -2439,7 +2439,7 @@ msgctxt ""
"par_id431513629862558\n"
"help.text"
msgid "Long click on the <emph>Save</emph> icon and select <emph>Save Remote Files...</emph>"
-msgstr ""
+msgstr "Manteniu clicada la icona <emph>Desa</emph> i seleccioneu <emph>Desa fitxers remots...</emph>"
#: 01060001.xhp
msgctxt ""
@@ -2447,7 +2447,7 @@ msgctxt ""
"par_id531513630220632\n"
"help.text"
msgid "A remote file server is a web service that stores documents with or without checkin, checkout, version controls and backups."
-msgstr ""
+msgstr "Un servidor de fitxers remots és un servei web que emmagatzema documents amb o sense registre, comprovació, controls de versió o còpies de seguretat."
#: 01060001.xhp
msgctxt ""
@@ -2463,7 +2463,7 @@ msgctxt ""
"tit\n"
"help.text"
msgid "Save a Copy"
-msgstr ""
+msgstr "Desa una còpia"
#: 01060002.xhp
msgctxt ""
@@ -2479,7 +2479,7 @@ msgctxt ""
"par_id391513471676787\n"
"help.text"
msgid "<link href=\"text/shared/01/01060002.xhp\" name=\"Save a Copy\">Save a Copy</link>"
-msgstr ""
+msgstr "<link href=\"text/shared/01/01060002.xhp\" name=\"Save a Copy\">Desa una còpia</link>"
#: 01060002.xhp
msgctxt ""
@@ -2487,7 +2487,7 @@ msgctxt ""
"par_id1001513471674465\n"
"help.text"
msgid "<variable id=\"saveacopy1\"><ahelp hid=\".uno:SaveACopy\">Save a copy of the actual document with another name or location.</ahelp></variable>"
-msgstr ""
+msgstr "<variable id=\"saveacopy1\"><ahelp hid=\".uno:SaveACopy\">Desa una còpia del document actual amb un altre nom o ubicació.</ahelp></variable>"
#: 01060002.xhp
msgctxt ""
@@ -2511,7 +2511,7 @@ msgctxt ""
"par_id21513472326060\n"
"help.text"
msgid "<link href=\"text/shared/01/01060000.xhp\" name=\"Save\">Save</link>"
-msgstr "<link href=\"text/shared/01/01060000.xhp\" name=\"Desa\">Desa</link><link href=\"text/shared/01/01060000.xhp\" name=\"Desa\">"
+msgstr "<link href=\"text/shared/01/01060000.xhp\" name=\"Save\">Desa</link>"
#: 01060002.xhp
msgctxt ""
@@ -4751,7 +4751,7 @@ msgctxt ""
"hd_id3154898\n"
"help.text"
msgid "Type"
-msgstr ""
+msgstr "Tipus"
#: 01140000.xhp
msgctxt ""
@@ -5383,7 +5383,7 @@ msgctxt ""
"par_id3152811\n"
"help.text"
msgid "<ahelp hid=\"sfx/ui/versionsofdialog/compare\">Compare the changes that were made in each version.</ahelp> If you want, you can <link href=\"text/shared/01/02230400.xhp\" name=\"Manage Changes\"><emph>Manage Changes</emph></link>."
-msgstr "<ahelp hid=\"sfx/ui/versionsofdialog/compare\">Compareu els canvis que s'han fet a cada versió.</ahelp> Si voleu, també podeu <link href=\"text/shared/01/02230400.xhp\" name=>\"Gestiona els canvis\"><emph>gestionar els canvis</emph></link>."
+msgstr "<ahelp hid=\"sfx/ui/versionsofdialog/compare\">Compareu els canvis que s'han fet a cada versió.</ahelp> Si voleu, també podeu <link href=\"text/shared/01/02230400.xhp\" name=\"Gestiona els canvis\"><emph>gestionar els canvis</emph></link>."
#: 01990000.xhp
msgctxt ""
@@ -6263,7 +6263,7 @@ msgctxt ""
"par_id3155261\n"
"help.text"
msgid "<switchinline select=\"appl\"> <caseinline select=\"CALC\">To select all of the cells on a sheet, click the button at the intersection of the column and row header in the top left corner of the sheet.</caseinline> <defaultinline/> </switchinline>"
-msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Per seleccionar totes les cel·les d'un full, feu clic al botó situat a la intersecció de la capçalera de les columnes i de les files a la cantonada superior esquerra del full.</caseinline><defaultinline/></switchinline>"
+msgstr "<switchinline select=\"appl\"><caseinline select=\"CALC\">Per a seleccionar totes les cel·les d'un full, feu clic al botó situat a la intersecció de la capçalera de les columnes i de les files a la cantonada superior esquerra del full.</caseinline> <defaultinline/></switchinline>"
#: 02090000.xhp
msgctxt ""
@@ -6271,7 +6271,7 @@ msgctxt ""
"par_id3154046\n"
"help.text"
msgid "<switchinline select=\"appl\"> <caseinline select=\"CALC\">To select all of the sheets in a spreadsheet file, right-click the name tab of a sheet, and then choose <emph>Select All Sheets</emph>.<ahelp hid=\".uno:TableSelectAll\" visibility=\"hidden\">Selects all of the sheets in the current spreadsheet.</ahelp></caseinline> <defaultinline/> </switchinline>"
-msgstr "<switchinline select=\"appl\"> <caseinline select=\"CALC\">Per seleccionar tots els fulls d'un full de càlcul, feu clic amb el botó dret del ratolí a la pestanya de nom d'un full i trieu <emph>Selecciona tots els fulls</emph>.<ahelp hid=\".uno:TableSelectAll\" visibility=\"hidden\">Selecciona tots els fulls del full de càlcul actual.</ahelp></caseinline> <defaultinline/> </switchinline>"
+msgstr "<switchinline select=\"appl\"> <caseinline select=\"CALC\">Per a seleccionar tots els fulls d'un full de càlcul, feu clic amb el botó dret del ratolí a la pestanya de nom d'un full i trieu <emph>Selecciona tots els fulls</emph>.<ahelp hid=\".uno:TableSelectAll\" visibility=\"hidden\">Selecciona tots els fulls del full de càlcul actual.</ahelp></caseinline> <defaultinline/> </switchinline>"
#: 02100000.xhp
msgctxt ""
@@ -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 "Representa un caràcter de l'abecedari. Utilitzeu [:alpha:]+ per trobar-ne un."
+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 "Representa un dígit decimal. Utilitzeu [:digit:]+ per trobar-ne un."
+msgid "Represents a decimal digit. Use [:digit:]+ to find one or more of them."
+msgstr ""
#: 02100001.xhp
msgctxt ""
@@ -9255,7 +9255,7 @@ msgctxt ""
"par_id3150008\n"
"help.text"
msgid "<ahelp visibility=\"visible\" hid=\".\">Lets you edit a selected object in your file that you inserted with the <emph>Insert – Object</emph> command.</ahelp>"
-msgstr "<ahelp visibility=\"visible\" hid=\"\">Permet editar un objecte seleccionat al fitxer; cal que hàgiu inserit l'objecte mitjançant l'ordre <emph>Insereix - Objecte</emph>.</ahelp>"
+msgstr "<ahelp visibility=\"visible\" hid=\".\">Permet editar un objecte seleccionat al fitxer; cal que hàgiu inserit l'objecte mitjançant l'ordre <emph>Insereix ▸ Objecte</emph>.</ahelp>"
#: 02200200.xhp
msgctxt ""
@@ -10167,7 +10167,7 @@ msgctxt ""
"par_id3150382\n"
"help.text"
msgid "<ahelp hid=\"svx/ui/imapdialog/container\">Displays the image map, so that you can click and edit the hotspots.</ahelp>"
-msgstr "<ahelp hid=\"svx/ui/imapdialog/container\"/>Mostra el mapa d'imatge perquè pugueu fer clic a les zones sensibles i editar-les."
+msgstr "<ahelp hid=\"svx/ui/imapdialog/container\">Mostra el mapa d'imatge perquè pugueu fer clic a les zones sensibles i editar-les.</ahelp>"
#: 02220000.xhp
msgctxt ""
@@ -17911,7 +17911,7 @@ msgctxt ""
"par_id3155351\n"
"help.text"
msgid "<ahelp hid=\".\">Sets the options for double-line writing for Asian languages. Select the characters in your text, and then choose this command.</ahelp>"
-msgstr "<ahelp hid=\"\">Defineix les opcions de línies dobles per a les llengües asiàtiques. Seleccioneu els caràcters al text i, tot seguit, trieu aquesta ordre.</ahelp>"
+msgstr "<ahelp hid=\".\">Defineix les opcions de línies dobles per a les llengües asiàtiques. Seleccioneu els caràcters al text i, tot seguit, trieu aquesta ordre.</ahelp>"
#: 05020600.xhp
msgctxt ""
@@ -29143,7 +29143,7 @@ msgctxt ""
"par_id3147000\n"
"help.text"
msgid "<ahelp hid=\"svx/ui/docking3deffects/texture\">Sets the properties of the surface texture for the selected 3D object. This feature is only available after you apply a surface texture to the selected object. To quickly apply a surface texture, open the <emph>Gallery</emph>, hold down Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, and then drag an image onto the selected 3D object.</ahelp>"
-msgstr "<ahelp hid=\"svx/ui/docking3deffects/texture\">Defineix les propietats de la textura superficial de l'objecte 3D seleccionat. Aquesta funció només està disponible després d'aplicar una textura superficial a l'objecte seleccionat. Per aplicar ràpidament una textura superficial, obriu la <emph>Galeria</emph>, manteniu premut Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Ordre</caseinline>Ctrl</defaultinline></switchinline>, i després arrossegueu una imatge fins a l'objecte 3D seleccionat.</ahelp>"
+msgstr "<ahelp hid=\"svx/ui/docking3deffects/texture\">Defineix les propietats de la textura superficial de l'objecte 3D seleccionat. Aquesta funció només està disponible després d'aplicar una textura superficial a l'objecte seleccionat. Per aplicar ràpidament una textura superficial, obriu la <emph>Galeria</emph>, manteniu premut Maj+<switchinline select=\"sys\"><caseinline select=\"MAC\">Ordre</caseinline>Ctrl</defaultinline></switchinline>, i després arrossegueu una imatge fins a l'objecte 3D seleccionat.</ahelp>"
#: 05350500.xhp
msgctxt ""
@@ -34535,7 +34535,7 @@ msgctxt ""
"par_id3155271\n"
"help.text"
msgid "<ahelp hid=\".\">Locate the <item type=\"productname\">%PRODUCTNAME</item> Basic library that you want to add to the current list, and then click Open.</ahelp>"
-msgstr "<ahelp hid=\"\">Cerqueu la biblioteca del <item type=\"productname\">%PRODUCTNAME</item> Basic que vulgueu afegir a la llista actual i, a continuació, feu clic a <emph>Obre</emph>.</ahelp>"
+msgstr "<ahelp hid=\".\">Cerqueu la biblioteca del <item type=\"productname\">%PRODUCTNAME</item> Basic que vulgueu afegir a la llista actual i, a continuació, feu clic a Obre.</ahelp>"
#: 06130500.xhp
msgctxt ""
@@ -35271,7 +35271,7 @@ msgctxt ""
"hd_id431514298399070\n"
"help.text"
msgid "<link href=\"text/shared/01/06140300.xhp\" name=\"Context Menus\">Context Menus</link>"
-msgstr ""
+msgstr "<link href=\"text/shared/01/06140300.xhp\" name=\"Context Menus\">Menús contextuals</link>"
#: 06140300.xhp
msgctxt ""
@@ -35407,7 +35407,7 @@ msgctxt ""
"par_id151514304300251\n"
"help.text"
msgid "Click on the Add button to add a new context menu."
-msgstr ""
+msgstr "Feu clic al botó Afegeix per afegir un nou menú contextual."
#: 06140300.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/shared/04.po b/source/ca/helpcontent2/source/text/shared/04.po
index 3181fc0d954..ab727deb351 100644
--- a/source/ca/helpcontent2/source/text/shared/04.po
+++ b/source/ca/helpcontent2/source/text/shared/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-05-08 15:10+0200\n"
-"PO-Revision-Date: 2018-05-23 06:31+0000\n"
+"PO-Revision-Date: 2018-06-25 10:14+0000\n"
"Last-Translator: Joan Montané <joan@montane.cat>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1527057067.000000\n"
+"X-POOTLE-MTIME: 1529921672.000000\n"
#: 01010000.xhp
msgctxt ""
@@ -559,7 +559,7 @@ msgctxt ""
"par_id3150567\n"
"help.text"
msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\"/><defaultinline>Toggles the view between fullscreen mode and normal mode in Writer or Calc</defaultinline></switchinline>"
-msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\"/><defaultinline>Alterna la visualització entre el mode pantalla completa i el normal al Writter o al Calc</defaultinline></switchinline>"
+msgstr "<switchinline select=\"sys\"><caseinline select=\"MAC\"/><defaultinline>Alterna la visualització entre el mode pantalla completa i el normal al Writer o al Calc</defaultinline></switchinline>"
#: 01010000.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/shared/optionen.po b/source/ca/helpcontent2/source/text/shared/optionen.po
index 9875b977446..240bf94ab67 100644
--- a/source/ca/helpcontent2/source/text/shared/optionen.po
+++ b/source/ca/helpcontent2/source/text/shared/optionen.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-06-04 15:42+0200\n"
-"PO-Revision-Date: 2018-06-12 13:00+0000\n"
-"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-06-25 11:10+0000\n"
+"Last-Translator: Joan Montané <joan@montane.cat>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -13,9 +13,9 @@ 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-Language: ca\n"
-"X-POOTLE-MTIME: 1528808448.000000\n"
+"X-POOTLE-MTIME: 1529925031.000000\n"
#: 01000000.xhp
msgctxt ""
@@ -3743,7 +3743,7 @@ msgctxt ""
"par_id3154270\n"
"help.text"
msgid "<ahelp hid=\".\">Specifies the maximum print quality in dpi. The resolution can only be reduced and not increased.</ahelp>"
-msgstr ""
+msgstr "<variable id=\"registerschattencursor\">Obriu un document de text, trieu <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferències</emph></caseinline><defaultinline><emph>Eines ▸ Opcions</emph></defaultinline></switchinline><emph> ▸ %PRODUCTNAME Writer/%PRODUCTNAME Writer/Web</emph> ▸ <emph>Ajudes a la formatació</emph>.</variable>"
#: 01010900.xhp
msgctxt ""
@@ -9134,8 +9134,8 @@ msgctxt ""
"01060500.xhp\n"
"par_id3154319\n"
"help.text"
-msgid "=B6*0,15"
-msgstr "=B6*0,16"
+msgid "=B6*0.15"
+msgstr ""
#: 01060500.xhp
msgctxt ""
@@ -11575,7 +11575,7 @@ msgctxt ""
"par_id3149182\n"
"help.text"
msgid "<variable id=\"farbe\"><ahelp hid=\".\" visibility=\"visible\">Defines the general settings for charts.</ahelp></variable>"
-msgstr "<variable id=\"farbe\"><ahelp hid=\"\" visibility=\"visible\">Defineix els paràmetres generals per als diagrames.</ahelp></variable>"
+msgstr "<variable id=\"farbe\"><ahelp hid=\".\" visibility=\"visible\">Defineix els paràmetres generals per als diagrames.</ahelp></variable>"
#: 01110100.xhp
msgctxt ""
@@ -13247,7 +13247,7 @@ msgctxt ""
"hd_id2507201510011472\n"
"help.text"
msgid "Autocorrection"
-msgstr ""
+msgstr "Correcció automàtica"
#: BasicIDE.xhp
msgctxt ""
@@ -14031,7 +14031,7 @@ msgctxt ""
"par_idN105A7\n"
"help.text"
msgid "Add"
-msgstr ""
+msgstr "Afegeix"
#: javaparameters.xhp
msgctxt ""
@@ -14047,7 +14047,7 @@ msgctxt ""
"par_idN105C55\n"
"help.text"
msgid "Edit"
-msgstr ""
+msgstr "Edita"
#: javaparameters.xhp
msgctxt ""
@@ -14719,7 +14719,7 @@ msgctxt ""
"hd_id1418807\n"
"help.text"
msgid "Change"
-msgstr ""
+msgstr "Canvia"
#: online_update.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/swriter.po b/source/ca/helpcontent2/source/text/swriter.po
index 1c8c45d3f29..a20f48764e8 100644
--- a/source/ca/helpcontent2/source/text/swriter.po
+++ b/source/ca/helpcontent2/source/text/swriter.po
@@ -3,8 +3,8 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-04-05 11:28+0200\n"
-"PO-Revision-Date: 2018-06-12 08:08+0000\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-06-21 08:32+0000\n"
"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
@@ -13,9 +13,9 @@ 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-Language: ca\n"
-"X-POOTLE-MTIME: 1528790881.000000\n"
+"X-POOTLE-MTIME: 1529569976.000000\n"
#: classificationbar.xhp
msgctxt ""
@@ -271,7 +271,7 @@ msgctxt ""
"par_id03082016174713477\n"
"help.text"
msgid "Use the file with your %PRODUCTNAME locale in the name as example."
-msgstr ""
+msgstr "Feu servir com a exemple el fitxer corresponent a la configuració local de la vostra versió del %PRODUCTNAME."
#: classificationbar.xhp
msgctxt ""
@@ -463,7 +463,7 @@ msgctxt ""
"par_idN10556\n"
"help.text"
msgid "<ahelp hid=\".\">Creates a single merged document with page breaks between each recipient.</ahelp> The names and the addresses of the recipients are contained in the document, which can be customized as needed."
-msgstr ""
+msgstr "<ahelp hid=\".\">Crea un únic document amb salts de pàgina entre cada destinatari.</ahelp> Els noms i les adreces dels destinataris són al document i es poden personalitzar en funció de les vostres necessitats."
#: main0000.xhp
msgctxt ""
@@ -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=\".\">Conté ordres per a establir, crear, editar, actualitzar, carregar i gestionar estils en un document de text.</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 "Per defecte"
+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 "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 "Set the current paragraph or selected paragraphs to the default style."
-msgstr "Estableix l'estil predeterminat al paràgraf actual, o als paràgrafs seleccionats."
+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/ca/helpcontent2/source/text/swriter/00.po b/source/ca/helpcontent2/source/text/swriter/00.po
index 043059e3082..e5f41b44f49 100644
--- a/source/ca/helpcontent2/source/text/swriter/00.po
+++ b/source/ca/helpcontent2/source/text/swriter/00.po
@@ -3,9 +3,9 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2018-05-22 13:17+0200\n"
-"PO-Revision-Date: 2018-05-28 12:29+0000\n"
-"Last-Translator: Joan Montané <joan@montane.cat>\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-06-21 08:33+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -13,9 +13,9 @@ 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-Language: ca\n"
-"X-POOTLE-MTIME: 1527510569.000000\n"
+"X-POOTLE-MTIME: 1529569999.000000\n"
#: 00000004.xhp
msgctxt ""
@@ -1159,7 +1159,7 @@ msgctxt ""
"par_id3154251\n"
"help.text"
msgid "Choose <emph>Table - Insert Table</emph>"
-msgstr ""
+msgstr "Trieu <emph>Taula ▸ Insereix una taula</emph>"
#: 00000404.xhp
msgctxt ""
@@ -1479,7 +1479,7 @@ msgctxt ""
"par_id3151370\n"
"help.text"
msgid "<variable id=\"eingabe\">Choose <emph>Tools - AutoCorrect - While Typing</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"eingabe\">Trieu <emph>Eines ▸ Correcció automàtica ▸ En teclejar</emph></variable>"
#: 00000405.xhp
msgctxt ""
@@ -1487,7 +1487,7 @@ msgctxt ""
"par_id3149538\n"
"help.text"
msgid "<variable id=\"autoformat1\">Choose <emph>Tools - AutoCorrect</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"autoformat1\">Trieu <emph>Eines ▸ Correcció automàtica</emph></variable>"
#: 00000405.xhp
msgctxt ""
@@ -1495,7 +1495,7 @@ msgctxt ""
"par_id3150117\n"
"help.text"
msgid "<variable id=\"autoformat2\">Choose <emph>Tools - AutoCorrect - Apply</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"autoformat2\">Trieu <emph>Eines ▸ Correcció automàtica ▸ Aplica</emph></variable>"
#: 00000405.xhp
msgctxt ""
@@ -1503,7 +1503,7 @@ msgctxt ""
"par_id3155870\n"
"help.text"
msgid "<variable id=\"autoformat3\">Choose <emph>Tools - AutoCorrect - Apply and Edit Changes</emph></variable>"
-msgstr ""
+msgstr "<variable id=\"autoformat3\">Trieu <emph>Eines ▸ Correcció automàtica ▸ Aplica i edita els canvis</emph></variable>"
#: 00000405.xhp
msgctxt ""
@@ -2183,7 +2183,7 @@ msgctxt ""
"par_id3156355\n"
"help.text"
msgid "Choose <emph>Format - Frame and Object - Properties</emph>"
-msgstr ""
+msgstr "Trieu <emph>Format ▸ Marc i objecte ▸ Propietats</emph>"
#: 00000405.xhp
msgctxt ""
@@ -2448,3 +2448,51 @@ msgctxt ""
"help.text"
msgid "Mail Merge"
msgstr "Combinació de correu"
+
+#: 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/ca/helpcontent2/source/text/swriter/01.po b/source/ca/helpcontent2/source/text/swriter/01.po
index 8bdfa225714..f399bd5cc16 100644
--- a/source/ca/helpcontent2/source/text/swriter/01.po
+++ b/source/ca/helpcontent2/source/text/swriter/01.po
@@ -4,8 +4,8 @@ msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
"POT-Creation-Date: 2018-05-22 13:17+0200\n"
-"PO-Revision-Date: 2018-05-28 12:22+0000\n"
-"Last-Translator: Joan Montané <joan@montane.cat>\n"
+"PO-Revision-Date: 2018-06-21 08:33+0000\n"
+"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: ca\n"
"MIME-Version: 1.0\n"
@@ -15,7 +15,7 @@ msgstr ""
"X-Accelerator-Marker: ~\n"
"X-Generator: Pootle 2.8\n"
"X-Language: ca\n"
-"X-POOTLE-MTIME: 1527510179.000000\n"
+"X-POOTLE-MTIME: 1529570012.000000\n"
#: 01120000.xhp
msgctxt ""
@@ -303,7 +303,7 @@ msgctxt ""
"hd_id3150108\n"
"help.text"
msgid "Field"
-msgstr ""
+msgstr "Camp"
#: 01150000.xhp
msgctxt ""
@@ -719,7 +719,7 @@ msgctxt ""
"par_idN1087B\n"
"help.text"
msgid "<image id=\"img_id3628141\" src=\"sw/res/sc20249.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3628141\">Icon</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3628141\" src=\"sw/res/sc20249.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3628141\">Icona</alt></image>"
#: 02110000.xhp
msgctxt ""
@@ -751,7 +751,7 @@ msgctxt ""
"par_id3154616\n"
"help.text"
msgid "<image id=\"img_id3154622\" src=\"sw/res/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154622\">Icon</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3154622\" src=\"sw/res/sc20186.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3154622\">Icona</alt></image>"
#: 02110000.xhp
msgctxt ""
@@ -783,7 +783,7 @@ msgctxt ""
"par_id3150767\n"
"help.text"
msgid "<image id=\"img_id3150773\" src=\"sw/res/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150773\">Icon</alt></image>"
-msgstr ""
+msgstr "<image id=\"img_id3150773\" src=\"sw/res/sc20175.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3150773\">Icona</alt></image>"
#: 02110000.xhp
msgctxt ""
diff --git a/source/ca/helpcontent2/source/text/swriter/guide.po b/source/ca/helpcontent2/source/text/swriter/guide.po
index 96a6aff35e5..265d38b1804 100644
--- a/source/ca/helpcontent2/source/text/swriter/guide.po
+++ b/source/ca/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-28 12:27+0000\n"
"Last-Translator: Joan Montané <joan@montane.cat>\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-Language: ca\n"
"X-POOTLE-MTIME: 1527510473.000000\n"
@@ -8732,26 +8732,34 @@ msgstr "Podeu importar estils d'un altre document o plantilla al document actual
#: 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."
+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 "Feu clic a la fletxa que hi ha al costat de la icona <emph>Estil nou a partir de la selecció</emph> per obrir el submenú."
+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 "Trieu <emph>Carrega els estils</emph>."
+msgid "Click the arrow next to the <emph>New Style from Selection</emph> icon to open the submenu."
+msgstr "Feu clic a la fletxa que hi ha al costat de la icona <emph>Estil nou a partir de la selecció</emph> per obrir el submenú."
#: load_styles.xhp
msgctxt ""