update translations for master

and force-fix errors using pocheck Change-Id: Ib744c61a45769eee462d6014d37f75a863c265a9
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2021-02-08 12:56:25 +0100
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2021-02-08 13:01:01 +0100
commit: 418be5d6b01b00babc6dc695e2a768f554c7dedc (patch)
tree: 8c2c3ceaa0b23a60ae924f0596689f5e61da3d25 /source/sq/helpcontent2
parent: 8cb8b0716a18bd866fed08dc3c72a895b46e4cd4 (diff)
10 files changed, 5127 insertions, 1077 deletions
diff --git a/source/sq/helpcontent2/source/text/sbasic/shared.po b/source/sq/helpcontent2/source/text/sbasic/shared.po
index 59bbf03e603..4a686252e92 100644
--- a/source/sq/helpcontent2/source/text/sbasic/shared.po
+++ b/source/sq/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-25 14:55+0100\n"
+"POT-Creation-Date: 2021-02-08 12:09+0100\n"
 "PO-Revision-Date: 2018-10-21 20:35+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -547,13 +547,13 @@ msgctxt ""
 msgid "Open <item type=\"menuitem\">Tools - Macros - %PRODUCTNAME Basic - Edit</item>  and select <item type=\"menuitem\">%PRODUCTNAME Macros</item> container."
 msgstr ""
 
-#. GWmpa
+#. 7wPgQ
 #: 00000003.xhp
 msgctxt ""
 "00000003.xhp\n"
 "par_id971529072633266\n"
 "help.text"
-msgid "<variable id=\"basiclibrarynote\">This library must be loaded before execution. Place the following statement before the first macro in your module:</variable>"
+msgid "<variable id=\"basiclibrarynote\">This library must be loaded before execution. Execute the following statement before running any macro that uses this library:</variable>"
 msgstr ""
 
 #. 8ipLK
diff --git a/source/sq/helpcontent2/source/text/sbasic/shared/03.po b/source/sq/helpcontent2/source/text/sbasic/shared/03.po
index ab55165d3a1..be3b5350507 100644
--- a/source/sq/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/sq/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-01-30 15:37+0100\n"
+"POT-Creation-Date: 2021-02-08 12:09+0100\n"
 "PO-Revision-Date: 2018-07-12 14:36+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -16,13 +16,13 @@ msgstr ""
 "X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1531406176.000000\n"
 
-#. QCGe5
+#. EziC4
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
 "tit\n"
 "help.text"
-msgid "ScriptForge Library"
+msgid "ScriptForge Libraries"
 msgstr ""
 
 #. NXPBo
@@ -79,6 +79,51 @@ msgctxt ""
 msgid "<literal>ScriptForge</literal> Basic library is available from %PRODUCTNAME 7.1 onwards."
 msgstr ""
 
+#. JYk4h
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id589160613700196\n"
+"help.text"
+msgid "ScriptForge services are organized in the following categories:"
+msgstr ""
+
+#. GUHWh
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id891611613601554\n"
+"help.text"
+msgid "%PRODUCTNAME Basic"
+msgstr ""
+
+#. DbtSH
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id891116610631554\n"
+"help.text"
+msgid "Document content"
+msgstr ""
+
+#. 5UQ7S
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id896111613601554\n"
+"help.text"
+msgid "User interface (UI)"
+msgstr ""
+
+#. GFE8W
+#: lib_ScriptForge.xhp
+msgctxt ""
+"lib_ScriptForge.xhp\n"
+"par_id681911613601554\n"
+"help.text"
+msgid "Utilities"
+msgstr ""
+
 #. BKpy6
 #: lib_ScriptForge.xhp
 msgctxt ""
@@ -871,13 +916,13 @@ msgctxt ""
 msgid "ScriptForge.Array service (SF_Array)"
 msgstr ""
 
-#. GRQ79
+#. DryH9
 #: sf_array.xhp
 msgctxt ""
 "sf_array.xhp\n"
 "bm_id781582391760253\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03/sf_array.xhp\" name=\"ScriptForge.Array Service\"><literal>ScriptForge</literal>.<literal>Array</literal> service</link>"
+msgid "<variable id=\"ArrayService\"><link href=\"text/sbasic/shared/03/sf_array.xhp\" name=\"ScriptForge.Array Service\"><literal>ScriptForge</literal>.<literal>Array</literal> service</link></variable>"
 msgstr ""
 
 #. SyLSL
@@ -2905,6 +2950,15 @@ msgctxt ""
 msgid "Methods"
 msgstr ""
 
+#. soCDf
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891611613601554\n"
+"help.text"
+msgid "List of Methods in the Calc Service"
+msgstr ""
+
 #. gaPo3
 #: sf_calc.xhp
 msgctxt ""
@@ -4264,6 +4318,1734 @@ msgctxt ""
 msgid "'Sort range based on columns A (ascending) and C (descending)"
 msgstr ""
 
+#. BC4Sc
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDialogs.Dialog service"
+msgstr ""
+
+#. LzQoS
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"dlg_h1\"><link href=\"text/sbasic/shared/03/sf_dialog.xhp\" name=\"SFDialogs.Dialog\"><literal>SFDialogs</literal>.<literal>Dialog</literal> service</link></variable>"
+msgstr ""
+
+#. ny8EV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id931583589764919\n"
+"help.text"
+msgid "The <literal>Dialog</literal> service contributes to the management of dialogs created with the Basic <link href=\"text/sbasic/guide/create_dialog.xhp\" name=\"Dialog Editor\">Dialog Editor</link>. Each instance of the current class represents a single dialog box displayed to the user."
+msgstr ""
+
+#. vxEvV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id831598110550771\n"
+"help.text"
+msgid "A dialog box can be displayed in modal or in non-modal modes."
+msgstr ""
+
+#. LVjBj
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id221598110444025\n"
+"help.text"
+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
+#: 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."
+msgstr ""
+
+#. GrpyR
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id721598110472337\n"
+"help.text"
+msgid "A dialog box disappears from memory after its explicit termination."
+msgstr ""
+
+#. asacX
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id891598188164936\n"
+"help.text"
+msgid "The <literal>SFDialogs.Dialog</literal> service is closely related to the <literal>SFDialogs.DialogControl</literal> service."
+msgstr ""
+
+#. CByHp
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation and usage"
+msgstr ""
+
+#. hZcuK
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id361598174756160\n"
+"help.text"
+msgid "The dialog service is invoked through the <literal>CreateScriptService</literal> method. It requires three arguments to specify the dialog box to activate:"
+msgstr ""
+
+#. Ntzqh
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id31612271944733\n"
+"help.text"
+msgid "<emph>Container</emph>: \"<link href=\"text/sbasic/shared/03131900.xhp\" name=\"GlobalScope specifier\"><literal>GlobalScope</literal></link>\" for preinstalled libraries or a window name as defined by <link href=\"text/sbasic/shared/03/sf_ui.xhp\" name=\"ScriptForge.UI\"><literal>ScriptForge.UI</literal></link> service. Empty string \"\" default value stands for the current document."
+msgstr ""
+
+#. juLgm
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id311612271947124\n"
+"help.text"
+msgid "<emph>Library</emph>: The case-sensitive name of a library contained in the container. Default value is \"Standard\"."
+msgstr ""
+
+#. FSp5N
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id821612271946316\n"
+"help.text"
+msgid "<emph>DialogName</emph>: A case-sensitive string designating the dialog."
+msgstr ""
+
+#. mqjFF
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id321598171269873\n"
+"help.text"
+msgid "'... controls initialization goes here..."
+msgstr ""
+
+#. yn6sy
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id471598176518738\n"
+"help.text"
+msgid "'Default mode = Modal"
+msgstr ""
+
+#. h9a9G
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id551598171288547\n"
+"help.text"
+msgid "'... Process controls and do what is needed here"
+msgstr ""
+
+#. ovpiH
+#: 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."
+msgstr ""
+
+#. XxoaB
+#: 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."
+msgstr ""
+
+#. nXGkZ
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd_id651583668365757\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. zVLEC
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id871583668386455\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. FBCFG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id491583668386455\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. ByVDE
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id271583668474014\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. 8AUBJ
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id401583668386455\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. iZZec
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id371583668519172\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. av994
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id771583668386455\n"
+"help.text"
+msgid "Value = 1. An OK button was pressed."
+msgstr ""
+
+#. GKcTG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id541583839708548\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. z4BZ4
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id731583839708412\n"
+"help.text"
+msgid "Value = 0. A Cancel button was pressed."
+msgstr ""
+
+#. cThsX
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id761584027709516\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 48bDT
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id971584027709752\n"
+"help.text"
+msgid "Specify the title of the dialog."
+msgstr ""
+
+#. 2pjyZ
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id31583839767743\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 3Rypn
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id111583839767195\n"
+"help.text"
+msgid "Specify the height of the dialog box."
+msgstr ""
+
+#. KD2zy
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id771583839920487\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. ABrxD
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id451583839920858\n"
+"help.text"
+msgid "Specifies if the dialog box is currently in execution in modal mode."
+msgstr ""
+
+#. sA5Nj
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id571588333908716\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. JoAYu
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id721588333908708\n"
+"help.text"
+msgid "The name of the dialog"
+msgstr ""
+
+#. jcbwB
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id501583774433513\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. Tfrah
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id151598177605296\n"
+"help.text"
+msgid "A dialog may have several pages that can be traversed by the user step by step. The Page property of the Dialog object defines which page of the dialog is active."
+msgstr ""
+
+#. FZG3n
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id271588334016191\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 3sRE5
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id251588334016874\n"
+"help.text"
+msgid "Specify if the dialog box is visible on the desktop. By default it is not visible until the Execute() method is run and visible afterwards."
+msgstr ""
+
+#. w6DwG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id451598177924437\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. W2CkE
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id191598177924897\n"
+"help.text"
+msgid "The UNO object representing the dialog model. Refer to <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XControlModel.html\" name=\"XControlModel interface\">XControlModel</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1awt_1_1UnoControlDialogModel-members.html\" name=\"css.awt.UnoControlDialogModel\">UnoControlDialogModel</link> in Application Programming Interface (API) documentation for detailed information."
+msgstr ""
+
+#. YFYi4
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id811598178083501\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. bmedG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id731598178083442\n"
+"help.text"
+msgid "The UNO object representing the dialog view. Refer to <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1awt_1_1XControlModel.html\" name=\"XControl interface\">XControl</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1awt_1_1UnoControlDialog-members.html\" name=\"UnoControlDialog interface\">UnoControlDialog</link> in Application Programming Interface (API) documentation for detailed information."
+msgstr ""
+
+#. gTQjc
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id921606472825856\n"
+"help.text"
+msgid "Methods"
+msgstr ""
+
+#. DiCyL
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id871583933076448\n"
+"help.text"
+msgid "Set the focus on the current <literal>Dialog</literal> instance. Return <literal>True</literal> if focusing was successful."
+msgstr ""
+
+#. 7QdPA
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id151598178880227\n"
+"help.text"
+msgid "This method is called from a dialog or control event, or when a dialog is displayed in non-modal mode."
+msgstr ""
+
+#. L9qDh
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd _id61583933076171\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
+msgstr ""
+
+#. iFcFd
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd _id26158393307687\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
+msgstr ""
+
+#. eYDfG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id841598179117184\n"
+"help.text"
+msgid "' Dialog stored in current document's standard library"
+msgstr ""
+
+#. 4qLn9
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id161584541257982\n"
+"help.text"
+msgid "Return either:"
+msgstr ""
+
+#. isSnB
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id421598179770993\n"
+"help.text"
+msgid "the list of the controls contained in the dialog"
+msgstr ""
+
+#. 4EuYK
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id81598185229301\n"
+"help.text"
+msgid "a dialog control class instance based on its name"
+msgstr ""
+
+#. 2RFtC
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd _id601584541257443\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functsyntax\"/>"
+msgstr ""
+
+#. 7PGuV
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd _id291584541257237\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functparameters\"/>"
+msgstr ""
+
+#. AEAHd
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.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 ""
+
+#. atHXa
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"hd _id32158454125769\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functexample\"/>"
+msgstr ""
+
+#. j8x9C
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id381598185776500\n"
+"help.text"
+msgid "Ends the display of a modal dialog and gives back the argument as return value for the current <literal>Execute()</literal> running action."
+msgstr ""
+
+#. gjvwy
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id551598185953362\n"
+"help.text"
+msgid "<literal>EndExecute()</literal> is usually contained in the processing of a macro triggered by a dialog or control event."
+msgstr ""
+
+#. BkuiE
+#: 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."
+msgstr ""
+
+#. FD9fr
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id29159818646178\n"
+"help.text"
+msgid "Display the dialog box and, when modal, wait for its termination by the user. The returned value is either:"
+msgstr ""
+
+#. PRCaG
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id541598186676277\n"
+"help.text"
+msgid "0 : <literal>Cancel</literal> button pressed"
+msgstr ""
+
+#. eCGBY
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id821598186716345\n"
+"help.text"
+msgid "1 : <literal>OK</literal> button pressed"
+msgstr ""
+
+#. MovhC
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id951598186738346\n"
+"help.text"
+msgid "Otherwise the dialog stopped with an <literal>EndExecute()</literal> statement issued by a dialog or control event"
+msgstr ""
+
+#. eBFXT
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id741598187335869\n"
+"help.text"
+msgid "For non-modal dialog boxes the method always returns 0 and the execution of the macro continues."
+msgstr ""
+
+#. KmiEw
+#: 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>."
+msgstr ""
+
+#. DxiPm
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id211598187104866\n"
+"help.text"
+msgid "' Dialog stored in current document's standard library"
+msgstr ""
+
+#. FrCG7
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"bas_id781612273203518\n"
+"help.text"
+msgid "End Select"
+msgstr ""
+
+#. DYy75
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id21598187953679\n"
+"help.text"
+msgid "Terminate the dialog service for the current instance. Return <literal>True</literal> if the termination was successful."
+msgstr ""
+
+#. BFfGX
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDialogs.DialogControl service"
+msgstr ""
+
+#. UBz5i
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"ctrls_h1\"><link href=\"text/sbasic/shared/03/sf_dialogcontrol.xhp\" name=\"SFDialogs.DialogControl service\"><literal>SFDialogs</literal>.<literal>DialogControl</literal> service</link></variable>"
+msgstr ""
+
+#. tZzKc
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id931583589764919\n"
+"help.text"
+msgid "The <literal>DialogControl</literal> service manages the controls belonging to a dialog defined with the Basic <link href=\"text/sbasic/guide/create_dialog.xhp\" name=\"Dialog Editor\">Dialog Editor</link>. Each instance of the current service represents a single control within a dialog box."
+msgstr ""
+
+#. 3oXnC
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bm_id331612167249331\n"
+"help.text"
+msgid "<bookmark_value>API;awt.XControl</bookmark_value>     <bookmark_value>API;awt.XControlModel</bookmark_value>"
+msgstr ""
+
+#. 7dDgL
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id701598191157426\n"
+"help.text"
+msgid "The focus is set on getting and setting the values displayed by the controls of the dialog box. Formatting is accessible via the <literal>XControlModel</literal> and <literal>XControlView</literal> properties."
+msgstr ""
+
+#. GqHgy
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id981598191184526\n"
+"help.text"
+msgid "Note that <literal>DialogControl.Value</literal> property content varies according to UNO control types."
+msgstr ""
+
+#. 9LpGF
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id891598188164936\n"
+"help.text"
+msgid "The <literal>SFDialogs.DialogControl</literal> service is closely related to the <link href=\"text/sbasic/shared/03/sf_dialog.xhp\" name=\"Dialog service\"><literal>SFDialogs.Dialog</literal></link> service."
+msgstr ""
+
+#. uGTGK
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. jKixF
+#: 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."
+msgstr ""
+
+#. WVG8J
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id961598453222539\n"
+"help.text"
+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 ""
+
+#. WKCuT
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id801598175242937\n"
+"help.text"
+msgid "' oControl represents now the instance of the Control class having triggered the current event"
+msgstr ""
+
+#. 75WJy
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id251598176312571\n"
+"help.text"
+msgid "Note that in previous examples, the prefix <literal>\"SFDialogs.\"</literal> may be omitted."
+msgstr ""
+
+#. F9uKj
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id71598455687512\n"
+"help.text"
+msgid "Control types"
+msgstr ""
+
+#. jKJBV
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id851598455863395\n"
+"help.text"
+msgid "The <literal>DialogControl</literal> service is available for these control types:"
+msgstr ""
+
+#. 7xddb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id651583668365757\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. 94RMV
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id871583668386455\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. eccsg
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id491583668386455\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. KRYNv
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id271583668474014\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. U9ZYU
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id291598538799794\n"
+"help.text"
+msgid "Applicable to"
+msgstr ""
+
+#. emDac
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id401583668386455\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. xNGhR
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id371583668519172\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. aTyMC
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id771583668386455\n"
+"help.text"
+msgid "Specifies if a command button has or not the behaviour of a Cancel button."
+msgstr ""
+
+#. Gft3Z
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id541583839708548\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. UXoyn
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id731583839708412\n"
+"help.text"
+msgid "Specifies the text associated with the control."
+msgstr ""
+
+#. Uo2SP
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id761584027709516\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. YKEAg
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id261598539120502\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. c5GAw
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id971584027709752\n"
+"help.text"
+msgid "One of the types listed above."
+msgstr ""
+
+#. veivJ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id31583839767743\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. y2irQ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id111583839767195\n"
+"help.text"
+msgid "Specifies whether a command button is the default (OK) button."
+msgstr ""
+
+#. GAdvJ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id771583839920487\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. tBmrq
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id891598539196786\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. 8S9xG
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id451583839920858\n"
+"help.text"
+msgid "Specifies if the control is accessible with the cursor."
+msgstr ""
+
+#. 2E9Cb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id571588333908716\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. DrmM6
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id491598539231618\n"
+"help.text"
+msgid "DateField, TimeField, FormattedField (read-only)"
+msgstr ""
+
+#. QbN5U
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id721588333908708\n"
+"help.text"
+msgid "Specifies the format used to display dates and times. It must be one these strings:"
+msgstr ""
+
+#. 5eRkE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.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 ""
+
+#. CDCLC
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id221598456991070\n"
+"help.text"
+msgid "For times: \"24h short\", \"24h long\", \"12h short\", \"12h long\"."
+msgstr ""
+
+#. nLCxq
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id501583774433513\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. LgGtA
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id151598177605296\n"
+"help.text"
+msgid "Specifies the number of rows in a list box or a combo box."
+msgstr ""
+
+#. kaaLt
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id271588334016191\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. JAmaD
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id251588334016874\n"
+"help.text"
+msgid "Specifies which item is selected in a list box or combo box."
+msgstr ""
+
+#. azv7C
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id961598457655506\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 6N6Eb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id2159845765568\n"
+"help.text"
+msgid "Specifies if the control is read-only."
+msgstr ""
+
+#. bubBB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id621598457951781\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. r83sC
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id821598457951782\n"
+"help.text"
+msgid "Specifies whether a user can make multiple selections in a listbox."
+msgstr ""
+
+#. BBJCw
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id351598458170114\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. uHsgi
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id151598539764402\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. HLjFU
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id621598458170392\n"
+"help.text"
+msgid "The name of the control."
+msgstr ""
+
+#. jSSnv
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id80159845835726\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 8GZkA
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id841598539781888\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. BdxvF
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id791598458357756\n"
+"help.text"
+msgid "A dialog may have several pages that can be traversed by the user step by step. The Page property of the Dialog object defines which page of the dialog is active."
+msgstr ""
+
+#. isrYW
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id441598458459145\n"
+"help.text"
+msgid "The Page property of a control defines the page of the dialog on which the control is visible."
+msgstr ""
+
+#. Cj3Kq
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id161598458580581\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 6EFh7
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id921598458580608\n"
+"help.text"
+msgid "<literal>Dialog</literal><br/>service"
+msgstr ""
+
+#. SDCx4
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id181598539807426\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. sqEuV
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id801598458580456\n"
+"help.text"
+msgid "The parent <literal>SFDialogs.Dialog</literal> class object instance."
+msgstr ""
+
+#. GTGu9
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id971598458773352\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. LP96H
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.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 specified control. The filename must comply with the <literal>FileNaming</literal> attribute of the <literal>ScriptForge.FileSystem</literal> service."
+msgstr ""
+
+#. PqsSY
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id401598516577225\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. AciNr
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id311598516577712\n"
+"help.text"
+msgid "Specifies the data contained in a combobox or a listbox."
+msgstr ""
+
+#. q532w
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id781598516764550\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 4h8VF
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id11159851676440\n"
+"help.text"
+msgid "Gives access to the text being displayed by the control."
+msgstr ""
+
+#. We5gv
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id411598517275112\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. EijF2
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id171598539985022\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. CbBZJ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id651598517275384\n"
+"help.text"
+msgid "Specifies the text that appears as a tooltip when you hold the mouse pointer over the control."
+msgstr ""
+
+#. kVtki
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id821598517418463\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. ZemBe
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id141598517418822\n"
+"help.text"
+msgid "Specifies if the checkbox control may appear dimmed (grayed) or not."
+msgstr ""
+
+#. BDWA7
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id701598517671373\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. fk87j
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id991598517671916\n"
+"help.text"
+msgid "Read below."
+msgstr ""
+
+#. PqKgo
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id661598517730941\n"
+"help.text"
+msgid "No"
+msgstr ""
+
+#. 8r3sG
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id761598540042290\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. xLL83
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id881598517730836\n"
+"help.text"
+msgid "Specifies if the control is hidden or visible."
+msgstr ""
+
+#. Xw6X9
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id451598177924437\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. dBNCA
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id94159817792441\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. gbjHB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id311598540066789\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. F8rNE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.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_1UnoControlDialogModel.html)\" name=\"awt.XControlDialogModel\">UnoControlDialogModel</link> in Application Programming Interface (API) documentation for detailed information."
+msgstr ""
+
+#. xfhaP
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id811598178083501\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. o2H9W
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id981598178083938\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. rrwm6
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id551598540079329\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. ZM6sk
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.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_1UnoControlDialog.html)\" name=\"awt.UnoControlDialog\">UnoControlDialog</link> in Application Programming Interface (API) documentation for detailed information."
+msgstr ""
+
+#. agJv5
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id81598540704978\n"
+"help.text"
+msgid "The Value property"
+msgstr ""
+
+#. JHK7w
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id10159854325492\n"
+"help.text"
+msgid "Control type"
+msgstr ""
+
+#. 33wWa
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id741598543254158\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. QLVMB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id961598543254444\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. BhCNv
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id461598543254494\n"
+"help.text"
+msgid "Button"
+msgstr ""
+
+#. jEyx9
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id741598543254108\n"
+"help.text"
+msgid "For toggle buttons only"
+msgstr ""
+
+#. uhGBX
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id131598543254931\n"
+"help.text"
+msgid "CheckBox"
+msgstr ""
+
+#. gCWiY
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id741598543254376\n"
+"help.text"
+msgid "Boolean or Integer"
+msgstr ""
+
+#. 7GZGS
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id521598543254630\n"
+"help.text"
+msgid "0, False: not checked<br/>1, True: checked<br/>2: grayed, don't know"
+msgstr ""
+
+#. 6zkoD
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id891598543254563\n"
+"help.text"
+msgid "ComboBox"
+msgstr ""
+
+#. nZVA5
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id331598543254947\n"
+"help.text"
+msgid "The selected value. The <literal>ListIndex</literal> property is an alternate option."
+msgstr ""
+
+#. xEYCn
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id58159854325446\n"
+"help.text"
+msgid "CurrencyField"
+msgstr ""
+
+#. MWkEW
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id5159854325443\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. 6iwGG
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id241598543254415\n"
+"help.text"
+msgid "DateField"
+msgstr ""
+
+#. B47pw
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id851598543254508\n"
+"help.text"
+msgid "FileControl"
+msgstr ""
+
+#. kgfXR
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.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 ""
+
+#. wDWNN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id921598543254323\n"
+"help.text"
+msgid "FormattedField"
+msgstr ""
+
+#. 9NVHN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id221598543254760\n"
+"help.text"
+msgid "String or Numeric"
+msgstr ""
+
+#. uhxwf
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id151598543254318\n"
+"help.text"
+msgid "ListBox"
+msgstr ""
+
+#. 53Ztp
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id42159854325422\n"
+"help.text"
+msgid "String or array of strings"
+msgstr ""
+
+#. 9NwJs
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id601598543254780\n"
+"help.text"
+msgid "The selected row(s) as a scalar or as an array depending on the <literal>MultiSelect</literal> attribute"
+msgstr ""
+
+#. XfuWw
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id771598543254973\n"
+"help.text"
+msgid "NumericField"
+msgstr ""
+
+#. tFGhf
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id461598543254909\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. zDgKW
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id38159854325480\n"
+"help.text"
+msgid "PatternField"
+msgstr ""
+
+#. GAk8n
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id951598543254998\n"
+"help.text"
+msgid "ProgressBar"
+msgstr ""
+
+#. YvPAp
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id631598543254771\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. fBArb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id91598543254766\n"
+"help.text"
+msgid "Must be within the predefined bounds"
+msgstr ""
+
+#. 6SESE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id791598543254779\n"
+"help.text"
+msgid "RadioButton"
+msgstr ""
+
+#. ZragT
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id851598543254624\n"
+"help.text"
+msgid "Each button has its own name. They are linked together if their TAB positions are contiguous. If a radiobutton is set to <literal>True</literal>, the other related buttons are automatically set to <literal>False</literal>"
+msgstr ""
+
+#. TWNd4
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id141598543254361\n"
+"help.text"
+msgid "ScrollBar"
+msgstr ""
+
+#. m6Uyb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id531598543254869\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. MWdGb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id21598543254994\n"
+"help.text"
+msgid "Must be within the predefined bounds"
+msgstr ""
+
+#. UDnLw
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id811598543254140\n"
+"help.text"
+msgid "TextField"
+msgstr ""
+
+#. a9AMF
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id441598543254738\n"
+"help.text"
+msgid "The text appearing in the field"
+msgstr ""
+
+#. GoB7K
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id89159854325478\n"
+"help.text"
+msgid "TimeField"
+msgstr ""
+
+#. YFbGT
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"hd_id421583670049913\n"
+"help.text"
+msgid "Methods"
+msgstr ""
+
+#. xNrc5
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id891611613601554\n"
+"help.text"
+msgid "List of Methods in the DialogControl Service"
+msgstr ""
+
+#. 3oU3L
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id871583933076448\n"
+"help.text"
+msgid "Set the focus on the control. Return <literal>True</literal> if focusing was successful."
+msgstr ""
+
+#. 6YvuU
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id151598178880227\n"
+"help.text"
+msgid "This method is often called from a dialog or control event."
+msgstr ""
+
+#. B7sAb
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id841598179117184\n"
+"help.text"
+msgid "'Dialog stored in current document's standard library"
+msgstr ""
+
+#. HNmmm
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id671598619892378\n"
+"help.text"
+msgid "Add a new line at the end of a multiline text field. A newline character will be inserted when appropriate. The method returns <literal>True</literal> when successful."
+msgstr ""
+
+#. D29nu
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id941598619892915\n"
+"help.text"
+msgid "An error is raised if the actual control is not of the type <literal>TextField</literal> or is not multiline."
+msgstr ""
+
+#. MwNhE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257789\n"
+"help.text"
+msgid "<emph>Line</emph> : The string to insert. Default = an empty line."
+msgstr ""
+
 #. opNus
 #: sf_dictionary.xhp
 msgctxt ""
