update translations for master/7.4

and force-fix errors using pocheck

Change-Id: I6791c0fed18c372d154a25de9c826720bb037af8

10 files changed, 706 insertions, 337 deletions

diff --git a/source/lt/helpcontent2/source/text/sbasic/shared.po b/source/lt/helpcontent2/source/text/sbasic/shared.po
index 488567ad44d..46f07d6f3c6 100644
--- a/source/lt/helpcontent2/source/text/sbasic/shared.po
+++ b/source/lt/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-10 20:16+0200\n"
+"POT-Creation-Date: 2022-05-25 12:36+0200\n"
 "PO-Revision-Date: 2021-03-03 18:36+0000\n"
 "Last-Translator: Valentina Dagiene <valentina.dagiene@mif.vu.lt>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/lt/>\n"
@@ -10807,32 +10807,32 @@ msgctxt ""
 msgid "Returns the size of an open file in bytes."
 msgstr "Grąžina atverto failo dydį baitais."
 
-#. 43MqD
+#. D84bA
 #: 03020303.xhp
 msgctxt ""
 "03020303.xhp\n"
 "par_id3150359\n"
 "help.text"
-msgid "Lof (FileNumber)"
-msgstr "Lof (failo numeris)"
+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> Bet kuri skaitinė išraiška, kurioje yra failo numeris, nurodytas atvėrimo sakinyje."
+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 "Norėdami gauti neatverto failo ilgį, naudokite funkciją <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 "Grąžina failo ilgį baitais."
 
-#. GfNg3
+#. RpGc5
 #: 03020408.xhp
 msgctxt ""
 "03020408.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaksė:"
-
-#. MoBSd
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3149656\n"
+"par_id401651744449325\n"
 "help.text"
-msgid "FileLen (Text As String)"
-msgstr "FileLen (tekstas kaip eilutė)"
-
-#. LVwBo
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3148798\n"
-"help.text"
-msgid "Return value:"
-msgstr "Grąžinama reikšmė:"
-
-#. H2KXW
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3150768\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrai:"
+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>Tekstas:</emph> Bet kuri eilutės išraiška, kuri pagrįsta nedviprasmiška failo specifikacija. Taip pat galite naudoti <link href=\"text/sbasic/shared/00000002.xhp\" name=\"URL notation\">URL žymėjimą</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 "Ši funkcija nustato failo ilgį. Jei „FileLen“ funkcija reikalinga atverti failą, ji grąžina failo ilgį iki jo atvėrimo. Norėdami nustatyti dabartinį atverto failo failo ilgį, naudokite funkciją „Lof“."
-
-#. j8DBv
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3163710\n"
-"help.text"
-msgid "Example:"
-msgstr "Pavyzdys:"
+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 "Konvertuoja bet kurį skaitinį reiškinį arba eilutės reiškinį į dvigubą tipą."
 
-#. jjGQH
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3149516\n"
-"help.text"
-msgid "Syntax"
-msgstr "Sintaksė"
-
-#. aTHD8
+#. wEVGF
 #: 03100400.xhp
 msgctxt ""
 "03100400.xhp\n"
 "par_id3156152\n"
 "help.text"
-msgid "CDbl (Expression)"
-msgstr "CDbl (reiškinys)"
-
-#. 38G4w
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3153061\n"
-"help.text"
-msgid "Return value"
-msgstr "Grąžinama reikšmė"
-
-#. LM9Ye
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrai:"
-
-#. 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>Reiškinys:</emph> Bet kuris eilutės ar skaitinis reiškinys, kurį norite konvertuoti. Norėdami konvertuoti eilutės reiškinį, skaičius turi būti įvestas grynuoju tekstu („123,5“) naudojant numatytąjį operacinės sistemos skaičių formatą."
-
-#. HxfeM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3148797\n"
-"help.text"
-msgid "Example:"
-msgstr "Pavyzdys:"
+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 "Konvertuoja bet kokią eilutę ar skaitinį reiškinį į sveikąjį skaičių."
 
-#. AFSBH
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147573\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaksė:"
-
-#. ZGxYP
+#. CCHrN
 #: 03100500.xhp
 msgctxt ""
 "03100500.xhp\n"
 "par_id3154142\n"
 "help.text"
-msgid "CInt (Expression)"
-msgstr "CInt (reiškinys)"
-
-#. AQaNC
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147531\n"
-"help.text"
-msgid "Return value:"
-msgstr "Grąžinama reikšmė:"
-
-#. a2YC7
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3145069\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrai:"
-
-#. 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 "Konvertuoja bet kokią eilutę ar skaitinį reiškinį į ilgąjį sveikąjį skaičių."
 
