update translations for master/7.4

and force-fix errors using pocheck

Change-Id: I6791c0fed18c372d154a25de9c826720bb037af8

10 files changed, 701 insertions, 332 deletions

diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/shared.po b/source/zh-TW/helpcontent2/source/text/sbasic/shared.po
index e6ca77c38f9..9fe18107545 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/shared.po
+++ b/source/zh-TW/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:41+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -10808,32 +10808,32 @@ msgctxt ""
 msgid "Returns the size of an open file in bytes."
 msgstr "傳回開啟檔案的大小，以位元組為單位。"
 
-#. 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>任意數值型表示式，包含由 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 "若要獲取未開啟檔案的長度，請使用 <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
@@ -11870,41 +11870,14 @@ msgctxt ""
 msgid "Returns the length of a file in bytes."
 msgstr "傳回檔案長度，以位元組為單位。"
 
-#. GfNg3
+#. RpGc5
 #: 03020408.xhp
 msgctxt ""
 "03020408.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "<emph>語法</emph>："
-
-#. 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 "<emph>傳回值類型</emph>："
-
-#. H2KXW
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3150768\n"
-"help.text"
-msgid "Parameters:"
-msgstr "參數："
+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
@@ -11915,23 +11888,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>Text：</emph>包含明確檔案規格的任意字串型表示式。您也可以使用 <link href=\"text/sbasic/shared/00000002.xhp\" name=\"URL 表示法\">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 "此函式確定檔案的長度。如果將 FileLen 函式用於開啟著的檔案，則此函式將傳回該檔案在開啟之前的長度。若要確定開啟著的檔案的目前長度，請使用 Lof 函式。"
-
-#. j8DBv
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3163710\n"
-"help.text"
-msgid "Example:"
-msgstr "<emph>示例：</emph>"
+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
@@ -24983,59 +24947,14 @@ msgctxt ""
 msgid "Converts any numerical expression or string expression to a double type."
 msgstr "將任意數值型表示式或字串型表示式轉換為雙精度型。"
 
-#. jjGQH
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax"
-msgstr "語法"
-
-#. aTHD8
+#. wEVGF
 #: 03100400.xhp
 msgctxt ""
 "03100400.xhp\n"
 "par_id3156152\n"
 "help.text"
-msgid "CDbl (Expression)"
-msgstr "CDbl(Expression)"
-
-#. 38G4w
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3153061\n"
-"help.text"
-msgid "Return value"
-msgstr "傳回值"
-
-#. LM9Ye
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "參數："
-
-#. 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>Expression：</emph>要轉換的任意字串型表示式或數值型表示式。若要轉換字串型表示式，必須使用作業系統的標準數字格式，將數字作為一般文字 (「123.5」) 輸入。"
-
-#. HxfeM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3148797\n"
-"help.text"
-msgid "Example:"
-msgstr "<emph>示例：</emph>"
+msgid "CDbl (Expression As Variant) As Double"
+msgstr ""
 
 #. Hs9F5
 #: 03100500.xhp
@@ -25073,58 +24992,13 @@ msgctxt ""
 msgid "Converts any string or numeric expression to an integer."
 msgstr "將任意字串型表示式或數值型表示式轉換為整數。"
 
-#. AFSBH
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147573\n"
-"help.text"
-msgid "Syntax:"
-msgstr "<emph>語法</emph>："
-
-#. ZGxYP
+#. CCHrN
 #: 03100500.xhp
 msgctxt ""
 "03100500.xhp\n"
 "par_id3154142\n"
 "help.text"
-msgid "CInt (Expression)"
-msgstr "CInt(Expression)"
-
-#. AQaNC
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147531\n"
-"help.text"
-msgid "Return value:"
-msgstr "<emph>傳回值類型</emph>："
-
-#. a2YC7
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3145069\n"
-"help.text"
-msgid "Parameters:"
-msgstr "參數："
-
-#. 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
@@ -25235,50 +25109,23 @@ msgctxt ""
 msgid "Converts any string or numeric expression to a long integer."
 msgstr "將任意字串型表示式或數值型表示式轉換為長型整數。"
 
-#. CtL6e
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "<emph>語法</emph>："
-
-#. 3HnrW
+#. 8aFmF
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "par_id3147573\n"
 "help.text"
-msgid "CLng (Expression)"
-msgstr "CLng(Expression)"
-
-#. iViY7
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145610\n"
-"help.text"
-msgid "Return value:"
-msgstr "<emph>傳回值類型</emph>："
-
-#. pC3ZX
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "參數："
+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>Expression：</emph>要轉換的任意數值型表示式。如果 <emph>Expression</emph> 不在 -2,147,483,648 到 2,147,483,647 的有效長型整數範圍內，$[officename] Basic 將傳回溢位錯誤。若要轉換字串型表示式，必須使用作業系統的標準數字格式，將數字作為一般文字 (「123.5」) 輸入。"
+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
@@ -25514,59 +25361,68 @@ msgctxt ""
 msgid "Converts any string or numeric expression to data type Single."
 msgstr "將任意字串型表示式或數值型表示式轉換為單精度資料類型。"
 
