update translations for 7.3.0 rc1

and force-fix errors using pocheck

Change-Id: Iaf5f970103a9ace669ee6019b2362031e34cbdf0

1 files changed, 1146 insertions, 102 deletions

diff --git a/source/si/helpcontent2/source/text/sbasic/shared/03.po b/source/si/helpcontent2/source/text/sbasic/shared/03.po
index e3766302a8c..8ed73d7897c 100644
--- a/source/si/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/si/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-11-25 19:33+0100\n"
+"POT-Creation-Date: 2021-12-20 13:20+0100\n"
 "PO-Revision-Date: 2018-07-12 14:35+0000\n"
 "Last-Translator: Anonymous Pootle User\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2761,13 +2761,13 @@ msgctxt ""
 msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
 msgstr ""
 
-#. FX6mM
+#. UxDTL
 #: sf_base.xhp
 msgctxt ""
 "sf_base.xhp\n"
 "par_id141635436912146\n"
 "help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
 msgstr ""
 
 #. gDM4C
@@ -2833,13 +2833,13 @@ msgctxt ""
 msgid "Typical example:"
 msgstr ""
 
-#. yrYgm
+#. fBDsN
 #: 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')"
+msgid "bas.MsgBox('Display this text in a message box from a Python script')"
 msgstr ""
 
 #. kGyCd
@@ -3706,22 +3706,22 @@ msgctxt ""
 msgid "The <literal>SFDocuments</literal> shared library provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME documents."
 msgstr ""
 
-#. r34Cu
+#. CBPyB
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id351591014177269\n"
 "help.text"
-msgid "Some methods are generic for all types of documents and are inherited from the <literal>SF_Document</literal> module, whereas other methods that are specific for Calc documents are defined in the <literal>SF_Calc</literal> module."
+msgid "The <literal>SFDocuments.Calc</literal> service is a subclass of the <link href=\"text/sbasic/shared/03/sf_document.xhp\" name=\"SF_Document_link\"><literal>SFDocuments.Document</literal></link> service. All methods and properties defined for the <literal>Document</literal> service can also be accessed using a <literal>Calc</literal> service instance."
 msgstr ""
 
-#. kTVJM
+#. 4uAEX
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id591589189364267\n"
 "help.text"
-msgid "The <literal>SF_Calc</literal> module is focused on:"
+msgid "The <literal>Calc</literal> service is focused on:"
 msgstr ""
 
 #. Gy8dD
@@ -3751,6 +3751,15 @@ msgctxt ""
 msgid "Copying and importing massive amounts of data"
 msgstr ""
 
+#. UFCyZ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id851638217526844\n"
+"help.text"
+msgid "This help page describes methods and properties that are applicable only to Calc documents."
+msgstr ""
+
 #. A47hJ
 #: sf_calc.xhp
 msgctxt ""
@@ -4165,13 +4174,13 @@ msgctxt ""
 msgid "Argument"
 msgstr ""
 
-#. GkAHr
+#. H9m2q
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id31582885195238\n"
 "help.text"
-msgid "Type"
+msgid "Return type"
 msgstr ""
 
 #. DDSFu
@@ -4210,13 +4219,94 @@ msgctxt ""
 msgid "String or array of strings"
 msgstr ""
 
-#. KUB6n
+#. kAAXc
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id85159240716560\n"
 "help.text"
-msgid "The single selected range as a string or the list of selected ranges as an array"
+msgid "The single selected range as a string or the list of selected ranges as an array."
+msgstr ""
+
+#. PFB5D
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407165606\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 5GeyC
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165545\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. TBHV2
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716828\n"
+"help.text"
+msgid "Returns the first used cell in a given range or sheet."
+msgstr ""
+
+#. BkCoD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407166642\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. ToQBc
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165145\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. boSak
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716225\n"
+"help.text"
+msgid "Returns the leftmost column number in a given range or sheet."
+msgstr ""
+
+#. 3AKqL
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407167972\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. zf3hK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165695\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. BXscD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716128\n"
+"help.text"
+msgid "Returns the topmost row number in a given range or sheet."
 msgstr ""
 
 #. BHFeu
@@ -4237,13 +4327,13 @@ msgctxt ""
 msgid "RangeName As String"
 msgstr ""
 
-#. R8spm
+#. FhLMF
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id311593094953330\n"
 "help.text"
-msgid "The number of rows (>= 1) in the given range"
+msgid "The number of rows (>= 1) in the given range."
 msgstr ""
 
 #. cU3Ah
@@ -4255,22 +4345,22 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. 4bY5E
+#. ALJCP
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id501591018870619\n"
 "help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
 msgstr ""
 
-#. XTyXP
+#. SNj7Q
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id881582885195976\n"
 "help.text"
-msgid "The last used cell in 'A1' format in the given sheet"
+msgid "Returns the last used cell in a given range or sheet."
 msgstr ""
 
 #. 75PEK
@@ -4282,22 +4372,22 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. Cu5Dr
+#. 3h43j
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id831592315106202\n"
 "help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
 msgstr ""
 
-#. ZZuih
+#. bU5vD
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id791592315106790\n"
 "help.text"
-msgid "The last used column in the given sheet"
+msgid "The last used column in a given range or sheet."
 msgstr ""
 
 #. q9Bx7
@@ -4309,22 +4399,22 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. hn9su
+#. r6diM
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id81591025591696\n"
 "help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
 msgstr ""
 
-#. NGNDP
+#. SDdEC
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id421591025591509\n"
 "help.text"
-msgid "The last used row in the given sheet"
+msgid "The last used row in a given range or sheet."
 msgstr ""
 
 #. 4t3He
@@ -4345,13 +4435,13 @@ msgctxt ""
 msgid "RangeName As String"
 msgstr ""
 
