update translations for 7.5.0 rc1/master

and force-fix errors using pocheck

Change-Id: I3c9458097e8ea70e7931e1646095b0da3f5a04eb

5 files changed, 1608 insertions, 51 deletions

diff --git a/source/ja/helpcontent2/source/text/sbasic/shared.po b/source/ja/helpcontent2/source/text/sbasic/shared.po
index 84ce2a04e70..9d59e2a9561 100644
--- a/source/ja/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ja/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-12-07 19:22+0100\n"
+"POT-Creation-Date: 2022-12-19 15:00+0100\n"
 "PO-Revision-Date: 2022-05-22 12:51+0000\n"
 "Last-Translator: JO3EMC <jo3emc@jarl.com>\n"
 "Language-Team: Japanese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/ja/>\n"
@@ -27916,40 +27916,22 @@ msgctxt ""
 msgid "Returns text or a numeric value that contain type information for a variable."
 msgstr ""
 
-#. Dytbi
-#: 03103600.xhp
-msgctxt ""
-"03103600.xhp\n"
-"par_id3155341\n"
-"help.text"
-msgid "TypeName (Varname As Variant) As String"
-msgstr ""
-
-#. gBaWF
-#: 03103600.xhp
-msgctxt ""
-"03103600.xhp\n"
-"par_id3155342\n"
-"help.text"
-msgid "VarType (Varname As Variant) As Integer"
-msgstr ""
-
-#. f2DSC
+#. 9pCYi
 #: 03103600.xhp
 msgctxt ""
 "03103600.xhp\n"
 "par_id591667555032629\n"
 "help.text"
-msgid "Text for <literal>TypeName</literal> suffixed with '()' for arrays."
+msgid "A text for <literal>TypeName</literal> suffixed with '()' for arrays."
 msgstr ""
 
-#. DXU2g
+#. 2XLBM
 #: 03103600.xhp
 msgctxt ""
 "03103600.xhp\n"
 "par_id371667555034757\n"
 "help.text"
-msgid "Integer for <literal>VarType</literal>. <literal>8192</literal> is added to the returned value for arrays."
+msgid "An integer for <literal>VarType</literal>. The number 8192 is added to the returned value for arrays of type <literal>VarType</literal>."
 msgstr ""
 
 #. 3xswS
diff --git a/source/ja/helpcontent2/source/text/sbasic/shared/03.po b/source/ja/helpcontent2/source/text/sbasic/shared/03.po
index 2ec6420d21c..d18f6cf5556 100644
--- a/source/ja/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/ja/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-12-07 19:22+0100\n"
+"POT-Creation-Date: 2022-12-19 15:00+0100\n"
 "PO-Revision-Date: 2021-11-26 20:38+0000\n"
 "Last-Translator: Jun NOGATA <nogajun@gmail.com>\n"
 "Language-Team: Japanese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/ja/>\n"
@@ -2824,6 +2824,114 @@ msgctxt ""
 msgid "If form documents are organized in folders, it becomes necessary to include the folder name to specify the form document to be opened, as illustrated in the following example:"
 msgstr ""
 
+#. FfnCL
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id31599490604484\n"
+"help.text"
+msgid "Opens the Data View window of the specified query and returns an instance of the <literal>Datasheet</literal> service."
+msgstr ""
+
+#. y7bbd
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281671113374329\n"
+"help.text"
+msgid "The query can be opened either in normal or design mode."
+msgstr ""
+
+#. PteVF
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id801671111609985\n"
+"help.text"
+msgid "If the query is already open, its Data View window will be made active."
+msgstr ""
+
+#. PD6CC
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id521671113436716\n"
+"help.text"
+msgid "Closing the Base document will cause the Data View window to be closed as well."
+msgstr ""
+
+#. h53Y2
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id701599490609511\n"
+"help.text"
+msgid "<emph>queryname</emph>: The name of an existing query as a case-sensitive String."
+msgstr ""
+
+#. tfZPA
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id461671113939669\n"
+"help.text"
+msgid "<emph>designmode</emph>: If this argument is set to <literal>True</literal> the query is opened in design mode. Otherwise it is opened in normal mode (Default = <literal>False</literal>)."
+msgstr ""
+
+#. f8xGi
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id31599490604787\n"
+"help.text"
+msgid "Opens the Data View window of the specified table and returns an instance of the <literal>Datasheet</literal> service."
+msgstr ""
+
+#. kJ7je
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281671113374441\n"
+"help.text"
+msgid "The table can be opened either in normal or design mode."
+msgstr ""
+
+#. mLCsE
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id801671111609395\n"
+"help.text"
+msgid "If the table is already open, its Data View window will be made active."
+msgstr ""
+
+#. CewtN
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id521671113436658\n"
+"help.text"
+msgid "Closing the Base document will cause the Data View window to be closed as well."
+msgstr ""
+
+#. 7Ub95
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id701599490609099\n"
+"help.text"
+msgid "<emph>tablename</emph>: The name of an existing table as a case-sensitive String."
+msgstr ""
+
+#. E2TZg
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id461671113939471\n"
+"help.text"
+msgid "<emph>designmode</emph>: If this argument is set to <literal>True</literal> the table is opened in design mode. Otherwise it is opened in normal mode (Default = <literal>False</literal>)."
+msgstr ""
+
 #. zzgBi
 #: sf_base.xhp
 msgctxt ""
@@ -3265,6 +3373,24 @@ msgctxt ""
 msgid "<emph>servicename</emph>: A fully qualified service name such as <literal>com.sun.star.ui.dialogs.FilePicker</literal> or <literal>com.sun.star.sheet.FunctionAccess</literal>."
 msgstr ""
 
