update translations for master/7.4

and force-fix errors using pocheck

Change-Id: I6791c0fed18c372d154a25de9c826720bb037af8

10 files changed, 704 insertions, 335 deletions

diff --git a/source/pt/helpcontent2/source/text/sbasic/shared.po b/source/pt/helpcontent2/source/text/sbasic/shared.po
index 8e873da3813..d37b0dbbbb2 100644
--- a/source/pt/helpcontent2/source/text/sbasic/shared.po
+++ b/source/pt/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-10 20:16+0200\n"
+"POT-Creation-Date: 2022-05-25 12:36+0200\n"
 "PO-Revision-Date: 2021-06-04 11:14+0000\n"
 "Last-Translator: Carlos Moreira <crolidge@hotmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/pt/>\n"
@@ -10807,32 +10807,32 @@ msgctxt ""
 msgid "Returns the size of an open file in bytes."
 msgstr "Devolve o tamanho de um ficheiro aberto em bytes."
 
-#. 43MqD
+#. D84bA
 #: 03020303.xhp
 msgctxt ""
 "03020303.xhp\n"
 "par_id3150359\n"
 "help.text"
-msgid "Lof (FileNumber)"
-msgstr "Lof (NumFicheiro)"
+msgid "Lof (FileNumber) As Long"
+msgstr ""
 
-#. BBamj
+#. 6oGoB
 #: 03020303.xhp
 msgctxt ""
 "03020303.xhp\n"
 "par_id3150869\n"
 "help.text"
-msgid "<emph>FileNumber:</emph> Any numeric expression that contains the file number that is specified in the Open statement."
-msgstr "<emph>NumFicheiro:</emph> qualquer expressão numérica que contenha o número de ficheiro especificado na instrução Open."
+msgid "<emph>FileNumber:</emph> Any numeric expression that contains the file number that is specified in the <literal>Open</literal> statement."
+msgstr ""
 
-#. vTRvK
+#. EAe7H
 #: 03020303.xhp
 msgctxt ""
 "03020303.xhp\n"
 "par_id3147349\n"
 "help.text"
-msgid "To obtain the length of a file that is not open, use the <emph>FileLen</emph> function."
-msgstr "Para obter o comprimento de um ficheiro que não esteja aberto, utilize a função <emph>FileLen</emph>."
+msgid "To obtain the length of a file that is not open, use the <link href=\"text/sbasic/shared/03020408.xhp\" name=\"FileLen function\"><literal>FileLen</literal></link> function."
+msgstr ""
 
 #. AGL3X
 #: 03020304.xhp
@@ -11869,41 +11869,14 @@ msgctxt ""
 msgid "Returns the length of a file in bytes."
 msgstr "Devolve o comprimento de um ficheiro em bytes."
 
-#. GfNg3
+#. RpGc5
 #: 03020408.xhp
 msgctxt ""
 "03020408.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaxe:"
-
-#. MoBSd
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3149656\n"
+"par_id401651744449325\n"
 "help.text"
-msgid "FileLen (Text As String)"
-msgstr "FileLen (Texto As String)"
-
-#. LVwBo
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valor de retorno:"
-
-#. H2KXW
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3150768\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parâmetros:"
+msgid "Use <link href=\"text/sbasic/shared/03/sf_filesystem.xhp\" name=\"ScriptForge.FileSystem service\">ScriptForge.FileSystem</link> service <link href=\"text/sbasic/shared/03/sf_filesystem.xhp#GetFileLen\" name=\"GetFileLen method\">GetFileLen()</link> method when size is expected to be over 2 gigabytes."
+msgstr ""
 
 #. Fo2XH
 #: 03020408.xhp
@@ -11914,23 +11887,14 @@ msgctxt ""
 msgid "<emph>Text:</emph> Any string expression that contains an unambiguous file specification. You can also use <link href=\"text/sbasic/shared/00000002.xhp\" name=\"URL notation\">URL notation</link>."
 msgstr "<emph>Texto:</emph> qualquer expressão em caracteres que contenha uma especificação do ficheiro inequívoca. É também possível utilizar a <link href=\"text/sbasic/shared/00000002.xhp\" name=\"URL notation\">notação URL</link>."
 
-#. SCB9u
+#. 7RtHj
 #: 03020408.xhp
 msgctxt ""
 "03020408.xhp\n"
 "par_id3150439\n"
 "help.text"
-msgid "This function determines the length of a file. If the FileLen function is called for an open file, it returns the file length before it was opened. To determine the current file length of an open file, use the Lof function."
-msgstr "Esta função determina o comprimento de um ficheiro. Se a função FileLen for chamada para um ficheiro aberto, ela devolve o comprimento do ficheiro antes deste ser aberto. Para determinar o comprimento atual de um ficheiro, utilize a função Lof."
-
-#. j8DBv
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3163710\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemplo:"
+msgid "This function determines the length of a file. If the <literal>FileLen</literal> function is called for an open file, it returns the file length before it was opened. To determine the current file length of an open file, use the <link href=\"text/sbasic/shared/03020303.xhp\" name=\"Lof function\"><literal>Lof</literal></link> function."
+msgstr ""
 
 #. FerKv
 #: 03020409.xhp
@@ -24982,59 +24946,14 @@ msgctxt ""
 msgid "Converts any numerical expression or string expression to a double type."
 msgstr "Converte qualquer expressão numérica ou em caracteres num tipo duplo."
 
-#. jjGQH
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax"
-msgstr "Sintaxe"
-
-#. aTHD8
+#. wEVGF
 #: 03100400.xhp
 msgctxt ""
 "03100400.xhp\n"
 "par_id3156152\n"
 "help.text"