-#. DSHss
+#. 2tmEj
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id571591025591367\n"
 "help.text"
-msgid "A range reference that can be used as argument of methods like <literal>CopyToRange</literal>"
+msgid "A range reference that can be used as argument of methods like <literal>CopyToRange</literal>."
 msgstr ""
 
 #. boDiE
@@ -4372,13 +4462,13 @@ msgctxt ""
 msgid "RangeName As String"
 msgstr ""
 
-#. kdjWP
+#. ey2LS
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id571591025599937\n"
 "help.text"
-msgid "Returns the address of the smallest area that contains the specified range so that the area is surrounded by empty cells or sheet edges. This is equivalent to applying the <keycode>Ctrl + *</keycode> shortcut to the given range."
+msgid "Returns the address of the smallest area that contains the specified range so that the area is surrounded by empty cells or sheet edges. This is equivalent to applying the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command + *</keycode></caseinline><defaultinline><keycode>Ctrl + *</keycode></defaultinline></switchinline> shortcut to the given range."
 msgstr ""
 
 #. 66iAb
@@ -4399,13 +4489,13 @@ msgctxt ""
 msgid "SheetName As String"
 msgstr ""
 
-#. JQ3xT
+#. 4KoAw
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id731591025591753\n"
 "help.text"
-msgid "A sheet reference that can be used as argument of methods like <literal>CopySheet</literal>"
+msgid "A sheet reference that can be used as argument of methods like <literal>CopySheet</literal>."
 msgstr ""
 
 #. HLpEQ
@@ -4435,13 +4525,13 @@ msgctxt ""
 msgid "Array of strings"
 msgstr ""
 
-#. dpUQH
+#. qGsms
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id491591025591370\n"
 "help.text"
-msgid "The list with the names of all existing sheets"
+msgid "The list with the names of all existing sheets."
 msgstr ""
 
 #. EaAB2
@@ -4462,13 +4552,13 @@ msgctxt ""
 msgid "RangeName As String"
 msgstr ""
 
-#. 2qreU
+#. BKFhE
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id681593095062358\n"
 "help.text"
-msgid "The number of columns (>= 1) in the given range"
+msgid "The number of columns (>= 1) in the given range."
 msgstr ""
 
 #. cju3B
@@ -4489,22 +4579,13 @@ msgctxt ""
 msgid "RangeName As String"
 msgstr ""
 
-#. s6c4j
+#. VaGpB
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id321592315404430\n"
 "help.text"
-msgid "A <literal>com.sun.star.Table.XCellRange</literal> UNO object"
-msgstr ""
-
-#. DFirg
-#: sf_calc.xhp
-msgctxt ""
-"sf_calc.xhp\n"
-"par_id961592315565332\n"
-"help.text"
-msgid "XSheetCellCursor"
+msgid "A <literal>com.sun.star.Table.XCellRange</literal> UNO object."
 msgstr ""
 
 #. nAD2d
@@ -4552,22 +4633,22 @@ msgctxt ""
 msgid "SheetName As String"
 msgstr ""
 
-#. 8eX6C
+#. cJAB7
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id41592315560095\n"
 "help.text"
-msgid "A <literal>com.sun.star.sheet.XSpreadsheet</literal> UNO object"
+msgid "A <literal>com.sun.star.sheet.XSpreadsheet</literal> UNO object."
 msgstr ""
 
-#. r9Fpc
+#. hwjGf
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id321611613059105\n"
 "help.text"
-msgid "Visit LibreOffice API Documentation's website to learn more about <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html\" name=\"XCellRange API\">XCellRange</link>, <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSheetCellCursor.html\" name=\"XSheetCellCursor API\">XSheetCellCursor</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSpreadsheet.html\" name=\"XSpreadsheet API\">XSpreadsheet</link> UNO objects."
+msgid "Visit %PRODUCTNAME API Documentation's website to learn more about <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html\" name=\"XCellRange API\">XCellRange</link>, <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSheetCellCursor.html\" name=\"XSheetCellCursor API\">XSheetCellCursor</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSpreadsheet.html\" name=\"XSpreadsheet API\">XSpreadsheet</link> UNO objects."
 msgstr ""
 
 #. V5dF8
@@ -4687,13 +4768,13 @@ msgctxt ""
 msgid "Activating a sheet makes sense only if it is performed on a Calc document. To make sure you have a Calc document at hand you can use the <literal>isCalc</literal> property of the document object, which returns <literal>True</literal> if it is a Calc document and <literal>False</literal> otherwise."
 msgstr ""
 
-#. 2EffV
+#. KWFFF
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id93158919969856\n"
 "help.text"
-msgid "Returns either the list with the names of all chart objects in a given sheet or a single chart service instance."
+msgid "Returns either the list with the names of all chart objects in a given sheet or a single <literal>Chart</literal> service instance."
 msgstr ""
 
 #. sBNho
@@ -4732,13 +4813,13 @@ msgctxt ""
 msgid "<emph>chartname</emph>: The user-defined name of the chart object to be returned. If the chart does not have a user-defined name, then the internal object name can be used. If this argument is absent, then the list of chart names in the specified sheet is returned."
 msgstr ""
 
-#. Bdgw9
+#. C7CSH
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id431635438771588\n"
 "help.text"
-msgid "Use the <menuitem>Navigator</menuitem>  sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem>  category."
+msgid "Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category."
 msgstr ""
 
 #. zbX9R
@@ -5785,13 +5866,202 @@ msgctxt ""
 msgid "'SheetX.$C$3:$H$7 (A1 offset by two rows and columns with width of 5 rows and 6 columns)"
 msgstr ""
 