+#. o4TnR
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651589200135438\n"
+"help.text"
+msgid "Returns an instance of a UNO structure of the specified type."
+msgstr ""
+
+#. ojWzv
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id3615892001216366\n"
+"help.text"
+msgid "<emph>unostructure</emph>: A fully qualified structure name such as <literal>com.sun.star.beans.Property</literal> or <literal>com.sun.star.util.DateTime</literal>."
+msgstr ""
+
 #. rZoCx
 #: sf_basic.xhp
 msgctxt ""
@@ -5029,13 +5155,175 @@ msgctxt ""
 msgid "Clears all the contents and formats of the given range."
 msgstr ""
 
-#. M5PqA
+#. kjBF4
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id961670941803758\n"
+"help.text"
+msgid "A filter formula can be specified to determine which cells shall be affected."
+msgstr ""
+
+#. UXnVo
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id441592919577809\n"
 "help.text"
-msgid "<emph>range</emph>: The range to be cleared, as a string."
+msgid "<emph>range:</emph> The range to be cleared, as a string."
+msgstr ""
+
+#. Bq7qT
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id351670939954166\n"
+"help.text"
+msgid "<emph>filterformula:</emph> A Calc formula that shall be applied to the given range to determine which cells will be affected. The specified formula must return <literal>True</literal> or <literal>False</literal>. If this argument is not specified, then all cells in the range are affected."
+msgstr ""
+
+#. Lvzwc
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id461670939954392\n"
+"help.text"
+msgid "<emph>filterscope:</emph> Determines how <literal>filterformula</literal> is expanded to the given range. This argument is mandatory if a <literal>filterformula</literal> is specified. The following values are accepted:"
+msgstr ""
+
+#. 3pGBf
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id991670941074213\n"
+"help.text"
+msgid "<emph>\"CELL\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each cell in <literal>range</literal>."
+msgstr ""
+
+#. YGjYE
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id911670941074926\n"
+"help.text"
+msgid "<emph>\"ROW\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each row in <literal>range</literal>."
+msgstr ""
+
+#. Uufc3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id581670941075101\n"
+"help.text"
+msgid "<emph>\"COLUMN\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each column in <literal>range</literal>."
+msgstr ""
+
+#. gZzon
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id681670941294573\n"
+"help.text"
+msgid "' Clears all cells in the range SheetX.A1:J10"
+msgstr ""
+
+#. dZnwN
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id521592919577626\n"
+"help.text"
+msgid "oDoc.ClearAll(\"SheetX.A1:J10\")"
+msgstr ""
+
+#. SpP9R
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id681670941294511\n"
+"help.text"
+msgid "' Clears all cells in the range SheetX.A1:J10 that have a value greater than 100"
+msgstr ""
+
+#. 7Nnnv
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id521592919575446\n"
+"help.text"
+msgid "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")"
+msgstr ""
+
+#. 8CXRd
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id681670941233673\n"
+"help.text"
+msgid "' Clears all rows in the range SheetX.A1:J10 whose sum is greater than 500"
+msgstr ""
+
+#. pABDv
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id521592919518126\n"
+"help.text"
+msgid "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")"
+msgstr ""
+
+#. 5av7R
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id681670941293083\n"
+"help.text"
+msgid "' Clears all columns in the range SheetX.A1:J10 whose sum is greater than 500"
+msgstr ""
+
+#. Bp2iA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id521592919577149\n"
+"help.text"
+msgid "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")"
+msgstr ""
+
+#. jBH48
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id211621536212144\n"
+"help.text"
+msgid "myDoc.ClearAll(\"SheetX.A1:F10\")"
+msgstr ""
+
+#. CGEqi
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id701670942024915\n"
+"help.text"
+msgid "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")"
+msgstr ""
+
+#. GDBWA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id261670942025274\n"
+"help.text"
+msgid "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")"
+msgstr ""
+
+#. 3fSEb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id711670942025635\n"
+"help.text"
+msgid "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")"
 msgstr ""
 
 #. Wz6CH
@@ -5047,6 +5335,15 @@ msgctxt ""
 msgid "Clears the formats and styles in the given range."
 msgstr ""
 
+#. PqtC3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id961670941800058\n"
+"help.text"
+msgid "A filter formula can be specified to determine which cells shall be affected."
+msgstr ""
+
 #. 6Qxnv
 #: sf_calc.xhp
 msgctxt ""
@@ -5056,6 +5353,15 @@ msgctxt ""
 msgid "<emph>range</emph>: The range whose formats and styles are to be cleared, as a string."
 msgstr ""
 
+#. DLmLj
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id461670942481008\n"
+"help.text"
+msgid "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\" name=\"ClearAll_link3\"><literal>ClearAll</literal></link> method documentation available above for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>."
+msgstr ""
+
 #. sMwMp
 #: sf_calc.xhp
 msgctxt ""
@@ -5065,6 +5371,15 @@ msgctxt ""
 msgid "Clears the values and formulas in the given range."
 msgstr ""
 
+#. te7oW
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id961670941801218\n"
+"help.text"
+msgid "A filter formula can be specified to determine which cells shall be affected."
+msgstr ""
+
 #. eEGn9
 #: sf_calc.xhp
 msgctxt ""
@@ -5074,6 +5389,15 @@ msgctxt ""
 msgid "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string."
 msgstr ""
 
+#. odncJ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id461670942481009\n"
+"help.text"
+msgid "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\" name=\"ClearAll_link3\"><literal>ClearAll</literal></link> method documentation available above for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>."
+msgstr ""
+
 #. JWFDb
 #: sf_calc.xhp
 msgctxt ""
@@ -7198,6 +7522,15 @@ msgctxt ""
 msgid "<emph>style</emph>: The name of the cell style to apply."
 msgstr ""
 
