update translations for master/7.1.0 rc1

and force-fix errors using pocheck

Change-Id: I64d1494dbed7adfa393e79f9b798725ad8c68350

3 files changed, 116 insertions, 98 deletions

diff --git a/source/es/helpcontent2/source/text/scalc/01.po b/source/es/helpcontent2/source/text/scalc/01.po
index d38974c03d3..daa086e8adb 100644
--- a/source/es/helpcontent2/source/text/scalc/01.po
+++ b/source/es/helpcontent2/source/text/scalc/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: 2020-11-20 15:33+0100\n"
-"PO-Revision-Date: 2020-12-05 20:36+0000\n"
+"PO-Revision-Date: 2020-12-11 20:36+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Spanish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/es/>\n"
 "Language: es\n"
@@ -52556,7 +52556,7 @@ msgctxt ""
 "par_id3156327\n"
 "help.text"
 msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage\">Specify the validation rules for the selected cell(s).</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage\">Especifique las reglas de validación de la celda(s) seleccionada.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage\">Especifique las reglas de validación de las celdas seleccionadas.</ahelp>"
 
 #. kWDG3
 #: 12120100.xhp
diff --git a/source/es/helpcontent2/source/text/scalc/04.po b/source/es/helpcontent2/source/text/scalc/04.po
index d3e5261206b..f1b4e1f5286 100644
--- a/source/es/helpcontent2/source/text/scalc/04.po
+++ b/source/es/helpcontent2/source/text/scalc/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: 2020-02-17 12:22+0100\n"
-"PO-Revision-Date: 2020-09-10 05:35+0000\n"
+"PO-Revision-Date: 2020-12-15 12:51+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Spanish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc04/es/>\n"
 "Language: es\n"
@@ -1238,7 +1238,7 @@ msgctxt ""
 "hd_id3147492\n"
 "help.text"
 msgid "Shortcut Keys"
-msgstr "Teclas de atajo"
+msgstr "Atajos de teclado"
 
 #. GB6qD
 #: 01020000.xhp
@@ -1265,7 +1265,7 @@ msgctxt ""
 "par_id3149197\n"
 "help.text"
 msgid "Open Format Cells dialog"
-msgstr "Abre el dialogo de formato de celdas"
+msgstr "Abrir el cuadro de diálogo Formato de celdas"
 
 #. XxnqH
 #: 01020000.xhp
@@ -1391,7 +1391,7 @@ msgctxt ""
 "par_id631581375238556\n"
 "help.text"
 msgid "The shortcut keys below are for the <emph>Pivot Table Layout</emph> dialog."
-msgstr ""
+msgstr "Los atajos de teclado siguientes corresponden al cuadro de diálogo <emph>Disposición de tabla dinámica</emph>."
 
 #. dRGGD
 #: 01020000.xhp
@@ -1454,7 +1454,7 @@ msgctxt ""
 "hd_id3148484\n"
 "help.text"
 msgid "<keycode>Up Arrow</keycode>"
-msgstr ""
+msgstr "<keycode>↑</keycode>"
 
 #. jWNGS
 #: 01020000.xhp
@@ -1472,7 +1472,7 @@ msgctxt ""
 "hd_id3154273\n"
 "help.text"
 msgid "<keycode>Down Arrow</keycode>"
-msgstr ""
+msgstr "<keycode>↓</keycode>"
 
 #. g3pGx
 #: 01020000.xhp
@@ -1490,7 +1490,7 @@ msgctxt ""
 "hd_id3148912\n"
 "help.text"
 msgid "<keycode>Left Arrow</keycode>"
-msgstr ""
+msgstr "<keycode>←</keycode>"
 
 #. dEqdi
 #: 01020000.xhp
@@ -1508,7 +1508,7 @@ msgctxt ""
 "hd_id3150712\n"
 "help.text"
 msgid "<keycode>Right Arrow</keycode>"
-msgstr ""
+msgstr "<keycode>→</keycode>"
 
 #. DKiGb
 #: 01020000.xhp
@@ -1526,7 +1526,7 @@ msgctxt ""
 "hd_id3146947\n"
 "help.text"
 msgid "<keycode>Home</keycode>"
-msgstr ""
+msgstr "<keycode>Inicio</keycode>"
 
 #. 2myZF
 #: 01020000.xhp
@@ -1544,7 +1544,7 @@ msgctxt ""
 "hd_id3153387\n"
 "help.text"
 msgid "<keycode>End</keycode>"
