update translations for master/7.4

and force-fix errors using pocheck

Change-Id: I6791c0fed18c372d154a25de9c826720bb037af8

10 files changed, 700 insertions, 331 deletions

diff --git a/source/vi/helpcontent2/source/text/sbasic/shared.po b/source/vi/helpcontent2/source/text/sbasic/shared.po
index 3f167a23de0..617f83ab780 100644
--- a/source/vi/helpcontent2/source/text/sbasic/shared.po
+++ b/source/vi/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: 2018-10-21 20:39+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -10807,32 +10807,32 @@ msgctxt ""
 msgid "Returns the size of an open file in bytes."
 msgstr "Trả về kích cỡ theo byte của một tập tin còn mở."
 
-#. 43MqD
+#. D84bA
 #: 03020303.xhp
 msgctxt ""
 "03020303.xhp\n"
 "par_id3150359\n"
 "help.text"
-msgid "Lof (FileNumber)"
-msgstr "Lof (FileNumber)"
+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>FileNumber:</emph> bất cứ biểu thức thuộc số nào mà chứa số thứ tự tập tin được ghi rõ trong câu lệnh 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 "Để giành được chiều dài của một tập tin chưa mở, dùng hàm <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 "Trả về chiều dài của tập tin, theo byte."
 
-#. GfNg3
+#. RpGc5
 #: 03020408.xhp
 msgctxt ""
 "03020408.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Cú pháp:"
-
-#. MoBSd
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3149656\n"
+"par_id401651744449325\n"
 "help.text"
-msgid "FileLen (Text As String)"
-msgstr "FileLen (Text As String)"
-
-#. LVwBo
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Return value:"
-msgstr "GIá trị trả về:"
-
-#. H2KXW
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3150768\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Tham số :"
+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>Văn bản:</emph> bất cứ biểu thức chuỗi nào mà chứa một đặc tả tập tin không mơ hồ. Bạn cũng có thể sử dụng <link href=\"text/sbasic/shared/00000002.xhp\" name=\"kiểu ghi URL\">kiểu ghi 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 "Hàm này xác định chiều dài của tập tin. Hàm FileLen được gọi đối với một tập tin còn mở sẽ trả về chiều dài của tập tin trước khi mở. Để xác định chiều dài tư hiện thời của một tập tin đã mở, dùng hàm « Lof »."
-
-#. j8DBv
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3163710\n"
-"help.text"
-msgid "Example:"
-msgstr "Thí dụ :"
+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 "Chuyển đổi bất cứ biểu thức nào kiểu chuỗi hay thuộc số sang một kiểu đôi."
 
-#. jjGQH
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax"
-msgstr "Cú pháp"
-
-#. aTHD8
+#. wEVGF
 #: 03100400.xhp
 msgctxt ""
 "03100400.xhp\n"
 "par_id3156152\n"
 "help.text"
-msgid "CDbl (Expression)"
-msgstr "CDbl(Biểu_thức)"
-
-#. 38G4w
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3153061\n"
-"help.text"
-msgid "Return value"
-msgstr "Giá trị trả về"
-
-#. LM9Ye
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Tham số :"
-
-#. 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>Biểu_thức:</emph> bất cứ biểu thức nào kiểu chuỗi hay thuộc số mà bạn muốn chuyển đổi. Để chuyển đổi một biểu thức kiểu chuỗi, số phải được nhập dạng văn bản bình thường (\"123.5\") dùng định dạng số của hệ điều hành của bạn."
-
-#. HxfeM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3148797\n"
-"help.text"
-msgid "Example:"
-msgstr "Thí dụ :"
+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 "Chuyển đổi bất cứ biểu thức nào kiểu chuỗi hay thuộc số sang một số nguyên."
 
-#. AFSBH
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147573\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Cú pháp:"
-
-#. ZGxYP
+#. CCHrN
 #: 03100500.xhp
 msgctxt ""
 "03100500.xhp\n"
 "par_id3154142\n"
 "help.text"
