update translations for master

and force-fix errors using pocheck

Change-Id: I1658b92ce4e7a15ad5539e5dcba48bfd1951744f

1 files changed, 160 insertions, 142 deletions

diff --git a/source/es/helpcontent2/source/text/scalc/01.po b/source/es/helpcontent2/source/text/scalc/01.po
index 69e7753a109..1bf7f18a61a 100644
--- a/source/es/helpcontent2/source/text/scalc/01.po
+++ b/source/es/helpcontent2/source/text/scalc/01.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: 2021-09-20 13:02+0200\n"
-"PO-Revision-Date: 2021-09-27 17:24+0000\n"
+"POT-Creation-Date: 2021-10-04 19:51+0200\n"
+"PO-Revision-Date: 2021-10-01 06:36+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Spanish <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/es/>\n"
 "Language: es\n"
@@ -13,7 +13,7 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=n != 1;\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Weblate 4.8.1\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1564682427.000000\n"
 
 #. sZfWF
@@ -14938,14 +14938,14 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa.</ahelp> The conversion uses the fixed exchange rates at which the legacy currencies entered the euro."
 msgstr "<ahelp hid=\".\">Convierte en euros un valor monetario expresado en una de las monedas que antes utilizaban los 19 Estados miembros de la Unión Europea, y viceversa.</ahelp> La conversión utiliza los tipos de cambio fijos que tenían cada una de estas monedas antes de la transición al euro."
 
-#. 5TXaB
+#. ikuav
 #: 04060106.xhp
 msgctxt ""
 "04060106.xhp\n"
 "par_id581631900947319\n"
 "help.text"
-msgid "We recommend using the more flexible EUROCONVERT function for converting between these currencies."
-msgstr "Recomendamos que utilice la función EUROCONVERT, más flexible, para efectuar conversiones entre estas divisas."
+msgid "We recommend using the more flexible EUROCONVERT function for converting between these currencies. For converting between many different units of measure, use the CONVERT function."
+msgstr ""
 
 #. ETLYS
 #: 04060106.xhp
@@ -19060,14 +19060,14 @@ msgctxt ""
 msgid "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
 msgstr "Si el Tipo es = 0, solo se encuentran resultados exactos. Si el criterio de búsqueda es encontrado más de una vez, la función devuelve el índice del primer valor encontrado. Solo si el Tipo es = 0 puedes buscar expresiones regulares (si están activadas en las opciones de cálculo) o comodines (si están activados en las opciones de cálculo)."
 
-#. kxGzq
+#. t3Ems
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3147528\n"
 "help.text"
-msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. This applies even when the search array is not sorted. For Type = -1, the first value that is larger or equal is returned."
-msgstr "Si el Tipo = 1 o el tercer parámetro es desconocido, se devuelve el índice del último valor que es menor que o igual al criterio de búsqueda. Esto se aplica incluso cuando la matriz de búsqueda no está ordenada. Para Tipo = -1, se devuelve el primer valor que es mayor o igual."
+msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the first value that is larger or equal is returned."
+msgstr ""
 
 #. eFMjk
 #: 04060109.xhp
@@ -44197,50 +44197,149 @@ msgctxt ""
 msgid "Merge and Center Cells"
 msgstr "Combinar y centrar celdas"
 
-#. d7KhY
+#. yCXuu
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"bm_id501632012952361\n"
+"help.text"
+msgid "<bookmark_value>toggle merge and center cells</bookmark_value>"
+msgstr ""
+
+#. CQ5ZE
 #: 05060000.xhp
 msgctxt ""
 "05060000.xhp\n"
 "hd_id3149785\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/05060000.xhp\" name=\"Merge and Center Cells\">Merge and Center Cells</link>"
-msgstr "<link href=\"text/scalc/01/05060000.xhp\" name=\"Merge and Center Cells\">Combinar y centrar celdas</link>"
+msgid "<variable id=\"togglemergecells\"><link href=\"text/scalc/01/05060000.xhp\" name=\"Merge and Center Cells\">Merge and Center Cells</link></variable>"
+msgstr ""
 