+#. wbiBR
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id461670942481010\n"
+"help.text"
+msgid "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\" name=\"ClearAll_link3\"><literal>ClearAll</literal></link> method documentation available above for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>."
+msgstr ""
+
 #. DCAWV
 #: sf_calc.xhp
 msgctxt ""
@@ -9169,13 +9502,85 @@ msgctxt ""
 msgid "' Returns the first 50 employee records ordered by the 'FirstName' field"
 msgstr ""
 
-#. FMBEy
+#. BS9jq
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id31599490604484\n"
+"help.text"
+msgid "Opens the Data View window of the specified query and returns an instance of the <literal>Datasheet</literal> service."
+msgstr ""
+
+#. d2YTW
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id801671111609985\n"
+"help.text"
+msgid "If the query could not be opened, then <literal>Nothing</literal> is returned."
+msgstr ""
+
+#. FJFvm
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id701599490609511\n"
+"help.text"
+msgid "<emph>queryname</emph>: The name of an existing query as a case-sensitive String."
+msgstr ""
+
+#. yq6V3
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id31599490601045\n"
+"help.text"
+msgid "Runs a SQL <literal>SELECT</literal> command, opens a Data View window with the results and returns an instance of the <literal>Datasheet</literal> service."
+msgstr ""
+
+#. Hx5xV
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id701599490604461\n"
+"help.text"
+msgid "<emph>sql</emph>: A string containing a valid SQL SELECT statement. Identifiers may be enclosed by square brackets."
+msgstr ""
+
+#. kYGxU
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id51599490609622\n"
+"help.text"
+msgid "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis (Default = <literal>False</literal>)."
+msgstr ""
+
+#. hT2oS
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id31599490605021\n"
+"help.text"
+msgid "Opens the Data View window of the specified table and returns an instance of the <literal>Datasheet</literal> service."
+msgstr ""
+
+#. CGfTt
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id701599490609021\n"
+"help.text"
+msgid "<emph>tablename</emph>: The name of an existing table as a case-sensitive String."
+msgstr ""
+
+#. Wme4W
 #: sf_database.xhp
 msgctxt ""
 "sf_database.xhp\n"
 "par_id31599490609759\n"
 "help.text"
-msgid "Executes an action query of an SQL statement such as creating a table, as well as inserting, updating and deleting records."
+msgid "Executes an action query or an SQL statement such as creating a table, as well as inserting, updating and deleting records."
 msgstr ""
 
 #. gyiQy
@@ -9214,6 +9619,825 @@ msgctxt ""
 msgid "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. (Default = <literal>False</literal>). For queries, the applied option is the one set when the query was defined."
 msgstr ""
 