@@ -5092,13 +6874,13 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. oAb9W
+#. QEZC4
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id581582885655885\n"
 "help.text"
-msgid "Returns a <literal>ScriptForge.Dictionary</literal> object. After update, can be passed again to the property for updating the document.<br/>Individual items of the dictionary may be either strings, numbers, (Basic) dates or <link href=\"https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1util_1_1Duration.html\" name=\"Duration API\"><literal>com.sun.star.util.Duration</literal></link> items."
+msgid "Returns a <literal>ScriptForge.Dictionary</literal> object instance. After update, can be passed again to the property for updating the document.<br/>Individual items of the dictionary may be either strings, numbers, (Basic) dates or <link href=\"https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1util_1_1Duration.html\" name=\"Duration API\"><literal>com.sun.star.util.Duration</literal></link> items."
 msgstr ""
 
 #. DktDb
@@ -5110,15 +6892,6 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. io4nc
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id131582886030297\n"
-"help.text"
-msgid "String"
-msgstr ""
-
 #. DNFGz
 #: sf_document.xhp
 msgctxt ""
@@ -5137,15 +6910,6 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. BnU6j
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id271582886791111\n"
-"help.text"
-msgid "Dictionary"
-msgstr ""
-
 #. Mm6E5
 #: sf_document.xhp
 msgctxt ""
@@ -5164,15 +6928,6 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. 9SCCU
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id951589194571781\n"
-"help.text"
-msgid "String"
-msgstr ""
-
 #. Aw2Tv
 #: sf_document.xhp
 msgctxt ""
@@ -5191,15 +6946,6 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. eB7RX
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id741589194633956\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
 #. pSbRu
 #: sf_document.xhp
 msgctxt ""
@@ -5218,15 +6964,6 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. 2wzEy
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id421589194910942\n"
-"help.text"
-msgid "String"
-msgstr ""
-
 #. CDTBC
 #: sf_document.xhp
 msgctxt ""
@@ -5245,15 +6982,6 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. JZ8g8
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id501589638614132\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
 #. JGTQz
 #: sf_document.xhp
 msgctxt ""
@@ -5272,15 +7000,6 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. KC8FF
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id551589195028724\n"
-"help.text"
-msgid "String"
-msgstr ""
-
 #. 99ZxC
 #: sf_document.xhp
 msgctxt ""
@@ -5299,15 +7018,6 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. KNpBA
-#: sf_document.xhp
-msgctxt ""
-"sf_document.xhp\n"
-"par_id31589195028773\n"
-"help.text"
-msgid "String"
-msgstr ""
-
 #. TCiBh
 #: sf_document.xhp
 msgctxt ""
@@ -5326,6 +7036,15 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
+#. PRmJE
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id371582885195525\n"
+"help.text"
+msgid "UNO Object"
+msgstr ""
+
 #. 9TNH3
 #: sf_document.xhp
 msgctxt ""
@@ -6226,6 +7945,2211 @@ msgctxt ""
 msgid "However, when a warning is raised, <emph>the macro execution is not stopped</emph>."
 msgstr ""
 