-msgid "CDbl (Expression)"
-msgstr "CDbl (Expressão)"
-
-#. 38G4w
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3153061\n"
-"help.text"
-msgid "Return value"
-msgstr "Valor de retorno"
-
-#. LM9Ye
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parâmetros:"
-
-#. DVRKM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"par_id3153897\n"
-"help.text"
-msgid "<emph>Expression:</emph> Any string or numeric expression that you want to convert. To convert a string expression, the number must be entered as normal text (\"123.5\") using the default number format of your operating system."
-msgstr "<emph>Expressão:</emph> qualquer cadeia ou expressão numérica que pretende converter. Para converter uma expressão em caracteres, o número deverá ser inserido como texto normal (\"123.5\") utilizando o formato de número padrão do seu sistema operativo."
-
-#. HxfeM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3148797\n"
-"help.text"
-msgid "Example:"
-msgstr "Exemplo:"
+msgid "CDbl (Expression As Variant) As Double"
+msgstr ""
 
 #. Hs9F5
 #: 03100500.xhp
@@ -25072,58 +24991,13 @@ msgctxt ""
 msgid "Converts any string or numeric expression to an integer."
 msgstr "Converte qualquer cadeia ou expressão numérica num número inteiro."
 
-#. AFSBH
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147573\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaxe:"
-
-#. ZGxYP
+#. CCHrN
 #: 03100500.xhp
 msgctxt ""
 "03100500.xhp\n"
 "par_id3154142\n"
 "help.text"
-msgid "CInt (Expression)"
-msgstr "CInt (Expressão)"
-
-#. AQaNC
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147531\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valor de retorno:"
-
-#. a2YC7
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3145069\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parâmetros:"
-
-#. 94dPA
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"par_id3159414\n"
-"help.text"
-msgid "<emph>Expression:</emph> Any expression that you want to convert."
-msgstr ""
-
-#. tSQka
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"par_id3159415\n"
-"help.text"
-msgid "If the argument is a number, it is used as numeric value of the expression."
+msgid "CInt (Expression As Variant) As Integer"
 msgstr ""
 
 #. UnfBB
@@ -25234,50 +25108,23 @@ msgctxt ""
 msgid "Converts any string or numeric expression to a long integer."
 msgstr "Converte qualquer cadeia de texto ou expressão numérica num número inteiro longo."
 
-#. CtL6e
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaxe:"
-
-#. 3HnrW
+#. 8aFmF
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "par_id3147573\n"
 "help.text"
-msgid "CLng (Expression)"
-msgstr "CLng (Expressão)"
-
-#. iViY7
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145610\n"
-"help.text"
-msgid "Return value:"
-msgstr "Valor de retorno:"
-
-#. pC3ZX
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parâmetros:"
+msgid "CLng (Expression As Variant) As Long"
+msgstr ""
 
-#. kyujG
+#. HDHVW
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "par_id3159414\n"
 "help.text"
-msgid "<emph>Expression:</emph> Any numerical expression that you want to convert. If the <emph>Expression</emph> lies outside the valid long integer range between -2.147.483.648 and 2.147.483.647, $[officename] Basic returns an overflow error. To convert a string expression, the number must be entered as normal text (\"123.5\") using the default number format of your operating system."
-msgstr "<emph>Expressão:</emph> qualquer expressão numérica que deseje converter. Se a <emph>Expressão</emph> estiver fora do intervalo válido do número inteiro longo entre -2.147.483.648 e 2.147.483.647, o $[officename] Basic devolve um erro de excesso de capacidade. Para converter uma expressão em cadeia, o número deverá ser inserido como texto normal (\"123.5\") utilizando o formato de número padrão do seu sistema operativo."
+msgid "If <literal>Expression</literal> lies outside the valid long integer range between -2.147.483.648 and 2.147.483.647, $[officename] Basic returns an overflow error."
+msgstr ""
 
 #. hgEwt
 #: 03100600.xhp
@@ -25513,59 +25360,68 @@ msgctxt ""
 msgid "Converts any string or numeric expression to data type Single."
 msgstr "Converte qualquer cadeia de texto ou expressão numérica num tipo de dados Individual."
 
-#. BNPsA
+#. dQQAS
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3153255\n"
+"par_id3148983\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaxe:"
+msgid "CSng (Expression As Variant) As Single"
+msgstr ""
 
-#. JxpvM
+#. ZodWe
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"par_id3148983\n"
+"par_id3153897\n"
 "help.text"
-msgid "CSng (Expression)"
-msgstr "CSng (Expressão)"
+msgid "<emph>Expression</emph>: Any string or numeric expression that you want to convert. To convert a string expression, the number must be entered using a dot \".\" as the decimal point and a comma \",\" as the thousands separator (for instance 123,456.78), which may differ from your %PRODUCTNAME <link href=\"text/shared/optionen/01140000.xhp\" name=\"language settings\">language settings</link>."
+msgstr ""
 
-#. FR3tS
+#. 6CgWz
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3152347\n"
+"par_id761652451117906\n"
 "help.text"
-msgid "Return value:"
-msgstr "Valor de retorno:"
+msgid "Numeric expressions are displayed according %PRODUCTNAME <link href=\"text/shared/optionen/01140000.xhp\" name=\"language settings\">language settings</link>:"
+msgstr ""
 
-#. cSsM4
+#. DirnZ
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3146957\n"
+"par_idm1341608224\n"
 "help.text"
