update translations for 7.0.0 rc1

and force-fix errors using pocheck

Change-Id: I3015e0155d85f8a7cf7c0b18c2e70a6a2f145dd5
(cherry picked from commit cae548d4c0456d970b8deb8f2639f30c9fabe98f)

1 files changed, 92 insertions, 20 deletions

diff --git a/source/gug/helpcontent2/source/text/scalc/02.po b/source/gug/helpcontent2/source/text/scalc/02.po
index 6245c487dbf..fc14505ebf0 100644
--- a/source/gug/helpcontent2/source/text/scalc/02.po
+++ b/source/gug/helpcontent2/source/text/scalc/02.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2020-01-07 14:09+0100\n"
+"POT-Creation-Date: 2020-06-29 13:08+0200\n"
 "PO-Revision-Date: 2020-05-27 09:52+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Spanish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc02/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 3.10.3\n"
+"X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1548569336.000000\n"
 
 #. aSE5T
@@ -394,59 +394,131 @@ msgctxt ""
 msgid "<bookmark_value>functions;sum function icon</bookmark_value>         <bookmark_value>formula bar;sum function</bookmark_value>         <bookmark_value>sum icon</bookmark_value>         <bookmark_value>AutoSum button, see sum icon</bookmark_value>"
 msgstr "<bookmark_value>funciones;icono de la función de suma</bookmark_value><bookmark_value>barra de fórmulas;función de suma</bookmark_value><bookmark_value>icono de suma</bookmark_value><bookmark_value>botón Autosuma, vea icono de suma</bookmark_value>"
 
-#. EUeEf
+#. vYDYK
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "hd_id3157909\n"
 "help.text"
-msgid "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Sum</link>"
-msgstr "<link href=\"text/scalc/02/06030000.xhp\" name=\"Suma\">Suma</link>"
+msgid "<link href=\"text/scalc/02/06030000.xhp\" name=\"Sum\">Select Function</link>"
+msgstr ""
 
-#. M5UpW
+#. KEkiG
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "par_id3150543\n"
 "help.text"
-msgid "<ahelp hid=\"HID_INSWIN_SUMME\">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp>"
-msgstr "<ahelp hid=\"HID_INSWIN_SUMME\">Inserta la suma de un intervalo de celdas en la celda actual o inserta los valores de las sumas en las celdas seleccionadas. Pulse en una celda, luego en este icono y, si lo prefiere, ajuste el intervalo de celdas. O bien, seleccione algunas celdas donde insertar los valores de la suma y luego pulse en el icono.</ahelp>"
+msgid "<ahelp hid=\"HID_INSWIN_SUMME\">Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range.</ahelp>"
+msgstr ""
 
-#. urwhB
+#. KDxsW
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "par_id3153770\n"
 "help.text"
-msgid "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3147434\">Icon</alt></image>"
-msgstr "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3147434\">Icono</alt></image>"
+msgid "<image id=\"img_id3147434\" src=\"cmd/sc_autosum.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3147434\">Icon Select Function</alt></image>"
+msgstr ""
 
-#. hfmVm
+#. DaEgA
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "par_id3152577\n"
 "help.text"
-msgid "Sum"
-msgstr "Suma"
+msgid "Select Function"
+msgstr ""
 
-#. DEYk8
+#. SpBhw
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"hd_id161592658402954\n"
+"help.text"
+msgid "Select Function applied with no selected range"
+msgstr ""
+
+#. 59eGX
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "par_id3156444\n"
 "help.text"
-msgid "$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function."
-msgstr "$[officename] sugiere automáticamente un área de celdas, siempre que la hoja de cálculo contenga datos. Si el área de celdas ya contiene una función de suma, se puede combinar con la nueva función para obtener la suma total del área. Si el área contiene filtros, se inserta la función Subtotal en lugar de la función Suma."
+msgid "$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function."
+msgstr ""
 
-#. HRZZS
+#. vpnqf
 #: 06030000.xhp
 msgctxt ""
 "06030000.xhp\n"
 "par_id3153189\n"
 "help.text"
-msgid "Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line."
-msgstr "Pulse en el icono <emph>Aceptar</emph> (marca de verificación verde) para utilizar la fórmula mostrada en la línea de entrada."
+msgid "Click the <emph>Accept</emph> icon to use the formula displayed in the input line or <emph>Cancel</emph>."
+msgstr ""
+
+#. TVD6h
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id231592663499228\n"
+"help.text"
+msgid "<image src=\"cmd/sc_ok.svg\" id=\"img_id521592663499228\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id171592663499228\">Accept Icon</alt></image>"
+msgstr ""
+
+#. iHTEW
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id481592663499228\n"
+"help.text"
+msgid "Accept"
+msgstr ""
+
+#. VFj6u
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id311592663828848\n"
+"help.text"
+msgid "<image src=\"cmd/sc_cancel.svg\" id=\"img_id641592663828848\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id111592663828848\">Icon Cancel</alt></image>"
+msgstr ""
+
+#. 7xGcL
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id431592663828848\n"
+"help.text"
+msgid "Cancel"
+msgstr ""
+
+#. GPtKR
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"hd_id261592658395518\n"
+"help.text"
+msgid "Select Function applied on a selected range"
+msgstr ""
+
+#. JPrPQ
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id911592658130888\n"
+"help.text"
+msgid "When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column."
+msgstr ""
+
+#. iHksB
+#: 06030000.xhp
+msgctxt ""
+"06030000.xhp\n"
+"par_id991592658144387\n"
+"help.text"
+msgid "When the selected range has one row, the function result is placed in the first available cell on the right of the selected range."
+msgstr ""
 
 #. NYGR7
 #: 06040000.xhp