update translations for master

and force-fix errors using pocheck

Change-Id: Ic6888555f22c4e961c0734fa685969b43f89c02e

4 files changed, 1104 insertions, 132 deletions

diff --git a/source/fi/helpcontent2/source/text/sbasic/guide.po b/source/fi/helpcontent2/source/text/sbasic/guide.po
index e642bc6fd5d..0fca23fab3e 100644
--- a/source/fi/helpcontent2/source/text/sbasic/guide.po
+++ b/source/fi/helpcontent2/source/text/sbasic/guide.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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-09-20 13:02+0200\n"
+"POT-Creation-Date: 2021-10-20 13:08+0200\n"
 "PO-Revision-Date: 2018-04-25 12:35+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Finnish <discuss@fi.libreoffice.org>\n"
@@ -1249,6 +1249,348 @@ msgctxt ""
 msgid "On the dialog, drag the button to the size you want."
 msgstr "Valintaikkunassa, vedä painike tarvitsemaasi kokoon."
 
+#. fRi68
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"tit\n"
+"help.text"
+msgid "Reading and Writing values to Ranges"
+msgstr ""
+
+#. 3hH3s
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"hd_id461623364876507\n"
+"help.text"
+msgid "<variable id=\"title\"><link href=\"text/sbasic/guide/read_write_values.xhp\" name=\"ReadWriteValues_h1\">Reading and Writing values to Ranges</link></variable>"
+msgstr ""
+
+#. ZKUBE
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id781633210592228\n"
+"help.text"
+msgid "Macros in %PRODUCTNAME Calc often need to read and write values from/to sheets. This help page describes the various approaches to accessing sheets and ranges to read or write their values."
+msgstr ""
+
+#. D4ZJu
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id191633214565965\n"
+"help.text"
+msgid "All examples presented in this page can be implemented both in Basic and Python."
+msgstr ""
+
+#. LfNCy
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"hd_id331633213558740\n"
+"help.text"
+msgid "Accessing a Single Cell"
+msgstr ""
+
+#. A5M3f
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id731633213581386\n"
+"help.text"
+msgid "The example below enters the numeric value 123 into cell \"A1\" of the current sheet."
+msgstr ""
+
+#. G6yWX
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id131633213887433\n"
+"help.text"
+msgid "The same can be accomplished with Python:"
+msgstr ""
+
+#. CDmg6
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id861633214219511\n"
+"help.text"
+msgid "Note that in the previous examples the cell is accessed using its range name \"A1\". It is also possible to access cells using indices as though the sheet were a matrix where columns and rows are indexed starting from zero."
+msgstr ""
+
+#. Jja4D
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id161633214461067\n"
+"help.text"
+msgid "This can be done using the <literal>getCellByPosition(colIndex, rowIndex)</literal> method, that takes in a column and a row index. The example below in Basic changes the text value in cell \"C1\" (column 2, row 0)."
+msgstr ""
+
+#. 5tsZR
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id221633214713436\n"
+"help.text"
+msgid "This example can also be implemented in Python as follows:"
+msgstr ""
+
+#. h6eq5
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id101633215142970\n"
+"help.text"
+msgid "The main difference between Python and Basic scripts lies on how to get access to the sheet object by using the <literal>XSCRIPTCONTEXT</literal> context variable. After that, all methods and properties are identical in Basic and Python."
+msgstr ""
+
+#. PmETF
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"hd_id411633215666257\n"
+"help.text"
+msgid "Values, Strings and Formulas"
+msgstr ""
+
+#. MBHDg
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id861633215682610\n"
+"help.text"
+msgid "Calc cells can have three types of values: numeric, strings and formulas. Each type has its own set and get methods:"
+msgstr ""
+
+#. RXE76
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id191633215791905\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. rYCuZ
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id181633215791905\n"
+"help.text"
+msgid "Numeric"
+msgstr ""
+
+#. ywHfC
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id961633215932180\n"
+"help.text"
+msgid "Text"
+msgstr ""
+
+#. KH9Ya
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id651633215984116\n"
+"help.text"
+msgid "Formula"
+msgstr ""
+
+#. nGhov
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id21633215845395\n"
+"help.text"
+msgid "Dates and currency values are considered as numeric values in Calc."
+msgstr ""
+
+#. t87Qx
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id221633216111353\n"
+"help.text"
+msgid "The following example enters numeric values into cells \"A1\" and \"A2\" and inserts a formula in cell \"A3\" that returns the multiplication of these values."
+msgstr ""
+
+#. r6BG6
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"hd_id321633216630043\n"
+"help.text"
+msgid "Accessing Ranges in Different Sheets"
+msgstr ""
+
+#. TFU8U
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id371633216672570\n"
+"help.text"
+msgid "The previous examples used only the active sheet to perform operations. It is possible to access cell ranges in different sheets by their indices or names."
+msgstr ""
+
+#. c3yhF
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id861633216843382\n"
+"help.text"
+msgid "The example below enters a numeric value into cell \"A1\" of the sheet named \"Sheet2\"."
+msgstr ""
+
+#. GpnNS
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id611633217090743\n"
+"help.text"
+msgid "This example can also be implemented in Python as follows:"
+msgstr ""
+
+#. xGQ3k
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id631633217279518\n"
+"help.text"
+msgid "Sheets can also be accessed using zero-based indices indicating which sheet considering the order they appear in the Calc file."
+msgstr ""
+
+#. tSo3e
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id291633264880172\n"
+"help.text"
+msgid "In Basic, instead of using the <literal>getByName</literal> method, use <literal>Sheets(sheetIndex)</literal> as shown next:"
+msgstr ""
+
+#. svDuj
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id891633265000047\n"
+"help.text"
+msgid "This can be done in a similar fashion in Python:"
+msgstr ""
+
+#. 6qHAn
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"hd_id451633265241066\n"
+"help.text"
+msgid "Using the ScriptForge Library"
+msgstr ""
+
+#. 8CkSe
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id731633265268585\n"
+"help.text"
+msgid "The Calc service of the ScriptForge library can be used to get and set cell values as follows:"
+msgstr ""
+
+#. DCJ2E
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id551633265526538\n"
+"help.text"
+msgid "' Loads the ScriptForge library"
+msgstr ""
+
+#. hgDyM
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id581633265527001\n"
+"help.text"
+msgid "' Gets access to the current Calc document"
+msgstr ""
+
+#. Gw4KG
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id751633265527427\n"
+"help.text"
+msgid "' Sets the value of cells A1 and A2"
+msgstr ""
+
+#. VUWVE
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id781633267324929\n"
+"help.text"
+msgid "The <literal>setValue</literal> method can be used to set both numeric and text values. To set a cell formula, use the <literal>setFormula</literal> method."
+msgstr ""
+
+#. jPRii
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id251633265634883\n"
+"help.text"
+msgid "With the Calc service, getting and setting cell values can be done with a single line of code. The example below gets the value from cell \"A1\" and shows it on a message box."
+msgstr ""
+
+#. NzUg4
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id521633608223310\n"
+"help.text"
+msgid "The ScriptForge library also makes it simpler to access ranges in different sheets, as demonstrated in the example below:"
+msgstr ""
+
+#. CCeEh
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"bas_id521633608366292\n"
+"help.text"
+msgid "' Gets cell \"A1\" from the sheet named \"Sheet1\""
+msgstr ""
+
+#. qUTqA
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"bas_id661633608366484\n"
+"help.text"
+msgid "' Gets cell \"B3\" from the sheet named \"Sheet2\""
+msgstr ""
+
+#. mCX5W
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"bas_id501633608516381\n"
+"help.text"
+msgid "' Places the result into cell \"A1\" of sheet \"Report\""
+msgstr ""
+
+#. ZdkEz
+#: read_write_values.xhp
+msgctxt ""
+"read_write_values.xhp\n"
+"par_id431633266057163\n"
+"help.text"
+msgid "The examples above can also be implemented in Python as follows:"
+msgstr ""
+
 #. ayg6P
 #: sample_code.xhp
 msgctxt ""