-#. BNPsA
+#. dQQAS
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3153255\n"
+"par_id3148983\n"
 "help.text"
-msgid "Syntax:"
-msgstr "<emph>語法</emph>："
+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(Expression)"
+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 "<emph>傳回值類型</emph>："
+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 "參數："
+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>Expression：</emph>要轉換的任意字串型表示式或數值型表示式。若要轉換字串型表示式，必須使用作業系統的標準數字格式，將數字作為一般文字 (「123.5」) 輸入。"
+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 "<emph>示例：</emph>"
+msgid "MsgBox CSng(expression := 5678.1234) ' 5678.123535156"
+msgstr ""
 
 #. MCFBf
 #: 03101000.xhp
diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po b/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
index d14192c5db7..964e468a9cc 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/zh-TW/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:38+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/zh-TW/helpcontent2/source/text/sdatabase.po b/source/zh-TW/helpcontent2/source/text/sdatabase.po
index 28f605f77b2..ce47d8eda3e 100644
--- a/source/zh-TW/helpcontent2/source/text/sdatabase.po
+++ b/source/zh-TW/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/zh-TW/helpcontent2/source/text/shared/06.po b/source/zh-TW/helpcontent2/source/text/shared/06.po
index 87872a19afc..7553497abbc 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/06.po
+++ b/source/zh-TW/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:35+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/zh-TW/helpcontent2/source/text/shared/guide.po b/source/zh-TW/helpcontent2/source/text/shared/guide.po
index 314a682b591..b2fc3acfa2c 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/guide.po
+++ b/source/zh-TW/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: 2019-08-09 08:03+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5749,14 +5749,14 @@ 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."
-msgstr "插入的繪圖物件被錨點至目前的段落。您可以選取此物件並按一下 <emph>[OLE 物件]</emph> 工具列或 <emph>[外框]</emph> 工具列上的<emph>變更錨點</emph>圖示來變更此錨點錨點。這會開啟右鍵功能表，在此您可以選取錨點類型。"
+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/zh-TW/helpcontent2/source/text/shared/help.po b/source/zh-TW/helpcontent2/source/text/shared/help.po
index 670cad307b2..c70da6ff9c3 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/help.po
+++ b/source/zh-TW/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:15+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/zh-TW/helpcontent2/source/text/shared/optionen.po b/source/zh-TW/helpcontent2/source/text/shared/optionen.po
index 2cfd78375a9..8016ac11039 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/optionen.po
+++ b/source/zh-TW/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:03+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 "字型"
-
-#. 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/zh-TW/helpcontent2/source/text/swriter.po b/source/zh-TW/helpcontent2/source/text/swriter.po
index 749db1f6a26..58758e676da 100644
--- a/source/zh-TW/helpcontent2/source/text/swriter.po
+++ b/source/zh-TW/helpcontent2/source/text/swriter.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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:41+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: chinese-l10n <chinese-l10n@googlegroups.com>\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=\"外框屬性\">外框屬性</link>"
 
-#. vjbUV
+#. uXf8a
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "tit\n"
 "help.text"
-msgid "OLE-Object Bar"
-msgstr "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 物件列\">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\"><emph>[OLE 物件]</emph> 列會在選取物件時出現，並且包含格式化與定位物件時最重要的功能。</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/zh-TW/helpcontent2/source/text/swriter/01.po b/source/zh-TW/helpcontent2/source/text/swriter/01.po
index 01385d04565..25aa223bab1 100644
--- a/source/zh-TW/helpcontent2/source/text/swriter/01.po
+++ b/source/zh-TW/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: 2019-08-09 08:03+0000\n"
 "Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4453,13 +4453,13 @@ msgctxt ""
 msgid "Insert Manual Break"
 msgstr "插入手動隔斷符"
 
-#. 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/zh-TW/helpcontent2/source/text/swriter/guide.po b/source/zh-TW/helpcontent2/source/text/swriter/guide.po
index e9522628abc..deb4a7382a9 100644
--- a/source/zh-TW/helpcontent2/source/text/swriter/guide.po
+++ b/source/zh-TW/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: 2020-01-12 06:57+0000\n"
 "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
 "Language-Team: Chinese (Traditional) <https://weblate.documentfoundation.org/projects/libo_help-master/textswriterguide/zh_Hant/>\n"
@@ -1609,14 +1609,14 @@ msgctxt ""
 msgid "Select the object for which you want to define a border."
 msgstr "選取您要為之定義邊框的物件。"
 
-#. 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 "按一下 <emph>[OLE 物件]</emph> 工具列或 <emph>[外框]</emph> 工具列上的<emph>邊框</emph>圖示以開啟 <emph>[邊框]</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