aboutsummaryrefslogtreecommitdiff
path: root/source/bo/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2022-05-25 13:25:24 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2022-05-25 13:27:50 +0200
commitbaa28fb3a6161fa057808d25b69ce24e21a1f9d8 (patch)
tree57a60ae046b0a3b136026e9bb71cf261a47e7a54 /source/bo/helpcontent2
parent9ef7b8c2ece5a5fc774c5226151a84a84958015e (diff)
update translations for master/7.4
and force-fix errors using pocheck Change-Id: I6791c0fed18c372d154a25de9c826720bb037af8
Diffstat (limited to 'source/bo/helpcontent2')
-rw-r--r--source/bo/helpcontent2/source/text/sbasic/shared.po266
-rw-r--r--source/bo/helpcontent2/source/text/sbasic/shared/03.po533
-rw-r--r--source/bo/helpcontent2/source/text/sdatabase.po123
-rw-r--r--source/bo/helpcontent2/source/text/shared/06.po20
-rw-r--r--source/bo/helpcontent2/source/text/shared/guide.po8
-rw-r--r--source/bo/helpcontent2/source/text/shared/help.po29
-rw-r--r--source/bo/helpcontent2/source/text/shared/optionen.po20
-rw-r--r--source/bo/helpcontent2/source/text/swriter.po20
-rw-r--r--source/bo/helpcontent2/source/text/swriter/01.po6
-rw-r--r--source/bo/helpcontent2/source/text/swriter/guide.po6
10 files changed, 700 insertions, 331 deletions
diff --git a/source/bo/helpcontent2/source/text/sbasic/shared.po b/source/bo/helpcontent2/source/text/sbasic/shared.po
index 7298ac59452..f8e17d76bb2 100644
--- a/source/bo/helpcontent2/source/text/sbasic/shared.po
+++ b/source/bo/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: 2019-08-09 08:32+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -10807,32 +10807,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
@@ -11869,41 +11869,14 @@ msgctxt ""
msgid "Returns the length of a file in bytes."
msgstr "ཕྱིར་ལོག་ཡིག་ཆའི་རིང་ཚད་ནི་ཡིག་ཚིགས་ཀྱིས་སྡེ་ཚན་བྱེད།"
-#. GfNg3
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"hd_id3159414\n"
-"help.text"
-msgid "Syntax:"
-msgstr "བརྡ་འཕྲོད་"
-
-#. MoBSd
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3149656\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 "ཕྱིར་ལོག་ཐང་"
-
-#. H2KXW
+#. RpGc5
#: 03020408.xhp
msgctxt ""
"03020408.xhp\n"
-"hd_id3150768\n"
+"par_id401651744449325\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
@@ -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>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 "དཔེ་གཞི་"
+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 "གྲངས་ཀའི་མཚོན་ཚུལ་ལམ་ཡིག་རྟགས་ཕྲེང་བ་མཚོན་ཚུལ་གང་རུང་དག་ཆད་ཆ་ཅན་གྱི་རིགས་ལ་བརྗེ་བསྒྱུར་བྱས།"
-#. 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>བརྗེ་བསྒྱུར་བྱ་དགོས་པའི་ཡིག་རྟགས་ཕྲེང་བའམ་གྲངས་ཀའི་མཚོན་ཚུལ་གང་རུང་།"
-
-#. HxfeM
-#: 03100400.xhp
-msgctxt ""
-"03100400.xhp\n"
-"hd_id3148797\n"
-"help.text"
-msgid "Example:"
-msgstr "དཔེ་གཞི་"
+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 "ཡིག་རྟགས་ཕྲེང་གང་རུང་ངམ་གྲངས་ཀའི་མཚོན་ཚུལ་དེ་ཧྲིལ་གྲངས་ལ་བརྗེ་བསྒྱུར་བྱེད།"
-#. AFSBH
-#: 03100500.xhp
-msgctxt ""
-"03100500.xhp\n"
-"hd_id3147573\n"
-"help.text"
-msgid "Syntax:"
-msgstr "བརྡ་འཕྲོད་"
-
-#. 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 "ཕྱིར་ལོག་ཐང་"
-
-#. 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
@@ -25234,50 +25108,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 "བརྡ་འཕྲོད་"
-
-#. 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 "ཕྱིར་ལོག་ཐང་"
-
-#. 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] ཧུང་གིས་ཕྱིར་ལུད་པའི་ནོར་འཁྲུལ་ལ་ཕྱིར་ལོག་བྱེད། ཡིག་རྟགས་ཕྲེང་བའི་མཚོན་ཚུལ་བརྗེ་བསྒྱུར་བྱ་དགོས་ན་ངེས་པར་དུ་བཀོལ་སྤྱོད་མ་ལག་གིས་ཁས་བླངས་པའི་རྣམ་གཞག་བེད་སྤྱོད་བྱེད་དགོས་ གྲངས་དེ་སྤྱིར་བཏང་ཡི་གེ་ (\"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
@@ -25513,59 +25360,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 "བརྡ་འཕྲོད་"
+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 "ཕྱིར་ལོག་ཐང་"
+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 "<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>བརྗེ་བསྒྱུར་བྱ་དགོས་པའི་ཡིག་རྟགས་ཕྲེང་བའམ་གྲངས་ཀའི་མཚོན་ཚུལ་གང་རུང་།"
+msgid "MsgBox CSng(1234.5678) ' 1234.567749023"
+msgstr ""
-#. kT9UB
+#. rf5Br
#: 03100900.xhp
msgctxt ""
"03100900.xhp\n"
-"hd_id3149514\n"
+"par_idm1341608242\n"
"help.text"
-msgid "Example:"
-msgstr "དཔེ་གཞི་"
+msgid "MsgBox CDbl(expression := 5678.1234) ' 5678.1234"
+msgstr ""
+
+#. uVUDG
+#: 03100900.xhp
+msgctxt ""
+"03100900.xhp\n"
+"par_idm1341604408\n"
+"help.text"
+msgid "MsgBox CSng(expression := 5678.1234) ' 5678.123535156"
+msgstr ""
#. MCFBf
#: 03101000.xhp
diff --git a/source/bo/helpcontent2/source/text/sbasic/shared/03.po b/source/bo/helpcontent2/source/text/sbasic/shared/03.po
index b92bebc40b8..3e9dd9883ae 100644
--- a/source/bo/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/bo/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:26+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/bo/helpcontent2/source/text/sdatabase.po b/source/bo/helpcontent2/source/text/sdatabase.po
index 28f605f77b2..ce47d8eda3e 100644
--- a/source/bo/helpcontent2/source/text/sdatabase.po
+++ b/source/bo/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/bo/helpcontent2/source/text/shared/06.po b/source/bo/helpcontent2/source/text/shared/06.po
index 6faab0d6a7c..90767280961 100644
--- a/source/bo/helpcontent2/source/text/shared/06.po
+++ b/source/bo/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 12:41+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/bo/helpcontent2/source/text/shared/guide.po b/source/bo/helpcontent2/source/text/shared/guide.po
index 153f5282c99..eec32989c56 100644
--- a/source/bo/helpcontent2/source/text/shared/guide.po
+++ b/source/bo/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
"PO-Revision-Date: 2018-11-14 11:52+0000\n"
"Last-Translator: Anonymous Pootle User\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/bo/helpcontent2/source/text/shared/help.po b/source/bo/helpcontent2/source/text/shared/help.po
index fec0ba87fde..48a7f5214d2 100644
--- a/source/bo/helpcontent2/source/text/shared/help.po
+++ b/source/bo/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 13:20+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/bo/helpcontent2/source/text/shared/optionen.po b/source/bo/helpcontent2/source/text/shared/optionen.po
index 811ab0d1cad..06b0fee92e6 100644
--- a/source/bo/helpcontent2/source/text/shared/optionen.po
+++ b/source/bo/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: 2018-11-14 11:52+0000\n"
"Last-Translator: Anonymous Pootle User\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/bo/helpcontent2/source/text/swriter.po b/source/bo/helpcontent2/source/text/swriter.po
index 198a3800c1e..42b0dc06f1a 100644
--- a/source/bo/helpcontent2/source/text/swriter.po
+++ b/source/bo/helpcontent2/source/text/swriter.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-10 20:16+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
"PO-Revision-Date: 2018-10-21 20:04+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2590,32 +2590,32 @@ msgctxt ""
msgid "<link href=\"text/swriter/01/04130000.xhp\" name=\"Frame Properties\">Frame Properties</link>"
msgstr "<link href=\"text/swriter/01/04130000.xhp\" name=\"ཡིག་དེབ་སྒྲོམ་\">ཡིག་དེབ་སྒྲོམ་</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/bo/helpcontent2/source/text/swriter/01.po b/source/bo/helpcontent2/source/text/swriter/01.po
index 3161fd05209..4027227a4d5 100644
--- a/source/bo/helpcontent2/source/text/swriter/01.po
+++ b/source/bo/helpcontent2/source/text/swriter/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-05-12 11:50+0200\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
"PO-Revision-Date: 2018-10-21 20:04+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4453,13 +4453,13 @@ msgctxt ""
msgid "Insert Manual Break"
msgstr "བར་གཅོད་རྟགས།"
-#. 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/bo/helpcontent2/source/text/swriter/guide.po b/source/bo/helpcontent2/source/text/swriter/guide.po
index 9117b5f719b..45c9dcfd49f 100644
--- a/source/bo/helpcontent2/source/text/swriter/guide.po
+++ b/source/bo/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2022-03-21 12:32+0100\n"
+"POT-Creation-Date: 2022-05-25 12:37+0200\n"
"PO-Revision-Date: 2018-11-12 13:20+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -1609,13 +1609,13 @@ 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."
+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