-#. CtL6e
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145315\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Sintaksė:"
-
-#. 3HnrW
+#. 8aFmF
 #: 03100600.xhp
 msgctxt ""
 "03100600.xhp\n"
 "par_id3147573\n"
 "help.text"
-msgid "CLng (Expression)"
-msgstr "CLng (reiškinys)"
-
-#. iViY7
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3145610\n"
-"help.text"
-msgid "Return value:"
-msgstr "Grąžinama reikšmė:"
-
-#. pC3ZX
-#: 03100600.xhp
-msgctxt ""
-"03100600.xhp\n"
-"hd_id3154760\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrai:"
+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>Reiškinys:</emph> Bet kuris skaitinis reiškinys, kurį norite konvertuoti. Jei <emph>reiškinys</emph> yra už galiojančio ilgojo sveikojo skaičiaus diapazono nuo -2,147,483,648 iki 2 147,483,647, tai „$[officename] Basic“ pateikia perpildymo klaidą. Norėdami konvertuoti eilutės reiškinį, skaičius turi būti įvestas grynuoju tekstu („123,5“) naudojant numatytąjį operacinės sistemos skaičių formatą."
+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 "Bet kurią eilutę ar skaitinį reiškinį paverčia duomenų atskiru tipu."
 
-#. BNPsA
+#. dQQAS
 #: 03100900.xhp
 msgctxt ""
 "03100900.xhp\n"
-"hd_id3153255\n"
+"par_id3148983\n"
 "help.text"
-msgid "Syntax:"
-msgstr "Sintaksė:"
+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 (reiškinys)"
+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 "Grąžinama reikšmė:"
+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 "Parametrai:"
+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>Reiškinys:</emph> Bet kokia eilutė ar skaitinis reiškinys, kurį norite konvertuoti. Norėdami konvertuoti eilutės reiškinį, skaičių reikia įvesti grynuoju tekstu („123,5“) naudojant numatytąjį operacinės sistemos skaičių formatą."
+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 "Pavyzdys:"
+msgid "MsgBox CSng(expression := 5678.1234) ' 5678.123535156"
+msgstr ""
 
 #. MCFBf
 #: 03101000.xhp
diff --git a/source/lt/helpcontent2/source/text/sbasic/shared/03.po b/source/lt/helpcontent2/source/text/sbasic/shared/03.po
index cf765eeef6c..e796478aba6 100644
--- a/source/lt/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/lt/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: 2021-02-01 16:24+0000\n"
 "Last-Translator: Valentina Dagiene <valentina.dagiene@mif.vu.lt>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/lt/>\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/lt/helpcontent2/source/text/sdatabase.po b/source/lt/helpcontent2/source/text/sdatabase.po
index 7cb7de2e0fc..2c8ae1fcdb9 100644
--- a/source/lt/helpcontent2/source/text/sdatabase.po
+++ b/source/lt/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: 2021-01-25 14:07+0000\n"
 "Last-Translator: Valentina Dagiene <valentina.dagiene@mif.vu.lt>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/lt/>\n"