-msgid "Parameters:"
-msgstr "Parâmetros:"
+msgid "MsgBox CDbl(1234.5678) ' 1234.5678"
+msgstr ""
 
-#. XEQKF
+#. BoiF4
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"par_id3153345\n"
+"par_idm1341604480\n"
+"help.text"
+msgid "MsgBox CSng(1234.5678) ' 1234.567749023"
+msgstr ""
+
+#. rf5Br
+#: 03100900.xhp
+msgctxt ""
+"03100900.xhp\n"
+"par_idm1341608242\n"
 "help.text"
-msgid "<emph>Expression:</emph> Any string or numeric expression that you want to convert. To convert a string expression, the number must be entered as normal text (\"123.5\") using the default number format of your operating system."
-msgstr "<emph>Expressão:</emph> qualquer cadeia ou expressão numérica que pretende converter. Para converter uma expressão em caracteres, o número deverá ser inserido como texto normal (\"123.5\") utilizando o formato de número padrão do seu sistema operativo."
+msgid "MsgBox CDbl(expression := 5678.1234) ' 5678.1234"
+msgstr ""
 
-#. kT9UB
+#. uVUDG
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3149514\n"
+"par_idm1341604408\n"
 "help.text"
-msgid "Example:"
-msgstr "Exemplo:"
+msgid "MsgBox CSng(expression := 5678.1234) ' 5678.123535156"
+msgstr ""
 
 #. MCFBf
 #: 03101000.xhp
diff --git a/source/pt/helpcontent2/source/text/sbasic/shared/03.po b/source/pt/helpcontent2/source/text/sbasic/shared/03.po
index e27d32b5093..400c2956e5c 100644
--- a/source/pt/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/pt/helpcontent2/source/text/sbasic/shared/03.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: 2022-05-04 12:42+0200\n"
+"POT-Creation-Date: 2022-05-25 12:36+0200\n"
 "PO-Revision-Date: 2022-01-29 07:39+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/pt/>\n"
@@ -178,6 +178,15 @@ msgctxt ""
 msgid "ScriptForge libraries build up an extensible collection of macro scripting resources for %PRODUCTNAME to be invoked from Basic macros or Python scripts."
 msgstr ""
 
+#. fL8KK
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id901528999850603\n"
+"help.text"
+msgid "• Basic macros require to load <literal>ScriptForge</literal> library using the following statement:<br/><literal>GlobalScope.BasicLibraries.loadLibrary(\"ScriptForge\")</literal><br/><br/>• Python scripts require an import from <literal>scriptforge</literal> module:<br/><literal>from scriptforge import CreateScriptService</literal>"
+msgstr ""
+
 #. eotwE
 #: lib_ScriptForge.xhp
 msgctxt ""
@@ -5020,6 +5029,366 @@ msgctxt ""
 msgid "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string."
 msgstr ""
 