-#. DaWoE
+#. 8qb5f
 #: 05060000.xhp
 msgctxt ""
 "05060000.xhp\n"
 "par_id3151246\n"
 "help.text"
-msgid "<ahelp hid=\".\">Combines the selected cells into a single cell or splits merged cells. Aligns cell content centered.</ahelp>"
-msgstr "<ahelp hid=\".\">Combina las celdas seleccionadas en una sola celda o divide celdas combinadas. Alinea el contenido de la celda al centro.</ahelp>"
+msgid "<ahelp hid=\".\">This is a toggleable control that joins all cells in a rectangular selection into a single cell, or returns merged cells to the original individual cells. When merging it will format the merged cell as center aligned.</ahelp>"
+msgstr ""
+
+#. b63oA
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id541633057818950\n"
+"help.text"
+msgid "The control is shown toggled-on whenever there are merged cells in the selection, indicating that clicking the control will unmerge those cells."
+msgstr ""
+
+#. MiEGm
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id3153718\n"
+"help.text"
+msgid "Merging cells can lead to calculation errors in formulas in the table."
+msgstr "Se pueden producir errores de cálculo al combinar celdas con fórmulas."
 
-#. XHEBx
+#. fBfnU
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id441632808439621\n"
+"help.text"
+msgid "Do one of the following:"
+msgstr ""
+
+#. bnEwD
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id691632803588118\n"
+"help.text"
+msgid "In the <emph>Formatting</emph> toolbar, click:"
+msgstr ""
+
+#. sq4wv
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id521632804983642\n"
+"help.text"
+msgid "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id921632804983642\">Icon</alt>    </image>"
+msgstr ""
+
+#. 86yef
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id491632804983642\n"
+"help.text"
+msgid "Merge and Center Cells"
+msgstr ""
+
+#. ZRQSQ
 #: 05060000.xhp
 msgctxt ""
 "05060000.xhp\n"
 "par_id3154020\n"
 "help.text"
-msgid "Choose <emph>Format - Merge Cells - Merge and Center Cells</emph>"
-msgstr "Vaya a <emph>Formato ▸ Combinar celdas ▸ Combinar y centrar celdas</emph>"
+msgid "Or, choose <variable id=\"format_mergecells_menu\"><menuitem>Format - Merge and Unmerge Cells - </menuitem></variable><menuitem> Merge and Center Cells</menuitem>."
+msgstr ""
+
+#. 8zues
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id3149665\n"
+"help.text"
+msgid "Cells cannot be merged again without first unmerging them."
+msgstr ""
 
-#. rpUVk
+#. Dybs6
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id581632979766784\n"
+"help.text"
+msgid "Merging a cell selection that partially includes merged cells is generally possible with <emph>Unmerge Cells</emph> followed by <emph>Merge Cells</emph>, without altering the initial selection. The result will be largely depend on previous choices when merging cells made with the <emph>Merge Cells Dialog</emph> options described below."
+msgstr ""
+
+#. wNBDD
 #: 05060000.xhp
 msgctxt ""
 "05060000.xhp\n"
 "par_id3148552\n"
 "help.text"
-msgid "The merged cell receives the name of the first cell of the original cell range. Merged cells cannot be merged a second time with other cells. The range must form a rectangle, multiple selection is not supported."
-msgstr "La celda fusionada obtiene la dirección correspondiente a la primera celda del área original. Las celdas ya fusionadas no pueden volver a comprimirse con otras celdas. El área debe tener forma rectangular; no se admiten selecciones múltiples."
+msgid "Multiple selection is not supported, that is, the selection must be rectangular."
+msgstr ""
 
-#. HQCwU
+#. XB4aH
 #: 05060000.xhp
 msgctxt ""
 "05060000.xhp\n"
-"par_id3149665\n"
+"par_id211632985508898\n"
 "help.text"