-#. bNqfB
+#. GwPQh
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id51592233506021\n"
+"help.text"
+msgid "Opens a non-modal dialog that can be used to select a range in the document and returns a string containing the selected range."
+msgstr ""
+
+#. CWn2A
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301637936295380\n"
+"help.text"
+msgid "This method opens the same dialog that is used by %PRODUCTNAME when the Shrink button is pressed. For example, the <menuitem>Tools - Goal Seek</menuitem> dialog has a Shrink button to the right of the <menuitem>Formula cell</menuitem> field."
+msgstr ""
+
+#. XUoah
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551637936545121\n"
+"help.text"
+msgid "This method does not change the current selection."
+msgstr ""
+
+#. tAHiV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id901592233506001\n"
+"help.text"
+msgid "<emph>title</emph>: The title of the dialog, as a string."
+msgstr ""
+
+#. Yyn74
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id781592234124502\n"
+"help.text"
+msgid "<emph>selection</emph>: An optional range that is initially selected when the dialog is displayed."
+msgstr ""
+
+#. zo7VK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id971592234138989\n"
+"help.text"
+msgid "<emph>singlecell</emph>: When <literal>True</literal> (default) only single-cell selection is allowed. When <literal>False</literal> range selection is allowed."
+msgstr ""
+
+#. SqEWv
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id321592234150345\n"
+"help.text"
+msgid "<emph>closeafterselect</emph>: When <literal>True</literal> (default) the dialog is closed immediately after the selection is made. When <literal>False</literal> the user can change the selection as many times as needed and then manually close the dialog."
+msgstr ""
+
+#. yDiCm
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id51592233503441\n"
+"help.text"
+msgid "Returns the input string after substituting its token characters by their values in a given range."
+msgstr ""
+
+#. Qu4DK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551637936596521\n"
+"help.text"
+msgid "This method does not change the current selection."
+msgstr ""
+
+#. eEqCY
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id171637938442558\n"
+"help.text"
+msgid "This method can be used to quickly extract specific parts of a range name, such as the sheet name or first cell column and row, and use them to compose a new range address."
+msgstr ""
+
+#. RAAVz
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id901592233506232\n"
+"help.text"
+msgid "<emph>inputstr</emph>: The string containing the tokens that will be replaced by the corresponding values in <literal>range</literal>."
+msgstr ""
+
+#. NJdUy
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id781592234161102\n"
+"help.text"
+msgid "<emph>range</emph>: A <literal>RangeName</literal> from which values will be extracted. If it contains a sheet name, the sheet must exist."
+msgstr ""
+
+#. BgCCD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id971592234102889\n"
+"help.text"
+msgid "<emph>tokencharacter</emph>: Character used to identify tokens. By default \"%\" is the token character. The following tokens are accepted:"
+msgstr ""
+
+#. WTDwR
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id261637943912156\n"
+"help.text"
+msgid "<emph>%S</emph> - The sheet name containing the range, including single quotes when necessary."
+msgstr ""
+
+#. YHLeU
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id441637943912380\n"
+"help.text"
+msgid "<emph>%R1</emph> - The row number of the top left cell of the range."
+msgstr ""
+
+#. joJi7
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id521637943912620\n"
+"help.text"
+msgid "<emph>%C1</emph> - The column letter of the top left cell of the range."
+msgstr ""
+
+#. YAfmV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id371637943912860\n"
+"help.text"
+msgid "<emph>%R2</emph> - The row number of the bottom right cell of the range."
+msgstr ""
+
+#. imuBD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id291637943913116\n"
+"help.text"
+msgid "<emph>%C2</emph> - The column letter of the bottom right cell of the range."
+msgstr ""
+
+#. gpmpG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941637943467476\n"
+"help.text"
+msgid "The example below extracts each element of the <literal>RangeName</literal> defined in <literal>sRange</literal> and uses them to compose a message."
+msgstr ""
+
+#. nbJ59
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id241637944350648\n"
+"help.text"
+msgid "The <literal>Printf</literal> method can be combined with <literal>SetFormula</literal> to create formulas over multiple cells. For instance, consider a table with numeric values in the range \"A1:E10\" from which formulas are to be created to sum the values in each row and place the results in the range \"F1:F10\":"
+msgstr ""
+
+#. foAvd
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id371637944971921\n"
+"help.text"
+msgid "' Note the use of the \"$\" character"
+msgstr ""
+
+#. wBpRw
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id156589200121138\n"
 "help.text"
-msgid "This method sends the content of the given sheet to a default printer or a printer defined by the <literal>SetPrinter()</literal> method of the <literal>Document</literal> Service."
+msgid "This method sends the contents of the given sheet to the default printer or to the printer defined by the <literal>SetPrinter</literal> method of the <literal>Document</literal> service."
 msgstr ""
 
 #. BaDL9
@@ -5821,13 +6091,13 @@ msgctxt ""
 msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
 msgstr ""
 
-#. i2Rtx
+#. DBFDA
 #: sf_calc.xhp
 msgctxt ""
 "sf_calc.xhp\n"
 "par_id141635436912146\n"
 "help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
 msgstr ""
 
 #. C8abL
@@ -6181,6 +6451,357 @@ msgctxt ""
 msgid "'D2 contains the formula \"=H2\""
 msgstr ""
 
