summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po6629
1 files changed, 6208 insertions, 421 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po b/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
index c7957d27ea8..76b61518dbe 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-04-06 14:45+0200\n"
+"POT-Creation-Date: 2021-06-11 23:56+0200\n"
"PO-Revision-Date: 2018-07-12 14:38+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -61,6 +61,15 @@ msgctxt ""
msgid "This property is not available in Python."
msgstr ""
+#. 7KtXf
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id651551701041690\n"
+"help.text"
+msgid "This service is available from %PRODUCTNAME 7.2 onwards."
+msgstr ""
+
#. GXE45
#: avail_release.xhp
msgctxt ""
@@ -70,6 +79,15 @@ msgctxt ""
msgid "These methods are available from %PRODUCTNAME 7.2 onwards."
msgstr ""
+#. An73n
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id291613654389792\n"
+"help.text"
+msgid "This method is available from %PRODUCTNAME 7.2 onwards."
+msgstr ""
+
#. qjuHF
#: avail_release.xhp
msgctxt ""
@@ -106,49 +124,58 @@ msgctxt ""
msgid "ScriptForge Libraries"
msgstr ""
-#. NXPBo
+#. ADEeP
#: lib_ScriptForge.xhp
msgctxt ""
"lib_ScriptForge.xhp\n"
"hd_id31529004750471\n"
"help.text"
-msgid "<variable id=\"ScriptForge_lib\"><link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"ScriptForge library\">The <item type=\"literal\">ScriptForge</item> Library</link></variable>"
+msgid "<variable id=\"ScriptForge_lib\"><link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"ScriptForge library\">The <literal>ScriptForge</literal> Library</link></variable>"
msgstr ""
-#. nMjDG
+#. yE8bw
#: lib_ScriptForge.xhp
msgctxt ""
"lib_ScriptForge.xhp\n"
"bm_id491529070339774\n"
"help.text"
-msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value>"
+msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value> <bookmark_value>Python scriptforge module</bookmark_value>"
msgstr ""
-#. WLejn
+#. BtMUU
#: lib_ScriptForge.xhp
msgctxt ""
"lib_ScriptForge.xhp\n"
-"par_id781606153472028\n"
+"par_id681619700336879\n"
"help.text"
-msgid "The described modules and classes are invoked from user scripts as \"Services\". A generic constructor of those services has been designed for that purpose:"
+msgid "ScriptForge libraries build up an extensible collection of macro scripting resources for %PRODUCTNAME to be invoked from Basic macros or Python scripts."
msgstr ""
-#. dUu2P
+#. YwSXj
#: lib_ScriptForge.xhp
msgctxt ""
"lib_ScriptForge.xhp\n"
-"par_id891606153700196\n"
+"par_id1001623412767893\n"
"help.text"
-msgid "Services from external libraries can be registered with the <literal>RegisterScriptServices(...)</literal> method in order to extend the set of available services."
+msgid "To learn more about how to create and execute Python scripts using the <literal>ScriptForge</literal> library, read the <embedvar href=\"text/sbasic/shared/03/sf_intro.xhp#title\"/> help page."
msgstr ""
-#. ErFP9
+#. wKZM6
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id781606153472028\n"
+"help.text"
+msgid "The described modules and classes are invoked from user scripts as \"Services\". A generic constructor of those services has been designed for that purpose for each language:"
+msgstr ""
+
+#. B3Xve
#: lib_ScriptForge.xhp
msgctxt ""
"lib_ScriptForge.xhp\n"
"par_id851605659675843\n"
"help.text"
-msgid "The <literal>ScriptForge</literal> Basic library is available from %PRODUCTNAME 7.1 onwards."
+msgid "The <literal>ScriptForge</literal> Basic library is available from %PRODUCTNAME 7.1 onwards.<br/>Python <literal>scriptforge</literal> module is available from %PRODUCTNAME 7.2 onwards."
msgstr ""
#. Depaw
@@ -2194,6 +2221,1446 @@ msgctxt ""
msgid "<emph>CaseSensitive</emph> : Only if the array is populated with texts, default = <literal>False</literal>."
msgstr ""
+#. GAXAU
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDocuments.Base service"
+msgstr ""
+
+#. TiAmG
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"ctrls_h1\"><link href=\"text/sbasic/shared/03/sf_base.xhp\" name=\"SFDocuments.Base service\"><literal>SFDocuments</literal>.<literal>Base</literal> service</link></variable>"
+msgstr ""
+
+#. 4KK8s
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id901619031958273\n"
+"help.text"
+msgid "The <literal>Base</literal> service provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME Base documents."
+msgstr ""
+
+#. ZxoY9
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id961619032060880\n"
+"help.text"
+msgid "This service is closely related to the <literal>Document</literal> service, which provides generic methods for handling %PRODUCTNAME documents, including Base documents. Hence, the <literal>Base</literal> service extends the <literal>Document</literal> service and provides additional methods that are specific for Base documents, enabling users to:"
+msgstr ""
+
+#. EK3gt
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id241619032289964\n"
+"help.text"
+msgid "Get access to the database contained in a Base document."
+msgstr ""
+
+#. y2wmE
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id291619032292829\n"
+"help.text"
+msgid "Open form documents stored in a Base document."
+msgstr ""
+
+#. cpnJ7
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id421619032296454\n"
+"help.text"
+msgid "Check if a form document from a Base document is currently loaded."
+msgstr ""
+
+#. myHaG
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id241619032941497\n"
+"help.text"
+msgid "Refer to the <link href=\"text/sbasic/shared/03/sf_document.xhp\" name=\"Document Service\"><literal>Document</literal> service</link> to learn more about methods and properties that can be used to manage %PRODUCTNAME documents."
+msgstr ""
+
+#. bGpRM
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. vi6hS
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id311619033224680\n"
+"help.text"
+msgid "The Base service can be invoked in a variety of ways. The code snippet below uses the method <literal>CreateBaseDocument</literal> from the <literal>UI</literal> service to create a new Base file."
+msgstr ""
+
+#. t4HPk
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id101619033666470\n"
+"help.text"
+msgid "Note that in all examples the object <literal>oDoc</literal> is an instance of the <literal>Base</literal> service."
+msgstr ""
+
+#. hKce4
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619033570656\n"
+"help.text"
+msgid "The <literal>Base</literal> service can also be instantiated while opening an existing Base file, as shown below:"
+msgstr ""
+
+#. noxU9
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id331619033713781\n"
+"help.text"
+msgid "If a Base document is already open, it is possible to instantiate the <literal>Base</literal> service directly:"
+msgstr ""
+
+#. DrqrF
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id871623102536956\n"
+"help.text"
+msgid "The examples above can be translated to Python as follows:"
+msgstr ""
+
+#. f8Esv
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619619980185\n"
+"help.text"
+msgid "The use of the <emph>\"SFDocuments.\"</emph> substring in the previous example is optional."
+msgstr ""
+
+#. oMw4m
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id451619034669263\n"
+"help.text"
+msgid "List of Methods in the Base Service"
+msgstr ""
+
+#. ZQnqj
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id481619036833610\n"
+"help.text"
+msgid "Returns an array with the full names (path/name) of all form documents in the Base document as an zero-based Array of strings."
+msgstr ""
+
+#. sECnJ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id431619037334440\n"
+"help.text"
+msgid "The code snippet below prints the names of all form documents in the current Base document."
+msgstr ""
+
+#. jsh8d
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id691623103639534\n"
+"help.text"
+msgid "bas = CreateScriptService(\"Basic\")"
+msgstr ""
+
+#. Cw4jD
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id101623103639206\n"
+"help.text"
+msgid "doc = CreateScriptService(\"Document\", bas.ThisDataBaseDocument)"
+msgstr ""
+
+#. D446T
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id901623103639390\n"
+"help.text"
+msgid "myForms = oDoc.FormDocuments()"
+msgstr ""
+
+#. BCyAZ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id791623103639701\n"
+"help.text"
+msgid "for formName in myForms:"
+msgstr ""
+
+#. pJKNZ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id741623103639861\n"
+"help.text"
+msgid "bas.MsgBox(formName)"
+msgstr ""
+
+#. DQb6z
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id921619036922844\n"
+"help.text"
+msgid "To learn more about form documents, refer to the <link href=\"text/sbasic/shared/03/sf_form.xhp\" name=\"Form service\"><literal>Form</literal> service help page</link>."
+msgstr ""
+
+#. gCGqW
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id191619037523467\n"
+"help.text"
+msgid "Depending on the parameters provided this method will return:"
+msgstr ""
+
+#. HqFmT
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id781619037575043\n"
+"help.text"
+msgid "A zero-based Array with the names of all the forms contained in a form document (if the <literal>Form</literal> argument is absent)"
+msgstr ""
+
+#. Q4Had
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id111619037577804\n"
+"help.text"
+msgid "A <literal>SFDocuments.Form</literal> object representing the form specified in the <literal>Form</literal> argument."
+msgstr ""
+
+#. pEtwt
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id861619037838260\n"
+"help.text"
+msgid "<emph>formdocument:</emph> The name of a valid form document as a case-sensitive string."
+msgstr ""
+
+#. L3csm
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619037857187\n"
+"help.text"
+msgid "<emph>form:</emph> The name or index number of the form stored in the form document. If this argument is absent, the method will return a list with the names of all forms available in the form document."
+msgstr ""
+
+#. K4nQh
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id921619437863617\n"
+"help.text"
+msgid "Although it is possible to use index numbers to refer to forms, this is only recommended when there is just one form in the form document. If there are two or more forms, it is preferable to use the form name instead."
+msgstr ""
+
+#. DoxrV
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id21623104676805\n"
+"help.text"
+msgid "The first line of the example below returns a list of all forms in the form document \"myFormDocument\". The second line returns an instance of the Form service representing the form \"myForm\"."
+msgstr ""
+
+#. 9jA9n
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id371619098340303\n"
+"help.text"
+msgid "Returns an instance of the <link href=\"text/sbasic/shared/03/sf_database.xhp\" name=\"Database service\"><literal>Database</literal> service</link> that allows the execution of SQL commands on the database defined and/or stored in the current Base document"
+msgstr ""
+
+#. 9Bncy
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id731619098073221\n"
+"help.text"
+msgid "<emph>user, password:</emph> Optional login parameters as strings. The default value for both parameters is an empty string \"\"."
+msgstr ""
+
+#. UbzRD
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id631615147843278\n"
+"help.text"
+msgid "' User and password are supplied below, if needed"
+msgstr ""
+
+#. XBJVn
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id921599408791887\n"
+"help.text"
+msgid "' ... Run queries, SQL statements, ..."
+msgstr ""
+
+#. DA8ob
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"pyc_id351623104861223\n"
+"help.text"
+msgid "' ... Run queries, SQL statements, ..."
+msgstr ""
+
+#. mBphD
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id871619098478513\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the specified <literal>FormDocument</literal> is currently open."
+msgstr ""
+
+#. njjFg
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id981619098545701\n"
+"help.text"
+msgid "<emph>formdocument:</emph> The name of a <literal>FormDocument</literal> to be checked, as a case-sensitive string."
+msgstr ""
+
+#. RS3kj
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id801619099743199\n"
+"help.text"
+msgid "Opens the specified <literal>FormDocument</literal> either in normal or in design mode."
+msgstr ""
+
+#. 38vtF
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id451619100075330\n"
+"help.text"
+msgid "If the form document is already open, it is activated without changing its mode. The method returns <literal>True</literal> if the form document could be opened."
+msgstr ""
+
+#. dUE6w
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id941619099797810\n"
+"help.text"
+msgid "<emph>formDocument:</emph> The name of the <literal>FormDocument</literal> to be opened, as a case-sensitive string."
+msgstr ""
+
+#. Coxpu
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id981619099816849\n"
+"help.text"
+msgid "<emph>designmode:</emph> If this argument is <literal>True</literal> the <literal>FormDocument</literal> will be opened in design mode."
+msgstr ""
+
+#. B29ng
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id251619100191992\n"
+"help.text"
+msgid "Most form documents are stored in the root of the Base document and they can be opened simply using their names, as in the example below:"
+msgstr ""
+
+#. pv3RA
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id461619100283210\n"
+"help.text"
+msgid "oDoc.OpenFormDocument(\"myFormDocument\")"
+msgstr ""
+
+#. ACLqQ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id351619100327505\n"
+"help.text"
+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 ""
+
+#. mLgzR
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id461619100283712\n"
+"help.text"
+msgid "oDoc.OpenFormDocument(\"myFolder/myFormDocument\")"
+msgstr ""
+
+#. 3RzkD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"tit\n"
+"help.text"
+msgid "ScriptForge.Basic service"
+msgstr ""
+
+#. GxEht
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id731582733781114\n"
+"help.text"
+msgid "<variable id=\"BasicService\"><link href=\"text/sbasic/shared/03/sf_basic.xhp\" name=\"Basic service\"><literal>ScriptForge</literal>.<literal>Basic</literal> service</link></variable>"
+msgstr ""
+
+#. G5jAV
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381589189355849\n"
+"help.text"
+msgid "The <literal>ScriptForge.Basic</literal> service proposes a collection of %PRODUCTNAME Basic methods to be executed in a Python context. <literal>Basic</literal> service methods reproduce the exact syntax and behaviour of Basic builtin functions."
+msgstr ""
+
+#. Bb7Br
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id591589189364267\n"
+"help.text"
+msgid "Typical example:"
+msgstr ""
+
+#. yrYgm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id971618493778666\n"
+"help.text"
+msgid "svc.MsgBox('This has to be displayed in a message box')"
+msgstr ""
+
+#. kGyCd
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id151618849022977\n"
+"help.text"
+msgid "<literal>ScriptForge</literal>.<literal>Basic</literal> service is limited to Python scripts."
+msgstr ""
+
+#. biAQa
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. pNUsj
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id141610734722352\n"
+"help.text"
+msgid "Before using the <literal>Basic</literal> service, import the <literal>CreateScriptService()</literal> method from the <literal>scriptforge</literal> module:"
+msgstr ""
+
+#. E6SaA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id201618922972557\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. bLzCe
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id401618922991909\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. 5FcQt
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id591618922991909\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. N5DD5
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id211618922991909\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. qXwST
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id971618923022846\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. W8eh6
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id541619003984227\n"
+"help.text"
+msgid "MB_OK, MB_OKCANCEL, MB_RETRYCANCEL, MB_YESNO, MB_YESNOCANCEL"
+msgstr ""
+
+#. KuiAD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619004009875\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. TkYXL
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id111619004011627\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. 7DG4F
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id791619004012484\n"
+"help.text"
+msgid "Values: 0, 1, 5, 4, 3"
+msgstr ""
+
+#. oASRR
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id161619003998035\n"
+"help.text"
+msgid "MB_ICONEXCLAMATION, MB_ICONINFORMATION, MB_ICONQUESTION, MB_ICONSTOP"
+msgstr ""
+
+#. 8ie8B
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id201619004097755\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. GNqXc
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id981619004098700\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. DQkGQ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id311619004099683\n"
+"help.text"
+msgid "Values: 48, 64, 32, 16<br/>"
+msgstr ""
+
+#. RBdBG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id831618922991909\n"
+"help.text"
+msgid "MB_ABORTRETRYIGNORE, MB_DEFBUTTON1, MB_DEFBUTTON2, MB_DEFBUTTON3"
+msgstr ""
+
+#. mCpye
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id581618922991909\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. CrG3W
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id161618922991910\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. h3hZE
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id211618923312141\n"
+"help.text"
+msgid "Values: 2, 128, 256, 512"
+msgstr ""
+
+#. F3DMG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id471618924470655\n"
+"help.text"
+msgid "IDABORT, IDCANCEL, IDIGNORE, IDNO, IDOK, IDRETRY, IDYES"
+msgstr ""
+
+#. kLst4
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id961618924503848\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. XKzky
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id571618924505303\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. Tmtc2
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id871618924506654\n"
+"help.text"
+msgid "Values: 3, 2, 5, 7, 1, 4, 6<br/>Constants indicating <literal>MsgBox</literal> selected button."
+msgstr ""
+
+#. fHLnu
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id421619006246768\n"
+"help.text"
+msgid "StarDesktop"
+msgstr ""
+
+#. BDtqm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id731619006254384\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. SKW53
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id711619006255184\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. AA95E
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id541619006255653\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/stardesktop.xhp\" name=\"StarDesktop\"><literal>StarDesktop</literal></link> object represents %PRODUCTNAME Start Center."
+msgstr ""
+
+#. vXq8C
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651606319520519\n"
+"help.text"
+msgid "List of Methods in the Basic Service"
+msgstr ""
+
+#. GvjSD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id71621894830071\n"
+"help.text"
+msgid "Converts a numeric expression or a string to a <literal>datetime</literal>.<literal>datetime</literal> Python native object."
+msgstr ""
+
+#. SVk4F
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id431621896441258\n"
+"help.text"
+msgid "This method exposes the Basic builtin function <link href=\"text/sbasic/shared/03100300.xhp\" name=\"CDate_Basic\">CDate</link> to Python scripts."
+msgstr ""
+
+#. xvPTA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id401621896675880\n"
+"help.text"
+msgid "<emph>expression</emph>: a numeric expression or a string representing a date."
+msgstr ""
+
+#. aBGSG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id481621950748686\n"
+"help.text"
+msgid "Converts a UNO date/time representation to a <literal>datetime.datetime</literal> Python native object."
+msgstr ""
+
+#. qhCRh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id41621950816227\n"
+"help.text"
+msgid "<emph>unodate</emph>: A UNO date/time object of one of the following types: <literal>com.sun.star.util.DateTime</literal>, <literal>com.sun.star.util.Date</literal> or <literal>com.sun.star.util.Time</literal>"
+msgstr ""
+
+#. GQ2hL
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id281621952224847\n"
+"help.text"
+msgid "The following example creates a <literal>com.sun.star.util.DateTime</literal> object and converts it to a <literal>datetime.datetime</literal> Python object."
+msgstr ""
+
+#. JXsJN
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id741621952469980\n"
+"help.text"
+msgid "Converts a date representation into a <literal>com.sun.star.util.DateTime</literal> object."
+msgstr ""
+
+#. 7LW9r
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id511621952524000\n"
+"help.text"
+msgid "<emph>date</emph>: A Python date/time object of one of the following types: <literal>datetime.datetime</literal>, <literal>datetime.date</literal>, <literal>datetime.time</literal>, <literal>float (time.time)</literal> or <literal>time.struct_time</literal>."
+msgstr ""
+
+#. vaMxs
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id93158919969864\n"
+"help.text"
+msgid "Returns a system path file name for the given <literal>file:</literal> URL."
+msgstr ""
+
+#. L4crp
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id321618502481706\n"
+"help.text"
+msgid "<emph>url</emph>: An absolute <literal>file:</literal> URL."
+msgstr ""
+
+#. nmEbg
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id81618502493505\n"
+"help.text"
+msgid "A system path file name."
+msgstr ""
+
+#. 7YMKT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id658519200121138\n"
+"help.text"
+msgid "Returns a <literal>file:</literal> URL for the given system path."
+msgstr ""
+
+#. ZdzNY
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id401618521015903\n"
+"help.text"
+msgid "<emph>systempath</emph>: A system file name as a string."
+msgstr ""
+
+#. BYkqo
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id61658101307414\n"
+"help.text"
+msgid "A <literal>file:</literal> URL as a string."
+msgstr ""
+
+#. kyZyo
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651589200121138\n"
+"help.text"
+msgid "Instantiates a UNO service with the <literal>ProcessServiceManager</literal>."
+msgstr ""
+
+#. 7BvYk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id361589200121646\n"
+"help.text"
+msgid "<emph>servicename</emph> : A fully qualified service name such as \"com.sun.star.ui.dialogs.FilePicker\" or 'com.sun.star.sheet.FunctionAccess'."
+msgstr ""
+
+#. rZoCx
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901599410483300\n"
+"help.text"
+msgid "Adds a date or time interval to a given date/time a number of times and returns the resulting date."
+msgstr ""
+
+#. aRMEj
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id581618562143601\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression from the following table, specifying the date or time interval."
+msgstr ""
+
+#. Vx3AB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id281618562144897\n"
+"help.text"
+msgid "<emph>number</emph>: A numerical expression specifying how often the <literal>interval</literal> value will be added when positive or subtracted when negative."
+msgstr ""
+
+#. 4C2B6
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id811618561843272\n"
+"help.text"
+msgid "<emph>date</emph>: A given datetime.datetime value, the <literal>interval</literal> value will be added number times to this date/time value."
+msgstr ""
+
+#. ppBnh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id181618561778320\n"
+"help.text"
+msgid "A datetime.datetime value."
+msgstr ""
+
+#. HAVdW
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id991589202413257\n"
+"help.text"
+msgid "Returns the number of date or time intervals between two given date/time values."
+msgstr ""
+
+#. 2HBSe
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id481618563770490\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression specifying the date interval, as detailed in above <literal>DateAdd</literal> method."
+msgstr ""
+
+#. ZAKJ9
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121618563772932\n"
+"help.text"
+msgid "<emph>date1</emph>, <emph>date2</emph>: The two datetime.datetime values to be compared."
+msgstr ""
+
+#. ZR7AD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121618563454738\n"
+"help.text"
+msgid "A number."
+msgstr ""
+
+#. KPEWi
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id81589202925519\n"
+"help.text"
+msgid "The DatePart function returns a specified part of a date."
+msgstr ""
+
+#. ens2Q
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id761618672192231\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression specifying the date interval, as detailed in above <literal>DateAdd</literal> method."
+msgstr ""
+
+#. KuDhD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id61618672313838\n"
+"help.text"
+msgid "<emph>date</emph>: The date/time from which the result is calculated."
+msgstr ""
+
+#. P3vuB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id511619445271897\n"
+"help.text"
+msgid "<emph>firstdayofweek, firstweekofyear</emph>: optional parameters that respectively specify the starting day of a week and the starting week of a year, as detailed in above <literal>DateDiff</literal> method."
+msgstr ""
+
+#. 5Yz25
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id791618672371743\n"
+"help.text"
+msgid "The extracted part for the given date/time."
+msgstr ""
+
+#. Dc9Cs
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121589203370778\n"
+"help.text"
+msgid "Computes a date value from a date string."
+msgstr ""
+
+#. qTtuh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id441618674018955\n"
+"help.text"
+msgid "The computed date."
+msgstr ""
+
+#. GuCbF
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id458161678389887\n"
+"help.text"
+msgid "Converts a number to a string, and then formats it according to the format that you specify."
+msgstr ""
+
+#. St67G
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id751618825527776\n"
+"help.text"
+msgid "Formatting Codes"
+msgstr ""
+
+#. G2TzF
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id681618825574599\n"
+"help.text"
+msgid "Predefined Formats"
+msgstr ""
+
+#. osJdR
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618876389887\n"
+"help.text"
+msgid "Returns the default context of the process service factory, if existent, else returns a null reference."
+msgstr ""
+
+#. d4EQf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id881618848030897\n"
+"help.text"
+msgid "<literal>GetDefaultContext</literal> is an alternative to the <link href=\"text/sbasic/python/python_programming.xhp\" name=\"getComponentContext method\">getComponentContext()</link> method available from <literal>XSCRIPTCONTEXT</literal> global variable or from <link href=\"text/sbasic/python/python_programming.xhp\" name=\"uno.py module\">uno.py</link> module."
+msgstr ""
+
+#. dk35X
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381618831451271\n"
+"help.text"
+msgid "The default component context is used, when instantiating services via <literal>XMultiServiceFactory</literal>. See the <literal>Professional UNO</literal> chapter in the Developer's Guide on <link href=\"https://api.libreoffice.org/\" name=\"API Developer's Guide\">api.libreoffice.org</link> for more information."
+msgstr ""
+
+#. LACDh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id154618876389887\n"
+"help.text"
+msgid "Returns a numerical value that specifies the graphical user interface. This function is only provided for backward compatibility with previous versions."
+msgstr ""
+
+#. SmsEL
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id341618848532640\n"
+"help.text"
+msgid "Refer to <literal>system()</literal> method from <literal>platform</literal> Python module to <link href=\"text/sbasic/python/python_platform.xhp\" name=\"identify the operating system\">identify the operating system</link>."
+msgstr ""
+
+#. BJTbw
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618876389788\n"
+"help.text"
+msgid "Returns the operating system-dependent directory separator used to specify file paths."
+msgstr ""
+
+#. BWvPB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id341618848562340\n"
+"help.text"
+msgid "Use <literal>os.pathsep</literal> from <literal>os</literal> Python module to <link href=\"text/sbasic/python/python_platform.xhp\" name=\"path delimiter\">identify the path separator</link>."
+msgstr ""
+
+#. Jvd3v
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618678389887\n"
+"help.text"
+msgid "Returns the number of system ticks provided by the operating system. You can use this function to optimize certain processes. Use this method to estimate time in milliseconds:"
+msgstr ""
+
+#. CEtsQ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id251619448108905\n"
+"help.text"
+msgid "ticks_ini = svc.GetSystemTicks()"
+msgstr ""
+
+#. SG6mf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id181619448111210\n"
+"help.text"
+msgid "time.sleep(1)"
+msgstr ""
+
+#. MZXnC
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id301619448111744\n"
+"help.text"
+msgid "ticks_end = svc.GetSystemTicks()"
+msgstr ""
+
+#. dSmH3
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id651619448112320\n"
+"help.text"
+msgid "svc.MsgBox(\"{} - {} = {}\".format(ticks_end, ticks_ini,ticks_end - ticks_ini))"
+msgstr ""
+
+#. t3ADN
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id61618905161499\n"
+"help.text"
+msgid "<bookmark_value>Basic service;GlobalScope.BasicLibraries</bookmark_value>"
+msgstr ""
+
+#. KRHNc
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id741622396277528\n"
+"help.text"
+msgid "Returns the UNO object containing all shared Basic libraries and modules."
+msgstr ""
+
+#. MCrF8
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id911622396571584\n"
+"help.text"
+msgid "This method is the Python equivalent to <literal>GlobalScope</literal>.<literal>BasicLibraries</literal> in Basic scripts."
+msgstr ""
+
+#. DEARA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id281622398076950\n"
+"help.text"
+msgid "The following example loads the Gimmicks Basic library if it has not been loaded yet."
+msgstr ""
+
+#. ZaDVN
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id61618905163671\n"
+"help.text"
+msgid "<bookmark_value>Basic service;GlobalScope.DialogLibraries</bookmark_value>"
+msgstr ""
+
+#. jusQK
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381622397863419\n"
+"help.text"
+msgid "Returns the UNO object containing all shared dialog libraries."
+msgstr ""
+
+#. QEFwP
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id491622397863810\n"
+"help.text"
+msgid "This method is the Python equivalent to <literal>GlobalScope</literal>.<literal>DialogLibraries</literal> in Basic scripts."
+msgstr ""
+
+#. 8ozVo
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id811622398234384\n"
+"help.text"
+msgid "The following example shows a message box with the names of all available dialog libraries."
+msgstr ""
+
+#. Vb2CW
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id61618905164342\n"
+"help.text"
+msgid "<bookmark_value>Basic service;InputBox</bookmark_value>"
+msgstr ""
+
+#. 7GPZv
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619008398677\n"
+"help.text"
+msgid "string"
+msgstr ""
+
+#. qRtw5
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id751619081201175\n"
+"help.text"
+msgid "txt = s.InputBox('Please enter a phrase:', \"Dear user\")"
+msgstr ""
+
+#. UgiDk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id261619081319555\n"
+"help.text"
+msgid "s.MsgBox(txt, MB_ICONINFORMATION, \"Confirmation of phrase\")"
+msgstr ""
+
+#. 42vSm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651618921455396\n"
+"help.text"
+msgid "For in-depth information please refer to <link href=\"https://wiki.documentfoundation.org/Macros/General/IO_to_Screen\" name=\"Input/Output to Screen with Python\">Input/Output to Screen with Python</link> on the Wiki."
+msgstr ""
+
+#. WMifG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id681618905411293\n"
+"help.text"
+msgid "<bookmark_value>Basic service;MsgBox</bookmark_value>"
+msgstr ""
+
+#. ogocf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id231618922407948\n"
+"help.text"
+msgid "Displays a dialog box containing a message and returns an optional value.<br/>MB_xx constants help specify the dialog type, the number and type of buttons to display, plus the icon type. By adding their respective values they form bit patterns, that define the <literal>MsgBox</literal> dialog appearance."
+msgstr ""
+
+#. 5adLA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id711619082902143\n"
+"help.text"
+msgid "An optional integer as detailed in above <literal>IDxx</literal> properties."
+msgstr ""
+
+#. hvEhT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id791618906935711\n"
+"help.text"
+msgid "<bookmark_value>Basic service;Now</bookmark_value>"
+msgstr ""
+
+#. f96nJ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id191619084216660\n"
+"help.text"
+msgid "Returns the current system date and time as a <literal>datetime</literal>.<literal>datetime</literal> Python native object."
+msgstr ""
+
+#. qxE2n
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id831618907521168\n"
+"help.text"
+msgid "<bookmark_value>Basic service;RGB</bookmark_value>"
+msgstr ""
+
+#. vBVsk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id621619448293385\n"
+"help.text"
+msgid "Returns an integer color value consisting of red, green, and blue components."
+msgstr ""
+
+#. vPBAA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id201619096429785\n"
+"help.text"
+msgid "<input>svc.RGB(red:int, green: int, blue: int): int</input>"
+msgstr ""
+
+#. AAeE4
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381619096830033\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. SDu3C
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id81618907850447\n"
+"help.text"
+msgid "<bookmark_value>Basic service;ThisComponent</bookmark_value>"
+msgstr ""
+
+#. 7wnpT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id141622840830978\n"
+"help.text"
+msgid "If the current component refers to a %PRODUCTNAME document, this method returns the UNO object representing the document."
+msgstr ""
+
+#. 72GZE
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id961622841287976\n"
+"help.text"
+msgid "The method will return <literal>None</literal> when the current component does not correspond to a document."
+msgstr ""
+
+#. xbQ6U
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id81618907858201\n"
+"help.text"
+msgid "<bookmark_value>Basic service;ThisDatabaseDocument</bookmark_value>"
+msgstr ""
+
+#. GXewr
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id271622912644859\n"
+"help.text"
+msgid "If the script is being executed from a Base document or any of its subcomponents this method returns the main component of the Base instance."
+msgstr ""
+
+#. 6MCpX
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id811622912819443\n"
+"help.text"
+msgid "This method returns <literal>None</literal> otherwise."
+msgstr ""
+
+#. q3CG8
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id201623153844931\n"
+"help.text"
+msgid "Visit the <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sdb_1_1OfficeDatabaseDocument.html\" name=\"OfficeDatabaseDocument\">OfficeDatabaseDocument</link> API page to learn more about Base's main component structure."
+msgstr ""
+
+#. mAUuG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id81618907851793\n"
+"help.text"
+msgid "<bookmark_value>Basic service;Xray</bookmark_value>"
+msgstr ""
+
+#. TwoGN
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451619094057178\n"
+"help.text"
+msgid "Inspect Uno objects or variables."
+msgstr ""
+
+#. 2A4om
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619094660345\n"
+"help.text"
+msgid "<emph>obj</emph>: A variable or Uno object."
+msgstr ""
+
+#. fMbAm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id951618554355538\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Macros/General/IO_to_Screen\" name=\"Input/Output to Screen with Python\">Input/Output to Screen with Python</link> on the wiki"
+msgstr ""
+
#. RYwFj
#: sf_calc.xhp
msgctxt ""
@@ -2212,22 +3679,22 @@ msgctxt ""
msgid "<variable id=\"CalcService\"><link href=\"text/sbasic/shared/03/sf_calc.xhp\" name=\"Calc service\"><literal>SFDocuments</literal>.<literal>Calc</literal> service</link></variable>"
msgstr ""
-#. DLwen
+#. DGXCA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id381589189355849\n"
"help.text"
-msgid "The <literal>SFDocuments</literal> library provides a number of methods and properties to facilitate the management and handling of LibreOffice Calc documents."
+msgid "The <literal>SFDocuments</literal> library provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME Calc documents."
msgstr ""
-#. ts5ZW
+#. m4FFE
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591014177269\n"
"help.text"
-msgid "Some methods are generic for all types of documents and are inherited from the <literal>SF_Document</literal> service, whereas other methods are specific for the <literal>SF_Calc</literal> module."
+msgid "Some methods are generic for all types of documents and are inherited from the <literal>Document</literal> service, whereas other methods are specific for the <literal>SF_Calc</literal> module."
msgstr ""
#. kTVJM
@@ -2275,49 +3742,58 @@ msgctxt ""
msgid "Service invocation"
msgstr ""
-#. DLSfC
+#. z3JcW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"par_id141610734722352\n"
+"par_id591589191059889\n"
"help.text"
-msgid "Before using the <literal>Calc</literal> service the <literal>ScriptForge</literal> library needs to be loaded using:"
+msgid "The <literal>Calc</literal> service is closely related to the <literal>UI</literal> service of the <literal>ScriptForge</literal> library. Below are a few examples of how the <literal>Calc</literal> service can be invoked."
msgstr ""
-#. z3JcW
+#. mKqEu
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"par_id591589191059889\n"
+"par_id551621623999947\n"
"help.text"
-msgid "The <literal>Calc</literal> service is closely related to the <literal>UI</literal> service of the <literal>ScriptForge</literal> library. Below are a few examples of how the <literal>Calc</literal> service can be invoked."
+msgid "The code snippet below creates a <literal>Calc</literal> service instance that corresponds to the currently active Calc document."
msgstr ""
-#. zNhLz
+#. gECrc
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id571589191739218\n"
+"par_id341621467500466\n"
"help.text"
-msgid "'1) From the ScriptForge.UI service:"
+msgid "Another way to create an instance of the <literal>Calc</literal> service is using the <literal>UI</literal> service. In the following example, a new Calc document is created and <literal>oDoc</literal> is a <literal>Calc</literal> service instance:"
msgstr ""
-#. BhvuW
+#. x6qdq
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id331589191766531\n"
+"par_id921621467621019\n"
"help.text"
-msgid "'Or: Set oDoc = ui.OpenDocument(\"C:\\Me\\MyFile.ods\")"
+msgid "Or using the <literal>OpenDocument</literal> method from the <literal>UI</literal> service:"
msgstr ""
-#. GZXJG
+#. MDxMC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id571589191774268\n"
+"par_id741621467697967\n"
"help.text"
-msgid "'2) Directly if the document is already open"
+msgid "It is also possible to instantiate the <literal>Calc</literal> service using the <literal>CreateScriptService</literal> method:"
+msgstr ""
+
+#. CKafD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id271621467810774\n"
+"help.text"
+msgid "In the example above, \"MyFile.ods\" is the name of an open document window. If this argument is not provided, the active window is considered."
msgstr ""
#. gfpHw
@@ -2428,13 +3904,13 @@ msgctxt ""
msgid "Either a string designating a set of contiguous cells located in a sheet of the current instance or an <literal>object</literal> produced by the <literal>.Range</literal> property."
msgstr ""
-#. YTCe8
+#. 6CySa
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id691591020711395\n"
"help.text"
-msgid "The shortcut \"~\" (tilde) represents the current selection or the first range if multiple ranges are selected."
+msgid "The shortcut \"~\" (tilde) represents the current selection or the first selected range if multiple ranges are selected."
msgstr ""
#. 7JEat
@@ -3040,13 +4516,13 @@ msgctxt ""
msgid "If the argument <literal>SheetName</literal> is provided, the given sheet is activated and it becomes the currently selected sheet. If the argument is absent, then the document window is activated."
msgstr ""
-#. GwCLE
+#. EhMzz
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id821591631203996\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be activated in the document."
+msgid "<emph>sheetname</emph>: The name of the sheet to be activated in the document. The default value is an empty string, meaning that the document window will be activated without changing the active sheet."
msgstr ""
#. 2cgiA
@@ -3076,13 +4552,13 @@ msgctxt ""
msgid "Clears all the contents and formats of the given range."
msgstr ""
-#. rAvDo
+#. M5PqA
#: 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 ""
#. Wz6CH
@@ -3094,13 +4570,13 @@ msgctxt ""
msgid "Clears the formats and styles in the given range."
msgstr ""
-#. uCqaF
+#. 6Qxnv
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id611592919864268\n"
"help.text"
-msgid "<emph>Range</emph> : The range whose formats and styles are to be cleared, as a string."
+msgid "<emph>range</emph>: The range whose formats and styles are to be cleared, as a string."
msgstr ""
#. sMwMp
@@ -3112,13 +4588,13 @@ msgctxt ""
msgid "Clears the values and formulas in the given range."
msgstr ""
-#. Cx3CM
+#. eEGn9
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id771592919928320\n"
"help.text"
-msgid "<emph>Range</emph> : The range whose values and formulas are to be cleared, as a string."
+msgid "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string."
msgstr ""
#. n6vJD
@@ -3130,31 +4606,31 @@ msgctxt ""
msgid "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful."
msgstr ""
-#. Di3Hd
+#. YqGL2
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id871591631693741\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be copied as a string or its reference as an object."
+msgid "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object."
msgstr ""
-#. azG6n
+#. 5cEGG
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591632126180\n"
"help.text"
-msgid "<emph>NewName</emph> : The name of the sheet to insert. The name must not be in use in the document."
+msgid "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document."
msgstr ""
-#. XDAoM
+#. 8sSno
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211591632192379\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
msgstr ""
#. yuvEn
@@ -3211,40 +4687,40 @@ msgctxt ""
msgid "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet."
msgstr ""
-#. BbR9B
+#. tCseT
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id471591714947181\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password."
msgstr ""
-#. FG6BQ
+#. gHjz6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id9915917146142\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be copied as a string."
+msgid "<emph>sheetname</emph>: The name of the sheet to be copied as a string."
msgstr ""
-#. vNK3G
+#. PeZ4F
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id71591714614904\n"
"help.text"
-msgid "<emph>NewName</emph> : The name of the copied sheet to be inserted in the document. The name must not be in use in the document."
+msgid "<emph>newname</emph>: The name of the copied sheet to be inserted in the document. The name must not be in use in the document."
msgstr ""
-#. 4UmRW
+#. 2niVz
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id601591714614407\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
msgstr ""
#. iEHJy
@@ -3283,22 +4759,22 @@ msgctxt ""
msgid "The source range may belong to another <emph>open</emph> document."
msgstr ""
-#. 6BKth
+#. RBQG9
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id761592558768578\n"
"help.text"
-msgid "<emph>SourceRange</emph> : The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
+msgid "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
msgstr ""
-#. vsAZV
+#. 3MUwk
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id711592558768466\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered."
msgstr ""
#. FbkjF
@@ -3391,49 +4867,58 @@ msgctxt ""
msgid "The source range may belong to another <emph>open</emph> document."
msgstr ""
-#. Tv5So
+#. CEaED
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id841592903121145\n"
"help.text"
-msgid "<emph>SourceRange</emph> : The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
+msgid "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
msgstr ""
-#. K5ANF
+#. v3d3d
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id5515929031211000\n"
"help.text"
-msgid "<emph>DestinationRange</emph> : The destination of the copied range of cells, as a string."
+msgid "<emph>destinationrange</emph>: The destination of the copied range of cells, as a string."
msgstr ""
-#. SzA83
+#. LsHF6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id461592905128991\n"
"help.text"
-msgid "Copy within the same document :"
+msgid "Copy within the same document:"
msgstr ""
-#. GtG3C
+#. dNdmJ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"bas_id601592904507182\n"
"help.text"
-msgid "'Returned range: $SheetY.$C$5:$J$14"
+msgid "' Returns a range string: \"$SheetY.$C$5:$J$14\""
msgstr ""
-#. RXkyV
+#. FBbwi
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id1001592905195364\n"
"help.text"
-msgid "Copy from one file to another :"
+msgid "Copy from one file to another:"
+msgstr ""
+
+#. 2fvZe
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id761621538667290\n"
+"help.text"
+msgid "doc.CopyToRange(\"SheetX.A1:F10\", \"SheetY.C5:J5\")"
msgstr ""
#. so8uw
@@ -3445,13 +4930,13 @@ msgctxt ""
msgid "Apply the functions Average, Count, Max, Min and Sum, respectively, to all the cells containing numeric values on a given range."
msgstr ""
-#. fPXvC
+#. F2UTC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id741595777001537\n"
"help.text"
-msgid "<emph>Range</emph> : The range to which the function will be applied, as a string."
+msgid "<emph>range</emph>: The range to which the function will be applied, as a string."
msgstr ""
#. ZhAYY
@@ -3472,6 +4957,96 @@ msgctxt ""
msgid "Cells in the given range that contain text will be ignored by all of these functions. For example, the <literal>DCount</literal> method will not count cells with text, only numerical cells."
msgstr ""
+#. BVKEy
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id501623063693649\n"
+"help.text"
+msgid "Depending on the parameters provided this method will return:"
+msgstr ""
+
+#. pBZm6
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id611623063742045\n"
+"help.text"
+msgid "A zero-based Array (or a tuple in Python) with the names of all the forms contained in a given sheet (if the <literal>form</literal> argument is absent)"
+msgstr ""
+
+#. FHWZs
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id641623063744536\n"
+"help.text"
+msgid "A <literal>SFDocuments.Form</literal> service instance representing the form specified as argument."
+msgstr ""
+
+#. YdQaD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id441623090893210\n"
+"help.text"
+msgid "<emph>sheetname</emph>: The name of the sheet, as a string, from which the form will be retrieved."
+msgstr ""
+
+#. BV8GH
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id451623063459286\n"
+"help.text"
+msgid "<emph>form</emph>: The name or index corresponding to a form stored in the specified sheet. If this argument is absent, the method will return a list with the names of all forms available in the sheet."
+msgstr ""
+
+#. sFFyE
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id251623063305557\n"
+"help.text"
+msgid "In the following examples, the first line gets the names of all forms stored in \"Sheet1\" and the second line retrieves the <literal>Form</literal> object of the form named \"Form_A\" which is stored in \"Sheet1\"."
+msgstr ""
+
+#. G9yMh
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id191623063399519\n"
+"help.text"
+msgid "Set FormNames = oDoc.Forms(\"Sheet1\")"
+msgstr ""
+
+#. cFBZw
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id691623063399711\n"
+"help.text"
+msgid "Set FormA = oDoc.Forms(\"Sheet1\", \"Form_A\")"
+msgstr ""
+
+#. NY6Wb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id271623063215023\n"
+"help.text"
+msgid "form_names = doc.Forms(\"Sheet1\")"
+msgstr ""
+
+#. DQsCo
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id961623063234990\n"
+"help.text"
+msgid "form_A = doc.Forms(\"Sheet1\", \"Form_A\")"
+msgstr ""
+
#. y9kCE
#: sf_calc.xhp
msgctxt ""
@@ -3481,22 +5056,22 @@ msgctxt ""
msgid "Converts a column number ranging between 1 and 1024 into its corresponding letter (column 'A', 'B', ..., 'AMJ'). If the given column number is outside the allowed range, a zero-length string is returned."
msgstr ""
-#. gUDC3
+#. EfsXe
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id83159163272628\n"
"help.text"
-msgid "<emph>ColumnNumber</emph> : The column number as an integer value in the interval 1 ... 1024."
+msgid "<emph>columnnumber</emph>: The column number as an integer value in the interval 1 ... 1024."
msgstr ""
-#. yDnhD
+#. 6yjtp
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id391611754462421\n"
+"par_id11621539831303\n"
"help.text"
-msgid "'Shows a message box with the string \"C\""
+msgid "Displays a message box with the name of the third column, which by default is \"C\"."
msgstr ""
#. XNAhU
@@ -3517,13 +5092,13 @@ msgctxt ""
msgid "Get the formula(s) stored in the given range of cells as a single string, a 1D or a 2D array of strings."
msgstr ""
-#. RG8Gg
+#. KDFkQ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891593880142588\n"
"help.text"
-msgid "<emph>Range</emph> : The range where to get the formulas from, as a string."
+msgid "<emph>range</emph>: The range where to get the formulas from, as a string."
msgstr ""
#. tBeSN
@@ -3544,22 +5119,22 @@ msgctxt ""
msgid "Get the value(s) stored in the given range of cells as a single value, a 1D array or a 2D array. All values are either doubles or strings."
msgstr ""
-#. gy45t
+#. XACNZ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id91592231156434\n"
"help.text"
-msgid "<emph>Range</emph> : The range where to get the values from, as a string."
+msgid "<emph>range</emph>: The range where to get the values from, as a string."
msgstr ""
-#. t7Dxx
+#. ojRBo
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id991611756492772\n"
"help.text"
-msgid "If a cell contains a date, the number corresponding to that date will be returned. To convert numeric values to dates, use the Basic <link href=\"text/sbasic/shared/03100300.xhp\" name=\"CDate function\"><literal>CDate</literal> builtin function</link>."
+msgid "If a cell contains a date, the number corresponding to that date will be returned. To convert numeric values to dates in Basic scripts, use the Basic <link href=\"text/sbasic/shared/03100300.xhp\" name=\"CDate Basic\"><literal>CDate</literal> builtin function</link>. In Python scripts, use the <link href=\"text/sbasic/shared/03/sf_basic.xhp#CDate\" name=\"CDate Python\"><literal>CDate</literal> function from the <literal>Basic</literal> service.</link>"
msgstr ""
#. YYMuH
@@ -3589,31 +5164,31 @@ msgctxt ""
msgid "The method returns a string representing the modified range of cells."
msgstr ""
-#. FYhhA
+#. GrquM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id851593685490824\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. aTojh
+#. VdTtY
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id641593685490936\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell to insert the imported data, as a string. If instead a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination cell to insert the imported data, as a string. If instead a range is given, only its top-left cell is considered."
msgstr ""
-#. wrD7S
+#. BrTfu
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id641593685863838\n"
"help.text"
-msgid "<emph>FilterOptions</emph> : The arguments for the CSV input filter. The default filter makes following assumptions:"
+msgid "<emph>filteroptions</emph>: The arguments for the CSV input filter. The default filter makes following assumptions:"
msgstr ""
#. Mb4c6
@@ -3724,49 +5299,49 @@ msgctxt ""
msgid "The method returns <literal>True</literal> when the import was successful."
msgstr ""
-#. HfEiJ
+#. rgoAd
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id311599568986784\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. Makpm
+#. j2J5e
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id711596555746281\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name to use to find the database in the databases register. This argument is ignored if a <literal>FileName</literal> is provided."
+msgid "<emph>registrationname</emph>: The name to use to find the database in the databases register. This argument is ignored if a <literal>filename</literal> is provided."
msgstr ""
-#. iG9FB
+#. 2hSHw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211599568986329\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination of the imported data, as a string. If a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination of the imported data, as a string. If a range is given, only its top-left cell is considered."
msgstr ""
-#. T8KAC
+#. aMfVw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id451599489278429\n"
"help.text"
-msgid "<emph>SQLCommand</emph> : A table or query name (without surrounding quotes or square brackets) or a SELECT SQL statement in which table and field names may be surrounded by square brackets or quotes to improve its readability."
+msgid "<emph>sqlcommand</emph>: A table or query name (without surrounding quotes or square brackets) or a SELECT SQL statement in which table and field names may be surrounded by square brackets or quotes to improve its readability."
msgstr ""
-#. GiN95
+#. wFpLr
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id271599489278141\n"
"help.text"
-msgid "<emph>DirectSQL</emph> : When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. The argument is ignored for tables. For queries, the applied option is the one set when the query was defined."
+msgid "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. The argument is ignored for tables. For queries, the applied option is the one set when the query was defined."
msgstr ""
#. toj8z
@@ -3778,22 +5353,22 @@ msgctxt ""
msgid "Inserts a new empty sheet before an existing sheet or at the end of the list of sheets."
msgstr ""
-#. iFgTP
+#. Xbm7k
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id941591698472748\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the new sheet."
+msgid "<emph>sheetname</emph>: The name of the new sheet."
msgstr ""
-#. agryz
+#. XbXNM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id84159169847269\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the new sheet."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the new sheet. This argument is optional and the default behavior is to insert the sheet at the last position."
msgstr ""
#. UCmit
@@ -3814,22 +5389,22 @@ msgctxt ""
msgid "Moves a specified source range to a destination range of cells. The method returns a string representing the modified range of cells. The dimension of the modified area is fully determined by the size of the source area."
msgstr ""
-#. Eh8ar
+#. UqxZv
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id571592569476332\n"
"help.text"
-msgid "<emph>Source</emph> : The source range of cells, as a string."
+msgid "<emph>source</emph>: The source range of cells, as a string."
msgstr ""
-#. MSSig
+#. G6BSW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891592569476362\n"
"help.text"
-msgid "<emph>Destination</emph> : The destination cell, as a string. If a range is given, its top-left cell is considered as the destination."
+msgid "<emph>destination</emph>: The destination cell, as a string. If a range is given, its top-left cell is considered as the destination."
msgstr ""
#. NorEd
@@ -3841,22 +5416,22 @@ msgctxt ""
msgid "Moves an existing sheet and places it before a specified sheet or at the end of the list of sheets."
msgstr ""
-#. s6bx7
+#. dgAxB
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591698903911\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to move. The sheet must exist or an exception is raised."
+msgid "<emph>sheetname</emph>: The name of the sheet to move. The sheet must exist or an exception is raised."
msgstr ""
-#. kp595
+#. fevuS
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id9159169890334\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which the original sheet will be placed."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which the original sheet will be placed. This argument is optional and the default behavior is to move the sheet to the last position."
msgstr ""
#. pd5t4
@@ -3886,67 +5461,67 @@ msgctxt ""
msgid "This method has the same behavior as the homonymous Calc's <link href=\"text/scalc/01/04060109.xhp\" name=\"Offset function\">Offset function</link>."
msgstr ""
-#. uiv8D
+#. G2oD2
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id901592233506293\n"
"help.text"
-msgid "<emph>Reference</emph> : The range, as a string, that the method will use as reference to perform the offset operation."
+msgid "<emph>reference</emph>: The range, as a string, that the method will use as reference to perform the offset operation."
msgstr ""
-#. YmkNz
+#. Ra7aW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id781592234124856\n"
"help.text"
-msgid "<emph>Rows</emph> : The number of rows by which the initial range is offset upwards (negative value) or downwards (positive value). Use 0 (default) to stay in the same row."
+msgid "<emph>rows</emph>: The number of rows by which the initial range is offset upwards (negative value) or downwards (positive value). Use 0 (default) to stay in the same row."
msgstr ""
-#. fR6JC
+#. FvqjV
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id971592234138769\n"
"help.text"
-msgid "<emph>Columns</emph> : The number of columns by which the initial range is offset to the left (negative value) or to the right (positive value). Use 0 (default) to stay in the same column."
+msgid "<emph>columns</emph>: The number of columns by which the initial range is offset to the left (negative value) or to the right (positive value). Use 0 (default) to stay in the same column."
msgstr ""
-#. TKX46
+#. VzgGM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321592234150061\n"
"help.text"
-msgid "<emph>Height</emph> : The vertical height for an area that starts at the new range position. Default = 0 (no vertical resizing)."
+msgid "<emph>height</emph>: The vertical height for an area that starts at the new range position. Omit this argument when no vertical resizing is needed."
msgstr ""
-#. 8uqoL
+#. JxENN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id271592234165247\n"
"help.text"
-msgid "<emph>Width</emph> : The horizontal width for an area that starts at the new range position. Default = 0 (no horizontal resizing)."
+msgid "<emph>width</emph>: The horizontal width for an area that starts at the new range position. Omit this argument when no horizontal resizing is needed."
msgstr ""
-#. hT42G
+#. t9QDN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id871592234172652\n"
"help.text"
-msgid "Arguments <literal>Rows</literal> and <literal>Columns</literal> must not lead to zero or negative start row or column."
+msgid "Arguments <literal>rows</literal> and <literal>columns</literal> must not lead to zero or negative start row or column."
msgstr ""
-#. QcACo
+#. JAxEm
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211592234180073\n"
"help.text"
-msgid "Arguments <literal>Height</literal> and <literal>Width</literal> must not lead to zero or negative count of rows or columns."
+msgid "Arguments <literal>height</literal> and <literal>width</literal> must not lead to zero or negative count of rows or columns."
msgstr ""
#. BkCDz
@@ -3976,13 +5551,22 @@ msgctxt ""
msgid "Removes an existing sheet from the document."
msgstr ""
-#. 9Mvbg
+#. Gwe7Z
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id991621620588147\n"
+"help.text"
+msgid "<input>svc.RemoveSheet(sheetname: str): bool</input>"
+msgstr ""
+
+#. dVxiA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id331591699085330\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to remove."
+msgid "<emph>sheetname</emph>: The name of the sheet to remove."
msgstr ""
#. GwKHr
@@ -3994,22 +5578,22 @@ msgctxt ""
msgid "Renames the given sheet and returns <literal>True</literal> if successful."
msgstr ""
-#. mAigC
+#. ofAiN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id161591704316337\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to rename."
+msgid "<emph>sheetname</emph>: The name of the sheet to rename."
msgstr ""
-#. s8sbi
+#. JHEDe
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id931591704316998\n"
"help.text"
-msgid "<emph>NewName</emph> : the new name of the sheet. It must not exist yet."
+msgid "<emph>newname</emph>: the new name of the sheet. It must not exist yet."
msgstr ""
#. bwtAA
@@ -4021,13 +5605,13 @@ msgctxt ""
msgid "This example renames the active sheet to \"SheetY\":"
msgstr ""
-#. EfMAM
+#. qEM6N
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id191592745582983\n"
"help.text"
-msgid "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>Value</literal> argument. Vectors are always expanded vertically."
+msgid "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>value</literal> argument. Vectors are always expanded vertically."
msgstr ""
#. tm6AR
@@ -4039,22 +5623,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. 6bCom
+#. FAuKq
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id801592745582116\n"
"help.text"
-msgid "<emph>TargetCell</emph> : The cell or a range as a string from where to start to store the given value."
+msgid "<emph>targetcell</emph>: The cell or a range as a string from where to start to store the given value."
msgstr ""
-#. SWWie
+#. aK7EZ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321592745582192\n"
"help.text"
-msgid "<emph>Value</emph> : A scalar, a vector or an array with the new values to be stored from the target cell or from the top-left corner of the range if <literal>TargetCell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
+msgid "<emph>value</emph>: A scalar, a vector or an array (in Python, one or two-dimensional lists and tuples) with the new values to be stored from the target cell or from the top-left corner of the range if <literal>targetcell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
msgstr ""
#. 7BCXQ
@@ -4111,49 +5695,49 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. 9FVf6
+#. xYrHQ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id361592231799255\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range where to store the given value, as a string."
+msgid "<emph>targetrange</emph>: The range where to store the given value, as a string."
msgstr ""
-#. gSTGX
+#. dydXF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id461592232081985\n"
"help.text"
-msgid "<emph>Value</emph> : A scalar, a vector or an array with the new values for each cell of the range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
+msgid "<emph>value</emph>: A scalar, a vector or an array with the new values for each cell of the range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
msgstr ""
-#. J2xh8
+#. CgwVF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id841592745785192\n"
"help.text"
-msgid "The full range is updated and the remainder of the sheet is left unchanged. If the size of <literal>Value</literal> is smaller than the size of <literal>TargetRange</literal>, then the remaining cells will be emptied."
+msgid "The full range is updated and the remainder of the sheet is left unchanged. If the size of <literal>value</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells will be emptied."
msgstr ""
-#. 6eqih
+#. QFkLr
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id191611776838396\n"
"help.text"
-msgid "If the size of <literal>Value</literal> is larger than the size of <literal>TargetRange</literal>, then <literal>Value</literal> is only partially copied until it fills the size of <literal>TargetRange</literal>."
+msgid "If the size of <literal>value</literal> is larger than the size of <literal>targetrange</literal>, then <literal>value</literal> is only partially copied until it fills the size of <literal>targetrange</literal>."
msgstr ""
-#. nfsWb
+#. ykBk6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id71611776941663\n"
"help.text"
-msgid "Vectors are expanded vertically, except if the range has a height of exactly 1 row."
+msgid "Vectors are expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row."
msgstr ""
#. FJCPf
@@ -4174,6 +5758,15 @@ msgctxt ""
msgid "'Below the Value and TargetRange have the same size"
msgstr ""
+#. 4LFnH
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id731621689592755\n"
+"help.text"
+msgid "If you want to fill a single row with values, you can use the <literal>Offset</literal> function. In the example below, consider that <literal>arrData</literal> is a one-dimensional array:"
+msgstr ""
+
#. g8mER
#: sf_calc.xhp
msgctxt ""
@@ -4192,22 +5785,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. L8GHj
+#. FtFpL
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id22159576768782\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range to which the style will be applied, as a string."
+msgid "<emph>targetrange</emph>: The range to which the style will be applied, as a string."
msgstr ""
-#. UxxXn
+#. aAGcy
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id181595767687247\n"
"help.text"
-msgid "<emph>Style</emph> : The name of the cell style to apply."
+msgid "<emph>style</emph>: The name of the cell style to apply."
msgstr ""
#. DCAWV
@@ -4228,22 +5821,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. CWJbm
+#. F5XDi
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891593880376776\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range to insert the formulas, as a string."
+msgid "<emph>targetrange</emph>: The range to insert the formulas, as a string."
msgstr ""
-#. rRECW
+#. A2UQF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id941593880376500\n"
"help.text"
-msgid "<emph>Formula</emph> : A string, a vector or an array of strings with the new formulas for each cell in the target range."
+msgid "<emph>formula</emph>: A string, a vector or an array of strings with the new formulas for each cell in the target range."
msgstr ""
#. 746E8
@@ -4264,31 +5857,31 @@ msgctxt ""
msgid "If the given formula is a string, the unique formula is pasted along the whole range with adjustment of the relative references."
msgstr ""
-#. uqWBs
+#. zr47n
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id491593880857823\n"
"help.text"
-msgid "If the size of <literal>Formula</literal> is smaller than the size of <literal>TargetRange</literal>, then the remaining cells are emptied."
+msgid "If the size of <literal>formula</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells are emptied."
msgstr ""
-#. oMpK4
+#. LwoGL
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id701611778103306\n"
"help.text"
-msgid "If the size of <literal>Formula</literal> is larger than the size of <literal>TargetRange</literal>, then the formulas are only partially copied until it fills the size of <literal>TargetRange</literal>."
+msgid "If the size of <literal>formula</literal> is larger than the size of <literal>targetrange</literal>, then the formulas are only partially copied until it fills the size of <literal>targetrange</literal>."
msgstr ""
-#. xGTCr
+#. GQC3N
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id761611777946581\n"
"help.text"
-msgid "Vectors are always expanded vertically, except if the range has a height of exactly 1 row."
+msgid "Vectors are always expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row."
msgstr ""
#. rNEEY
@@ -4318,67 +5911,67 @@ msgctxt ""
msgid "Sorts the given range based on up to 3 columns/rows. The sorting order may vary by column/row. It returns a string representing the modified range of cells. The size of the modified area is fully determined by the size of the source area."
msgstr ""
-#. V6NVn
+#. MVGBC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id171595692394598\n"
"help.text"
-msgid "<emph>Range</emph> : The range to be sorted, as a string."
+msgid "<emph>range</emph>: The range to be sorted, as a string."
msgstr ""
-#. zppvu
+#. aenrK
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id171595692814163\n"
"help.text"
-msgid "<emph>SortKeys</emph> : A scalar (if 1 column/row) or an array of column/row numbers starting from 1. The maximum number of keys is 3."
+msgid "<emph>sortkeys</emph>: A scalar (if 1 column/row) or an array of column/row numbers starting from 1. The maximum number of keys is 3."
msgstr ""
-#. rmDya
+#. aQF93
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id421595692962095\n"
"help.text"
-msgid "<emph>SortOrder</emph> : A scalar or an array of strings containing the values \"ASC\" (ascending), \"DESC\" (descending) or \"\" (which defaults to ascending). Each item is paired with the corresponding item in <literal>SortKeys</literal>. If the <literal>SortOrder</literal> array is shorter than <literal>SortKeys</literal>, the remaining keys are sorted in ascending order."
+msgid "<emph>sortorder</emph>: A scalar or an array of strings containing the values \"ASC\" (ascending), \"DESC\" (descending) or \"\" (which defaults to ascending). Each item is paired with the corresponding item in <literal>sortkeys</literal>. If the <literal>sortorder</literal> array is shorter than <literal>sortkeys</literal>, the remaining keys are sorted in ascending order."
msgstr ""
-#. oPgRB
+#. GVpuf
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id361595692394604\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell of the sorted range of cells, as a string. If a range is given, only its top-left cell is considered. By default the source Range is overwritten."
+msgid "<emph>destinationcell</emph>: The destination cell of the sorted range of cells, as a string. If a range is given, only its top-left cell is considered. By default the source Range is overwritten."
msgstr ""
-#. JogWo
+#. QyaTf
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id441595693011034\n"
"help.text"
-msgid "<emph>ContainsHeader</emph> : When <literal>True</literal>, the first row/column is not sorted."
+msgid "<emph>containsheader</emph>: When <literal>True</literal>, the first row/column is not sorted."
msgstr ""
-#. Q7Bi2
+#. AbVtY
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id241595693169032\n"
"help.text"
-msgid "<emph>CaseSensitive</emph> : Only for string comparisons. Default = <literal>False</literal>"
+msgid "<emph>casesensitive</emph>: Only for string comparisons. Default = <literal>False</literal>"
msgstr ""
-#. g2ggy
+#. CL5Gm
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id1001595693326226\n"
"help.text"
-msgid "<emph>SortColumns</emph> : When <literal>True</literal>, the columns are sorted from left to right. Default = <literal>False</literal> : rows are sorted from top to bottom."
+msgid "<emph>sortcolumns</emph>: When <literal>True</literal>, the columns are sorted from left to right. Default = <literal>False</literal> : rows are sorted from top to bottom."
msgstr ""
#. LvjpD
@@ -4543,13 +6136,13 @@ msgctxt ""
msgid "Conversely, if a <literal>RegistrationName</literal> is specified, the <literal>FileName</literal> parameter should not be defined."
msgstr ""
-#. 3d6NY
+#. Bc97U
#: sf_database.xhp
msgctxt ""
"sf_database.xhp\n"
"par_id841615147168279\n"
"help.text"
-msgid "<emph>ReadOnly</emph>: Determines if the database will be opened as readonly (Default = True)."
+msgid "<emph>ReadOnly</emph>: Determines if the database will be opened as readonly (Default = <literal>True</literal>)."
msgstr ""
#. Gn7AF
@@ -4597,6 +6190,15 @@ msgctxt ""
msgid "' ... Run queries, SQL statements, ..."
msgstr ""
+#. AVkg5
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id361619188184750\n"
+"help.text"
+msgid "The <link href=\"text/sbasic/shared/03/sf_database.xhp#GetDatabase\" name=\"GetDatabase method\">GetDatabase</link> method used in the example above is part of ScriptForge's <literal>Base</literal> service."
+msgstr ""
+
#. EF9Lc
#: sf_database.xhp
msgctxt ""
@@ -5065,13 +6667,13 @@ msgctxt ""
msgid "In modal mode, the box is displayed and the execution of the macro process is suspended until one of the OK or Cancel buttons is pressed. In the meantime, user actions executed on the box can trigger specific actions."
msgstr ""
-#. QEaR3
+#. FFTSj
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
"par_id981598110463521\n"
"help.text"
-msgid "In non-modal mode, the dialog box is \"floating\" on the user desktop and the execution of the macro process continues normally. Regardless of its status, the dialog closes when the macro that displayed it finishes running."
+msgid "In non-modal mode, the dialog box is \"floating\" on the user desktop and the execution of the macro process continues normally. A non-modal dialog closes when it is terminated with the <literal>Terminate()</literal> method or when the %PRODUCTNAME session ends. The window close button is inactive in non-modal dialogs."
msgstr ""
#. GrpyR
@@ -5101,13 +6703,13 @@ msgctxt ""
msgid "Service invocation and usage"
msgstr ""
-#. v8RcL
+#. S8GrJ
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
"par_id361598174756160\n"
"help.text"
-msgid "The <literal>Dialog</literal> service is invoked through the <literal>CreateScriptService</literal> method. It requires three arguments to specify the dialog box to activate:"
+msgid "The <literal>Dialog</literal> service is invoked through the <literal>CreateScriptService</literal> method. It requires three positional arguments to specify the dialog box to activate:"
msgstr ""
#. Ntzqh
@@ -5137,6 +6739,15 @@ msgctxt ""
msgid "<emph>DialogName</emph>: A case-sensitive string designating the dialog."
msgstr ""
+#. r5vY5
+#: 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:"
+msgstr ""
+
#. mqjFF
#: sf_dialog.xhp
msgctxt ""
@@ -5164,22 +6775,67 @@ msgctxt ""
msgid "'... Process controls and do what is needed here"
msgstr ""
-#. ovpiH
+#. VD35X
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id601619622310089\n"
+"help.text"
+msgid "Or using Python:"
+msgstr ""
+
+#. knENA
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id41619622700314\n"
+"help.text"
+msgid "# ... controls initialization goes here..."
+msgstr ""
+
+#. 2PTBU
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id661611699964814\n"
+"help.text"
+msgid "# Default mode is Modal"
+msgstr ""
+
+#. ABoA2
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"pyc_id681619619965191\n"
+"help.text"
+msgid "# ... Process controls and do what is needed here"
+msgstr ""
+
+#. eehkB
#: 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 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 "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."
+msgstr ""
+
+#. QBG5g
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id741619625211462\n"
+"help.text"
+msgid "with Python:"
msgstr ""
-#. XxoaB
+#. n72Hv
#: 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."
+msgid "Note that in previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted when deemed appropriate."
msgstr ""
#. nXGkZ
@@ -5677,13 +7333,13 @@ msgctxt ""
msgid "This method is called from a dialog or control event, or when a dialog is displayed in non-modal mode."
msgstr ""
-#. eYDfG
+#. uoBhE
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
-"bas_id841598179117184\n"
+"par_id811620109056270\n"
"help.text"
-msgid "' Dialog stored in current document's standard library"
+msgid "Python and %PRODUCTNAME Basic examples both assume that the dialog is stored in current document's <literal>Standard</literal> library."
msgstr ""
#. 4qLn9
@@ -5704,13 +7360,13 @@ msgctxt ""
msgid "the list of the controls contained in the dialog"
msgstr ""
-#. 4EuYK
+#. hdSWz
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
"par_id81598185229301\n"
"help.text"
-msgid "a dialog control class instance based on its name"
+msgid "a <literal>DialogControl</literal> class instance based on its name"
msgstr ""
#. AEAHd
@@ -5740,13 +7396,40 @@ msgctxt ""
msgid "<literal>EndExecute()</literal> is usually contained in the processing of a macro triggered by a dialog or control event."
msgstr ""
-#. BkuiE
+#. yukGC
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
"par_id451598185776957\n"
"help.text"
-msgid "<emph>ReturnValue</emph> : The value passed to the running <literal>Execute()</literal> method."
+msgid "<emph>returnvalue</emph>: The value passed to the running <literal>Execute()</literal> method."
+msgstr ""
+
+#. ABome
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id411620110780170\n"
+"help.text"
+msgid "Using %PRODUCTNAME Basic:"
+msgstr ""
+
+#. EtAN6
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id11620110819754\n"
+"help.text"
+msgid "Using Python:"
+msgstr ""
+
+#. ML9Mz
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id81620201915101\n"
+"help.text"
+msgid "Above <link href=\"https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1lang_1_1EventObject.html\" name=\"com.sun.star.lang.EventObject\">com.sun.star.lang.EventObject</link> mentions are optional. Such annotations help identify %PRODUCTNAME Application Programming Interface (API)."
msgstr ""
#. FD9fr
@@ -5794,22 +7477,31 @@ msgctxt ""
msgid "For non-modal dialog boxes the method always returns 0 and the execution of the macro continues."
msgstr ""
-#. KmiEw
+#. Ej2iF
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
"par_id11598186461227\n"
"help.text"
-msgid "<emph>Modal</emph> : <literal>False</literal> when non-modal dialog. Default = <literal>True</literal>."
+msgid "<emph>modal</emph>: <literal>False</literal> when non-modal dialog. Default = <literal>True</literal>."
+msgstr ""
+
+#. fGatm
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id231620110023843\n"
+"help.text"
+msgid "In this Basic example <literal>myDialog</literal> dialog is stored in current document's <literal>Standard</literal> library."
msgstr ""
-#. DxiPm
+#. ouEVN
#: sf_dialog.xhp
msgctxt ""
"sf_dialog.xhp\n"
-"bas_id211598187104866\n"
+"par_id191620110162627\n"
"help.text"
-msgid "' Dialog stored in current document's standard library"
+msgid "This Python code displays <literal>DlgConvert</literal> modal dialog from <literal>Euro</literal> shared Basic library."
msgstr ""
#. ARCGg
@@ -5821,6 +7513,33 @@ msgctxt ""
msgid "Terminate the <literal>Dialog</literal> service for the current instance. Return <literal>True</literal> if the termination was successful."
msgstr ""
+#. CgAYf
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id951620300687150\n"
+"help.text"
+msgid "Below Basic and Python examples open <literal>DlgConsole</literal> and <literal>dlgTrace</literal> non-modal dialogs. They are respectively stored in <literal>ScriptForge</literal> and <literal>Access2Base</literal> shared libraries. Dialog close buttons are disabled and explicit termination is performed at the end of a running process."
+msgstr ""
+
+#. W3W3Y
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id301620302137482\n"
+"help.text"
+msgid "In this example a button in <literal>DlgConsole</literal> is substituting inhibited window closing:"
+msgstr ""
+
+#. 7z7hg
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id811620112217958\n"
+"help.text"
+msgid "With Python:"
+msgstr ""
+
#. BFfGX
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -5893,13 +7612,22 @@ msgctxt ""
msgid "Service invocation"
msgstr ""
-#. jKixF
+#. EnxDs
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id361598174756160\n"
"help.text"
-msgid "The <literal>DialogControl</literal><literal/> service is invoked from an existing <literal>Dialog</literal> service instance thru its <literal>Controls()</literal> method. The dialog must be initiated with the <literal>SFDialogs.Dialog</literal> service."
+msgid "The <literal>DialogControl</literal> service is invoked from an existing <literal>Dialog</literal> service instance through its <literal>Controls()</literal> method. The dialog must be initiated with the <literal>SFDialogs.Dialog</literal> service."
+msgstr ""
+
+#. RCFrE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id581598453210170\n"
+"help.text"
+msgid "myControl.Value = \"Dialog started at \" & Now()"
msgstr ""
#. WVG8J
@@ -5911,22 +7639,31 @@ msgctxt ""
msgid "' ... process the controls actual values"
msgstr ""
-#. 2PPv4
+#. gxhUu
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"par_id951598174966322\n"
+"pyc_id861620225235002\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 "text.Value = \"Dialog started at \" + strftime(\"%a, %d %b %Y %H:%M:%S\", localtime())"
msgstr ""
-#. WKCuT
+#. nu3f3
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"bas_id801598175242937\n"
+"pyc_id841620225235377\n"
"help.text"
-msgid "' oControl represents now the instance of the Control class having triggered the current event"
+msgid "# ... process the controls actual values"
+msgstr ""
+
+#. 2PPv4
+#: 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."
msgstr ""
#. 75WJy
@@ -7180,40 +8917,40 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event - using the <literal>OnNodeExpanded</literal> event - to complete the tree dynamically."
msgstr ""
-#. cK7HA
+#. T8xdA
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id761612711823834\n"
"help.text"
-msgid "<emph>ParentNode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
+msgid "<emph>parentnode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
msgstr ""
-#. g2Ubo
+#. qJ9ej
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id791612711823819\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The text appearing in the tree control box."
+msgid "<emph>displayvalue</emph>: The text appearing in the tree control box."
msgstr ""
-#. GV6Gp
+#. Pzz72
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id911612711823382\n"
"help.text"
-msgid "<emph>DataValue</emph>: Any value associated with the new node. Default value is <literal>Empty</literal>."
+msgid "<emph>datavalue</emph>: Any value associated with the new node. <literal>datavalue</literal> may be a string, a number or a date. Omit the argument when not applicable."
msgstr ""
-#. qbb2x
+#. 2pLPL
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"bas_id401612711823779\n"
+"par_id901620317110685\n"
"help.text"
-msgid "'Dialog stored in current document's standard library"
+msgid "%PRODUCTNAME Basic and Python examples pick up current document's <literal>myDialog</literal> dialog from <literal>Standard</literal> library."
msgstr ""
#. 8B3qP
@@ -7225,22 +8962,22 @@ msgctxt ""
msgid "Return <literal>True</literal> when a subtree, subordinate to a parent node, could be inserted successfully in a tree control. If the parent node had already child nodes before calling this method, the child nodes are erased."
msgstr ""
-#. UkE9k
+#. beond
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id781612713087722\n"
"help.text"
-msgid "<emph>ParentNode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
+msgid "<emph>parentnode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
msgstr ""
-#. 2FTD4
+#. QJ73V
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id36161271308759\n"
"help.text"
-msgid "<emph>FlatTree</emph>: a two dimension array sorted on the columns containing the display values. Such an array can be issued by the <literal>GetRows</literal> method applied on the <literal>SFDatabases.Database</literal> service. When an array item containing the text to be displayed is <literal>Empty</literal> or <literal>Null</literal>, no new subnode is created and the remainder of the row is skipped."
+msgid "<emph>flattree</emph>: a two dimension array sorted on the columns containing the display values. Such an array can be issued by the <literal>GetRows</literal> method applied on the <literal>SFDatabases.Database</literal> service. When an array item containing the text to be displayed is <literal>Empty</literal> or <literal>Null</literal>, no new subnode is created and the remainder of the row is skipped."
msgstr ""
#. r5QNj
@@ -7252,13 +8989,13 @@ msgctxt ""
msgid "Flat tree >>>> Resulting subtree"
msgstr ""
-#. SQH7v
+#. MUi8U
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id51612713087915\n"
"help.text"
-msgid "<emph>WithDataValue</emph>: When <literal>False</literal> default value is used, every column of <literal>FlatTree</literal> contains the text to be displayed in the tree control. When <literal>True</literal>, the texts to be displayed (<literal>DisplayValue</literal>) are in columns 0, 2, 4, ... while the data values (<literal>DataValue</literal>) are in columns 1, 3, 5, ..."
+msgid "<emph>withdatavalue</emph>: When <literal>False</literal> default value is used, every column of <literal>flattree</literal> contains the text to be displayed in the tree control. When <literal>True</literal>, the texts to be displayed (<literal>displayvalue</literal>) are in columns 0, 2, 4, ... while the data values (<literal>datavalue</literal>) are in columns 1, 3, 5, ..."
msgstr ""
#. fWnhZ
@@ -7279,31 +9016,22 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event to complete the tree dynamically."
msgstr ""
-#. QiXVA
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id671612780723837\n"
-"help.text"
-msgid "<emph>DisplayValue</emph>: The text appearing in the tree control box."
-msgstr ""
-
-#. Cw3b9
+#. JXyjD
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"par_id31612780723267\n"
+"par_id791612117823819\n"
"help.text"
-msgid "<emph>DataValue</emph>: Any value associated with the new node. Default value is <literal>Empty</literal>."
+msgid "<emph>displayvalue</emph>: The text appearing in the tree control box."
msgstr ""
-#. Ynpwt
+#. XxGFd
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id171612781589503\n"
"help.text"
-msgid "Traverses the tree and finds recursively, starting from the root, a node meeting some criteria. Either - 1 match is enough - having its display value matching <literal>DisplayValue</literal> pattern or having its data value equal to <literal>DataValue</literal>. The comparisons may be or not case-sensitive. The first matching occurrence is returned as a node UNO object of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>. <embedvar href=\"text/sbasic/shared/03/sf_dialogcontrol.xhp#XMutableTreeNode\"/>"
+msgid "Traverses the tree and finds recursively, starting from the root, a node meeting some criteria. Either - 1 match is enough - having its display value matching <literal>displayvalue</literal> pattern or having its data value equal to <literal>datavalue</literal>. The comparisons may be or not case-sensitive. The first matching occurrence is returned as a node UNO object of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>. <embedvar href=\"text/sbasic/shared/03/sf_dialogcontrol.xhp#XMutableTreeNode\"/>"
msgstr ""
#. 5Jxkj
@@ -7324,40 +9052,31 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event."
msgstr ""
-#. BSnCr
+#. Dd4Ti
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id541613670199211\n"
"help.text"
-msgid "One argument out of <literal>DisplayValue</literal> or <literal>DataValue</literal> must be specified. If both present, one match is sufficient to select the node."
+msgid "One argument out of <literal>displayvalue</literal> or <literal>datavalue</literal> must be specified. If both present, one match is sufficient to select the node."
msgstr ""
-#. fYkEn
+#. MF7PA
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id591612781589560\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The pattern to be matched. See the <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"String service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method. When equal to the zero-length string (default), this display value is not searched for."
-msgstr ""
-
-#. CF4o6
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id481612781589626\n"
-"help.text"
-msgid "<emph>DataValue</emph>: A string, a numeric value, a date. Use <literal>Empty</literal> default value when no value applies."
+msgid "<emph>displayvalue</emph>: The pattern to be matched. Refer to <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"String service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method for the list of possible wildcards. When equal to the zero-length string (default), this display value is not searched for."
msgstr ""
-#. g7uEG
+#. BE58W
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id141582384726168\n"
"help.text"
-msgid "<emph>CaseSensitive</emph>: Default value is <literal>False</literal>"
+msgid "<emph>casesensitive</emph>: Default value is <literal>False</literal>"
msgstr ""
#. 3oU3L
@@ -8098,85 +9817,103 @@ msgctxt ""
msgid "Service invocation"
msgstr ""
-#. C9LQA
+#. X6BV3
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id141610734722352\n"
+"par_id581611090387382\n"
"help.text"
-msgid "Before using the <literal>Document</literal> service the <literal>ScriptForge</literal> library needs to be loaded using:"
+msgid "Below are three variants of how the <literal>Document</literal> service can be invoked."
msgstr ""
-#. JFFek
+#. o39cT
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id591589191059889\n"
+"par_id181622816732197\n"
"help.text"
-msgid "The <literal>Document</literal> service is closely related to the <literal>UI</literal> and <literal>FileSystem</literal> services of the <literal>ScriptForge</literal> library."
+msgid "Using the <literal>getDocument</literal> method from the <literal>ScriptForge</literal>.<literal>UI</literal> service:"
msgstr ""
-#. X6BV3
+#. 6AZF9
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id581611090387382\n"
+"par_id181622818236233\n"
"help.text"
-msgid "Below are three variants of how the <literal>Document</literal> service can be invoked."
+msgid "Alternatively you can use the methods <literal>CreateDocument</literal> and <literal>OpenDocument</literal> from the <literal>UI</literal> service."
msgstr ""
-#. HevYB
+#. kv6B9
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"bas_id571589191739218\n"
+"par_id691622816765571\n"
"help.text"
-msgid "'1) From the ScriptForge.UI service:"
+msgid "Directly if the document is already open."
msgstr ""
-#. 6TA5q
+#. yFDEW
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"bas_id331589191766183\n"
+"par_id821622816825012\n"
"help.text"
-msgid "'Alternatively, using the CreateDocument or OpenDocument methods"
+msgid "From a macro triggered by a document event."
msgstr ""
-#. rAPFN
+#. FxfW2
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"bas_id571589191774268\n"
+"par_id831622816562430\n"
"help.text"
-msgid "'2) Directly if the document is already open"
+msgid "The <literal>Document</literal> service is closely related to the <literal>UI</literal> and <literal>FileSystem</literal> services."
msgstr ""
-#. CWFJB
+#. QF9FG
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"bas_id471598109329789\n"
+"par_id891582733781994\n"
"help.text"
-msgid "'3) From a macro triggered by a document event"
+msgid "Except when the document was closed by program with the CloseDocument method (it is then superfluous), it is recommended to free resources after use:"
msgstr ""
-#. LyvNw
+#. 2odf5
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id71611090922315\n"
+"pyc_id551622819064247\n"
"help.text"
-msgid "The use of the prefix \"<literal>SFDocuments.</literal>\" while calling the service is optional."
+msgid "def RunEvent(event)"
msgstr ""
-#. QF9FG
+#. oHQNa
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id891582733781994\n"
+"pyc_id311622819064554\n"
"help.text"
-msgid "Except when the document was closed by program with the CloseDocument method (it is then superfluous), it is recommended to free resources after use:"
+msgid "doc = CreateScriptService(\"SFDocuments.DocumentEvent\", Event)"
+msgstr ""
+
+#. sHApS
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"pyc_id221622819064967\n"
+"help.text"
+msgid "# (...)"
+msgstr ""
+
+#. LyvNw
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id71611090922315\n"
+"help.text"
+msgid "The use of the prefix \"<literal>SFDocuments.</literal>\" while calling the service is optional."
msgstr ""
#. z3oxC
@@ -8422,6 +10159,15 @@ msgctxt ""
msgid "The example below prints all the properties of a document. Note that the <literal>oDoc</literal> object returned by the <literal>UI.OpenDocument</literal> method is a <literal>SFDocuments.Document</literal> object."
msgstr ""
+#. eqL5J
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id571622826920742\n"
+"help.text"
+msgid "To access document properties in a Python script the user needs to directly access them using their names, as shown below:"
+msgstr ""
+
#. wmiy9
#: sf_document.xhp
msgctxt ""
@@ -8494,40 +10240,112 @@ msgctxt ""
msgid "Returns <literal>True</literal> if the document was successfully closed."
msgstr ""
-#. F2emZ
+#. Wt7L9
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id361589200121646\n"
"help.text"
-msgid "<emph>SaveAsk</emph> : If <literal>True</literal> (default), the user is invited to confirm if the changes should be written on disk. This argument is ignored if the document was not modified."
+msgid "<emph>saveask</emph> : If <literal>True</literal> (default), the user is invited to confirm if the changes should be written on disk. This argument is ignored if the document was not modified."
msgstr ""
-#. AxyoV
+#. STq4L
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id901599410483300\n"
+"bas_id751622827903730\n"
+"help.text"
+msgid "End If"
+msgstr ""
+
+#. vp56r
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id501623063693649\n"
+"help.text"
+msgid "Depending on the parameters provided this method will return:"
+msgstr ""
+
+#. wrCnS
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id611623063742045\n"
+"help.text"
+msgid "A zero-based Array (or a tuple in Python) with the names of all the forms contained in the document (if the <literal>form</literal> argument is absent)"
+msgstr ""
+
+#. hgt6o
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id641623063744536\n"
+"help.text"
+msgid "A <literal>SFDocuments.Form</literal> service instance representing the form specified as argument."
+msgstr ""
+
+#. 4WbGV
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id821623076570573\n"
+"help.text"
+msgid "This method is applicable only for Writer documents. Calc and Base documents have their own <literal>Forms</literal> method in the <link href=\"text/sbasic/shared/03/sf_calc.xhp#Forms\" name=\"Calc_Forms\">Calc</link> and <link href=\"text/sbasic/shared/03/sf_base.xhp#Forms\" name=\"Base_Forms\">Base</link> services, respectively."
+msgstr ""
+
+#. fRBBF
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id451623063459286\n"
+"help.text"
+msgid "<emph>form</emph>: The name or index corresponding to a form stored in the document. If this argument is absent, the method will return a list with the names of all forms available in the document."
+msgstr ""
+
+#. CELkA
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id251623063305557\n"
"help.text"
-msgid "This method is applicable <emph>only for Base documents</emph>."
+msgid "In the following examples, the first line gets the names of all forms in the document and the second line retrieves the <literal>Form</literal> object of the form named \"Form_A\"."
msgstr ""
-#. 47ud8
+#. 8GoMk
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id891599410524092\n"
+"bas_id191623063399519\n"
"help.text"
-msgid "It returns a <literal>SFDatabases.Database</literal> service instance giving access to the execution of SQL commands on the database defined and/or embedded in the actual Base document."
+msgid "Set FormNames = oDoc.Forms()"
msgstr ""
-#. cdu6C
+#. uCcpo
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
-"par_id721599410266911\n"
+"bas_id691623063399711\n"
"help.text"
-msgid "<emph>User, Password</emph> : The login parameters. Both default to \"\"."
+msgid "Set FormA = oDoc.Forms(\"Form_A\")"
+msgstr ""
+
+#. 9gHMA
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"pyc_id271623063215023\n"
+"help.text"
+msgid "form_names = doc.Forms()"
+msgstr ""
+
+#. H3946
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"pyc_id961623063234990\n"
+"help.text"
+msgid "form_A = doc.Forms(\"Form_A\")"
msgstr ""
#. Nmwv9
@@ -8557,22 +10375,22 @@ msgctxt ""
msgid "The document itself does not need to be active to be able to run commands."
msgstr ""
-#. qAb3U
+#. QSiFB
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id401589202413575\n"
"help.text"
-msgid "<emph>Command</emph> : Case-sensitive string containing the command in English. The command itself is not checked for correctness. If nothing happens after the command call, then the command is probably wrong."
+msgid "<emph>command</emph>: Case-sensitive string containing the command in English. The command itself is not checked for correctness. If nothing happens after the command call, then the command is probably wrong."
msgstr ""
-#. nZ8Yc
+#. wQF35
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id721611153068137\n"
"help.text"
-msgid "The following example runs the \"SelectData\" command in a Calc sheet named \"My_File.ods\", which will result in the selection of the data area based on the currently selected cell."
+msgid "The following example runs the \"SelectData\" command in a Calc sheet named \"MyFile.ods\", which will result in the selection of the data area based on the currently selected cell."
msgstr ""
#. pbYAn
@@ -8647,49 +10465,49 @@ msgctxt ""
msgid "The document itself does not need to be active to run this method."
msgstr ""
-#. cNiiE
+#. 7tX6c
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id331589203370950\n"
"help.text"
-msgid "<emph>FileName</emph> : A string containing the file name to be used. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: A string containing the file name to be used. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. AKbDA
+#. niFkh
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id631589204010142\n"
"help.text"
-msgid "<emph>Overwrite</emph> : If <literal>True</literal>, the destination file may be overwritten (default = <literal>False</literal>)."
+msgid "<emph>overwrite</emph>: If <literal>True</literal>, the destination file may be overwritten (default = <literal>False</literal>)."
msgstr ""
-#. zkP8D
+#. snX8q
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id811589204084107\n"
"help.text"
-msgid "<emph>Password</emph> (*) : A non-space string to protect the document."
+msgid "<emph>password</emph> (*): A non-space string to protect the document."
msgstr ""
-#. ntVEA
+#. g3wDy
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id451589204163772\n"
"help.text"
-msgid "<emph>FilterName</emph> (*) : The name of a filter that should be used for saving the document. If this argument is passed, then the filter must exist."
+msgid "<emph>filtername</emph> (*): The name of a filter that should be used for saving the document. If this argument is passed, then the filter must exist."
msgstr ""
-#. N6WPC
+#. qZaAJ
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id981589204207800\n"
"help.text"
-msgid "<emph>FilterOptions</emph> (*) : An optional string of options associated with the filter."
+msgid "<emph>filteroptions</emph> (*): An optional string of options associated with the filter."
msgstr ""
#. FJywB
@@ -8719,49 +10537,49 @@ msgctxt ""
msgid "The document itself does not need to be active to run this method."
msgstr ""
-#. CPc2g
+#. FAjhF
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id301589205147697\n"
"help.text"
-msgid "<emph>FileName</emph> : A string containing the file name to be used. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: A string containing the file name to be used. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. GEybm
+#. zr6Rx
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id851589205147348\n"
"help.text"
-msgid "<emph>Overwrite</emph> : If <literal>True</literal>, the destination file may be overwritten (default = <literal>False</literal>)."
+msgid "<emph>overwrite</emph>: If <literal>True</literal>, the destination file may be overwritten (default = <literal>False</literal>)."
msgstr ""
-#. PPc3f
+#. k2uRD
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id821589205147330\n"
"help.text"
-msgid "<emph>Password</emph> (*) : A non-space string to protect the document."
+msgid "<emph>password</emph> (*): A non-space string to protect the document."
msgstr ""
-#. RKCha
+#. eyrsV
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id67158920514729\n"
"help.text"
-msgid "<emph>FilterName</emph> (*) : The name of a filter that should be used for saving the document. If this argument is passed, then the filter must exist."
+msgid "<emph>filtername</emph> (*): The name of a filter that should be used for saving the document. If this argument is passed, then the filter must exist."
msgstr ""
-#. hXUjB
+#. vA4NU
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id881589205147911\n"
"help.text"
-msgid "<emph>FilterOptions</emph> (*) : An optional string of options associated with the filter."
+msgid "<emph>filteroptions</emph> (*): An optional string of options associated with the filter."
msgstr ""
#. WCH7E
@@ -8782,67 +10600,76 @@ msgctxt ""
msgid "<variable id=\"ExceptionService\"><link href=\"text/sbasic/shared/03/sf_exception.xhp\" name=\"Exception service\"><literal>ScriptForge</literal>.<literal>Exception</literal> service</link></variable>"
msgstr ""
-#. m5HoF
+#. 4X7Xk
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id181587139648008\n"
"help.text"
-msgid "The <literal>Exception</literal> service is a collection of methods for Basic code debugging and error handling."
+msgid "The <literal>Exception</literal> service is a collection of methods to assist in code debugging in Basic and Python scripts and in error handling in Basic scripts."
msgstr ""
-#. KiitV
+#. XeYa4
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id141587140927573\n"
"help.text"
-msgid "In the advent of a run-time error, the <literal>Exception</literal> service properties and methods help identify the error context and permit to handle it."
+msgid "In <emph>Basic scripts</emph>, when a run-time error occurs, the methods and properties of the <literal>Exception</literal> service help identify the error context and allow to handle it."
msgstr ""
-#. Kn3iF
+#. ENY3v
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id461587140965192\n"
+"par_id401621450898070\n"
"help.text"
msgid "The <literal>SF_Exception</literal> service is similar to the <link href=\"text/sbasic/shared/ErrVBA.xhp\" name=\"VBA Err object\">VBA <literal>Err</literal> object</link>."
msgstr ""
-#. 6rquM
+#. vpB42
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id61587141015326\n"
+"par_id361621450908874\n"
"help.text"
msgid "The <literal>Number</literal> property identifies the error."
msgstr ""
-#. 9Gh4S
+#. TnWpD
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id251608212974671\n"
+"par_id861621450910254\n"
"help.text"
-msgid "Use <literal>Raise()</literal> method to interrupt processing, use <literal>RaiseWarning()</literal> method to trap an anomaly and continue processing."
+msgid "Use the <literal>Raise</literal> method to interrupt processing. The <literal>RaiseWarning</literal> method can be used to trap an anomaly without interrupting the macro execution."
msgstr ""
-#. PddYS
+#. CpxKC
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id621587225732733\n"
"help.text"
-msgid "Errors or warnings raised with the <literal>Exception</literal> service are stored in memory and can be retrieved using its <literal>Console()</literal> method."
+msgid "Errors and warnings raised with the <literal>Exception</literal> service are stored in memory and can be retrieved using the <literal>Console</literal> method."
msgstr ""
-#. i8z6N
+#. CpBSQ
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id411587141146677\n"
"help.text"
-msgid "The <literal>Exception</literal> service console stores events, variable values and information about errors. Use the console when Basic IDE is not accessible, for example in <link href=\"text/scalc/guide/userdefined_function.xhp\" name=\"Calc user-defined function\">Calc user defined functions (UDF)</link> or during events processing. Use <literal>DebugPrint()</literal> method to aggregate additional user data. Console entries can be dumped to a text file or visualized in a dialogue."
+msgid "The <literal>Exception</literal> service console stores events, variable values and information about errors. Use the console when the Basic IDE is not easily accessible, for example in <link href=\"text/scalc/guide/userdefined_function.xhp\" name=\"Calc user-defined function\">Calc user defined functions (UDF)</link> or during events processing."
+msgstr ""
+
+#. NrY9C
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id251621034725811\n"
+"help.text"
+msgid "Use the <literal>DebugPrint</literal> method to add any relevant information to the console. Console entries can be dumped to a text file or visualized in a dialog window."
msgstr ""
#. 9AW2i
@@ -8863,13 +10690,13 @@ msgctxt ""
msgid "Report the error in the <literal>Exception</literal> console"
msgstr ""
-#. SGmPy
+#. N9X2f
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id751587141235313\n"
"help.text"
-msgid "Inform the user about the error using either a standard message either a customized message"
+msgid "Inform the user about the error using either a standard message or a custom message"
msgstr ""
#. C3NMD
@@ -8881,22 +10708,31 @@ msgctxt ""
msgid "Optionally stop its execution"
msgstr ""
-#. yQzKr
+#. vFJRL
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"hd_id201586594659135\n"
+"par_id771621035263403\n"
"help.text"
-msgid "Service invocation"
+msgid "In <emph>Python scripts</emph> the <literal>Exception</literal> service is mostly used for debugging purposes. Methods such as <literal>DebugPrint</literal>, <literal>Console</literal> and <literal>DebugDisplay</literal> are useful to quickly print messages, log data and open the console window from within a Python script."
+msgstr ""
+
+#. VAaLU
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id211621035276160\n"
+"help.text"
+msgid "Not all methods and properties are available for Python scripts since the Python language already has a comprehensive exception handling system."
msgstr ""
-#. 5YFk5
+#. yQzKr
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id571586594672714\n"
+"hd_id201586594659135\n"
"help.text"
-msgid "To invoke the <literal>Exception</literal> service, first you need to load the <literal>ScriptForge</literal> library using:"
+msgid "Service invocation"
msgstr ""
#. T8o7G
@@ -8908,6 +10744,15 @@ msgctxt ""
msgid "The following examples show three different approaches to call the method <literal>Raise</literal>. All other methods can be executed in a similar fashion."
msgstr ""
+#. tGmaZ
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id901621036227048\n"
+"help.text"
+msgid "The code snippet below creates an instance of the <literal>Exception</literal> service, logs a message and displays the <literal>Console</literal> window."
+msgstr ""
+
#. HABsh
#: sf_exception.xhp
msgctxt ""
@@ -8917,6 +10762,15 @@ msgctxt ""
msgid "Properties"
msgstr ""
+#. JDNi6
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id911621036526404\n"
+"help.text"
+msgid "The properties listed below are only available for <emph>Basic</emph> scripts."
+msgstr ""
+
#. s3E9G
#: sf_exception.xhp
msgctxt ""
@@ -8926,13 +10780,13 @@ msgctxt ""
msgid "Name"
msgstr ""
-#. qEhnn
+#. b96rE
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id241584978211550\n"
"help.text"
-msgid "ReadOnly"
+msgid "Readonly"
msgstr ""
#. TkMLa
@@ -9106,13 +10960,13 @@ msgctxt ""
msgid "A modal console can only be closed by the user. A non-modal console can either be closed by the user or upon macro termination."
msgstr ""
-#. 2DWxi
+#. HUgnb
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id511598718179819\n"
"help.text"
-msgid "<emph>Modal</emph>: Determine if the console window is Modal (<literal>True</literal>) or Non-modal (<literal>False</literal>). Default value is <literal>True</literal>."
+msgid "<emph>modal</emph>: Determine if the console window is modal (<literal>True</literal>) or non-modal (<literal>False</literal>). Default value is <literal>True</literal>."
msgstr ""
#. xu6FA
@@ -9124,13 +10978,13 @@ msgctxt ""
msgid "Clears the console keeping an optional number of recent messages. If the console is activated in non-modal mode, it is refreshed."
msgstr ""
-#. jbkCo
+#. SE7ei
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id351587215098527\n"
"help.text"
-msgid "<emph>Keep</emph>: The number of recent messages to be kept. Default value is 0."
+msgid "<emph>keep</emph>: The number of recent messages to be kept. Default value is 0."
msgstr ""
#. GLEVv
@@ -9151,13 +11005,40 @@ msgctxt ""
msgid "Exports the contents of the console to a text file. If the file already exists and the console is not empty, it will be overwritten without warning. Returns <literal>True</literal> if successful."
msgstr ""
-#. QMb9C
+#. HEXvU
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id851587218077862\n"
"help.text"
-msgid "<emph>FileName</emph>: The name of the text file the console should be dumped into. The name is expressed according to the current <literal>FileNaming</literal> property of the <literal>SF_FileSystem</literal> service. <link href=\"text/sbasic/shared/00000002.xhp\" name=\"Url notation\">URL notation</link> and the native operating system's format are both admitted."
+msgid "<emph>filename</emph>: The name of the text file the console should be dumped into. The name is expressed according to the current <literal>FileNaming</literal> property of the <literal>SF_FileSystem</literal> service. By default, <link href=\"text/sbasic/shared/00000002.xhp\" name=\"Url notation\">URL notation</link> and the native operating system's format are both admitted."
+msgstr ""
+
+#. F3tVM
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id701621043185177\n"
+"help.text"
+msgid "Concatenates all the arguments into a single human-readable string and displays it in a <literal>MsgBox</literal> with an Information icon and an OK button."
+msgstr ""
+
+#. KaGM6
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id791621097689492\n"
+"help.text"
+msgid "The final string is also added to the Console."
+msgstr ""
+
+#. QhRgF
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id481587218636884\n"
+"help.text"
+msgid "<emph>arg0[, arg1, ...]</emph>: Any number of arguments of any type."
msgstr ""
#. 2qser
@@ -9169,13 +11050,67 @@ msgctxt ""
msgid "Assembles all the given arguments into a single human-readable string and adds it as a new entry in the console."
msgstr ""
-#. BmmDA
+#. mUSEP
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id481587218637988\n"
"help.text"
-msgid "<emph>Arg0[, Arg1, ...]</emph>: Any number of arguments of any type."
+msgid "<emph>arg0[, arg1, ...]</emph>: Any number of arguments of any type."
+msgstr ""
+
+#. CUoch
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id111621426672183\n"
+"help.text"
+msgid "Opens an APSO Python shell as a non-modal window. The Python script keeps running after the shell is opened. The output from <literal>print</literal> statements inside the script are shown in the shell."
+msgstr ""
+
+#. f9ZzM
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id841621426922467\n"
+"help.text"
+msgid "Only a single instance of the APSO Python shell can be opened at any time. Hence, if a Python shell is already open, then calling this method will have no effect."
+msgstr ""
+
+#. KGi8B
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id391621449167833\n"
+"help.text"
+msgid "<emph>variables</emph>: a Python dictionary with variable names and values that will be passed on to the APSO Python shell. By default all local variables are passed using Python's builtin <literal>locals()</literal> function."
+msgstr ""
+
+#. zT7Gq
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id991621449657850\n"
+"help.text"
+msgid "The example below opens the APSO Python shell passing all global and local variables considering the context where the script is running."
+msgstr ""
+
+#. yUoFK
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id521621449800348\n"
+"help.text"
+msgid "When the APSO Python shell is open, any subsequent output printed by the script will be shown in the shell. Hence, the string printed in the example below will be displayed in the Python shell."
+msgstr ""
+
+#. 5xNCX
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"pyc_id731621449899901\n"
+"help.text"
+msgid "print(\"Hello world!\")"
msgstr ""
#. aXDEK
@@ -9241,13 +11176,13 @@ msgctxt ""
msgid "To raise an exception with the standard values:"
msgstr ""
-#. ZneYd
+#. SABN3
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id751587222598238\n"
"help.text"
-msgid "To raise an exception with an specific code:"
+msgid "To raise an exception with a specific code:"
msgstr ""
#. QXgCy
@@ -10942,6 +12877,3516 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03020103.xhp\" name=\"Open statement\">Open Statement</link>"
msgstr ""
+#. XQG8t
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDocuments.Form service"
+msgstr ""
+
+#. kanuY
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"FormService\"><link href=\"text/sbasic/shared/03/sf_form.xhp\" name=\"SFDocuments.Form\"><literal>SFDocuments</literal>.<literal>Form</literal> service</link></variable>"
+msgstr ""
+
+#. LDpRB
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id931583589764919\n"
+"help.text"
+msgid "The <literal>Form</literal> service provides methods and properties to manage forms in %PRODUCTNAME documents. This service supports forms in Base, Calc and Writer documents and allows to:"
+msgstr ""
+
+#. U3zGB
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id381618172063851\n"
+"help.text"
+msgid "Open and activate forms."
+msgstr ""
+
+#. SC6Yb
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id261618172129782\n"
+"help.text"
+msgid "Navigate through records shown by the form."
+msgstr ""
+
+#. krQfB
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id281618172141607\n"
+"help.text"
+msgid "Get access to the controls inside the form."
+msgstr ""
+
+#. itKdZ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id371618172155483\n"
+"help.text"
+msgid "Get access to subforms of a parent form."
+msgstr ""
+
+#. QcJ24
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id351616768789190\n"
+"help.text"
+msgid "The <literal>SFDocuments</literal>.<literal>Form</literal> service is available from %PRODUCTNAME 7.2 onwards."
+msgstr ""
+
+#. Ga5NU
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id451616765867881\n"
+"help.text"
+msgid "Forms are usually used in %PRODUCTNAME documents to create user interfaces connected to relational databases. Hence, the <literal>Form</literal> service provides quick access to the linked database through the <link href=\"text/sbasic/shared/03/sf_database.xhp\" name=\"SFDatabases.Database\"><literal>SFDatabases</literal>.<literal>Database</literal> service</link>."
+msgstr ""
+
+#. rGB5M
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id891598188164936\n"
+"help.text"
+msgid "The <literal>SFDocuments</literal>.<literal>Form</literal> service is closely related to the <link href=\"text/sbasic/shared/03/sf_formcontrol.xhp\" name=\"SFDocuments.FormControl\"><literal>SFDocuments</literal>.<literal>FormControl</literal> service.</link>"
+msgstr ""
+
+#. 3HUmh
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id161616766330804\n"
+"help.text"
+msgid "Definitions"
+msgstr ""
+
+#. GYDbT
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id951618172906010\n"
+"help.text"
+msgid "Forms are usually created in Base documents, but they can be added to Writer and Calc documents as well."
+msgstr ""
+
+#. nKUdb
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id671618173380680\n"
+"help.text"
+msgid "In Base, each form you create using the <menuitem>Insert - Form</menuitem> functionality or through the <link href=\"text/shared/autopi/01090000.xhp\" name=\"FormWizard\">Form Wizard</link> is actually a <literal>FormDocument</literal> that can be handled with the <literal>Form</literal> service. Base documents can contain an unlimited number of form documents."
+msgstr ""
+
+#. kegBD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id841618177362626\n"
+"help.text"
+msgid "Below is an example showing the hierarchy of all the elements involved in accessing forms and subforms in a Base document. Suppose you have a Base file named <literal>Employees.odb</literal> and inside it you created a form document to add new employees to the database. The form document contains a main form named <literal>EmployeeData</literal> that gives access to a table. There is also a subform <literal>WorksAtPlant</literal> that allows you to associate the new employee to one of the plants of the company."
+msgstr ""
+
+#. izkiB
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id151618176848874\n"
+"help.text"
+msgid "Employees.odb (Base document)"
+msgstr ""
+
+#. cz2fJ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id941618176869485\n"
+"help.text"
+msgid "|-- EmployeeData (Main Form)"
+msgstr ""
+
+#. k8nxK
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id221618173444457\n"
+"help.text"
+msgid "A <literal>FormDocument</literal> can be seen as a set of forms that provide access to datasets such as database tables and queries from within %PRODUCTNAME documents. The names of forms and subforms inside a FormDocument can be accessed using the <link href=\"text/shared/02/01170600.xhp\" name=\"FormNavigator\">Form Navigator</link>."
+msgstr ""
+
+#. AMFVt
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id851616767037521\n"
+"help.text"
+msgid "Forms and Subforms"
+msgstr ""
+
+#. GA63u
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id681616767265034\n"
+"help.text"
+msgid "A form document is composed of one or more forms which, in turn, may also contain any number of subforms. A Form is an abstract set of controls that are linked to a specified data source, which can be a database table, a query or a SQL <literal>SELECT</literal> statement."
+msgstr ""
+
+#. fDvBD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id711618178831976\n"
+"help.text"
+msgid "In Calc and Writer documents, each form can be linked to datasets located in different databases. On the other hand, in Base documents the database contained in the document is common to all forms."
+msgstr ""
+
+#. wDfhy
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id191616837111507\n"
+"help.text"
+msgid "To invoke the <literal>SFDocuments</literal>.<literal>Form</literal> service refer to the methods <literal>Forms()</literal>, <literal>FormDocuments()</literal> and <literal>OpenFormDocument()</literal> of the <link href=\"text/sbasic/shared/03/sf_document.xhp\" name=\"SFDocuments\"><literal>SFDocuments</literal>.<literal>Document</literal></link> service"
+msgstr ""
+
+#. gs4KC
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. KfjEA
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id991618179698545\n"
+"help.text"
+msgid "In Writer documents"
+msgstr ""
+
+#. 8s4VD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id51616767892693\n"
+"help.text"
+msgid "The code snippet below shows how to access the form named <literal>Form1</literal> that is inside a Writer file:"
+msgstr ""
+
+#. NFikt
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id531618179517628\n"
+"help.text"
+msgid "Forms can be accessed by their names or by their indices, as shown below:"
+msgstr ""
+
+#. cYS6G
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id691622014677169\n"
+"help.text"
+msgid "my_form = doc.Forms(0)"
+msgstr ""
+
+#. 8PHy6
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id181618250546617\n"
+"help.text"
+msgid "If you try to access a <literal>FormDocument</literal> that is currently opened in <emph>Design Mode</emph> an exception will be raised."
+msgstr ""
+
+#. xNr3R
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id921618179792926\n"
+"help.text"
+msgid "In Calc documents"
+msgstr ""
+
+#. yCpnG
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id481618179851104\n"
+"help.text"
+msgid "A form in a Calc file must have a unique name inside its sheet. Hence, the <literal>Forms</literal> method requires two arguments, the first indicating the sheet name and the second specifying the form name."
+msgstr ""
+
+#. i9Um4
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id51622028165429\n"
+"help.text"
+msgid "This is achieved identically using Python:"
+msgstr ""
+
+#. 2fB94
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id201618180055756\n"
+"help.text"
+msgid "In Base documents"
+msgstr ""
+
+#. J3Btp
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id711616768164987\n"
+"help.text"
+msgid "A <literal>FormDocument</literal> inside a Base document is accessed by its name. The following example opens the form document named <literal>thisFormDocument</literal> and accesses the form <literal>MainForm</literal>:"
+msgstr ""
+
+#. pbtEM
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id271598171225874\n"
+"help.text"
+msgid "' The statement below is necessary only if the form hasn't been opened yet"
+msgstr ""
+
+#. EDADK
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id51616768358888\n"
+"help.text"
+msgid "' Or, alternatively, to access the form by its index ..."
+msgstr ""
+
+#. 2v2aG
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id991618249636036\n"
+"help.text"
+msgid "To perform any action on a form using the <literal>Form</literal> service, the <literal>FormDocument</literal> must have been opened either manually by the user or programmatically in a user script. The latter can be done by calling the <literal>OpenFormDocument</literal> method of the <link href=\"text/sbasic/shared/03/sf_base.xhp\" name=\"ScriptForge Base Service\"><literal>Base</literal> service</link>."
+msgstr ""
+
+#. DDerZ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id11618180564274\n"
+"help.text"
+msgid "To access a given subform of a form use the <literal>SubForms</literal> method. Note that in the example below <literal>mySubForm</literal> is a new instance of the <literal>Form</literal> service."
+msgstr ""
+
+#. e7fcY
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id681622028653480\n"
+"help.text"
+msgid "Previous examples translate in Python as:"
+msgstr ""
+
+#. Af2SY
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id501622028742999\n"
+"help.text"
+msgid "db = CreateScriptService('SFDocuments.Document', XSCRIPTCONTEXT.getDocument())"
+msgstr ""
+
+#. ebc4K
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id811622808499801\n"
+"help.text"
+msgid "# The statement below is necessary only if the form hasn't been opened yet"
+msgstr ""
+
+#. j3BCx
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id671622028743191\n"
+"help.text"
+msgid "form_doc = db.OpenFormDocument('thisFormDocument')"
+msgstr ""
+
+#. mSnqt
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id431622028743374\n"
+"help.text"
+msgid "form = form_doc.Forms('thisFormDocument', 'MainForm')"
+msgstr ""
+
+#. GdyX6
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id511622808538351\n"
+"help.text"
+msgid "# Or, alternatively, to access the form by its index ..."
+msgstr ""
+
+#. Bb4K4
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id681622028743582\n"
+"help.text"
+msgid "form = form_doc.Forms('thisFormDocument', 0)"
+msgstr ""
+
+#. FTwWJ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id611622028743782\n"
+"help.text"
+msgid "sub_form = form.SubForms('mySubForm')"
+msgstr ""
+
+#. QFFzk
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id211618180379064\n"
+"help.text"
+msgid "In Form events"
+msgstr ""
+
+#. WBzCD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id421616768529754\n"
+"help.text"
+msgid "To invoke the <literal>Form</literal> service when a form event takes place:"
+msgstr ""
+
+#. k2fKf
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id721623150543016\n"
+"help.text"
+msgid "It is recommended to free resources after use of the Form service."
+msgstr ""
+
+#. pF9UQ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id221623150547406\n"
+"help.text"
+msgid "This operation is done implicitly when a form document is closed with the <literal>CloseFormDocument()</literal> method described below."
+msgstr ""
+
+#. GueeT
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id651583668365757\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. 9LaxS
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id871583668386455\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. SpGw6
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id491583668386455\n"
+"help.text"
+msgid "Readonly"
+msgstr ""
+
+#. K7Bsy
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id271583668474014\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. ekeZU
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id401583668386455\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. wSC47
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id371583668519172\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. jJ2dL
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id771583668386455\n"
+"help.text"
+msgid "Specifies if the form allows to delete records."
+msgstr ""
+
+#. DBxgx
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id541583839708548\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. j5J3C
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id731583839708412\n"
+"help.text"
+msgid "Specifies if the form allows to add records."
+msgstr ""
+
+#. FCFEk
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id761584027709516\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 8qCAE
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id971584027709752\n"
+"help.text"
+msgid "Specifies if the form allows to update records."
+msgstr ""
+
+#. VxAL4
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id31583839767743\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. CRA7v
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id111583839767195\n"
+"help.text"
+msgid "Specifies the hierarchical name of the Base Form containing the actual form."
+msgstr ""
+
+#. FehA2
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id771583839920487\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. V8tZX
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id451583839920858\n"
+"help.text"
+msgid "Specifies uniquely the current record of the form's underlying table, query or SQL statement."
+msgstr ""
+
+#. 3jDxi
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id571588333908716\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 7NUo8
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id721588333908708\n"
+"help.text"
+msgid "Identifies the current record in the dataset being viewed on a form. If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. Row count starts at 1. If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. Row -1 refers to the last row in the result set."
+msgstr ""
+
+#. FKDA7
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id501583774433513\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. eAsdX
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id151598177605296\n"
+"help.text"
+msgid "Specifies a subset of records to be displayed as a <literal>SQL</literal> <literal>WHERE</literal>-clause without the <literal>WHERE</literal> keyword."
+msgstr ""
+
+#. uyje5
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id271588334016191\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. FQDDW
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id251588334016874\n"
+"help.text"
+msgid "Specifies how records in a child subform are linked to records in its parent form."
+msgstr ""
+
+#. DMwPW
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id901616774153495\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 2EiCA
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id981616774153723\n"
+"help.text"
+msgid "Specifies how records in a child subform are linked to records in its parent form."
+msgstr ""
+
+#. ppCiD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id501616774304840\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. kPfzG
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id461616774304497\n"
+"help.text"
+msgid "The name of the current form."
+msgstr ""
+
+#. vpBCA
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id751616774384451\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. ppErx
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id321616774384489\n"
+"help.text"
+msgid "Specifies in which order the records should be displayed as a <literal>SQL</literal> <literal>ORDER BY</literal> clause without the <literal>ORDER BY</literal> keywords."
+msgstr ""
+
+#. AGC5s
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id261616774918923\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. rjCpM
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id171616774918881\n"
+"help.text"
+msgid "The parent of the current form. It can be either a <literal>SFDocuments</literal>.<literal>Form</literal> or a <literal>SFDocuments</literal>.<literal>Document</literal> object."
+msgstr ""
+
+#. rLS8r
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id501616777650751\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. USDVC
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id91616777650933\n"
+"help.text"
+msgid "Specifies the source of the data, as a table name, a query name or a SQL statement."
+msgstr ""
+
+#. rtCsj
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id451598177924437\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. GxHLP
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id94159817792441\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. VYFDs
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id191598177924897\n"
+"help.text"
+msgid "The UNO object representing interactions with the form. Refer to <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1form_1_1XForm.html\" name=\"XForm interface\">XForm</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1form_1_1component_1_1DataForm.html\" name=\"DataForm service\">DataForm</link> in the API documentation for detailed information."
+msgstr ""
+
+#. cwE3k
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"hd_id421612628828054\n"
+"help.text"
+msgid "Event properties"
+msgstr ""
+
+#. eTuoa
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id41612629140856\n"
+"help.text"
+msgid "The properties below return or set URI strings that define the script triggered by the event."
+msgstr ""
+
+#. fdses
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id961612628879819\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. DsQGQ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id401612628879819\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. 5FemG
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id281612628879819\n"
+"help.text"
+msgid "Basic IDE Description"
+msgstr ""
+
+#. PgdP8
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id111612629836630\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. GAgms
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id1001612629836902\n"
+"help.text"
+msgid "Before record change"
+msgstr ""
+
+#. Mr9ns
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id291612629836294\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. DwhZn
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id62161262983683\n"
+"help.text"
+msgid "Fill parameters"
+msgstr ""
+
+#. DrMbU
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id81612629836634\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. eAJAN
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id881612629836744\n"
+"help.text"
+msgid "Prior to reset"
+msgstr ""
+
+#. Y9d6z
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id591612629836830\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. LKxEu
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id161612629836775\n"
+"help.text"
+msgid "Before record action"
+msgstr ""
+
+#. Zyx2S
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id891612629836630\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 2HBeC
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id461612629836679\n"
+"help.text"
+msgid "Before submitting"
+msgstr ""
+
+#. 2fJrZ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id131612629836291\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. BX4AH
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id151612629836151\n"
+"help.text"
+msgid "Confirm deletion"
+msgstr ""
+
+#. W9izF
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id211612629836725\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. pDvPB
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id361612629836624\n"
+"help.text"
+msgid "After record change"
+msgstr ""
+
+#. WprGG
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id311612629836481\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. Xn2CS
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id721612629836752\n"
+"help.text"
+msgid "Error occurred"
+msgstr ""
+
+#. B3zCy
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id981612629836116\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. L3Ac6
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id381612629836635\n"
+"help.text"
+msgid "When loading"
+msgstr ""
+
+#. 9Z9vv
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id711612629836704\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. XL4Js
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id35161262983642\n"
+"help.text"
+msgid "When reloading"
+msgstr ""
+
+#. P6DEi
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id44161677878329\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. ywCsh
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id661616778783899\n"
+"help.text"
+msgid "Before reloading"
+msgstr ""
+
+#. eGnRj
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id651616778529764\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. E6JUH
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id311616778529570\n"
+"help.text"
+msgid "After resetting"
+msgstr ""
+
+#. VDAk5
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id601616778529481\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 99FfH
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id351616778529352\n"
+"help.text"
+msgid "After record action"
+msgstr ""
+
+#. CxndA
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id711616778529292\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. DTDCq
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id981616778529250\n"
+"help.text"
+msgid "When unloading"
+msgstr ""
+
+#. iWroa
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id521616778529932\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. pVPR9
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id511616778529291\n"
+"help.text"
+msgid "Before unloading"
+msgstr ""
+
+#. cTdFS
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id961618181634322\n"
+"help.text"
+msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
+msgstr ""
+
+#. bkBH8
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id921606472825856\n"
+"help.text"
+msgid "List of methods in the Form service"
+msgstr ""
+
+#. KwDij
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id871583933076448\n"
+"help.text"
+msgid "Sets the focus on the current <literal>Form</literal> instance. Returns <literal>True</literal> if focusing was successful."
+msgstr ""
+
+#. 9qj5F
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id81616858956290\n"
+"help.text"
+msgid "The behavior of the <literal>Activate</literal> method depends on the type of document where the form is located:"
+msgstr ""
+
+#. YVgyr
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id761616858967361\n"
+"help.text"
+msgid "<emph>In Writer documents:</emph> Sets the focus on that document."
+msgstr ""
+
+#. HKFTw
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id931616859010103\n"
+"help.text"
+msgid "<emph>In Calc documents:</emph> Sets the focus on the sheet to which the form belongs."
+msgstr ""
+
+#. 6jx5G
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id41616859019478\n"
+"help.text"
+msgid "<emph>In Base documents:</emph> Sets the focus on the <literal>FormDocument</literal> the <literal>Form</literal> refers to."
+msgstr ""
+
+#. J5C7y
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id921618228229529\n"
+"help.text"
+msgid "The following example assumes you want to activate the form named <literal>FormA</literal> located in <literal>Sheet1</literal> of the currently open Calc file. It first gets access to the document using the <literal>Document</literal> service and <literal>ThisComponent</literal> and then activates the form."
+msgstr ""
+
+#. 4EC5M
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id21618228468066\n"
+"help.text"
+msgid "'Gets hold of the form that will be activated"
+msgstr ""
+
+#. M2Wks
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"bas_id201618228487565\n"
+"help.text"
+msgid "'Activates the form"
+msgstr ""
+
+#. YHxMm
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id81618228720782\n"
+"help.text"
+msgid "<literal>ThisComponent</literal> applies to Calc and Writer documents. For Base documents use <literal>ThisDataBaseDocument</literal>."
+msgstr ""
+
+#. QznyJ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id501616860541195\n"
+"help.text"
+msgid "Closes the form document containing the actual <literal>Form</literal> instance. The <literal>Form</literal> instance is disposed."
+msgstr ""
+
+#. CcCpD
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id611618229004669\n"
+"help.text"
+msgid "This method only closes form documents located in Base documents. If the form is stored in a Writer or Calc document, calling <literal>CloseFormDocument</literal> will have no effect."
+msgstr ""
+
+#. a8CxQ
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id161584541257982\n"
+"help.text"
+msgid "The value returned by the <literal>Controls</literal> method depends on the arguments provided:"
+msgstr ""
+
+#. YkyY2
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id421598179770993\n"
+"help.text"
+msgid "If the method is called <emph>without arguments</emph>, then it returns the list of the controls contained in the form. Beware that the returned list does not contain any subform controls."
+msgstr ""
+
+#. SsiUX
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id81598185229301\n"
+"help.text"
+msgid "If the optional <literal>ControlName</literal> argument is provided, the method returns a <literal>FormControl</literal> class instance referring to the specified control."
+msgstr ""
+
+#. 7CFJU
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id1001584541257789\n"
+"help.text"
+msgid "<emph>controlname</emph> : A valid control name as a case-sensitive string. If absent, the list of control names is returned as a zero-based array."
+msgstr ""
+
+#. unh4B
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id291616861407907\n"
+"help.text"
+msgid "Return a <link href=\"text/sbasic/shared/03/sf_database.xhp\" name=\"DBService\"><literal>SFDatabases</literal>.<literal>Database</literal></link> instance giving access to the execution of SQL commands on the database the current form is connected to and/or that is stored in the current Base document."
+msgstr ""
+
+#. fZRst
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id991616861417207\n"
+"help.text"
+msgid "Each form has its own database connection, except in Base documents where they all share the same connection."
+msgstr ""
+
+#. wFSWb
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id701616861134906\n"
+"help.text"
+msgid "<emph>user, password</emph>: The login optional parameters (Default = \"\")."
+msgstr ""
+
+#. 83Jju
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id771616861842867\n"
+"help.text"
+msgid "The form cursor is positioned on the first record. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. rapRE
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id331616863143187\n"
+"help.text"
+msgid "The form cursor is positioned on the last record. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. HZELb
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id361616863143954\n"
+"help.text"
+msgid "The form cursor is positioned on the new record area. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. 2QwcR
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id541616863143461\n"
+"help.text"
+msgid "The form cursor is positioned on the next record. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. a2gGn
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id271616863582607\n"
+"help.text"
+msgid "<emph>offset</emph>: The number of records to go forward (Default = 1)."
+msgstr ""
+
+#. e6huC
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id616168637945\n"
+"help.text"
+msgid "The form cursor is positioned on the previous record. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. tAnVw
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id751616863794125\n"
+"help.text"
+msgid "<emph>offset</emph>: The number of records to go backwards (Default = 1)."
+msgstr ""
+
+#. Kp4Wo
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id811616864216529\n"
+"help.text"
+msgid "Reloads the current data from the database and refreshes the form. The cursor is positioned on the first record. Returns <literal>True</literal> if successful."
+msgstr ""
+
+#. Npc6x
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"pyc_id401622550186725\n"
+"help.text"
+msgid "form.Requery() # Python"
+msgstr ""
+
+#. 5gBGr
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id891616864510614\n"
+"help.text"
+msgid "The value returned by the <literal>Subforms</literal> method depends on the arguments provided:"
+msgstr ""
+
+#. 4yG2j
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id951616864510585\n"
+"help.text"
+msgid "If the method is called <emph>without any arguments</emph>, then it returns the list of subforms contained in the current form or subform instance."
+msgstr ""
+
+#. AD3Q6
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id591616864510445\n"
+"help.text"
+msgid "If the optional <literal>subform</literal> argument is provided, the method returns a new <literal>SFDocuments</literal>.<literal>Form</literal> instance based on the specified form/subform name or index."
+msgstr ""
+
+#. NLwGt
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id341616864510747\n"
+"help.text"
+msgid "<emph>subform</emph> : A subform stored in the current <literal>Form</literal> class instance given by its name or index."
+msgstr ""
+
+#. 8Cxxs
+#: sf_form.xhp
+msgctxt ""
+"sf_form.xhp\n"
+"par_id211618230389251\n"
+"help.text"
+msgid "When this argument is absent, the method returns a list of available subforms as a zero-based array. If the form has a single subform, you can set <literal>Subform = 0</literal> to get access to it."
+msgstr ""
+
+#. CfGgB
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDocuments.FormControl service"
+msgstr ""
+
+#. vND8Z
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"FormControlService\"><link href=\"text/sbasic/shared/03/sf_formcontrol.xhp\" name=\"SFDocuments.FormControl service\"><literal>SFDocuments</literal>.<literal>FormControl</literal> service</link></variable>"
+msgstr ""
+
+#. XFkrG
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id931583589764919\n"
+"help.text"
+msgid "The <literal>FormControl</literal> service provides access to the controls that belong to a form, a subform or a table control of a <literal>FormDocument</literal>. Each instance of the <literal>FormControl</literal> service refers to a single control in the form. This service allows users to:"
+msgstr ""
+
+#. irNFC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id451618771561326\n"
+"help.text"
+msgid "Get and set the properties of the control represented by the <literal>FormControl</literal> instance."
+msgstr ""
+
+#. S5aH9
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id601618771565183\n"
+"help.text"
+msgid "Access the current value displayed by the control."
+msgstr ""
+
+#. P5xzV
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id981618771567951\n"
+"help.text"
+msgid "Set the focus on the desired control."
+msgstr ""
+
+#. LUDRM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id301616939922857\n"
+"help.text"
+msgid "To use the <literal>FormControl</literal> service in a particular form, subform or table control, all controls must have unique names."
+msgstr ""
+
+#. JMFEb
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id541618771629112\n"
+"help.text"
+msgid "Radio buttons that share the same group name must also have unique control names."
+msgstr ""
+
+#. mAwyv
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id51618771641273\n"
+"help.text"
+msgid "The main purpose of the <literal>FormControl</literal> service is setting and getting the properties and values displayed by the controls in a form."
+msgstr ""
+
+#. K2Bgc
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id81618774023346\n"
+"help.text"
+msgid "All controls have a <literal>Value</literal> property. However, its contents will vary according to the control type. For more information, read <link href=\"text/sbasic/shared/03/sf_formcontrol.xhp#hd_id81598540704978\" name=\"Value property\">The <literal>Value</literal> Property</link> below."
+msgstr ""
+
+#. kF29h
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id881618771651907\n"
+"help.text"
+msgid "It is also possible to format the controls via the <literal>XControlModel</literal> and <literal>XControlView</literal> properties."
+msgstr ""
+
+#. WEST9
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891598188164936\n"
+"help.text"
+msgid "The <literal>SFDocuments.FormControl</literal> service is closely related to the <link href=\"text/sbasic/shared/03/sf_form.xhp\" name=\"Form service\"><literal>SFDocuments.Form</literal></link> service."
+msgstr ""
+
+#. rUEuw
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. BeDqF
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id361598174756160\n"
+"help.text"
+msgid "The <literal>FormControl</literal> service is invoked from an existing <literal>Form</literal> service instance through its <literal>Controls</literal> method."
+msgstr ""
+
+#. 56bE7
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"pyc_id721622556808773\n"
+"help.text"
+msgid "control.Value = 'Current Time = ' + strftime(\"%a, %d %b %Y %H:%M:%S\", localtime())"
+msgstr ""
+
+#. FaP92
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id781618772761258\n"
+"help.text"
+msgid "To learn more about how to open a <literal>FormDocument</literal> and get access to its forms, refer to the <link href=\"text/sbasic/shared/03/sf_form.xhp\" name=\"Form service\">SFDocuments.Form</link> service help page."
+msgstr ""
+
+#. qeXCN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id951598174966322\n"
+"help.text"
+msgid "Alternatively a <literal>FormControl</literal> instance can be retrieved via the <literal>SFDocuments.FormEvent</literal> service, which returns the <literal>SFDocuments.FormControl</literal> class instance that triggered the event."
+msgstr ""
+
+#. bSfxy
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"bas_id801598175242937\n"
+"help.text"
+msgid "' oControl now represents the instance of the FormControl class that triggered the current event"
+msgstr ""
+
+#. EgCtB
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id251598176312571\n"
+"help.text"
+msgid "Note that in previous examples, the prefix <literal>\"SFDocuments.\"</literal> may be omitted."
+msgstr ""
+
+#. 7gE8Y
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id951618773412097\n"
+"help.text"
+msgid "The <literal>FormEvent</literal> service is used exclusively to create instances of the <literal>SFDocuments.Form</literal> and <literal>SFDocuments.FormControl</literal> services when a form or control event takes place."
+msgstr ""
+
+#. AppFj
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id71598455687512\n"
+"help.text"
+msgid "Control types"
+msgstr ""
+
+#. ezcW8
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id851598455863395\n"
+"help.text"
+msgid "The <literal>FormControl</literal> service is available for the following control types:"
+msgstr ""
+
+#. BESBv
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id651583668365757\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. VrBfK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id871583668386455\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. hDr9G
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id491583668386455\n"
+"help.text"
+msgid "Readonly"
+msgstr ""
+
+#. kWac7
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id271583668474014\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. dXwGN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id291598538799794\n"
+"help.text"
+msgid "Applicable to"
+msgstr ""
+
+#. bEQWc
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id401583668386455\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. N3ejK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id371583668519172\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. PszFp
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id771583668386455\n"
+"help.text"
+msgid "Specifies the action triggered when the button is clicked. Accepted values are: <literal>none</literal>, <literal>submitForm</literal>, <literal>resetForm</literal>, <literal>refreshForm</literal>, <literal>moveToFirst</literal>, <literal>moveToLast</literal>, <literal>moveToNext</literal>, <literal>moveToPrev</literal>, <literal>saveRecord</literal>, <literal>moveToNew</literal>, <literal>deleteRecord</literal>, <literal>undoRecord</literal>."
+msgstr ""
+
+#. fmzNT
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id541583839708548\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 62Bud
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id731583839708412\n"
+"help.text"
+msgid "Specifies the text displayed by the control."
+msgstr ""
+
+#. nFFDY
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id411616942306677\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 8H6BR
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id461616942306745\n"
+"help.text"
+msgid "Specifies the rowset field mapped onto the current control."
+msgstr ""
+
+#. AJUH6
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id761584027709516\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. Enqxp
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id261598539120502\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. FsCJK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id971584027709752\n"
+"help.text"
+msgid "One of the control types listed above."
+msgstr ""
+
+#. DH84k
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id31583839767743\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. pRrwC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id111583839767195\n"
+"help.text"
+msgid "Specifies whether a command button is the default OK button."
+msgstr ""
+
+#. 2dP2A
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id241616942739459\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. Sukx9
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id271616942739359\n"
+"help.text"
+msgid "Specifies the default value used to initialize a control in a new record."
+msgstr ""
+
+#. nFBUQ
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id771583839920487\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. fQYqd
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891598539196786\n"
+"help.text"
+msgid "All (except HiddenControl)"
+msgstr ""
+
+#. MmDQ5
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id451583839920858\n"
+"help.text"
+msgid "Specifies if the control is accessible with the cursor."
+msgstr ""
+
+#. VDkDh
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id571588333908716\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 8X3Ho
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id721588333908708\n"
+"help.text"
+msgid "Specifies the format used to display dates and times. It must be one of following strings:"
+msgstr ""
+
+#. 6CqCN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891598456980194\n"
+"help.text"
+msgid "For dates: \"Standard (short)\", \"Standard (short YY)\", \"Standard (short YYYY)\", \"Standard (long)\", \"DD/MM/YY\", \"MM/DD/YY\", \"YY/MM/DD\", \"DD/MM/YYYY\", \"MM/DD/YYYY\" , \"YYYY/MM/DD\", \"YY-MM-DD\", \"YYYY-MM-DD\"."
+msgstr ""
+
+#. f6gni
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id221598456991070\n"
+"help.text"
+msgid "For times: \"24h short\", \"24h long\", \"12h short\", \"12h long\"."
+msgstr ""
+
+#. RqjAh
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id501583774433513\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. E4aHX
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id151598177605296\n"
+"help.text"
+msgid "Returns the number of rows in a ListBox or a ComboBox."
+msgstr ""
+
+#. ApC5v
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id271588334016191\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. XQ3AV
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id251588334016874\n"
+"help.text"
+msgid "Specifies which item is selected in a ListBox or ComboBox. In case of multiple selection, the index of the first item is returned or only one item is set."
+msgstr ""
+
+#. 5DjjX
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891616944120697\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. nNqW5
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id901616944120614\n"
+"help.text"
+msgid "Specifies the data contained in a ComboBox or a ListBox as a zero-based array of string values."
+msgstr ""
+
+#. rvVZ7
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id21616944586559\n"
+"help.text"
+msgid "Combined with <literal>ListSourceType</literal>, may also contain the name of a table, a query or a complete <literal>SQL</literal> statement."
+msgstr ""
+
+#. jqgF5
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id821616944631740\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. sqr2g
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id131616944631625\n"
+"help.text"
+msgid "Specifies the type of data contained in a combobox or a listbox."
+msgstr ""
+
+#. Fdm4C
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id881616944631341\n"
+"help.text"
+msgid "It must be one of the <link href=\"https://api.libreoffice.org/docs/idl/ref/ListSourceType_8idl_source.html\" name=\"ListSourceType\"><literal>com.sun.star.form.ListSourceType.*</literal></link> constants."
+msgstr ""
+
+#. BQ7JE
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id961598457655506\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. EV4jD
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id2159845765568\n"
+"help.text"
+msgid "Specifies if the control is read-only."
+msgstr ""
+
+#. CXDED
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id621598457951781\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. e7HnA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id821598457951782\n"
+"help.text"
+msgid "Specifies whether the user can select multiple items in a listbox."
+msgstr ""
+
+#. TZuvX
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id351598458170114\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. AtLKa
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id151598539764402\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. EuBGK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id621598458170392\n"
+"help.text"
+msgid "The name of the control."
+msgstr ""
+
+#. SNTgh
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id161598458580581\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. CTjAM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id181598539807426\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. z8w8o
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id801598458580456\n"
+"help.text"
+msgid "Depending on the parent type, a form, a subform or a tablecontrol, returns the parent <literal>SFDocuments</literal>.<literal>Form</literal> or <literal>SFDocuments</literal>.<literal>FormControl</literal> class object instance."
+msgstr ""
+
+#. fyoXF
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id971598458773352\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. RnXeR
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id451598458773588\n"
+"help.text"
+msgid "Specifies the file name containing a bitmap or other type of graphic to be displayed on the control. The filename must comply with the <literal>FileNaming</literal> attribute of the <literal>ScriptForge.FileSystem</literal> service."
+msgstr ""
+
+#. PHBtj
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id251616946015886\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. oYA7V
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id91616946015258\n"
+"help.text"
+msgid "A control is said required when the underlying data must not contain a <literal>null</literal> value."
+msgstr ""
+
+#. NbTpX
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id781598516764550\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. Rv448
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id11159851676440\n"
+"help.text"
+msgid "Gives access to the text being displayed by the control."
+msgstr ""
+
+#. 7kxit
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id411598517275112\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. MNqBi
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id171598539985022\n"
+"help.text"
+msgid "All (except HiddenControl)"
+msgstr ""
+
+#. VXR9Y
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id651598517275384\n"
+"help.text"
+msgid "Specifies the text that appears as a tooltip when you hover the mouse pointer over the control."
+msgstr ""
+
+#. Awzep
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id821598517418463\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 6S5EL
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id141598517418822\n"
+"help.text"
+msgid "Specifies if the checkbox control may appear dimmed (grayed) or not."
+msgstr ""
+
+#. mCQFz
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id701598517671373\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. mHxWu
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id1001598540024225\n"
+"help.text"
+msgid "This property depends on the current control type. Refer to <link href=\"text/sbasic/shared/03/sf_formcontrol.xhp#hd_id81598540704978\" name=\"Value property\">The <literal>Value</literal> property</link> for more information."
+msgstr ""
+
+#. ybVim
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id661598517730941\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. G52FE
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id761598540042290\n"
+"help.text"
+msgid "All (except HiddenControl)"
+msgstr ""
+
+#. 5juZG
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id881598517730836\n"
+"help.text"
+msgid "Specifies if the control is hidden or visible."
+msgstr ""
+
+#. FAYCA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id451598177924437\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. UZ7ug
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id94159817792441\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. 65CSA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id311598540066789\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. 25EFH
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id191598177924897\n"
+"help.text"
+msgid "The UNO object representing the control model. Refer to <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XControlModel.html\" name=\"awt.XControlModel\">XControlModel</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1awt_1_1UnoControlModel.html\" name=\"awt.UnoControlModel\">UnoControlModel</link> in the API documentation for more information."
+msgstr ""
+
+#. FzDR6
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id811598178083501\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. Bdvyd
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id981598178083938\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. DFQ5P
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id551598540079329\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. XahSM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id731598178083442\n"
+"help.text"
+msgid "The UNO object representing the control view. Refer to <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XControl.html\" name=\"awt.XControl\">XControl</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1awt_1_1UnoControl.html\" name=\"awt.UnoControl\">UnoControl</link> in the API documentation for more information."
+msgstr ""
+
+#. pqsod
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id81598540704978\n"
+"help.text"
+msgid "The <variable id=\"ValueProperty\"><literal>Value</literal> property</variable>"
+msgstr ""
+
+#. PbEBw
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id10159854325492\n"
+"help.text"
+msgid "Control type"
+msgstr ""
+
+#. bsmCC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id741598543254158\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. MWgHB
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id961598543254444\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. FLUGH
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id741598543254108\n"
+"help.text"
+msgid "Applicable to toggle buttons only."
+msgstr ""
+
+#. jpLCR
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id741598543254376\n"
+"help.text"
+msgid "Boolean or Integer"
+msgstr ""
+
+#. ErAZY
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id521598543254630\n"
+"help.text"
+msgid "0, False: not checked<br/>1, True: checked<br/>2: grayed out, don't know (applicable if <literal>TripleState</literal> is <literal>True</literal>)"
+msgstr ""
+
+#. 3frrW
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id331598543254947\n"
+"help.text"
+msgid "The selected value, as a String. The <literal>ListIndex</literal> property is an alternate option to access the index of the selected value."
+msgstr ""
+
+#. faEEm
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id5159854325443\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. VyagB
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id971598543254757\n"
+"help.text"
+msgid "A file name formatted in accordance with the <literal>FileNaming</literal> property of the <literal>ScriptForge.FileSystem</literal> service"
+msgstr ""
+
+#. CaGtr
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id221598543254760\n"
+"help.text"
+msgid "String or Numeric"
+msgstr ""
+
+#. gtxJY
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id42159854325422\n"
+"help.text"
+msgid "String or array of strings"
+msgstr ""
+
+#. kBH32
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id601598543254780\n"
+"help.text"
+msgid "The selected row(s) as a single string or an array of strings. Only a single value can be set. If the box is linked to a database, this property gets or sets the underlying data. Otherwise it gets or sets the data being displayed."
+msgstr ""
+
+#. f7EZX
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id461598543254909\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. DrhU9
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id851598543254624\n"
+"help.text"
+msgid "Each button has its own name. Multiple RadioButton controls are linked together when they share the same group name. If a RadioButton is set to <literal>True</literal>, the other related buttons are automatically set to <literal>False</literal>"
+msgstr ""
+
+#. WEsqT
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id531598543254869\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. LxeLY
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id21598543254994\n"
+"help.text"
+msgid "Must be within the predefined bounds"
+msgstr ""
+
+#. mpoa7
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id951616947400919\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. x6ZLt
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id48161694740085\n"
+"help.text"
+msgid "Must be within the predefined bounds"
+msgstr ""
+
+#. UZLYC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id441598543254738\n"
+"help.text"
+msgid "The text appearing in the field"
+msgstr ""
+
+#. WBHoJ
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id421612628828054\n"
+"help.text"
+msgid "Event properties"
+msgstr ""
+
+#. tqnsA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id41612629140856\n"
+"help.text"
+msgid "The properties below return or set URI strings that define the script triggered by the event."
+msgstr ""
+
+#. 7Azyz
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id961612628879819\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. N4btE
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id401612628879819\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. RXoDM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id281612628879819\n"
+"help.text"
+msgid "Description as labeled in the Basic IDE"
+msgstr ""
+
+#. yhjPA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id91612707166532\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. HVTKN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id291612707166258\n"
+"help.text"
+msgid "Execute action"
+msgstr ""
+
+#. T5CTw
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id79161270716675\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. qs3LA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id831612707166731\n"
+"help.text"
+msgid "While adjusting"
+msgstr ""
+
+#. vUbN6
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id301616948330694\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. PopWN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id901616948330305\n"
+"help.text"
+msgid "Approve action"
+msgstr ""
+
+#. PmE7k
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id821616948330888\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. rjQCJ
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id111616948330257\n"
+"help.text"
+msgid "Prior to reset"
+msgstr ""
+
+#. octLi
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id271616948330553\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. D7yir
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id451616948330759\n"
+"help.text"
+msgid "Before updating"
+msgstr ""
+
+#. YM7Nt
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id71616948330769\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. pHG54
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id211616948330895\n"
+"help.text"
+msgid "Changed"
+msgstr ""
+
+#. UaRoN
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id121616948330654\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. tfW7M
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id2216169483303\n"
+"help.text"
+msgid "Error occurred"
+msgstr ""
+
+#. vDFhJ
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id111612629836630\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. NN9FK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id1001612629836902\n"
+"help.text"
+msgid "When receiving focus"
+msgstr ""
+
+#. tLp7Y
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id291612629836294\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. DDcCF
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id62161262983683\n"
+"help.text"
+msgid "When losing focus"
+msgstr ""
+
+#. EBVQM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id51612707354544\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. PLPUr
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id211612707354899\n"
+"help.text"
+msgid "Item status changed"
+msgstr ""
+
+#. zBci2
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id81612629836634\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. vPrAA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id881612629836744\n"
+"help.text"
+msgid "Key pressed"
+msgstr ""
+
+#. 8cFqR
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id591612629836830\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 6rrBt
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id161612629836775\n"
+"help.text"
+msgid "Key released"
+msgstr ""
+
+#. 7Pzmy
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891612629836630\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 2pMWG
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id461612629836679\n"
+"help.text"
+msgid "Mouse moved while key presses"
+msgstr ""
+
+#. SGYBr
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id131612629836291\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. AJGQd
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id151612629836151\n"
+"help.text"
+msgid "Mouse inside"
+msgstr ""
+
+#. 6cFkB
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id211612629836725\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. tfmtf
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id361612629836624\n"
+"help.text"
+msgid "Mouse outside"
+msgstr ""
+
+#. 6E7WA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id311612629836481\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. CeNku
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id721612629836752\n"
+"help.text"
+msgid "Mouse moved"
+msgstr ""
+
+#. iSxsS
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id981612629836116\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 9yirD
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id381612629836635\n"
+"help.text"
+msgid "Mouse button pressed"
+msgstr ""
+
+#. b6pFV
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id711612629836704\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. D5vXU
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id35161262983642\n"
+"help.text"
+msgid "Mouse button released"
+msgstr ""
+
+#. 9Ui2H
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id31616948666215\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. mdLSp
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id951616948666674\n"
+"help.text"
+msgid "After resetting"
+msgstr ""
+
+#. jb4at
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id811612707606330\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. m3Rb7
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id621612707606219\n"
+"help.text"
+msgid "Text modified"
+msgstr ""
+
+#. bfgkG
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id41616948721642\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. imn6B
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id311616948721872\n"
+"help.text"
+msgid "After updating"
+msgstr ""
+
+#. tcpN5
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id961618181634181\n"
+"help.text"
+msgid "To learn more about URI strings, refer to the <link href=\"https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework_URI_Specification\" name=\"URI specification\">Scripting Framework URI Specification</link>."
+msgstr ""
+
+#. RpNkd
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id891611613601554\n"
+"help.text"
+msgid "List of Methods in the FormControl Service"
+msgstr ""
+
+#. CKZDf
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id161584541257982\n"
+"help.text"
+msgid "This method is applicable only to controls of the <literal>TableControl</literal> type. The returned value depends on the arguments provided."
+msgstr ""
+
+#. GfVbh
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id701618777636827\n"
+"help.text"
+msgid "If the optional argument <literal>ControlName</literal> is absent, then a zero-based Array containing the names of all controls is returned."
+msgstr ""
+
+#. GyLgF
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id851618777715892\n"
+"help.text"
+msgid "On the other hand, if a <literal>ControlName</literal> is provided, the method returns a <literal>FormControl</literal> class instance corresponding to the specified control."
+msgstr ""
+
+#. eoLJG
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id1001584541257789\n"
+"help.text"
+msgid "<emph>controlname</emph>: A valid control name as a case-sensitive string. If absent, the list of control names is returned as a zero-based array."
+msgstr ""
+
+#. F4Sdy
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"bas_id471618778075117\n"
+"help.text"
+msgid "' Returns an Array with the names of all controls in \"myTableControl\""
+msgstr ""
+
+#. YoHSo
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id931618778110273\n"
+"help.text"
+msgid "' Returns a FormControl class instance corresponding to \"myCheckBox\""
+msgstr ""
+
+#. AGA7Z
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id391622559441530\n"
+"help.text"
+msgid "Using Python:"
+msgstr ""
+
+#. CprjV
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id871583933076448\n"
+"help.text"
+msgid "Sets the focus on the control. Returns <literal>True</literal> if focusing was successful."
+msgstr ""
+
+#. LuxFE
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id151598178880227\n"
+"help.text"
+msgid "This method is often called from a form or control event."
+msgstr ""
+
+#. haAXC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"hd_id141618777179310\n"
+"help.text"
+msgid "Additional examples"
+msgstr ""
+
+#. JopFS
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id331618777195723\n"
+"help.text"
+msgid "Below are two examples that illustrate the use of the <literal>FormControl</literal> service."
+msgstr ""
+
+#. 5iGmg
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id371618776324489\n"
+"help.text"
+msgid "The first example reads the current value in a ComboBox containing city names and writes it to a FixedTest control in a Form:"
+msgstr ""
+
+#. B5QLA
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"pyc_id991622562833004\n"
+"help.text"
+msgid "ui = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
+msgstr ""
+
+#. 8jneo
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"pyc_id781622561048794\n"
+"help.text"
+msgid "lbl_city.Caption = \"Selected city: \" + combo_city.Value"
+msgstr ""
+
+#. kz9SK
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"par_id251618776614814\n"
+"help.text"
+msgid "The following code snippet can be used to process RadioButton controls that share the same group name. In this example, suppose there are three radio buttons with names <literal>optA</literal>, <literal>optB</literal> and <literal>optC</literal> and we wish to display the caption of the selected control."
+msgstr ""
+
+#. hRhNC
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"bas_id251618776933304\n"
+"help.text"
+msgid "MsgBox \"Selected option: \" & optControl.Caption"
+msgstr ""
+
+#. kxKPM
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"pyc_id991622562822004\n"
+"help.text"
+msgid "ui = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
+msgstr ""
+
+#. QBAvs
+#: sf_formcontrol.xhp
+msgctxt ""
+"sf_formcontrol.xhp\n"
+"pyc_id441622562080419\n"
+"help.text"
+msgid "ui.MsgBox('Selected option: ' + control.Caption)"
+msgstr ""
+
+#. czP76
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"tit\n"
+"help.text"
+msgid "Creating Python Scripts with ScriptForge"
+msgstr ""
+
+#. 8BEWT
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id461623364876507\n"
+"help.text"
+msgid "<variable id=\"title\"><link href=\"text/sbasic/shared/03/sf_intro.xhp\" name=\"SF_Intro_Page\">Creating Python Scripts with <literal>ScriptForge</literal></link></variable>"
+msgstr ""
+
+#. 6JuA3
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id361623410405420\n"
+"help.text"
+msgid "Differences between Basic and Python"
+msgstr ""
+
+#. 3GzhB
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id41623410443946\n"
+"help.text"
+msgid "The <link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"SF_Lib\">ScriptForge library</link> is available both for Basic and Python. Most services, methods and properties work identically in both programming languages. However, due to differences in how each language works, <literal>ScriptForge</literal> users must be aware of some characteristics of the library when using Python:"
+msgstr ""
+
+#. HsKzK
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id551623410718241\n"
+"help.text"
+msgid "<emph>Methods and Property names:</emph> In Python, all methods and properties can be used in lowercased, ProperCased or camelCased formats."
+msgstr ""
+
+#. Rg29x
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id741623411104297\n"
+"help.text"
+msgid "<emph>Arguments:</emph> All keyword arguments passed on to methods are lowercased."
+msgstr ""
+
+#. C6VCu
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id441623411216354\n"
+"help.text"
+msgid "<emph>Dates:</emph> All date objects are passed and returned as <literal>datetime.datetime</literal> native Python objects."
+msgstr ""
+
+#. FcX93
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id891623411367669\n"
+"help.text"
+msgid "<emph>Arrays:</emph> One-dimensional arrays are passed and returned as tuples (which is an immutable object). Two-dimensional arrays are passed and returned as tuples of tuples."
+msgstr ""
+
+#. S6wwX
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id981623411507442\n"
+"help.text"
+msgid "<emph>None:</emph> Python's <literal>None</literal> keyword is equivalent to Basic's <literal>Null</literal>, <literal>Empty</literal> or <literal>Nothing</literal>."
+msgstr ""
+
+#. 2G2uk
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id21623411611447\n"
+"help.text"
+msgid "<emph>UNO objects:</emph> All UNO structures are exchanged between Basic and Python without any changes."
+msgstr ""
+
+#. WFDrN
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id651623412069496\n"
+"help.text"
+msgid "<emph>Debugging:</emph> Whenever an error occurs in Python scripts that use <literal>ScriptForge</literal>, the error message provided by the Python execution stack displays the line of code that triggered the error. In Basic error messages do not display this information."
+msgstr ""
+
+#. ZzngK
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id31623411828158\n"
+"help.text"
+msgid "Visit <embedvar href=\"text/sbasic/python/main0000.xhp#pythonscriptshelp\"/> for more information on Python scripting using %PRODUCTNAME."
+msgstr ""
+
+#. CZiTF
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id391623411150080\n"
+"help.text"
+msgid "Running Python scripts on %PRODUCTNAME"
+msgstr ""
+
+#. 2j29F
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id411623364895100\n"
+"help.text"
+msgid "Depending on what you intend to achieve, you may choose one of the following approaches to running Python scripts in %PRODUCTNAME:"
+msgstr ""
+
+#. XHP4Z
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id681623365274024\n"
+"help.text"
+msgid "<emph>Run Scripts inside the current %PRODUCTNAME process:</emph> Python scripts are executed from within the %PRODUCTNAME process by using the <menuitem>Tools - Macros - Run Macro</menuitem> menu or the APSO extension to call user scripts stored in the Python scripts folder. You can also use the APSO Python shell to interactively run Python scripts."
+msgstr ""
+
+#. pnXQT
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id761623365278133\n"
+"help.text"
+msgid "<emph>Run Scripts separately from the %PRODUCTNAME process:</emph> Python scripts are executed from an external process that connects to an ongoing %PRODUCTNAME process using a socket."
+msgstr ""
+
+#. uyCPN
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id631623365667011\n"
+"help.text"
+msgid "If you plan to run scripts from inside the %PRODUCTNAME process, it is recommended to install the <link href=\"https://extensions.libreoffice.org/en/extensions/show/apso-alternative-script-organizer-for-python\" name=\"APSO\">APSO (Alternative Script Organizer for Python) extension</link>. However, to develop Python scripts from outside %PRODUCTNAME, you can choose your preferred Python IDE."
+msgstr ""
+
+#. R4Rfk
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id431623365836802\n"
+"help.text"
+msgid "Running Scripts from inside the %PRODUCTNAME process"
+msgstr ""
+
+#. UFGaA
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id111623365861568\n"
+"help.text"
+msgid "Using the APSO extension"
+msgstr ""
+
+#. GAQwg
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id681623365892513\n"
+"help.text"
+msgid "The easiest way to get started with Python scripting in %PRODUCTNAME is by installing the APSO extension. After installing it, open any %PRODUCTNAME component and go to <menuitem>Tools - Macros - Organize Python Scripts</menuitem>."
+msgstr ""
+
+#. iXiDt
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id111623366334727\n"
+"help.text"
+msgid "In APSO's main window go to <menuitem>Menu - Python Shell</menuitem>."
+msgstr ""
+
+#. gbnEf
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id931623366329927\n"
+"help.text"
+msgid "Alternativelly you can open APSO using the default shortcut <keycode>Alt + Shift + F11</keycode>."
+msgstr ""
+
+#. TKAXE
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id661623366478092\n"
+"help.text"
+msgid "Now you can start typing Python commands and the shell will print the corresponding output after each line of code is executed."
+msgstr ""
+
+#. zGCxS
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id581623366559478\n"
+"help.text"
+msgid "To start using the <literal>ScriptForge</literal> library, you need to import the <literal>CreateScriptService</literal> method, with which you will be able to access the services provided by the library. The example below uses the <literal>Basic</literal> service to display a message box."
+msgstr ""
+
+#. F7c8N
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id701623366829587\n"
+"help.text"
+msgid "To run the example above, enter each line in the Python shell, one by one, pressing the Enter key after you type each line of code."
+msgstr ""
+
+#. tWENT
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id471623366906045\n"
+"help.text"
+msgid "Now you can start executing Python commands using any of the ScriptForge services. For example, the code snippet bellow uses the <literal>UI</literal> service to create a blank writer document."
+msgstr ""
+
+#. N5A9E
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id961623367376768\n"
+"help.text"
+msgid "Creating Python script files"
+msgstr ""
+
+#. xqmvY
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id821623367433650\n"
+"help.text"
+msgid "You can create your own Python files and edit them with your preferred text editor. Later you can call them from within any %PRODUCTNAME component."
+msgstr ""
+
+#. arDpS
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id51623367560321\n"
+"help.text"
+msgid "The first step is to locate where your user scripts are stored. For that, refer to <link href=\"text/sbasic/python/python_locations.xhp\" name=\"Python_Scripts_Path\">Python Scripts Organization and Location</link> help page."
+msgstr ""
+
+#. NdM4Y
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id821623367773032\n"
+"help.text"
+msgid "Now you can create a text file inside your Python user scripts folder, for instance <emph>sf_test.py</emph>, and start typing your scripts."
+msgstr ""
+
+#. rFyBp
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id271623367917630\n"
+"help.text"
+msgid "Next is a simple example that gets the numeric value from a Calc cell and increments it by 1. Simply type the following code into the <emph>sf_test.py</emph> file."
+msgstr ""
+
+#. EQxF2
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id171623368511426\n"
+"help.text"
+msgid "This example creates the <literal>increment_cell</literal> function. Note that <literal>g_exportedScripts</literal> is a tuple that tells which functions will be displayed in %PRODUCTNAME as user scripts."
+msgstr ""
+
+#. UUnv4
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id471623368615244\n"
+"help.text"
+msgid "To run this script from within a Calc document:"
+msgstr ""
+
+#. FynYm
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id811623368677444\n"
+"help.text"
+msgid "Create or open a Calc file."
+msgstr ""
+
+#. qdWEL
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id281623368679141\n"
+"help.text"
+msgid "Enter some numeric value into cell \"A1\" in the current sheet."
+msgstr ""
+
+#. bFQSh
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id111623368679893\n"
+"help.text"
+msgid "Go to <menuitem>Tools - Macros - Run Macros</menuitem> ."
+msgstr ""
+
+#. xLTy8
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id421623368680565\n"
+"help.text"
+msgid "Choose My Macros - sf_test in the library selector. Then choose the <literal>increment_cell</literal> function under the <menuitem>Macro Name</menuitem> list."
+msgstr ""
+
+#. EaBEU
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id131623368875763\n"
+"help.text"
+msgid "Click <keycode>Run</keycode>. Note that the value in cell \"A1\" was incremented by 1."
+msgstr ""
+
+#. 9FozC
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id781623368934689\n"
+"help.text"
+msgid "You can also use APSO to run Python scripts in a similar manner:"
+msgstr ""
+
+#. Lyyxc
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id501623369002537\n"
+"help.text"
+msgid "First open APSO by going to <menuitem>Tools - Macros - Organize Python Scripts</menuitem>."
+msgstr ""
+
+#. 2H4ta
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id521623369004825\n"
+"help.text"
+msgid "In the macro list, navigate to <menuitem>My Macros - sf_test - increment_cell</menuitem> ."
+msgstr ""
+
+#. ZhSaL
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id101623369005929\n"
+"help.text"
+msgid "Click <menuitem>Execute</menuitem> ."
+msgstr ""
+
+#. ujB4e
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id531623369208159\n"
+"help.text"
+msgid "Running Scripts separately from the %PRODUCTNAME process"
+msgstr ""
+
+#. 9yG9z
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id261623370168228\n"
+"help.text"
+msgid "Determining the Installation Path"
+msgstr ""
+
+#. 2ijCM
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id261623369722023\n"
+"help.text"
+msgid "The first step to run scripts from a separate process is to find the folder where %PRODUCTNAME is installed. There are several ways to do that, but <literal>ScriptForge</literal> provides a quick way to identify your installation path. For that, open APSO's Python shell and type:"
+msgstr ""
+
+#. UEwkB
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id81623370150730\n"
+"help.text"
+msgid "The output from the code above is the base directory where %PRODUCTNAME is installed. Now you need to add the \"program\" subfolder to the resulting path. This is the base folder from which you will run Python scripts from a separate process."
+msgstr ""
+
+#. EvDcx
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id451623370201479\n"
+"help.text"
+msgid "For example, suppose you get <emph>/usr/lib/libreoffice/</emph> as the result from running the Python code above. Then you need to consider <emph>/usr/lib/libreoffice/program</emph> as the path to run your Python scripts."
+msgstr ""
+
+#. 6EYGe
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id231623370501084\n"
+"help.text"
+msgid "Start %PRODUCTNAME with socket settings"
+msgstr ""
+
+#. F94mp
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id721623369245475\n"
+"help.text"
+msgid "To run Python scripts from a separate process, you need to start %PRODUCTNAME with a few additional options that specify the hostname and port through which the external process will communicate with the %PRODUCTNAME component process."
+msgstr ""
+
+#. mfbEM
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id221623369584132\n"
+"help.text"
+msgid "Open the your operating system's command prompt, navigate to the program folder of your %PRODUCTNAME installation directory and type:"
+msgstr ""
+
+#. 6hDm4
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id981623370706743\n"
+"help.text"
+msgid "The command above will start %PRODUCTNAME with a communication channel open so that other processes can exchange messages with it."
+msgstr ""
+
+#. SB5LE
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id621623370871360\n"
+"help.text"
+msgid "Note that the previous example opens %PRODUCTNAME start center. If you want to open a specific component, for instance Writer, you can add the --writer flag to the command, as follows."
+msgstr ""
+
+#. cVRuV
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id431623373618951\n"
+"help.text"
+msgid "Take note of the <literal>host</literal> and <literal>port</literal> parameters, which in this example are <emph>localhost</emph> and <emph>2021</emph>, respectively."
+msgstr ""
+
+#. Z7z5C
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"hd_id861623370468356\n"
+"help.text"
+msgid "Running an External Python Shell"
+msgstr ""
+
+#. eBmVz
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id621623371253647\n"
+"help.text"
+msgid "Start the Python shell from within the <emph>program</emph> folder inside your %PRODUCTNAME installation path. Follow the steps <link href=\"text/sbasic/shared/03/sf_intro.xhp#InstallPath\" name=\"Install_Path\">above</link> to learn how to find your installation path."
+msgstr ""
+
+#. 69F7S
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id11623373098602\n"
+"help.text"
+msgid "<emph>On Linux / Mac OS:</emph>"
+msgstr ""
+
+#. PFWiq
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id311623373151552\n"
+"help.text"
+msgid "<emph>On Windows:</emph>"
+msgstr ""
+
+#. HGBuK
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id791623373520018\n"
+"help.text"
+msgid "This will open the Python shell and now you can start typing commands that will be executed by %PRODUCTNAME. But first you need to set up the socket connection."
+msgstr ""
+
+#. s54tE
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id351623373686414\n"
+"help.text"
+msgid "The second line of code above defines the <literal>host</literal> and <literal>port</literal> settings so that the Python shell can communicate with an ongoing %PRODUCTNAME process opened with the same socket settings."
+msgstr ""
+
+#. RiXDx
+#: sf_intro.xhp
+msgctxt ""
+"sf_intro.xhp\n"
+"par_id721623373769471\n"
+"help.text"
+msgid "Now you can run other Python commands and they will be able to communicate with the %PRODUCTNAME process. For example:"
+msgstr ""
+
#. VCRTD
#: sf_l10n.xhp
msgctxt ""
@@ -14065,6 +19510,33 @@ msgctxt ""
msgid "The hexadecimal digits may be prefixed with \"0x\" or \"&H\"."
msgstr ""
+#. 3WKNf
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id791584008420941\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid International Bank Account Number (IBAN). The comparison is not case-sensitive."
+msgstr ""
+
+#. JZERm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id951880048466565\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. VgT3x
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id631619526542367\n"
+"help.text"
+msgid "<literal>True</literal> if the string contains a valid IBAN number."
+msgstr ""
+
#. CcTNk
#: sf_string.xhp
msgctxt ""
@@ -16180,13 +21652,13 @@ msgctxt ""
msgid "<variable id=\"UIService\"><link href=\"text/sbasic/shared/03/sf_ui.xhp\" name=\"ScriptForge.UI service\"><literal>ScriptForge</literal>.<literal>UI</literal> service</link></variable>"
msgstr ""
-#. ABBCn
+#. cAtxQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id31587913266153\n"
"help.text"
-msgid "The UI (User Interface) service simplifies the identification and the manipulation of the different windows composing the whole LibreOffice application:"
+msgid "The UI (User Interface) service simplifies the identification and the manipulation of the different windows composing the whole %PRODUCTNAME application:"
msgstr ""
#. nTqj5
@@ -16243,11 +21715,11 @@ msgctxt ""
msgid "Access to the underlying \"documents\""
msgstr ""
-#. 3pR9U
+#. W5BL2
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"par_id421587913266819\n"
+"par_id181620312953395\n"
"help.text"
msgid "The UI service is the starting point to open, create or access to the content of new or existing documents from a user script."
msgstr ""
@@ -16450,6 +21922,177 @@ msgctxt ""
msgid "The list of the currently open documents. Special windows are ignored. This list consists of a zero-based one dimensional array either of filenames (in SF_FileSystem.FileNaming notation) or of window titles for unsaved documents."
msgstr ""
+#. BH9YJ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"hd_id511620762163390\n"
+"help.text"
+msgid "Constants"
+msgstr ""
+
+#. ziD2D
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id761620761856238\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. eBD6E
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id591620761856238\n"
+"help.text"
+msgid "Value"
+msgstr ""
+
+#. 2DU4R
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id711620761856238\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. TGMq5
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id511620761856238\n"
+"help.text"
+msgid "MACROEXECALWAYS"
+msgstr ""
+
+#. VFEvz
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id761620761856107\n"
+"help.text"
+msgid "2"
+msgstr ""
+
+#. adCUF
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id341620761856238\n"
+"help.text"
+msgid "Macros are always executed"
+msgstr ""
+
+#. o7zQn
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id661620761881513\n"
+"help.text"
+msgid "MACROEXECNEVER"
+msgstr ""
+
+#. kfQCf
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id661620761891082\n"
+"help.text"
+msgid "1"
+msgstr ""
+
+#. 7hEDg
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id101620761893011\n"
+"help.text"
+msgid "Macros are never executed"
+msgstr ""
+
+#. EABYh
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id311620761888379\n"
+"help.text"
+msgid "MACROEXECNORMAL"
+msgstr ""
+
+#. LpGCQ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id951620761899067\n"
+"help.text"
+msgid "0"
+msgstr ""
+
+#. 6Jgt7
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id11620761899780\n"
+"help.text"
+msgid "Macro execution depends on user settings"
+msgstr ""
+
+#. BTUQ4
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id311620312548992\n"
+"help.text"
+msgid "The examples below show a <literal>MsgBox</literal> with the names of all currently open documents."
+msgstr ""
+
+#. DCM9L
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id21620312350189\n"
+"help.text"
+msgid "svcUI = CreateScriptService(\"UI\")"
+msgstr ""
+
+#. EBquG
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id631620312351013\n"
+"help.text"
+msgid "sBasic = CreateScriptService(\"Basic\")"
+msgstr ""
+
+#. 3XXYB
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id141620312351286\n"
+"help.text"
+msgid "openDocs = svcUI.Documents()"
+msgstr ""
+
+#. jZeEa
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id661620312351500\n"
+"help.text"
+msgid "strDocs = \"\\n\".join(openDocs)"
+msgstr ""
+
+#. 7hHpR
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id801620312351676\n"
+"help.text"
+msgid "sBasic.MsgBox(strDocs)"
+msgstr ""
+
#. DfpBz
#: sf_ui.xhp
msgctxt ""
@@ -16459,11 +22102,11 @@ msgctxt ""
msgid "List of Methods in the UI Service"
msgstr ""
-#. dfsmh
+#. 4fc2p
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"par_id811596553490262\n"
+"par_id431620322170443\n"
"help.text"
msgid "Note, as an exception, that the methods marked <emph>(*)</emph> are <emph>not applicable to Base documents</emph>."
msgstr ""
@@ -16477,85 +22120,103 @@ msgctxt ""
msgid "Make the specified window active. The method returns <literal>True</literal> if the given window is found and can be activated. There is no change in the actual user interface if no window matches the selection."
msgstr ""
-#. fcE3q
+#. w9DR4
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id381587913266946\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: see the definitions above."
msgstr ""
-#. df2C7
+#. 5kwSb
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id13159655484952\n"
"help.text"
-msgid "Create and store a new LibreOffice Base document embedding an empty database of the given type. The method returns a document object."
+msgid "Creates and stores a new %PRODUCTNAME Base document embedding an empty database of the given type. The method returns a <literal>Document</literal> service instance."
msgstr ""
-#. BtPaW
+#. gqGpB
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441596554849949\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to create. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
+msgid "<emph>filename</emph> : Identifies the file to create. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. If the file already exists, it is overwritten without warning"
msgstr ""
-#. nePdj
+#. ncJxE
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id381596554849698\n"
"help.text"
-msgid "<emph>EmbeddedDatabase</emph> : Either \"HSQLDB\" (default) or \"FIREBIRD\"."
+msgid "<emph>embeddeddatabase</emph> : Either \"HSQLDB\" (default) or \"FIREBIRD\"."
msgstr ""
-#. iyE5E
+#. BWgpN
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id521596554849185\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name used to store the new database in the databases register. When = \"\" (default), no registration takes place. If the name already exists it is overwritten without warning."
+msgid "<emph>registrationname</emph> : The name used to store the new database in the databases register. When = \"\" (default), no registration takes place. If the name already exists it is overwritten without warning."
msgstr ""
-#. A9gBj
+#. XkY2F
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id361620323808010\n"
+"help.text"
+msgid "myBase = svcUI.CreateBaseDocument(r\"C:\\Databases\\MyBaseFile.odb\", \"FIREBIRD\")"
+msgstr ""
+
+#. GtB5n
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id651588521753997\n"
"help.text"
-msgid "Create a new LibreOffice document of a given type or based on a given template. The method returns a document object."
+msgid "Create a new %PRODUCTNAME document of a given type or based on a given template. The method returns a document object."
msgstr ""
-#. CC8kd
+#. 2rUeD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id51588521753302\n"
"help.text"
-msgid "<emph>DocumentType</emph> : \"Calc\", \"Writer\", etc. If absent, the <literal>TemplateFile</literal> argument must be present."
+msgid "<emph>documenttype</emph> : \"Calc\", \"Writer\", etc. If absent, the <literal>TemplateFile</literal> argument must be present."
msgstr ""
-#. 2DPGC
+#. BQ6UD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id401588522663325\n"
"help.text"
-msgid "<emph>TemplateFile</emph> : The full <literal>FileName</literal> of the template to build the new document on. If the file does not exist, the argument is ignored. The \"FileSystem\" service provides the <literal>TemplatesFolder</literal> and <literal>UserTemplatesFolder</literal> properties to help to build the argument."
+msgid "<emph>templatefile</emph> : The full <literal>FileName</literal> of the template to build the new document on. If the file does not exist, the argument is ignored. The <literal>FileSystem</literal> service provides the <literal>TemplatesFolder</literal> and <literal>UserTemplatesFolder</literal> properties to help to build the argument."
msgstr ""
-#. JFB9W
+#. VeNQg
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id131588522824366\n"
"help.text"
-msgid "<emph>Hidden</emph>: if <literal>True</literal>, open the new document in the background (default = False). To use with caution: activation or closure afterwards can only happen programmatically."
+msgid "<emph>hidden</emph>: if <literal>True</literal>, open the new document in the background (default = <literal>False</literal>). To use with caution: activation or closure afterwards can only happen programmatically."
+msgstr ""
+
+#. gWFt9
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id701620762417802\n"
+"help.text"
+msgid "In both examples below, the first call to <literal>CreateDocument</literal> method creates a blank Calc document, whereas the second creates a document from a template file."
msgstr ""
#. W3qxn
@@ -16567,13 +22228,22 @@ msgctxt ""
msgid "Returns a document object referring to either the active window or the given window."
msgstr ""
-#. hD23E
+#. hZmVw
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id851588520551368\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: See the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is used."
+msgstr ""
+
+#. AAjDB
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id521620330287071\n"
+"help.text"
+msgid "To access the name of the currently active window, refer to the <literal>ActiveWindow</literal> property."
msgstr ""
#. CYsyC
@@ -16585,13 +22255,13 @@ msgctxt ""
msgid "Maximizes the active window or the given window."
msgstr ""
-#. G2hSo
+#. hD4TC
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id951587986441954\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above. If the argument is absent, the active window is maximized."
+msgid "<emph>windowname</emph>: see the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is maximized."
msgstr ""
#. vzDdG
@@ -16603,121 +22273,130 @@ msgctxt ""
msgid "Minimizes the active window or the given window."
msgstr ""
-#. snQ6b
+#. Enys5
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id751587986592626\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above. If the argument is absent, the active window is minimized."
+msgid "<emph>windowname</emph>: see the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is minimized."
msgstr ""
-#. tmxLS
+#. WHDDQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id691596555746539\n"
"help.text"
-msgid "Open an existing LibreOffice Base document. The method returns a document object."
+msgid "Open an existing %PRODUCTNAME Base document. The method returns a document object."
msgstr ""
-#. RERE5
+#. yGPbD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id231596555746385\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
+msgid "<emph>filename</emph> : Identifies the file to open. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
msgstr ""
-#. xE2FY
+#. DBB9u
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id711596555746281\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name to use to find the database in the databases register. It is ignored if <literal>FileName</literal> <> \"\"."
+msgid "<emph>registrationname</emph> : The name to use to find the database in the databases register. It is ignored if <literal>FileName</literal> <> \"\"."
msgstr ""
-#. u4Erc
+#. TqAd2
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"id721596556313545\n"
"help.text"
-msgid "<emph>MacroExecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
+msgid "<emph>macroexecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
+msgstr ""
+
+#. Dok5e
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id941620762989833\n"
+"help.text"
+msgid "To improve code readability you can use <link href=\"text/sbasic/shared/03/sf_ui.xhp#Constants\" name=\"CHANGE ME\">predefined constants</link> for the <literal>macroexecution</literal> argument, as in the examples above."
msgstr ""
-#. szffG
+#. LBgGQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id541588523635283\n"
"help.text"
-msgid "Open an existing LibreOffice document with the given options. Returns a document object or one of its subclasses or <literal>Null</literal> if the opening failed, including when due to a user decision."
+msgid "Opens an existing %PRODUCTNAME document with the given options. Returns a document object or one of its subclasses. The method returns <literal>Nothing</literal> (in Basic) / <literal>None</literal> (in Python) if the opening failed, even when the failure is caused by a user decision."
msgstr ""
-#. dZF95
+#. 8tjbg
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id481588523635890\n"
"help.text"
-msgid "<emph>FileName</emph>: Identifies the file to open. It must follow the <literal>FileNaming</literal> notation of the <literal>FileSystem</literal> service."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>FileNaming</literal> notation of the <literal>FileSystem</literal> service."
msgstr ""
-#. NRyuH
+#. PWvQz
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id451588523635507\n"
"help.text"
-msgid "<emph>Password</emph>: To use when the document is protected. If wrong or absent while the document is protected, the user will be prompted to enter a password."
+msgid "<emph>password</emph>: To use when the document is protected. If wrong or absent while the document is protected, the user will be prompted to enter a password."
msgstr ""
-#. hZkGG
+#. 2jjFK
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id611588524329781\n"
"help.text"
-msgid "<emph>ReadOnly</emph>: Default = <literal>False</literal>."
+msgid "<emph>readonly</emph>: Default = <literal>False</literal>."
msgstr ""
-#. Hhywx
+#. BcyEp
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id641588523635497\n"
"help.text"
-msgid "<emph>Hidden</emph>: if <literal>True</literal>, open the new document in the background (default = False). To use with caution: activation or closure afterwards can only happen programmatically."
+msgid "<emph>hidden</emph>: if <literal>True</literal>, open the new document in the background (default = <literal>False</literal>). To use with caution: activation or closure afterwards can only happen programmatically."
msgstr ""
-#. VPmyv
+#. sbgeH
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id981588524474719\n"
"help.text"
-msgid "<emph>MacroExecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
+msgid "<emph>macroexecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
msgstr ""
-#. KBCtV
+#. AF7iF
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id611588524584693\n"
"help.text"
-msgid "<emph>FilterName</emph>: The name of a filter that should be used for loading the document. If present, the filter must exist."
+msgid "<emph>filtername</emph>: The name of a filter that should be used for loading the document. If present, the filter must exist."
msgstr ""
-#. 6rbcm
+#. MKueU
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id191588524634348\n"
"help.text"
-msgid "<emph>FilterOptions</emph>: An optional string of options associated with the filter."
+msgid "<emph>filteroptions</emph>: An optional string of options associated with the filter."
msgstr ""
#. qMTrj
@@ -16729,31 +22408,49 @@ msgctxt ""
msgid "Resizes and/or moves the active window. Absent and negative arguments are ignored. If the window is minimized or maximized, calling <literal>Resize</literal> without arguments restores it."
msgstr ""
-#. SxjEP
+#. 6NUcv
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441587986945696\n"
"help.text"
-msgid "<emph>Left, Top</emph>: Distances of the top-left corner from top and left edges of the screen."
+msgid "<emph>left, top</emph>: Distances of the top-left corner from top and left edges of the screen, in pixels."
msgstr ""
-#. ne7hx
+#. AdcjG
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id601587987453825\n"
"help.text"
-msgid "<emph>Width, Height</emph>: New dimensions of the window."
+msgid "<emph>width, height</emph>: New dimensions of the window, in pixels."
msgstr ""
-#. 4UBqz
+#. vDNVH
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"bas_id801587987507028\n"
+"par_id801587987507028\n"
"help.text"
-msgid "' Top and Height are left unchanged"
+msgid "In the following examples, the <literal>width</literal> and <literal>height</literal> of the window are changed while <literal>top</literal> and <literal>left</literal> are left unchanged."
+msgstr ""
+
+#. 7HuAE
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id971620331945744\n"
+"help.text"
+msgid "svcUI.Resize(width = 500, height = 500)"
+msgstr ""
+
+#. HP2Jb
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id21620332301809\n"
+"help.text"
+msgid "To resize a window that is not active, first activate it using the <literal>Activate</literal> method."
msgstr ""
#. NnBWM
@@ -16765,58 +22462,130 @@ msgctxt ""
msgid "Display a text and a progressbar in the status bar of the active window. Any subsequent calls in the same macro run refer to the same status bar of the same window, even if the window is not visible anymore. A call without arguments resets the status bar to its normal state."
msgstr ""
-#. dKTqd
+#. rDr2L
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id71587996421829\n"
"help.text"
-msgid "<emph>Text</emph>: An optional text to be displayed in front of the progress bar."
+msgid "<emph>text</emph>: An optional text to be displayed in front of the progress bar."
msgstr ""
-#. WuBNx
+#. hbCpG
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id881587996421777\n"
"help.text"
-msgid "<emph>Percentage</emph>: an optional degree of progress between 0 and 100."
+msgid "<emph>percentage</emph>: an optional degree of progress between 0 and 100."
+msgstr ""
+
+#. qbGdy
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id651620332601083\n"
+"help.text"
+msgid "' Resets the statusbar"
msgstr ""
-#. DBbfU
+#. venZk
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id631620332653004\n"
+"help.text"
+msgid "from time import sleep"
+msgstr ""
+
+#. AQ57P
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id351620332422330\n"
+"help.text"
+msgid "for i in range(101):"
+msgstr ""
+
+#. uUDVJ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id261620332627647\n"
+"help.text"
+msgid "svcUI.SetStatusbar(\"Test:\", i)"
+msgstr ""
+
+#. qWafN
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id181620332715974\n"
+"help.text"
+msgid "sleep(0.05)"
+msgstr ""
+
+#. PgCrS
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id381620332733373\n"
+"help.text"
+msgid "svcUI.SetStatusbar()"
+msgstr ""
+
+#. oQfWc
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id571598864255776\n"
"help.text"
-msgid "Display a non-modal dialog box. Specify its title, an explicatory text and a percentage of progress represented on a progressbar. The box will remain visible until a call to the method without argument, or until the end of the currently running macro."
+msgid "Displays a non-modal dialog box. Specify its title, an explicatory text and a percentage of progress to be represented on a progressbar. The dialog will remain visible until a call to the method without arguments or until the user manually closes the dialog."
msgstr ""
-#. B27Bg
+#. drhV6
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441598864535695\n"
"help.text"
-msgid "<emph>Title</emph> : The title appearing on top of the dialog box. Default = \"ScriptForge\"."
+msgid "<emph>title</emph> : The title appearing on top of the dialog box. Default = \"ScriptForge\"."
msgstr ""
-#. 6pZKs
+#. jvrZV
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id311598864255297\n"
"help.text"
-msgid "<emph>Text</emph>: An optional text to be displayed above the progress bar."
+msgid "<emph>text</emph>: An optional text to be displayed above the progress bar."
msgstr ""
-#. FV2pm
+#. Qj3N3
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id881598864255424\n"
"help.text"
-msgid "<emph>Percentage</emph>: an optional degree of progress between 0 and 100."
+msgid "<emph>percentage</emph>: an optional degree of progress between 0 and 100."
+msgstr ""
+
+#. rVBX3
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id651620333289753\n"
+"help.text"
+msgid "' Closes the Progress Bar window"
+msgstr ""
+
+#. u3gZ8
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id761620333269236\n"
+"help.text"
+msgid "# Closes the Progress Bar window"
msgstr ""
#. ZEG6t
@@ -16828,11 +22597,29 @@ msgctxt ""
msgid "Returns <literal>True</literal> if the given window could be identified."
msgstr ""
-#. aAKnF
+#. rkJbT
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id45158858711917\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: see the definitions above."
+msgstr ""
+
+#. F7ntw
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id441620333481074\n"
+"help.text"
+msgid "if svcUI.WindowExists(r\"C:\\Document\\My file.odt\"):"
+msgstr ""
+
+#. nLT8F
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id801620333495532\n"
+"help.text"
+msgid "# ..."
msgstr ""