-msgid "If the cells to be merged have any contents, a security dialog is shown."
-msgstr "Si las celdas combinadas tienen contenido se muestra un diálogo de seguridad."
+msgid "The merged cell receives the name and content of the first cell of the selection."
+msgstr ""
+
+#. XRBDv
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id271632985709781\n"
+"help.text"
+msgid "If more than one cell to be merged has content the <emph>Merge Cells</emph> dialog opens."
+msgstr ""
+
+#. QWjJw
+#: 05060000.xhp
+msgctxt ""
+"05060000.xhp\n"
+"par_id391632360383197\n"
+"help.text"
+msgid "Merge Cells Dialog Options"
+msgstr ""
 
 #. LBMEE
 #: 05060000.xhp
@@ -44278,15 +44377,6 @@ msgctxt ""
 msgid "<emph>Empty the contents of the hidden cells</emph>: <ahelp hid=\".\">The contents of the hidden cells are removed; the results of formulas referring to the hidden cells will be updated.</ahelp>"
 msgstr "<emph>Vaciar el contenido de las celdas ocultas</emph>. <ahelp hid=\".\">Se suprime el contenido de las celdas ocultas y se actualizan los resultados de cualesquier fórmulas que hagan referencia a las celdas ocultas.</ahelp>"
 
-#. MiEGm
-#: 05060000.xhp
-msgctxt ""
-"05060000.xhp\n"
-"par_id3153718\n"
-"help.text"
-msgid "Merging cells can lead to calculation errors in formulas in the table."
-msgstr "Se pueden producir errores de cálculo al combinar celdas con fórmulas."
-
 #. b8c8c
 #: 05070000.xhp
 msgctxt ""
@@ -44305,14 +44395,14 @@ msgctxt ""
 msgid "<bookmark_value>style;page</bookmark_value><bookmark_value>page;style</bookmark_value><bookmark_value>format;page</bookmark_value><bookmark_value>formatting;page</bookmark_value>"
 msgstr ""
 
-#. YjqDi
+#. Rpt6B
 #: 05070000.xhp
 msgctxt ""
 "05070000.xhp\n"
 "hd_id3157910\n"
 "help.text"
-msgid "Page Style"
-msgstr "Estilos de página"
+msgid "<link href=\"text/scalc/01/05070000.xhp\" name=\"Page Style\">Page Style</link>"
+msgstr ""
 
 #. 4vJrN
 #: 05070000.xhp
@@ -44584,23 +44674,23 @@ msgctxt ""
 msgid "First page number"
 msgstr "Primer núm. de página"
 
-#. zJPaa
+#. oAziQ
 #: 05070500.xhp
 msgctxt ""
 "05070500.xhp\n"
 "par_id3155378\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Select this option if you want the first page to start with a number other than 1.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Seleccione esta opción si desea que la primera página empiece por un número distinto de 1.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/checkBTN_PAGENO\">Select this option if you want this style to restart page numbering.</ahelp>"
+msgstr ""
 
-#. AG8hs
+#. gVwLk
 #: 05070500.xhp
 msgctxt ""
 "05070500.xhp\n"
 "par_id3145389\n"
 "help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Enter the number of the first page.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Entra  el número de la primera página.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/spinED_PAGENO\">Enter the number you want to restart at.</ahelp>"
+msgstr ""
 
 #. V6Y9R
 #: 05070500.xhp
@@ -44908,14 +44998,14 @@ msgctxt ""
 msgid "Edit Print Ranges"
 msgstr "Editar zonas de impresión"
 
-#. QueLv
+#. JfwDe
 #: 05080300.xhp
 msgctxt ""
 "05080300.xhp\n"
 "par_id3159488\n"
 "help.text"
