update translations for master

and force-fix errors using pocheck Change-Id: I5b89ae56a22a53d2975d3f3f34f7b854b5a0151a
author: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2021-05-05 18:03:30 +0200
committer: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> 2021-05-05 18:09:31 +0200
commit: dddf75c6f2e8840ed6966fa73989485db7c6b10b (patch)
tree: b489030e47116ef6a4fbccbe5fbe5537d03f6eb3 /source/lo/helpcontent2/source
parent: 926713ac8f969ab8b246090eb8f3c4c48bead223 (diff)
8 files changed, 2360 insertions, 929 deletions
diff --git a/source/lo/helpcontent2/source/text/sbasic/python.po b/source/lo/helpcontent2/source/text/sbasic/python.po
index b21d45bbe95..59fdd58d11f 100644
--- a/source/lo/helpcontent2/source/text/sbasic/python.po
+++ b/source/lo/helpcontent2/source/text/sbasic/python.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-03-19 17:31+0100\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2443,13 +2443,13 @@ msgctxt ""
 msgid "Python : Programming with Python"
 msgstr ""
 
-#. bG2BP
+#. g4R9j
 #: python_programming.xhp
 msgctxt ""
 "python_programming.xhp\n"
 "N0218\n"
 "help.text"
-msgid "<bookmark_value>Python;Programming</bookmark_value>        <bookmark_value>XSCRIPTCONTEXT;Python</bookmark_value>        <bookmark_value>uno.py</bookmark_value>"
+msgid "<bookmark_value>Python;Programming</bookmark_value>        <bookmark_value>XSCRIPTCONTEXT;Python</bookmark_value>        <bookmark_value>XSCRIPTCONTEXT;getComponentContext()</bookmark_value>        <bookmark_value>uno.py</bookmark_value>        <bookmark_value>uno.py;getComponentContext()</bookmark_value>"
 msgstr ""
 
 #. CU6JS
diff --git a/source/lo/helpcontent2/source/text/sbasic/shared.po b/source/lo/helpcontent2/source/text/sbasic/shared.po
index 403ec7c8661..839a499fb87 100644
--- a/source/lo/helpcontent2/source/text/sbasic/shared.po
+++ b/source/lo/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-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-10-21 20:25+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2185,6 +2185,51 @@ msgctxt ""
 msgid "Once you have declared a variable as a certain type, you cannot declare the variable under the same name again as a different type!"
 msgstr ""
 
+#. V5Csc
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id421619551219763\n"
+"help.text"
+msgid "When you declare multiple variables in a single line of code you need to specify the type of each variable. If the type of a variable is not explicitly specified, then Basic will assume that the variable is of the <emph>Variant</emph> type."
+msgstr ""
+
+#. FzKND
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id321619555442706\n"
+"help.text"
+msgid "' Both variables \"a\" and \"b\" are of the Integer type"
+msgstr ""
+
+#. NCE7F
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id451619555463988\n"
+"help.text"
+msgid "' Variable \"c\" is a Variant and \"d\" is an Integer"
+msgstr ""
+
+#. fsaNa
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id161619555482237\n"
+"help.text"
+msgid "' A variable can also be explicitly declared as a Variant"
+msgstr ""
+
+#. uQD9L
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id521619551687371\n"
+"help.text"
+msgid "The <emph>Variant</emph> type is a special data type that can store any kind of value. To learn more, refer to the section <link href=\"text/sbasic/shared/01020100.xhp#VariantTypeH2\" name=\"Variant Type\">The Variant type</link> below."
+msgstr ""
+
 #. RENXG
 #: 01020100.xhp
 msgctxt ""
@@ -2536,6 +2581,114 @@ msgctxt ""
 msgid "dob = #2010-09-28#"
 msgstr ""
 
+#. pCPWV
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bm_id601619552599885\n"
+"help.text"
+msgid "<bookmark_value>The Variant type</bookmark_value>  <bookmark_value>The Any type</bookmark_value>"
+msgstr ""
+
+#. mPKPe
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"VariantTypeH2\n"
+"help.text"
+msgid "The Variant type"
+msgstr ""
+
+#. gnP2t
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id1001619552129323\n"
+"help.text"
+msgid "Variables declared as <emph>Variant</emph> can handle any data type. This means that the actual data type is defined during runtime as a value is assigned to the variable."
+msgstr ""
+
+#. kKQzr
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id631619552417188\n"
+"help.text"
+msgid "There are three main ways to create a <emph>Variant</emph> variable, as shown below:"
+msgstr ""
+
+#. ZTswL
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id751619554900163\n"
+"help.text"
+msgid "Dim varA            ' The type is not specified, hence the variable is a Variant"
+msgstr ""
+
+#. 3mWEB
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id181619554965451\n"
+"help.text"
+msgid "Dim varB as Variant ' The variable is explicitly declared as a Variant"
+msgstr ""
+
+#. vEpTz
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id371619554853094\n"
+"help.text"
+msgid "varC = \"abc\"        ' Previously undeclared variables are treated as Variants"
+msgstr ""
+
+#. PDFED
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id631619552417343\n"
+"help.text"
+msgid "The example below uses the <link href=\"text/sbasic/shared/03103600.xhp\" name=\"TypeName function\">TypeName function</link> to show how the type of a <emph>Variant</emph> variable changes upon assignment."
+msgstr ""
+
+#. smtqw
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id141619553442668\n"
+"help.text"
+msgid "A <emph>Variant</emph> variable is initialized with the <link href=\"text/sbasic/shared/03040000.xhp#objectconstants\" name=\" object constants\">Empty</link> special data type. You can use the <link href=\"text/sbasic/shared/03102400.xhp\" name=\"IsEmpty function\">IsEmpty function</link> to test if a variable is an <emph>Empty Variant</emph>."
+msgstr ""
+
+#. aervF
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id541619552755706\n"
+"help.text"
+msgid "You can also use the keyword <emph>Any</emph> to declare a variable as a <emph>Variant</emph>. However, <emph>Any</emph> is deprecated and is available for backward compatibility."
+msgstr ""
+
+#. 74VtP
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"par_id711619622934043\n"
+"help.text"
+msgid "Arguments with type <emph>Variant</emph> or <emph>Any</emph> passed in function calls are not checked for their types."
+msgstr ""
+
+#. qFpUB
+#: 01020100.xhp
+msgctxt ""
+"01020100.xhp\n"
+"bas_id141619552837486\n"
+"help.text"
+msgid "Dim myVar As Any ' Variable \"myVar\" is a Variant"
+msgstr ""
+
 #. kGGKi
 #: 01020100.xhp
 msgctxt ""
@@ -7873,31 +8026,31 @@ msgctxt ""
 msgid "Displays a dialog box containing a message."
 msgstr ""
 
-#. 6pAvx
+#. rXKix
 #: 03010101.xhp
 msgctxt ""
 "03010101.xhp\n"
 "par_id3148798\n"
 "help.text"
-msgid "<emph>Prompt</emph>: String expression displayed as a message in the dialog box. Line breaks can be inserted with Chr$(13)."
+msgid "<emph>prompt</emph>: String expression displayed as a message in the dialog box. Line breaks can be inserted with Chr$(13)."
 msgstr ""
 
-#. wNFv5
+#. oK5f6
 #: 03010101.xhp
 msgctxt ""
 "03010101.xhp\n"
 "par_id3150769\n"
 "help.text"
-msgid "<emph>Title</emph>: String expression displayed in the title bar of the dialog. If omitted, the title bar displays the name of the respective application."
+msgid "<emph>title</emph>: String expression displayed in the title bar of the dialog. If omitted, the title bar displays the name of the respective application."
 msgstr ""
 
-#. aC93y
+#. HPRQD
 #: 03010101.xhp
 msgctxt ""
 "03010101.xhp\n"
 "par_id3147228\n"
 "help.text"
-msgid "<emph>Buttons</emph>: Any integer expression that specifies the dialog type, as well as the number and type of buttons to display, and the icon type. <emph>Buttons</emph> represents a combination of bit patterns, that is, a combination of elements can be defined by adding their respective values:"
+msgid "<emph>buttons</emph>: Any integer expression that specifies the dialog type, as well as the number and type of buttons to display, and the icon type. <emph>Buttons</emph> represents a combination of bit patterns, that is, a combination of elements can be defined by adding their respective values:"
 msgstr ""
 
 #. xuEUm
@@ -8458,58 +8611,58 @@ msgctxt ""
 msgid "The <emph>InputBox</emph> statement is a convenient method of entering text through a dialog. Confirm the input by clicking OK or pressing Return. The input is returned as the function return value. If you close the dialog with Cancel, <emph>InputBox</emph> returns a zero-length string (\"\")."
 msgstr ""
 
-#. G7eXr
+#. fcMCj
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3153311\n"
 "help.text"
-msgid "<emph>Prompt</emph>: String expression displayed as the message in the dialog box."
+msgid "<emph>prompt</emph>: String expression displayed as the message in the dialog box."
 msgstr ""
 
-#. 66zGG
+#. kqAw6
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3145315\n"
 "help.text"
-msgid "<emph>Title</emph>: String expression displayed in the title bar of the dialog box."
+msgid "<emph>title</emph>: String expression displayed in the title bar of the dialog box."
 msgstr ""
 
-#. b7vFT
+#. 4qoJn
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3154307\n"
 "help.text"
-msgid "<emph>Default</emph>: String expression displayed in the text box as default if no other input is given."
+msgid "<emph>default</emph>: String expression displayed in the text box as default if no other input is given."
 msgstr ""
 
-#. Cs49h
+#. w5QhP
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3147573\n"
 "help.text"
-msgid "<emph>xPosTwips</emph>: Integer expression that specifies the horizontal position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application."
+msgid "<emph>xpostwips</emph>: Integer expression that specifies the horizontal position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application."
 msgstr ""
 
-#. QyymW
+#. CannW
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3156024\n"
 "help.text"
-msgid "<emph>yPosTwips</emph>: Integer expression that specifies the vertical position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application."
+msgid "<emph>ypostwips</emph>: Integer expression that specifies the vertical position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application."
 msgstr ""
 
-#. 8pC7C
+#. m6iBC
 #: 03010201.xhp
 msgctxt ""
 "03010201.xhp\n"
 "par_id3153897\n"
 "help.text"
-msgid "If <emph>xPosTwips</emph> and <emph>yPosTwips</emph> are omitted, the dialog is centered on the screen. The position is specified in <link href=\"text/sbasic/shared/00000002.xhp#twips\" name=\"twips\">twips</link>."
+msgid "If <literal>xpostwips</literal> and <literal>yPosTwips</literal> are omitted, the dialog is centered on the screen. The position is specified in <link href=\"text/sbasic/shared/00000002.xhp#twips\" name=\"twips\">twips</link>."
 msgstr ""
 
 #. Mh8Z6
@@ -9331,31 +9484,31 @@ msgctxt ""
 msgid "Parameter:"
 msgstr ""
 
-#. pP9x5
+#. QM73e
 #: 03010305.xhp
 msgctxt ""
 "03010305.xhp\n"
 "par_id3152597\n"
 "help.text"
-msgid "<emph>Red</emph>: Any integer expression that represents the red component (0-255) of the composite color."
+msgid "<emph>red</emph>: Any integer expression that represents the red component (0-255) of the composite color."
 msgstr ""
 
-#. pbFvi
+#. H7yGv
 #: 03010305.xhp
 msgctxt ""
 "03010305.xhp\n"
 "par_id3146974\n"
 "help.text"