+#. gn6AM
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"tit\n"
+"help.text"
+msgid "ScriptForge.String service (SF_String)"
+msgstr ""
+
+#. mqmxD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id521580038927003\n"
+"help.text"
+msgid "<variable id=\"CalcService\"><link href=\"text/sbasic/shared/03/sf_string.xhp\" name=\"Calc service\"><literal>ScriptForge</literal>.<literal>String</literal> service</link></variable>"
+msgstr ""
+
+#. yaisH
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id351579602570526\n"
+"help.text"
+msgid "The <literal>String</literal> service provides a collection of methods for string processing. These methods can be used to:"
+msgstr ""
+
+#. oNvbV
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611611952070366\n"
+"help.text"
+msgid "Validate the contents of strings"
+msgstr ""
+
+#. UmFAv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611611952070376\n"
+"help.text"
+msgid "Format strings by trimming, justifying or wrapping their contents"
+msgstr ""
+
+#. EZKAi
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611611952070367\n"
+"help.text"
+msgid "Use regular expressions to search and replace substrings"
+msgstr ""
+
+#. D2qPU
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611611952070368\n"
+"help.text"
+msgid "Apply hash algorithms on strings, etc."
+msgstr ""
+
+#. Nd4es
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id961579603699855\n"
+"help.text"
+msgid "Definitions"
+msgstr ""
+
+#. dQjPv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id441579603838777\n"
+"help.text"
+msgid "Line breaks"
+msgstr ""
+
+#. ePyj2
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id791611946942340\n"
+"help.text"
+msgid "The <literal>String</literal> service recognizes the following line breaks:"
+msgstr ""
+
+#. o2TiZ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151611947117831\n"
+"help.text"
+msgid "Symbolic name"
+msgstr ""
+
+#. fEbm9
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721611947117831\n"
+"help.text"
+msgid "ASCII number"
+msgstr ""
+
+#. yqVHd
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id761611947117831\n"
+"help.text"
+msgid "Line feed<br/>             Vertical tab<br/>             Carriage return<br/>             Line feed + Carriage return<br/>             File separator<br/>             Group separator<br/>             Record separator<br/>             Next line<br/>             Line separator<br/>             Paragraph separator"
+msgstr ""
+
+#. WCvgW
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id161579604225813\n"
+"help.text"
+msgid "Whitespaces"
+msgstr ""
+
+#. mFfbq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id401611948279056\n"
+"help.text"
+msgid "The <literal>String</literal> service recognizes the following whitespaces:"
+msgstr ""
+
+#. U3GSy
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151611947117893\n"
+"help.text"
+msgid "Symbolic name"
+msgstr ""
+
+#. ZsSFF
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721611947117855\n"
+"help.text"
+msgid "ASCII number"
+msgstr ""
+
+#. TXAFP
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id761611947117835\n"
+"help.text"
+msgid "Space<br/>             Horizontal tab<br/>             Line feed<br/>             Vertical tab<br/>             Form feed<br/>             Carriage return<br/>             Next line<br/>             No-break space<br/>             Line separator<br/>             Paragraph separator"
+msgstr ""
+
+#. UPByW
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id191580480825160\n"
+"help.text"
+msgid "Escape sequences"
+msgstr ""
+
+#. JD6CK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id971611949145057\n"
+"help.text"
+msgid "Below is a list of escape sequences that can be used in strings."
+msgstr ""
+
+#. D4DjE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151611947117287\n"
+"help.text"
+msgid "Escape Sequence"
+msgstr ""
+
+#. xzDai
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721611947117732\n"
+"help.text"
+msgid "Symbolic name"
+msgstr ""
+
+#. rrxV4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721611947117144\n"
+"help.text"
+msgid "ASCII number"
+msgstr ""
+
+#. RDZhY
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id771611948706049\n"
+"help.text"
+msgid "\\n <br/> \\r <br/> \\t"
+msgstr ""
+
+#. fS24a
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id761611947119834\n"
+"help.text"
+msgid "Line feed<br/>             Carriage return<br/>             Horizontal tab"
+msgstr ""
+
+#. 6cwNJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id251611949474763\n"
+"help.text"
+msgid "To have the escape sequence \"\\n\" interpreted as an actual string, simply use \"\\\\n\" instead of \"\\\" & Chr(10)."
+msgstr ""
+
+#. AYQbH
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id771579606799550\n"
+"help.text"
+msgid "Non-printable characters:"
+msgstr ""
+
+#. WXEDi
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id531579606877342\n"
+"help.text"
+msgid "Characters defined in the Unicode Character Database as “Other” or “Separator” are considered as non-printable characters."
+msgstr ""
+
+#. EsBdD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id221611949584320\n"
+"help.text"
+msgid "Control characters (ascii code <= 0x1F) are also considered as non-printable."
+msgstr ""
+
+#. GfNfK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id661579604944268\n"
+"help.text"
+msgid "Quotes inside strings:"
+msgstr ""
+
+#. 6KLF9
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id551579605035332\n"
+"help.text"
+msgid "To add quotes in strings use \\' (single quote) or \\\" (double quote). For example:"
+msgstr ""
+
+#. BKoHN
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id201611949691285\n"
+"help.text"
+msgid "The string <literal>[str\\'i\\'ng]</literal> is interpreted as <literal>[str'i'ng]</literal>"
+msgstr ""
+
+#. eRosR
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id201611949691323\n"
+"help.text"
+msgid "The string <literal>[str\\\"i\\\"ng]</literal> is interpreted as <literal>[str\"i\"ng]</literal>"
+msgstr ""
+
+#. FtzhT
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id201586594659135\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. 4WFve
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id141609955500101\n"
+"help.text"
+msgid "Before using the <literal>ScriptForge.String</literal> service the <literal>ScriptForge</literal> library needs to be loaded using:"
+msgstr ""
+
+#. tSsDx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id63158659509728\n"
+"help.text"
+msgid "The following code snippets show the three ways to call methods in the <literal>String</literal> service (the <literal>ExpandTabs</literal> method is used as an example):"
+msgstr ""
+
+#. GfEcK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id651584978211886\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. PGBk4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id241611950267068\n"
+"help.text"
+msgid "The <literal>SF_String</literal> object provides the following properties:"
+msgstr ""
+
+#. FDjPb
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id271584978211792\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. HGYbF
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id241584978211550\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. 5qXzL
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id621584978211403\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 6DG3u
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id71584978715562\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. YJA6w
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581584978715701\n"
+"help.text"
+msgid "Carriage return: Chr(13)"
+msgstr ""
+
+#. NCbTs
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id211584978211383\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. xht7K
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id691584978211774\n"
+"help.text"
+msgid "Carriage return + Linefeed: Chr(13) & Chr(10)"
+msgstr ""
+
+#. ennLs
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id671584978666689\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. pdykp
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id951584978666296\n"
+"help.text"
+msgid "Linefeed: Chr(10)"
+msgstr ""
+
+#. TTF6v
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id421584978666327\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 9djV3
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id901584978666158\n"
+"help.text"
+msgid "Carriage return + Linefeed, which can be<br/>1) Chr(13) & Chr(10) or                  <br/>2) Linefeed: Chr(10)                  <br/>depending on the operating system."
+msgstr ""
+
+#. EMV7g
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id541584978666991\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. VrjGQ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id741584978666508\n"
+"help.text"
+msgid "Horizontal tabulation: Chr(9)"
+msgstr ""
+
+#. Ee5CF
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id461584978880380\n"
+"help.text"
+msgid "You can use the properties above to identify or insert the corresponding characters inside strings. For example, the Linefeed can be replaced by <literal>SF_String.sfLF</literal>."
+msgstr ""
+
+#. WSwjJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151611951803163\n"
+"help.text"
+msgid "The first argument of most methods is the string to be considered. It is always passed by reference and left unchanged. Methods such as Capitalize, Escape, etc return a new string after their execution."
+msgstr ""
+
+#. jaBZR
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id271579683706571\n"
+"help.text"
+msgid "Capitalizes the first character from each word in the input string."
+msgstr ""
+
+#. ABfrm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id941582304592013\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be capitalized."
+msgstr ""
+
+#. YLZDS
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bm_id421582384432626\n"
+"help.text"
+msgid "<bookmark_value>String service;Count</bookmark_value>"
+msgstr ""
+
+#. Uf2TJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"hd_id1001582384527265\n"
+"help.text"
+msgid "Count"
+msgstr ""
+
+#. DB982
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id891582384556756\n"
+"help.text"
+msgid "Counts the number of occurrences of a substring or a regular expression within a string."
+msgstr ""
+
+#. tvxcg
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id571582384689863\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The input string to be examined"
+msgstr ""
+
+#. 97Asr
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id601582384696486\n"
+"help.text"
+msgid "<emph>Substring</emph>: The substring or the regular expression to be used during search"
+msgstr ""
+
+#. i5aBr
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id451582384703719\n"
+"help.text"
+msgid "<emph>IsRegex</emph>: Use <literal>True</literal> if the substring is a regular expression (default = <literal>False</literal>)"
+msgstr ""
+
+#. fxSHM
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id141582384726168\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>"
+msgstr ""
+
+#. QcE5q
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id371582384749769\n"
+"help.text"
+msgid "'Counts the occurrences of the substring \"or\" inside the input string (returns 2)"
+msgstr ""
+
+#. XXCR4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id561582384801586\n"
+"help.text"
+msgid "'Counts the number of words with only lowercase letters (returns 7)"
+msgstr ""
+
+#. aJNDg
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id131612223767126\n"
+"help.text"
+msgid "To learn more about regular expressions, refer to the Python's documentation on <link href=\"https://docs.python.org/3/library/re.html\" name=\"Regular expressions\">Regular Expression Operations</link>."
+msgstr ""
+
+#. CCzMc
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581579687739629\n"
+"help.text"
+msgid "Returns <literal>True</literal> if a string ends with a specified substring."
+msgstr ""
+
+#. cAmFW
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id21612306392239\n"
+"help.text"
+msgid "The function returns <literal>False</literal> when either the string or the substring have a length = 0 or when the substring is longer than the string."
+msgstr ""
+
+#. xsyiT
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id191579861552201\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be tested."
+msgstr ""
+
+#. B5JDX
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id211579861561473\n"
+"help.text"
+msgid "<emph>Substring</emph>: The substring to be searched at the end of <literal>InputStr</literal>."
+msgstr ""
+
+#. WfUif
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id801579861574009\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: The comparison can be case sensitive or not (default = <literal>False</literal>)."
+msgstr ""
+
+#. gn2F8
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id811579862998452\n"
+"help.text"
+msgid "'Returns True because the method was called with the default CaseSensitive = False"
+msgstr ""
+
+#. vJDmx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id231579863168747\n"
+"help.text"
+msgid "'Returns False due to the CaseSensitive parameter"
+msgstr ""
+
+#. zThMM
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id921585921441429\n"
+"help.text"
+msgid "Converts linebreaks and tabs contained in the input string to their equivalent escaped sequence (\\\\, \\n, \\r, \\t)."
+msgstr ""
+
+#. KH5Qh
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id9158592144110\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be converted."
+msgstr ""
+
+#. cpLKD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id901585921441483\n"
+"help.text"
+msgid "'Returns the string \"abc\\n\\tdef\\\\n\""
+msgstr ""
+
+#. ADN8M
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id271579868053137\n"
+"help.text"
+msgid "Replaces Tab characters <literal>Chr(9)</literal> by space characters to replicate the behavior of tab stops."
+msgstr ""
+
+#. Eb23Z
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id951579868064344\n"
+"help.text"
+msgid "If a line break is found, a new line is started and the character counter is reset."
+msgstr ""
+
+#. da5NH
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id231579868290408\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be expanded"
+msgstr ""
+
+#. J3oNq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id281579868299807\n"
+"help.text"
+msgid "<emph>TabSize</emph>: This parameter is used to determine the Tab stops using the formula: TabSize + 1, 2 * TabSize + 1 , ... N * TabSize + 1 (default = 8)"
+msgstr ""
+
+#. GUoE8
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id161579874552729\n"
+"help.text"
+msgid "Replaces all non-printable characters in the input string by a given character."
+msgstr ""
+
+#. bJBrE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id431579874633865\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be searched"
+msgstr ""
+
+#. jH4n8
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id31579874656437\n"
+"help.text"
+msgid "<emph>ReplacedBy</emph>: Zero, one or more characters that will replace all non-printable charaters in <literal>InputStr</literal> (Default = \"\")"
+msgstr ""
+
+#. W44TL
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id1001579876228707\n"
+"help.text"
+msgid "Finds in a string a substring matching a given regular expression."
+msgstr ""
+
+#. FK83s
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id131579876314120\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be searched"
+msgstr ""
+
+#. pEWGm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id751579876371545\n"
+"help.text"
+msgid "<emph>Regex</emph>: The regular expression"
+msgstr ""
+
+#. 5dD3S
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id881579876394584\n"
+"help.text"
+msgid "<emph>Start</emph>: The position in the string where the search will begin. This parameter is passed by reference, so after execution the value of Start will point to the first character of the found substring. If no matching substring is found, Start will be set to 0."
+msgstr ""
+
+#. 8ACCG
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id251579876403831\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>"
+msgstr ""
+
+#. y5jTA
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id841579876412287\n"
+"help.text"
+msgid "<emph>Forward</emph>: Determines the direction of the search. If <literal>True</literal>, search moves forward. If <literal>False</literal> search moves backwards (Default = <literal>True</literal>)"
+msgstr ""
+
+#. 6Qzy2
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id451612309155653\n"
+"help.text"
+msgid "At the first iteration, if <literal>Forward = True</literal>, then Start should be equal to 1, whereas if <literal>Forward = False</literal> then Start should be equal to <literal>Len(InputStr)</literal>"
+msgstr ""
+
+#. gv3oo
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id221612309579001\n"
+"help.text"
+msgid "In the example above, the new value of <literal>lStart</literal> can be used to keep searching the same input string by setting the <literal>Start</literal> parameter to <literal>lStart + Len(result)</literal> at the next iteration."
+msgstr ""
+
+#. qAkN4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id471601048983628\n"
+"help.text"
+msgid "Hash functions are used inside some cryptographic algorithms, in digital signatures, message authentication codes, manipulation detection, fingerprints, checksums (message integrity check), hash tables, password storage and much more."
+msgstr ""
+
+#. LsuGS
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id301601048983765\n"
+"help.text"
+msgid "The <literal>HashStr</literal> method returns the result of a hash function applied on a given string and using a scpecified algorithm, as a string of lowercase hexadecimal digits."
+msgstr ""
+
+#. ZRZEF
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id631601048983149\n"
+"help.text"
+msgid "The hash algorithms supported are: <literal>MD5</literal>, <literal>SHA1</literal>, <literal>SHA224</literal>, <literal>SHA256</literal>, <literal>SHA384</literal> and <literal>SHA512</literal>."
+msgstr ""
+
+#. xWGnD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id621601048983210\n"
+"help.text"
+msgid "<emph>InputStr</emph> : The string to hash. It is presumed to be encoded in UTF-8. The hashing algorithm will consider the string as a stream of bytes."
+msgstr ""
+
+#. krqwK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id941601048983822\n"
+"help.text"
+msgid "<emph>Algorithm</emph> : One of the supported algorithms listed above, passed as a string."
+msgstr ""
+
+#. TXGmB
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id221579879516929\n"
+"help.text"
+msgid "Encodes the input string into the HTML character codes, replacing special characters by their <literal>&</literal> counterparts."
+msgstr ""
+
+#. YNfid
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id341612351999692\n"
+"help.text"
+msgid "For example, the character <literal>é</literal> would be replaced by <literal>&eacute;</literal> or an equivalent numerical HTML code."
+msgstr ""
+
+#. 2SAZB
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id501579879570781\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to encode"
+msgstr ""
+
+#. jpv97
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id171579880990533\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the input string is a valid date according to a specified date format."
+msgstr ""
+
+#. rhVGc
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151579881091821\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>"
+msgstr ""
+
+#. J4E4L
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id991579881107670\n"
+"help.text"
+msgid "<emph>DateFormat</emph>: The date format, as a string. It can be either \"YYYY-MM-DD\" (default), \"DD-MM-YYYY\" or \"MM-DD-YYYY\""
+msgstr ""
+
+#. GvZLC
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id291579881117126\n"
+"help.text"
+msgid "The dash (-) may be replaced by a dot (.), a slash (/) or a space."
+msgstr ""
+
+#. yCA3T
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id51579881125801\n"
+"help.text"
+msgid "If the format is invalid, the method returns <literal>False</literal>."
+msgstr ""
+
+#. qFmWW
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id211612370427721\n"
+"help.text"
+msgid "This method checks the format of the input string without performing any calendar-specific checks. Hence it does not test the input string for leap years or months with 30 or 31 days. For that, refer to the <link href=\"text/sbasic/shared/03102300.xhp\" name=\"IsDate function\"><literal>IsDate</literal> built-in function</link>."
+msgstr ""
+
+#. DJQFQ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id181612371147364\n"
+"help.text"
+msgid "The example below shows the difference between the methods <literal>IsADate</literal> (ScriptForge) and the <literal>IsDate</literal> (built-in) function."
+msgstr ""
+
+#. hAADi
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id161579881600317\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are alphabetic."
+msgstr ""
+
+#. Cpeo3
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id251579881615469\n"
+"help.text"
+msgid "Alphabetic characters are those characters defined in the <link href=\"https://unicode.org/reports/tr44/\" name=\"Unicode documentation\">Unicode Character Database</link> as <literal>Letter</literal>."
+msgstr ""
+
+#. CLTDC
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id11579881691826\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked.  If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. KaLGv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id421579883181382\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are alphabetic, digits or \"_\" (underscore). The first character must not be a digit."
+msgstr ""
+
+#. LLCAz
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id31579884464101\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. qAZpA
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id671580039484786\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are Ascii characters."
+msgstr ""
+
+#. AR4hr
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id791580039528838\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. iuPF4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id861580044805749\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are digits."
+msgstr ""
+
+#. njKib
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id41580044873043\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. J8Ykx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id521580045221758\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid email address."
+msgstr ""
+
+#. DFTVq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id841580045280071\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. R6MsU
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id41580047039666\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid filename in a given operating system."
+msgstr ""
+
+#. VEp6E
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id801580047079938\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. j3yDJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id781580047088954\n"
+"help.text"
+msgid "<emph>OSName</emph>: The operating system name, as a string. It can be WINDOWS, LINUX, MACOSX or SOLARIS."
+msgstr ""
+
+#. GnrxA
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id991612372824234\n"
+"help.text"
+msgid "The default value is the current operating system on which the script is running."
+msgstr ""
+
+#. FPuAV
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id911580047551929\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are hexadecimal digits."
+msgstr ""
+
+#. WqaBe
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id331580047594144\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. kEz4y
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id521612377109554\n"
+"help.text"
+msgid "The hexadecimal digits may be prefixed with \"0x\" or \"&H\"."
+msgstr ""
+
+#. CcTNk
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id791580048420941\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid IP(v4) address."
+msgstr ""
+
+#. m9byA
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id981580048466565\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. yWHew
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id831580049093038\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the whole input string matches a given pattern containing wildcards."
+msgstr ""
+
+#. GDhnV
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id141580049142548\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. DnQC9
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id31580049154551\n"
+"help.text"
+msgid "<emph>Pattern</emph>: The pattern as a string. Wildcard are:"
+msgstr ""
+
+#. ZCzDP
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id181612441703306\n"
+"help.text"
+msgid "\"?\" represents any single character;"
+msgstr ""
+
+#. CFPcW
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id861612377611438\n"
+"help.text"
+msgid "\"*\" represents zero, one, or multiple characters."
+msgstr ""
+
+#. CntsV
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id991580049206617\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>."
+msgstr ""
+
+#. kSMmn
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581580050048679\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are in lowercase. Non-alphabetic characters are ignored."
+msgstr ""
+
+#. nWGvX
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id751580050122938\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. BzD3y
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id231580051650488\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are printable."
+msgstr ""
+
+#. XjiTs
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721580051706431\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. HYBp5
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id281580052400960\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the whole input string matches a given regular expression."
+msgstr ""
+
+#. eaFWB
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id161580052454770\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. AVFYQ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581580052467973\n"
+"help.text"
+msgid "<emph>Regex</emph>: The regular expression. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. FvYsk
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id621580052654341\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>."
+msgstr ""
+
+#. iZSEw
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id1001589460240467\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the input string is a valid Calc sheet name."
+msgstr ""
+
+#. oFBzi
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id671589460240552\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. uE5gz
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id551612442002823\n"
+"help.text"
+msgid "A sheet name must not contain the characters [ ] * ? : / \\ or the character ' (apostrophe) as first or last character."
+msgstr ""
+
+#. ALdgg
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id371580293093655\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the first character of every word is in uppercase and the other characters are in lowercase."
+msgstr ""
+
+#. iiBCT
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id471580293142283\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. 7Ryzp
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id801580128672004\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are in uppercase. Non alphabetic characters are ignored."
+msgstr ""
+
+#. N7DBZ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id391580128736809\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. BTRpG
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id531580132067813\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid absolute URL (Uniform Resource Locator) address. Only the http, https and ftp protocols are supported."
+msgstr ""
+
+#. NdBfD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id321580132113593\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. wBAqG
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id41580132491698\n"
+"help.text"
+msgid "Returns <literal>True</literal> if all characters in the string are whitespaces"
+msgstr ""
+
+#. DRDP8
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id801580132535511\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. 7EBbA
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id891580133307100\n"
+"help.text"
+msgid "Returns the input string center-justified."
+msgstr ""
+
+#. ycGFR
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id571612380829021\n"
+"help.text"
+msgid "The leading and trailing white spaces are stripped and the remaining characters are completed left and right up to a specified total <literal>Length</literal> with the character <literal>Padding</literal>."
+msgstr ""
+
+#. 9aW5U
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id911580133391827\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be center-justified. If empty, the method returns an empty string."
+msgstr ""
+
+#. RXgZr
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id671580133694946\n"
+"help.text"
+msgid "<emph>Length</emph>: The length of the resulting string (default = the length of the input string)."
+msgstr ""
+
+#. A3qof
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id511612381090109\n"
+"help.text"
+msgid "If the specified length is shorter than the center-justified input string, then the returned string is truncated."
+msgstr ""
+
+#. LEKsf
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id101580133705268\n"
+"help.text"
+msgid "<emph>Padding</emph>: The single character to be used as padding (default = the Ascii space \" \")."
+msgstr ""
+
+#. 4zk3p
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id911580135466348\n"
+"help.text"
+msgid "Returns the input string left-justified."
+msgstr ""
+
+#. GbAcR
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id431612381917641\n"
+"help.text"
+msgid "The leading white spaces are stripped and the remaining characters are completed to the right up to a specified total <literal>Length</literal> with the character <literal>Padding</literal>."
+msgstr ""
+
+#. rPfqE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id281580135523448\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be left-justified. If empty, the method returns an empty string."
+msgstr ""
+
+#. tUCdj
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id431580135534910\n"
+"help.text"
+msgid "<emph>Length</emph>: The length of the resulting string (default = the length of the input string)."
+msgstr ""
+
+#. ntKXx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id161612381664182\n"
+"help.text"
+msgid "If the specified length is shorter than the left-justified input string, then the returned string is truncated."
+msgstr ""
+
+#. BrEAS
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id221580135568475\n"
+"help.text"
+msgid "<emph>Padding</emph>: The single character to be used as padding (default = the Ascii space \" \")."
+msgstr ""
+
+#. TTokb
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id821580136091225\n"
+"help.text"
+msgid "Returns the input string right-justified."
+msgstr ""
+
+#. PPcZT
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id771612382000293\n"
+"help.text"
+msgid "The leading white spaces are stripped and the remaining characters are completed to the left up to a specified total <literal>Length</literal> with the character <literal>Padding</literal>."
+msgstr ""
+
+#. MzFoN
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id201580136154170\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be right-justified. If empty, the method returns an empty string."
+msgstr ""
+
+#. uM4Xm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id71580136164632\n"
+"help.text"
+msgid "<emph>Length</emph>: The length of the resulting string (default = the length of the input string)."
+msgstr ""
+
+#. dshKE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id191612381732163\n"
+"help.text"
+msgid "If the specified length is shorter than the right-justified input string, then the returned string is truncated."
+msgstr ""
+
+#. f9BKD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id751580136200680\n"
+"help.text"
+msgid "<emph>Padding</emph>: The single character to be used as padding (default = the Ascii space \" \")."
+msgstr ""
+
+#. Wn55u
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id251580136888958\n"
+"help.text"
+msgid "Returns the input string enclosed in single or double quotes. Existing quotes are left unchanged, including leading and/or trailing quotes."
+msgstr ""
+
+#. 6VRqZ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id811580136944674\n"
+"help.text"
+msgid "<emph>InputStr</emph>: the string to quote."
+msgstr ""
+
+#. T8fPe
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581599129397412\n"
+"help.text"
+msgid "<emph>QuoteChar</emph> : Either the single (') or (default) double (\") quote."
+msgstr ""
+
+#. fY3PC
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id911612382537087\n"
+"help.text"
+msgid "This method can be useful while preparing a string field to be stored in a csv-like file, which requires that text values be enclosed with single or double quotes."
+msgstr ""
+
+#. 8Rr4M
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id951580139124650\n"
+"help.text"
+msgid "Replaces all occurrences of the characters specified in the <literal>Before</literal> parameter by the corresponding characters specified in <literal>After</literal>."
+msgstr ""
+
+#. 5hn2y
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id1001612384040018\n"
+"help.text"
+msgid "If the length of <literal>Before</literal> is greater than the length of <literal>After</literal>, the residual characters in <literal>Before</literal> are replaced by the last character in <literal>After</literal>."
+msgstr ""
+
+#. 949cN
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id11580139160633\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The input string on which replacements will occur."
+msgstr ""
+
+#. PoQ5t
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id111580139169795\n"
+"help.text"
+msgid "<emph>Before</emph>: A string with the characters that will be searched in the input string for repacement."
+msgstr ""
+
+#. jCz7k
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id851580139182113\n"
+"help.text"
+msgid "<emph>After</emph>: A string with the new characters that will replace those defined in <literal>Before</literal>."
+msgstr ""
+
+#. CDuCC
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id921580139218457\n"
+"help.text"
+msgid "' Replaces accented characters"
+msgstr ""
+
+#. 5ww5A
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id151612442904499\n"
+"help.text"
+msgid "The <literal>SF_String</literal> service provides useful public constants for the Latin character sets, as shown in the example below:"
+msgstr ""
+
+#. 9SPjv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id671580140272818\n"
+"help.text"
+msgid "Replaces all occurrences of a given regular expression by a new string."
+msgstr ""
+
+#. yT3Qw
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id471580140311626\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The input string on which replacements will occur."
+msgstr ""
+
+#. hW8Q6
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id651580140322666\n"
+"help.text"
+msgid "<emph>Regex</emph>: The regular expression."
+msgstr ""
+
+#. Do29t
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id891580140334754\n"
+"help.text"
+msgid "<emph>NewStr</emph>: The replacing string."
+msgstr ""
+
+#. MwRMp
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id581580140345221\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>."
+msgstr ""
+
+#. ykPVR
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id961612384647003\n"
+"help.text"
+msgid "' \"Lxxxx xxxxx xxxxx xxx xxxx, xxxxxxxxxxx xxxxxxxxxx xxxx.\" (each lowercase letter is replaced by \"x\")"
+msgstr ""
+
+#. rkMsv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id751612384623936\n"
+"help.text"
+msgid "' \"x x x x x, x x x.\" (each word is replaced by \"x\")"
+msgstr ""
+
+#. 2Gd5C
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id51580146471894\n"
+"help.text"
+msgid "Replaces in a string some or all occurrences of an array of strings by an array of new strings."
+msgstr ""
+
+#. W4yEv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id831580146504326\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The input string on which replacements will occur."
+msgstr ""
+
+#. ik56f
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id411580146514927\n"
+"help.text"
+msgid "<emph>OldStr</emph>: A single string or an array of strings. Zero-length strings are ignored."
+msgstr ""
+
+#. pRZAd
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id591580146532966\n"
+"help.text"
+msgid "<emph>NewStr</emph>: The replacing string or the array of replacing strings."
+msgstr ""
+
+#. 97Cuk
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611612384873347\n"
+"help.text"
+msgid "If <literal>OldStr</literal> is an array, each occurrence of any of the items in <literal>OldStr</literal> is replaced by <literal>NewStr</literal>."
+msgstr ""
+
+#. jLs7f
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id611612384880820\n"
+"help.text"
+msgid "If <literal>OldStr</literal> and <literal>NewStr</literal> are arrays, replacements occur one by one up to the <literal>UBound(NewStr)</literal>."
+msgstr ""
+
+#. HDGCx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id241612385058264\n"
+"help.text"
+msgid "If <literal>OldStr</literal> has more entries than <literal>NewStr</literal>, than the residual elements in <literal>OldStr</literal> are replaced by the last element in <literal>NewStr</literal>."
+msgstr ""
+
+#. oTqRh
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id701580146547619\n"
+"help.text"
+msgid "<emph>Occurrences</emph>: The maximum number of replacements. The default value is 0, meaning that all occurrences will be replaced."
+msgstr ""
+
+#. eigiB
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id741612385380533\n"
+"help.text"
+msgid "When <literal>OldStr</literal> is an array, the <literal>Occurrence</literal> parameter is computed separately for each item in the array."
+msgstr ""
+
+#. EUziv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id301580146556599\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>."
+msgstr ""
+
+#. eygyi
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id901580147558931\n"
+"help.text"
+msgid "Returns a string with a readable representation of the argument, truncated at a given length. This is useful mainly for debugging or logging purposes."
+msgstr ""
+
+#. jNrC5
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id11612386054691\n"
+"help.text"
+msgid "If the <literal>AnyValue</literal> parameter is an object, it will be enclosed with square brackets \"[\" and \"]\"."
+msgstr ""
+
+#. gVB32
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id491612386081802\n"
+"help.text"
+msgid "In strings, tabs and line breaks are replaced by \\t, \\n or \\r."
+msgstr ""
+
+#. vnB48
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id921612386089103\n"
+"help.text"
+msgid "If the final length exceeds the <literal>MaxLength</literal> parameter, the latter part of the string is replaced by \" ... (N)\" where N is the total length of the original string before truncation."
+msgstr ""
+
+#. ukVSq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id91580147593626\n"
+"help.text"
+msgid "<emph>AnyValue</emph>: The input value to be represented. It can be any value, such as a string, an array, a Basic object, a UNO object, etc."
+msgstr ""
+
+#. Gp3Gk
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id811580147609322\n"
+"help.text"
+msgid "<emph>MaxLength</emph>: The maximum length of the resulting string. The default value is 0, meaning there is no limit to the length of the resulting representation."
+msgstr ""
+
+#. EuYdK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id641612386659292\n"
+"help.text"
+msgid "Note that the representation of data types such as Arrays and <literal>ScriptForge.Dictionary</literal> object intances include both the data type and their values:"
+msgstr ""
+
+#. ZFFAD
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id971612386906463\n"
+"help.text"
+msgid "' An example with a Basic built-in Array"
+msgstr ""
+
+#. GEZzM
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id401612386876329\n"
+"help.text"
+msgid "' An example with a ScriptForge Array"
+msgstr ""
+
+#. mZ3ar
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id551612386931680\n"
+"help.text"
+msgid "' An example with a ScriptForge Dictionary"
+msgstr ""
+
+#. vvADG
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id411580312925741\n"
+"help.text"
+msgid "Returns the input string in reversed order."
+msgstr ""
+
+#. 5PtEv
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id141612387177873\n"
+"help.text"
+msgid "This method is equivalent to the built-in <link href=\"text/sbasic/shared/03120412.xhp\" name=\"StrReverse function\"><literal>StrReverse</literal> Basic function</link>, however with better performance."
+msgstr ""
+
+#. CjFDm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id961612387463144\n"
+"help.text"
+msgid "To use the <literal>StrReverse</literal> function, the statement <literal>OpTion VBASupport 1</literal> must be present in the module."
+msgstr ""
+
+#. ScghL
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id241580312964497\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be reversed."
+msgstr ""
+
+#. KBFDk
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id721580210762286\n"
+"help.text"
+msgid "Returns a zero-based array of strings with the lines in the input string. Each item in the array is obtained by splitting the input string at newline characters."
+msgstr ""
+
+#. RRtva
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id481580210806878\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be split."
+msgstr ""
+
+#. UAkXJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id231580210820309\n"
+"help.text"
+msgid "<emph>KeepBreaks</emph>: When <literal>True</literal>, line breaks are preserved in the output array (default = <literal>False</literal>)."
+msgstr ""
+
+#. HAG8Q
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id471580211762739\n"
+"help.text"
+msgid "Splits a string into an array of elements using a specified delimiter."
+msgstr ""
+
+#. zsADB
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id281612388034501\n"
+"help.text"
+msgid "If a quoted substring contains a delimiter, it is ignored. This is useful when parsing CSV-like records that contain quoted strings."
+msgstr ""
+
+#. mw9Lu
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id881580211809490\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be split."
+msgstr ""
+
+#. sYE2m
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id811580211821162\n"
+"help.text"
+msgid "<emph>Delimiter</emph>: A string of one or more characters that will be used as delimiter. The default delimiter is the space character."
+msgstr ""
+
+#. NBsXC
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id181580211833778\n"
+"help.text"
+msgid "<emph>Occurrences</emph>: The maximum number of substrings to return. The default value is 0, meaning that there is no limit to the number of returned strings."
+msgstr ""
+
+#. dzzmh
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id421599123777334\n"
+"help.text"
+msgid "<emph>QuoteChar</emph> : Either the single (') or double (\") quote."
+msgstr ""
+
+#. dVPPE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id351612388312049\n"
+"help.text"
+msgid "' a = Array(\"abc\", \"\"\"def\\\"\",ghi\"\"\")"
+msgstr ""
+
+#. 6Q2tJ
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id771580212837884\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the first characters of a string are identical to a given substring."
+msgstr ""
+
+#. BYx4G
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id781612393174350\n"
+"help.text"
+msgid "This method returns <literal>False</literal> if either the input string or the substring have a length = 0 or when the substring is longer than the input string."
+msgstr ""
+
+#. rmutH
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id271580212876135\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be tested."
+msgstr ""
+
+#. 2wa7W
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id571580212889462\n"
+"help.text"
+msgid "<emph>Substring</emph>: The substring to be searched at the start of <literal>InputStr</literal>."
+msgstr ""
+
+#. HAFmq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id811580212900799\n"
+"help.text"
+msgid "<emph>CaseSensitive</emph>: Default = <literal>False</literal>."
+msgstr ""
+
+#. DGgBx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id911580295999690\n"
+"help.text"
+msgid "Returns the input string without its leading and trailing whitespaces."
+msgstr ""
+
+#. ekDEE
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id541580296044377\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to trimmed."
+msgstr ""
+
+#. 9t9vX
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id61580483096936\n"
+"help.text"
+msgid "Converts any escaped sequence (\\\\, \\n, \\r, \\t) in the input string to their corresponding Ascii character."
+msgstr ""
+
+#. J7Fpn
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id971580483124743\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be converted."
+msgstr ""
+
+#. BoYHV
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id831580213634029\n"
+"help.text"
+msgid "Removes the single or double quotes enclosing the input string."
+msgstr ""
+
+#. Ae8c5
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id811612393585600\n"
+"help.text"
+msgid "This is useful when parsing CSV-like records that contain quoted strings."
+msgstr ""
+
+#. GrBsF
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id761580213677493\n"
+"help.text"
+msgid "<emph>InputStr</emph> : The string to unquote."
+msgstr ""
+
+#. GYKCt
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id211599129509890\n"
+"help.text"
+msgid "<emph>QuoteChar</emph> : Either the single (') or double (\") quote (default)."
+msgstr ""
+
+#. G368s
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id981580213799125\n"
+"help.text"
+msgid "s = SF_String.Unquote(\"\"\"Some text\"\"\") ' s = \"Some text\" (without enclosing quotes)"
+msgstr ""
+
+#. kyuNy
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id961612393917830\n"
+"help.text"
+msgid "s = SF_String.Unquote(\"Some text\") ' s = \"Some text\" (unchanged)"
+msgstr ""
+
+#. ULtxx
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"bas_id461612394182689\n"
+"help.text"
+msgid "' Quotes inside the string are not removed"
+msgstr ""
+
+#. JGhWK
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id871585834468102\n"
+"help.text"
+msgid "Converts the input string into an array of substrings so that each item in the array has at most a given number of characters."
+msgstr ""
+
+#. 4G9FU
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id21612394465120\n"
+"help.text"
+msgid "In practice, this method returns a zero-based array of output lines, without newlines at the end, except for the pre-existing line-breaks."
+msgstr ""
+
+#. qgd6X
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id601612395193333\n"
+"help.text"
+msgid "Tabs are expanded using the same procedure performed by the <link href=\"text/sbasic/shared/03/sf_string.xhp#ExpandTabs\" name=\"ExpandTabs method\">ExpandTabs</link> method."
+msgstr ""
+
+#. kTwEG
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id641612394826616\n"
+"help.text"
+msgid "Symbolic line breaks are replaced by their equivalent Ascii characters."
+msgstr ""
+
+#. y7VvP
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id361612394859733\n"
+"help.text"
+msgid "If the wrapped output has no content, the returned array is empty."
+msgstr ""
+
+#. J73yb
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id251585834468498\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to wrap."
+msgstr ""
+
+#. 5iowq
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id351585834773177\n"
+"help.text"
+msgid "<emph>Width</emph> : The maximum number of characters in each line (default = 70)."
+msgstr ""
+
+#. GhpV4
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id741585834874500\n"
+"help.text"
+msgid "<emph>TabSize</emph> : Before wrapping the text, the existing TAB <literal>Chr(9)</literal> characters are replaced with spaces. TabSize defines the TAB stops at TabSize + 1, 2 * TabSize + 1 , ... N * TabSize + 1 (default = 8)."
+msgstr ""
+
+#. xDXfd
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id271612398715438\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03120202.xhp\" name=\"String function\">String built-in function</link>"
+msgstr ""
+
 #. PCSPY
 #: sf_timer.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/scalc.po b/source/sq/helpcontent2/source/text/scalc.po