+#. gF7Gb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880373070\n"
+"help.text"
+msgid "Moves a given range of cells downwards by inserting empty rows. The current selection is not affected."
+msgstr ""
+
+#. VTxxB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929435655\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholerows</literal> argument the inserted rows can either span the width of the specified range or span all columns in the row."
+msgstr ""
+
+#. uvH4j
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880370247\n"
+"help.text"
+msgid "This method returns a string representing the new location of the initial range."
+msgstr ""
+
+#. cvqws
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id811637929284110\n"
+"help.text"
+msgid "If the shifted range exceeds the sheet edges, then nothing happens."
+msgstr ""
+
+#. bUdZp
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376123\n"
+"help.text"
+msgid "<emph>range</emph>: The range above which rows will be inserted, as a string."
+msgstr ""
+
+#. fVYpB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880376566\n"
+"help.text"
+msgid "<emph>wholerow</emph>: If set to <literal>False</literal> (default), then the width of the inserted rows will be the same as the width of the specified <literal>range</literal>. Otherwise, the inserted row will span all columns in the sheet."
+msgstr ""
+
+#. rXzZX
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373045\n"
+"help.text"
+msgid "<emph>rows</emph>: The number of rows to be inserted. The default value is the height of the original <literal>range</literal>. The number of rows must be a positive number."
+msgstr ""
+
+#. dacHK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931053547\n"
+"help.text"
+msgid "' Moves the range \"A3:D3\" down by one row; affects only columns A to D"
+msgstr ""
+
+#. v4w3P
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232893\n"
+"help.text"
+msgid "' The inserted row spans all columns in the sheet"
+msgstr ""
+
+#. vsryg
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931053897\n"
+"help.text"
+msgid "' Moves the range \"A3:D3\" down by five rows"
+msgstr ""
+
+#. pwuUG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id501638218784265\n"
+"help.text"
+msgid "' Moves the range \"A3:D10\" down by two rows and shows the new location of the original range"
+msgstr ""
+
+#. hVfv3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880376255\n"
+"help.text"
+msgid "Deletes the leftmost columns of a given range and moves to the left all cells to the right of the affected range. The current selection is not affected."
+msgstr ""
+
+#. iawBn
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929460261\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholecolumns</literal> argument the deleted columns can either span the height of the specified range or span all rows in the column."
+msgstr ""
+
+#. BXEkG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880371259\n"
+"help.text"
+msgid "This method returns a string representing the location of the remaining portion of the initial range. If all cells in the original range have been deleted, then an empty string is returned."
+msgstr ""
+
+#. CyRpL
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376205\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which cells will be deleted, as a string."
+msgstr ""
+
+#. zWG3Y
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880356026\n"
+"help.text"
+msgid "<emph>wholecolumn</emph>: If set to <literal>False</literal> (default), then the height of the deleted columns will be the same as the height of the specified <literal>range</literal>. Otherwise, the deleted columns will span all rows in the sheet."
+msgstr ""
+
+#. JLdBr
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373306\n"
+"help.text"
+msgid "<emph>columns</emph>: The number of columns to be deleted from the specified <literal>range</literal>. The default value is the width of the original <literal>range</literal>, which is also the maximum value of this argument."
+msgstr ""
+
+#. 8UycD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931064919\n"
+"help.text"
+msgid "' Deletes the range \"B3:B6\"; moves left all cells to the right"
+msgstr ""
+
+#. vM8hB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931056991\n"
+"help.text"
+msgid "' Deletes the first column in the range \"A3:D6\""
+msgstr ""
+
+#. FPVSg
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232569\n"
+"help.text"
+msgid "' The deleted columns (A to D) spans all rows in the sheet"
+msgstr ""
+
+#. TAB2b
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880373529\n"
+"help.text"
+msgid "Deletes the topmost rows of a given range and moves upwards all cells below the affected range. The current selection is not affected."
+msgstr ""
+
+#. kb5h3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929435361\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholerows</literal> argument the deleted rows can either span the width of the specified range or span all columns in the row."
+msgstr ""
+
+#. s9Nfb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880370299\n"
+"help.text"
+msgid "This method returns a string representing the location of the remaining portion of the initial range. If all cells in the original range have been deleted, then an empty string is returned."
+msgstr ""
+
+#. H5EtV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376583\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which cells will be deleted, as a string."
+msgstr ""
+
+#. JQtGb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880300966\n"
+"help.text"
+msgid "<emph>wholerow</emph>: If set to <literal>False</literal> (default), then the width of the deleted rows will be the same as the width of the specified <literal>range</literal>. Otherwise, the deleted row will span all columns in the sheet."
+msgstr ""
+
+#. ueo8E
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373265\n"
+"help.text"
+msgid "<emph>rows</emph>: The number of rows to be deleted from the specified <literal>range</literal>. The default value is the height of the original <literal>range</literal>, which is also the maximum value of this argument."
+msgstr ""
+
+#. jHP9x
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931064667\n"
+"help.text"
+msgid "' Deletes the range \"A3:D3\"; moves all cells below it by one row up"
+msgstr ""
+
+#. Make5
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931056647\n"
+"help.text"
+msgid "' Deletes the first row in the range \"A3:D6\""
+msgstr ""
+
+#. APQKA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232493\n"
+"help.text"
+msgid "' The deleted rows spans all columns in the sheet"
+msgstr ""
+
+#. gKkbB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880372568\n"
+"help.text"
+msgid "Moves a given range of cells to the right by inserting empty columns. The current selection is not affected."
+msgstr ""
+
+#. RxvcF
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929335255\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholecolumns</literal> argument the inserted columns can either span the height of the specified range or span all rows in the column."
+msgstr ""
+
+#. Fh33o
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880372560\n"
+"help.text"
+msgid "This method returns a string representing the new location of the initial range."
+msgstr ""
+
+#. pLAHD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id811637929283210\n"
+"help.text"
+msgid "If the shifted range exceeds the sheet edges, then nothing happens."
+msgstr ""
+
+#. SeAGD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880370543\n"
+"help.text"
+msgid "<emph>range</emph>: The range which will have empty columns inserted to its left, as a string."
+msgstr ""
+
+#. KtD6Y
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880373316\n"
+"help.text"
+msgid "<emph>wholecolumn</emph>: If set to <literal>False</literal> (default), then the height of the inserted columns will be the same as the height of the specified <literal>range</literal>. Otherwise, the inserted columns will span all rows in the sheet."
+msgstr ""
+
+#. fBzCG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515938803791960\n"
+"help.text"
+msgid "<emph>columns</emph>: The number of columns to be inserted. The default value is the width of the original <literal>range</literal>."
+msgstr ""
+
+#. nmXTU
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931052587\n"
+"help.text"
+msgid "' Moves the range \"A3:A6\" right by one column; affects only rows 3 to 6"
+msgstr ""
+
+#. 5mWBq
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931053225\n"
+"help.text"
+msgid "' Moves the range \"A3:A6\" right by five columns"
+msgstr ""
+
+#. G53xT
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232548\n"
+"help.text"
+msgid "' The inserted column spans all rows in the sheet"
+msgstr ""
+
 #. FrC59
 #: sf_calc.xhp
 msgctxt ""