-msgid "<emph>Green</emph>: Any integer expression that represents the green component (0-255) of the composite color."
+msgid "<emph>green</emph>: Any integer expression that represents the green component (0-255) of the composite color."
 msgstr ""
 
-#. XG6FB
+#. t8P2M
 #: 03010305.xhp
 msgctxt ""
 "03010305.xhp\n"
 "par_id3151113\n"
 "help.text"
-msgid "<emph>Blue</emph>: Any integer expression that represents the blue component (0-255) of the composite color."
+msgid "<emph>blue</emph>: Any integer expression that represents the blue component (0-255) of the composite color."
 msgstr ""
 
 #. cFpDD
@@ -13075,67 +13228,31 @@ msgctxt ""
 msgid "Returns a date value from a date string. The date string is a complete date in a single numeric value. You can also use this serial number to determine the difference between two dates."
 msgstr ""
 
-#. QJz7y
-#: 03030102.xhp
-msgctxt ""
-"03030102.xhp\n"
-"hd_id3148799\n"
-"help.text"
-msgid "Syntax:"
-msgstr ""
-
-#. 3FsEa
+#. PxEGo
 #: 03030102.xhp
 msgctxt ""
 "03030102.xhp\n"
 "par_id3154910\n"
 "help.text"
-msgid "DateValue [(date)]"
-msgstr ""
-
-#. B7CrF
-#: 03030102.xhp
-msgctxt ""
-"03030102.xhp\n"
-"hd_id3150870\n"
-"help.text"
-msgid "Return value:"
-msgstr ""
-
-#. 4G37B
-#: 03030102.xhp
-msgctxt ""
-"03030102.xhp\n"
-"par_id3153194\n"
-"help.text"
-msgid "Date"
+msgid "DateValue(date)"
 msgstr ""
 
-#. NHYd9
-#: 03030102.xhp
-msgctxt ""
-"03030102.xhp\n"
-"hd_id3153969\n"
-"help.text"
-msgid "Parameters:"
-msgstr ""
-
-#. ghsyA
+#. vxxyq
 #: 03030102.xhp
 msgctxt ""
 "03030102.xhp\n"
 "par_id3153770\n"
 "help.text"
-msgid "<emph>Date:</emph> String expression that contains the date that you want to calculate. In contrast to the DateSerial function that passes years, months and days as separate numeric values, the DateValue function requests the date string to be according to either one of the date acceptance patterns defined for your locale setting (see <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - Language Settings - Languages</menuitem>) or to ISO date format (momentarily, only the ISO format with hyphens, e.g. \"2012-12-31\" is accepted)."
+msgid "<emph>Date</emph>: String expression that contains the date that you want to calculate. In contrast to the DateSerial function that passes years, months and days as separate numeric values, the DateValue function requests the date string to be according to either one of the date acceptance patterns defined for your locale setting (see <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - Language Settings - Languages</menuitem>) or to ISO date format (momentarily, only the ISO format with hyphens, e.g. \"2012-12-31\" is accepted)."
 msgstr ""
 
-#. EWVzU
+#. KmwFZ
 #: 03030102.xhp
 msgctxt ""
 "03030102.xhp\n"
-"hd_id3153142\n"
+"par_id3153194\n"
 "help.text"
-msgid "Example:"
+msgid "The computed date."
 msgstr ""
 
 #. wDviP
@@ -14893,22 +15010,22 @@ msgctxt ""
 msgid "<emph>date1, date2</emph> - The two date values to be compared."
 msgstr ""
 
-#. yVo8Q
+#. e7hMm
 #: 03030120.xhp
 msgctxt ""
 "03030120.xhp\n"
 "par_idN1066A\n"
 "help.text"
-msgid "<emph>firstDayOfWeek</emph> - An optional parameter that specifies the starting day of a week."
+msgid "<emph>firstdayofweek</emph>: An optional parameter that specifies the starting day of a week."
 msgstr ""
 
-#. dDoRU
+#. wpCoP
 #: 03030120.xhp
 msgctxt ""
 "03030120.xhp\n"
 "par_idN1067A\n"
 "help.text"
-msgid "firstDayOfWeek value"
+msgid "firstdayofweek value"
 msgstr ""
 
 #. gmaR8
@@ -15064,22 +15181,22 @@ msgctxt ""
 msgid "Saturday"
 msgstr ""
 
-#. BLhqf
+#. E5nqv
 #: 03030120.xhp
 msgctxt ""
 "03030120.xhp\n"
 "par_idN106EB\n"
 "help.text"
-msgid "<emph>firstWeekOfYear</emph> - An optional parameter that specifies the starting week of a year."
+msgid "<emph>firstweekofyear</emph>: An optional parameter that specifies the starting week of a year."
 msgstr ""
 
-#. KGncd
+#. e3gQd
 #: 03030120.xhp
 msgctxt ""
 "03030120.xhp\n"
 "par_idN106FB\n"
 "help.text"
-msgid "firstWeekOfYear value"
+msgid "firstweekofyear value"
 msgstr ""
 
 #. zAFFS
@@ -16414,13 +16531,13 @@ msgctxt ""
 msgid "<bookmark_value>Basic constants</bookmark_value>"
 msgstr ""
 
-#. NMCZ2
+#. ev3DS
 #: 03040000.xhp
 msgctxt ""
 "03040000.xhp\n"
 "hd_id051620171022255424\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03040000.xhp\">Basic Constants</link>"
+msgid "<variable id=\"basicconstantsh1\"><link href=\"text/sbasic/shared/03040000.xhp\">Basic Constants</link></variable>"
 msgstr ""
 
 #. K6sdH
@@ -26494,13 +26611,13 @@ msgctxt ""
 msgid "<bookmark_value>Dim statement</bookmark_value>  <bookmark_value>arrays; dimensioning</bookmark_value>  <bookmark_value>dimensioning arrays</bookmark_value>"
 msgstr ""
 
-#. 4Usmk
+#. HnQSe
 #: 03102100.xhp
 msgctxt ""
 "03102100.xhp\n"
 "hd_id3149812\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03102100.xhp\" name=\"Dim Statement\">Dim Statement</link>"
+msgid "<variable id=\"Dimh1\"><link href=\"text/sbasic/shared/03102100.xhp\" name=\"Dim Statement\">Dim Statement</link></variable>"
 msgstr ""
 
 #. 9gRSS
@@ -30985,49 +31102,49 @@ msgctxt ""
 msgid "<link href=\"text/sbasic/shared/03120301.xhp\" name=\"Format Function\">Format Function</link>"
 msgstr ""
 
-#. ZAitp
+#. AfW2N
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3156042\n"
 "help.text"
-msgid "Converts a number to a string, and then formats it according to the format that you specify."
+msgid "Converts a numeric expression to a string, and then formats it according to the format that you specify."
 msgstr ""
 
-#. wp4Ae
+#. arnAa
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153527\n"
 "help.text"
-msgid "Format (Number [, Format As String])"
+msgid "Format(expression [, format As String]) As String"
 msgstr ""
 
-#. gddga
+#. v2BdG
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
-"par_id3148474\n"
+"par_id3149415\n"
 "help.text"
-msgid "String"
+msgid "<emph>expression</emph>: Numeric expression that you want to convert to a formatted string."
 msgstr ""
 
-#. 6Dyxg
+#. p5nFg
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
-"par_id3149415\n"
+"par_id3147531\n"
 "help.text"
-msgid "<emph>Number:</emph> Numeric expression that you want to convert to a formatted string."
+msgid "<emph>format</emph>: String that specifies the format code for the number. If <literal>format</literal> is omitted, the Format function works like the %PRODUCTNAME Basic <literal>Str()</literal> function."
 msgstr ""
 
-#. G3TNy
+#. Mh6xN
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
-"par_id3147531\n"
+"par_id3148474\n"
 "help.text"
-msgid "<emph>Format:</emph> String that specifies the format code for the number. If <emph>Format</emph> is omitted, the Format function works like the <emph>Str</emph> function."
+msgid "Text string."
 msgstr ""
 
 #. 8DmPW
@@ -31039,58 +31156,58 @@ msgctxt ""
 msgid "Formatting Codes"
 msgstr ""
 
-#. j9pBf
+#. 4TDkj
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3147265\n"
 "help.text"
-msgid "The following list describes the codes that you can use for formatting a number:"
+msgid "The following list describes the codes that you can use for formatting a numeric expression:"
 msgstr ""
 
-#. AA4AR
+#. LJGi5
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153380\n"
 "help.text"
-msgid "<emph>0:</emph> If <emph>Number</emph> has a digit at the position of the 0 in the format code, the digit is displayed, otherwise a zero is displayed."
+msgid "<emph>0:</emph> If <literal>expression</literal> has a digit at the position of the 0 in the <literal>format</literal> code, the digit is displayed, otherwise a zero is displayed."
 msgstr ""
 
-#. 6hoDN
+#. MRyQ7
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3151210\n"
 "help.text"
-msgid "If <emph>Number</emph> has fewer digits than the number of zeros in the format code, (on either side of the decimal), leading or trailing zeros are displayed. If the number has more digits to the left of the decimal separator than the amount of zeros in the format code, the additional digits are displayed without formatting."
+msgid "If <literal>expression</literal> has fewer digits than the number of zeros in the <literal>format</literal> code, (on either side of the decimal), leading or trailing zeros are displayed. If the <literal>expression</literal> has more digits to the left of the decimal separator than the amount of zeros in the <literal>format</literal> code, the additional digits are displayed without formatting."
 msgstr ""
 
-#. EDBbq
+#. bYkcA
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3151176\n"
 "help.text"
-msgid "Decimal places in the number are rounded according to the number of zeros that appear after the decimal separator in the <emph>Format </emph>code."
+msgid "Decimal places in the <literal>expression</literal> are rounded according to the number of zeros that appear after the decimal separator in the <literal>format</literal> code."
 msgstr ""
 
-#. ucKaQ
+#. Cypxj
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3154123\n"
 "help.text"
-msgid "<emph>#:</emph> If <emph>Number</emph> contains a digit at the position of the # placeholder in the <emph>Format</emph> code, the digit is displayed, otherwise nothing is displayed at this position."
+msgid "<emph>#:</emph> If <literal>expression</literal> contains a digit at the position of the # placeholder in the <literal>format</literal> code, the digit is displayed, otherwise nothing is displayed at this position."
 msgstr ""
 
-#. EKGPx
+#. Mst5g
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3148452\n"
 "help.text"
-msgid "This symbol works like the 0, except that leading or trailing zeroes are not displayed if there are more # characters in the format code than digits in the number. Only the relevant digits of the number are displayed."
+msgid "This symbol works like the 0, except that leading or trailing zeroes are not displayed if there are more # characters in the <literal>format</literal> code than digits in the <literal>expression</literal>. Only the relevant digits of the <literal>expression</literal> are displayed."
 msgstr ""
 
 #. Cnq7B
@@ -31102,31 +31219,31 @@ msgctxt ""
 msgid "<emph>.:</emph> The decimal placeholder determines the number of decimal places to the left and right of the decimal separator."
 msgstr ""
 
-#. tWDUe
+#. ehB5x
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3159252\n"
 "help.text"
-msgid "If the format code contains only # placeholders to the left of this symbol, numbers less than 1 begin with a decimal separator. To always display a leading zero with fractional numbers, use 0 as a placeholder for the first digit to the left of the decimal separator."
+msgid "If the <literal>format</literal> code contains only # placeholders to the left of this symbol, numbers less than 1 begin with a decimal separator. To always display a leading zero with fractional numbers, use 0 as a placeholder for the first digit to the left of the decimal separator."
 msgstr ""
 
-#. L7ry6
+#. yMgJz
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153368\n"
 "help.text"