index 614d4fb03a4..8356e5dc82c 100644
--- a/source/sq/helpcontent2/source/text/scalc.po
+++ b/source/sq/helpcontent2/source/text/scalc.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: 2020-10-27 12:31+0100\n"
+"POT-Creation-Date: 2021-02-08 12:09+0100\n"
 "PO-Revision-Date: 2017-05-10 09:07+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -214,13 +214,13 @@ msgctxt ""
 msgid "<link href=\"text/scalc/01/03100000.xhp\">Page Break</link>"
 msgstr ""
 
-#. rJbW2
+#. Hr8bk
 #: main0103.xhp
 msgctxt ""
 "main0103.xhp\n"
 "hd_id10272015110909623\n"
 "help.text"
-msgid "Grid Lines for Sheet"
+msgid "View Grid lines"
 msgstr ""
 
 #. TvxiA
@@ -259,6 +259,15 @@ msgctxt ""
 msgid "<link href=\"text/shared/01/gallery.xhp\">Gallery</link>"
 msgstr ""
 
+#. 8MsyZ
+#: main0103.xhp
+msgctxt ""
+"main0103.xhp\n"
+"hd_id102720151147488697\n"
+"help.text"
+msgid "<embedvar href=\"text/scalc/01/04080000.xhp#function_list_title\"/>"
+msgstr ""
+
 #. f3nqY
 #: main0103.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/scalc/00.po b/source/sq/helpcontent2/source/text/scalc/00.po