diff --git a/source/fi/helpcontent2/source/text/sbasic/python.po b/source/fi/helpcontent2/source/text/sbasic/python.po
index 77aff98820d..48c31860276 100644
--- a/source/fi/helpcontent2/source/text/sbasic/python.po
+++ b/source/fi/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-09-27 19:09+0200\n"
+"POT-Creation-Date: 2021-10-25 12:48+0200\n"
 "PO-Revision-Date: 2021-04-10 15:37+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicpython/fi/>\n"
@@ -582,13 +582,13 @@ msgctxt ""
 msgid "Monitoring Document Events"
 msgstr ""
 
-#. SZGH4
+#. VwSwW
 #: python_document_events.xhp
 msgctxt ""
 "python_document_events.xhp\n"
 "N0530\n"
 "help.text"
-msgid "Monitoring is illustrated herewith for Basic and Python languages using object-oriented programming. Assigning <literal>OnLoad</literal> script, to the <emph>Open Document</emph> event, suffices to initiate and terminate document event monitoring. <menuitem>Tools - Customize</menuitem> menu <menuitem>Events</menuitem> tab is used to assign either scripts."
+msgid "Monitoring is illustrated herewith for Basic and Python languages using object-oriented programming. Assigning <literal>OnLoad</literal> script, to the <menuitem>Open Document</menuitem> event, suffices to initiate and terminate document event monitoring. <menuitem>Tools - Customize</menuitem> menu <menuitem>Events</menuitem> tab is used to assign either scripts."
 msgstr ""
 
 #. KgWvt
@@ -627,13 +627,13 @@ msgctxt ""
 msgid "Events monitoring starts from object instantiation and ultimately stops when Python releases the object. Raised events are reported using <literal>Access2Base</literal> console."
 msgstr ""
 
-#. D2HXF
+#. mCDwK
 #: python_document_events.xhp
 msgctxt ""
 "python_document_events.xhp\n"
 "N0534\n"
 "help.text"
-msgid "<literal>OnLoad</literal> and <literal>OnUnload</literal> events can be used to respectively set and unset Python programs path. They are described as <emph>Open document</emph> and <emph>Document closed</emph>."
+msgid "<literal>OnLoad</literal> and <literal>OnUnload</literal> events can be used to respectively set and unset Python programs path. They are described as <menuitem>Open document</menuitem> and <menuitem>Document closed</menuitem>."
 msgstr ""
 
 #. AdYNb
@@ -807,6 +807,15 @@ msgctxt ""
 msgid "def OnLoad(*args):  # 'Open Document' event"
 msgstr ""
 
+#. PmjAB
+#: python_document_events.xhp
+msgctxt ""
+"python_document_events.xhp\n"
+"N0602\n"
+"help.text"
+msgid "listener = UiDocument()  # Initiates listening"
+msgstr ""
+
 #. CkJg4
 #: python_document_events.xhp
 msgctxt ""
@@ -870,6 +879,15 @@ msgctxt ""
 msgid "\"\"\" Display console content/dialog \"\"\""
 msgstr ""
 
+#. mPJ3B
+#: python_document_events.xhp
+msgctxt ""
+"python_document_events.xhp\n"
+"N0638\n"
+"help.text"
+msgid "''' Grab application-based Basic script '''"
+msgstr ""
+
 #. 2dfeg
 #: python_document_events.xhp
 msgctxt ""
@@ -879,13 +897,13 @@ msgctxt ""
 msgid "Mind the misspelled <literal>documentEventOccured</literal> method that inherits a typo from %PRODUCTNAME Application Programming Interface (API)."
 msgstr ""
 
-#. CuAga
+#. qNVD4
 #: python_document_events.xhp
 msgctxt ""
 "python_document_events.xhp\n"
 "N0648\n"
 "help.text"
-msgid "<emph>Start application</emph> and <emph>Close application</emph> events can respectively be used to set and to unset Python path for user scripts or %PRODUCTNAME scripts. In a similar fashion, document based Python libraries or modules can be loaded and released using <emph>Open document</emph> and <emph>Document closed</emph> events. Refer to <link href=\"text/sbasic/python/python_import.xhp\" name=\"Importing Python Modules\">Importing Python Modules</link> for more information."
+msgid "<menuitem>Start application</menuitem> and <menuitem>Close application</menuitem> events can respectively be used to set and to unset Python path for user scripts or %PRODUCTNAME scripts. In a similar fashion, document based Python libraries or modules can be loaded and released using <menuitem>Open document</menuitem> and <menuitem>Document closed</menuitem> events. Refer to <link href=\"text/sbasic/python/python_import.xhp\" name=\"Importing Python Modules\">Importing Python Modules</link> for more information."
 msgstr ""
 
 #. 8pHCg