-msgid "<emph>%:</emph> Multiplies the number by 100 and inserts the percent sign (%) where the number appears in the format code."
+msgid "<emph>%:</emph> Multiplies the <literal>expression</literal>by 100 and inserts the percent sign (%) where the <literal>expression</literal> appears in the <literal>format</literal> code."
 msgstr ""
 
-#. 5A2Kp
+#. prkKA
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3149481\n"
 "help.text"
-msgid "<emph>E- E+ e- e+ :</emph> If the format code contains at least one digit placeholder (0 or #) to the right of the symbol E-, E+, e-, or e+, the number is formatted in the scientific or exponential format. The letter E or e is inserted between the number and the exponent. The number of placeholders for digits to the right of the symbol determines the number of digits in the exponent."
+msgid "<emph>E- E+ e- e+ :</emph> If the <literal>format</literal> code contains at least one digit placeholder (0 or #) to the right of the symbol E-, E+, e-, or e+, the <literal>expression</literal> is formatted in the scientific or exponential format. The letter E or e is inserted between the number and the exponent. The number of placeholders for digits to the right of the symbol determines the number of digits in the exponent."
 msgstr ""
 
 #. jhCb5
@@ -31138,13 +31255,13 @@ msgctxt ""
 msgid "If the exponent is negative, a minus sign is displayed directly before an exponent with E-, E+, e-, e+. If the exponent is positive, a plus sign is only displayed before exponents with E+ or e+."
 msgstr ""
 
-#. shj6y
+#. WTvZT
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3148617\n"
 "help.text"
-msgid "The thousands delimiter is displayed if the format code contains the delimiter enclosed by digit placeholders (0 or #)."
+msgid "The thousands delimiter is displayed if the <literal>format</literal> code contains the delimiter enclosed by digit placeholders (0 or #)."
 msgstr ""
 
 #. A8QmE
@@ -31156,13 +31273,13 @@ msgctxt ""
 msgid "The use of a period as a thousands and decimal separator is dependent on the regional setting. When you enter a number directly in Basic source code, always use a period as decimal delimiter. The actual character displayed as a decimal separator depends on the number format in your system settings."
 msgstr ""
 
-#. 5EMgE
+#. sxDcc
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3152887\n"
 "help.text"
-msgid "<emph>- + $ ( ) space:</emph> A plus (+), minus (-), dollar ($), space, or brackets entered directly in the format code is displayed as a literal character."
+msgid "<emph>- + $ ( ) space:</emph> A plus (+), minus (-), dollar ($), space, or brackets entered directly in the <literal>format</literal> code is displayed as a literal character."
 msgstr ""
 
 #. PyKZq
@@ -31174,22 +31291,22 @@ msgctxt ""
 msgid "To display characters other than the ones listed here, you must precede it by a backslash (\\), or enclose it in quotation marks (\" \")."
 msgstr ""
 
-#. 2VEmR
+#. SqAeG
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153139\n"
 "help.text"
-msgid "\\ : The backslash displays the next character in the format code."
+msgid "<emph>\\ :</emph> The backslash displays the next character in the <literal>format</literal> code."
 msgstr ""
 
-#. UFfdk
+#. CBbYy
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153366\n"
 "help.text"
-msgid "Characters in the format code that have a special meaning can only be displayed as literal characters if they are preceded by a backslash. The backslash itself is not displayed, unless you enter a double backslash (\\\\) in the format code."
+msgid "Characters in the <literal>format</literal> code that have a special meaning can only be displayed as literal characters if they are preceded by a backslash. The backslash itself is not displayed, unless you enter a double backslash (\\\\) in the format code."
 msgstr ""
 
 #. L4LbT
@@ -31201,22 +31318,22 @@ msgctxt ""
 msgid "Characters that must be preceded by a backslash in the format code in order to be displayed as literal characters are date- and time-formatting characters (a, c, d, h, m, n, p, q, s, t, w, y, /, :), numeric-formatting characters (#, 0, %, E, e, comma, period), and string-formatting characters (@, &, <, >, !)."
 msgstr ""
 
-#. NN8eT
+#. BCQqy
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3145749\n"
 "help.text"
-msgid "You can also use the following predefined number formats. Except for \"General Number\", all of the predefined format codes return the number as a decimal number with two decimal places."
+msgid "You can also use the following predefined number formats. Except for <literal>\"General Number\"</literal>, all of the predefined format codes return the number as a decimal number with two decimal places."
 msgstr ""
 
-#. fkPvC
+#. MDb3h
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3150113\n"
 "help.text"
-msgid "If you use predefined formats, the name of the format must be enclosed in quotation marks."
+msgid "If you use predefined formats, the name of the <literal>format</literal> must be enclosed in quotation marks."
 msgstr ""
 
 #. GT9Rs
@@ -31282,13 +31399,13 @@ msgctxt ""
 msgid "<emph>Scientific:</emph> Displays numbers in scientific format (for example, 1.00E+03 for 1000)."
 msgstr ""
 
-#. cMtWm
+#. AAj9K
 #: 03120301.xhp
 msgctxt ""
 "03120301.xhp\n"
 "par_id3153707\n"
 "help.text"
-msgid "A format code can be divided into three sections that are separated by semicolons. The first part defines the format for positive values, the second part for negative values, and the third part for zero. If you only specify one format code, it applies to all numbers."
+msgid "A <literal>format</literal> code can be divided into three sections that are separated by semicolons. The first part defines the format for positive values, the second part for negative values, and the third part for zero. If you only specify one <literal>format</literal> code, it applies to all numbers."
 msgstr ""
 
 #. ZsNPC
diff --git a/source/lo/helpcontent2/source/text/sbasic/shared/03.po b/source/lo/helpcontent2/source/text/sbasic/shared/03.po
index 67004d84027..487f4db3b81 100644
--- a/source/lo/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/lo/helpcontent2/source/text/sbasic/shared/03.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-07-12 14:33+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -79,6 +79,15 @@ msgctxt ""
 msgid "These methods are available from %PRODUCTNAME 7.2 onwards."
 msgstr ""
 
+#. An73n
+#: avail_release.xhp
+msgctxt ""
+"avail_release.xhp\n"
+"par_id291613654389792\n"
+"help.text"
+msgid "This method is available from %PRODUCTNAME 7.2 onwards."
+msgstr ""
+
 #. qjuHF
 #: avail_release.xhp
 msgctxt ""
@@ -115,13 +124,13 @@ msgctxt ""
 msgid "ScriptForge Libraries"
 msgstr ""
 
-#. NXPBo
+#. ADEeP
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
 "hd_id31529004750471\n"
 "help.text"
-msgid "<variable id=\"ScriptForge_lib\"><link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"ScriptForge library\">The <item type=\"literal\">ScriptForge</item> Library</link></variable>"
+msgid "<variable id=\"ScriptForge_lib\"><link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"ScriptForge library\">The <literal>ScriptForge</literal> Library</link></variable>"
 msgstr ""
 
 #. nMjDG
@@ -133,31 +142,31 @@ msgctxt ""
 msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value>"
 msgstr ""
 
-#. WLejn
+#. BtMUU
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
-"par_id781606153472028\n"
+"par_id681619700336879\n"
 "help.text"
-msgid "The described modules and classes are invoked from user scripts as \"Services\". A generic constructor of those services has been designed for that purpose:"
+msgid "ScriptForge libraries build up an extensible collection of macro scripting resources for %PRODUCTNAME to be invoked from Basic macros or Python scripts."
 msgstr ""
 
-#. dUu2P
+#. wKZM6
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
-"par_id891606153700196\n"
+"par_id781606153472028\n"
 "help.text"
-msgid "Services from external libraries can be registered with the <literal>RegisterScriptServices(...)</literal> method in order to extend the set of available services."
+msgid "The described modules and classes are invoked from user scripts as \"Services\". A generic constructor of those services has been designed for that purpose for each language:"
 msgstr ""
 
-#. ErFP9
+#. B3Xve
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
 "par_id851605659675843\n"
 "help.text"
-msgid "The <literal>ScriptForge</literal> Basic library is available from %PRODUCTNAME 7.1 onwards."
+msgid "The <literal>ScriptForge</literal> Basic library is available from %PRODUCTNAME 7.1 onwards.<br/>Python <literal>scriptforge</literal> module is available from %PRODUCTNAME 7.2 onwards."
 msgstr ""
 
 #. Depaw
@@ -2203,6 +2212,1275 @@ msgctxt ""
 msgid "<emph>CaseSensitive</emph> : Only if the array is populated with texts, default = <literal>False</literal>."
 msgstr ""
 