index a5c1b34085d..7beb6831c94 100644
--- a/source/sq/helpcontent2/source/text/scalc/00.po
+++ b/source/sq/helpcontent2/source/text/scalc/00.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: 2020-12-01 12:34+0100\n"
+"POT-Creation-Date: 2021-02-05 18:59+0100\n"
 "PO-Revision-Date: 2020-02-19 20:15+0000\n"
 "Last-Translator: Bela Toci <toci.bela@gmail.com>\n"
 "Language-Team: Albanian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc00/sq/>\n"
@@ -1177,22 +1177,40 @@ msgctxt ""
 msgid "Window Menu"
 msgstr "AutoPilot Meny"
 
-#. 64duT
+#. dH2aq
 #: 00000407.xhp
 msgctxt ""
 "00000407.xhp\n"
 "par_id3147335\n"
 "help.text"
-msgid "<variable id=\"fete\">Choose ><item type=\"menuitem\">View - Split Window</item>.</variable>"
+msgid "<variable id=\"fete\">Choose ><menuitem>View - Split Window</menuitem>.</variable>"
 msgstr ""
 
-#. q8E8w
+#. dr9Aq
 #: 00000407.xhp
 msgctxt ""
 "00000407.xhp\n"
 "par_id3153663\n"
 "help.text"
-msgid "<variable id=\"fefix\">Choose <item type=\"menuitem\">View - Freeze Rows and Columns</item>.</variable>"
+msgid "<variable id=\"fefix\">Choose <menuitem>View - Freeze Rows and Columns</menuitem>.</variable>"
+msgstr ""
+
+#. DrJ2d
+#: 00000407.xhp
+msgctxt ""
+"00000407.xhp\n"
+"par_id631612313719480\n"
+"help.text"
+msgid "<variable id=\"freezefirstcol\">Choose <menuitem>View - Freeze Cells - Freeze First Column</menuitem></variable>"
+msgstr ""
+
+#. 5YHvr
+#: 00000407.xhp
+msgctxt ""
+"00000407.xhp\n"
+"par_id251612313725513\n"
+"help.text"
+msgid "<variable id=\"freezefirstrow\">Choose <menuitem>View - Freeze Cells - Freeze First Row</menuitem></variable>"
 msgstr ""
 
 #. BkQfX
diff --git a/source/sq/helpcontent2/source/text/scalc/01.po b/source/sq/helpcontent2/source/text/scalc/01.po
index 62c26e68466..7e3fab5420c 100644
--- a/source/sq/helpcontent2/source/text/scalc/01.po
+++ b/source/sq/helpcontent2/source/text/scalc/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-30 15:37+0100\n"
+"POT-Creation-Date: 2021-02-05 18:59+0100\n"
 "PO-Revision-Date: 2018-11-12 14:06+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5893,6 +5893,24 @@ msgctxt ""
 msgid "<emph>Rate</emph> is the rate of depreciation."
 msgstr ""
 
+#. TzEBm
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id421612299085248\n"
+"help.text"
+msgid "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming degressive depreciation, what is the amount of depreciation in the fourth depreciation period?"
+msgstr ""
+
+#. qyD4t
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id901612299089478\n"
+"help.text"
+msgid "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units."
+msgstr ""
+
 #. UCPgp
 #: 04060103.xhp
 msgctxt ""
@@ -5983,6 +6001,24 @@ msgctxt ""
 msgid "<emph>Rate</emph> is the rate of depreciation."
 msgstr ""
 
+#. vJKVs
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id641612299092454\n"
+"help.text"
+msgid "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming linear depreciation, what is the amount of depreciation in the fourth depreciation period?"
+msgstr ""
+
+#. zcGNo
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id391612299096511\n"
+"help.text"
+msgid "<input>=AMORLINC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 200 currency units."
+msgstr ""
+
 #. DHKDL
 #: 04060103.xhp
 msgctxt ""
@@ -6172,13 +6208,22 @@ msgctxt ""
 msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)."
 msgstr ""
 
-#. qAZtL
+#. GPEHn
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3159204\n"
 "help.text"
-msgid "<emph>Par</emph> (optional) is the par value of the security."
+msgid "<emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used."
+msgstr ""
+
+#. EJaKm
+#: 04060103.xhp
+msgctxt ""
+"04060103.xhp\n"
+"par_id481612296978513\n"
+"help.text"
+msgid "We recommend that you always specify the value that you require for ACCRINTM’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain."
 msgstr ""
 
 #. nB5zK
@@ -7531,31 +7576,22 @@ msgctxt ""
 msgid "<emph>Month</emph> (optional) denotes the number of months for the first year of depreciation. If an entry is not defined, 12 is used as the default."
 msgstr ""
 
-#. YDw8X
+#. D2krK
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3156147\n"
 "help.text"
-msgid "A computer system with an initial cost of 25,000 currency units is to be depreciated over a three year period. The salvage value is to be 1,000 currency units. One period is 30 days."
+msgid "A computer system with an initial cost of 25,000 currency units is to be depreciated over a three-year period. The salvage value is to be 1,000 currency units. The first period of depreciation comprises 6 months. What is the fixed-declining balance depreciation of the computer system in the second period, which is a full year starting from the end of the first six-month period?"
 msgstr ""
 
-#. DpiBb
+#. 4CQGc
 #: 04060103.xhp
 msgctxt ""
 "04060103.xhp\n"
 "par_id3149513\n"
 "help.text"
-msgid "<item type=\"input\">=DB(25000;1000;36;1;6)</item> = 1,075.00 currency units"
-msgstr ""
-
-#. 9hDAg
-#: 04060103.xhp
-msgctxt ""
-"04060103.xhp\n"
-"par_id3159242\n"
-"help.text"
-msgid "The fixed-declining depreciation of the computer system is 1,075.00 currency units."
+msgid "<input>=DB(25000; 1000; 3; 2; 6)</input> returns 11,037.95 currency units."
 msgstr ""
 
 #. fWK6h
@@ -18457,13 +18493,13 @@ msgctxt ""
 msgid "SHEET"
 msgstr "SHEET"
 
-#. GkhfA
+#. BRXnw
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3150309\n"
 "help.text"
-msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula."
+msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula."
 msgstr ""
 
 #. KRzAZ
@@ -18484,13 +18520,22 @@ msgctxt ""
 msgid "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string."
 msgstr ""
 
-#. SEDm6
+#. wbjCM
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
 "par_id3146988\n"
 "help.text"
-msgid "<item type=\"input\">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is the second sheet in the spreadsheet document."
+msgid "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document."
+msgstr ""
+
+#. fEQws
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id491612531793751\n"
+"help.text"
+msgid "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document."
 msgstr ""
 
 #. 7ZBfD
@@ -19087,6 +19132,78 @@ msgctxt ""
 msgid "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\" name=\"VLOOKUP\">VLOOKUP</link> (columns and rows are exchanged)"
 msgstr ""
 
+#. vwqHz
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id141612447324913\n"
+"help.text"
+msgid "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”."
+msgstr ""
+
+#. BcKD5
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id711612450364379\n"
+"help.text"
+msgid "Hydrogen"
+msgstr ""
+
+#. ACHPj
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id681612450364379\n"
+"help.text"
+msgid "Helium"
+msgstr ""
+
+#. 7YEmL
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id531612453345232\n"
+"help.text"
+msgid "Lithium"
+msgstr ""
+
+#. Y3c6z
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id571612453039430\n"
+"help.text"
+msgid "Oganesson"
+msgstr ""
+
+#. Cb3HA
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id51612447346319\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead."
+msgstr ""
+
+#. Fa8kD
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id291612447349416\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold."
+msgstr ""
+
+#. LbWuo
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
+"par_id971612447352912\n"
+"help.text"
+msgid "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon."
+msgstr ""
+
 #. B4DL3
 #: 04060109.xhp
 msgctxt ""
@@ -28141,202 +28258,40 @@ msgctxt ""
 msgid "<emph>Guess</emph> (optional) is a guess that can be input for the internal rate of return. The default is 10%."
 msgstr ""
 
-#. NSjGJ
+#. dZESY
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3149273\n"
 "help.text"
-msgid "Calculation of the internal rate of return for the following five payments:"
-msgstr ""
-
-#. eke7W
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3155838\n"
-"help.text"
-msgid "A"
-msgstr ""
-
-#. LSV7U
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3152934\n"
-"help.text"
-msgid "B"
+msgid "Calculation of the internal rate of return for the following five payments (dates are in ISO 8601 format):"
 msgstr ""
 
-#. BGtK9
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154638\n"
-"help.text"
-msgid "C"
-msgstr ""
-
-#. WYW4F
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3147083\n"
-"help.text"
-msgid "1"
-msgstr ""
-
-#. SwaVn
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3151187\n"
-"help.text"
-msgid "2001-01-01"
-msgstr "01/01/2001"
-
-#. ChsyU
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3145212\n"
-"help.text"
-msgid "-<item type=\"input\">10000</item>"
-msgstr "<item type=\"input\">10</item>"
-
-#. rmGTa
+#. 6JTLA
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3146856\n"
 "help.text"
-msgid "<item type=\"input\">Received</item>"
-msgstr "<item type=\"input\">7</item>"
-
-#. gxjFB
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3153277\n"
-"help.text"
-msgid "2"
+msgid "Received"
 msgstr ""
 
-#. e3a6n
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154052\n"
-"help.text"
-msgid "2001-01-02"
-msgstr "02/01/2001"
-
-#. BLL9e
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3151297\n"
-"help.text"
-msgid "<item type=\"input\">2000</item>"
-msgstr "<item type=\"input\">10</item>"
-
-#. unr5K
+#. N2RNr
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3149985\n"
 "help.text"
-msgid "<item type=\"input\">Deposited</item>"
-msgstr "<item type=\"input\">7</item>"
-
-#. YCCCY
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3154744\n"
-"help.text"
-msgid "3"
+msgid "Deposited"
 msgstr ""
 
-#. uxnXF
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3153151\n"
-"help.text"
-msgid "2001-03-15"
-msgstr "15/03/2001"
-
-#. qzvoJ
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3145657\n"
-"help.text"
-msgid "2500"
-msgstr "200"
-
-#. T6jHE
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3155101\n"
-"help.text"
-msgid "4"
-msgstr ""
-
-#. 6qrWD
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3146894\n"
-"help.text"
-msgid "2001-05-12"
-msgstr "12/05/2001"
-
-#. cqxc3
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3143231\n"
-"help.text"
-msgid "5000"
-msgstr "100"
-
-#. GkY8h
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3156012\n"
-"help.text"
-msgid "5"
-msgstr ""
-
-#. X7PHP
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3149758\n"
-"help.text"
-msgid "2001-08-10"
-msgstr "10/08/2001"
-
-#. 5AWfe
-#: 04060118.xhp
-msgctxt ""
-"04060118.xhp\n"
-"par_id3147495\n"
-"help.text"
-msgid "1000"
-msgstr "100"
-
-#. 6ArE8
+#. FLNWb
 #: 04060118.xhp
 msgctxt ""
 "04060118.xhp\n"
 "par_id3152793\n"
 "help.text"
-msgid "=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828."
+msgid "<input>=XIRR(B1:B5; A1:A5; 0.1)</input> returns 0.1828 or 18.28%."
 msgstr ""
 
 #. HRiCT
@@ -35809,23 +35764,23 @@ msgctxt ""
 msgid "The inverse function is GAMMAINV or GAMMA.INV."
 msgstr ""
 
-#. F2Nsp
+#. P8Kc2
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id2406201422405814\n"
 "help.text"
-msgid "This function is identical to GAMMADIST and was introduced for interoperability with other office suites."
+msgid "This function is similar to GAMMADIST and was introduced for interoperability with other office suites."
 msgstr ""
 
-#. WGnD7
+#. Gk9Ch
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id240620142238475\n"
 "help.text"
-msgid "GAMMA.DIST(Number; Alpha; Beta; C)"
-msgstr "Alfa parametri për Beta shprëndarje."
+msgid "GAMMA.DIST(Number; Alpha; Beta; Cumulative)"
+msgstr ""
 
 #. kLcmS
 #: 04060182.xhp
@@ -35854,13 +35809,13 @@ msgctxt ""
 msgid "<emph>Beta</emph> is the parameter Beta of the Gamma distribution."
 msgstr ""
 
-#. 4nR86
+#. a6oxX
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id2406201422391058\n"
 "help.text"
-msgid "<emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution."
+msgid "<emph>Cumulative</emph> = 0 or False calculates the probability density function; <emph>Cumulative</emph> = 1, True, or any other value calculates the cumulative distribution function."
 msgstr ""
 
 #. Z7AS8
@@ -36313,13 +36268,13 @@ msgctxt ""
 msgid "<emph>NPopulation </emph>is the size of the total population."
 msgstr ""
 
-#. oDuYV
+#. MDMvu
 #: 04060182.xhp
 msgctxt ""
 "04060182.xhp\n"
 "par_id231585952506847\n"
 "help.text"
-msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter."
+msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability mass function (FALSE or 0) or the cumulative distribution function (any other value). The probability mass function is the default if no value is specified for this parameter."
 msgstr ""
 
 #. WUiB6
@@ -37222,31 +37177,31 @@ msgctxt ""
 msgid "LOGINV(Number [; Mean [; StDev]])"
 msgstr ""
 
-#. uqfDA
+#. vDVWm
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3148390\n"
 "help.text"
-msgid "<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated."
+msgid "<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated."
 msgstr ""
 
-#. ZAEjF
+#. aJATB
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3149538\n"
 "help.text"
-msgid "<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution."
+msgid "<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted)."
 msgstr ""
 
-#. RTG5n
+#. PDJWU
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id3145355\n"
 "help.text"
-msgid "<emph>StDev</emph> is the standard deviation of the standard logarithmic distribution."
+msgid "<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted)."
 msgstr ""
 
 #. Uh6oi
@@ -37294,13 +37249,13 @@ msgctxt ""
 msgid "This function is identical to LOGINV and was introduced for interoperability with other office suites."
 msgstr ""
 
-#. tLigG
+#. AivtF
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901049\n"
 "help.text"
-msgid "LOGNORM.INV(Number; Mean; StDev)"
+msgid "LOGNORM.INV(Number [; Mean [; StDev]])"
 msgstr ""
 
 #. p2y5k
@@ -37312,22 +37267,22 @@ msgctxt ""
 msgid "<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated."
 msgstr ""
 
-#. sFACF
+#. ip7rm
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901538\n"
 "help.text"
-msgid "<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution."
+msgid "<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted)."
 msgstr ""
 
-#. PZ4w5
+#. pPM9C
 #: 04060183.xhp
 msgctxt ""
 "04060183.xhp\n"
 "par_id2901355\n"
 "help.text"
-msgid "<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution."
+msgid "<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted)."
 msgstr ""
 
 #. UYg6S
@@ -38842,13 +38797,13 @@ msgctxt ""
 msgid "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>"
 msgstr ""
 
-#. JHGHg
+#. nVnxU
 #: 04060184.xhp
 msgctxt ""
 "04060184.xhp\n"
 "par_id2946093\n"
 "help.text"
-msgid "POISSON.DIST(Number; Mean [; C])"
+msgid "POISSON.DIST(Number; Mean ; Cumulative)"
 msgstr ""
 
 #. jnjk7
@@ -38869,13 +38824,13 @@ msgctxt ""
 msgid "<emph>Mean</emph> represents the middle value of the Poisson distribution."
 msgstr ""
 
-#. fXReC
+#. MiQ2K
 #: 04060184.xhp
 msgctxt ""
 "04060184.xhp\n"
 "par_id2949200\n"
 "help.text"
-msgid "<emph>C</emph> (optional) = 0 or False calculates the density function; <emph>C</emph> = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME."
+msgid "<emph>Cumulative</emph> = 0 or False to calculate the probability mass function; <emph>Cumulative</emph> = 1, True, or any other non-zero value to calculate the cumulative distribution function."
 msgstr ""
 
 #. gXFJQ
@@ -45439,13 +45394,13 @@ msgctxt ""
 msgid "<bookmark_value>Stylist, see Styles window</bookmark_value><bookmark_value>Styles window</bookmark_value><bookmark_value>formats; Styles window</bookmark_value><bookmark_value>formatting; Styles window</bookmark_value><bookmark_value>paint can for applying styles</bookmark_value><bookmark_value>styles in spreadsheets</bookmark_value><bookmark_value>styles; in Calc</bookmark_value>"
 msgstr ""
 
-#. WerNG
+#. eA3vo
 #: 05100000.xhp
 msgctxt ""
 "05100000.xhp\n"
 "hd_id3150447\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles in Calc</link>"
+msgid "<link href=\"text/scalc/01/05100000.xhp\" name=\"Styles\">Styles</link>"
 msgstr ""
 
 #. bBG57
@@ -48022,13 +47977,13 @@ msgctxt ""
 msgid "Freeze Rows and Columns"
 msgstr ""
 
-#. rBUcX
+#. nwRKF
 #: 07090000.xhp
 msgctxt ""
 "07090000.xhp\n"
 "hd_id3150517\n"
 "help.text"
-msgid "<link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze Rows and Columns</link>"
+msgid "<variable id=\"freezerowcolum\"><link href=\"text/scalc/01/07090000.xhp\" name=\"Freeze\">Freeze Rows and Columns</link></variable>"
 msgstr ""
 
 #. XjvVY
@@ -48040,6 +47995,42 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable.</ahelp>"
 msgstr ""
 