+#. 4TmY5
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDatabases.Datasheet service"
+msgstr ""
+
+#. fSnZf
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"ctrls_h1\"><link href=\"text/sbasic/shared/03/sf_datasheet.xhp\" name=\"SFDatabases.Datasheet service\"><literal>SFDatabases</literal>.<literal>Datasheet</literal> service</link></variable>"
+msgstr ""
+
+#. CCxPd
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id901619031958273\n"
+"help.text"
+msgid "The <literal>Datasheet</literal> service allows to visualize the contents of database tables as well as the results of queries and SQL statements using Base's Data View. Additionally, this service allows to:"
+msgstr ""
+
+#. MDMA7
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id241619032289964\n"
+"help.text"
+msgid "Add custom menus to the data view."
+msgstr ""
+
+#. DucpD
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id291619032292829\n"
+"help.text"
+msgid "Access values in specific positions of the data view."
+msgstr ""
+
+#. MrxfF
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id421619032296454\n"
+"help.text"
+msgid "Position the cursor in a specific cell of the data view."
+msgstr ""
+
+#. xZtEL
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. GEQkg
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id141609955500101\n"
+"help.text"
+msgid "Before using the <literal>Datasheet</literal> service the <literal>ScriptForge</literal> library needs to be loaded or imported:"
+msgstr ""
+
+#. UDCjV
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id311619033224680\n"
+"help.text"
+msgid "The <literal>Datasheet</literal> service can be invoked in two different ways depending on whether the database file is open."
+msgstr ""
+
+#. LXxpq
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id781671108693239\n"
+"help.text"
+msgid "The example below considers that the database file is open, hence the <literal>UI</literal> service can be used to retrieve the document and the <literal>OpenTable</literal> method from the <literal>Database</literal> service is used to get a <literal>Datasheet</literal> service instance."
+msgstr ""
+
+#. nmHPC
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id561671040218003\n"
+"help.text"
+msgid "Dim ui As Object, oBase As Object, oSheet As Object"
+msgstr ""
+
+#. uCvbC
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id981671039972329\n"
+"help.text"
+msgid "' Object oBase is an instance of the Base service"
+msgstr ""
+
+#. y8TZZ
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id451671040032633\n"
+"help.text"
+msgid "' Object oSheet is an instance of the Datasheet service"
+msgstr ""
+
+#. cnJfg
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id721671040093835\n"
+"help.text"
+msgid "In the example above it is also possible to use the method <literal>OpenQuery</literal> from the <literal>Base</literal> service to get a <literal>Datasheet</literal> instance."
+msgstr ""
+
+#. 5usm9
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id281619033570656\n"
+"help.text"
+msgid "To invoke the <literal>Datasheet</literal> service when the database file is not open, use the <literal>OpenTable</literal>, <literal>OpenQuery</literal> or <literal>OpenSql</literal> methods from the <literal>Database</literal> service. The example below uses the <literal>OpenTable</literal> method to open an existing table in the database file:"
+msgstr ""
+
+#. 6dFFb
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id451671040032621\n"
+"help.text"
+msgid "' Object oDatabase is an instance of the Database service"
+msgstr ""
+
+#. vFEti
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id451671040032011\n"
+"help.text"
+msgid "' Object oSheet is an instance of the Datasheet service"
+msgstr ""
+
+#. TGuKf
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id871623102536956\n"
+"help.text"
+msgid "The examples above can be translated to Python as follows:"
+msgstr ""
+
+#. xFcX4
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"hd_id711600788076834\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. yaMir
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id31671041470077\n"
+"help.text"
+msgid "The following properties are available in the <literal>Datasheet</literal> service:"
+msgstr ""
+
+#. uVScA
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id461600788076917\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. o9D7n
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id221600788076591\n"
+"help.text"
+msgid "Read-only"
+msgstr ""
+
+#. ykDW3
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id761600788076328\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. BJ9DV
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id67160078807636\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. ETvvH
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id311600788076756\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 7Xcpx
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id831600788076785\n"
+"help.text"
+msgid "Array of Strings"
+msgstr ""
+
+#. DSDCy
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id441600788076826\n"
+"help.text"
+msgid "Returns an <literal>Array</literal> with the names of column headers in the datasheet."
+msgstr ""
+
+#. AawGx
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id49160078807654\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. XVhow
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id81600788076419\n"
+"help.text"
+msgid "Returns the currently selected column name."
+msgstr ""
+
+#. 8ph7x
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id711600788076534\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. cLaaP
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id541600788076645\n"
+"help.text"
+msgid "Returns the number of the currently selected row, starting at 1."
+msgstr ""
+
+#. h3vRR
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id891600788076190\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 5FdAQ
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id91600788076674\n"
+"help.text"
+msgid "Returns the file name of the Base file in <literal>FSO.FileNaming</literal> format."
+msgstr ""
+
+#. 3TyFG
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id561633021747903\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. Pv5DC
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id831633021749007\n"
+"help.text"
+msgid "Specifies a filter to be applied to the datasheet expressed as the <literal>WHERE</literal> clause of a SQL query without the <literal>WHERE</literal> keyword. If an empty string is specified then the active <literal>Filter</literal> is removed."
+msgstr ""
+
+#. uiSkN
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id391600788076253\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. p4e8b
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id21600788076541\n"
+"help.text"
+msgid "Returns the number of rows in the datasheet."
+msgstr ""
+
+#. ZERuR
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id211600788076138\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. y8qWp
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id521600788076371\n"
+"help.text"
+msgid "Specifies the order in which records are shown expressed as the <literal>ORDER BY</literal> clause of a SQL query without the <literal>ORDER BY</literal> keyword. If an empty string is specified then the active <literal>OrderBy</literal> is removed."
+msgstr ""
+
+#. BJAwG
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id21600788076758\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. faBy9
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id871600788076196\n"
+"help.text"
+msgid "Object"
+msgstr ""
+
+#. iCABS
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id781600788076694\n"
+"help.text"
+msgid "Returns the <literal>Database</literal> service instance to which the datasheet belongs."
+msgstr ""
+
+#. 3AG3X
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id261600788076841\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. zE8Xg
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id11600788076757\n"
+"help.text"
+msgid "Returns a String that represents the data source, which can be a SQL statement, a table name or a query name."
+msgstr ""
+
+#. 8VKAq
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id531600789141795\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. TSNA5
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id301600789141619\n"
+"help.text"
+msgid "Returns the type of the data source, which can be one of the following values: \"SQL\", \"TABLE\" or \"QUERY\"."
+msgstr ""
+
+#. bZqAE
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id541600789286532\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. wxLJ4
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id181600789286889\n"
+"help.text"
+msgid "UNO Object"
+msgstr ""
+
+#. NDjRM
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id701600789286280\n"
+"help.text"
+msgid "Returns the <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1lang_1_1XComponent.html\" name=\"XComponent\">com.sun.star.lang.XComponent</link> UNO object  that represents the datasheet."
+msgstr ""
+
+#. vEoc2
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941608709527698\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. tCgaA
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id100100678952791\n"
+"help.text"
+msgid "UNO Object"
+msgstr ""
+
+#. 8jt7B
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id661300789527859\n"
+"help.text"
+msgid "Returns the <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XControl.html\" name=\"XControl\">com.sun.star.awt.XControl</link> UNO object that represents the datasheet."
+msgstr ""
+
+#. 62EDa
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941600789527698\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 7AReG
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id100160078952791\n"
+"help.text"
+msgid "UNO Object"
+msgstr ""
+
+#. nTQHe
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id631600789527859\n"
+"help.text"
+msgid "Returns the <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XTabControllerModel.html\" name=\"XTabControllerModel\">com.sun.star.awt.XTabControllerModel</link> UNO object  that represents the datasheet."
+msgstr ""
+
+#. wfJfa
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"hd_id501582887473754\n"
+"help.text"
+msgid "Methods"
+msgstr ""
+
+#. wgVfx
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id451619034669263\n"
+"help.text"
+msgid "List of Methods in the Datasheet Service"
+msgstr ""
+
+#. euurc
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099743199\n"
+"help.text"
+msgid "Brings to front the data view window referred to by the <literal>Datasheet</literal> instance."
+msgstr ""
+
+#. ZQdnE
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099748128\n"
+"help.text"
+msgid "Closes the data view window referred to by the <literal>Datasheet</literal> instance."
+msgstr ""
+
+#. fStHW
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099748639\n"
+"help.text"
+msgid "Creates a new menu entry in the data view window and returns a <literal>SFWidgets.Menu</literal> service instance, with which menu items can be programmatically added."
+msgstr ""
+
+#. H4ghA
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id71671047526843\n"
+"help.text"
+msgid "Menus added using the <literal>CreateMenu</literal> method are lost as soon as the data view window is closed."
+msgstr ""
+
+#. QC9Uh
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997155\n"
+"help.text"
+msgid "<emph>menuheader:</emph> The name of the new menu."
+msgstr ""
+
+#. yVxAC
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997180\n"
+"help.text"
+msgid "<emph>before:</emph> This argument can be either the name of an existing menu entry before which the new menu will be placed or a number expressing the position of the new menu. If this argument is left blank the new menu is placed as the last entry."
+msgstr ""
+
+#. MXC5w
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997090\n"
+"help.text"
+msgid "<emph>submenuchar:</emph> The delimiter used in menu trees (Default = \">\")"
+msgstr ""
+
+#. EMDiB
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id461619100382442\n"
+"help.text"
+msgid "Set oMenu = oSheet.CreateMenu(\"My Menu\", Before := \"Data\")"
+msgstr ""
+
+#. zLvjn
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id591671048413063\n"
+"help.text"
+msgid ".AddItem(\"Item 1\", Command := \".uno:About\")"
+msgstr ""
+
+#. DKtUn
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"pyc_id361623165059667\n"
+"help.text"
+msgid "menu = sheet.CreateMenu(\"My Menu\", before=\"Data\")"
+msgstr ""
+
+#. WAFYz
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"pyc_id571671048780765\n"
+"help.text"
+msgid "menu.AddItem(\"Item 1\", command=\".uno:About\")"
+msgstr ""
+
+#. K62eP
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id521671048538692\n"
+"help.text"
+msgid "Read the <link href=\"text/sbasic/shared/03/sf_menu.xhp\" name=\"SF_Menu\">Menu service</link> help page to learn more about how to create menu and submenu entries and associate commands."
+msgstr ""
+
+#. nXH8z
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099748009\n"
+"help.text"
+msgid "Returns the text in a given column of the current row."
+msgstr ""
+
+#. DJ8Ft
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id161671050245887\n"
+"help.text"
+msgid "This method does not change the position of the cursor in the data view window."
+msgstr ""
+
+#. 3qnwN
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997693\n"
+"help.text"
+msgid "<emph>column:</emph> The name of the column as a String or the column position (starting at 1). If a position greater than the number of columns is given, the last column is returned."
+msgstr ""
+
+#. ED6ma
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099747177\n"
+"help.text"
+msgid "Returns the value in a given column of the current row as a valid Basic type."
+msgstr ""
+
+#. fXDwA
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id91671050315349\n"
+"help.text"
+msgid "The types that can be returned are: <literal>String</literal>, <literal>Integer</literal>, <literal>Long</literal>, <literal>Single</literal>, <literal>Double</literal>, <literal>Date</literal> and <literal>Null</literal>."
+msgstr ""
+
+#. HADUe
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id411671050476363\n"
+"help.text"
+msgid "Binary types are returned as a <literal>Long</literal> value indicating the length of the binary field."
+msgstr ""
+
+#. nTQDh
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id141671050559691\n"
+"help.text"
+msgid "An <literal>Empty</literal> value is returned if the required value could not be retrieved."
+msgstr ""
+
+#. BtN8B
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id161671050245365\n"
+"help.text"
+msgid "This method does not change the position of the cursor in the data view window."
+msgstr ""
+
+#. DwSZS
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997253\n"
+"help.text"
+msgid "<emph>column:</emph> The name of the column as a String or the column position (starting at 1). If a position greater than the number of columns is given, the last column is returned."
+msgstr ""
+
+#. ij88V
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099747188\n"
+"help.text"
+msgid "Moves the cursor to the specified row and column."
+msgstr ""
+
+#. 4CXzN
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id161671050245147\n"
+"help.text"
+msgid "This method does not change the position of the cursor in the data view window."
+msgstr ""
+
+#. CECkE
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id231671105664098\n"
+"help.text"
+msgid "<emph>row:</emph> The row number as a numeric value starting at 1. If the requested row exceeds the number of existing rows, the cursor is moved to the last row. If this argument is not specified, then the row is not changed."
+msgstr ""
+
+#. 4AYCp
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997124\n"
+"help.text"
+msgid "<emph>column:</emph> The name of the column as a <literal>String</literal> or the column position (starting at 1). If the requested column exceeds the number of existing columns, the cursor is moved to the last column. If this argument is not specified, then the column is not changed."
+msgstr ""
+
+#. t7xYa
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id741671106250967\n"
+"help.text"
+msgid "' Moves the cursor to the column \"LastName\" in row 4"
+msgstr ""
+
+#. BRB4u
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id51671106293155\n"
+"help.text"
+msgid "oSheet.GoToCell(4, \"LastName\")"
+msgstr ""
+
+#. xvnqb
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id616711059619900\n"
+"help.text"
+msgid "' Moves the cursor to the third column of the current row"
+msgstr ""
+
+#. sSJ4S
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id611671106014685\n"
+"help.text"
+msgid "' Moves cursor one row down leaving it in the same column"
+msgstr ""
+
+#. hLAZS
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"bas_id711671107842042\n"
+"help.text"
+msgid "' Moves to the last column of the last row"
+msgstr ""
+
+#. 4mHFQ
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"pyc_id361623165059099\n"
+"help.text"
+msgid "sheet.GoToCell(4, \"LastName\")"
+msgstr ""
+
+#. zU2uu
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id801916099747090\n"
+"help.text"
+msgid "Removes a menu entry from the data view by its name."
+msgstr ""
+
+#. FhSiD
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id511671106735805\n"
+"help.text"
+msgid "This method can remove menus that belong to the standard user interface as well as menus that were programmatically added with the <literal>CreateMenu</literal> method. The removal of standard menus is not permanent and they will reappear after the window is closed and reopened."
+msgstr ""
+
+#. ED3Co
+#: sf_datasheet.xhp
+msgctxt ""
+"sf_datasheet.xhp\n"
+"par_id941619079997083\n"
+"help.text"
+msgid "<emph>menuheader:</emph> The case-sensitive name of the menu to be removed. The name must not include the tilde (\"~\") character."
+msgstr ""
+
 #. BC4Sc
 #: sf_dialog.xhp
 msgctxt ""