+#. GAXAU
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"tit\n"
+"help.text"
+msgid "SFDocuments.Base service"
+msgstr ""
+
+#. TiAmG
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bm_id781582391760253\n"
+"help.text"
+msgid "<variable id=\"ctrls_h1\"><link href=\"text/sbasic/shared/03/sf_base.xhp\" name=\"SFDocuments.Base service\"><literal>SFDocuments</literal>.<literal>Base</literal> service</link></variable>"
+msgstr ""
+
+#. 4KK8s
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id901619031958273\n"
+"help.text"
+msgid "The <literal>Base</literal> service provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME Base documents."
+msgstr ""
+
+#. ZxoY9
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id961619032060880\n"
+"help.text"
+msgid "This service is closely related to the <literal>Document</literal> service, which provides generic methods for handling %PRODUCTNAME documents, including Base documents. Hence, the <literal>Base</literal> service extends the <literal>Document</literal> service and provides additional methods that are specific for Base documents, enabling users to:"
+msgstr ""
+
+#. EK3gt
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id241619032289964\n"
+"help.text"
+msgid "Get access to the database contained in a Base document."
+msgstr ""
+
+#. y2wmE
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id291619032292829\n"
+"help.text"
+msgid "Open form documents stored in a Base document."
+msgstr ""
+
+#. cpnJ7
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id421619032296454\n"
+"help.text"
+msgid "Check if a form document from a Base document is currently loaded."
+msgstr ""
+
+#. myHaG
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id241619032941497\n"
+"help.text"
+msgid "Refer to the <link href=\"text/sbasic/shared/03/sf_document.xhp\" name=\"Document Service\"><literal>Document</literal> service</link> to learn more about methods and properties that can be used to manage %PRODUCTNAME documents."
+msgstr ""
+
+#. bGpRM
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. vi6hS
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id311619033224680\n"
+"help.text"
+msgid "The Base service can be invoked in a variety of ways. The code snippet below uses the method <literal>CreateBaseDocument</literal> from the <literal>UI</literal> service to create a new Base file."
+msgstr ""
+
+#. t4HPk
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id101619033666470\n"
+"help.text"
+msgid "Note that in all examples the object <literal>oDoc</literal> is an instance of the <literal>Base</literal> service."
+msgstr ""
+
+#. hKce4
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619033570656\n"
+"help.text"
+msgid "The <literal>Base</literal> service can also be instantiated while opening an existing Base file, as shown below:"
+msgstr ""
+
+#. noxU9
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id331619033713781\n"
+"help.text"
+msgid "If a Base document is already open, it is possible to instantiate the <literal>Base</literal> service directly:"
+msgstr ""
+
+#. f8Esv
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619619980185\n"
+"help.text"
+msgid "The use of the <emph>\"SFDocuments.\"</emph> substring in the previous example is optional."
+msgstr ""
+
+#. oMw4m
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id451619034669263\n"
+"help.text"
+msgid "List of Methods in the Base Service"
+msgstr ""
+
+#. ZQnqj
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id481619036833610\n"
+"help.text"
+msgid "Returns an array with the full names (path/name) of all form documents in the Base document as an zero-based Array of strings."
+msgstr ""
+
+#. sECnJ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id431619037334440\n"
+"help.text"
+msgid "The code snippet below prints the names of all form documents in the current Base document."
+msgstr ""
+
+#. DQb6z
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id921619036922844\n"
+"help.text"
+msgid "To learn more about form documents, refer to the <link href=\"text/sbasic/shared/03/sf_form.xhp\" name=\"Form service\"><literal>Form</literal> service help page</link>."
+msgstr ""
+
+#. gCGqW
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id191619037523467\n"
+"help.text"
+msgid "Depending on the parameters provided this method will return:"
+msgstr ""
+
+#. HqFmT
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id781619037575043\n"
+"help.text"
+msgid "A zero-based Array with the names of all the forms contained in a form document (if the <literal>Form</literal> argument is absent)"
+msgstr ""
+
+#. Q4Had
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id111619037577804\n"
+"help.text"
+msgid "A <literal>SFDocuments.Form</literal> object representing the form specified in the <literal>Form</literal> argument."
+msgstr ""
+
+#. mKXZE
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id861619037838260\n"
+"help.text"
+msgid "<emph>FormDocument:</emph> The name of a valid form document as a case-sensitive string."
+msgstr ""
+
+#. BtBVu
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id281619037857187\n"
+"help.text"
+msgid "<emph>Form:</emph> The name or index number of the form stored in the form document. If this argument is absent, the method will return a list with the names of all forms available in the form document."
+msgstr ""
+
+#. K4nQh
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id921619437863617\n"
+"help.text"
+msgid "Although it is possible to use index numbers to refer to forms, this is only recommended when there is just one form in the form document. If there are two or more forms, it is preferable to use the form name instead."
+msgstr ""
+
+#. vDKoa
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id231619200162092\n"
+"help.text"
+msgid "' Returns a list of all forms in the form document \"myFormDocument\""
+msgstr ""
+
+#. Hwr96
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id31619200259812\n"
+"help.text"
+msgid "' Returns an instance of the Form service representing the form \"myForm\""
+msgstr ""
+
+#. 9jA9n
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id371619098340303\n"
+"help.text"
+msgid "Returns an instance of the <link href=\"text/sbasic/shared/03/sf_database.xhp\" name=\"Database service\"><literal>Database</literal> service</link> that allows the execution of SQL commands on the database defined and/or stored in the current Base document"
+msgstr ""
+
+#. FdXAK
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id731619098073221\n"
+"help.text"
+msgid "<emph>User, Password:</emph> Optional login parameters as strings. The default value for both parameters is an empty string \"\"."
+msgstr ""
+
+#. UbzRD
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id631615147843278\n"
+"help.text"
+msgid "' User and password are supplied below, if needed"
+msgstr ""
+
+#. XBJVn
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id921599408791887\n"
+"help.text"
+msgid "'   ... Run queries, SQL statements, ..."
+msgstr ""
+
+#. mBphD
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id871619098478513\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the specified <literal>FormDocument</literal> is  currently open."
+msgstr ""
+
+#. 7nHnE
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id981619098545701\n"
+"help.text"
+msgid "<emph>FormDocument:</emph> The name of a FormDocument to be checked, as a case-sensitive string."
+msgstr ""
+
+#. RS3kj
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id801619099743199\n"
+"help.text"
+msgid "Opens the specified <literal>FormDocument</literal> either in normal or in design mode."
+msgstr ""
+
+#. 38vtF
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id451619100075330\n"
+"help.text"
+msgid "If the form document is already open, it is activated without changing its mode. The method returns <literal>True</literal> if the form document could be opened."
+msgstr ""
+
+#. EizHx
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id941619099797810\n"
+"help.text"
+msgid "<emph>FormDocument:</emph> The name of the <literal>FormDocument</literal> to be opened, as a case-sensitive string."
+msgstr ""
+
+#. BNeps
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id981619099816849\n"
+"help.text"
+msgid "<emph>DesignMode:</emph> If this argument is <literal>True</literal> the <literal>FormDocument</literal> will be opened in design mode."
+msgstr ""
+
+#. B29ng
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id251619100191992\n"
+"help.text"
+msgid "Most form documents are stored in the root of the Base document and they can be opened simply using their names, as in the example below:"
+msgstr ""
+
+#. pv3RA
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id461619100283210\n"
+"help.text"
+msgid "oDoc.OpenFormDocument(\"myFormDocument\")"
+msgstr ""
+
+#. ACLqQ
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"par_id351619100327505\n"
+"help.text"
+msgid "If form documents are organized in folders, it becomes necessary to include the folder name to specify the form document to be opened, as illustrated in the following example:"
+msgstr ""
+
+#. mLgzR
+#: sf_base.xhp
+msgctxt ""
+"sf_base.xhp\n"
+"bas_id461619100283712\n"
+"help.text"
+msgid "oDoc.OpenFormDocument(\"myFolder/myFormDocument\")"
+msgstr ""
+
+#. 3RzkD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"tit\n"
+"help.text"
+msgid "ScriptForge.Basic service"
+msgstr ""
+
+#. GxEht
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id731582733781114\n"
+"help.text"
+msgid "<variable id=\"BasicService\"><link href=\"text/sbasic/shared/03/sf_basic.xhp\" name=\"Basic service\"><literal>ScriptForge</literal>.<literal>Basic</literal> service</link></variable>"
+msgstr ""
+
+#. G5jAV
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381589189355849\n"
+"help.text"
+msgid "The <literal>ScriptForge.Basic</literal> service proposes a collection of %PRODUCTNAME Basic methods to be executed in a Python context. <literal>Basic</literal> service methods reproduce the exact syntax and behaviour of Basic builtin functions."
+msgstr ""
+
+#. Bb7Br
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id591589189364267\n"
+"help.text"
+msgid "Typical example:"
+msgstr ""
+
+#. yrYgm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id971618493778666\n"
+"help.text"
+msgid "svc.MsgBox('This has to be displayed in a message box')"
+msgstr ""
+
+#. kGyCd
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id151618849022977\n"
+"help.text"
+msgid "<literal>ScriptForge</literal>.<literal>Basic</literal> service is limited to Python scripts."
+msgstr ""
+
+#. biAQa
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id581582885621841\n"
+"help.text"
+msgid "Service invocation"
+msgstr ""
+
+#. pNUsj
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id141610734722352\n"
+"help.text"
+msgid "Before using the <literal>Basic</literal> service, import the <literal>CreateScriptService()</literal> method from the <literal>scriptforge</literal> module:"
+msgstr ""
+
+#. E6SaA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id201618922972557\n"
+"help.text"
+msgid "Properties"
+msgstr ""
+
+#. bLzCe
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id401618922991909\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. 5FcQt
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id591618922991909\n"
+"help.text"
+msgid "ReadOnly"
+msgstr ""
+
+#. N5DD5
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id211618922991909\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. qXwST
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id971618923022846\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. W8eh6
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id541619003984227\n"
+"help.text"
+msgid "MB_OK, MB_OKCANCEL, MB_RETRYCANCEL, MB_YESNO, MB_YESNOCANCEL"
+msgstr ""
+
+#. KuiAD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619004009875\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. TkYXL
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id111619004011627\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. 7DG4F
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id791619004012484\n"
+"help.text"
+msgid "Values: 0, 1, 5, 4, 3"
+msgstr ""
+
+#. oASRR
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id161619003998035\n"
+"help.text"
+msgid "MB_ICONEXCLAMATION, MB_ICONINFORMATION, MB_ICONQUESTION, MB_ICONSTOP"
+msgstr ""
+
+#. 8ie8B
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id201619004097755\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. GNqXc
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id981619004098700\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. DQkGQ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id311619004099683\n"
+"help.text"
+msgid "Values: 48, 64, 32, 16<br/>"
+msgstr ""
+
+#. RBdBG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id831618922991909\n"
+"help.text"
+msgid "MB_ABORTRETRYIGNORE, MB_DEFBUTTON1, MB_DEFBUTTON2, MB_DEFBUTTON3"
+msgstr ""
+
+#. mCpye
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id581618922991909\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. CrG3W
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id161618922991910\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. h3hZE
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id211618923312141\n"
+"help.text"
+msgid "Values: 2, 128, 256, 512"
+msgstr ""
+
+#. F3DMG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id471618924470655\n"
+"help.text"
+msgid "IDABORT, IDCANCEL, IDIGNORE, IDNO, IDOK, IDRETRY, IDYES"
+msgstr ""
+
+#. kLst4
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id961618924503848\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. XKzky
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id571618924505303\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. Tmtc2
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id871618924506654\n"
+"help.text"
+msgid "Values: 3, 2, 5, 7, 1, 4, 6<br/>Constants  indicating <literal>MsgBox</literal> selected button."
+msgstr ""
+
+#. fHLnu
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id421619006246768\n"
+"help.text"
+msgid "StarDesktop"
+msgstr ""
+
+#. BDtqm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id731619006254384\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. SKW53
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id711619006255184\n"
+"help.text"
+msgid "UNO<br/>object"
+msgstr ""
+
+#. cLAgG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id541619006255653\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/stardesktop.xhp\" name=\"StarDesktop\"><literal>StarDesktop</literal></link> object represents LibreOfficeDev Start Center."
+msgstr ""
+
+#. vXq8C
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651606319520519\n"
+"help.text"
+msgid "List of Methods in the Basic Service"
+msgstr ""
+
+#. vaMxs
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id93158919969864\n"
+"help.text"
+msgid "Returns a system path file name for the given <literal>file:</literal> URL."
+msgstr ""
+
+#. L4crp
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id321618502481706\n"
+"help.text"
+msgid "<emph>url</emph>: An absolute <literal>file:</literal> URL."
+msgstr ""
+
+#. nmEbg
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id81618502493505\n"
+"help.text"
+msgid "A system path file name."
+msgstr ""
+
+#. 7YMKT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id658519200121138\n"
+"help.text"
+msgid "Returns a <literal>file:</literal> URL for the given system path."
+msgstr ""
+
+#. ZdzNY
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id401618521015903\n"
+"help.text"
+msgid "<emph>systempath</emph>: A system file name as a string."
+msgstr ""
+
+#. BYkqo
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id61658101307414\n"
+"help.text"
+msgid "A <literal>file:</literal> URL as a string."
+msgstr ""
+
+#. kyZyo
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651589200121138\n"
+"help.text"
+msgid "Instantiates a UNO service with the <literal>ProcessServiceManager</literal>."
+msgstr ""
+
+#. 7BvYk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id361589200121646\n"
+"help.text"
+msgid "<emph>servicename</emph> : A fully qualified service name such as \"com.sun.star.ui.dialogs.FilePicker\" or 'com.sun.star.sheet.FunctionAccess'."
+msgstr ""
+
+#. rZoCx
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901599410483300\n"
+"help.text"
+msgid "Adds a date or time interval to a given date/time a number of times and returns the resulting date."
+msgstr ""
+
+#. aRMEj
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id581618562143601\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression from the following table, specifying the date or time interval."
+msgstr ""
+
+#. Vx3AB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id281618562144897\n"
+"help.text"
+msgid "<emph>number</emph>: A numerical expression specifying how often the <literal>interval</literal> value will be added when positive or subtracted when negative."
+msgstr ""
+
+#. 4C2B6
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id811618561843272\n"
+"help.text"
+msgid "<emph>date</emph>: A given datetime.datetime value, the <literal>interval</literal> value will be added number times to this date/time value."
+msgstr ""
+
+#. ppBnh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id181618561778320\n"
+"help.text"
+msgid "A datetime.datetime value."
+msgstr ""
+
+#. HAVdW
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id991589202413257\n"
+"help.text"
+msgid "Returns the number of date or time intervals between two given date/time values."
+msgstr ""
+
+#. 2HBSe
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id481618563770490\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression  specifying the date interval, as detailed in above <literal>DateAdd</literal> method."
+msgstr ""
+
+#. ZAKJ9
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121618563772932\n"
+"help.text"
+msgid "<emph>date1</emph>, <emph>date2</emph>: The two datetime.datetime values to be compared."
+msgstr ""
+
+#. ZR7AD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121618563454738\n"
+"help.text"
+msgid "A number."
+msgstr ""
+
+#. BuEML
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id641618564383315\n"
+"help.text"
+msgid "diffDays = svc.DateDiff('d', date1, date2)"
+msgstr ""
+
+#. qePoV
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id151618564392035\n"
+"help.text"
+msgid "print(diffDays)"
+msgstr ""
+
+#. KPEWi
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id81589202925519\n"
+"help.text"
+msgid "The DatePart function returns a specified part of a date."
+msgstr ""
+
+#. ens2Q
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id761618672192231\n"
+"help.text"
+msgid "<emph>interval</emph>: A string expression  specifying the date interval, as detailed in above <literal>DateAdd</literal> method."
+msgstr ""
+
+#. KuDhD
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id61618672313838\n"
+"help.text"
+msgid "<emph>date</emph>: The date/time from which the result is calculated."
+msgstr ""
+
+#. P3vuB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id511619445271897\n"
+"help.text"
+msgid "<emph>firstdayofweek, firstweekofyear</emph>: optional parameters that respectively specify the starting day of a week and the starting week of a year, as detailed in above <literal>DateDiff</literal> method."
+msgstr ""
+
+#. 5Yz25
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id791618672371743\n"
+"help.text"
+msgid "The extracted part for the given date/time."
+msgstr ""
+
+#. Dc9Cs
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id121589203370778\n"
+"help.text"
+msgid "Computes a date value from a date string."
+msgstr ""
+
+#. QwSFJ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id151618673970234\n"
+"help.text"
+msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#functvalue\"/>"
+msgstr ""
+
+#. qTtuh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id441618674018955\n"
+"help.text"
+msgid "The computed date."
+msgstr ""
+
+#. DGgj3
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id931618674563379\n"
+"help.text"
+msgid "print(dt)"
+msgstr ""
+
+#. GuCbF
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id458161678389887\n"
+"help.text"
+msgid "Converts a number to a string, and then formats it according to the format that you specify."
+msgstr ""
+
+#. St67G
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id751618825527776\n"
+"help.text"
+msgid "Formatting Codes"
+msgstr ""
+
+#. G2TzF
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"hd_id681618825574599\n"
+"help.text"
+msgid "Predefined Formats"
+msgstr ""
+
+#. osJdR
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618876389887\n"
+"help.text"
+msgid "Returns the default context of the process service factory, if existent, else returns a null reference."
+msgstr ""
+
+#. d4EQf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id881618848030897\n"
+"help.text"
+msgid "<literal>GetDefaultContext</literal> is an alternative to the <link href=\"text/sbasic/python/python_programming.xhp\" name=\"getComponentContext method\">getComponentContext()</link> method available from <literal>XSCRIPTCONTEXT</literal> global variable or from <link href=\"text/sbasic/python/python_programming.xhp\" name=\"uno.py module\">uno.py</link> module."
+msgstr ""
+
+#. dk35X
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381618831451271\n"
+"help.text"
+msgid "The default component context is used, when instantiating services via <literal>XMultiServiceFactory</literal>. See the <literal>Professional UNO</literal> chapter in the Developer's Guide on <link href=\"https://api.libreoffice.org/\" name=\"API Developer's Guide\">api.libreoffice.org</link> for more information."
+msgstr ""
+
+#. LACDh
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id154618876389887\n"
+"help.text"
+msgid "Returns a numerical value that specifies the graphical user interface. This function is only provided for backward compatibility with previous versions."
+msgstr ""
+
+#. SmsEL
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id341618848532640\n"
+"help.text"
+msgid "Refer to <literal>system()</literal> method from <literal>platform</literal> Python module to <link href=\"text/sbasic/python/python_platform.xhp\" name=\"identify the operating system\">identify the operating system</link>."
+msgstr ""
+
+#. BJTbw
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618876389788\n"
+"help.text"
+msgid "Returns the operating system-dependent directory separator used to specify file paths."
+msgstr ""
+
+#. BWvPB
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id341618848562340\n"
+"help.text"
+msgid "Use <literal>os.pathsep</literal> from <literal>os</literal> Python module to <link href=\"text/sbasic/python/python_platform.xhp\" name=\"path delimiter\">identify the path separator</link>."
+msgstr ""
+
+#. Jvd3v
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451618678389887\n"
+"help.text"
+msgid "Returns the number of system ticks provided by the operating system. You can use this function to optimize certain processes. Use this method to estimate time in milliseconds:"
+msgstr ""
+
+#. CEtsQ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id251619448108905\n"
+"help.text"
+msgid "ticks_ini = svc.GetSystemTicks()"
+msgstr ""
+
+#. SG6mf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id181619448111210\n"
+"help.text"
+msgid "time.sleep(1)"
+msgstr ""
+
+#. MZXnC
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id301619448111744\n"
+"help.text"
+msgid "ticks_end = svc.GetSystemTicks()"
+msgstr ""
+
+#. dSmH3
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id651619448112320\n"
+"help.text"
+msgid "svc.MsgBox(\"{} - {} = {}\".format(ticks_end, ticks_ini,ticks_end - ticks_ini))"
+msgstr ""
+
+#. Vb2CW
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id61618905164342\n"
+"help.text"
+msgid "<bookmark_value>Basic service;InputBox</bookmark_value>"
+msgstr ""
+
+#. 7GPZv
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619008398677\n"
+"help.text"
+msgid "string"
+msgstr ""
+
+#. qRtw5
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id751619081201175\n"
+"help.text"
+msgid "txt = s.InputBox('Please enter a phrase:', \"Dear user\")"
+msgstr ""
+
+#. UgiDk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"pyc_id261619081319555\n"
+"help.text"
+msgid "s.MsgBox(txt, MB_ICONINFORMATION, \"Confirmation of phrase\")"
+msgstr ""
+
+#. 42vSm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id651618921455396\n"
+"help.text"
+msgid "For in-depth information please refer to <link href=\"https://wiki.documentfoundation.org/Macros/General/IO_to_Screen\" name=\"Input/Output to Screen with Python\">Input/Output to Screen with Python</link> on the Wiki."
+msgstr ""
+
+#. WMifG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id681618905411293\n"
+"help.text"
+msgid "<bookmark_value>Basic service;MsgBox</bookmark_value>"
+msgstr ""
+
+#. ogocf
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id231618922407948\n"
+"help.text"
+msgid "Displays a dialog box containing a message and returns an optional value.<br/>MB_xx constants help specify the dialog type, the number and type of buttons to display, plus the icon type. By adding their respective values they form bit patterns, that define the <literal>MsgBox</literal> dialog appearance."
+msgstr ""
+
+#. 5adLA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id711619082902143\n"
+"help.text"
+msgid "An optional integer as detailed in above <literal>IDxx</literal> properties."
+msgstr ""
+
+#. hvEhT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id791618906935711\n"
+"help.text"
+msgid "<bookmark_value>Basic service;Now</bookmark_value>"
+msgstr ""
+
+#. 2FAgQ
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id191619084216660\n"
+"help.text"
+msgid "Returns the current system date and time as a date/time value."
+msgstr ""
+
+#. qxE2n
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id831618907521168\n"
+"help.text"
+msgid "<bookmark_value>Basic service;RGB</bookmark_value>"
+msgstr ""
+
+#. vBVsk
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id621619448293385\n"
+"help.text"
+msgid "Returns an integer color value consisting of red, green, and blue components."
+msgstr ""
+
+#. vPBAA
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id201619096429785\n"
+"help.text"
+msgid "<input>svc.RGB(red:int, green: int, blue: int): int</input>"
+msgstr ""
+
+#. AAeE4
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id381619096830033\n"
+"help.text"
+msgid "integer"
+msgstr ""
+
+#. mAUuG
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"bm_id81618907851793\n"
+"help.text"
+msgid "<bookmark_value>Basic service;Xray</bookmark_value>"
+msgstr ""
+
+#. TwoGN
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id451619094057178\n"
+"help.text"
+msgid "Inspect Uno objects or variables."
+msgstr ""
+
+#. 2A4om
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id21619094660345\n"
+"help.text"
+msgid "<emph>obj</emph>: A variable or Uno object."
+msgstr ""
+
+#. erHE5
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901618486941514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_programming.xhp\" name=\"uno.fileUrlToSystemPath() method\">uno.fileUrlToSystemPath() method</link>"
+msgstr ""
+
+#. GFQ97
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901618496841514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_programming.xhp\" name=\"uno.systemPathToFileUrl() method\">uno.systemPathToFileUrl() method</link>"
+msgstr ""
+
+#. fMbAm
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id951618554355538\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Macros/General/IO_to_Screen\" name=\"Input/Output to Screen with Python\">Input/Output to Screen with Python</link> on the wiki"
+msgstr ""
+
+#. uruDr
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id610918486941514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_programming.xhp\" name=\"XSCRIPTCONTEXT.getComponentContext() method\">XSCRIPTCONTEXT.getComponentContext() method</link>"
+msgstr ""
+
+#. UCnzE
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901618484961514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_programming.xhp\" name=\"uno.getComponentContext() method\">uno.getComponentContext() method</link>"
+msgstr ""
+
+#. 5GvY3
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901648186941514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_platform.xhp\" name=\"platform.system() method\">platform.system() method</link>"
+msgstr ""
+
+#. gsfQT
+#: sf_basic.xhp
+msgctxt ""
+"sf_basic.xhp\n"
+"par_id901816486941514\n"
+"help.text"
+msgid "<link href=\"text/sbasic/python/python_platform.xhp\" name=\"os.pathsep() method\">os.pathsep() method</link>"
+msgstr ""
+
 #. RYwFj
 #: sf_calc.xhp
 msgctxt ""