+#. mBdCG
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Freeze Cells"
+msgstr ""
+
+#. U6FYG
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"bm_id821612315529410\n"
+"help.text"
+msgid "<bookmark_value>freezing;first row</bookmark_value>    <bookmark_value>freezing;first column</bookmark_value>    <bookmark_value>freezing;cells</bookmark_value>"
+msgstr ""
+
+#. tTzNC
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"hd_id961612313262512\n"
+"help.text"
+msgid "<variable id=\"freezecellsh1\"><link href=\"text/scalc/01/07090100.xhp\" name=\"Freeze Cells\">Freeze Cells</link></variable>"
+msgstr ""
+
+#. sWGWB
+#: 07090100.xhp
+msgctxt ""
+"07090100.xhp\n"
+"par_id481612313262514\n"
+"help.text"
+msgid "Freezes the first column or the first row of the current spreadsheet."
+msgstr ""
+
 #. ozNTG
 #: 12010000.xhp
 msgctxt ""
@@ -60946,31 +60937,31 @@ msgctxt ""
 msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
 msgstr ""
 
-#. nUeRH
+#. Dp4Sx
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id27619246864839\n"
 "help.text"
-msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65."
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65."
 msgstr ""
 
-#. CnZcV
+#. 7S443
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id220502883332563\n"
 "help.text"
-msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>"
+msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>"
 msgstr ""
 
-#. sGnvo
+#. gNhzJ
 #: func_minifs.xhp
 msgctxt ""
 "func_minifs.xhp\n"
 "par_id15342189586295\n"
 "help.text"
-msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180."
+msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190."
 msgstr ""
 
 #. uz4wr
@@ -62800,40 +62791,22 @@ msgctxt ""
 msgid "The parameters should specify at least three values."
 msgstr ""
 
-#. W8hYu
+#. Q2i35
 #: func_skewp.xhp
 msgctxt ""
 "func_skewp.xhp\n"
 "par_id1102201617001888\n"
 "help.text"
-msgid "<item type=\"literal\">SKEWP(2;3;1;6;8;5)</item> returns 0.2828158928"
+msgid "<input>SKEWP(2;3;1;6;8;5)</input> returns 0.2329985562"
 msgstr ""
 
-#. 63DiS
+#. TAGzC
 #: func_skewp.xhp
 msgctxt ""
 "func_skewp.xhp\n"
 "par_id1102201618185378\n"
 "help.text"
-msgid "<item type=\"literal\">SKEWP(A1:A6)</item> returns 0.2828158928, when the range A1:A6 contains {2;3;1;6;8;5}"
-msgstr ""
-
-#. Tdd33
-#: func_skewp.xhp
-msgctxt ""
-"func_skewp.xhp\n"
-"par_id1102201618185326\n"
-"help.text"
-msgid "<item type=\"literal\">SKEWP(Number1; Number2)</item> always returns zero, if Number1 and Number2 results in two numbers."
-msgstr ""
-
-#. X6nGR
-#: func_skewp.xhp
-msgctxt ""
-"func_skewp.xhp\n"
-"par_id1102201618188326\n"
-"help.text"
-msgid "<item type=\"literal\">SKEWP(Number1)</item> returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value."
+msgid "<input>SKEWP(A1:A6)</input> returns 0.2329985562, when the range A1:A6 contains {2;3;1;6;8;5}"
 msgstr ""
 
 #. 5iYyJ
diff --git a/source/sq/helpcontent2/source/text/sdatabase.po b/source/sq/helpcontent2/source/text/sdatabase.po
index 8154be7bb96..51d1c2ad7b7 100644
--- a/source/sq/helpcontent2/source/text/sdatabase.po
+++ b/source/sq/helpcontent2/source/text/sdatabase.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-14 18:09+0100\n"
+"POT-Creation-Date: 2021-02-05 18:59+0100\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3019,13 +3019,13 @@ msgctxt ""
 msgid "In the $[officename] Help, you will find further information on the following subjects:"
 msgstr ""
 
-#. UxGw5
+#. GAgsq
 #: 05000000.xhp
 msgctxt ""
 "05000000.xhp\n"
 "hd_id3152425\n"
 "help.text"
-msgid "<link href=\"text/shared/explorer/database/05010000.xhp\" name=\"Create new or edit table design\">Create new or edit table design</link>"
+msgid "<link href=\"text/sdatabase/05010000.xhp\" name=\"Create new or edit table design\">Create new or edit table design</link>"
 msgstr ""
 
 #. Hk4Jz
@@ -3199,6 +3199,600 @@ msgctxt ""
 msgid "<ahelp hid=\"dbaccess/ui/password/confirmpassword\">Enter the new password again.</ahelp>"
 msgstr ""
 
+#. NYfPs
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Table Design"
+msgstr ""
+
+#. DKzbA
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3154228\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05010000.xhp\" name=\"Table Design\">Table Design</link>"
+msgstr ""
+
+#. fQvmC
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3152363\n"
+"help.text"
+msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table."
+msgstr ""
+
+#. 3skAk
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3146957\n"
+"help.text"
+msgid "The window has its own menu bar. It also contains the following new command: <link href=\"text/sdatabase/05010100.xhp\" name=\"Index Design\"><emph>Index Design</emph></link>"
+msgstr ""
+
+#. z6hA5
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3152551\n"
+"help.text"
+msgid "Table definition area"
+msgstr ""
+
+#. xmBqj
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3153681\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TABDESIGN_BACKGROUND\">This area is where you define the table structure.</ahelp>"
+msgstr ""
+
+#. FfuwA
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3153031\n"
+"help.text"
+msgid "Field Name"
+msgstr ""
+
+#. GiHyW
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3156113\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp>"
+msgstr ""
+
+#. QNg69
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3147618\n"
+"help.text"
+msgid "Field type"
+msgstr ""
+
+#. eK4to
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3154897\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type. The available field types are limited by the database engine being used.</ahelp>"
+msgstr ""
+
+#. Ehy3n
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3156119\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 96xiG
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3145315\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>"
+msgstr ""
+
+#. A99ei
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3155630\n"
+"help.text"
+msgid "The row headers contain the following context menu commands:"
+msgstr ""
+
+#. rd8Zn
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3156330\n"
+"help.text"
+msgid "Cut"
+msgstr ""
+
+#. GVxeZ
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3159157\n"
+"help.text"
+msgid "Cuts the selected row to the clipboard."
+msgstr ""
+
+#. JxTSq
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3159177\n"
+"help.text"
+msgid "Copy"
+msgstr ""
+
+#. ZAjhE
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3148685\n"
+"help.text"
+msgid "Copies the selected row to the clipboard."
+msgstr ""
+
+#. Q8awG
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3156327\n"
+"help.text"
+msgid "Paste"
+msgstr ""
+
+#. 5AQBL
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3152472\n"
+"help.text"
+msgid "Pastes the content of the clipboard."
+msgstr ""
+
+#. aQCGh
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3144511\n"
+"help.text"
+msgid "Delete"
+msgstr ""
+
+#. fbZPb
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3148550\n"
+"help.text"
+msgid "<ahelp hid=\".uno:Delete\">Deletes the selected row.</ahelp>"
+msgstr ""
+
+#. pD5B3
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3147303\n"
+"help.text"
+msgid "Insert Rows"
+msgstr ""
+
+#. kfUXp
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3149456\n"
+"help.text"
+msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp>"
+msgstr ""
+
+#. XMDuJ
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3153524\n"
+"help.text"
+msgid "Primary Key"
+msgstr ""
+
+#. mmwbs
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3150398\n"
+"help.text"
+msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys."
+msgstr ""
+
+#. kDbYY
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3153104\n"
+"help.text"
+msgid "Field properties"
+msgstr ""
+
+#. BZPWE
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3148922\n"
+"help.text"
+msgid "Defines the field properties of the currently selected field."
+msgstr ""
+
+#. bRsW9
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3150767\n"
+"help.text"
+msgid "Length"
+msgstr ""
+
+#. D58RK
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3144761\n"
+"help.text"
+msgid "Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters."
+msgstr ""
+
+#. fJknL
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3154948\n"
+"help.text"
+msgid "Decimal places"
+msgstr ""
+
+#. FgVqm
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3149203\n"
+"help.text"
+msgid "Specifies the number of decimal places for a numerical field or decimal field."
+msgstr ""
+
+#. mW3AN
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3156422\n"
+"help.text"
+msgid "Default value"
+msgstr ""
+
+#. HYW5B
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3125863\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TAB_ENT_DEFAULT\">Specifies the value that is the default in new data records.</ahelp>"
+msgstr ""
+
+#. vQcGG
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3147289\n"
+"help.text"
+msgid "Format example"
+msgstr ""
+
+#. V3i6o
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3155131\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the <emph>Format Field</emph> button.</ahelp>"
+msgstr ""
+
+#. A2jGQ
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3154129\n"
+"help.text"
+msgid "Format Field"
+msgstr ""
+
+#. 8GHDz
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3154146\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT\">This button opens the <link href=\"text/shared/01/05340405.xhp\" name=\"Field Format\"><emph>Format Field</emph></link> dialog.</ahelp>"
+msgstr ""
+
+#. CgbCE
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"hd_id3152576\n"
+"help.text"
+msgid "Help area"
+msgstr ""
+
+#. Gg783
+#: 05010000.xhp
+msgctxt ""
+"05010000.xhp\n"
+"par_id3150685\n"
+"help.text"
+msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays a help string or hint defined by the database designer for the given field.</ahelp>"
+msgstr ""
+
+#. hzJ3Q
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Index design"
+msgstr ""
+
+#. q4EEe
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3153311\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05010100.xhp\" name=\"Index design\">Index design</link>"
+msgstr ""
+
+#. 98zvT
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3166460\n"
+"help.text"
+msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp>"
+msgstr ""
+
+#. N85Yq
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3149578\n"
+"help.text"
+msgid "Index list"
+msgstr ""
+
+#. JQ5ws
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3155342\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
+msgstr ""
+
+#. GNgfV
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3149795\n"
+"help.text"
+msgid "New Index"
+msgstr ""
+
+#. hbmc3
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3150085\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_NEW\">Creates a new index.</ahelp>"
+msgstr ""
+
+#. CraTD
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3145317\n"
+"help.text"
+msgid "Delete Current Index"
+msgstr ""
+
+#. CLtrt
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3154860\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_DROP\">Deletes the current index.</ahelp>"
+msgstr ""
+
+#. qxQaG
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3150986\n"
+"help.text"
+msgid "Rename Current Index"
+msgstr ""
+
+#. Me7m2
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3148685\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME\">Renames the current index.</ahelp>"
+msgstr ""
+
+#. h5vTM
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3153628\n"
+"help.text"
+msgid "Save Current Index"
+msgstr ""
+
+#. GEBFr
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3148563\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE\">Saves the current index in the data source.</ahelp>"
+msgstr ""
+
+#. JxS8c
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3154924\n"
+"help.text"
+msgid "Reset Current Index"
+msgstr ""
+
+#. AkcRe
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3154758\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_RESET\">Resets the current index to the setting that it had when the dialog was started.</ahelp>"
+msgstr ""
+
+#. kpk89
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3152812\n"
+"help.text"
+msgid "Index details"
+msgstr ""
+
+#. whVGR
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3154938\n"
+"help.text"
+msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
+msgstr ""
+
+#. rEFpa
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3154138\n"
+"help.text"
+msgid "Unique"
+msgstr ""
+
+#. wqFaL
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3156282\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/UNIQUE\">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity."
+msgstr ""
+
+#. SFD2p
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3150448\n"
+"help.text"
+msgid "Fields"
+msgstr ""
+
+#. KGRnz
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3147085\n"
+"help.text"
+msgid "The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list."
+msgstr ""
+
+#. ALC5T
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3149765\n"
+"help.text"
+msgid "Index field"
+msgstr ""
+
+#. 2oDE4
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3158408\n"
+"help.text"
+msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_FIELD\">Displays a list of the fields in the current table. You can select more than one field.</ahelp>"
+msgstr ""
+
+#. CmQtE
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3153192\n"
+"help.text"
+msgid "Sort order"
+msgstr ""
+
+#. MXzBy
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3149561\n"
+"help.text"
+msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>"
+msgstr ""
+
+#. cEYAF
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"hd_id3155132\n"
+"help.text"
+msgid "Close"
+msgstr ""
+
+#. NuXdU
+#: 05010100.xhp
+msgctxt ""
+"05010100.xhp\n"
+"par_id3154190\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/close\">Closes the dialog.</ahelp>"
+msgstr ""
+
 #. cLmBi
 #: main.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/shared/01.po b/source/sq/helpcontent2/source/text/shared/01.po
index 5938e4c28d1..beabcc7ef9d 100644
--- a/source/sq/helpcontent2/source/text/shared/01.po
+++ b/source/sq/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-30 15:37+0100\n"
+"POT-Creation-Date: 2021-02-08 12:09+0100\n"
 "PO-Revision-Date: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3598,13 +3598,13 @@ msgctxt ""
 msgid "Saves a thumbnail preview .png inside the document. This image may be used by a file manager under certain conditions."
 msgstr ""
 
-#. onMPH
+#. kGCVD
 #: 01100200.xhp
 msgctxt ""
 "01100200.xhp\n"
 "par_id231606265075565\n"
 "help.text"
-msgid "To disable generating thumbnails in general, choose <menuitem>Tools - Options - LibreOffice - Advanced</menuitem>. Click the <widget>Open Expert Configuration</widget> button, and search for <emph>GenerateThumbnail</emph>. If this property has the value <literal>true</literal>, then double-click on it to set its value to <literal>false</literal>."
+msgid "To disable generating thumbnails in general, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem/><menuitem> - %PRODUCTNAME - Advanced</menuitem>. Click the <widget>Open Expert Configuration</widget> button, and search for <emph>GenerateThumbnail</emph>. If this property has the value <literal>true</literal>, then double-click on it to set its value to <literal>false</literal>."
 msgstr ""
 
 #. ibdbD
@@ -25306,13 +25306,13 @@ msgctxt ""
 msgid "<emph>For all style categories:</emph>"
 msgstr ""
 
-#. aAFeT
+#. ZCV8q
 #: 05140100.xhp
 msgctxt ""
 "05140100.xhp\n"
 "par_id411608260881855\n"
 "help.text"
-msgid "Choose <menuitem>View - Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the <emph>Styles</emph> sidebar, select the desired <emph>Style</emph> category at the top of <emph>Styles</emph> deck, then click the <emph>Styles action menu</emph> icon at the top right corner, and choose <menuitem>New Style from Selection</menuitem>."
+msgid "Choose <menuitem>View - Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the Styles sidebar, select the desired style category at the top of Styles deck, then click the <emph>Styles action menu</emph> icon at the top right corner, and choose <menuitem>New Style from Selection</menuitem>."
 msgstr ""
 
 #. Z4co9
@@ -25324,22 +25324,22 @@ msgctxt ""
 msgid "Choose <menuitem>Styles - New Style from Selection</menuitem>. (cell styles only)"
 msgstr ""
 
-#. BTeg7
+#. kP8Su
 #: 05140100.xhp
 msgctxt ""
 "05140100.xhp\n"
 "par_id751608262329946\n"
 "help.text"
-msgid "Choose <menuitem>Styles - Manage Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the <emph>Styles</emph> sidebar, select the desired <emph>Style</emph> category at the top of <emph>Styles</emph> deck, then click the <emph>New Style from Selection</emph> icon."
+msgid "Choose <menuitem>Styles - Manage Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the Styles sidebar, select the desired style category at the top of Styles deck, then click the <emph>New Style from Selection</emph> icon."
 msgstr ""
 
-#. fRA2v
+#. 9Cz2g
 #: 05140100.xhp
 msgctxt ""
 "05140100.xhp\n"
 "par_id791608262979620\n"
 "help.text"
-msgid "Choose <menuitem>View - Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the Styles sidebar, then click the <emph>New Style from Selection</emph> icon at the top of the <emph>Styles</emph> deck."
+msgid "Choose <menuitem>View - Styles</menuitem> or press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command+T</keycode></caseinline><defaultinline><keycode>F11</keycode></defaultinline></switchinline> to open the Styles sidebar, then click the <emph>New Style from Selection</emph> icon at the top of the Styles deck."
 msgstr ""
 
 #. xeDUe
@@ -35917,13 +35917,22 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/applyautofmtpage/ApplyAutoFmtPage\">Select the options for automatically correcting errors as you type, and then click <emph>OK</emph>.</ahelp>"
 msgstr ""
 
-#. BAFoD
+#. RiA4T
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3153124\n"
 "help.text"
-msgid "In text documents, you can choose to apply the AutoCorrect corrections while you type [T], or by choosing <menuitem>Tools - AutoCorrect - Apply</menuitem> to modify existing text [M]. The [M] options are applied only to paragraphs with Default Paragraph Style."
+msgid "In text documents, you can choose to apply [T] AutoCorrect options while you type. Enable this feature by using <menuitem>Tools - AutoCorrect - While Typing</menuitem>."
+msgstr ""
+
+#. cZFNj
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"par_id141612013807625\n"
+"help.text"
+msgid "You can also apply [M] AutoCorrect options to a selection or a whole document of existing text by using <menuitem>Tools - AutoCorrect - Apply</menuitem>. In general, [M] options are applied only to paragraphs with Default Paragraph Style."
 msgstr ""
 
 #. QavGm
@@ -35935,6 +35944,15 @@ msgctxt ""
 msgid "All non-empty paragraphs with \"Default Paragraph Style\" are converted to \"Text Body\" paragraph style when <menuitem>Tools - AutoCorrect - Apply</menuitem> is used."
 msgstr ""
 
+#. C8cAH
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"hd_id291612211857255\n"
+"help.text"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">[M] and [T] options</caseinline></switchinline>"
+msgstr ""
+
 #. W2qGH
 #: 06040100.xhp
 msgctxt ""