@@ -6523,13 +7144,13 @@ msgctxt ""
 msgid "Specifies if the chart is displayed with 3D elements. If the value is a string, it must be either \"Bar\", \"Cylinder\", \"Cone\" or \"Pyramid\"."
 msgstr ""
 
-#. aT4GF
+#. HgqhX
 #: sf_chart.xhp
 msgctxt ""
 "sf_chart.xhp\n"
 "par_id541600788076141\n"
 "help.text"
-msgid "If the boolean <literal>True</literal> value is specified, than the chart is displayed using 3D bars."
+msgid "If the boolean <literal>True</literal> value is specified, then the chart is displayed using 3D bars."
 msgstr ""
 
 #. vDs4z
@@ -6559,15 +7180,6 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. FVExu
-#: sf_chart.xhp
-msgctxt ""
-"sf_chart.xhp\n"
-"par_id201633021748455\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
 #. AaBHr
 #: sf_chart.xhp
 msgctxt ""
@@ -8521,6 +9133,60 @@ msgctxt ""
 msgid "This Python code displays <literal>DlgConvert</literal> modal dialog from <literal>Euro</literal> shared Basic library."
 msgstr ""
 
+#. HU6Jv
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id21598187900349\n"
+"help.text"
+msgid "Replaces all fixed text strings in a dialog by their translated versions based on a <literal>L10N</literal> service instance. This method translates the following strings:"
+msgstr ""
+
+#. JixXU
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id641625855723650\n"
+"help.text"
+msgid "The method returns <literal>True</literal> if successful."
+msgstr ""
+
+#. v5Zt5
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id61637871260604\n"
+"help.text"
+msgid "To create a list of translatable strings in a dialog use the <link href=\"text/sbasic/shared/03/sf_l10n.xhp#AddTextsFromDialog\" name=\"AddTextsFromDialog\">AddTextsFromDialog</link> method from the L10N service."
+msgstr ""
+
+#. ECNVg
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id451598185776205\n"
+"help.text"
+msgid "<emph>l10n</emph>: A <literal>L10N</literal> service instance from which translated strings will be retrieved."
+msgstr ""
+
+#. MeJAT
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id951620300689850\n"
+"help.text"
+msgid "The following example loads translated strings and applies them to the dialog \"MyDialog\"."
+msgstr ""
+
+#. p3KMX
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id901637872163895\n"
+"help.text"
+msgid "Read the <link href=\"text/sbasic/shared/03/sf_l10n.xhp\" name=\"L10N\">L10N service</link> help page to learn more about how PO and POT files are handled."
+msgstr ""
+
 #. ARCGg
 #: sf_dialog.xhp
 msgctxt ""
@@ -8953,13 +9619,13 @@ msgctxt ""
 msgid "Yes"
 msgstr ""
 
-#. LgGtA
+#. rDJFC
 #: sf_dialogcontrol.xhp
 msgctxt ""
 "sf_dialogcontrol.xhp\n"
 "par_id151598177605296\n"
 "help.text"
-msgid "Specifies the number of rows in a list box or a combo box."
+msgid "Specifies the number of rows in a ListBox, a ComboBox or a TableControl."
 msgstr ""
 
 #. kaaLt
@@ -8971,13 +9637,13 @@ msgctxt ""
 msgid "No"
 msgstr ""
 
-#. JAmaD
+#. Ey9iG
 #: sf_dialogcontrol.xhp
 msgctxt ""
 "sf_dialogcontrol.xhp\n"
 "par_id251588334016874\n"
 "help.text"
-msgid "Specifies which item is selected in a list box or combo box."
+msgid "Specifies which item is selected in a ListBox, a ComboBox or a TableControl."
 msgstr ""
 
 #. azv7C
@@ -9556,6 +10222,15 @@ msgctxt ""
 msgid "Must be within the predefined bounds"
 msgstr ""
 
+#. CVTcE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id441598543254951\n"
+"help.text"
+msgid "One-dimensional array with the data of the currently selected row."
+msgstr ""
+
 #. a9AMF
 #: sf_dialogcontrol.xhp
 msgctxt ""
@@ -10114,6 +10789,105 @@ msgctxt ""
 msgid "This method is often called from a dialog or control event."
 msgstr ""
 