+#. JWFDb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id841592919903025\n"
+"help.text"
+msgid "Deletes the columns of a specified range that match a filter expressed as a Calc formula. The filter is applied to each column to decide whether it will be deleted or not."
+msgstr ""
+
+#. 4JWnp
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id601652269911029\n"
+"help.text"
+msgid "The deleted column can be limited to the height of the specified range or span to the height of the entire sheet, thus deleting whole columns."
+msgstr ""
+
+#. VAVU3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id701652271281106\n"
+"help.text"
+msgid "This method returns a string with the range address of the compacted range. If all columns are deleted, then an empty string is returned."
+msgstr ""
+
+#. j2GAb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id191652271892064\n"
+"help.text"
+msgid "If a range of cells is selected, calling this method will not impact the selection."
+msgstr ""
+
+#. WsrKe
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919922181\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which columns will be deleted, as a string."
+msgstr ""
+
+#. Q9QBp
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919932260\n"
+"help.text"
+msgid "<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>."
+msgstr ""
+
+#. M7qto
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919915974\n"
+"help.text"
+msgid "<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns."
+msgstr ""
+
+#. 8sYWa
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id361652271022647\n"
+"help.text"
+msgid "For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns."
+msgstr ""
+
+#. FDspT
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id941652271391005\n"
+"help.text"
+msgid "' Delete all empty columns in the range G1:L10 from Sheet1"
+msgstr ""
+
+#. huH9x
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id691652271390762\n"
+"help.text"
+msgid "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")"
+msgstr ""
+
+#. 2BkcC
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id921652271392627\n"
+"help.text"
+msgid "' The example below is similar, but the entire column is deleted from the sheet"
+msgstr ""
+
+#. 6GoCu
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id941652271392873\n"
+"help.text"
+msgid "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)"
+msgstr ""
+
+#. KfQRA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id751652271393226\n"
+"help.text"
+msgid "' Deletes all columns where the first row is marked with an \"X\""
+msgstr ""
+
+#. fLJ7y
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id761652271393514\n"
+"help.text"
+msgid "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")"
+msgstr ""
+
+#. UqpQB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id241652271725676\n"
+"help.text"
+msgid "' Deletes all columns where the sum of values in the column is odd"
+msgstr ""
+
+#. 5rxDM
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id531652271726131\n"
+"help.text"
+msgid "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")"
+msgstr ""
+
+#. i4ux6
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id451621536612334\n"
+"help.text"
+msgid "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")"
+msgstr ""
+
+#. j5kGd
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id201652272121176\n"
+"help.text"
+msgid "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)"
+msgstr ""
+
+#. pBca4
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id781652272122794\n"
+"help.text"
+msgid "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')"
+msgstr ""
+
+#. VGAj6
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id731652272123209\n"
+"help.text"
+msgid "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')"
+msgstr ""
+
+#. vqJ5B
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id841592919903699\n"
+"help.text"
+msgid "Deletes the rows of a specified range that match a filter expressed as a Calc formula. The filter is applied to each row to decide whether it will be deleted or not."
+msgstr ""
+
+#. RhiRD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id601652269910091\n"
+"help.text"
+msgid "The deleted rows can be limited to the width of the specified range or span to the width of the entire sheet, thus deleting whole rows."
+msgstr ""
+
+#. Yw3WB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id701652271283456\n"
+"help.text"
+msgid "This method returns a string with the range address of the compacted range. If all rows are deleted, then an empty string is returned."
+msgstr ""
+
+#. RtGtW
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id191652271893913\n"
+"help.text"
+msgid "If a range of cells is selected, calling this method will not impact the selection."
+msgstr ""
+
+#. X3Ekj
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919922080\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which rows will be deleted, as a string."
+msgstr ""
+
+#. sAtHM
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919921160\n"
+"help.text"
+msgid "<emph>wholerow</emph>: If this option is set to <literal>True</literal> the entire row will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted row will be limited to the width of the specified <literal>range</literal>."
+msgstr ""
+
+#. pKXWR
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id771592919926374\n"
+"help.text"
+msgid "<emph>filterformula</emph>: The filter to be applied to each row to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first row. When the formula returns <emph>True</emph> for a row, that row will be deleted. The default filter deletes all empty rows."
+msgstr ""
+
+#. 2DsWD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id361652271022681\n"
+"help.text"
+msgid "For example, suppose range <emph>A1:J200</emph> is selected (width = 10), so the default formula is <emph>=(COUNTBLANK(A1:J1)=10)</emph>. This means that if all 10 cells are empty in the first row (Row 1), then the row is deleted. Note that the formula is expressed with respect to the first row only. Internally the <literal>CompactUp</literal> method will generalize this formula for all the remaining rows."
+msgstr ""
+
+#. GuWzD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id941652271391554\n"
+"help.text"
+msgid "' Delete all empty rows in the range G1:L10 from Sheet1"
+msgstr ""
+
+#. GBrKx
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id691652271390789\n"
+"help.text"
+msgid "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")"
+msgstr ""
+
+#. FV3Ev
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id921652271392567\n"
+"help.text"
+msgid "' The example below is similar, but the entire row is deleted from the sheet"
+msgstr ""
+
+#. Y5YVh
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id941652271392553\n"
+"help.text"
+msgid "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)"
+msgstr ""
+
+#. mFqmA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id751652271393117\n"
+"help.text"
+msgid "' Deletes all rows where the first column is marked with an \"X\""
+msgstr ""
+
+#. gJQRm
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id761652271393034\n"
+"help.text"
+msgid "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")"
+msgstr ""
+
+#. DoDfJ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id241652271725065\n"
+"help.text"
+msgid "' Deletes all rows where the sum of values in the row is odd"
+msgstr ""
+
+#. zXErV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id531652271726010\n"
+"help.text"
+msgid "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")"
+msgstr ""
+
+#. Mcwq5
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id451621536612227\n"
+"help.text"
+msgid "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")"
+msgstr ""
+
+#. tXmJD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id201652272121288\n"
+"help.text"
+msgid "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)"
+msgstr ""
+
+#. WZ3XF
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id781652272122931\n"
+"help.text"
+msgid "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')"
+msgstr ""
+
+#. 4DfG9
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id731652272123109\n"
+"help.text"
+msgid "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')"
+msgstr ""
+
 #. n6vJD
 #: sf_calc.xhp
 msgctxt ""
@@ -9124,6 +9493,87 @@ msgctxt ""
 msgid "Python and %PRODUCTNAME Basic examples both assume that the dialog is stored in current document's <literal>Standard</literal> library."
 msgstr ""
 
+#. 7VrwE
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id391651225506119\n"
+"help.text"
+msgid "Centers the current dialog instance in the middle of a parent window. Without arguments, the method centers the dialog in the middle of the current window."
+msgstr ""
+
+#. xEJEH
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id391651552206119\n"
+"help.text"
+msgid "Returns <literal>True</literal> when successful."
+msgstr ""
+
+#. Woksx
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id1001585441257789\n"
+"help.text"
+msgid "<emph>Parent</emph>: An optional object that can be either …"
+msgstr ""
+
+#. DCeY9
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id412598177970993\n"
+"help.text"
+msgid "a ScriptForge dialog object"
+msgstr ""
+
+#. D5yN3
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id81591858229301\n"
+"help.text"
+msgid "a ScriptForge document (Calc, Base, ...) object"
+msgstr ""
+
+#. 8DDWf
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id12598185484092\n"
+"help.text"
+msgid "Set oDialog1 = CreateScriptService(\"DialogEvent\", oEvent) ' The dialog that caused the event"
+msgstr ""
+
+#. dx9rf
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id641598184589492\n"
+"help.text"
+msgid "Set oDialog2 = CreateScriptService(\"Dialog\", ...) ' Open a second dialog"
+msgstr ""
+
+#. kqFdv
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id351619267575732\n"
+"help.text"
+msgid "dlg1 = CreateScriptService('DialogEvent.Dialog', event)  # The dialog having caused the event"
+msgstr ""
+
+#. fDQAG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id431619267576082\n"
+"help.text"
+msgid "dlg2 = CreateScriptService('Dialog', ...)  # Open a second dialog"
+msgstr ""
+
 #. 4qLn9
 #: sf_dialog.xhp
 msgctxt ""