@@ -4552,13 +5830,13 @@ msgctxt ""
 msgid "Conversely, if a <literal>RegistrationName</literal> is specified, the <literal>FileName</literal> parameter should not be defined."
 msgstr ""
 
-#. 3d6NY
+#. Bc97U
 #: sf_database.xhp
 msgctxt ""
 "sf_database.xhp\n"
 "par_id841615147168279\n"
 "help.text"
-msgid "<emph>ReadOnly</emph>: Determines if the database will be opened as readonly (Default = True)."
+msgid "<emph>ReadOnly</emph>: Determines if the database will be opened as readonly (Default = <literal>True</literal>)."
 msgstr ""
 
 #. Gn7AF
@@ -4606,6 +5884,15 @@ msgctxt ""
 msgid "'   ... Run queries, SQL statements, ..."
 msgstr ""
 
+#. AVkg5
+#: sf_database.xhp
+msgctxt ""
+"sf_database.xhp\n"
+"par_id361619188184750\n"
+"help.text"
+msgid "The <link href=\"text/sbasic/shared/03/sf_database.xhp#GetDatabase\" name=\"GetDatabase method\">GetDatabase</link> method used in the example above is part of ScriptForge's <literal>Base</literal> service."
+msgstr ""
+
 #. EF9Lc
 #: sf_database.xhp
 msgctxt ""