+#. it2QN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id541638553960464\n"
+"help.text"
+msgid "Fills a <literal>TableControl</literal> with the given data. All preexisting data is cleared before inserting the new data passed as argument."
+msgstr ""
+
+#. Vmmag
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id551638554058131\n"
+"help.text"
+msgid "When the <literal>TableControl</literal> is added to the dialog, it is possible to use the Basic IDE to define whether column and row headers will be shown in the table. If the <literal>TableControl</literal> has column and/or row headers, the first column and/or row in the provided data array are used as labels for the table headers."
+msgstr ""
+
+#. qn4UN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id411638569396108\n"
+"help.text"
+msgid "This method returns <literal>True</literal> when successful."
+msgstr ""
+
+#. LESVB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257133\n"
+"help.text"
+msgid "<emph>dataarray</emph>: Data to be entered into the table represented as an Array of Arrays in Basic or a tuple of tuples in Python. The data must include column and row headers if they are to be displayed by the <literal>TableControl</literal>."
+msgstr ""
+
+#. 6AKaJ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257025\n"
+"help.text"
+msgid "<emph>widths</emph>: Array containing the relative widths of each column. In other words, <literal>widths = Array(1, 2)</literal> means that the second column is twice as wide as the first one. If the number of values in the array is smaller than the number of columns in the table, then the last value in the array is used to define the width of the remaining columns."
+msgstr ""
+
+#. AEGq3
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257007\n"
+"help.text"
+msgid "<emph>alignments</emph>: Defines the alignment in each column as a string in which each character can be \"L\" (Left), \"C\" (Center), \"R\" (Right) or \" \" (whitespace, default, meaning left for strings and right for numeric values). If the length of the string is shorter than the number of columns in the table, then the last character in the string is used to define the alignment of the remaining columns."
+msgstr ""
+
+#. FCNEg
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id381638569172413\n"
+"help.text"
+msgid "The following example assumes that the dialog <literal>myDialog</literal> has a <literal>TableControl</literal> named <literal>Grid1</literal> with \"Show header row\" and \"Show column row\" properties set to \"Yes\"."
+msgstr ""
+
+#. N9Byz
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id171638650502346\n"
+"help.text"
+msgid "The <literal>Value</literal> property returns the selected row in the table. If no row is selected, an empty Array object is returned. The following code snippet shows how to test if any row is selected in the table."
+msgstr ""
+
+#. C3f3k
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id361638651540588\n"
+"help.text"
+msgid "MsgBox \"No row selected.\""
+msgstr ""
+
+#. iQ94A
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id781638651541028\n"
+"help.text"
+msgid "MsgBox \"Row \" & oTable.ListIndex & \" is selected.\""
+msgstr ""
+
+#. yyATt
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id111638569958471\n"
+"help.text"
+msgid "dlg = CreateScriptService(\"Dialog\", \"GlobalScope\", \"Standard\", \"myDialog\")"
+msgstr ""
+
 #. HNmmm
 #: sf_dialogcontrol.xhp
 msgctxt ""
@@ -11311,13 +12085,103 @@ msgctxt ""
 msgid "<emph>saveask</emph> : If <literal>True</literal> (default), the user is invited to confirm if the changes should be written on disk. This argument is ignored if the document was not modified."
 msgstr ""
 
-#. wvxcZ
+#. CGKZA
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id156589200123048\n"
+"help.text"
+msgid "Exports the document directly as a PDF file to the specified location. Returns <literal>True</literal> if the PDF file was successfully created."
+msgstr ""
+
+#. PBk4E
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id811638276067119\n"
+"help.text"
+msgid "The export options can be set either manually using the <menuitem>File - Export As - Export as PDF</menuitem> dialog or by calling the methods <literal>GetPDFExportOptions</literal> and <literal>SetPDFExportOptions</literal> from the <link href=\"text/sbasic/shared/03/sf_session.xhp\" name=\"SFSession\">Session</link> service."
+msgstr ""
+
+#. SFwEd
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id211635436910641\n"
+"help.text"
+msgid "<emph>filename</emph>: The full path and file name of the PDF to be created. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgstr ""
+
+#. E6KyY
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436912005\n"
+"help.text"
+msgid "<emph>overwrite</emph>: Specifies if the destination file can be overwritten (Default = <literal>False</literal>). An error will occur if <literal>overwrite</literal> is set to <literal>False</literal> and the destination file already exists."
+msgstr ""
+
+#. d9RRn
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436913587\n"
+"help.text"
+msgid "<emph>pages</emph><emph/>: String specifying which pages will be exported. This argument uses the same notation as in the dialog <menuitem>File - Export As - Export as PDF</menuitem>."
+msgstr ""
+
+#. kBDPk
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436919655\n"
+"help.text"
+msgid "<emph>password</emph><emph/>: Specifies a password to open the PDF file."
+msgstr ""
+
+#. joeXi
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436913365\n"
+"help.text"
+msgid "<emph>watermark</emph>: Text to be used as watermark in the PDF file, which will be drawn in every page of the resulting PDF."
+msgstr ""
+
+#. NmChF
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id301638234284727\n"
+"help.text"
+msgid "The following example exports the current document as a PDF file, defines a password and overwrites the destination file if it already exists."
+msgstr ""
+
+#. wEW7B
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id311638276257020\n"
+"help.text"
+msgid "The code snippet below gets the current PDF export options and uses them to create the PDF file."
+msgstr ""
+
+#. 7uUWr
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"bas_id851638277174798\n"
+"help.text"
+msgid "' Sets to True the option to export comments as PDF notes"
+msgstr ""
+
+#. HNC9m
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id156589200121138\n"
 "help.text"
-msgid "This method sends the content of the document to a default printer or a printer defined by the <literal>SetPrinter</literal> method."
+msgid "This method sends the contents of the document to the default printer or to the printer defined by the <literal>SetPrinter</literal> method."
 msgstr ""
 
 #. CJxTR
@@ -11338,13 +12202,13 @@ msgctxt ""
 msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
 msgstr ""
 
-#. eD7LB
+#. EHtFi
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id141635436912146\n"
 "help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
 msgstr ""
 
 #. Nmwv9
@@ -11392,13 +12256,13 @@ msgctxt ""
 msgid "The following example runs the \"SelectData\" command in a Calc sheet named \"MyFile.ods\", which will result in the selection of the data area based on the currently selected cell."
 msgstr ""
 
-#. pbYAn
+#. avaEg
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id751611153375195\n"
 "help.text"