@@ -9340,6 +9790,87 @@ msgctxt ""
 msgid "Read the <link href=\"text/sbasic/shared/03/sf_l10n.xhp\" name=\"L10N\">L10N service</link> help page to learn more about how PO and POT files are handled."
 msgstr ""
 
+#. mA4Nm
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id21598187953697\n"
+"help.text"
+msgid "Moves the topleft corner of a dialog to new coordinates and/or modify its dimensions. All distances are expressed in 1/100 mm. Without arguments, the method resets the initial dimensions. Return <literal>True</literal> if the resize was successful."
+msgstr ""
+
+#. XRdLE
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id481651236673068\n"
+"help.text"
+msgid "<emph>Left</emph>: the horizontal distance from the top-left corner"
+msgstr ""
+
+#. FcTcU
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id721651236674379\n"
+"help.text"
+msgid "<emph>Top</emph>: the vertical distance from the top-left corner"
+msgstr ""
+
+#. uX7ps
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id991651236674995\n"
+"help.text"
+msgid "<emph>Width</emph>: the width of the rectangle containing the dialog"
+msgstr ""
+
+#. ApqA8
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id771651236675564\n"
+"help.text"
+msgid "<emph>Height</emph>: the height of the rectangle containing the dialog"
+msgstr ""
+
+#. H4CtP
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id211651236676180\n"
+"help.text"
+msgid "Negative or missing arguments are left unchanged"
+msgstr ""
+
+#. guvaM
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id791620301085031\n"
+"help.text"
+msgid "oDialog.Resize(1000, 2000, Height := 6000) ' Width is not changed"
+msgstr ""
+
+#. pEVvm
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id181620112217958\n"
+"help.text"
+msgid "With Python:"
+msgstr ""
+
+#. gBerj
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id941620303073866\n"
+"help.text"
+msgid "oDialog.Resize(1000, 2000, Height = 6000)  # Width is not changed"
+msgstr ""
+
 #. ARCGg
 #: sf_dialog.xhp
 msgctxt ""
diff --git a/source/pt/helpcontent2/source/text/sdatabase.po b/source/pt/helpcontent2/source/text/sdatabase.po
index 93e9783252f..004ac4a384b 100644
--- a/source/pt/helpcontent2/source/text/sdatabase.po
+++ b/source/pt/helpcontent2/source/text/sdatabase.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: 2022-02-21 15:22+0100\n"
+"POT-Creation-Date: 2022-05-25 12:36+0200\n"
 "PO-Revision-Date: 2022-01-29 07:39+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/pt/>\n"
@@ -384,14 +384,14 @@ msgctxt ""
 msgid "<bookmark_value>views; creating database views (Base)</bookmark_value>  <bookmark_value>queries; creating in design view (Base)</bookmark_value>  <bookmark_value>designing; queries (Base)</bookmark_value>  <bookmark_value>design view; queries/views (Base)</bookmark_value>  <bookmark_value>joining;tables (Base)</bookmark_value>  <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value>  <bookmark_value>queries; joining tables (Base)</bookmark_value>  <bookmark_value>tables in databases; relations (Base)</bookmark_value>  <bookmark_value>relations; joining tables (Base)</bookmark_value>  <bookmark_value>queries; deleting table links (Base)</bookmark_value>  <bookmark_value>criteria of query design (Base)</bookmark_value>  <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value>  <bookmark_value>filter conditions;in queries (Base)</bookmark_value>  <bookmark_value>parameters; queries (Base)</bookmark_value>  <bookmark_value>queries; parameter queries (Base)</bookmark_value>  <bookmark_value>SQL; queries (Base)</bookmark_value>  <bookmark_value>native SQL (Base)</bookmark_value>"
 msgstr "<bookmark_value>vistas; criar vistas de base de dados (Base)</bookmark_value><bookmark_value>consultas; criar na vista de design (Base)</bookmark_value><bookmark_value>design; consultas (Base)</bookmark_value><bookmark_value>vista de design; consultas/vistas (Base)</bookmark_value><bookmark_value>unir;tabelas (Base)</bookmark_value><bookmark_value>tabelas em bases de dados; unir para consultas (Base)</bookmark_value><bookmark_value>consultas; unir tabelas (Base)</bookmark_value><bookmark_value>tabelas em bases de dados; relações (Base)</bookmark_value><bookmark_value>relações; unir tabelas (Base)</bookmark_value><bookmark_value>consultas; eliminar ligações a tabelas (Base)</bookmark_value><bookmark_value>critérios do design de consultas (Base)</bookmark_value><bookmark_value>consultas; formular condições de filtro (Base)</bookmark_value><bookmark_value>condições de filtro;em consultas (Base)</bookmark_value><bookmark_value>parâmetros; consultas (Base)</bookmark_value><bookmark_value>consultas; consultas a parâmetros (Base)</bookmark_value><bookmark_value>SQL; consultas (Base)</bookmark_value><bookmark_value>SQL nativo (Base)</bookmark_value>"
 
-#. fmcBY
+#. 2BrD2
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "hd_id3153394\n"
 "help.text"
-msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Query Design</link>"
-msgstr "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Design de consulta</link>"
+msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>"
+msgstr ""
 
 #. GU8Jd
 #: 02010100.xhp
@@ -447,14 +447,14 @@ msgctxt ""
 msgid "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>."
 msgstr "Para criar uma consulta, clique no ícone <emph>Consultas</emph> no documento e, em seguida, clique em <emph>Criar consulta no modo de design</emph>."
 