@@ -12328,13 +13615,13 @@ msgctxt ""
 msgid "Service invocation"
 msgstr ""
 
-#. vbWXq
+#. BeDqF
 #: sf_formcontrol.xhp
 msgctxt ""
 "sf_formcontrol.xhp\n"
 "par_id361598174756160\n"
 "help.text"
-msgid "The <literal>FormControl</literal><literal/> service is invoked from an existing <literal>Form</literal> service instance through its <literal>Controls</literal> method."
+msgid "The <literal>FormControl</literal> service is invoked from an existing <literal>Form</literal> service instance through its <literal>Controls</literal> method."
 msgstr ""
 
 #. FaP92
@@ -16882,6 +18169,33 @@ msgctxt ""
 msgid "The hexadecimal digits may be prefixed with \"0x\" or \"&H\"."
 msgstr ""
 
+#. 3WKNf
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id791584008420941\n"
+"help.text"
+msgid "Returns <literal>True</literal> if the string is a valid International Bank Account Number (IBAN). The comparison is not case-sensitive."
+msgstr ""
+
+#. JZERm
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id951880048466565\n"
+"help.text"
+msgid "<emph>InputStr</emph>: The string to be checked. If empty, the method returns <literal>False</literal>."
+msgstr ""
+
+#. VgT3x
+#: sf_string.xhp
+msgctxt ""
+"sf_string.xhp\n"
+"par_id631619526542367\n"
+"help.text"
+msgid "<literal>True</literal> if the string contains a valid IBAN number."
+msgstr ""
+
 #. CcTNk
 #: sf_string.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/scalc/01.po b/source/lo/helpcontent2/source/text/scalc/01.po
index bb495458c85..fa6d4bdefdb 100644
--- a/source/lo/helpcontent2/source/text/scalc/01.po
+++ b/source/lo/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-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-11-12 13:51+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -57562,22 +57562,22 @@ msgctxt ""
 msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>"
 msgstr ""
 
-#. fyEW6
+#. jbwVT
 #: func_countifs.xhp
 msgctxt ""
 "func_countifs.xhp\n"
 "par_id27421466710275\n"
 "help.text"
-msgid "COUNTIFS(Range1; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])"
+msgid "COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])"
 msgstr ""
 
-#. 2BB8K
+#. KTAXW
 #: func_countifs.xhp
 msgctxt ""
 "func_countifs.xhp\n"
 "par_id14734320631377\n"
 "help.text"
-msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
+msgid "<emph>Range, Range2, ...</emph> and <emph>Criterion, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
 msgstr ""
 
 #. ZuFZj
diff --git a/source/lo/helpcontent2/source/text/sdatabase.po b/source/lo/helpcontent2/source/text/sdatabase.po
index 34789729d58..5149e255b76 100644
--- a/source/lo/helpcontent2/source/text/sdatabase.po
+++ b/source/lo/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-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3505,13 +3505,13 @@ msgctxt ""
 msgid "Format example"
 msgstr ""
 
-#. V3i6o
+#. CrqiQ
 #: 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>"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays a sample of the format code of the field by applying it to the default value. Select the format code with the <emph>Format Field</emph> button.</ahelp>"
 msgstr ""
 
 #. A2jGQ
@@ -4009,22 +4009,22 @@ msgctxt ""
 msgid "The update and delete options are only available if they are supported by the database used."
 msgstr ""
 
-#. BDC5P
+#. gdhcZ
 #: 05020100.xhp
 msgctxt ""
 "05020100.xhp\n"
 "hd_id3155341\n"
 "help.text"
-msgid "Tables"
+msgid "Tables involved"
 msgstr ""
 
-#. BAGsd
+#. P78bc
 #: 05020100.xhp
 msgctxt ""
 "05020100.xhp\n"
 "par_id3153880\n"
 "help.text"
-msgid "<ahelp hid=\"dbaccess/ui/relationdialog/table2\" visibility=\"hidden\">This is where the two related tables are listed.</ahelp> If you create a new relation, you can select one table from each of the combo boxes in the top part of the dialog."
+msgid "<ahelp hid=\"dbaccess/ui/relationdialog/table2\">This is where the two related tables are listed.</ahelp> If you create a new relation, you can select one table from each of the combo boxes in the top part of the dialog."
 msgstr ""
 
 #. 4UCC7
@@ -5251,6 +5251,771 @@ msgctxt ""
 msgid "<ahelp hid=\".\">Displays the description for the selected table.</ahelp>"
 msgstr ""
 
+#. jpgRA
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"tit\n"
+"help.text"
+msgid "Data sources in $[officename]"
+msgstr ""
+
+#. w4Ehh
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"bm_id3155449\n"
+"help.text"
+msgid "<bookmark_value>databases;drag and drop (Base)</bookmark_value>"
+msgstr ""
+
+#. HwcVW
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3151299\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05040200.xhp\" name=\"Data sources in $[officename]\">Data sources in $[officename]</link>"
+msgstr ""
+
+#. PNBCF
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3150616\n"
+"help.text"
+msgid "Selecting the Address Book"
+msgstr ""
+
+#. GeoEc
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3153049\n"
+"help.text"
+msgid "To select the address book that you want to use, choose <link href=\"text/shared/01/01110101.xhp\" name=\"Tools - Address Book Source\"><emph>Tools - Address Book Source</emph></link>."
+msgstr ""
+
+#. hdhBt
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3147275\n"
+"help.text"
+msgid "Opening a Data Source"
+msgstr ""
+
+#. C7ppK
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3154143\n"
+"help.text"
+msgid "To open the data source view, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Shift+F4</keycode> in a text, spreadsheet or form document."
+msgstr ""
+
+#. qiyEE
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3154046\n"
+"help.text"
+msgid "To view the contents of a database, click the plus sign (+) in front of the name in the data source view."
+msgstr ""
+
+#. 884eA
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"tit\n"
+"help.text"
+msgid "ODBC"
+msgstr ""
+
+#. GCT7W
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149031\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11020000.xhp\" name=\"ODBC\">ODBC</link>"
+msgstr ""
+
+#. kyqcm
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3150499\n"
+"help.text"
+msgid "<ahelp hid=\".\">Specifies the settings for <link href=\"text/shared/00/00000005.xhp#odbc\" name=\"ODBC\">ODBC</link> databases. This includes your user access data, driver settings, and font definitions.</ahelp>"
+msgstr ""
+
+#. Dbr2C
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3148642\n"
+"help.text"
+msgid "User Name"
+msgstr ""
+
+#. WBXTJ
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154514\n"
+"help.text"
+msgid "<ahelp hid=\".\">Type the user name for accessing the database.</ahelp>"
+msgstr ""
+
+#. DpZgn
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3153665\n"
+"help.text"
+msgid "Password required"
+msgstr ""
+
+#. HaYKD
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3145119\n"
+"help.text"
+msgid "<ahelp hid=\".\">Prevents an unauthorized user from accessing the database. You only need to enter the password once per session.</ahelp>"
+msgstr ""
+
+#. QWAfC
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3153087\n"
+"help.text"
+msgid "Driver Settings"
+msgstr ""
+
+#. FFBSB
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3143271\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/odbcpage/options\">Use this text field to enter additional optional driver settings if this is necessary.</ahelp>"
+msgstr ""
+
+#. ETNaE
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3152472\n"
+"help.text"
+msgid "Character Set"
+msgstr ""
+
+#. SCzpp
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3151245\n"
+"help.text"
+msgid "<ahelp hid=\"HID_DSADMIN_CHARSET_ODBC\">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp> Choose \"System\" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes."
+msgstr ""
+
+#. xBEZv
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149669\n"
+"help.text"
+msgid "General"
+msgstr ""
+
+#. REocx
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3147265\n"
+"help.text"
+msgid "Retrieve generated values"
+msgstr ""
+
+#. ToEkf
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3151054\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/autoretrieve\">Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source.</ahelp> Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field."
+msgstr ""
+
+#. aokLy
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3150400\n"
+"help.text"
+msgid "Auto-increment statement"
+msgstr ""
+
+#. HFuC7
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154366\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/statement\">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, a typical SQL statement to create a data field is:"
+msgstr ""
+
+#. C5Mvn
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3159149\n"
+"help.text"
+msgid "CREATE TABLE \"table1\" (\"id\" INTEGER)"
+msgstr ""
+
+#. M4YsG
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3147084\n"
+"help.text"
+msgid "To auto-increment the \"id\" data field in a MySQL database, change the statement to:"
+msgstr ""
+
+#. 2pPyd
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154909\n"
+"help.text"
+msgid "CREATE TABLE \"table1\" (\"id\" INTEGER AUTO_INCREMENT)"
+msgstr ""
+
+#. wyFqp
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3152933\n"
+"help.text"
+msgid "In other words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph> box."
+msgstr ""
+
+#. cFjbY
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149765\n"
+"help.text"
+msgid "Query of generated values"
+msgstr ""
+
+#. EnHXJ
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3145171\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/query\">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:"
+msgstr ""
+
+#. KdqAK
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3150769\n"
+"help.text"
+msgid "SELECT LAST_INSERT_D();"
+msgstr ""
+
+#. UcUfT
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3157892\n"
+"help.text"
+msgid "Use SQL92 naming constraints"
+msgstr ""
+
+#. nvCRa
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3153368\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/specialsettingspage/usesql92\">Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected.</ahelp> Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers."
+msgstr ""
+
+#. 9BNi4
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3154011\n"
+"help.text"
+msgid "Use Catalog for file-based databases"
+msgstr ""
+
+#. BaWgu
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3148618\n"
+"help.text"
+msgid "<ahelp hid=\"HID_DSADMIN_USECATALOG\">Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear.</ahelp>"
+msgstr ""
+
+#. RBCN4
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"tit\n"
+"help.text"
+msgid "dBASE"
+msgstr ""
+
+#. jQexT
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3153539\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11030000.xhp\" name=\"dBase\">dBASE</link>"
+msgstr ""
+
+#. EFxxW
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3147088\n"
+"help.text"
+msgid "<ahelp hid=\".\">Specify the settings for a dBASE database.</ahelp>"
+msgstr ""
+
+#. bSnXm
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3151110\n"
+"help.text"
+msgid "To be able to define relations between tables, use JDBC or ODBC from within $[officename]."
+msgstr ""
+
+#. irtxH
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3149233\n"
+"help.text"
+msgid "Display inactive records"
+msgstr ""
+
+#. Y4AnV
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3153823\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbasepage/showDelRowsCheckbutton\">Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.</ahelp>"
+msgstr ""
+
+#. 7vpRc
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3156023\n"
+"help.text"
+msgid "In dBASE format, deleted records remain in the file."
+msgstr ""
+
+#. ZYefW
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "To view any changes that you make to the database, close the connection to the database, and then reconnect the database."
+msgstr ""
+
+#. 5LBSi
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id0904200811094971\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp>"
+msgstr ""
+
+#. Gmun9
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3149047\n"
+"help.text"
+msgid "Indexes"
+msgstr ""
+
+#. BjWsR
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3161656\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbasepage/indiciesButton\">Opens the <link href=\"text/sdatabase/11030100.xhp\" name=\"Indexes\"><emph>Indexes</emph></link> dialog, where you can organize the table indexes in the current dBASE database.</ahelp>"
+msgstr ""
+
+#. vMA8w
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Indexes"
+msgstr ""
+
+#. x4TDi
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3148983\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11030100.xhp\" name=\"Indexes\">Indexes</link>"
+msgstr ""
+
+#. DmGsN
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3150247\n"
+"help.text"
+msgid "<ahelp hid=\".\">Lets you organize dBASE database indexes.</ahelp> An index allows you to access a database quickly, provided that you query the data in the selection that was defined through the index. When you design a table, you can define the indexes on the <emph>Indexes </emph>tab page."
+msgstr ""
+
+#. Aj5Uz
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3155339\n"
+"help.text"
+msgid "Table"
+msgstr ""
+
+#. bzzGv
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3152551\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/table\">Select the database table that you want to index.</ahelp>"
+msgstr ""
+
+#. eyouE
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3159233\n"
+"help.text"
+msgid "Table Indexes"
+msgstr ""
+
+#. hyCqp
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3143267\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/tableindex\">Lists the current indexes for the selected database table.</ahelp> To remove an index from the list, click the index, and then click the right arrow."
+msgstr ""
+
+#. scWXw
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3148538\n"
+"help.text"
+msgid "Free Indexes"
+msgstr ""
+
+#. mtGqS
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3151110\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/freeindex\">Lists the available indexes that you can assign to a table.</ahelp> To assign an index to a selected table, click the left arrow icon. The left double arrow assigns all available indexes."
+msgstr ""
+
+#. U4FQh
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3156152\n"
+"help.text"
+msgid "<"
+msgstr ""
+
+#. sxDJi
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3150984\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/add\">Moves the selected index to the <emph>Table Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. FPRFh
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3149416\n"
+"help.text"
+msgid "<<"
+msgstr ""
+
+#. 45Vrm
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3145315\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/addall\">Moves all of the free indexes to the <emph>Table Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. Ba8Z9
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3149579\n"
+"help.text"
+msgid ">"
+msgstr ""
+
+#. EP9GN
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3149795\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/remove\">Moves the selected table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. sAASQ
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3155629\n"
+"help.text"
+msgid ">>"
+msgstr ""
+
+#. t2gbA
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3151245\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/removeall\">Moves all of the table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. LQcMC
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Execute SQL statement"
+msgstr ""
+
+#. GDjji
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"bm_id3148983\n"
+"help.text"
+msgid "<bookmark_value>SQL; executing SQL statements (Base)</bookmark_value><bookmark_value>databases; administration through SQL (Base)</bookmark_value>"
+msgstr ""
+
+#. JsqKF
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3153345\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11080000.xhp\" name=\"Execute SQL statement\">Execute SQL statement</link>"
+msgstr ""
+
+#. BtQ2b
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3154288\n"
+"help.text"
+msgid "<variable id=\"sqltext\"><ahelp hid=\".\">Opens a dialog where you can enter an SQL command for administering a database.</ahelp></variable>"
+msgstr ""
+
+#. jhBMm
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3147275\n"
+"help.text"
+msgid "You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here."
+msgstr ""
+
+#. JZmCZ
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3154860\n"
+"help.text"
+msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design View</link>."
+msgstr ""
+
+#. Ck9G4
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3149514\n"
+"help.text"
+msgid "Command to execute"
+msgstr ""
+
+#. BHLbE
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3147618\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sql\">Enter the SQL administration command that you want to run.</ahelp>"
+msgstr ""
+
+#. 5DFEP
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3153087\n"
+"help.text"
+msgid "For example, for a \"Bibliography\" data source, you can enter the following SQL command:"
+msgstr ""
+
+#. XDWsR
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3145673\n"
+"help.text"
+msgid "SELECT \"Address\" FROM \"biblio\" \"biblio\""
+msgstr ""
+
+#. LjEvw
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3145611\n"
+"help.text"
+msgid "For more information on SQL commands, please consult the documentation that came with the database."
+msgstr ""
+
+#. BQmT9
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3156024\n"
+"help.text"
+msgid "Previous commands"
+msgstr ""
+
+#. hkxBT
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3149045\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp>"
+msgstr ""
+
+#. AvXck
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154348\n"
+"help.text"
+msgid "Status"
+msgstr ""
+
+#. yhCpt
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151054\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>"
+msgstr ""
+
+#. BUpxX
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154071\n"
+"help.text"
+msgid "Run"
+msgstr ""
+
+#. qDYRx
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151210\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>"
+msgstr ""
+
+#. 93Xfs
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Table Filter"
+msgstr ""
+
+#. bG74E
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"hd_id3150702\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11090000.xhp\" name=\"Tables\">Table Filter</link>"
+msgstr ""
+
+#. NLCCV
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"par_id3149164\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Some databases track changes to each record by assigning version number to fields that are changed. This number is incremented by 1 each time the field is changed. Displays the internal version number of the record in the database table.</ahelp>"
+msgstr ""
+
+#. axsoU
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"hd_id3154923\n"
+"help.text"
+msgid "Sort Ascending"
+msgstr ""
+
+#. XFbZd
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"par_id3147559\n"
+"help.text"
+msgid "<ahelp hid=\".\">Sorts the list of table names in ascending order starting at the beginning of the alphabet.</ahelp>"
+msgstr ""
+
 #. cLmBi
 #: main.xhp
 msgctxt ""