-msgid "The example above actually runs the UNO command <literal>uno:SelectData</literal>. Hence, to use the <literal>RunCommand</literal> method it is necessary to remove the \"uno:\" substring."
+msgid "The example above actually runs the UNO command <literal>.uno:SelectData</literal>. Hence, to use the <literal>RunCommand</literal> method it is necessary to remove the \".uno:\" substring."
 msgstr ""
 
 #. JRHRS
@@ -11617,13 +12481,13 @@ msgctxt ""
 msgid "<emph>orientation</emph>: Either <literal>PORTRAIT</literal> or <literal>LANDSCAPE</literal>. When absent, left unchanged with respect to the printer settings."
 msgstr ""
 
-#. H2EDf
+#. ENyZH
 #: sf_document.xhp
 msgctxt ""
 "sf_document.xhp\n"
 "par_id821985205147330\n"
 "help.text"
-msgid "<emph>paperformat</emph>: One of the following string values <literal>A3</literal>, <literal>A4</literal>, <literal>A5</literal>, <literal>LETTER</literal>, <literal>LEGAL</literal>, <literal>TABLOID</literal>. Left unchanged when absent."
+msgid "<emph>paperformat</emph>: Specifies the paper format as a string value that can be either <literal>A3</literal>, <literal>A4</literal>, <literal>A5</literal>, <literal>LETTER</literal>, <literal>LEGAL</literal> or <literal>TABLOID</literal>. Left unchanged when absent."
 msgstr ""
 
 #. WCH7E
@@ -16792,13 +17656,13 @@ msgctxt ""
 msgid "The first example reads the current value in a ComboBox containing city names and writes it to a FixedTest control in a Form:"
 msgstr ""
 
-#. B5QLA
+#. 3eh6E
 #: sf_formcontrol.xhp
 msgctxt ""
 "sf_formcontrol.xhp\n"
 "pyc_id991622562833004\n"
 "help.text"
-msgid "ui = CreateScriptService('ScriptForge.Basic')  # Basic-like methods"
+msgid "bas = CreateScriptService('ScriptForge.Basic')  # Basic-like methods"
 msgstr ""
 
 #. 8jneo
@@ -16828,22 +17692,22 @@ msgctxt ""
 msgid "MsgBox \"Selected option: \" & optControl.Caption"
 msgstr ""
 
-#. kxKPM
+#. YnBgM
 #: sf_formcontrol.xhp
 msgctxt ""
 "sf_formcontrol.xhp\n"
 "pyc_id991622562822004\n"
 "help.text"
-msgid "ui = CreateScriptService('ScriptForge.Basic')  # Basic-like methods"
+msgid "bas = CreateScriptService('ScriptForge.Basic')  # Basic-like methods"
 msgstr ""
 
-#. QBAvs
+#. TNTT9
 #: sf_formcontrol.xhp
 msgctxt ""
 "sf_formcontrol.xhp\n"
 "pyc_id441622562080419\n"
 "help.text"
-msgid "ui.MsgBox('Selected option: ' + control.Caption)"
+msgid "bas.MsgBox('Selected option: ' + control.Caption)"
 msgstr ""
 
 #. czP76
@@ -17467,13 +18331,13 @@ msgctxt ""
 msgid "The <literal>L10N</literal> service is based on the GNU implementation of PO (portable object) files. To learn more about this file format, visit <link href=\"https://www.gnu.org/software/gettext/manual/html_node/PO-Files.html\" name=\"GetText\">GNU gettext Utilities: PO Files</link>."
 msgstr ""
 
-#. 4CMir
+#. DGiG9
 #: sf_l10n.xhp
 msgctxt ""
 "sf_l10n.xhp\n"
 "par_id91585843652832\n"
 "help.text"
-msgid "This service implements the three methods listed below:"
+msgid "This service implements the methods listed below:"
 msgstr ""
 
 #. fBXDW
@@ -17485,6 +18349,15 @@ msgctxt ""
 msgid "<emph>AddText</emph>: Used by the programmer to build a set of strings that will be translated later."
 msgstr ""
 
+#. BtuQ3
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id81637866601151\n"
+"help.text"
+msgid "<emph>AddTextsFromDialog</emph>: Extracts all strings from a <literal>Dialog</literal> service instance."
+msgstr ""
+
 #. cm7fq
 #: sf_l10n.xhp
 msgctxt ""
@@ -17791,6 +18664,96 @@ msgctxt ""
 msgid "The example below creates a set of strings in English:"
 msgstr ""
 
+#. rWt7U
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id1001585843659821\n"
+"help.text"
+msgid "Automatically extracts strings from a dialog and adds them to the list of localizable text strings. The following strings are extracted:"
+msgstr ""
+
+#. bS7ZL
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id621637863440015\n"
+"help.text"
+msgid "The title of the dialog."
+msgstr ""
+
+#. EBFAC
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id61637863440399\n"
+"help.text"
+msgid "The caption of the following control types: Button, CheckBox, FixedLine, FixedText, GroupBox and RadioButton."
+msgstr ""
+
+#. uCL85
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id251637863440626\n"
+"help.text"
+msgid "Static strings in ListBoxes and ComboBoxes."
+msgstr ""
+
+#. HWkAU
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id811637863596791\n"
+"help.text"
+msgid "The tooltip or help text displayed when the mouse hovers over the control."
+msgstr ""
+
+#. gKbEN
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id641625855723650\n"
+"help.text"
+msgid "The method returns <literal>True</literal> if successful."
+msgstr ""
+
+#. Kcowa
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id731637863894577\n"
+"help.text"
+msgid "The dialog from which strings will be extracted must not be open when the method is called."
+msgstr ""
+
+#. 75EGY
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id911637864050221\n"
+"help.text"
+msgid "When a <literal>L10N</literal> service instance is created from an existing PO file, use the <link href=\"text/sbasic/shared/03/sf_dialog.xhp#GetTextsFromL10N\" name=\"GetTextsFromL10N\">GetTextsFromL10N</link> method from the <literal>Dialog</literal> service to automatically load all translated strings into the dialog."
+msgstr ""
+
+#. ejhbN
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id391585843652113\n"
+"help.text"
+msgid "<emph>dialog</emph>: a Dialog service instance corresponding to the dialog from which strings will be extracted."
+msgstr ""
+
+#. QzWzG
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id461614364298983\n"
+"help.text"
+msgid "The following example extracts all strings from the dialog \"MyDialog\" stored in the \"Standard\" library and exports them to a POT file:"
+msgstr ""
+
 #. DqFBf
 #: sf_l10n.xhp
 msgctxt ""