-#. EN5uU
+#. AtAHv
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3150255\n"
 "help.text"
-msgid "The lower pane of the Design View is where you <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
-msgstr "O painel inferior da vista de design é onde se <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">define</link> a consulta. Para definir uma consulta, especifique os <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">nomes de campos</link> da base de dados a incluir e os <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">critérios</link> para exibição de campos. Para reorganizar as colunas no painel inferior da vista de design, arraste o cabeçalho da coluna para um novo local ou selecione a coluna e prima <switchinline select=\"sys\"><caseinline select=\"MAC\">Comando</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Tecla de seta."
+msgid "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the  criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
+msgstr ""
 
 #. GMVkG
 #: 02010100.xhp
@@ -924,15 +924,6 @@ msgctxt ""
 msgid "For example:"
 msgstr "Por exemplo:"
 
-#. ynSGq
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148478\n"
-"help.text"
-msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\""
-msgstr "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\""
-
 #. roTzi
 #: 02010100.xhp
 msgctxt ""
@@ -996,14 +987,14 @@ msgctxt ""
 msgid "Criteria"
 msgstr "Critérios"
 
-#. f3DvJ
+#. fWRgB
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3145134\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Especifica os primeiros <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">critérios</link> pelos quais o conteúdo dos dados deve ser filtrado.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>"
+msgstr ""
 
 #. qpADC
 #: 02010100.xhp
@@ -2157,15 +2148,6 @@ msgctxt ""
 msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}"
 msgstr ""
 
-#. Cy7Cc
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3150661\n"
-"help.text"
-msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}"
-msgstr ""
-
 #. newGb
 #: 02010100.xhp
 msgctxt ""
@@ -2184,15 +2166,6 @@ msgctxt ""
 msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}"
 msgstr ""
 
-#. VnKGf
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3156052\n"
-"help.text"
-msgid "Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}"
-msgstr ""
-
 #. mWG9p
 #: 02010100.xhp
 msgctxt ""
@@ -2292,24 +2265,6 @@ msgctxt ""
 msgid "DateTime"
 msgstr ""
 
-#. FqZXM
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149539\n"
-"help.text"
-msgid "Example: select {d '1999-12-31'} from world.years"
-msgstr ""
-
-#. WJ4YB
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149540\n"
-"help.text"
-msgid "Example: select * from mytable where years='1999-12-31'"
-msgstr ""
-
 #. CZdA4
 #: 02010100.xhp
 msgctxt ""
@@ -2481,13 +2436,13 @@ msgctxt ""
 msgid "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used."
 msgstr ""
 
-#. 57vjv
+#. f2NMg
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id191120151905518123\n"
 "help.text"
-msgid "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>"
+msgid "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>"
 msgstr ""
 
 #. DZCXm
@@ -2499,13 +2454,13 @@ msgctxt ""
 msgid "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases."
 msgstr ""
 
-#. bGnxL
+#. WBEtt
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id191120151931441881\n"
 "help.text"
-msgid "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>."
+msgid "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>."
 msgstr ""
 
 #. sSSB9
@@ -5919,6 +5874,42 @@ msgctxt ""
 msgid "For more information on SQL commands, please consult the documentation that came with the database."
 msgstr ""
 
+#. hdoAK
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id91652478785999\n"
+"help.text"
+msgid "Show output of \"select\" statements"
+msgstr ""
+
+#. nB4gp
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id281652481037143\n"
+"help.text"
+msgid "Show the result of the SQL SELECT command in the Output box."
+msgstr ""
+
+#. uaXF8
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154071\n"
+"help.text"
+msgid "Execute"
+msgstr ""
+
+#. 6UCdY
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151210\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute</emph> box.</ahelp>"
+msgstr ""
+
 #. BQmT9
 #: 11080000.xhp
 msgctxt ""
@@ -5928,13 +5919,13 @@ msgctxt ""
 msgid "Previous commands"
 msgstr ""
 
-#. hkxBT
+#. 8AWBX
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
 "par_id3149045\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Execute</emph>.</ahelp>"
 msgstr ""
 
 #. AvXck
@@ -5946,31 +5937,31 @@ msgctxt ""
 msgid "Status"
 msgstr ""
 
-#. yhCpt
+#. 7RS4e
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
 "par_id3151054\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the status, including errors, of the SQL command that you ran.</ahelp>"
 msgstr ""
 
-#. BUpxX
+#. 8qcm5
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
-"hd_id3154071\n"
+"hd_id841652479655639\n"
 "help.text"
-msgid "Run"
+msgid "Output"
 msgstr ""
 
-#. qDYRx
+#. pEFoq
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
-"par_id3151210\n"
+"par_id511652479714010\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>"
+msgid "Displays the results of the SQL command that you ran."
 msgstr ""
 
 #. 93Xfs
diff --git a/source/pt/helpcontent2/source/text/shared/06.po b/source/pt/helpcontent2/source/text/shared/06.po
index 7ba569edafd..bbb793a9854 100644
--- a/source/pt/helpcontent2/source/text/shared/06.po
+++ b/source/pt/helpcontent2/source/text/shared/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: 2022-02-18 12:17+0100\n"
+"POT-Creation-Date: 2022-05-25 12:36+0200\n"
 "PO-Revision-Date: 2022-01-29 07:39+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textshared06/pt/>\n"
@@ -474,21 +474,3 @@ msgctxt ""
 "help.text"
 msgid "YouTube Videos"
 msgstr "Vídeos do YouTube"