@@ -9340,13 +10564,13 @@ msgctxt ""
 msgid "<emph>DialogName</emph>: A case-sensitive string designating the dialog."
 msgstr ""
 
-#. r5vY5
+#. L5fJw
 #: sf_dialog.xhp
 msgctxt ""
 "sf_dialog.xhp\n"
 "par_id761620142701399\n"
 "help.text"
-msgid "Below %PRODUCTNAME Basic and Python examples are displaying the <literal>dlgConsole</literal> dialog that belongs to <literal>ScriptForge</literal> shared library:"
+msgid "The examples below in Basic and Python display the <literal>dlgConsole</literal> dialog that belongs to the <literal>ScriptForge</literal> shared library:"
 msgstr ""
 
 #. mqjFF
@@ -9412,31 +10636,112 @@ msgctxt ""
 msgid "# ... Process controls and do what is needed here"
 msgstr ""
 
-#. eehkB
+#. BkTv6
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id811670854106781\n"
+"help.text"
+msgid "Use the string \"GlobalScope\" as the <emph>container</emph> argument when the dialog is stored either in <menuitem>My Macros & Dialogs</menuitem> or in <menuitem>Application Macros & Dialogs</menuitem>."
+msgstr ""
+
+#. 8iyqo
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd_id141670854511382\n"
+"help.text"
+msgid "Retrieving the Dialog instance that triggered a dialog event"
+msgstr ""
+
+#. BVcDA
 #: sf_dialog.xhp
 msgctxt ""
 "sf_dialog.xhp\n"
 "par_id951598174966322\n"
 "help.text"