@@ -3507,38 +3525,110 @@ msgctxt ""
 msgid "The Python interactive console, also known as Python interpreter or Python shell, provides programmers with a quick way to execute commands and try out and test code without creating a file. UNO objects introspection as well as %PRODUCTNAME Python modules documentation can be obtained from the terminal."
 msgstr ""
 
-#. MZodx
+#. kFpxo
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"par_id851633601202270\n"
+"help.text"
+msgid "From a full-featured %PRODUCTNAME installed package, use either Basic or Python:"
+msgstr ""
+
+#. 5HhXz
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
 "N0121\n"
 "help.text"
-msgid "Using a Basic macro:"
+msgid "Using a Basic macro"
 msgstr ""
 
-#. vXGF7
+#. KhWLk
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
 "N0127\n"
 "help.text"
-msgid "Using a Python macro:"
+msgid "Using a Python macro"
 msgstr ""
 
-#. oBg3T
+#. 3FCJH
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
 "N0141\n"
 "help.text"
-msgid "Usage:"
+msgid "Example output"
 msgstr ""
 
-#. EzwwC
+#. MxDtE
 #: python_shell.xhp
 msgctxt ""
 "python_shell.xhp\n"
 "N0142\n"
 "help.text"
-msgid "<image src=\"media/helpimg/python/python_shell.png\" id=\"N0143\"><alt id=\"N0144\">Python Interactive Console</alt></image>"
+msgid "<image src=\"media/helpimg/python/python_interactive_console.png\" id=\"N0143\"><alt id=\"N0143\">Python Interactive Console</alt></image>"
+msgstr ""
+
+#. fk6sx
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"hd_id381633446811095\n"
+"help.text"
+msgid "Using the Terminal"
+msgstr ""
+
+#. CNFdD
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"par_id801633601715910\n"
+"help.text"
+msgid "From a %PRODUCTNAME copy included in a GNU/Linux platform, use the terminal as shown:"
+msgstr ""
+
+#. vWPwe
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"par_id531633444780190\n"
+"help.text"
+msgid "<literal>whereis</literal> or <literal>type</literal> terminal commands help locate Python interactive console:"
+msgstr ""
+
+#. 8Ei5d
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"hd_id311633513620803\n"
+"help.text"
+msgid "Alternative console"
+msgstr ""
+
+#. d8DCA
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"par_id81632760673283\n"
+"help.text"
+msgid "Use <link href=\"https://extensions.libreoffice.org/extensions/apso-alternative-script-organizer-for-Python\" name=\"APSO extension\">APSO extension</link> console as an alternative:"
+msgstr ""
+
+#. 6h9CS
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"N0144\n"
+"help.text"
+msgid "<image src=\"media/helpimg/python/python_shell.png\" id=\"N0144\"><alt id=\"N0144\">APSO console</alt></image>"
+msgstr ""
+
+#. DNr5W
+#: python_shell.xhp
+msgctxt ""
+"python_shell.xhp\n"
+"par_id351633599611244\n"
+"help.text"
+msgid "<link href=\"text/sbasic/shared/03/sf_exception.html?#PythonShell\" name=\"PythonShell method\"><literal>PythonShell</literal></link> function in <link href=\"text/sbasic/shared/03/sf_exception.html\" name=\"ScriptForge.Exception service\"><literal>ScriptForge.Exception</literal></link> service"
 msgstr ""
diff --git a/source/fi/helpcontent2/source/text/sbasic/shared.po b/source/fi/helpcontent2/source/text/sbasic/shared.po
index 610b794642e..7d5f746a09f 100644
--- a/source/fi/helpcontent2/source/text/sbasic/shared.po
+++ b/source/fi/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
 msgstr ""
 "Project-Id-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-10-04 19:51+0200\n"
+"POT-Creation-Date: 2021-10-25 12:48+0200\n"
 "PO-Revision-Date: 2021-08-08 17:10+0000\n"
 "Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
 "Language-Team: Finnish <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared/fi/>\n"
@@ -16626,13 +16626,13 @@ msgctxt ""
 msgid "MsgBox Right(\"00\" & lHour , 2) & \":\"& Right(\"00\" & lMin , 2) & \":\" & Right(\"00\" & lSec , 2), 0, \"The time is\""
 msgstr ""
 
-#. CWMJG
+#. oYudq
 #: 03030303.xhp
 msgctxt ""
 "03030303.xhp\n"
 "par_id491610993401822\n"
 "help.text"
-msgid "The <literal>Timer</literal> function measures time in seconds. To measure time in milliseconds use the <embedvar href=\"text/sbasic/shared/03/sf_timer.xhp#TimerService\"/>."
+msgid "The <literal>Timer</literal> function measures time in seconds. To measure time in milliseconds use the <link href=\"text/sbasic/shared/03/sf_timer.xhp\" name=\"Timer_link\">Timer service</link> available in the <literal>ScriptForge</literal> library."
 msgstr ""
 
 #. ATnCy
@@ -24591,13 +24591,13 @@ msgctxt ""
 msgid "<bookmark_value>Type statement</bookmark_value>"
 msgstr ""
 
-#. aKHFj
+#. pipio
 #: 03090413.xhp
 msgctxt ""
 "03090413.xhp\n"
 "hd_id3153311\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03090413.xhp\" name=\"Type Statement\">Type Statement</link>"
+msgid "<variable id=\"Type_h1\"><link href=\"text/sbasic/shared/03090413.xhp\" name=\"Type Statement\">Type Statement</link></variable>"
 msgstr ""
 
 #. TYvyD
@@ -27804,13 +27804,13 @@ msgctxt ""
 msgid "<bookmark_value>IsObject function</bookmark_value>"
 msgstr "<bookmark_value>Basic-funktio IsObject</bookmark_value>"
 
-#. 9oZFD
+#. MF9nS
 #: 03102800.xhp
 msgctxt ""
 "03102800.xhp\n"