@@ -36259,6 +36277,15 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Removes spaces and tabs at the beginning of each line. To use this option, the <emph>Apply Styles</emph> option must also be selected.</caseinline></switchinline>"
 msgstr ""
 
+#. orQus
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"hd_id881612211740519\n"
+"help.text"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">[T] options only</caseinline></switchinline>"
+msgstr ""
+
 #. BGD5w
 #: 06040100.xhp
 msgctxt ""
@@ -36277,6 +36304,24 @@ msgctxt ""
 msgid "Replaces two or more consecutive spaces with a single space."
 msgstr ""
 
+#. vCSin
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"hd_id871612310182014\n"
+"help.text"
+msgid "Correct accidental use of cAPS LOCK key"
+msgstr ""
+
+#. 2m6cj
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"par_id971612310224117\n"
+"help.text"
+msgid "Inverts a capitalized word entered with the <keycode>Caps Lock</keycode> key enabled, after a <keycode>space</keycode> is entered, and disables the <keycode>Caps Lock</keycode> key. For example, entering <literal>Libre</literal> with <keycode>Caps Lock</keycode> enabled appears as <literal>lIBRE</literal>, which is converted automatically to <literal>Libre</literal>."
+msgstr ""
+
 #. EDVL6
 #: 06040100.xhp
 msgctxt ""
@@ -36322,22 +36367,22 @@ msgctxt ""
 msgid "Apply border"
 msgstr "Zbato kufinjtë dhe hijezimin"
 
-#. AJGRE
+#. 5vVhT
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3144445\n"
 "help.text"
-msgid "Automatically applies a border at the base of the preceding paragraph when you type three or more specific characters, and then press Enter. To create a single line, type three or more hyphens (-), or underscores (_), and then press Enter. To create a double line, type three or more equal signs (=), asterisks (*), tildes (~), or hash marks (#), and then press Enter."
+msgid "Automatically applies a border at the base of the preceding paragraph when you type three or more specific characters, and then press <keycode>Enter</keycode>."
 msgstr ""
 
-#. BvcCd
+#. gBQ7Z
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
-"par_idN10C2E\n"
+"par_id791612261705442\n"
 "help.text"
-msgid "To delete the created line, click the paragraph above the line, choose <emph>Format - Paragraph - Borders</emph>, delete the bottom border."
+msgid "To create a single line, type three or more hyphens (<keycode>-</keycode>), or underscores (<keycode>_</keycode>), and then press <keycode>Enter</keycode>. To create a double line, type three or more equal signs (<keycode>=</keycode>), asterisks (<keycode>*</keycode>), tildes (<keycode>~</keycode>), or hash marks (<keycode>#</keycode>), and then press <keycode>Enter</keycode>."
 msgstr ""
 
 #. yv7YY
@@ -36358,13 +36403,13 @@ msgctxt ""
 msgid "---"
 msgstr ""
 
-#. AFEWL
+#. 2k3QK
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3154690\n"
 "help.text"
-msgid "0.5pt single underline"
+msgid "0.05pt single underline"
 msgstr ""
 
 #. 7Agog
@@ -36394,13 +36439,13 @@ msgctxt ""
 msgid "==="
 msgstr ""
 
-#. AkmHz
+#. GRSgX
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3145364\n"
 "help.text"
-msgid "1.1pt double underline"
+msgid "1.0pt double underline"
 msgstr ""
 
 #. AD8uc
@@ -36412,13 +36457,13 @@ msgctxt ""
 msgid "***"
 msgstr ""
 
-#. g3pxh
+#. ZrZyM
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3152791\n"
 "help.text"
-msgid "4.5pt double underline"
+msgid "4.0pt thick-thin double underline"
 msgstr ""
 
 #. dAuHd
@@ -36430,13 +36475,13 @@ msgctxt ""
 msgid "~~~"
 msgstr ""
 
-#. GEkMp
+#. mfUWB
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3152885\n"
 "help.text"
-msgid "6.0pt double underline"
+msgid "4.0pt thin-thick double underline"
 msgstr ""
 
 #. RB69t
@@ -36448,13 +36493,40 @@ msgctxt ""
 msgid "###"
 msgstr ""
 
-#. G9GSG
+#. bXVDw
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3153188\n"
 "help.text"
-msgid "9.0pt double underline"
+msgid "2.5pt double underline"
+msgstr ""
+
+#. wzM8n
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"par_id381612261836746\n"
+"help.text"
+msgid "To modify attributes of a predefined border, such as color, style, width and shadow, click the paragraph above the line, choose <menuitem>Format - Paragraph - Borders</menuitem> tab."
+msgstr ""
+
+#. BvcCd
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"par_idN10C2E\n"
+"help.text"
+msgid "To delete the created line, click the paragraph above the line, choose <emph>Format - Paragraph - Borders</emph>, delete the bottom border."
+msgstr ""
+
+#. CHmBD
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"par_id581612215799960\n"
+"help.text"
+msgid "To remove a line created with Apply Border, place the cursor above the line, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+M</keycode>."
 msgstr ""
 
 #. sQ22b
@@ -36529,6 +36601,15 @@ msgctxt ""
 msgid "This feature works only with \"Default Paragraph Style\", \"Text Body\" and \"Text Body Indent\" paragraph styles, and there must be one empty paragraph before the text, if the text is not at the top of a page."
 msgstr ""
 
+#. BjgHi
+#: 06040100.xhp
+msgctxt ""
+"06040100.xhp\n"
+"hd_id861612011786183\n"
+"help.text"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">[M] options only</caseinline></switchinline>"
+msgstr ""
+
 #. RRoM9
 #: 06040100.xhp
 msgctxt ""
@@ -36538,13 +36619,13 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Remove blank paragraphs</caseinline></switchinline>"
 msgstr ""
 
-#. PtacD
+#. NFYGm
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3145728\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Removes empty paragraphs from the current document when you choose <menuitem>Tools - AutoCorrect - Apply</menuitem>.</caseinline></switchinline>"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Removes empty paragraphs and paragraphs that contain only spaces or tabs from the current document. This option works for any paragraph style.</caseinline></switchinline>"
 msgstr ""
 
 #. 3wrpe
@@ -36556,13 +36637,13 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Replace Custom Styles</caseinline></switchinline>"
 msgstr ""
 
-#. ABgU8
+#. 6trmB
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3156299\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Replaces the custom paragraph styles in the current document with the \"Default\", the \"Text Body\", or the \"Text Body Indent\" paragraph style.</caseinline></switchinline>"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Replaces custom paragraph styles applied in the current document to \"Text Body\", \"Text Body Indent\", \"First Line Indent\" or \"Hanging Indent\" paragraph style.</caseinline></switchinline>"
 msgstr ""
 
 #. UsxjM
@@ -36574,13 +36655,13 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Replace bullets with</caseinline></switchinline>"
 msgstr ""
 
-#. sPDGS
+#. Ehrw7
 #: 06040100.xhp
 msgctxt ""
 "06040100.xhp\n"
 "par_id3150420\n"
 "help.text"
-msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Converts paragraphs that start with a hyphen (-), a plus sign (+), or an asterisk (*) directly followed by a space or a tab, to bulleted lists. This option only works on paragraphs that are formatted with the \"Default\", \"Text Body\", or \"Text Body Indent\" paragraph styles. To change the bullet style that is used, select this option, and then click <emph>Edit</emph>.</caseinline></switchinline>"
+msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\">Converts paragraphs that start with a hyphen (-), a plus sign (+), or an asterisk (*) directly followed by a space or a tab, to bulleted lists. This option only works on paragraphs that are formatted with the \"Default Paragraph Style\". To change the bullet style that is used, select this option, and then click <emph>Edit</emph>.</caseinline></switchinline>"
 msgstr ""
 
 #. vbwez
@@ -38050,23 +38131,23 @@ msgctxt ""
 msgid "<ahelp hid=\"cui/ui/numberingoptionspage/levellb\">Select the level(s) that you want to define the formatting options for.</ahelp> The selected level is highlighted in the preview."
 msgstr ""
 
-#. ugWJQ
+#. DBFn7
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
 "hd_id3159200\n"
 "help.text"
-msgid "Number"
+msgid "Numbering"
 msgstr ""
 
-#. LEAqu
+#. ujAuR
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
 "hd_id3159201\n"
 "help.text"
-msgid "Numbering"
-msgstr "Numërimi"
+msgid "Number"
+msgstr ""
 
 #. vcASB
 #: 06050500.xhp
@@ -38266,13 +38347,13 @@ msgctxt ""
 msgid "Bullet"
 msgstr "Pikë"
 
-#. vZdhE
+#. RqUuK
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
 "par_id3145085\n"
 "help.text"
-msgid "Adds a bullet to the beginning of a line. Select this option, and then click the <emph>Select</emph> button to choose a bullet style."
+msgid "Adds a bullet to the beginning of a line. Select this option, and then use the <emph>Character style</emph> drop-down menu to choose a bullet style."
 msgstr ""
 
 #. JBJEa
@@ -38338,49 +38419,31 @@ msgctxt ""
 msgid "Does not apply a numbering style."
 msgstr "Ky Stil nuk ekziston."
 
-#. 6zLDV
+#. P7jbZ
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
 "par_id3145746\n"
 "help.text"
-msgid "The availability of the following fields depends on the style that you select in the <emph>Numbering </emph>box."
+msgid "The availability of the following fields depends on the style that you select in the <emph>Number</emph> box."
 msgstr ""
 
-#. 85gXU
-#: 06050500.xhp
-msgctxt ""
-"06050500.xhp\n"
-"hd_id3156293\n"
-"help.text"
-msgid "Before"
-msgstr "Përpara"
-
-#. R2LPX
-#: 06050500.xhp
-msgctxt ""
-"06050500.xhp\n"
-"par_id3150393\n"
-"help.text"
-msgid "<ahelp hid=\"cui/ui/numberingoptionspage/prefix\">Enter a character or the text to display in front of the number in the list.</ahelp>"
-msgstr ""
-
-#. eY5nc
+#. iqVUE
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
-"hd_id3153968\n"
+"hd_id3155429\n"
 "help.text"
-msgid "After"
-msgstr "Pas"
+msgid "Start at"
+msgstr "Fillo në"
 
-#. 9rGAH
+#. eyM3f
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
-"par_id3150288\n"
+"par_id3146903\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/numberingoptionspage/suffix\">Enter a character or the text to display behind the number in the list. If you want to create a numbered list that uses the style \"1.)\", enter \".)\" in this box.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/numberingoptionspage/startat\">Enter a new starting number for the current level.</ahelp>"
 msgstr ""
 
 #. Uw4HA
@@ -38419,22 +38482,40 @@ msgctxt ""
 msgid "<switchinline select=\"appl\"><caseinline select=\"WRITER\"><ahelp hid=\"cui/ui/numberingoptionspage/sublevels\">Enter the number of previous levels to include in the numbering style. For example, if you enter \"2\" and the previous level uses the \"A, B, C...\" numbering style, the numbering scheme for the current level becomes: \"A.1\".</ahelp></caseinline></switchinline>"
 msgstr ""
 
-#. iqVUE
+#. 85gXU
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
-"hd_id3155429\n"
+"hd_id3156293\n"
 "help.text"
-msgid "Start at"
-msgstr "Fillo në"
+msgid "Before"
+msgstr "Përpara"
 
-#. eyM3f
+#. R2LPX
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
-"par_id3146903\n"
+"par_id3150393\n"
 "help.text"
-msgid "<ahelp hid=\"cui/ui/numberingoptionspage/startat\">Enter a new starting number for the current level.</ahelp>"
+msgid "<ahelp hid=\"cui/ui/numberingoptionspage/prefix\">Enter a character or the text to display in front of the number in the list.</ahelp>"
+msgstr ""
+
+#. eY5nc
+#: 06050500.xhp
+msgctxt ""
+"06050500.xhp\n"
+"hd_id3153968\n"
+"help.text"
+msgid "After"
+msgstr "Pas"
+
+#. 9rGAH
+#: 06050500.xhp
+msgctxt ""
+"06050500.xhp\n"
+"par_id3150288\n"
+"help.text"
+msgid "<ahelp hid=\"cui/ui/numberingoptionspage/suffix\">Enter a character or the text to display behind the number in the list. If you want to create a numbered list that uses the style \"1.)\", enter \".)\" in this box.</ahelp>"
 msgstr ""
 
 #. FWEse
@@ -38482,14 +38563,14 @@ msgctxt ""
 msgid "Options for graphics:"
 msgstr "Shiriti i opcioneve /Grafikat"
 
-#. MBuC2
+#. wL36V
 #: 06050500.xhp
 msgctxt ""
 "06050500.xhp\n"
 "hd_id3149934\n"
 "help.text"
-msgid "Select..."
-msgstr "Zgjedh"
+msgid "Graphics"
+msgstr ""
 
 #. YLCPM
 #: 06050500.xhp
@@ -45754,184 +45835,193 @@ msgctxt ""
 msgid "<bookmark_value>notebook bar;contextual single toolbar</bookmark_value>  <bookmark_value>notebook bar;contextual groups</bookmark_value>  <bookmark_value>notebook bar;tabbed mode</bookmark_value>  <bookmark_value>notebook bar;single toolbar</bookmark_value>  <bookmark_value>notebook bar;default layout</bookmark_value>  <bookmark_value>notebook bar;layouts</bookmark_value>  <bookmark_value>notebook bar;toolbar</bookmark_value>  <bookmark_value>notebook bar;sidebar</bookmark_value>  <bookmark_value>sidebar;notebook bar</bookmark_value>  <bookmark_value>toolbar;notebook bar</bookmark_value>"
 msgstr ""
 
-#. BBvJB
+#. P8ZCj
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "hd_id190920161731349683\n"
 "help.text"
-msgid "<link href=\"text/shared/01/notebook_bar.xhp\">Using the notebook bar</link>"
+msgid "<link href=\"text/shared/01/notebook_bar.xhp\">User Interface</link>"
+msgstr ""
+
+#. 5eu7G
+#: notebook_bar.xhp
+msgctxt ""
+"notebook_bar.xhp\n"
+"par_id791612306305954\n"
+"help.text"
+msgid "Opens the Select Your Preferred User Interface dialog to let you choose the user interface layout for %PRODUCTNAME."
 msgstr ""
 
-#. LkNPu
+#. aGRwD
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
 "par_id190920161732262244\n"
 "help.text"
-msgid "<ahelp hid=\".\">The notebook bar is a new form of displaying commands icons for a quicker usage.</ahelp>"
+msgid "<ahelp hid=\".\">The notebook bar shows a different way to organize controls and icons than a collection of straight rows of icons, displaying contextual groups of commands and contents for a quicker usage and better user experience.</ahelp>"
 msgstr ""
 
-#. roAUi
+#. eBXFy
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744065146\n"
+"par_id190920161744066306\n"
 "help.text"
-msgid "By default, %PRODUCTNAME commands are grouped in cascading menus and in toolbars filled with icons."
+msgid "Choose menu <menuitem>View - User Interface</menuitem>"
 msgstr ""
 
-#. 77wSC
+#. SJiku
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744061691\n"
+"hd_id190920161911374012\n"
 "help.text"
-msgid "The notebook bar shows a different way to organize controls and icons than a collection of straight rows of icons, displaying contextual groups of commands and contents."
+msgid "User interface layouts"
 msgstr ""
 
-#. VucBE
+#. VDTBe
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744064258\n"
+"par_id190920161744068946\n"
 "help.text"
-msgid "With the notebook bar, frequently used commands are grouped in an arrangement that will make it quicker to access, avoiding lengthy menu navigation and toolbars command icon lookup."
+msgid "The <emph>User Interface</emph> entry defines which user interface elements are visible."
 msgstr ""
 
-#. GjBq3
+#. Y4ACs
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744067918\n"
+"par_id190920161744068819\n"
 "help.text"
-msgid "The notebook bar is available in Writer, Calc, Draw and Impress. The user interface has now several available layouts. To change the layout, choose <menuitem>View - User Interface</menuitem> and from the submenu select the layout which you want."
+msgid "Standard toolbar"
 msgstr ""
 
-#. eBXFy
+#. XREwu
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744066306\n"
+"par_id851612307031565\n"
 "help.text"
-msgid "Choose menu <menuitem>View - User Interface</menuitem>"
+msgid "Classic mode with two visible toolbars – standard and formatting. The sidebar is partially collapsed and shows only tabs. Intended for users who are familiar with the classic interface."
 msgstr ""
 
-#. SJiku
+#. DPUVF
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"hd_id190920161911374012\n"
+"par_id190920161744069064\n"
 "help.text"
-msgid "User interface layouts"
+msgid "Tabbed"
 msgstr ""
 
-#. eNYfs
+#. G3kBv
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744068946\n"
+"par_id651612308171162\n"
 "help.text"
-msgid "The <emph>User Interface</emph> entry defines which user interface elements are visible. The following three layouts are not of notebook bar type:"
+msgid "In this mode, the bar is divided into tabs, where each tab displays a set of icons grouped by context. The context can also change depending on the object selected in the document, for example a table or an image. The Tabbed user interface is the most similar to the Ribbons used in Microsoft Office. It organizes functions in tabs and makes the main menu obsolete."
 msgstr ""
 
-#. XUKfA
+#. Z3syw
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744068819\n"
+"hd_id121612308178510\n"
 "help.text"
-msgid "<emph>Standard toolbar</emph> – classic mode with two visible toolbars – standard and formatting. The sidebar is partially collapsed and shows only tabs."
+msgid "Tabbed compact"
 msgstr ""
 
-#. RmGcF
+#. S64Hx
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744061192\n"
+"par_id91612308184979\n"
 "help.text"