-msgid "<variable id=\"druckbereichetext\"><ahelp hid=\".uno:EditPrintArea\">Opens a dialog where you can specify the print range.</ahelp></variable> You can also set the rows or columns which are to be repeated in every page."
-msgstr "<variable id=\"druckbereichetext\"><ahelp hid=\".uno:EditPrintArea\">Abre un cuadro de diálogo donde especificar la zona de impresión.</ahelp></variable> También se puede determinar las filas o columnas que se repetirán en todas las páginas."
+msgid "<variable id=\"printrangestext\"><ahelp hid=\".uno:EditPrintArea\">Opens a dialog where you can specify the print range.</ahelp></variable> You can also set the rows or columns which are to be repeated in every page."
+msgstr ""
 
 #. eja4j
 #: 05080300.xhp
@@ -45367,78 +45457,6 @@ msgctxt ""
 msgid "<ahelp hid=\"SFX2_HID_TEMPLATE_FILTER\">Lists the available style groups.</ahelp>"
 msgstr "<ahelp hid=\"SFX2_HID_TEMPLATE_FILTER\">Enumera los grupos de estilos disponibles.</ahelp>"
 
-#. Gmpzb
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"tit\n"
-"help.text"
-msgid "Merge Cells"
-msgstr "Combinar celdas"
-
-#. 4JtKL
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"hd_id3154765\n"
-"help.text"
-msgid "Merge Cells"
-msgstr "Combinar celdas"
-
-#. BHmTE
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"par_id3147406\n"
-"help.text"
-msgid "<ahelp hid=\".\">Combines the contents of the selected cells into a single cell.</ahelp>"
-msgstr "<ahelp hid=\".\">Combina el contenido de las celdas seleccionadas en una sola celda.</ahelp>"
-
-#. AP2s7
-#: 05100100.xhp
-msgctxt ""
-"05100100.xhp\n"
-"par_id3154351\n"
-"help.text"
-msgid "Choose <emph>Format - Merge Cells - Merge Cells</emph>"
-msgstr "Elija <emph>Formato ▸ Combinar celdas ▸ Combinar celdas</emph>"
-
-#. pfYCj
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"tit\n"
-"help.text"
-msgid "Split Cells"
-msgstr "Dividir celdas"
-
-#. ZTsK9
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"hd_id3154654\n"
-"help.text"
-msgid "Split Cells"
-msgstr "Dividir celdas"
-
-#. omMdA
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"par_id3083451\n"
-"help.text"
-msgid "<ahelp hid=\".\">Splits previously merged cells.</ahelp>"
-msgstr "<ahelp hid=\".\">Divide celdas combinadas previamente.</ahelp>"
-
-#. ic7Vk
-#: 05100200.xhp
-msgctxt ""
-"05100200.xhp\n"
-"par_id3154023\n"
-"help.text"
-msgid "Choose <emph>Format - Merge Cells - Split Cells</emph>"
-msgstr "Elija <emph>Formato ▸ Combinar celdas ▸ Dividir celdas</emph>"
-
 #. MiWuG
 #: 05110000.xhp
 msgctxt ""
@@ -48688,22 +48706,22 @@ msgctxt ""
 msgid "<ahelp hid=\"modules/scalc/ui/sortoptionspage/leftright\"> Sorts columns by the values in the active rows of the selected range.</ahelp>"
 msgstr "<ahelp hid=\"modules/scalc/ui/sortoptionspage/leftright\">Ordena las columnas según los valores de las filas activas del intervalo seleccionado.</ahelp>"
 
-#. a8dw2
+#. MzEHk
 #: 12040000.xhp
 msgctxt ""
 "12040000.xhp\n"
 "tit\n"
 "help.text"
-msgid "Filter"
-msgstr "Filtro"
+msgid "More Filters"
+msgstr ""
 
-#. A3xBE
+#. EtYTd
 #: 12040000.xhp
 msgctxt ""
 "12040000.xhp\n"
 "hd_id3150767\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">Filters</link>"
+msgid "<link href=\"text/scalc/01/12040000.xhp\" name=\"Filter\">More Filters</link>"
 msgstr ""
 
 #. PgpNB
@@ -48715,14 +48733,14 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Shows commands to filter your data.</ahelp>"
 msgstr "<ahelp hid=\".\">Muestra órdenes para filtrar sus datos.</ahelp>"
 