-"hd_id3149346\n"
+"hd_id51633474369322\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03102800.xhp\" name=\"IsObject Function\">IsObject Function</link>"
+msgid "<variable id=\"IsObject_h1\"><link href=\"text/sbasic/shared/03102800.xhp\" name=\"IsObject Function\">IsObject Function</link></variable>"
 msgstr ""
 
 #. AyVCR
@@ -27822,67 +27822,13 @@ msgctxt ""
 msgid "Tests if a variable is an object, as opposed to primitive data types such as dates, numbers, texts. The function returns <literal>True</literal> if the variable is an object, otherwise it returns <literal>False</literal>."
 msgstr ""
 
-#. gBKMV
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"hd_id3149234\n"
-"help.text"
-msgid "Syntax:"
-msgstr "Syntaksi:"
-
-#. C8wfe
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"par_id3154285\n"
-"help.text"
-msgid "IsObject(var)"
-msgstr ""
-
-#. ni2zH
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"hd_id3148685\n"
-"help.text"
-msgid "Return value:"
-msgstr "Palautusarvo:"
-
-#. 4SsCT
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"par_id3156024\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
-#. rEmQA
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"hd_id3148947\n"
-"help.text"
-msgid "Parameters:"
-msgstr "Parametrit:"
-
-#. JBB4B
-#: 03102800.xhp
-msgctxt ""
-"03102800.xhp\n"
-"par_id3148552\n"
-"help.text"
-msgid "<emph>var:</emph> Any variable that you want to test."
-msgstr ""
-
-#. SPGXx
+#. jCmJE
 #: 03102800.xhp
 msgctxt ""
 "03102800.xhp\n"
 "par_id891575896963115\n"
 "help.text"
-msgid "The following objects return <literal>True</literal>:"
+msgid "This function returns <literal>True</literal> for the following object types:"
 msgstr ""
 
 #. CBoWs
@@ -27939,6 +27885,24 @@ msgctxt ""
 msgid "Data structures return <literal>True</literal> even when empty. Object defined variables return <literal>True</literal> even if uninitialized."
 msgstr ""
 
+#. 4SsCT
+#: 03102800.xhp
+msgctxt ""
+"03102800.xhp\n"
+"par_id3156024\n"
+"help.text"
+msgid "Boolean"
+msgstr ""
+
+#. rTuwL
+#: 03102800.xhp
+msgctxt ""
+"03102800.xhp\n"
+"par_id3148552\n"
+"help.text"
+msgid "<emph>var:</emph> The variable to be tested."
+msgstr ""
+
 #. yHDkt
 #: 03102800.xhp
 msgctxt ""
@@ -28893,14 +28857,14 @@ msgctxt ""
 msgid "Set Statement"
 msgstr ""
 
-#. GzHJQ
+#. zHGh5
 #: 03103700.xhp
 msgctxt ""
 "03103700.xhp\n"
 "bm_id3154422\n"
 "help.text"
-msgid "<bookmark_value>Set statement</bookmark_value>  <bookmark_value>New keyword</bookmark_value>  <bookmark_value>Nothing object</bookmark_value>"
-msgstr ""
+msgid "<bookmark_value>Set statement</bookmark_value>  <bookmark_value>Nothing object</bookmark_value>"
+msgstr "<bookmark_value>Set-lause</bookmark_value><bookmark_value>Nothing-objekti</bookmark_value>"
 
 #. MT9CF
 #: 03103700.xhp
@@ -29766,23 +29730,32 @@ msgctxt ""
 msgid "<bookmark_value>EqualUnoObjects function</bookmark_value>"
 msgstr "<bookmark_value>Basic-funktio EqualUnoObjects</bookmark_value>"
 
-#. rqXey
+#. DxBM3
 #: 03104600.xhp
 msgctxt ""
 "03104600.xhp\n"
-"hd_id3149205\n"
+"hd_id791633472607429\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03104600.xhp\" name=\"EqualUnoObjects Function\">EqualUnoObjects Function</link>"
+msgid "<variable id=\"EqualUnoObjects_h1\"><link href=\"text/sbasic/shared/03104600.xhp\" name=\"EqualUnoObjects Function\">EqualUnoObjects Function</link></variable>"
 msgstr ""
 
-#. wrfhm
+#. Gc4cj
 #: 03104600.xhp
 msgctxt ""
 "03104600.xhp\n"
 "par_id3145090\n"
 "help.text"
-msgid "Returns True if the two specified Basic Uno objects represent the same Uno object instance."
-msgstr "EqualUnoObjects palauttaa arvon True, jos kaksi määrättyä Basic Uno-oliota edustavat samaa Uno-olion ilmentymää."
+msgid "Returns <emph>True</emph> if the two specified Basic variables represent the same Uno object instance."
+msgstr ""
+
+#. 9Zx4W
+#: 03104600.xhp
+msgctxt ""
+"03104600.xhp\n"
+"par_id61633530293311\n"
+"help.text"
+msgid "<emph>oObj1, oObj2:</emph> the variables to be tested."
+msgstr ""
 
 #. NqNdq
 #: 03104600.xhp
@@ -29793,22 +29766,22 @@ msgctxt ""
 msgid "Bool"
 msgstr "Bool-tyypin totuusarvo"
 
-#. eQEDj
+#. NvGLb
 #: 03104600.xhp
 msgctxt ""
 "03104600.xhp\n"
-"par_id3156024\n"
+"par_id771633473462939\n"
 "help.text"
-msgid "' Copy of objects -> same instance"
+msgid "The example below returns <emph>True</emph> because both <literal>oDoc</literal> and <literal>ThisComponent</literal> are references to the same object:"
 msgstr ""
 
-#. kTNQT
+#. 5QGLx
 #: 03104600.xhp
 msgctxt ""
 "03104600.xhp\n"
-"par_id3153525\n"
+"par_id181633473874216\n"
 "help.text"
-msgid "' Copy of structs as value -> new instance"
+msgid "The example below returns <emph>False</emph> because the assignment creates a copy of the original object. Hence <literal>Struct1</literal> and <literal>Struct2</literal> refer to different object instances."
 msgstr ""
 
 #. hQzux