-
-#. dNxMD
-#: youtubevideos.xhp
-msgctxt ""
-"youtubevideos.xhp\n"
-"par_id311644338760624\n"
-"help.text"
-msgid "Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party."
-msgstr ""
-
-#. 6FN4K
-#: youtubevideos.xhp
-msgctxt ""
-"youtubevideos.xhp\n"
-"par_id91644338793051\n"
-"help.text"
-msgid "<link href=\"https://policies.google.com/privacy\" name=\"linkname\">YouTube Privacy Policy</link>"
-msgstr ""
diff --git a/source/pt/helpcontent2/source/text/shared/guide.po b/source/pt/helpcontent2/source/text/shared/guide.po
index 873dbe632b4..3486d79f973 100644
--- a/source/pt/helpcontent2/source/text/shared/guide.po
+++ b/source/pt/helpcontent2/source/text/shared/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: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2021-04-22 09:37+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsharedguide/pt/>\n"
@@ -5749,14 +5749,14 @@ msgctxt ""
 msgid "Inserting into a text document"
 msgstr "Inserir num documento de texto"
 
-#. tnY74
+#. yCE5L
 #: copy_drawfunctions.xhp
 msgctxt ""
 "copy_drawfunctions.xhp\n"
 "par_id3150276\n"
 "help.text"
-msgid "An inserted drawing object is anchored to the current paragraph. You can change the anchor by selecting the object and clicking the <emph>Change Anchor</emph> icon on the <emph>OLE-Object</emph> toolbar or the <emph>Frame</emph> toolbar. This opens a popup menu where you can select the anchor type."
-msgstr "Um objeto de desenho inserido é ancorado no parágrafo atual. Pode alterar a âncora ao selecionar o objeto e clicar no ícone <emph>Alterar âncora</emph> na barra de ferramentas <emph>Objeto OLE</emph> ou na barra de ferramentas <emph>Moldura</emph>. É aberto um menu onde pode escolher o tipo de âncora."
+msgid "An inserted drawing object is anchored to the current paragraph. You can change the anchor by selecting the object and clicking the <emph>Change Anchor</emph> icon on the <emph>OLE Object</emph> toolbar or the <emph>Frame</emph> toolbar. This opens a popup menu where you can select the anchor type."
+msgstr ""
 
 #. TTFkG
 #: copy_drawfunctions.xhp
diff --git a/source/pt/helpcontent2/source/text/shared/help.po b/source/pt/helpcontent2/source/text/shared/help.po
index fc5dc61c409..b6e2cc3b956 100644
--- a/source/pt/helpcontent2/source/text/shared/help.po
+++ b/source/pt/helpcontent2/source/text/shared/help.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: 2022-02-09 16:45+0100\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2020-08-15 14:35+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedhelp/pt/>\n"
@@ -862,6 +862,24 @@ msgctxt ""
 msgid "<variable id=\"xap_didyoumean\">Did you mean:</variable>"
 msgstr "<variable id=\"xap_didyoumean\">Será que queria dizer:</variable>"
 
+#. PrbPA
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"hd_id471652287598699\n"
+"help.text"
+msgid "<variable id=\"externalvideo\">External video</variable>"
+msgstr ""
+
+#. CKGLp
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"par_id311644338760624\n"
+"help.text"
+msgid "<variable id=\"ytaccept\">Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.</variable>"
+msgstr ""
+
 #. BvoqF
 #: browserhelp.xhp
 msgctxt ""
@@ -870,3 +888,12 @@ msgctxt ""
 "help.text"
 msgid "<variable id=\"ytbutton\">Accept YouTube Content</variable>"
 msgstr ""
+
+#. jDvUs
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"par_id91644338793051\n"
+"help.text"
+msgid "<variable id=\"ytprivacy\">YouTube Privacy Policy</variable>"
+msgstr ""
diff --git a/source/pt/helpcontent2/source/text/shared/optionen.po b/source/pt/helpcontent2/source/text/shared/optionen.po
index f9e01248284..17059d11489 100644
--- a/source/pt/helpcontent2/source/text/shared/optionen.po
+++ b/source/pt/helpcontent2/source/text/shared/optionen.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-03-21 12:31+0100\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2022-01-29 07:39+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsharedoptionen/pt/>\n"
@@ -5569,24 +5569,6 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/opthtmlpage/savegrflocal\">Mark this check box to automatically upload the embedded pictures to the Internet server when uploading using FTP. Use the <emph>Save As</emph> dialog to save the document and enter a complete FTP URL as the file name in the Internet.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/opthtmlpage/savegrflocal\">Assinale esta caixa de verificação para enviar automaticamente as imagens incorporadas para o servidor da Internet, ao efetuar um envio através de FTP. Utilize a caixa de diálogo <emph>Guardar como</emph> para guardar o documento e para introduzir o URL FTP como nome do ficheiro na Internet.</ahelp>"
 
-#. tBaEs
-#: 01030500.xhp
-msgctxt ""
-"01030500.xhp\n"
-"hd_id3152960\n"
-"help.text"
-msgid "Character set"
-msgstr "Conjunto de caracteres"
-
-#. giSiE
-#: 01030500.xhp
-msgctxt ""
-"01030500.xhp\n"
-"par_id3149018\n"
-"help.text"
-msgid "<ahelp hid=\"cui/ui/opthtmlpage/charset\">Select the appropriate character set for the export</ahelp>."
-msgstr "<ahelp hid=\"cui/ui/opthtmlpage/charset\">Selecione o conjunto de caracteres adequado à exportação</ahelp>"
-
 #. CGmvv
 #: 01040000.xhp
 msgctxt ""