-#. ipXuZ
+#. nGCni
 #: 12040000.xhp
 msgctxt ""
 "12040000.xhp\n"
-"par_id3146119\n"
+"par_id911633127394220\n"
 "help.text"
-msgid "$[officename] automatically recognizes predefined database ranges."
-msgstr "$[officename] reconoce automáticamente las áreas de base de datos predefinidas."
+msgid "%PRODUCTNAME automatically recognizes predefined database ranges."
+msgstr ""
 
 #. 7khnq
 #: 12040000.xhp
@@ -53240,7 +53258,7 @@ msgctxt ""
 "par_id3153379\n"
 "help.text"
 msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Defines the error message that is displayed when invalid data is entered in a cell.</ahelp>"
-msgstr ""
+msgstr "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Permite definir el mensaje de error que se debe mostrar cuando se introducen datos incorrectos en una celda.</ahelp>"
 
 #. CqYXY
 #: 12120300.xhp
@@ -63545,7 +63563,7 @@ msgctxt ""
 "par_id3154819\n"
 "help.text"
 msgid "<emph>Text</emph> is a string that contains the number to be converted."
-msgstr ""
+msgstr "<emph>Texto</emph> es una cadena de caracteres que contiene el número que se va a convertir."
 
 #. gwZ7A
 #: func_numbervalue.xhp
@@ -67183,14 +67201,14 @@ msgctxt ""
 msgid "Live Data Stream"
 msgstr "Flujo de datos en directo"
 
-#. iithi
+#. GvEyi
 #: live_data_stream.xhp
 msgctxt ""
 "live_data_stream.xhp\n"
 "bm_id240920171018528200\n"
 "help.text"
-msgid "<bookmark_value>Data Stream;Live data stream</bookmark_value>"
-msgstr "<bookmark_value>flujo de datos;flujo de datos en directo</bookmark_value>"
+msgid "<bookmark_value>Data Stream;Live data stream</bookmark_value>    <bookmark_value>Data Stream;Streams</bookmark_value>"
+msgstr ""
 
 #. bn3r4
 #: live_data_stream.xhp
@@ -67201,32 +67219,32 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/live_data_stream.xhp\">Live Data Stream</link>"
 msgstr "<link href=\"text/scalc/01/live_data_stream.xhp\">Flujo de datos en directo</link>"
 
-#. mND9J
+#. mB9BH
 #: live_data_stream.xhp
 msgctxt ""
 "live_data_stream.xhp\n"
 "par_id240920171003293400\n"
 "help.text"
-msgid "<ahelp hid=\".\">Live data stream for spreadsheets</ahelp>"
-msgstr "<ahelp hid=\".\">Flujos de datos en directo para hojas de cálculo</ahelp>"
+msgid "<ahelp hid=\".\"><variable id=\"streams_desc\">Create live data streams for spreadsheets.</variable></ahelp>"
+msgstr ""
 
-#. DBAjA
+#. Zsu3z
 #: live_data_stream.xhp
 msgctxt ""
 "live_data_stream.xhp\n"
 "par_id240920171007389295\n"
 "help.text"
-msgid "Menu <item type=\"menuitem\">Data – Streams...</item>"
-msgstr "Vaya a <item type=\"menuitem\">Datos ▸ Flujos</item>"
+msgid "Menu <menuitem>Data – Streams...</menuitem>"
+msgstr ""
 
-#. FYDzo
+#. JT47J
 #: live_data_stream.xhp
 msgctxt ""
 "live_data_stream.xhp\n"
-"par_id240920171007419799\n"
+"par_id921633126951835\n"
 "help.text"
-msgid "Data streams"
-msgstr "Flujos de datos"
+msgid "This is an experimental feature and is disabled by default. To enable it, go to <menuitem>Tools - Options - Advanced</menuitem>  and check the option <emph>Enable experimental features (may be unstable)</emph>."
+msgstr ""
 
 #. k7H5Y
 #: solver.xhp