-msgid "CInt (Expression)"
-msgstr "CInt(Biểu_thức)"
-
-#. AQaNC
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147531\n"
-"help.text"
-msgid "Return value:"
-msgstr "GIá trị trả về:"
-
-#. a2YC7
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3145069\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Tham số :"
-
-#. 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 "Chuyển đổi bất cứ biểu thức nào kiểu chuỗi hay thuộc số sang một số nguyên dài."
 
-#. CtL6e
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Cú pháp:"
-
-#. 3HnrW
+#. 8aFmF
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "par_id3147573\n"
 "help.text"
-msgid "CLng (Expression)"
-msgstr "CLng(Biểu_thức)"
-
-#. iViY7
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145610\n"
-"help.text"
-msgid "Return value:"
-msgstr "GIá trị trả về:"
-
-#. pC3ZX
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Tham số :"
+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>Biểu_thức:</emph> bất cứ biểu thức thuộc số nào cần chuyển đổi. Nếu <emph>Biểu_thức</emph> nằm ở ngoại phạm vi số nguyên dài hợp lệ -2.147.483.648 đến 2.147.483.647, $[officename] Basic trả về một lỗi bị tràn. Để chuyển đổi một biểu thức kiểu chuỗi, số phải được nhập dạng văn bản bình thường (\"123.5\") dùng định dạng số mặc định của hệ điều hành của bạn."
+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 "Chuyển đổi bất cứ biểu thức nào kiểu chuỗi hay thuộc số sang kiểu dữ liệu Đơn (Single)."
 
-#. BNPsA
+#. dQQAS
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3153255\n"
+"par_id3148983\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Cú pháp:"
+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 (Biểu_thức)"
+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 "GIá trị trả về:"
+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 "Tham số :"
+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>Biểu_thức:</emph> bất cứ biểu thức nào kiểu chuỗi hay thuộc số mà bạn muốn chuyển đổi. Để chuyển đổi một biểu thức kiểu chuỗi, số phải được nhập dạng văn bản bình thường (\"123.5\") dùng định dạng số của hệ điều hành của bạn."
+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 "Thí dụ :"
+msgid "MsgBox CSng(expression := 5678.1234) ' 5678.123535156"
+msgstr ""
 
 #. MCFBf
 #: 03101000.xhp
diff --git a/source/vi/helpcontent2/source/text/sbasic/shared/03.po b/source/vi/helpcontent2/source/text/sbasic/shared/03.po
index e5db8f7c4af..59fd925fb28 100644
--- a/source/vi/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/vi/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: 2018-07-12 14:37+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\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/vi/helpcontent2/source/text/sdatabase.po b/source/vi/helpcontent2/source/text/sdatabase.po
index 28f605f77b2..ce47d8eda3e 100644
--- a/source/vi/helpcontent2/source/text/sdatabase.po
+++ b/source/vi/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: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -382,13 +382,13 @@ 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 ""
 
-#. 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>"
+msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>"
 msgstr ""
 
 #. GU8Jd
@@ -445,13 +445,13 @@ 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 ""
 
-#. 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."
+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
@@ -922,15 +922,6 @@ msgctxt ""
 msgid "For example:"
 msgstr ""
 
-#. ynSGq
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148478\n"
-"help.text"
-msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\""
-msgstr ""
-
 #. roTzi
 #: 02010100.xhp
 msgctxt ""
@@ -994,13 +985,13 @@ msgctxt ""
 msgid "Criteria"
 msgstr ""
 
-#. 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>"
+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
@@ -2155,15 +2146,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 ""
@@ -2182,15 +2164,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 ""
@@ -2290,24 +2263,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 ""
@@ -2479,13 +2434,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
@@ -2497,13 +2452,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
@@ -5917,6 +5872,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 ""
@@ -5926,13 +5917,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
@@ -5944,31 +5935,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/vi/helpcontent2/source/text/shared/06.po b/source/vi/helpcontent2/source/text/shared/06.po
index 5056fc53994..f9a2999face 100644
--- a/source/vi/helpcontent2/source/text/shared/06.po
+++ b/source/vi/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: 2018-09-03 13:33+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -474,21 +474,3 @@ msgctxt ""
 "help.text"
 msgid "YouTube Videos"
 msgstr ""
-
-#. 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/vi/helpcontent2/source/text/shared/guide.po b/source/vi/helpcontent2/source/text/shared/guide.po
index e012900d632..aa2a7a5a3ad 100644
--- a/source/vi/helpcontent2/source/text/shared/guide.po
+++ b/source/vi/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: 2018-11-14 12:12+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5749,13 +5749,13 @@ msgctxt ""
 msgid "Inserting into a text document"
 msgstr ""
 
-#. 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."
+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
diff --git a/source/vi/helpcontent2/source/text/shared/help.po b/source/vi/helpcontent2/source/text/shared/help.po
index 77a69ca872d..694529be879 100644
--- a/source/vi/helpcontent2/source/text/shared/help.po
+++ b/source/vi/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: 2018-11-12 14:13+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -862,6 +862,24 @@ msgctxt ""
 msgid "<variable id=\"xap_didyoumean\">Did you mean:</variable>"
 msgstr ""
 
+#. 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/vi/helpcontent2/source/text/shared/optionen.po b/source/vi/helpcontent2/source/text/shared/optionen.po
index 7de6a59165c..369501e0a5b 100644
--- a/source/vi/helpcontent2/source/text/shared/optionen.po
+++ b/source/vi/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: 2019-08-09 08:37+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\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 ""
 
-#. tBaEs
-#: 01030500.xhp
-msgctxt ""
-"01030500.xhp\n"
-"hd_id3152960\n"
-"help.text"
-msgid "Character set"
-msgstr "Bộ ký tự"
-
-#. 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 ""
-
 #. CGmvv
 #: 01040000.xhp
 msgctxt ""
diff --git a/source/vi/helpcontent2/source/text/swriter.po b/source/vi/helpcontent2/source/text/swriter.po
index fb5936aa194..7ce4e10e7ba 100644
--- a/source/vi/helpcontent2/source/text/swriter.po
+++ b/source/vi/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: 2018-10-21 20:40+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\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=\"Thuộc tính khung\">Thuộc tính khung</link>"
 
-#. vjbUV
+#. uXf8a
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "tit\n"
 "help.text"
-msgid "OLE-Object Bar"
-msgstr "Thanh đối tượng 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=\"Thanh đối tượng OLE\">Thanh đối tượng 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\">Thanh <emph>đối tượng OLE</emph> xuất hiện khi đối tượng được chọn, và chứa những chức năng quan trọng nhất để định dạng và định vị đối tượng.</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/vi/helpcontent2/source/text/swriter/01.po b/source/vi/helpcontent2/source/text/swriter/01.po
index a06e0136929..9ea0b51167e 100644
--- a/source/vi/helpcontent2/source/text/swriter/01.po
+++ b/source/vi/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: 2018-10-21 20:40+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4453,13 +4453,13 @@ msgctxt ""
 msgid "Insert Manual Break"
 msgstr "Chèn dấu ngắt bằng tay"
 
-#. 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/vi/helpcontent2/source/text/swriter/guide.po b/source/vi/helpcontent2/source/text/swriter/guide.po
index f261d240ec1..789baf7a631 100644
--- a/source/vi/helpcontent2/source/text/swriter/guide.po
+++ b/source/vi/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: 2018-11-12 14:13+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1609,14 +1609,14 @@ msgctxt ""
 msgid "Select the object for which you want to define a border."
 msgstr "Chọn đối tượng cho đó bạn muốn xác định viền."
 
-#. 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 "Nhấn vào biểu tượng <emph>Viền</emph> trên thanh công cụ <emph>Đối tượng OLE</emph> hay thanh công cụ <emph>Khung</emph> để mở cửa sổ <emph>Viền</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