diff --git a/source/pt/helpcontent2/source/text/swriter.po b/source/pt/helpcontent2/source/text/swriter.po
index f395286b26e..39a44d7bb6f 100644
--- a/source/pt/helpcontent2/source/text/swriter.po
+++ b/source/pt/helpcontent2/source/text/swriter.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-10 20:16+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2022-01-12 14:38+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textswriter/pt/>\n"
@@ -2590,32 +2590,32 @@ msgctxt ""
 msgid "<link href=\"text/swriter/01/04130000.xhp\" name=\"Frame Properties\">Frame Properties</link>"
 msgstr "<link href=\"text/swriter/01/04130000.xhp\" name=\"Frame Properties\">Propriedades da moldura</link>"
 
-#. vjbUV
+#. uXf8a
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "tit\n"
 "help.text"
-msgid "OLE-Object Bar"
-msgstr "Barra Objeto OLE"
+msgid "OLE Object Bar"
+msgstr ""
 
-#. W8UvK
+#. iiqD4
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "hd_id3150726\n"
 "help.text"
-msgid "<link href=\"text/swriter/main0216.xhp\" name=\"OLE-Object Bar\">OLE-Object Bar</link>"
-msgstr "<link href=\"text/swriter/main0216.xhp\" name=\"OLE-Object Bar\">Barra Objeto OLE</link>"
+msgid "<link href=\"text/swriter/main0216.xhp\" name=\"OLE Object Bar\">OLE Object Bar</link>"
+msgstr ""
 
-#. CQsLx
+#. phgBb
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "par_id3150746\n"
 "help.text"
-msgid "<ahelp hid=\"HID_OLE_TOOLBOX\">The<emph> OLE-Object </emph>bar appears when objects are selected, and contains the most important functions for formatting and positioning objects.</ahelp>"
-msgstr "<ahelp hid=\"HID_OLE_TOOLBOX\">A barra<emph> Objeto OLE </emph>aparece quando são selecionados objetos, e mostra as funções mais importantes na formatação e posicionamento de objetos.</ahelp>"
+msgid "<ahelp hid=\"HID_OLE_TOOLBOX\">The <emph>OLE Object</emph> bar appears when objects are selected, and contains the most important functions for formatting and positioning objects.</ahelp>"
+msgstr ""
 
 #. FGEsG
 #: main0216.xhp
diff --git a/source/pt/helpcontent2/source/text/swriter/01.po b/source/pt/helpcontent2/source/text/swriter/01.po
index cbfa49844eb..37925f66099 100644
--- a/source/pt/helpcontent2/source/text/swriter/01.po
+++ b/source/pt/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2021-11-06 17:36+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textswriter01/pt/>\n"
@@ -4454,13 +4454,13 @@ msgctxt ""
 msgid "Insert Manual Break"
 msgstr "Inserir quebra manual"
 
-#. hvzGW
+#. HFYWT
 #: 04010000.xhp
 msgctxt ""
 "04010000.xhp\n"
 "bm_id991649682491332\n"
 "help.text"
-msgid "<bookmark_value>manual break:next full line</bookmark_value><bookmark_value>manual break:right</bookmark_value><bookmark_value>manual break:clear right</bookmark_value><bookmark_value>clear right:manual break</bookmark_value><bookmark_value>manual break:clear left</bookmark_value><bookmark_value>manual break:left</bookmark_value><bookmark_value>clear left:manual break</bookmark_value><bookmark_value>manual break:next line</bookmark_value>"
+msgid "<bookmark_value>manual break;next full line</bookmark_value><bookmark_value>manual break;right</bookmark_value><bookmark_value>manual break;clear right</bookmark_value><bookmark_value>clear right;manual break</bookmark_value><bookmark_value>manual break;clear left</bookmark_value><bookmark_value>manual break;left</bookmark_value><bookmark_value>clear left;manual break</bookmark_value><bookmark_value>manual break;next line</bookmark_value>"
 msgstr ""
 
 #. FuBqy
diff --git a/source/pt/helpcontent2/source/text/swriter/guide.po b/source/pt/helpcontent2/source/text/swriter/guide.po
index 2c2769d59d4..e79ff6751e9 100644
--- a/source/pt/helpcontent2/source/text/swriter/guide.po
+++ b/source/pt/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: 2022-03-21 12:32+0100\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2022-01-29 07:39+0000\n"
 "Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
 "Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textswriterguide/pt/>\n"
@@ -1609,14 +1609,14 @@ msgctxt ""
 msgid "Select the object for which you want to define a border."
 msgstr "Selecione o objeto para o qual pretende definir o contorno."
 
-#. 77sGp
+#. BQmhJ
 #: border_object.xhp
 msgctxt ""
 "border_object.xhp\n"
 "par_id3149578\n"
 "help.text"
-msgid "Click the <emph>Borders</emph> icon on the <emph>OLE-Object</emph> toolbar or <emph>Frame</emph> toolbar to open the <emph>Borders</emph> window."
-msgstr "Clique no ícone <emph>Contornos</emph> na barra de ferramentas <emph>Objeto OLE</emph> ou na barra de ferramentas <emph>Moldura</emph> para abrir a janela <emph>Contornos</emph>."
+msgid "Click the <emph>Borders</emph> icon on the <emph>OLE Object</emph> toolbar or <emph>Frame</emph> toolbar to open the <emph>Borders</emph> window."
+msgstr ""
 
 #. 2ZzA5
 #: border_object.xhp