@@ -30369,13 +30342,13 @@ msgctxt ""
 msgid "Use the <emph>Chr$</emph> function to send special control sequences to a printer or to another output source. You can also use it to insert quotation marks in a string expression."
 msgstr "<emph>Chr$</emph>-funktiota käytetään lähettämään erityinen ohjauskoodisarja tulostimelle tai muulle tulostuslaitteelle. Sitä voidaan käyttää myös lainausmerkkien lisäämiseen merkkijonolausekkeeseen."
 
-#. Yy5Eh
+#. 36Hj5
 #: 03120102.xhp
 msgctxt ""
 "03120102.xhp\n"
-"par_id111552916434071\n"
+"par_id81634652871848\n"
 "help.text"
-msgid "<embedvar href=\"text/sbasic/shared/00000003.xhp#err6\"/>, when VBA compatibility mode is enabled and expression is greater than 255."
+msgid "An overflow error will occur when VBA compatibility mode is enabled and the expression value is greater than 255."
 msgstr ""
 
 #. vHwsG
@@ -32655,14 +32628,14 @@ msgctxt ""
 msgid "Split (Text As String, delimiter, number)"
 msgstr "Split (teksti1 As String[, erotin1][, luku1])"
 
-#. BNdCD
+#. dBAZR
 #: 03120314.xhp
 msgctxt ""
 "03120314.xhp\n"
 "par_id3154285\n"
 "help.text"
-msgid "String"
-msgstr "merkkijono (String)"
+msgid "With Option VBASupport 1: String, with Option VBASupport 0: Variant/String"
+msgstr ""
 
 #. PRupM
 #: 03120314.xhp
@@ -35409,13 +35382,13 @@ msgctxt ""
 msgid "<bookmark_value>CreateObject function</bookmark_value>"
 msgstr "<bookmark_value>Basic-funktio CreateObject</bookmark_value>"
 
-#. GkTQC
+#. QpKCT
 #: 03132400.xhp
 msgctxt ""
 "03132400.xhp\n"
 "par_idN10580\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03132400.xhp\">CreateObject Function</link>"
+msgid "<variable id=\"CreateObject_h1\"><link href=\"text/sbasic/shared/03132400.xhp\">CreateObject Function</link></variable>"
 msgstr ""
 
 #. PAXDf
@@ -35436,14 +35409,14 @@ msgctxt ""
 msgid "This method creates instances of the type that is passed as parameter."
 msgstr "Tämä metodi luo ilmentymän, jonka tyyppi välitetään parametrissä."
 
-#. mNxwL
+#. SHgqs
 #: 03132400.xhp
 msgctxt ""
 "03132400.xhp\n"
-"par_idN105A6\n"
+"par_id191633632167310\n"
 "help.text"
-msgid "oObj = CreateObject( type )"
-msgstr "oObj = CreateObject( type )"
+msgid "<emph>type:</emph> the type of the object to be created, as a string."
+msgstr ""
 
 #. Gthw7
 #: 03132500.xhp
@@ -37470,49 +37443,94 @@ msgctxt ""
 msgid "Round Function [VBA]"
 msgstr ""
 
-#. 66dvh
+#. zEB5S
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "bm_id3150499\n"
 "help.text"
-msgid "<bookmark_value>Round function</bookmark_value>"
+msgid "<bookmark_value>Round function (VBA)</bookmark_value>"
 msgstr ""
 
-#. FPUAv
+#. oVQUL
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "hd_id3150499\n"
 "help.text"
-msgid "<link href=\"text/sbasic/shared/03170000.xhp\" name=\"Round Function [VBA]\">Round Function [VBA]</link>"
+msgid "<variable id=\"Round_VBA_h1\"><link href=\"text/sbasic/shared/03170000.xhp\" name=\"Round Function [VBA]\">Round Function [VBA]</link></variable>"
 msgstr ""
 
-#. PGShA
+#. B6tFP
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id3151384\n"
 "help.text"
-msgid "The Round function returns a number rounded to a specified number of digits."
+msgid "Rounds a numeric value to a specified number of decimal digits."
 msgstr ""
 
-#. hbUFX
+#. yUTFN
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id741634154499890\n"
+"help.text"
+msgid "This function implements the rounding rule known as \"round-to-even\". With this rule, whenever the difference between the number to be rounded and its nearest integer is equal to 0.5, the number is rounded to the nearest even number. See the examples <link href=\"text/sbasic/shared/03170000.xhp#round_example\" name=\"round_ex_link\">below</link> to learn more about this rule."
+msgstr ""
+
+#. DfnHz
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id691634217736290\n"
+"help.text"
+msgid "Beware that VBA's <literal>Round</literal> function works differently than %PRODUCTNAME Calc's <literal>Round</literal> function. In Calc, if the difference between the number to be rounded and the nearest integer is exactly 0.5, then the number is rounded up. Hence, in Calc the number 2.5 is rounded to 3 whereas using VBA's <literal>Round</literal> function the value 2.5 is rounded to 2 due to the \"round-to-even\" rule."
+msgstr ""
+
+#. GSzGj
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id240720170117391741\n"
 "help.text"
-msgid "<emph>expression</emph>: Required. The numeric expression to be rounded."
+msgid "<emph>expression</emph>: The numeric expression to be rounded."
 msgstr ""
 
-#. gAZc7
+#. 9E33v
 #: 03170000.xhp
 msgctxt ""
 "03170000.xhp\n"
 "par_id240720170117395610\n"
 "help.text"
-msgid "<emph>numdecimalplaces</emph>: Optional. Specifies how many places to the right of the decimal are included in the rounding. Default is 0."
+msgid "<emph>numdecimalplaces</emph>: Optional argument that specifies the number of decimal digits in the resulting rounded value. The default value is 0."
+msgstr ""
+
+#. oSEiU
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"par_id541634154843718\n"
+"help.text"
+msgid "The following examples illustrate the \"round-to-even\" rule:"
+msgstr ""
+
+#. 4DLZC
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"bas_id651634154984931\n"
+"help.text"
+msgid "' Rounding to the nearest integer (decimalplaces = 0)"
+msgstr ""
+
+#. DQwkT
+#: 03170000.xhp
+msgctxt ""
+"03170000.xhp\n"
+"bas_id651634157812537\n"
+"help.text"
+msgid "' Rounding with 2 decimal digits (decimalplaces = 2)"
 msgstr ""
 
 #. g7CVV