@@ -18952,15 +19915,6 @@ msgctxt ""
 msgid "The example below uses the icon \"sc_newdoc.svg\" that is located inside the \"cmd\" folder. The forward slash \"/\" character is used as the path separator regardless of the operating system."
 msgstr ""
 
-#. HReGj
-#: sf_popupmenu.xhp
-msgctxt ""
-"sf_popupmenu.xhp\n"
-"bas_id121636725026678\n"
-"help.text"
-msgid "myPopup.AddItem(\"Item A\", Icon := \"cmd/sc_newdoc.svg\")"
-msgstr ""
-
 #. 2QW4m
 #: sf_popupmenu.xhp
 msgctxt ""
@@ -19834,6 +20788,42 @@ msgctxt ""
 msgid "The following examples show how to call the function <literal>odd_integers</literal> from within Basic and Python scripts."
 msgstr ""
 
+#. pbmij
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id111582816585087\n"
+"help.text"
+msgid "Returns the current PDF export settings defined in the <menuitem>PDF Options</menuitem> dialog, which can be accessed by choosing <menuitem>File - Export as - Export as PDF</menuitem>."
+msgstr ""
+
+#. K7j2q
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id931638383270026\n"
+"help.text"
+msgid "Export options set with the <menuitem>PDF Options</menuitem> dialog are kept for future use. Hence <literal>GetPDFExportOptions</literal> returns the settings currently defined. In addition, use <literal>SetPDFExportOptions</literal> to change current PDF export options."
+msgstr ""
+
+#. uFCEq
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id801638383659558\n"
+"help.text"
+msgid "This method returns a <literal>Dictionary</literal> object wherein each key represent export options and the corresponding values are the current PDF export settings."
+msgstr ""
+
+#. 6kXBe
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id751638383457198\n"
+"help.text"
+msgid "Read the <link href=\"https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export\" name=\"PDFExport_Wiki\">PDF Export wiki page</link> to learn more about all available options."
+msgstr ""
+
 #. Lv4iA
 #: sf_session.xhp
 msgctxt ""
@@ -20005,6 +20995,60 @@ msgctxt ""
 msgid "<emph>editmessage</emph>: When <literal>True</literal> (default), the message is edited before being sent."
 msgstr ""
 
+#. g7zLC
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id111582816583005\n"
+"help.text"
+msgid "Modifies the PDF export settings defined in the <menuitem>PDF Options</menuitem> dialog, which can be accessed by choosing <menuitem>File - Export as - Export as PDF</menuitem>."
+msgstr ""
+
+#. T2DkW
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id181638385131806\n"
+"help.text"
+msgid "Calling this method changes the actual values set in the <menuitem>PDF Options</menuitem> dialog, which are used by the <literal>ExportAsPDF</literal> method from the <literal>Document</literal> service."
+msgstr ""
+
+#. FBrKg
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id391638385313847\n"
+"help.text"
+msgid "This method returns <literal>True</literal> when successful."
+msgstr ""
+
+#. 9BqH3
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id751638383457321\n"
+"help.text"
+msgid "Read the <link href=\"https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export\" name=\"PDFExport_Wiki\">PDF Export wiki page</link> to learn more about all available options."
+msgstr ""
+
+#. JhhXU
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id771582816585233\n"
+"help.text"
+msgid "<emph>pdfoptions</emph>: <literal>Dictionary</literal> object that defines the PDF export settings to be changed. Each key-value pair represents an export option and the value that will be set in the dialog."
+msgstr ""
+
+#. 8DKZK
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id141638386087986\n"
+"help.text"
+msgid "The following example changes the maximum image resolution to 150 dpi and exports the current document as a PDF file."
+msgstr ""
+
 #. HtzHP
 #: sf_session.xhp
 msgctxt ""
@@ -24352,13 +25396,13 @@ msgctxt ""
 msgid "In the following examples, the first line gets the names of all forms in the document and the second line retrieves the <literal>Form</literal> object of the form named \"Form_A\"."
 msgstr ""
 
-#. S5MwC
+#. y684J
 #: sf_writer.xhp
 msgctxt ""
 "sf_writer.xhp\n"
 "par_id31592919577984\n"
 "help.text"
-msgid "Send the content of the document to the printer. The printer might be defined previously by default, by the user or by the <link href=\"text/sbasic/03/sf_document.xhp#SetPrinter\" name=\"SetPrinter method\"><literal>SetPrinter()</literal></link> method of the <link href=\"text/sbasic/03/sf_document.xhp\" name=\"Document service\">Document</link> service. Returns <literal>True</literal> when successful."
+msgid "Send the contents of the document to the printer. The printer may be previously defined by default, by the user or by the <link href=\"text/sbasic/03/sf_document.xhp#SetPrinter\" name=\"SetPrinter method\"><literal>SetPrinter</literal></link> method of the <link href=\"text/sbasic/03/sf_document.xhp\" name=\"Document service\">Document</link> service. Returns <literal>True</literal> when successful."
 msgstr ""
 
 #. CKDb5