-msgid "Alternatively a <literal>Dialog</literal> instance can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, providing that the dialog was initiated with the <literal>Dialog</literal> service. <literal>DialogEvent</literal> returns the <literal>SFDialogs.Dialog</literal> service instance that triggered the event."
+msgid "An instance of the <literal>Dialog</literal> service can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, provided that the dialog was initiated with the <literal>Dialog</literal> service. In the example below, <literal>oDlg</literal> contains the <literal>Dialog</literal> instance that triggered the dialog event."
 msgstr ""
 
-#. QBG5g
+#. 4FBts
 #: sf_dialog.xhp
 msgctxt ""
 "sf_dialog.xhp\n"
 "par_id741619625211462\n"
 "help.text"
-msgid "with Python:"
+msgid "Or using Python:"
 msgstr ""
 
-#. n72Hv
+#. 5zauR
 #: sf_dialog.xhp
 msgctxt ""
 "sf_dialog.xhp\n"
 "par_id251598176312571\n"
 "help.text"
-msgid "Note that in previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted when deemed appropriate."
+msgid "Note that in the previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted when deemed appropriate."
+msgstr ""
+
+#. KCDyk
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd_id681670854491710\n"
+"help.text"
+msgid "Handling exceptions in event handlers"
+msgstr ""
+
+#. 9kZzz
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id971670855125683\n"
+"help.text"
+msgid "When creating an event handler for dialog events it is good practice to handle errors inside the subroutine itself. For instance, suppose the event handler below is called when the mouse button is pressed in the dialog window."
+msgstr ""
+
+#. AVgYD
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id261670857160312\n"
+"help.text"
+msgid "' Process the event"
+msgstr ""
+
+#. fLvwj
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id691670857377446\n"
+"help.text"
+msgid "Call <literal>SF_Exception.Clear</literal> if you do not want the error to propagate after the dialog execution ended."
+msgstr ""
+
+#. fJoDn
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id741619625211445\n"
+"help.text"
+msgid "In Python use native <literal>try/except</literal> blocks for exception handling as shown below:"
+msgstr ""
+
+#. vDjYf
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id491670866556493\n"
+"help.text"
+msgid "# Process the event"
+msgstr ""
+
+#. LNECW
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id416708660557072\n"
+"help.text"
+msgid "# The object \"bas\" is an instance of the Basic service"
 msgstr ""
 
 #. nXGkZ
@@ -10321,6 +11626,150 @@ msgctxt ""
 msgid "oDialog.Resize(1000, 2000, Height = 6000)  # Width is not changed"
 msgstr ""
 