@@ -40170,6 +40188,375 @@ msgctxt ""
 msgid "BasicCodeStubs"
 msgstr "BasicCodeStubs"
 
+#. vSapF
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"tit\n"
+"help.text"
+msgid "Collection Object"
+msgstr ""
+
+#. 5of5h
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bm_id3149205\n"
+"help.text"
+msgid "<bookmark_value>Collection Object</bookmark_value>      <bookmark_value>Collection;Count</bookmark_value>"
+msgstr ""
+
+#. 68sg6
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id791633472607429\n"
+"help.text"
+msgid "<variable id=\"Collection_h1\"><link href=\"text/sbasic/shared/collection.xhp\" name=\"New_Operator\">Collection Object</link></variable>"
+msgstr ""
+
+#. 7xSei
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id581633961735332\n"
+"help.text"
+msgid "Collections can be used to store items of different types. Each item can be accessed by its index or by an optional key associated with it."
+msgstr ""
+
+#. 9b4kg
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id131633961959816\n"
+"help.text"
+msgid "A <literal>Collection</literal> object has the following methods:"
+msgstr ""
+
+#. XoLQr
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id331633962000259\n"
+"help.text"
+msgid "<emph>Add:</emph> inserts a new item into the collection. Optionally a string value can be defined as the key to the item."
+msgstr ""
+
+#. ddAGy
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id181633962000767\n"
+"help.text"
+msgid "<emph>Count:</emph> returns the number of items in the collection."
+msgstr ""
+
+#. ad7qY
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id521633962001072\n"
+"help.text"
+msgid "<emph>Item:</emph> returns the item in the collection by passing its index or key."
+msgstr ""
+
+#. GX6nx
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id981633962001272\n"
+"help.text"
+msgid "<emph>Remove:</emph> removes the specified item from the collection by its index or key."
+msgstr ""
+
+#. yyWx7
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id221633976539661\n"
+"help.text"
+msgid "Items in a Collection can be accessed either by their indices (as in a 1-based single-dimensional Array) or by their associated keys."
+msgstr ""
+
+#. PheLX
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id811634214809970\n"
+"help.text"
+msgid "The <link href=\"text/sbasic/shared/03/sf_dictionary.xhp\" name=\"SFDic_link\"><literal>ScriptForge Dictionary</literal></link> service extends the <literal>Collection</literal> object by providing supplemental features as key retrieval and replacement, as well as import/export to Array objects and JSON strings."
+msgstr ""
+
+#. pJAht
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id51633962353863\n"
+"help.text"
+msgid "Creating a Collection"
+msgstr ""
+
+#. 28i8B
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id491633962366024\n"
+"help.text"
+msgid "To create a <literal>Collection</literal> use the <literal>New</literal> keyword. The following example creates a <literal>Collection</literal> object and populates it with three items:"
+msgstr ""
+
+#. 8hHmz
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id421633962742512\n"
+"help.text"
+msgid "Adding Items"
+msgstr ""
+
+#. G49p7
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bm_id591633974561425\n"
+"help.text"
+msgid "<bookmark_value>Collection;Add</bookmark_value>"
+msgstr ""
+
+#. 3qnWY
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id261633962766238\n"
+"help.text"
+msgid "The <literal>Add</literal> method can be used to add new items into the <literal>Collection</literal> object."
+msgstr ""
+
+#. htAaY
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id501633974650241\n"
+"help.text"
+msgid "<emph>item:</emph> the item to be added to the <literal>Collection</literal>. May be of any type."
+msgstr ""
+
+#. DUGrx
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id181633974650705\n"
+"help.text"
+msgid "<emph>key:</emph> string value used as the unique key used to identify this value."
+msgstr ""
+
+#. yoEzK
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id391633974651050\n"
+"help.text"
+msgid "<emph>before, after:</emph> optional keyword argument that indicates where the new item will be placed in the <literal>Collection</literal>. Only one of the arguments <literal>before</literal> or <literal>after</literal> can be specified to determine the index or key before which (or after which) the new item is to be placed."
+msgstr ""
+
+#. xcdEF
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id211633962988398\n"
+"help.text"
+msgid "The example below adds two elements into a <literal>Collection</literal>. The first has a key associated with it, whereas the second does not."
+msgstr ""
+
+#. ZKBEQ
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id71633963110632\n"
+"help.text"
+msgid "The <literal>Add</literal> method also supports keyword arguments:"
+msgstr ""
+
+#. ZhTZb
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id941633963225913\n"
+"help.text"
+msgid "Keys must be unique in a <literal>Collection</literal> object. Comparison between keys is <emph>case-insensitive</emph>. Adding duplicated keys will result in a runtime error."
+msgstr ""
+
+#. NVgmj
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id891633975568372\n"
+"help.text"
+msgid "The example below illustrates how to use the <literal>Before</literal> and <literal>After</literal> keyword arguments to determine the position of the item that is being added."
+msgstr ""
+
+#. WxjE9
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id121633976325472\n"
+"help.text"
+msgid "Items in a <literal>Collection</literal> object are assigned an integer index value that starts at 1 and corresponds to the order in which they were added."
+msgstr ""
+
+#. 2Lrc6
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id141633977141797\n"
+"help.text"
+msgid "Accessing Items"
+msgstr ""
+
+#. DDdKC
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bm_id481633977601834\n"
+"help.text"
+msgid "<bookmark_value>Collection;Item</bookmark_value>"
+msgstr ""
+
+#. MquEn
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id431633977156315\n"
+"help.text"
+msgid "Use the <literal>Item</literal> method to access a given item by its index or key."
+msgstr ""
+
+#. DCFTg
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id261633976447187\n"
+"help.text"
+msgid "<emph>index:</emph> an integer value specifying the index of the item to be returned."
+msgstr ""
+
+#. mqA85
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id51633976782487\n"
+"help.text"
+msgid "<emph>key:</emph> a string value specifying the key of the item to be returned."
+msgstr ""
+
+#. egnJW
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id651633976030220\n"
+"help.text"
+msgid "Removing Items"
+msgstr ""
+
+#. BdBa3
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bm_id311633977567197\n"
+"help.text"
+msgid "<bookmark_value>Collection;Remove</bookmark_value>"
+msgstr ""
+
+#. Wteju
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id391633976125206\n"
+"help.text"
+msgid "Use the <literal>Remove</literal> method to delete items from a <literal>Collection</literal> object."
+msgstr ""
+
+#. sHVAN
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id121633976268027\n"
+"help.text"
+msgid "Items can be removed either by their indices or key values."
+msgstr ""
+
+#. o9Eyd
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id261633976447289\n"
+"help.text"
+msgid "<emph>index:</emph> an integer value specifying the index of the item to be removed."
+msgstr ""
+
+#. 8TMiC
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id51633976782455\n"
+"help.text"
+msgid "<emph>key:</emph> a string value specifying the key of the item to be removed."
+msgstr ""
+
+#. WpHmn
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id491633978085731\n"
+"help.text"
+msgid "Iterating Over all Items"
+msgstr ""
+
+#. FVzmC
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id91633978099143\n"
+"help.text"
+msgid "It is possible to use a <literal>For Each ... Next</literal> statement to iterate over all items in a <literal>Collection</literal>."
+msgstr ""
+
+#. EWDWE
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"hd_id191634215349347\n"
+"help.text"
+msgid "Clearing a Collection"
+msgstr ""
+
+#. V4EZw
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"par_id891634215363485\n"
+"help.text"
+msgid "To remove all items from a <literal>Collection</literal> object call the <literal>Remove</literal> method for each item, as illustrated in the example below:"
+msgstr ""
+
+#. tUMtQ
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bas_id681634215646028\n"
+"help.text"
+msgid "' Create a sample Collection with two entries"
+msgstr ""
+
+#. Yy5nP
+#: collection.xhp
+msgctxt ""
+"collection.xhp\n"
+"bas_id391634215647196\n"
+"help.text"
+msgid "' Removes all items in the collection"
+msgstr ""
+
 #. gvH3T
 #: compatibilitymode.xhp
 msgctxt ""