@@ -384,14 +384,14 @@ msgctxt ""
 msgid "<bookmark_value>views; creating database views (Base)</bookmark_value>  <bookmark_value>queries; creating in design view (Base)</bookmark_value>  <bookmark_value>designing; queries (Base)</bookmark_value>  <bookmark_value>design view; queries/views (Base)</bookmark_value>  <bookmark_value>joining;tables (Base)</bookmark_value>  <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value>  <bookmark_value>queries; joining tables (Base)</bookmark_value>  <bookmark_value>tables in databases; relations (Base)</bookmark_value>  <bookmark_value>relations; joining tables (Base)</bookmark_value>  <bookmark_value>queries; deleting table links (Base)</bookmark_value>  <bookmark_value>criteria of query design (Base)</bookmark_value>  <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value>  <bookmark_value>filter conditions;in queries (Base)</bookmark_value>  <bookmark_value>parameters; queries (Base)</bookmark_value>  <bookmark_value>queries; parameter queries (Base)</bookmark_value>  <bookmark_value>SQL; queries (Base)</bookmark_value>  <bookmark_value>native SQL (Base)</bookmark_value>"
 msgstr "<bookmark_value>rodiniai; duomenų bazių rodinių kūrimas (Base)</bookmark_value>  <bookmark_value>užklausos; kūrimas projektavimo veiksenoje (Base)</bookmark_value>  <bookmark_value>kūrimas; užklausos (Base)</bookmark_value>  <bookmark_value>projektavimo veiksena; užklausos ir rodiniai (Base)</bookmark_value>  <bookmark_value>jungimas;lentelės (Base)</bookmark_value>  <bookmark_value>lentelės duomenų bazėse; jungimas užklausose (Base)</bookmark_value>  <bookmark_value>užklausos; lentelių jungimas (Base)</bookmark_value>  <bookmark_value>lentelės duomenų bazėse; sąryšiai (Base)</bookmark_value>  <bookmark_value>sąryšiai; lentelių jungimas (Base)</bookmark_value>  <bookmark_value>užklausos; lentelių saitų šalinimas (Base)</bookmark_value>  <bookmark_value>užklausų kūrimo kriterijai (Base)</bookmark_value>  <bookmark_value>užklausos; filtravimo sąlygų formulavimas (Base)</bookmark_value>  <bookmark_value>filtravimo sąlygos;užklausos (Base)</bookmark_value>  <bookmark_value>parametrai; užklausos (Base)</bookmark_value>  <bookmark_value>užklausos; parametrų užklausos (Base)</bookmark_value>  <bookmark_value>SQL; užklausos (Base)</bookmark_value>  <bookmark_value>savitoji SQL kalba (Base)</bookmark_value>"
 
-#. fmcBY
+#. 2BrD2
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "hd_id3153394\n"
 "help.text"
-msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Query Design</link>"
-msgstr "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Užklausų kūrimas</link>"
+msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>"
+msgstr ""
 
 #. GU8Jd
 #: 02010100.xhp
@@ -447,14 +447,14 @@ msgctxt ""
 msgid "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>."
 msgstr "Užklausai sukurti duomenų bazių programos lange spustelėkite mygtuką <emph>Užklausos</emph>, tuomet spustelėkite komandą <emph>Kurti užklausą projektavimo veiksenoje</emph>."
 
-#. EN5uU
+#. AtAHv
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3150255\n"
 "help.text"
-msgid "The lower pane of the Design View is where you <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
-msgstr "Užklausa <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">kuriama</link> apatiniame užklausų kūrimo lango polangyje. Užklausai sukurti nurodykite į ją įtrauktinų <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">laukų pavadinimus</link> ir <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">kriterijus</link> tiems laukams atvaizduoti. Jei norite pakeisti stulpelių tvarką apatiniame užklausos kūrimo lango polangyje, tempkite stulpelio antraštę į norimą vietą arba pažymėkite stulpelį ir spauskite <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Vald</emph></defaultinline></switchinline> ir <emph>rodyklių</emph> klavišus."
+msgid "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the  criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key."
+msgstr ""
 
 #. GMVkG
 #: 02010100.xhp
@@ -924,15 +924,6 @@ msgctxt ""
 msgid "For example:"
 msgstr "Pavyzdžiui:"
 
-#. ynSGq
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148478\n"
-"help.text"
-msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\""
-msgstr "SELECT \"PrNr\" AS \"PrekėsNr\" FROM \"Prekės\""
-
 #. roTzi
 #: 02010100.xhp
 msgctxt ""
@@ -996,14 +987,14 @@ msgctxt ""
 msgid "Criteria"
 msgstr "Kriterijus"
 
-#. f3DvJ
+#. fWRgB
 #: 02010100.xhp
 msgctxt ""
 "02010100.xhp\n"
 "par_id3145134\n"
 "help.text"
-msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Nurodomas pirmasis <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">kriterijus</link>, pagal kurį bus filtruojamas duomenų lauko turinys.</ahelp>"
+msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>"
+msgstr ""
 
 #. qpADC
 #: 02010100.xhp
@@ -2157,15 +2148,6 @@ msgctxt ""
 msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}"
 msgstr "Operatoriaus <emph>LIKE</emph> kaitos seka: {escape 'kaitos_seka'}"
 
-#. Cy7Cc
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3150661\n"
-"help.text"
-msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}"
-msgstr "Pavyzdys: SELECT * FROM prekės WHERE PrekėsPavad LIKE 'Naujas *%' {escape '*'}"
-
 #. newGb
 #: 02010100.xhp
 msgctxt ""
@@ -2184,15 +2166,6 @@ msgctxt ""
 msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}"
 msgstr "Operatoriaus <emph>OUTER JOIN</emph> kaitos seka: {oj outer-join-sakinys}"
 