diff --git a/source/lo/helpcontent2/source/text/shared/00.po b/source/lo/helpcontent2/source/text/shared/00.po
index 141761b1df6..8f401e100de 100644
--- a/source/lo/helpcontent2/source/text/shared/00.po
+++ b/source/lo/helpcontent2/source/text/shared/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: 2021-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2248,13 +2248,13 @@ msgctxt ""
 msgid "Direct and Style Formatting"
 msgstr ""
 
-#. DCSZA
+#. QaB9M
 #: 00000005.xhp
 msgctxt ""
 "00000005.xhp\n"
 "par_id431619103899855\n"
 "help.text"
-msgid "A style is a set of formatting atributes, grouped and identified by a name (the style name). When you apply a style to an object, the object is formatted with the set of attributes of the style. Several objects of same nature can have the same style. As consequence, when you change the set of formatting attributes of the style, all objects associated with the style also change their formatting attributes accordingly. Use styles to uniformly format a large set of paragraphs, cells, and objects and better manage the formatting of documents."
+msgid "A style is a set of formatting attributes, grouped and identified by a name (the style name). When you apply a style to an object, the object is formatted with the set of attributes of the style. Several objects of same nature can have the same style. As consequence, when you change the set of formatting attributes of the style, all objects associated with the style also change their formatting attributes accordingly. Use styles to uniformly format a large set of paragraphs, cells, and objects and better manage the formatting of documents."
 msgstr ""
 
 #. GDMrG
diff --git a/source/lo/helpcontent2/source/text/shared/01.po b/source/lo/helpcontent2/source/text/shared/01.po
index 24b8d5434e5..4aa0336d755 100644
--- a/source/lo/helpcontent2/source/text/shared/01.po
+++ b/source/lo/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-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-11-14 12:04+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -4804,13 +4804,13 @@ msgctxt ""
 msgid "From which"
 msgstr ""
 
-#. 8bGAj
+#. tHVZf
 #: 01130000.xhp
 msgctxt ""
 "01130000.xhp\n"
 "par_id35\n"
 "help.text"
-msgid "<ahelp hid=\".\">Select the source of sheet content to be printed.</ahelp> Possible valuer are <emph>Print all sheets</emph> and <emph>Print selected sheets</emph>."
+msgid "<ahelp hid=\".\">Select the source of sheet content to be printed.</ahelp> Possible values are <emph>Print all sheets</emph> and <emph>Print selected sheets</emph>."
 msgstr ""
 
 #. fGCJk
@@ -15523,13 +15523,13 @@ msgctxt ""
 msgid "To stop applying a direct format, such as underlining, while you type new text at the end of a line, press <keycode>Shift+Ctrl+X</keycode>."
 msgstr ""
 
-#. BsVyF
+#. uGgku
 #: 05010000.xhp
 msgctxt ""
 "05010000.xhp\n"
 "par_id91619108534060\n"
 "help.text"
-msgid "Bullets and numbering are properties of lists. <emph>Clear Direct Formatting</emph> does not clear directly formatted bullets and numbering found in a paragraph. To remove the bullet and numbering applied directly to a paragraph, use the <emph>Toggle Unordered List</emph>, the <emph>Togle Ordered List</emph> or the <emph>No List</emph> icons on the Formatting toolbar."
+msgid "Bullets and numbering are properties of lists. <emph>Clear Direct Formatting</emph> does not clear directly formatted bullets and numbering found in a paragraph. To remove the bullet and numbering applied directly to a paragraph, use the <emph>Toggle Unordered List</emph>, the <emph>Toggle Ordered List</emph> or the <emph>No List</emph> icons on the Formatting toolbar."
 msgstr ""
 
 #. rQFC8
diff --git a/source/lo/helpcontent2/source/text/shared/explorer/database.po b/source/lo/helpcontent2/source/text/shared/explorer/database.po
index 6d324f34b23..5abc63673d2 100644
--- a/source/lo/helpcontent2/source/text/shared/explorer/database.po
+++ b/source/lo/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-04-27 17:03+0200\n"
+"POT-Creation-Date: 2021-05-05 17:15+0200\n"
 "PO-Revision-Date: 2018-11-12 13:51+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -16,771 +16,6 @@ msgstr ""
 "X-Generator: LibreOffice\n"
 "X-POOTLE-MTIME: 1542030686.000000\n"
 