@@ -40350,13 +40737,13 @@ msgctxt ""
 msgid "<variable id=\"compatiblestatement\"><link href=\"text/sbasic/shared/compatible.xhp\" name=\"compatible\">Option Compatible Statement</link></variable>"
 msgstr ""
 
-#. qCdkp
+#. 6HFov
 #: compatible.xhp
 msgctxt ""
 "compatible.xhp\n"
 "N0106\n"
 "help.text"
-msgid "<literal>Option Compatible</literal> turns on the VBA-compatible Basic compiler mode at the module level."
+msgid "<literal>Option Compatible</literal> extends %PRODUCTNAME Basic compiler and runtime, allowing supplemental language constructs to Basic."
 msgstr ""
 
 #. SNhhH
@@ -41043,6 +41430,78 @@ msgctxt ""
 msgid "<image src=\"media/helpimg/sbasic/char_fragment.svg\" id=\"img_id4157296484514\"><alt id=\"alt_id15152796484516\">type declaration characters</alt></image>"
 msgstr ""
 
+#. tYUK6
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"tit\n"
+"help.text"
+msgid "Is Operator"
+msgstr ""
+
+#. xvBgn
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"bm_id3149205\n"
+"help.text"
+msgid "<bookmark_value>Is Operator</bookmark_value>"
+msgstr ""
+
+#. 7otAB
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"hd_id791633472607429\n"
+"help.text"
+msgid "<variable id=\"IsOperator_h1\"><link href=\"text/sbasic/shared/is_keyword.xhp\" name=\"Is_Operator\">Is Operator</link></variable>"
+msgstr ""
+
+#. mwGMA
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"par_id3145090\n"
+"help.text"
+msgid "Tests if two Basic variables refer to the same object instance."
+msgstr ""
+
+#. HTVQA
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"par_id441633531311929\n"
+"help.text"
+msgid "If <literal>oObj1</literal> and <literal>oObj2</literal> are references to the same object instance, the result will be <emph>True</emph>."
+msgstr ""
+
+#. akugg
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"par_id771633473462939\n"
+"help.text"
+msgid "The example below first defines a new type <literal>Student</literal>. Calling <literal>TestObjects</literal> creates the object <literal>oStudent1</literal> as a new object of this type."
+msgstr ""
+
+#. mAAho
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"par_id841633532400710\n"
+"help.text"
+msgid "The assignment <literal>oStudent2 = oStudent1</literal> actually copies the reference to the same object. Hence the result of applying the <literal>Is</literal> operator is <emph>True</emph>."
+msgstr ""
+
+#. mvVuR
+#: is_keyword.xhp
+msgctxt ""
+"is_keyword.xhp\n"
+"par_id181633473874216\n"
+"help.text"
+msgid "The example below returns <emph>False</emph> because <literal>oStudent1</literal> and <literal>oStudent2</literal> are references to two different object instances, each created with the <literal>New</literal> operator."
+msgstr ""
+
 #. onSEk
 #: keys.xhp
 msgctxt ""
@@ -41349,6 +41808,87 @@ msgctxt ""
 msgid "%PRODUCTNAME installs a set of Basic macro libraries that can be accessed from your Basic macros."
 msgstr ""
 
+#. 44MBv
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"tit\n"
+"help.text"
+msgid "New Operator"
+msgstr ""
+
+#. 8iBmc
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"bm_id3149205\n"
+"help.text"
+msgid "<bookmark_value>New Operator</bookmark_value>"
+msgstr ""
+
+#. T3AA8
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"hd_id791633472607429\n"
+"help.text"
+msgid "<variable id=\"NewOperator_h1\"><link href=\"text/sbasic/shared/new_keyword.xhp\" name=\"New_Operator\">New Operator</link></variable>"
+msgstr ""
+
+#. BWufp
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"par_id3145090\n"
+"help.text"
+msgid "Use the <literal>New</literal> operator to instantiate objects of user-defined types, as well as Uno services, structs and enumerations."
+msgstr ""
+
+#. uDGEZ
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"par_id831633630704012\n"
+"help.text"
+msgid "The <literal>New</literal> operator can be used either during variable declaration or in an assignment operation."
+msgstr ""
+
+#. r6osC
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"par_id621633630563936\n"
+"help.text"
+msgid "The following example uses the <literal>New</literal> operator to create an instance of the <literal>PropertyValue</literal> Uno struct."
+msgstr ""
+
+#. nPNvc
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"bas_id631633630856218\n"
+"help.text"
+msgid "' Instantiating the object during variable declaration"
+msgstr ""
+
+#. Ts8iC
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"bas_id11633631135918\n"
+"help.text"
+msgid "' The same can be accomplished with an assignment"
+msgstr ""
+
+#. 6RJcJ
+#: new_keyword.xhp
+msgctxt ""
+"new_keyword.xhp\n"
+"par_id971633631328827\n"
+"help.text"
+msgid "The example below creates a new type <literal>Student</literal> and instantiates an object of this type:"
+msgstr ""
+
 #. r4nQn
 #: partition.xhp
 msgctxt ""