-#. 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 "Pavyzdys: SELECT Daiktas.* FROM {oj prekės LEFT OUTER JOIN užsakymai ON prekės.nr=užsakymai.PNR}"
-
 #. mWG9p
 #: 02010100.xhp
 msgctxt ""
@@ -2292,24 +2265,6 @@ msgctxt ""
 msgid "DateTime"
 msgstr "Data ir laikas"
 
-#. FqZXM
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149539\n"
-"help.text"
-msgid "Example: select {d '1999-12-31'} from world.years"
-msgstr "Pavyzdys: select {d '1999-12-31'} from world.years"
-
-#. WJ4YB
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3149540\n"
-"help.text"
-msgid "Example: select * from mytable where years='1999-12-31'"
-msgstr "Pavyzdys: select * from lentelė where metai='1999-12-31'"
-
 #. CZdA4
 #: 02010100.xhp
 msgctxt ""
@@ -2481,14 +2436,14 @@ 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 "Ir projektavimo, ir SQL veiksenoje prieš parametrų vardus rašomas dvitaškis. Parametro vardą galima įrašyti visur, kur tik turėtų būti kokia nors reikšmė. Jei užklausoje ta pati reikšmė reikalinga keletą kartų, galima naudoti tą patį parametro vardą."
 
-#. 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>"
-msgstr "Paprasčiausiu atveju vietoje reikšmės, kuri vykdant užklausą bus lyginama su duomenų lauko turiniu, <emph>kriterijaus</emph> laukelyje įrašykite parametro vardą su dvitaškiu priekyje. <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL veiksenoje</link> reikėtų rašyti šitaip: <item type=\"input\">WHERE \"Laukas\" = :Parametro_vardas</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
 #: 02010100.xhp
@@ -2499,14 +2454,14 @@ 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 "Parametrų varduose negali būti tarpų ir šių rašmenų: <item type=\"input\">`!\"$%^*()+={}[]@'~#<>?/,</item>. Parametrų vardai negali sutapti su duomenų laukų pavadinimais ar SQL komandomis, tačiau gali būti tokie patys, kaip alternatyvieji vardai."
 
-#. 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>."
-msgstr "Geras būdas filtruoti teksto laukus pagal dalį teksto – į užklausą įtraukti paslėptą stulpelį su kriterijumi <item type=\"input\">\"LIKE '%' || :Lauko_teksto_fragmentas || '%'\"</item>. Pagal tokį kriterijų bus randami įrašai su tiksliu teksto fragmentu. Jei užklausą norite vykdyti neatsižvelgiant į raidžių lygį, lauką užklausoje galima nurodyti taip: <item type=\"input\">LOWER (Lauko_pavadinimas)</item>, o kriterijų – šitaip: <item type=\"input\">LIKE LOWER ( '%' || :Lauko_teksto_fragmentas || '%' )</item>. Tarpai kriterijaus apraše yra svarbūs – jei juos praleisite, SQL analizatorius interpretuos visą kriterijų kaip ieškomą tekstą. <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL veiksenoje</link> tokią užklausą reikėtų užrašyti šitaip: <item type=\"input\">LOWER ( \"Lauko_pavadinimas\" ) LIKE LOWER ( '%' || :Lauko_teksto_fragmentas || '%' )</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
 #: 02010100.xhp
@@ -5919,6 +5874,42 @@ msgctxt ""
 msgid "For more information on SQL commands, please consult the documentation that came with the database."
 msgstr ""
 
+#. hdoAK
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id91652478785999\n"
+"help.text"
+msgid "Show output of \"select\" statements"
+msgstr ""
+
+#. nB4gp
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id281652481037143\n"
+"help.text"
+msgid "Show the result of the SQL SELECT command in the Output box."
+msgstr ""
+
+#. uaXF8
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154071\n"
+"help.text"
+msgid "Execute"
+msgstr ""
+
+#. 6UCdY
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151210\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute</emph> box.</ahelp>"
+msgstr ""
+
 #. BQmT9
 #: 11080000.xhp
 msgctxt ""
@@ -5928,13 +5919,13 @@ msgctxt ""
 msgid "Previous commands"
 msgstr ""
 
-#. hkxBT
+#. 8AWBX
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
 "par_id3149045\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Execute</emph>.</ahelp>"
 msgstr ""
 
 #. AvXck
@@ -5946,31 +5937,31 @@ msgctxt ""
 msgid "Status"
 msgstr ""
 