-msgid "<emph>Single toolbar</emph> – one toolbar with all frequently used features. The sidebar is collapsed."
+msgid "The Tabbed Compact variant aims to be familiar with the Microsoft Office interface, yet occupying less space for smaller screens."
 msgstr ""
 
-#. 7gMq7
+#. TFCoD
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744069136\n"
+"hd_id701612308190664\n"
 "help.text"
-msgid "<emph>Sidebar</emph> – The sidebar is fully opened and only one toolbar is showed – formatting toolbar."
+msgid "Groupedbar compact"
 msgstr ""
 
-#. SEtCx
+#. F2FbK
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744063797\n"
+"par_id381612308201500\n"
 "help.text"
-msgid "When user activates additional toolbars, they will be saved in the user profile. Therefore, on returning from the notebook bar mode, all toolbars set visible before will show again."
+msgid "The Groupedbar Compact interface provides access to functions in groups, with icons for most-frequently used features, and dropdown menus for others. This compact variant favors vertical space."
 msgstr ""
 
-#. kWX9d
+#. Nn5my
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"hd_id190920161744069618\n"
+"par_id190920161744063712\n"
 "help.text"
-msgid "Available Notebook bar modes"
+msgid "Contextual single"
 msgstr ""
 
-#. NEESh
+#. kFfNM
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744063875\n"
+"par_id581612307790744\n"
 "help.text"
-msgid "In a notebook bar mode, all toolbar and sidebar are hidden and the notebook bar is placed on the top."
+msgid "The Contextual Single interface shows functions in a single-line toolbar with context-dependent content."
 msgstr ""
 
-#. FBGD4
+#. fH7Zn
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744069064\n"
+"par_id190920161744061192\n"
 "help.text"
-msgid "<emph>Tabbed</emph> – In this mode, the bar is divided into tabs, where each tab displays a set of icons grouped by context. The context can also change depending on the object selected in the document, for example a table or an image."
+msgid "Single toolbar"
 msgstr ""
 
-#. mhdGc
+#. 7tFzV
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744064039\n"
+"par_id531612307932017\n"
 "help.text"
-msgid "In the tabbed mode the menu bar is hidden by default. To display the menu bar, select the <emph>Menubar</emph> icon at the top-left position of the window."
+msgid "Standard user interface but with single-line toolbar. Intended for use on small screens. The sidebar is collapsed."
 msgstr ""
 
-#. d9XHr
+#. W6yav
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744067802\n"
+"par_id190920161744069136\n"
 "help.text"
-msgid "<emph>Contextual groups</emph> – The notebook bar is divided into 4 groups. The File, Clipboard and Text groups are fixed. The Insert group contents are replaced with commands that depends on the nature of the selected object in the document, as for a table, an image or an OLE object."
+msgid "Sidebar"
 msgstr ""
 
-#. AuxmH
+#. udotR
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744063712\n"
+"par_id411612308221445\n"
 "help.text"
-msgid "<emph>Contextual single</emph> – Displays a single centered toolbar with context-dependent contents."
+msgid "Standard user interface with expanded sidebar. Expert users who want to quickly change many different properties are advised to use this user interface."
 msgstr ""
 
-#. xDDBG
+#. SEtCx
 #: notebook_bar.xhp
 msgctxt ""
 "notebook_bar.xhp\n"
-"par_id190920161744063446\n"
+"par_id190920161744063797\n"
 "help.text"
-msgid "<emph>Groupedbar</emph> – The bar is divided into groups that contain commands organized as icon sets and menus."
+msgid "When user activates additional toolbars, they will be saved in the user profile. Therefore, on returning from the notebook bar mode, all toolbars set visible before will show again."
 msgstr ""
 
 #. Jrez7
diff --git a/source/sq/helpcontent2/source/text/shared/04.po b/source/sq/helpcontent2/source/text/shared/04.po
index 1077a258372..13ec62ed8e6 100644
--- a/source/sq/helpcontent2/source/text/shared/04.po
+++ b/source/sq/helpcontent2/source/text/shared/04.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: 2020-10-27 12:31+0100\n"
+"POT-Creation-Date: 2021-02-05 18:59+0100\n"
 "PO-Revision-Date: 2018-07-08 16:55+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -754,13 +754,13 @@ msgctxt ""
 msgid "F6"
 msgstr ""
 
-#. RY4As
+#. G8yZx
 #: 01010000.xhp
 msgctxt ""
 "01010000.xhp\n"
 "par_id3144506\n"
 "help.text"
-msgid "Sets focus in next subwindow, for example, document/data source view."
+msgid "Sets focus in next visible subwindow, including menu bar, toolbars, windows such as Sidebar and Navigator, and document canvas/data source."
 msgstr ""
 
 #. Enxuj
@@ -781,6 +781,24 @@ msgctxt ""
 msgid "Sets focus in previous subwindow."
 msgstr ""
 
+#. BnTGx
+#: 01010000.xhp
+msgctxt ""
+"01010000.xhp\n"
+"par_id341612296864115\n"
+"help.text"
+msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+F6</keycode>"
+msgstr ""
+
+#. SvF5v
+#: 01010000.xhp
+msgctxt ""
+"01010000.xhp\n"
+"par_id521612296878916\n"
+"help.text"
+msgid "Sets focus in the document canvas/data source."
+msgstr ""
+
 #. Y7pzu
 #: 01010000.xhp
 msgctxt ""
@@ -817,6 +835,24 @@ msgctxt ""
 msgid "Opens the context menu."
 msgstr "Meny kyçur/çkyçur"
 
+#. GSfvr
+#: 01010000.xhp
+msgctxt ""
+"01010000.xhp\n"
+"par_id631612398592490\n"
+"help.text"
+msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Shift+F10</keycode>"
+msgstr ""
+
+#. QFqB4
+#: 01010000.xhp
+msgctxt ""
+"01010000.xhp\n"
+"par_id111612398626979\n"
+"help.text"
+msgid "Docks and undocks floating subwindows such as unlocked toolbars, Sidebar and Navigator."
+msgstr ""
+
 #. CFAWe
 #: 01010000.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/shared/explorer/database.po b/source/sq/helpcontent2/source/text/shared/explorer/database.po
index 3056efc49d8..d8e83482e0b 100644
--- a/source/sq/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/sq/helpcontent2/source/text/shared/explorer/database.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-01-14 18:09+0100\n"
+"POT-Creation-Date: 2021-02-01 17:02+0100\n"
 "PO-Revision-Date: 2018-11-12 14:07+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -16,600 +16,6 @@ msgstr ""
 "X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1542031624.000000\n"
 
-#. NYfPs
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Table Design"
-msgstr "Dizajni i tabeles..."
-
-#. nowKn
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3154228\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05010000.xhp\" name=\"Table Design\">Table Design</link>"
-msgstr ""
-
-#. fQvmC
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3152363\n"
-"help.text"
-msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table."
-msgstr ""
-
-#. BEMur
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3146957\n"
-"help.text"
-msgid "The window has its own menu bar. It also contains the following new command: <link href=\"text/shared/explorer/database/05010100.xhp\" name=\"Index Design\"><emph>Index Design</emph></link>"
-msgstr ""
-
-#. z6hA5
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3152551\n"
-"help.text"
-msgid "Table definition area"
-msgstr "Zona e numrit të sllajdit"
-
-#. xmBqj
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3153681\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_BACKGROUND\">This area is where you define the table structure.</ahelp>"
-msgstr ""
-
-#. FfuwA
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3153031\n"
-"help.text"
-msgid "Field Name"
-msgstr "Emri i fushës"
-
-#. GiHyW
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3156113\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp>"
-msgstr ""
-
-#. QNg69
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3147618\n"
-"help.text"
-msgid "Field type"
-msgstr "Lloji  i publikimit"
-
-#. eK4to
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3154897\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type. The available field types are limited by the database engine being used.</ahelp>"
-msgstr ""
-
-#. Ehy3n
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3156119\n"
-"help.text"
-msgid "Description"
-msgstr "Përshkrimi"
-
-#. 96xiG
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3145315\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>"
-msgstr ""
-
-#. A99ei
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3155630\n"
-"help.text"
-msgid "The row headers contain the following context menu commands:"
-msgstr ""
-
-#. rd8Zn
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3156330\n"
-"help.text"
-msgid "Cut"
-msgstr "Preje"
-
-#. GVxeZ
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3159157\n"
-"help.text"
-msgid "Cuts the selected row to the clipboard."
-msgstr ""
-
-#. JxTSq
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3159177\n"
-"help.text"
-msgid "Copy"
-msgstr "Kopjo"
-
-#. ZAjhE
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3148685\n"
-"help.text"
-msgid "Copies the selected row to the clipboard."
-msgstr ""
-
-#. Q8awG
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3156327\n"
-"help.text"
-msgid "Paste"
-msgstr "Lësho"
-
-#. 5AQBL
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3152472\n"
-"help.text"
-msgid "Pastes the content of the clipboard."
-msgstr "Përvijo në Clipboard"
-
-#. aQCGh
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3144511\n"
-"help.text"
-msgid "Delete"
-msgstr "Fshije"
-
-#. fbZPb
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3148550\n"
-"help.text"
-msgid "<ahelp hid=\".uno:Delete\">Deletes the selected row.</ahelp>"
-msgstr ""
-
-#. pD5B3
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3147303\n"
-"help.text"
-msgid "Insert Rows"
-msgstr "Futi Rreshtat"
-
-#. kfUXp
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3149456\n"
-"help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp>"
-msgstr ""
-
-#. XMDuJ
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3153524\n"
-"help.text"
-msgid "Primary Key"
-msgstr "Lloj kyç"
-
-#. mmwbs
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3150398\n"
-"help.text"
-msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys."
-msgstr ""
-
-#. kDbYY
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3153104\n"
-"help.text"
-msgid "Field properties"
-msgstr "Vetitë e kornizës"
-
-#. BZPWE
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3148922\n"
-"help.text"
-msgid "Defines the field properties of the currently selected field."
-msgstr ""
-
-#. bRsW9
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3150767\n"
-"help.text"
-msgid "Length"
-msgstr "Gjatësi"
-
-#. D58RK
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3144761\n"
-"help.text"
-msgid "Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters."
-msgstr ""
-
-#. fJknL
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3154948\n"
-"help.text"
-msgid "Decimal places"
-msgstr "Vendet decimale"
-
-#. FgVqm
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3149203\n"
-"help.text"
-msgid "Specifies the number of decimal places for a numerical field or decimal field."
-msgstr ""
-
-#. mW3AN
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3156422\n"
-"help.text"
-msgid "Default value"
-msgstr "Mosparaqitje vlerash"
-
-#. HYW5B
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3125863\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_DEFAULT\">Specifies the value that is the default in new data records.</ahelp>"
-msgstr ""
-
-#. vQcGG
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3147289\n"
-"help.text"
-msgid "Format example"
-msgstr "Format tjetër"
-
-#. SqUBY
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3155131\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp>"
-msgstr ""
-
-#. BTHDk
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3154129\n"
-"help.text"
-msgid "..."
-msgstr "..."
-
-#. XEX9M
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3154146\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT\">This button opens the <link href=\"text/shared/01/05340405.xhp\" name=\"Field Format\"><emph>Field Format</emph></link> dialog.</ahelp>"
-msgstr ""
-
-#. CgbCE
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"hd_id3152576\n"
-"help.text"
-msgid "Help area"
-msgstr "Zona e fundfaqes"
-
-#. Gg783
-#: 05010000.xhp
-msgctxt ""
-"05010000.xhp\n"
-"par_id3150685\n"
-"help.text"
-msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays a help string or hint defined by the database designer for the given field.</ahelp>"
-msgstr ""
-
-#. hzJ3Q
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"tit\n"
-"help.text"
-msgid "Index design"
-msgstr "Dizajni i indeksit"
-
-#. fR7tk
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3153311\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/05010100.xhp\" name=\"Index design\">Index design</link>"
-msgstr ""
-
-#. 98zvT
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3166460\n"
-"help.text"
-msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp>"
-msgstr ""
-
-#. N85Yq
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3149578\n"
-"help.text"
-msgid "Index list"
-msgstr "Indeks liste"
-
-#. JQ5ws
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3155342\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>"
-msgstr ""
-
-#. GNgfV
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3149795\n"
-"help.text"
-msgid "New Index"
-msgstr "Indeks i ri i përdoruesit"
-
-#. hbmc3
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3150085\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_NEW\">Creates a new index.</ahelp>"
-msgstr ""
-
-#. CraTD
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3145317\n"
-"help.text"
-msgid "Delete Current Index"
-msgstr "Fshije Indeksin/Tabelën"
-
-#. CLtrt
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3154860\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_DROP\">Deletes the current index.</ahelp>"
-msgstr ""
-
-#. qxQaG
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3150986\n"
-"help.text"
-msgid "Rename Current Index"
-msgstr "Indeks i të dhënave kryesore"
-
-#. Me7m2
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3148685\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME\">Renames the current index.</ahelp>"
-msgstr ""
-
-#. h5vTM
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3153628\n"
-"help.text"
-msgid "Save Current Index"
-msgstr "Indeks i të dhënave kryesore"
-
-#. GEBFr
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3148563\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE\">Saves the current index in the data source.</ahelp>"
-msgstr ""
-
-#. JxS8c
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3154924\n"
-"help.text"
-msgid "Reset Current Index"
-msgstr "Indeks i të dhënave kryesore"
-
-#. AkcRe
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3154758\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/ID_INDEX_RESET\">Resets the current index to the setting that it had when the dialog was started.</ahelp>"
-msgstr ""
-
-#. kpk89
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3152812\n"
-"help.text"
-msgid "Index details"
-msgstr "Fsheh hollësitë"
-
-#. whVGR
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3154938\n"
-"help.text"
-msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon."
-msgstr ""
-
-#. rEFpa
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3154138\n"
-"help.text"
-msgid "Unique"
-msgstr ""
-
-#. wqFaL
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3156282\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/UNIQUE\">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity."
-msgstr ""
-
-#. SFD2p
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3150448\n"
-"help.text"
-msgid "Fields"
-msgstr "Fushat"
-
-#. KGRnz
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3147085\n"
-"help.text"
-msgid "The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list."
-msgstr ""
-
-#. ALC5T
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3149765\n"
-"help.text"
-msgid "Index field"
-msgstr "Emri i fushës"
-
-#. 2oDE4
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3158408\n"
-"help.text"
-msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_FIELD\">Displays a list of the fields in the current table. You can select more than one field.</ahelp>"
-msgstr ""
-
-#. CmQtE
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3153192\n"
-"help.text"
-msgid "Sort order"
-msgstr "renditja e klasifikimit"
-
-#. MXzBy
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3149561\n"
-"help.text"
-msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>"
-msgstr ""
-
-#. cEYAF
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"hd_id3155132\n"
-"help.text"
-msgid "Close"
-msgstr "Mbylle"
-
-#. NuXdU
-#: 05010100.xhp
-msgctxt ""
-"05010100.xhp\n"
-"par_id3154190\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/close\">Closes the dialog.</ahelp>"
-msgstr ""
-
 #. n4gFz
 #: 05020000.xhp
 msgctxt ""
diff --git a/source/sq/helpcontent2/source/text/shared/guide.po b/source/sq/helpcontent2/source/text/shared/guide.po
index 2492d876b1e..e040fbf1807 100644
--- a/source/sq/helpcontent2/source/text/shared/guide.po
+++ b/source/sq/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-19 13:13+0100\n"
+"POT-Creation-Date: 2021-02-01 17:02+0100\n"
 "PO-Revision-Date: 2018-11-14 12:10+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7612,13 +7612,13 @@ msgctxt ""
 msgid "<variable id=\"data_tabledefine\"><link href=\"text/shared/guide/data_tabledefine.xhp\" name=\"Table Design\">Table Design</link></variable>"
 msgstr ""
 
-#. 2PvzC
+#. owGgU
 #: data_tabledefine.xhp
 msgctxt ""
 "data_tabledefine.xhp\n"
 "par_id3155535\n"
 "help.text"
-msgid "This section contains information about how to create a new database table in the <link href=\"text/shared/explorer/database/05010000.xhp\" name=\"design view\">design view</link>."
+msgid "This section contains information about how to create a new database table in the <link href=\"text/sdatabase/05010000.xhp\" name=\"design view\">design view</link>."
 msgstr ""
 
 #. 39GZc
@@ -8161,13 +8161,13 @@ msgctxt ""
 msgid "Tables"
 msgstr "Tabelat"
 
-#. zkMGQ
+#. k3n7x
 #: database_main.xhp
 msgctxt ""
 "database_main.xhp\n"
 "par_id3163713\n"
 "help.text"
-msgid "<link href=\"text/shared/explorer/database/05010000.xhp\" name=\"Create new table, edit table structure\">Create new table, edit table structure</link>, <link href=\"text/shared/explorer/database/05010100.xhp\" name=\"index\">index</link>, <link href=\"text/shared/explorer/database/05020000.xhp\" name=\"relations\">relations</link>"
+msgid "<link href=\"text/sdatabase/05010000.xhp\" name=\"Create new table, edit table structure\">Create new table, edit table structure</link>, <link href=\"text/sdatabase/05010100.xhp\" name=\"index\">index</link>, <link href=\"text/shared/explorer/database/05020000.xhp\" name=\"relations\">relations</link>"
 msgstr ""
 
 #. AENyR
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2021-02-08 12:56:25 +0100
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2021-02-08 13:01:01 +0100
commit	418be5d6b01b00babc6dc695e2a768f554c7dedc (patch)
tree	8c2c3ceaa0b23a60ae924f0596689f5e61da3d25 /source/sq/helpcontent2
parent	8cb8b0716a18bd866fed08dc3c72a895b46e4cd4 (diff)