-msgstr ""
+msgstr "<keycode>Fin</keycode>"
 
 #. RhFGF
 #: 01020000.xhp
@@ -1571,7 +1571,7 @@ msgctxt ""
 "par_id3152949\n"
 "help.text"
 msgid "Copies or moves the current field into the \"Row Fields\" area."
-msgstr ""
+msgstr "Copia o mueve el campo actual hacia el área «Campos de fila»."
 
 #. qFSYZ
 #: 01020000.xhp
@@ -1589,7 +1589,7 @@ msgctxt ""
 "par_id3149968\n"
 "help.text"
 msgid "Copies or moves the current field into the \"Column Fields\" area."
-msgstr ""
+msgstr "Copia o mueve el campo actual hacia el área «Campos de columna»."
 
 #. wGVoz
 #: 01020000.xhp
@@ -1607,7 +1607,7 @@ msgctxt ""
 "par_id3148649\n"
 "help.text"
 msgid "Copies or moves the current field into the \"Data Fields\" area."
-msgstr ""
+msgstr "Copia o mueve el campo actual hacia el área «Campos de datos»."
 
 #. raCg3
 #: 01020000.xhp
@@ -1625,7 +1625,7 @@ msgctxt ""
 "par_id3144649\n"
 "help.text"
 msgid "Copies or moves the current field into the \"Filters\" area."
-msgstr ""
+msgstr "Copia o mueve el campo actual hacia el área «Filtros»."
 
 #. RBfHn
 #: 01020000.xhp
diff --git a/source/es/helpcontent2/source/text/scalc/guide.po b/source/es/helpcontent2/source/text/scalc/guide.po
index 77a5487c7c3..02977f6247c 100644
--- a/source/es/helpcontent2/source/text/scalc/guide.po
+++ b/source/es/helpcontent2/source/text/scalc/guide.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: 2020-12-01 12:34+0100\n"
-"PO-Revision-Date: 2020-12-02 14:36+0000\n"
+"POT-Creation-Date: 2020-12-14 15:33+0100\n"
+"PO-Revision-Date: 2020-12-15 12:51+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Spanish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/es/>\n"
 "Language: es\n"
@@ -10573,32 +10573,41 @@ msgctxt ""
 msgid "<variable id=\"rename_table\"><link href=\"text/scalc/guide/rename_table.xhp\" name=\"Renaming Sheets\">Renaming Sheets</link></variable>"
 msgstr "<variable id=\"rename_table\"><link href=\"text/scalc/guide/rename_table.xhp\" name=\"Cambiar el nombre de las hojas\">Cambiar el nombre de las hojas</link></variable>"
 
-#. wxAHr
+#. zEnG4
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id701519308848244\n"
 "help.text"
-msgid "Setting sheet names is an important feature to produce readable and understandable spreadsheets documents. To rename a sheet in your document:"
-msgstr "Establecer nombres a las hojas es un procedimiento importante para producir documentos legibles y fáciles de entender. Para cambiar el nombre de una hoja del libro:"
+msgid "Setting sheet names is an important feature to produce readable and understandable spreadsheets documents."
+msgstr ""
 
-#. KR8Ag
+#. DE2ji
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id3155131\n"
+"par_id3155444\n"
 "help.text"
-msgid "Click on the sheet tab to select it."
-msgstr "Pulse en la pestaña de la hoja para seleccionarla."
+msgid "The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file."
+msgstr "El nombre de cada hoja es independiente del del libro. El nombre del libro lo definirá cuando lo guarde por primera vez como un archivo."
 
-#. FQiK8
+#. rMuCd
+#: rename_table.xhp
+msgctxt ""
+"rename_table.xhp\n"
+"par_id471607437423400\n"
+"help.text"
+msgid "To rename a sheet in your document:"
+msgstr ""
+
+#. 99JMV
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id3146976\n"
 "help.text"
-msgid "Open the context menu of the sheet tab and choose the <emph>Rename Sheet</emph> command. A dialog box appears where you can enter a new name."
-msgstr "Abra el menú contextual de la pestaña de la hoja y, a continuación, seleccione la opción <emph>Cambiar nombre de hoja</emph>. Aparecerá un cuadro de diálogo en el que podrá escribir un nombre nuevo."
+msgid "Double-click the sheet tab or open its context menu and choose <menuitem>Rename Sheet</menuitem>. A dialog box appears where you can enter a new name."
+msgstr ""
 
 #. GtGtQ
 #: rename_table.xhp