-#. yhCpt
+#. 7RS4e
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
 "par_id3151054\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the status, including errors, of the SQL command that you ran.</ahelp>"
 msgstr ""
 
-#. BUpxX
+#. 8qcm5
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
-"hd_id3154071\n"
+"hd_id841652479655639\n"
 "help.text"
-msgid "Run"
+msgid "Output"
 msgstr ""
 
-#. qDYRx
+#. pEFoq
 #: 11080000.xhp
 msgctxt ""
 "11080000.xhp\n"
-"par_id3151210\n"
+"par_id511652479714010\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>"
+msgid "Displays the results of the SQL command that you ran."
 msgstr ""
 
 #. 93Xfs
diff --git a/source/lt/helpcontent2/source/text/shared/06.po b/source/lt/helpcontent2/source/text/shared/06.po
index dcb8247b628..a996e746f93 100644
--- a/source/lt/helpcontent2/source/text/shared/06.po
+++ b/source/lt/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: 2020-11-01 10:35+0000\n"
 "Last-Translator: Modestas Rimkus <modestas.rimkus@gmail.com>\n"
 "Language-Team: Lithuanian <https://weblate.documentfoundation.org/projects/libo_help-master/textshared06/lt/>\n"
@@ -474,21 +474,3 @@ msgctxt ""
 "help.text"
 msgid "YouTube Videos"
 msgstr "„YouTube“ vaizdo įrašai"
-
-#. 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/lt/helpcontent2/source/text/shared/guide.po b/source/lt/helpcontent2/source/text/shared/guide.po
index 6a79b8d93fe..4c8f345ee70 100644
--- a/source/lt/helpcontent2/source/text/shared/guide.po
+++ b/source/lt/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2021-01-30 10:36+0000\n"
 "Last-Translator: Modestas Rimkus <modestas.rimkus@gmail.com>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textsharedguide/lt/>\n"
@@ -5749,14 +5749,14 @@ msgctxt ""
 msgid "Inserting into a text document"
 msgstr "Įterpimas į teksto dokumentą"
 
-#. 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 "Įdėtas grafikos objektas pririšamas prie veikiamosios pastraipos. Prieraišą galima pakeisti pažymėjus objektą ir spustelėjus mygtuką <emph>Prieraišas</emph> mygtukų juostose <emph>OLE objektas</emph> arba <emph>Kadras</emph>. Mygtuku atveriamas meniu, kuriame galima pasirinkti norimo tipo prieraišą."
+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/lt/helpcontent2/source/text/shared/help.po b/source/lt/helpcontent2/source/text/shared/help.po
index 53f0e7c8670..335b1aefcef 100644
--- a/source/lt/helpcontent2/source/text/shared/help.po
+++ b/source/lt/helpcontent2/source/text/shared/help.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-02-09 16:45+0100\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2020-11-02 14:56+0000\n"
 "Last-Translator: Modestas Rimkus <modestas.rimkus@gmail.com>\n"
 "Language-Team: Lithuanian <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedhelp/lt/>\n"
@@ -862,6 +862,24 @@ msgctxt ""
 msgid "<variable id=\"xap_didyoumean\">Did you mean:</variable>"
 msgstr "<variable id=\"xap_didyoumean\">Ar turėjote omenyje:</variable>"
 
+#. PrbPA
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"hd_id471652287598699\n"
+"help.text"
+msgid "<variable id=\"externalvideo\">External video</variable>"
+msgstr ""
+
+#. CKGLp
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"par_id311644338760624\n"
+"help.text"
+msgid "<variable id=\"ytaccept\">Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.</variable>"
+msgstr ""
+
 #. BvoqF
 #: browserhelp.xhp
 msgctxt ""
@@ -870,3 +888,12 @@ msgctxt ""
 "help.text"
 msgid "<variable id=\"ytbutton\">Accept YouTube Content</variable>"
 msgstr ""
+
+#. jDvUs
+#: browserhelp.xhp
+msgctxt ""
+"browserhelp.xhp\n"
+"par_id91644338793051\n"
+"help.text"
+msgid "<variable id=\"ytprivacy\">YouTube Privacy Policy</variable>"
+msgstr ""
diff --git a/source/lt/helpcontent2/source/text/shared/optionen.po b/source/lt/helpcontent2/source/text/shared/optionen.po
index afb2b269f46..ae6ffabe84c 100644
--- a/source/lt/helpcontent2/source/text/shared/optionen.po
+++ b/source/lt/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: 2021-02-03 19:36+0000\n"
 "Last-Translator: Modestas Rimkus <modestas.rimkus@gmail.com>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textsharedoptionen/lt/>\n"