diff --git a/source/fi/helpcontent2/source/text/sbasic/shared/03.po b/source/fi/helpcontent2/source/text/sbasic/shared/03.po
index b4145cdad2c..cf7036225a4 100644
--- a/source/fi/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/fi/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-10-04 19:51+0200\n"
+"POT-Creation-Date: 2021-10-25 12:48+0200\n"
 "PO-Revision-Date: 2018-07-12 14:29+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -160,13 +160,13 @@ msgctxt ""
 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 ""
 
-#. yE8bw
+#. Poeai
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
 "bm_id491529070339774\n"
 "help.text"
-msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value>        <bookmark_value>Python scriptforge module</bookmark_value>"
+msgid "<bookmark_value>BASIC ScriptForge library</bookmark_value>    <bookmark_value>Python scriptforge module</bookmark_value>"
 msgstr ""
 
 #. BtMUU
@@ -178,13 +178,13 @@ msgctxt ""
 msgid "ScriptForge libraries build up an extensible collection of macro scripting resources for %PRODUCTNAME to be invoked from Basic macros or Python scripts."
 msgstr ""
 
-#. YwSXj
+#. eotwE
 #: lib_ScriptForge.xhp
 msgctxt ""
 "lib_ScriptForge.xhp\n"
 "par_id1001623412767893\n"
 "help.text"
-msgid "To learn more about how to create and execute Python scripts using the <literal>ScriptForge</literal> library, read the <embedvar href=\"text/sbasic/shared/03/sf_intro.xhp#title\"/> help page."
+msgid "To learn more about how to create and execute Python scripts using the <literal>ScriptForge</literal> library, read the help page <link href=\"text/sbasic/shared/03/sf_intro.xhp\" name=\"sfintro_link\">Creating Python Scripts with ScriptForge</link>."
 msgstr ""
 
 #. wKZM6
@@ -9106,13 +9106,13 @@ msgctxt ""
 msgid "Keys and items can be retrieved, counted, updated, and much more."
 msgstr ""
 
-#. HnBYG
+#. LtaTT
 #: sf_dictionary.xhp
 msgctxt ""
 "sf_dictionary.xhp\n"
 "par_id971582884636922\n"
 "help.text"
-msgid "%PRODUCTNAME Basic <literal>Collection</literal> object does not support the retrieval of the keys.  <br/>Additionally its items contain only primitive Basic data types such as dates, text, numbers, and the like."
+msgid "The Dictionary service is similar to the built-in %PRODUCTNAME Basic <literal>Collection</literal> object, however with more features. For example, <literal>Collection</literal> objects do not support the retrieval of keys. Moreover, Dictionaries provide additional capabilities as replacing keys, testing if a specific key already exists and converting the Dictionary into an Array object or JSON string."
 msgstr ""
 
 #. RkMHR
@@ -15775,13 +15775,13 @@ msgctxt ""
 msgid "<emph>Debugging:</emph> Whenever an error occurs in Python scripts that use <literal>ScriptForge</literal>, the error message provided by the Python execution stack displays the line of code that triggered the error. In Basic error messages do not display this information."
 msgstr ""
 
-#. ZzngK
+#. cPtYB
 #: sf_intro.xhp
 msgctxt ""
 "sf_intro.xhp\n"
 "par_id31623411828158\n"
 "help.text"
-msgid "Visit <embedvar href=\"text/sbasic/python/main0000.xhp#pythonscriptshelp\"/> for more information on Python scripting using %PRODUCTNAME."
+msgid "Visit <link href=\"text/sbasic/python/main0000.xhp#\" name=\"pyscripts_link\">%PRODUCTNAME Python Scripts Help</link> for more information on Python scripting using %PRODUCTNAME."
 msgstr ""
 
 #. CZiTF
@@ -17620,13 +17620,13 @@ msgctxt ""
 msgid "ScriptForge.Session service"
 msgstr ""
 
-#. c4YAM
+#. DxnDG
 #: sf_session.xhp
 msgctxt ""
 "sf_session.xhp\n"
 "hd_id901582814720985\n"
 "help.text"
-msgid "<variable id=\"SessionService\"><link href=\"text/sbasic/shared/03/sf_session.xhp\" name=\"Session service\"><literal>ScriptForge</literal>.<literal>Session</literal> service</link></variable>"
+msgid "<variable id=\"SessionService\"><link href=\"text/sbasic/shared/03/sf_session.xhp\" name=\"Session service\"><literal>ScriptForge.Session</literal> service</link></variable>"
 msgstr ""
 
 #. yTgFK
@@ -18025,13 +18025,13 @@ msgctxt ""
 msgid "Consider the Python function <literal>odd_integers</literal> defined below that creates a list with odd integer values between <literal>v1</literal> and <literal>v2</literal>. Suppose this function is stored in a file named <emph>my_macros.py</emph> in your user scripts folder."
 msgstr ""
 
-#. CHr5n
+#. o6DUm
 #: sf_session.xhp
 msgctxt ""
 "sf_session.xhp\n"
 "par_id751626817335715\n"
 "help.text"
-msgid "Read the help page <embedvar href=\"text/sbasic/python/python_locations.xhp#pythonlocations1\"/> to learn more about where Python scripts can be stored."
+msgid "Read the help page <link href=\"text/sbasic/python/python_locations.xhp\" name=\"pylocation_link\">Python Scripts Organization and Location</link> to learn more about where Python scripts can be stored."
 msgstr ""
 
 #. vqBm9