@@ -10618,6 +10627,24 @@ msgctxt ""
 msgid "Alternatively, hold down the <switchinline select=\"sys\"><caseinline select=\"MAC\">Option key</caseinline><defaultinline>Alt key</defaultinline></switchinline> and click on any sheet name and enter the new name directly."
 msgstr "Otra posibilidad es mantener oprimida la tecla <switchinline select=\"sys\"><caseinline select=\"MAC\">⌥</caseinline><defaultinline>Alt</defaultinline></switchinline>, pulsar en el nombre de cualquier hoja y escribir directamente el nombre nuevo."
 
+#. FUXLc
+#: rename_table.xhp
+msgctxt ""
+"rename_table.xhp\n"
+"par_id471519308256437\n"
+"help.text"
+msgid "The document can contain up to 10,000 individual sheets, which must have different names."
+msgstr "El documento puede contener hasta 10 000 hojas individuales, las cuales deben tener nombres diferentes."
+
+#. VDtVj
+#: rename_table.xhp
+msgctxt ""
+"rename_table.xhp\n"
+"hd_id541607437294635\n"
+"help.text"
+msgid "Sheet Naming Restrictions"
+msgstr ""
+
 #. ynfez
 #: rename_table.xhp
 msgctxt ""
@@ -10627,158 +10654,140 @@ msgctxt ""
 msgid "Sheet names can contain almost any character. Some naming restrictions apply, the following characters are not allowed in sheet names:"
 msgstr "Los nombres de las hojas pueden contener casi cualquier carácter. Sin embargo, se aplican algunas restricciones; los caracteres siguientes están prohibidos:"
 
-#. vjFiR
+#. GW256
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id090920081050281\n"
 "help.text"
-msgid "colon :"
-msgstr "dos puntos :"
+msgid "colon <literal>:</literal>"
+msgstr ""
 
-#. Q8bUX
+#. a2JXE
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id0909200810502897\n"
 "help.text"
-msgid "back slash \\"
-msgstr "contrabarra \\"
+msgid "back slash <literal>\\</literal>"
+msgstr ""
 
-#. nzDQF
+#. mkHAC
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id090920081050299\n"
 "help.text"
-msgid "forward slash /"
-msgstr "barra /"
+msgid "forward slash <literal>/</literal>"
+msgstr ""
 
-#. C2KDM
+#. V9Z6i
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id0909200810502913\n"
 "help.text"
-msgid "question mark ?"
-msgstr "signo de interrogación ?"
+msgid "question mark <literal>?</literal>"
+msgstr ""
 
-#. MThFN
+#. 42B5r
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id090920081050298\n"
 "help.text"
-msgid "asterisk *"
-msgstr "asterisco *"
+msgid "asterisk <literal>*</literal>"
+msgstr ""
 
-#. MFpgr
+#. sAMTR
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id0909200810502969\n"
 "help.text"
-msgid "left square bracket ["
-msgstr "corchete izquierdo ["
+msgid "left square bracket <literal>[</literal>"
+msgstr ""
 
-#. ayMFC
+#. 32rAi
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id0909200810502910\n"
 "help.text"
-msgid "right square bracket ]"
-msgstr "corchete derecho ]"
+msgid "right square bracket <literal>]</literal>"
+msgstr ""
 
-#. DYGBS
+#. ESD5B
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
 "par_id0909200810502971\n"
 "help.text"
-msgid "single quote ' as the first or last character of the name"
-msgstr "comilla simple ' como primer o último caracter de un nombre"
-
-#. zqVm4
-#: rename_table.xhp
-msgctxt ""
-"rename_table.xhp\n"
-"par_id090920081050307\n"
-"help.text"
-msgid "In cell references, a sheet name must be enclosed in single quotes ' when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes)."
-msgstr "En las referencias de celdas, un nombre de hoja debe estar encerrado entre comillas simples «'» si el nombre contiene caracteres distintos de los alfanuméricos o guiones bajos. Asimismo, si el nombre de la hoja contiene un apóstrofo (recto), este debe escaparse duplicándolo."
-
-#. uPNL7
-#: rename_table.xhp
-msgctxt ""
-"rename_table.xhp\n"
-"par_id321519307869857\n"
-"help.text"
-msgid "For example, you want to reference the cell A1 on a sheet with the following name:"
-msgstr "Por ejemplo, si quiere hacer referencia a la celda A1 de una hoja que se denomina:"
+msgid "single quote <literal>'</literal> as the first or last character of the name"
+msgstr ""
 