@@ -5569,24 +5569,6 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/opthtmlpage/savegrflocal\">Mark this check box to automatically upload the embedded pictures to the Internet server when uploading using FTP. Use the <emph>Save As</emph> dialog to save the document and enter a complete FTP URL as the file name in the Internet.</ahelp>"
 msgstr "<ahelp hid=\"cui/ui/opthtmlpage/savegrflocal\">Šią parinktį pažymėkite, jei norite, kad eksportuojamame dokumente esantys paveikslai būtų automatiškai kopijuojami į serverį, kai tinklalapį į serverį siunčiate FTP protokolu. Pasirinkite komandą <emph>Įrašyti kaip</emph> ir atsivėrusiame dialogo lange, failo vardo laukelyje įveskite visą failo FTP URL adresą.</ahelp>"
 
-#. tBaEs
-#: 01030500.xhp
-msgctxt ""
-"01030500.xhp\n"
-"hd_id3152960\n"
-"help.text"
-msgid "Character set"
-msgstr "Koduotė"
-
-#. giSiE
-#: 01030500.xhp
-msgctxt ""
-"01030500.xhp\n"
-"par_id3149018\n"
-"help.text"
-msgid "<ahelp hid=\"cui/ui/opthtmlpage/charset\">Select the appropriate character set for the export</ahelp>."
-msgstr "<ahelp hid=\"cui/ui/opthtmlpage/charset\">Parinkite eksportuojamam dokumentui tinkamą koduotę.</ahelp>"
-
 #. CGmvv
 #: 01040000.xhp
 msgctxt ""
diff --git a/source/lt/helpcontent2/source/text/swriter.po b/source/lt/helpcontent2/source/text/swriter.po
index e48c2c52403..f44d2a833c1 100644
--- a/source/lt/helpcontent2/source/text/swriter.po
+++ b/source/lt/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: 2021-01-21 14:36+0000\n"
 "Last-Translator: Valentina Dagiene <valentina.dagiene@mif.vu.lt>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textswriter/lt/>\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=\"Kadro savybės\">Kadro savybės</link>"
 
-#. vjbUV
+#. uXf8a
 #: main0216.xhp
 msgctxt ""
 "main0216.xhp\n"
 "tit\n"
 "help.text"
-msgid "OLE-Object Bar"
-msgstr "OLE objekto mygtukų juosta"
+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 objekto mygtukų juosta\">OLE objekto mygtukų juosta</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 objekto </emph>juosta rodoma, kai pažymėtas objektas. Joje yra pagrindinės funkcijos objektams formatuoti ir jų padėčiai nustatyti.</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/lt/helpcontent2/source/text/swriter/01.po b/source/lt/helpcontent2/source/text/swriter/01.po
index 5243e8ba1a7..efc5165175a 100644
--- a/source/lt/helpcontent2/source/text/swriter/01.po
+++ b/source/lt/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
 "PO-Revision-Date: 2021-01-31 19:36+0000\n"
 "Last-Translator: Tolmantas <tolmantas.dagys@gmail.com>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textswriter01/lt/>\n"
@@ -4455,13 +4455,13 @@ msgctxt ""
 msgid "Insert Manual Break"
 msgstr "Įterpti lūžį rankiniu būdu"
 
-#. 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/lt/helpcontent2/source/text/swriter/guide.po b/source/lt/helpcontent2/source/text/swriter/guide.po
index bea70687f2a..464d4b48ed9 100644
--- a/source/lt/helpcontent2/source/text/swriter/guide.po
+++ b/source/lt/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: 2021-01-31 19:36+0000\n"
 "Last-Translator: Valentina Dagiene <valentina.dagiene@mif.vu.lt>\n"
 "Language-Team: Lithuanian <https://translations.documentfoundation.org/projects/libo_help-master/textswriterguide/lt/>\n"
@@ -1609,14 +1609,14 @@ msgctxt ""
 msgid "Select the object for which you want to define a border."
 msgstr "Pasirinkti objektą, kuriuo norite apibrėžti kraštinę."
 
-#. 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 "Paspauskite <emph>Kraštinės</emph> piktogramą <emph>OLE objektas</emph> mygtukų juostoje arba <emph>Kadras</emph> mygtukų juostoje atverkite <emph>Kraštinės</emph> langą."
+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