+#. 6DRxV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id21598187950047\n"
+"help.text"
+msgid "Defines which controls in a dialog are responsible for switching pages, making it easier to manage the <literal>Page</literal> property of a dialog and its controls."
+msgstr ""
+
+#. DDxnE
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id291670871829824\n"
+"help.text"
+msgid "Dialogs may have multiple pages and the currently visible page is defined by the <literal>Page</literal> dialog property. If the <literal>Page</literal> property is left unchanged, the default visible page is equal to 0 (zero), meaning that no particular page is defined and all visible controls are displayed regardless of the value set in their own <literal>Page</literal> property."
+msgstr ""
+
+#. YB97d
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id431670872095503\n"
+"help.text"
+msgid "When the <literal>Page</literal> property of a dialog is changed to some other value such as 1, 2, 3 and so forth, then only the controls whose <literal>Page</literal> property match the current dialog page will be displayed."
+msgstr ""
+
+#. 4oNFA
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id161670872517032\n"
+"help.text"
+msgid "By using the <literal>SetPageManager</literal> method it is possible to define four types of page managers:"
+msgstr ""
+
+#. Bdjcu
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id161670872665432\n"
+"help.text"
+msgid "<emph>List box or combo box:</emph> in this case, each entry in the list box or combo box corresponds to a page. The first item refers to Page 1, the second items refers to Page 2 and so on."
+msgstr ""
+
+#. 2cbkh
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id141670872835955\n"
+"help.text"
+msgid "<emph>Group of radio buttons:</emph> defines a group of radio buttons that will control which page is visible."
+msgstr ""
+
+#. BszmV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id11670872840588\n"
+"help.text"
+msgid "<emph/><emph>Sequence of buttons:</emph> defines a set of buttons, each of which corresponding to a dialog page. This can be used to emulate a tabbed interface by placing buttons side by side in the dialog."
+msgstr ""
+
+#. qFQHA
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id461670873122132\n"
+"help.text"
+msgid "<emph>Previous/Next buttons:</emph> defines which buttons in the dialog that will be used to navigate to the Previous/Next page in the dialog."
+msgstr ""
+
+#. dANup
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id871670874232499\n"
+"help.text"
+msgid "It is possible to use more than one page management mechanism at the same time."
+msgstr ""
+
+#. JLw7E
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id831670873941232\n"
+"help.text"
+msgid "This method is supposed to be called just once before calling the <literal>Execute</literal> method. Subsequent calls are ignored."
+msgstr ""
+
+#. NAsqC
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id371670874142972\n"
+"help.text"
+msgid "If successful this method returns <literal>True</literal>."
+msgstr ""
+
+#. iyTJv
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id481651236673466\n"
+"help.text"
+msgid "<emph>pilotcontrols:</emph> a comma-separated list of <literal>ListBox</literal>, <literal>ComboBox</literal> or <literal>RadioButton</literal> control names used as page managers. For RadioButton controls, specify the name of the first control in the group to be used."
+msgstr ""
+
+#. vNxtV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id721651236670589\n"
+"help.text"
+msgid "<emph>tabcontrols:</emph> a comma-separated list of button names that will be used as page managers. The order in which they are specified in this argument corresponds to the page number they are associated with."
+msgstr ""
+
+#. VXVDL
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id991651236674963\n"
+"help.text"
+msgid "<emph>wizardcontrols:</emph> a comma-separated list with the names of two buttons that will be used as the Previous/Next buttons."
+msgstr ""
+
+#. AEFZz
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id771651236671764\n"
+"help.text"
+msgid "<emph>lastpage:</emph> the number of the last available page. It is recommended to specify this value when using the Previous/Next page manager."
+msgstr ""
+
+#. sWmg6
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id861670874176863\n"
+"help.text"
+msgid "Consider a dialog with three pages. The dialog has a <literal>ListBox</literal> control named \"aPageList\" that will be used to control the visible page. Additionally, there are two buttons named \"btnPrevious\" and \"btnNext\" that will be used as the Previous/Next buttons in the dialog."
+msgstr ""
+
 #. ARCGg
 #: sf_dialog.xhp
 msgctxt ""
@@ -10483,22 +11932,148 @@ msgctxt ""
 msgid "# ... process the controls actual values"
 msgstr ""
 
-#. 2PPv4
+#. GZ3ia
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id141670854511382\n"
+"help.text"
+msgid "Retrieving the DialogControl instance that triggered a control event"
+msgstr ""
+
+#. CcXYE
 #: sf_dialogcontrol.xhp
 msgctxt ""
 "sf_dialogcontrol.xhp\n"
 "par_id951598174966322\n"
 "help.text"
-msgid "Alternatively a control instance can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, providing the dialog was initiated with the <literal>Dialog</literal> service. <literal>DialogEvent</literal> returns the <literal>SFDialogs.DialogControl</literal> class instance that triggered the event."
+msgid "An instance of the <literal>DialogControl</literal> service can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, provided that the dialog was initiated with the <literal>Dialog</literal> service. In the example below, <literal>oControl</literal> contains the <literal>DialogControl</literal> instance that triggered the control event."
 msgstr ""
 
-#. 75WJy
+#. jeLRp
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id741619625211462\n"
+"help.text"
+msgid "Or using Python:"
+msgstr ""
+
+#. EroTy
 #: sf_dialogcontrol.xhp
 msgctxt ""
 "sf_dialogcontrol.xhp\n"
 "par_id251598176312571\n"
 "help.text"
-msgid "Note that in previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted."
+msgid "Note that in the previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted when deemed appropriate."
+msgstr ""
+
+#. KazD8
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id681670854491710\n"
+"help.text"
+msgid "Handling exceptions in event handlers"
+msgstr ""
+
+#. isdwE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id971670855125683\n"
+"help.text"
+msgid "When creating an event handler for control events it is good practice to handle errors inside the subroutine itself. For instance, suppose the event handler below is called when button is clicked."
+msgstr ""
+
+#. HSAhd
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id261670857160312\n"
+"help.text"
+msgid "' Process the event"
+msgstr ""
+
+#. wUTZB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id691670857377446\n"
+"help.text"
+msgid "Call <literal>SF_Exception.Clear</literal> if you do not want the error to propagate after the dialog execution ended."
+msgstr ""
+
+#. GVfqQ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id741619625211445\n"
+"help.text"
+msgid "In Python use native <literal>try/except</literal> blocks for exception handling as shown below:"
+msgstr ""
+
+#. FBViG
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id111670866555779\n"
+"help.text"
+msgid "def on_button_clicked(event=None):"
+msgstr ""
+
+#. CMzBk
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id871670866556117\n"
+"help.text"
+msgid "try:"
+msgstr ""
+
+#. 64DRA
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id721670866556311\n"
+"help.text"
+msgid "oControl = CreateScriptService(\"DialogEvent\", event)"
+msgstr ""
+
+#. UAGhF
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id491670866556493\n"
+"help.text"
+msgid "# Process the event"
+msgstr ""
+
+#. i77WY
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id521670866556680\n"
+"help.text"
+msgid "except Exception as e:"
+msgstr ""
+
+#. KY75S
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id416708660557072\n"
+"help.text"
+msgid "# The object \"bas\" below is an instance of the Basic service"
+msgstr ""
+
+#. jAhhf
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id491670866556877\n"
+"help.text"
+msgid "bas.MsgBox(str(e))"
 msgstr ""
 
 #. F9uKj