-#. jpgRA
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"tit\n"
-"help.text"
-msgid "Data sources in $[officename]"
-msgstr ""
-
-#. w4Ehh
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"bm_id3155449\n"
-"help.text"
-msgid "<bookmark_value>databases;drag and drop (Base)</bookmark_value>"
-msgstr ""
-
-#. AqvhY
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"hd_id3151299\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11000002.xhp\" name=\"Data sources in $[officename]\">Data sources in $[officename]</link>"
-msgstr ""
-
-#. PNBCF
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"hd_id3150616\n"
-"help.text"
-msgid "Selecting the Address Book"
-msgstr ""
-
-#. GeoEc
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"par_id3153049\n"
-"help.text"
-msgid "To select the address book that you want to use, choose <link href=\"text/shared/01/01110101.xhp\" name=\"Tools - Address Book Source\"><emph>Tools - Address Book Source</emph></link>."
-msgstr ""
-
-#. hdhBt
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"hd_id3147275\n"
-"help.text"
-msgid "Opening a Data Source"
-msgstr ""
-
-#. C7ppK
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"par_id3154143\n"
-"help.text"
-msgid "To open the data source view, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Shift+F4</keycode> in a text, spreadsheet or form document."
-msgstr ""
-
-#. qiyEE
-#: 11000002.xhp
-msgctxt ""
-"11000002.xhp\n"
-"par_id3154046\n"
-"help.text"
-msgid "To view the contents of a database, click the plus sign (+) in front of the name in the data source view."
-msgstr ""
-
-#. 884eA
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"tit\n"
-"help.text"
-msgid "ODBC"
-msgstr ""
-
-#. QkyCA
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3149031\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11020000.xhp\" name=\"ODBC\">ODBC</link>"
-msgstr ""
-
-#. kyqcm
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3150499\n"
-"help.text"
-msgid "<ahelp hid=\".\">Specifies the settings for <link href=\"text/shared/00/00000005.xhp#odbc\" name=\"ODBC\">ODBC</link> databases. This includes your user access data, driver settings, and font definitions.</ahelp>"
-msgstr ""
-
-#. Dbr2C
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3148642\n"
-"help.text"
-msgid "User Name"
-msgstr ""
-
-#. WBXTJ
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3154514\n"
-"help.text"
-msgid "<ahelp hid=\".\">Type the user name for accessing the database.</ahelp>"
-msgstr ""
-
-#. DpZgn
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3153665\n"
-"help.text"
-msgid "Password required"
-msgstr ""
-
-#. HaYKD
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3145119\n"
-"help.text"
-msgid "<ahelp hid=\".\">Prevents an unauthorized user from accessing the database. You only need to enter the password once per session.</ahelp>"
-msgstr ""
-
-#. QWAfC
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3153087\n"
-"help.text"
-msgid "Driver Settings"
-msgstr ""
-
-#. FFBSB
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3143271\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/odbcpage/options\">Use this text field to enter additional optional driver settings if this is necessary.</ahelp>"
-msgstr ""
-
-#. ETNaE
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3152472\n"
-"help.text"
-msgid "Character Set"
-msgstr ""
-
-#. SCzpp
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3151245\n"
-"help.text"
-msgid "<ahelp hid=\"HID_DSADMIN_CHARSET_ODBC\">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp> Choose \"System\" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes."
-msgstr ""
-
-#. xBEZv
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3149669\n"
-"help.text"
-msgid "General"
-msgstr ""
-
-#. REocx
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3147265\n"
-"help.text"
-msgid "Retrieve generated values"
-msgstr ""
-
-#. ToEkf
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3151054\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/autoretrieve\">Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source.</ahelp> Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field."
-msgstr ""
-
-#. aokLy
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3150400\n"
-"help.text"
-msgid "Auto-increment statement"
-msgstr ""
-
-#. HFuC7
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3154366\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/statement\">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, a typical SQL statement to create a data field is:"
-msgstr ""
-
-#. C5Mvn
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3159149\n"
-"help.text"
-msgid "CREATE TABLE \"table1\" (\"id\" INTEGER)"
-msgstr ""
-
-#. M4YsG
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3147084\n"
-"help.text"
-msgid "To auto-increment the \"id\" data field in a MySQL database, change the statement to:"
-msgstr ""
-
-#. 2pPyd
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3154909\n"
-"help.text"
-msgid "CREATE TABLE \"table1\" (\"id\" INTEGER AUTO_INCREMENT)"
-msgstr ""
-
-#. wyFqp
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3152933\n"
-"help.text"
-msgid "In other words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph> box."
-msgstr ""
-
-#. cFjbY
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3149765\n"
-"help.text"
-msgid "Query of generated values"
-msgstr ""
-
-#. EnHXJ
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3145171\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/generatedvaluespage/query\">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:"
-msgstr ""
-
-#. KdqAK
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3150769\n"
-"help.text"
-msgid "SELECT LAST_INSERT_D();"
-msgstr ""
-
-#. UcUfT
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3157892\n"
-"help.text"
-msgid "Use SQL92 naming constraints"
-msgstr ""
-
-#. nvCRa
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3153368\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/specialsettingspage/usesql92\">Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected.</ahelp> Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers."
-msgstr ""
-
-#. 9BNi4
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"hd_id3154011\n"
-"help.text"
-msgid "Use Catalog for file-based databases"
-msgstr ""
-
-#. BaWgu
-#: 11020000.xhp
-msgctxt ""
-"11020000.xhp\n"
-"par_id3148618\n"
-"help.text"
-msgid "<ahelp hid=\"HID_DSADMIN_USECATALOG\">Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear.</ahelp>"
-msgstr ""
-
-#. RBCN4
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"tit\n"
-"help.text"
-msgid "dBASE"
-msgstr ""
-
-#. bWmM9
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"hd_id3153539\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11030000.xhp\" name=\"dBase\">dBASE</link>"
-msgstr ""
-
-#. EFxxW
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3147088\n"
-"help.text"
-msgid "<ahelp hid=\".\">Specify the settings for a dBASE database.</ahelp>"
-msgstr ""
-
-#. bSnXm
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3151110\n"
-"help.text"
-msgid "To be able to define relations between tables, use JDBC or ODBC from within $[officename]."
-msgstr ""
-
-#. irtxH
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"hd_id3149233\n"
-"help.text"
-msgid "Display inactive records"
-msgstr ""
-
-#. Y4AnV
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3153823\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbasepage/showDelRowsCheckbutton\">Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.</ahelp>"
-msgstr ""
-
-#. 7vpRc
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3156023\n"
-"help.text"
-msgid "In dBASE format, deleted records remain in the file."
-msgstr ""
-
-#. ZYefW
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3151384\n"
-"help.text"
-msgid "To view any changes that you make to the database, close the connection to the database, and then reconnect the database."
-msgstr ""
-
-#. 5LBSi
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id0904200811094971\n"
-"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp>"
-msgstr ""
-
-#. Gmun9
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"hd_id3149047\n"
-"help.text"
-msgid "Indexes"
-msgstr ""
-
-#. wh2wn
-#: 11030000.xhp
-msgctxt ""
-"11030000.xhp\n"
-"par_id3161656\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbasepage/indiciesButton\">Opens the <link href=\"text/shared/explorer/database/11030100.xhp\" name=\"Indexes\"><emph>Indexes</emph></link> dialog, where you can organize the table indexes in the current dBASE database.</ahelp>"
-msgstr ""
-
-#. vMA8w
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"tit\n"
-"help.text"
-msgid "Indexes"
-msgstr ""
-
-#. aznJb
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3148983\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11030100.xhp\" name=\"Indexes\">Indexes</link>"
-msgstr ""
-
-#. DmGsN
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3150247\n"
-"help.text"
-msgid "<ahelp hid=\".\">Lets you organize dBASE database indexes.</ahelp> An index allows you to access a database quickly, provided that you query the data in the selection that was defined through the index. When you design a table, you can define the indexes on the <emph>Indexes </emph>tab page."
-msgstr ""
-
-#. Aj5Uz
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3155339\n"
-"help.text"
-msgid "Table"
-msgstr ""
-
-#. bzzGv
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3152551\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/table\">Select the database table that you want to index.</ahelp>"
-msgstr ""
-
-#. eyouE
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3159233\n"
-"help.text"
-msgid "Table Indexes"
-msgstr ""
-
-#. hyCqp
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3143267\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/tableindex\">Lists the current indexes for the selected database table.</ahelp> To remove an index from the list, click the index, and then click the right arrow."
-msgstr ""
-
-#. scWXw
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3148538\n"
-"help.text"
-msgid "Free Indexes"
-msgstr ""
-
-#. mtGqS
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3151110\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/freeindex\">Lists the available indexes that you can assign to a table.</ahelp> To assign an index to a selected table, click the left arrow icon. The left double arrow assigns all available indexes."
-msgstr ""
-
-#. U4FQh
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3156152\n"
-"help.text"
-msgid "<"
-msgstr ""
-
-#. sxDJi
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3150984\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/add\">Moves the selected index to the <emph>Table Indexes</emph> list.</ahelp>"
-msgstr ""
-
-#. FPRFh
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3149416\n"
-"help.text"
-msgid "<<"
-msgstr ""
-
-#. 45Vrm
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3145315\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/addall\">Moves all of the free indexes to the <emph>Table Indexes</emph> list.</ahelp>"
-msgstr ""
-
-#. Ba8Z9
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3149579\n"
-"help.text"
-msgid ">"
-msgstr ""
-
-#. EP9GN
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3149795\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/remove\">Moves the selected table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
-msgstr ""
-
-#. sAASQ
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"hd_id3155629\n"
-"help.text"
-msgid ">>"
-msgstr ""
-
-#. t2gbA
-#: 11030100.xhp
-msgctxt ""
-"11030100.xhp\n"
-"par_id3151245\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/removeall\">Moves all of the table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
-msgstr ""
-
-#. LQcMC
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Execute SQL statement"
-msgstr ""
-
-#. GDjji
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"bm_id3148983\n"
-"help.text"
-msgid "<bookmark_value>SQL; executing SQL statements (Base)</bookmark_value><bookmark_value>databases; administration through SQL (Base)</bookmark_value>"
-msgstr ""
-
-#. Fpgqa
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"hd_id3153345\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11080000.xhp\" name=\"Execute SQL statement\">Execute SQL statement</link>"
-msgstr ""
-
-#. BtQ2b
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3154288\n"
-"help.text"
-msgid "<variable id=\"sqltext\"><ahelp hid=\".\">Opens a dialog where you can enter an SQL command for administering a database.</ahelp></variable>"
-msgstr ""
-
-#. jhBMm
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3147275\n"
-"help.text"
-msgid "You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here."
-msgstr ""
-
-#. JZmCZ
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3154860\n"
-"help.text"
-msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design View</link>."
-msgstr ""
-
-#. Ck9G4
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"hd_id3149514\n"
-"help.text"
-msgid "Command to execute"
-msgstr ""
-
-#. BHLbE
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3147618\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sql\">Enter the SQL administration command that you want to run.</ahelp>"
-msgstr ""
-
-#. 5DFEP
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3153087\n"
-"help.text"
-msgid "For example, for a \"Bibliography\" data source, you can enter the following SQL command:"
-msgstr ""
-
-#. XDWsR
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3145673\n"
-"help.text"
-msgid "SELECT \"Address\" FROM \"biblio\" \"biblio\""
-msgstr ""
-
-#. LjEvw
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3145611\n"
-"help.text"
-msgid "For more information on SQL commands, please consult the documentation that came with the database."
-msgstr ""
-
-#. BQmT9
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"hd_id3156024\n"
-"help.text"
-msgid "Previous commands"
-msgstr ""
-
-#. hkxBT
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3149045\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp>"
-msgstr ""
-
-#. AvXck
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"hd_id3154348\n"
-"help.text"
-msgid "Status"
-msgstr ""
-
-#. yhCpt
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3151054\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>"
-msgstr ""
-
-#. BUpxX
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"hd_id3154071\n"
-"help.text"
-msgid "Run"
-msgstr ""
-
-#. qDYRx
-#: 11080000.xhp
-msgctxt ""
-"11080000.xhp\n"
-"par_id3151210\n"
-"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>"
-msgstr ""
-
-#. 93Xfs
-#: 11090000.xhp
-msgctxt ""
-"11090000.xhp\n"
-"tit\n"
-"help.text"
-msgid "Table Filter"
-msgstr ""
-
-#. yA8Tv
-#: 11090000.xhp
-msgctxt ""
-"11090000.xhp\n"
-"hd_id3150702\n"
-"help.text"
-msgid "<link href=\"text/shared/explorer/database/11090000.xhp\" name=\"Tables\">Table Filter</link>"
-msgstr ""
-
-#. NLCCV
-#: 11090000.xhp
-msgctxt ""
-"11090000.xhp\n"
-"par_id3149164\n"
-"help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Some databases track changes to each record by assigning version number to fields that are changed. This number is incremented by 1 each time the field is changed. Displays the internal version number of the record in the database table.</ahelp>"
-msgstr ""
-
-#. axsoU
-#: 11090000.xhp
-msgctxt ""
-"11090000.xhp\n"
-"hd_id3154923\n"
-"help.text"
-msgid "Sort Ascending"
-msgstr ""
-
-#. XFbZd
-#: 11090000.xhp
-msgctxt ""
-"11090000.xhp\n"
-"par_id3147559\n"
-"help.text"
-msgid "<ahelp hid=\".\">Sorts the list of table names in ascending order starting at the beginning of the alphabet.</ahelp>"
-msgstr ""
-
 #. SaBHA
 #: dabaadvprop.xhp
 msgctxt ""
author	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2021-05-05 18:03:30 +0200
committer	Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>	2021-05-05 18:09:31 +0200
commit	dddf75c6f2e8840ed6966fa73989485db7c6b10b (patch)
tree	b489030e47116ef6a4fbccbe5fbe5537d03f6eb3 /source/lo/helpcontent2/source
parent	926713ac8f969ab8b246090eb8f3c4c48bead223 (diff)