-#. 4DECe
+#. 36nvo
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id0909200810503071\n"
+"par_id761607437686157\n"
 "help.text"
-msgid "This year's sheet"
-msgstr "Visitas a Sian Ka'an"
+msgid "The single quote is Unicode <literal>U+0027</literal>, also known as <literal>apostrophe</literal>. Other single-quote characters, similar to <literal>apostrophe</literal>, are allowed, such as <literal>ʼ</literal> <literal>‛</literal> and <literal>‚</literal>."
+msgstr ""
 
-#. c3VAE
+#. DMm29
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id0909200810503054\n"
+"hd_id251607438968588\n"
 "help.text"
-msgid "The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled:"
-msgstr "La referencia se debe encerrar en comillas simples, y el apóstrofo en el nombre debe duplicarse:"
+msgid "Using a Default Prefix for Sheet Names"
+msgstr "Utilizar un prefijo predeterminado para los nombres de las hojas"
 
-#. F2TyQ
+#. MEc8r
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id0909200810503069\n"
+"par_id81519309108908\n"
 "help.text"
-msgid "'This year''s sheet'.A1"
-msgstr "'Visitas a Sian Ka''an'.A1"
+msgid "You can set a prefix for the names of new sheets you create. Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Defaults</menuitem> and enter the prefix name in <emph>Prefix name for new worksheet</emph>."
+msgstr ""
 
-#. DE2ji
+#. Ev9Ae
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id3155444\n"
+"hd_id821607437571713\n"
 "help.text"
-msgid "The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file."
-msgstr "El nombre de cada hoja es independiente del del libro. El nombre del libro lo definirá cuando lo guarde por primera vez como un archivo."
+msgid "Referencing Sheet Names with Special Characters"
+msgstr "Hacer referencia a nombres de hojas con caracteres especiales"
 
-#. FUXLc
+#. BAZ4z
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id471519308256437\n"
+"par_id090920081050307\n"
 "help.text"
-msgid "The document can contain up to 10,000 individual sheets, which must have different names."
-msgstr "El documento puede contener hasta 10 000 hojas individuales, las cuales deben tener nombres diferentes."
+msgid "In cell references, a sheet name must be enclosed in single quotes <literal>'</literal> when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes)."
+msgstr ""
 
-#. vkB9b
+#. ZjbDT
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id81519309108908\n"
+"par_id321519307869857\n"
 "help.text"
-msgid "You can set a prefix for the names of new sheets you create. See <link href=\"text/shared/optionen/01061000.xhp\" name=\"prefix names\">this page of Calc options.</link>"
-msgstr "Puede determinar un prefijo para los nombres de las hojas nuevas que vaya creando. Vea <link href=\"text/shared/optionen/01061000.xhp\" name=\"prefijar nombres\">esta página de opciones de Calc</link>."
+msgid "For example, you want to reference the <literal>cell A1</literal> on a sheet named <literal>This year's sheet</literal>."
+msgstr ""
 
-#. de9uD
+#. tAj5V
 #: rename_table.xhp
 msgctxt ""
 "rename_table.xhp\n"
-"par_id81519379108908\n"
+"par_id0909200810503054\n"
 "help.text"
-msgid "<link href=\"text/shared/optionen/01061000.xhp\" name=\"prefix names\">New sheet names prefixing.</link>"
-msgstr "<link href=\"text/shared/optionen/01061000.xhp\" name=\"prefix names\">Prefijación de nombres de hojas de cálculo nuevas</link>"
+msgid "The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled: <literal>'This year''s sheet'.A1</literal>"
+msgstr ""
 
 #. bwZRy
 #: rounding_numbers.xhp
@@ -12508,6 +12517,15 @@ msgctxt ""
 msgid "In <emph>Format - Cells - Alignment</emph>, mark the <emph>Wrap text automatically</emph> option and click OK."
 msgstr "En <emph>Formato ▸ Celdas ▸ Alineación</emph> seleccione la opción <emph>Ajustar texto automáticamente</emph> y pulse en Aceptar."
 
+#. Vf66T
+#: text_wrap.xhp
+msgctxt ""
+"text_wrap.xhp\n"
+"note_xls_optimal_height\n"
+"help.text"
+msgid "For automatic wrapping in XLS files, the rows in question should be set to Optimal Height."
+msgstr ""
+
 #. pED9m
 #: text_wrap.xhp
 msgctxt ""