diff --git a/source/ja/helpcontent2/source/text/shared/02.po b/source/ja/helpcontent2/source/text/shared/02.po
index 99333711069..8be2c958e08 100644
--- a/source/ja/helpcontent2/source/text/shared/02.po
+++ b/source/ja/helpcontent2/source/text/shared/02.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-12-07 19:22+0100\n"
+"POT-Creation-Date: 2022-12-19 15:00+0100\n"
 "PO-Revision-Date: 2022-05-10 09:33+0000\n"
 "Last-Translator: JO3EMC <jo3emc@jarl.com>\n"
 "Language-Team: Japanese <https://translations.documentfoundation.org/projects/libo_help-master/textshared02/ja/>\n"
@@ -12625,13 +12625,13 @@ msgctxt ""
 msgid "<link href=\"text/shared/02/07070000.xhp\">Edit Mode</link>"
 msgstr ""
 
-#. B9CS6
+#. 5DwSX
 #: 07070000.xhp
 msgctxt ""
 "07070000.xhp\n"
 "par_id3153089\n"
 "help.text"
-msgid "<ahelp hid=\".uno:EditDoc\" visibility=\"hidden\">Enables you to edit a read-only document or database table.</ahelp> Use the<emph> Edit Mode</emph> icon to activate or deactivate the edit mode."
+msgid "<ahelp hid=\".uno:EditDoc\" visibility=\"hidden\">Enables you to edit a read-only document or database table.</ahelp> Use the<emph> Edit Mode</emph> option to activate the edit mode."
 msgstr ""
 
 #. HpbAm
diff --git a/source/ja/helpcontent2/source/text/swriter.po b/source/ja/helpcontent2/source/text/swriter.po
index a1f6297b946..be0741e3188 100644
--- a/source/ja/helpcontent2/source/text/swriter.po
+++ b/source/ja/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-12-08 19:47+0100\n"
+"POT-Creation-Date: 2022-12-19 15:00+0100\n"
 "PO-Revision-Date: 2022-05-03 12:47+0000\n"
 "Last-Translator: JO3EMC <jo3emc@jarl.com>\n"
 "Language-Team: Japanese <https://translations.documentfoundation.org/projects/libo_help-master/textswriter/ja/>\n"
@@ -241,14 +241,14 @@ msgctxt ""
 msgid "<ahelp hid=\".\">This menu contains commands for editing the contents of the current document.</ahelp>"
 msgstr "<ahelp hid=\".\">このメニューには、現在のドキュメントの内容を編集するコマンドがあります。</ahelp>"
 
-#. VrMBN
+#. TV7tD
 #: main0102.xhp
 msgctxt ""
 "main0102.xhp\n"
 "hd_id3147619\n"
 "help.text"
-msgid "<link href=\"text/shared/02/07070000.xhp\">Select Text</link>"
-msgstr "<link href=\"text/shared/02/07070000.xhp\">テキストの選択</link>"
+msgid "Select Text"
+msgstr ""
 
 #. Hug2v
 #: main0102.xhp
diff --git a/source/ja/helpcontent2/source/text/swriter/guide.po b/source/ja/helpcontent2/source/text/swriter/guide.po
index 02a03445787..23d3e3f87cc 100644
--- a/source/ja/helpcontent2/source/text/swriter/guide.po
+++ b/source/ja/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-12-07 19:22+0100\n"
+"POT-Creation-Date: 2022-12-19 15:00+0100\n"
 "PO-Revision-Date: 2022-04-25 17:42+0000\n"
 "Last-Translator: JO3EMC <jo3emc@jarl.com>\n"
 "Language-Team: Japanese <https://translations.documentfoundation.org/projects/libo_help-master/textswriterguide/ja/>\n"
@@ -16990,14 +16990,14 @@ msgctxt ""
 msgid "A template is a document that contains specific formatting styles, graphics, tables, objects, and other information. A template is used as the basis for creating other documents. For example, you can define paragraph and character styles in a document, save the document as a template, and then use the template to create a new document with the same styles."
 msgstr "テンプレートとは、固有の書式スタイル、画像、表、オブジェクト、およびその他の情報が含まれているドキュメントのことです。こうして作成されたテンプレートは、新規ドキュメントを作成する際のひな形として利用できます。たとえば、必要な段落や文字のスタイルを設定したドキュメントをテンプレートとして保存しておけば、このテンプレートを用いて、同じスタイルで新規ドキュメントを何度でも作成することができます。"
 
-#. zNZ83
+#. 4X8z5
 #: templates_styles.xhp
 msgctxt ""
 "templates_styles.xhp\n"
 "par_id3149957\n"
 "help.text"
-msgid "Unless you specify otherwise, every new $[officename] text document is based on the default template."
-msgstr "別途指定しないかぎり、$[officename] の新しいテキストドキュメントはすべて標準のテンプレートを使用します。"
+msgid "You can set a default template, so every new $[officename] document would use it, unless you specified otherwise (for example, when you create a new document from a different template)."
+msgstr ""
 
 #. UXnRC
 #: templates_styles.xhp