aboutsummaryrefslogtreecommitdiff
path: root/source/pt/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-05-31 16:27:05 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-05-31 16:31:43 +0200
commit387ea1005f554dadedc7073e947bbd93dfa38c25 (patch)
tree612159922b977ccf3b51ad8bfdf8780efd5099a4 /source/pt/helpcontent2
parent48ffdf216a07738135223c4f95e9f942be8a5dd9 (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I5a54db2572738c26858f69eba71239fa9474f0a4
Diffstat (limited to 'source/pt/helpcontent2')
-rw-r--r--source/pt/helpcontent2/source/text/sbasic/guide.po28
-rw-r--r--source/pt/helpcontent2/source/text/sbasic/shared.po65
-rw-r--r--source/pt/helpcontent2/source/text/sbasic/shared/03.po1118
-rw-r--r--source/pt/helpcontent2/source/text/scalc/01.po2849
-rw-r--r--source/pt/helpcontent2/source/text/scalc/guide.po8
-rw-r--r--source/pt/helpcontent2/source/text/shared/01.po38
-rw-r--r--source/pt/helpcontent2/source/text/shared/06.po8
7 files changed, 2948 insertions, 1166 deletions
diff --git a/source/pt/helpcontent2/source/text/sbasic/guide.po b/source/pt/helpcontent2/source/text/sbasic/guide.po
index 0ace85354a0..e9f9fcdb708 100644
--- a/source/pt/helpcontent2/source/text/sbasic/guide.po
+++ b/source/pt/helpcontent2/source/text/sbasic/guide.po
@@ -4,7 +4,7 @@ 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: 2019-11-08 19:34+0100\n"
-"PO-Revision-Date: 2021-04-25 08:37+0000\n"
+"PO-Revision-Date: 2021-05-25 14:37+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicguide/pt/>\n"
"Language: pt\n"
@@ -554,7 +554,7 @@ msgctxt ""
"N0551\n"
"help.text"
msgid "%PRODUCTNAME embedded Python contains many standard libraries to benefit from. They bear a rich feature set, such as but not limited to:"
-msgstr ""
+msgstr "O Python incluso no %PRODUCTNAME contém muitas bibliotecas padrão. Disponibilizam um vasto conjunto de funcionalidades, tais como mas não limitados a:"
#. aPbV7
#: basic_2_python.xhp
@@ -563,7 +563,7 @@ msgctxt ""
"N0552\n"
"help.text"
msgid "<emph>argparse</emph> Parser for command-line options, arguments and sub-commands"
-msgstr ""
+msgstr "<emph>argparse</emph> Analisador de opções da linha de comando, argumentos e subcomandos"
#. zBD3c
#: basic_2_python.xhp
@@ -572,7 +572,7 @@ msgctxt ""
"N0553\n"
"help.text"
msgid "<emph>cmath</emph> Mathematical functions for complex numbers"
-msgstr ""
+msgstr "<emph>cmath</emph> Funções matemáticas para números complexos"
#. GDXVa
#: basic_2_python.xhp
@@ -581,7 +581,7 @@ msgctxt ""
"N0554\n"
"help.text"
msgid "<emph>csv</emph> CSV files reading and writing"
-msgstr ""
+msgstr "<emph>csv</emph> Leitura e gravação de ficheiros CSV"
#. FnCu8
#: basic_2_python.xhp
@@ -590,7 +590,7 @@ msgctxt ""
"N0555\n"
"help.text"
msgid "<emph>datetime</emph> Genuine date and time types"
-msgstr ""
+msgstr "<emph>datetime</emph> Tipos de data e hora genuínos"
#. GQCwa
#: basic_2_python.xhp
@@ -599,7 +599,7 @@ msgctxt ""
"N0556\n"
"help.text"
msgid "<emph>json</emph> JSON encoder and decoder"
-msgstr ""
+msgstr "<emph>json</emph> Codificador e descodificador JSON"
#. JmFZK
#: basic_2_python.xhp
@@ -608,7 +608,7 @@ msgctxt ""
"N0557\n"
"help.text"
msgid "<emph>math</emph> Mathematical functions"
-msgstr ""
+msgstr "<emph>math</emph> Funções matemáticas"
#. PRGHi
#: basic_2_python.xhp
@@ -617,7 +617,7 @@ msgctxt ""
"N0558\n"
"help.text"
msgid "<emph>re</emph> Regular expression operations"
-msgstr ""
+msgstr "<emph>re</emph> Operações com expressões regulares"
#. XVbzW
#: basic_2_python.xhp
@@ -626,7 +626,7 @@ msgctxt ""
"N0559\n"
"help.text"
msgid "<emph>socket</emph> Low-level networking interface"
-msgstr ""
+msgstr "<emph>socket</emph> Interface de rede de baixo nível"
#. VehtJ
#: basic_2_python.xhp
@@ -635,7 +635,7 @@ msgctxt ""
"N0560\n"
"help.text"
msgid "<emph>sys</emph> System-specific parameters and functions"
-msgstr ""
+msgstr "<emph>sys</emph> Parâmetros e funções específicos do sistema"
#. RWzWY
#: basic_2_python.xhp
@@ -644,7 +644,7 @@ msgctxt ""
"N0561\n"
"help.text"
msgid "<emph>unittest</emph> and <emph>trace</emph> Unit testing framework and Track Python execution"
-msgstr ""
+msgstr "<emph>unittest</emph> e <emph>trace</emph> Estrutura de unidades de teste e de execução Python"
#. JG3VZ
#: basic_2_python.xhp
@@ -653,7 +653,7 @@ msgctxt ""
"N0562\n"
"help.text"
msgid "<emph>xml.etree.ElementTree</emph> ElementTree XML API"
-msgstr ""
+msgstr "<emph>xml.etree.ElementTree</emph> API de XML ElementTree"
#. CwBFN
#: basic_examples.xhp
@@ -770,7 +770,7 @@ msgctxt ""
"par_id3150447\n"
"help.text"
msgid "Enter a name for the dialog and click <emph>OK</emph>. To rename the dialog later, right-click the name on the tab and choose <emph>Rename</emph>."
-msgstr ""
+msgstr "Introduza um nome para a caixa de diálogo e clique em <emph>Aceitar</emph>. Para, mais tarde, mudar o nome de uma caixa de diálogo, clique no nome do separador com o botão direito do rato e escolha <emph>Mudar nome</emph>."
#. qFeYH
#: create_dialog.xhp
diff --git a/source/pt/helpcontent2/source/text/sbasic/shared.po b/source/pt/helpcontent2/source/text/sbasic/shared.po
index a24e867e89d..d954738beb3 100644
--- a/source/pt/helpcontent2/source/text/sbasic/shared.po
+++ b/source/pt/helpcontent2/source/text/sbasic/shared.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-05-14 14:15+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2020-08-19 18:35+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/pt/>\n"
@@ -610,6 +610,51 @@ msgctxt ""
msgid "<variable id=\"functexample\">Example:</variable>"
msgstr "<variable id=\"functexample\">Exemplo:</variable>"
+#. 3aa4B
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"hd_id191620312698501\n"
+"help.text"
+msgid "In Basic"
+msgstr ""
+
+#. BenDd
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"hd_id831620312769993\n"
+"help.text"
+msgid "In Python"
+msgstr ""
+
+#. AuYyY
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id701621038131185\n"
+"help.text"
+msgid "This method is only available for <emph>Basic</emph> scripts."
+msgstr ""
+
+#. Kk2av
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id701621038131336\n"
+"help.text"
+msgid "This method is only available for <emph>Python</emph> scripts."
+msgstr ""
+
+#. FMxTn
+#: 00000003.xhp
+msgctxt ""
+"00000003.xhp\n"
+"par_id81621427048241\n"
+"help.text"
+msgid "This method requires the installation of the <link href=\"https://extensions.libreoffice.org/en/extensions/show/apso-alternative-script-organizer-for-python\" name=\"APSO Link\">APSO (Alternative Script Organizer for Python)</link> extension. If it is not installed, an error will occur."
+msgstr ""
+
#. TV2YL
#: 00000003.xhp
msgctxt ""
@@ -11167,6 +11212,15 @@ msgctxt ""
msgid "Some DOS-specific file and directory functions are no longer provided in %PRODUCTNAME, or their function is only limited. For example, support for the <literal>ChDir</literal>, <literal>ChDrive</literal> and <literal>CurDir</literal> functions is not provided. Some DOS-specific properties are no longer used in functions that expect file properties as parameters (for example, to differentiate from concealed files and system files). This ensures the greatest possible level of platform independence for %PRODUCTNAME. Therefore this feature is subject to removal in a future release."
msgstr ""
+#. EQYDk
+#: 03020401.xhp
+msgctxt ""
+"03020401.xhp\n"
+"par_id321620859565917\n"
+"help.text"
+msgid "The <link href=\"text/sbasic/shared/03/lib_ScriptForge.xhp\" name=\"SF_Lib\">ScriptForge</link> library in %PRODUCTNAME 7.1 introduces the <link href=\"text/sbasic/shared/03/sf_filesystem.xhp\" name=\"FileSystem_Service\">FileSystem</link> service with methods to handle files and folders in user scripts."
+msgstr ""
+
#. WXPPp
#: 03020401.xhp
msgctxt ""
@@ -11230,15 +11284,6 @@ msgctxt ""
msgid "Changes the current drive."
msgstr "Altera a unidade atual."
-#. rkzEY
-#: 03020402.xhp
-msgctxt ""
-"03020402.xhp\n"
-"par_id3154685\n"
-"help.text"
-msgid "ChDrive Text As String"
-msgstr "ChDrive Texto As String"
-
#. ncuAv
#: 03020402.xhp
msgctxt ""
diff --git a/source/pt/helpcontent2/source/text/sbasic/shared/03.po b/source/pt/helpcontent2/source/text/sbasic/shared/03.po
index 68b8c4b67bb..6760db4d2b3 100644
--- a/source/pt/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/pt/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-05-14 14:15+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2021-01-16 21:44+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textsbasicshared03/pt/>\n"
@@ -3499,22 +3499,22 @@ msgctxt ""
msgid "<variable id=\"CalcService\"><link href=\"text/sbasic/shared/03/sf_calc.xhp\" name=\"Calc service\"><literal>SFDocuments</literal>.<literal>Calc</literal> service</link></variable>"
msgstr ""
-#. DLwen
+#. DGXCA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id381589189355849\n"
"help.text"
-msgid "The <literal>SFDocuments</literal> library provides a number of methods and properties to facilitate the management and handling of LibreOffice Calc documents."
+msgid "The <literal>SFDocuments</literal> library provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME Calc documents."
msgstr ""
-#. ts5ZW
+#. m4FFE
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591014177269\n"
"help.text"
-msgid "Some methods are generic for all types of documents and are inherited from the <literal>SF_Document</literal> service, whereas other methods are specific for the <literal>SF_Calc</literal> module."
+msgid "Some methods are generic for all types of documents and are inherited from the <literal>Document</literal> service, whereas other methods are specific for the <literal>SF_Calc</literal> module."
msgstr ""
#. kTVJM
@@ -3562,49 +3562,58 @@ msgctxt ""
msgid "Service invocation"
msgstr ""
-#. DLSfC
+#. z3JcW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"par_id141610734722352\n"
+"par_id591589191059889\n"
"help.text"
-msgid "Before using the <literal>Calc</literal> service the <literal>ScriptForge</literal> library needs to be loaded using:"
+msgid "The <literal>Calc</literal> service is closely related to the <literal>UI</literal> service of the <literal>ScriptForge</literal> library. Below are a few examples of how the <literal>Calc</literal> service can be invoked."
msgstr ""
-#. z3JcW
+#. mKqEu
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"par_id591589191059889\n"
+"par_id551621623999947\n"
"help.text"
-msgid "The <literal>Calc</literal> service is closely related to the <literal>UI</literal> service of the <literal>ScriptForge</literal> library. Below are a few examples of how the <literal>Calc</literal> service can be invoked."
+msgid "The code snippet below creates a <literal>Calc</literal> service instance that corresponds to the currently active Calc document."
msgstr ""
-#. zNhLz
+#. gECrc
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id571589191739218\n"
+"par_id341621467500466\n"
"help.text"
-msgid "'1) From the ScriptForge.UI service:"
+msgid "Another way to create an instance of the <literal>Calc</literal> service is using the <literal>UI</literal> service. In the following example, a new Calc document is created and <literal>oDoc</literal> is a <literal>Calc</literal> service instance:"
msgstr ""
-#. BhvuW
+#. x6qdq
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id331589191766531\n"
+"par_id921621467621019\n"
"help.text"
-msgid "'Or: Set oDoc = ui.OpenDocument(\"C:\\Me\\MyFile.ods\")"
+msgid "Or using the <literal>OpenDocument</literal> method from the <literal>UI</literal> service:"
msgstr ""
-#. GZXJG
+#. MDxMC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id571589191774268\n"
+"par_id741621467697967\n"
"help.text"
-msgid "'2) Directly if the document is already open"
+msgid "It is also possible to instantiate the <literal>Calc</literal> service using the <literal>CreateScriptService</literal> method:"
+msgstr ""
+
+#. CKafD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id271621467810774\n"
+"help.text"
+msgid "In the example above, \"MyFile.ods\" is the name of an open document window. If this argument is not provided, the active window is considered."
msgstr ""
#. gfpHw
@@ -3715,13 +3724,13 @@ msgctxt ""
msgid "Either a string designating a set of contiguous cells located in a sheet of the current instance or an <literal>object</literal> produced by the <literal>.Range</literal> property."
msgstr ""
-#. YTCe8
+#. 6CySa
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id691591020711395\n"
"help.text"
-msgid "The shortcut \"~\" (tilde) represents the current selection or the first range if multiple ranges are selected."
+msgid "The shortcut \"~\" (tilde) represents the current selection or the first selected range if multiple ranges are selected."
msgstr ""
#. 7JEat
@@ -4327,13 +4336,13 @@ msgctxt ""
msgid "If the argument <literal>SheetName</literal> is provided, the given sheet is activated and it becomes the currently selected sheet. If the argument is absent, then the document window is activated."
msgstr ""
-#. GwCLE
+#. EhMzz
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id821591631203996\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be activated in the document."
+msgid "<emph>sheetname</emph>: The name of the sheet to be activated in the document. The default value is an empty string, meaning that the document window will be activated without changing the active sheet."
msgstr ""
#. 2cgiA
@@ -4363,13 +4372,13 @@ msgctxt ""
msgid "Clears all the contents and formats of the given range."
msgstr ""
-#. rAvDo
+#. M5PqA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id441592919577809\n"
"help.text"
-msgid "<emph>Range</emph> : The range to be cleared, as a string."
+msgid "<emph>range</emph>: The range to be cleared, as a string."
msgstr ""
#. Wz6CH
@@ -4381,13 +4390,13 @@ msgctxt ""
msgid "Clears the formats and styles in the given range."
msgstr ""
-#. uCqaF
+#. 6Qxnv
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id611592919864268\n"
"help.text"
-msgid "<emph>Range</emph> : The range whose formats and styles are to be cleared, as a string."
+msgid "<emph>range</emph>: The range whose formats and styles are to be cleared, as a string."
msgstr ""
#. sMwMp
@@ -4399,13 +4408,13 @@ msgctxt ""
msgid "Clears the values and formulas in the given range."
msgstr ""
-#. Cx3CM
+#. eEGn9
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id771592919928320\n"
"help.text"
-msgid "<emph>Range</emph> : The range whose values and formulas are to be cleared, as a string."
+msgid "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string."
msgstr ""
#. n6vJD
@@ -4417,31 +4426,31 @@ msgctxt ""
msgid "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful."
msgstr ""
-#. Di3Hd
+#. YqGL2
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id871591631693741\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be copied as a string or its reference as an object."
+msgid "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object."
msgstr ""
-#. azG6n
+#. 5cEGG
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591632126180\n"
"help.text"
-msgid "<emph>NewName</emph> : The name of the sheet to insert. The name must not be in use in the document."
+msgid "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document."
msgstr ""
-#. XDAoM
+#. 8sSno
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211591632192379\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
msgstr ""
#. yuvEn
@@ -4498,40 +4507,40 @@ msgctxt ""
msgid "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet."
msgstr ""
-#. BbR9B
+#. tCseT
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id471591714947181\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password."
msgstr ""
-#. FG6BQ
+#. gHjz6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id9915917146142\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to be copied as a string."
+msgid "<emph>sheetname</emph>: The name of the sheet to be copied as a string."
msgstr ""
-#. vNK3G
+#. PeZ4F
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id71591714614904\n"
"help.text"
-msgid "<emph>NewName</emph> : The name of the copied sheet to be inserted in the document. The name must not be in use in the document."
+msgid "<emph>newname</emph>: The name of the copied sheet to be inserted in the document. The name must not be in use in the document."
msgstr ""
-#. 4UmRW
+#. 2niVz
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id601591714614407\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position."
msgstr ""
#. iEHJy
@@ -4570,22 +4579,22 @@ msgctxt ""
msgid "The source range may belong to another <emph>open</emph> document."
msgstr ""
-#. 6BKth
+#. RBQG9
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id761592558768578\n"
"help.text"
-msgid "<emph>SourceRange</emph> : The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
+msgid "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
msgstr ""
-#. vsAZV
+#. 3MUwk
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id711592558768466\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered."
msgstr ""
#. FbkjF
@@ -4678,49 +4687,58 @@ msgctxt ""
msgid "The source range may belong to another <emph>open</emph> document."
msgstr ""
-#. Tv5So
+#. CEaED
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id841592903121145\n"
"help.text"
-msgid "<emph>SourceRange</emph> : The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
+msgid "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document."
msgstr ""
-#. K5ANF
+#. v3d3d
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id5515929031211000\n"
"help.text"
-msgid "<emph>DestinationRange</emph> : The destination of the copied range of cells, as a string."
+msgid "<emph>destinationrange</emph>: The destination of the copied range of cells, as a string."
msgstr ""
-#. SzA83
+#. LsHF6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id461592905128991\n"
"help.text"
-msgid "Copy within the same document :"
+msgid "Copy within the same document:"
msgstr ""
-#. GtG3C
+#. dNdmJ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"bas_id601592904507182\n"
"help.text"
-msgid "'Returned range: $SheetY.$C$5:$J$14"
+msgid "' Returns a range string: \"$SheetY.$C$5:$J$14\""
msgstr ""
-#. RXkyV
+#. FBbwi
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id1001592905195364\n"
"help.text"
-msgid "Copy from one file to another :"
+msgid "Copy from one file to another:"
+msgstr ""
+
+#. 2fvZe
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"pyc_id761621538667290\n"
+"help.text"
+msgid "doc.CopyToRange(\"SheetX.A1:F10\", \"SheetY.C5:J5\")"
msgstr ""
#. so8uw
@@ -4732,13 +4750,13 @@ msgctxt ""
msgid "Apply the functions Average, Count, Max, Min and Sum, respectively, to all the cells containing numeric values on a given range."
msgstr ""
-#. fPXvC
+#. F2UTC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id741595777001537\n"
"help.text"
-msgid "<emph>Range</emph> : The range to which the function will be applied, as a string."
+msgid "<emph>range</emph>: The range to which the function will be applied, as a string."
msgstr ""
#. ZhAYY
@@ -4768,22 +4786,22 @@ msgctxt ""
msgid "Converts a column number ranging between 1 and 1024 into its corresponding letter (column 'A', 'B', ..., 'AMJ'). If the given column number is outside the allowed range, a zero-length string is returned."
msgstr ""
-#. gUDC3
+#. EfsXe
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id83159163272628\n"
"help.text"
-msgid "<emph>ColumnNumber</emph> : The column number as an integer value in the interval 1 ... 1024."
+msgid "<emph>columnnumber</emph>: The column number as an integer value in the interval 1 ... 1024."
msgstr ""
-#. yDnhD
+#. 6yjtp
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
-"bas_id391611754462421\n"
+"par_id11621539831303\n"
"help.text"
-msgid "'Shows a message box with the string \"C\""
+msgid "Displays a message box with the name of the third column, which by default is \"C\"."
msgstr ""
#. XNAhU
@@ -4804,13 +4822,13 @@ msgctxt ""
msgid "Get the formula(s) stored in the given range of cells as a single string, a 1D or a 2D array of strings."
msgstr ""
-#. RG8Gg
+#. KDFkQ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891593880142588\n"
"help.text"
-msgid "<emph>Range</emph> : The range where to get the formulas from, as a string."
+msgid "<emph>range</emph>: The range where to get the formulas from, as a string."
msgstr ""
#. tBeSN
@@ -4831,22 +4849,22 @@ msgctxt ""
msgid "Get the value(s) stored in the given range of cells as a single value, a 1D array or a 2D array. All values are either doubles or strings."
msgstr ""
-#. gy45t
+#. XACNZ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id91592231156434\n"
"help.text"
-msgid "<emph>Range</emph> : The range where to get the values from, as a string."
+msgid "<emph>range</emph>: The range where to get the values from, as a string."
msgstr ""
-#. t7Dxx
+#. ojRBo
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id991611756492772\n"
"help.text"
-msgid "If a cell contains a date, the number corresponding to that date will be returned. To convert numeric values to dates, use the Basic <link href=\"text/sbasic/shared/03100300.xhp\" name=\"CDate function\"><literal>CDate</literal> builtin function</link>."
+msgid "If a cell contains a date, the number corresponding to that date will be returned. To convert numeric values to dates in Basic scripts, use the Basic <link href=\"text/sbasic/shared/03100300.xhp\" name=\"CDate Basic\"><literal>CDate</literal> builtin function</link>. In Python scripts, use the <link href=\"text/sbasic/shared/03/sf_basic.xhp#CDate\" name=\"CDate Python\"><literal>CDate</literal> function from the <literal>Basic</literal> service.</link>"
msgstr ""
#. YYMuH
@@ -4876,31 +4894,31 @@ msgctxt ""
msgid "The method returns a string representing the modified range of cells."
msgstr ""
-#. FYhhA
+#. GrquM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id851593685490824\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. aTojh
+#. VdTtY
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id641593685490936\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell to insert the imported data, as a string. If instead a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination cell to insert the imported data, as a string. If instead a range is given, only its top-left cell is considered."
msgstr ""
-#. wrD7S
+#. BrTfu
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id641593685863838\n"
"help.text"
-msgid "<emph>FilterOptions</emph> : The arguments for the CSV input filter. The default filter makes following assumptions:"
+msgid "<emph>filteroptions</emph>: The arguments for the CSV input filter. The default filter makes following assumptions:"
msgstr ""
#. Mb4c6
@@ -5011,49 +5029,49 @@ msgctxt ""
msgid "The method returns <literal>True</literal> when the import was successful."
msgstr ""
-#. HfEiJ
+#. rgoAd
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id311599568986784\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
msgstr ""
-#. Makpm
+#. j2J5e
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id711596555746281\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name to use to find the database in the databases register. This argument is ignored if a <literal>FileName</literal> is provided."
+msgid "<emph>registrationname</emph>: The name to use to find the database in the databases register. This argument is ignored if a <literal>filename</literal> is provided."
msgstr ""
-#. iG9FB
+#. 2hSHw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211599568986329\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination of the imported data, as a string. If a range is given, only its top-left cell is considered."
+msgid "<emph>destinationcell</emph>: The destination of the imported data, as a string. If a range is given, only its top-left cell is considered."
msgstr ""
-#. T8KAC
+#. aMfVw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id451599489278429\n"
"help.text"
-msgid "<emph>SQLCommand</emph> : A table or query name (without surrounding quotes or square brackets) or a SELECT SQL statement in which table and field names may be surrounded by square brackets or quotes to improve its readability."
+msgid "<emph>sqlcommand</emph>: A table or query name (without surrounding quotes or square brackets) or a SELECT SQL statement in which table and field names may be surrounded by square brackets or quotes to improve its readability."
msgstr ""
-#. GiN95
+#. wFpLr
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id271599489278141\n"
"help.text"
-msgid "<emph>DirectSQL</emph> : When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. The argument is ignored for tables. For queries, the applied option is the one set when the query was defined."
+msgid "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. The argument is ignored for tables. For queries, the applied option is the one set when the query was defined."
msgstr ""
#. toj8z
@@ -5065,22 +5083,22 @@ msgctxt ""
msgid "Inserts a new empty sheet before an existing sheet or at the end of the list of sheets."
msgstr ""
-#. iFgTP
+#. Xbm7k
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id941591698472748\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the new sheet."
+msgid "<emph>sheetname</emph>: The name of the new sheet."
msgstr ""
-#. agryz
+#. XbXNM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id84159169847269\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which to insert the new sheet."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the new sheet. This argument is optional and the default behavior is to insert the sheet at the last position."
msgstr ""
#. UCmit
@@ -5101,22 +5119,22 @@ msgctxt ""
msgid "Moves a specified source range to a destination range of cells. The method returns a string representing the modified range of cells. The dimension of the modified area is fully determined by the size of the source area."
msgstr ""
-#. Eh8ar
+#. UqxZv
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id571592569476332\n"
"help.text"
-msgid "<emph>Source</emph> : The source range of cells, as a string."
+msgid "<emph>source</emph>: The source range of cells, as a string."
msgstr ""
-#. MSSig
+#. G6BSW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891592569476362\n"
"help.text"
-msgid "<emph>Destination</emph> : The destination cell, as a string. If a range is given, its top-left cell is considered as the destination."
+msgid "<emph>destination</emph>: The destination cell, as a string. If a range is given, its top-left cell is considered as the destination."
msgstr ""
#. NorEd
@@ -5128,22 +5146,22 @@ msgctxt ""
msgid "Moves an existing sheet and places it before a specified sheet or at the end of the list of sheets."
msgstr ""
-#. s6bx7
+#. dgAxB
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591698903911\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to move. The sheet must exist or an exception is raised."
+msgid "<emph>sheetname</emph>: The name of the sheet to move. The sheet must exist or an exception is raised."
msgstr ""
-#. kp595
+#. fevuS
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id9159169890334\n"
"help.text"
-msgid "<emph>BeforeSheet</emph> : The name (string) or index (numeric, starting from 1) of the sheet before which the original sheet will be placed."
+msgid "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which the original sheet will be placed. This argument is optional and the default behavior is to move the sheet to the last position."
msgstr ""
#. pd5t4
@@ -5173,67 +5191,67 @@ msgctxt ""
msgid "This method has the same behavior as the homonymous Calc's <link href=\"text/scalc/01/04060109.xhp\" name=\"Offset function\">Offset function</link>."
msgstr ""
-#. uiv8D
+#. G2oD2
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id901592233506293\n"
"help.text"
-msgid "<emph>Reference</emph> : The range, as a string, that the method will use as reference to perform the offset operation."
+msgid "<emph>reference</emph>: The range, as a string, that the method will use as reference to perform the offset operation."
msgstr ""
-#. YmkNz
+#. Ra7aW
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id781592234124856\n"
"help.text"
-msgid "<emph>Rows</emph> : The number of rows by which the initial range is offset upwards (negative value) or downwards (positive value). Use 0 (default) to stay in the same row."
+msgid "<emph>rows</emph>: The number of rows by which the initial range is offset upwards (negative value) or downwards (positive value). Use 0 (default) to stay in the same row."
msgstr ""
-#. fR6JC
+#. FvqjV
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id971592234138769\n"
"help.text"
-msgid "<emph>Columns</emph> : The number of columns by which the initial range is offset to the left (negative value) or to the right (positive value). Use 0 (default) to stay in the same column."
+msgid "<emph>columns</emph>: The number of columns by which the initial range is offset to the left (negative value) or to the right (positive value). Use 0 (default) to stay in the same column."
msgstr ""
-#. TKX46
+#. VzgGM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321592234150061\n"
"help.text"
-msgid "<emph>Height</emph> : The vertical height for an area that starts at the new range position. Default = 0 (no vertical resizing)."
+msgid "<emph>height</emph>: The vertical height for an area that starts at the new range position. Omit this argument when no vertical resizing is needed."
msgstr ""
-#. 8uqoL
+#. JxENN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id271592234165247\n"
"help.text"
-msgid "<emph>Width</emph> : The horizontal width for an area that starts at the new range position. Default = 0 (no horizontal resizing)."
+msgid "<emph>width</emph>: The horizontal width for an area that starts at the new range position. Omit this argument when no horizontal resizing is needed."
msgstr ""
-#. hT42G
+#. t9QDN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id871592234172652\n"
"help.text"
-msgid "Arguments <literal>Rows</literal> and <literal>Columns</literal> must not lead to zero or negative start row or column."
+msgid "Arguments <literal>rows</literal> and <literal>columns</literal> must not lead to zero or negative start row or column."
msgstr ""
-#. QcACo
+#. JAxEm
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id211592234180073\n"
"help.text"
-msgid "Arguments <literal>Height</literal> and <literal>Width</literal> must not lead to zero or negative count of rows or columns."
+msgid "Arguments <literal>height</literal> and <literal>width</literal> must not lead to zero or negative count of rows or columns."
msgstr ""
#. BkCDz
@@ -5263,13 +5281,22 @@ msgctxt ""
msgid "Removes an existing sheet from the document."
msgstr ""
-#. 9Mvbg
+#. H3eHf
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id991621620588147\n"
+"help.text"
+msgid "<input>doc.RemoveSheet(sheetname: str): bool</input>"
+msgstr ""
+
+#. dVxiA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id331591699085330\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to remove."
+msgid "<emph>sheetname</emph>: The name of the sheet to remove."
msgstr ""
#. GwKHr
@@ -5281,22 +5308,22 @@ msgctxt ""
msgid "Renames the given sheet and returns <literal>True</literal> if successful."
msgstr ""
-#. mAigC
+#. ofAiN
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id161591704316337\n"
"help.text"
-msgid "<emph>SheetName</emph> : The name of the sheet to rename."
+msgid "<emph>sheetname</emph>: The name of the sheet to rename."
msgstr ""
-#. s8sbi
+#. JHEDe
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id931591704316998\n"
"help.text"
-msgid "<emph>NewName</emph> : the new name of the sheet. It must not exist yet."
+msgid "<emph>newname</emph>: the new name of the sheet. It must not exist yet."
msgstr ""
#. bwtAA
@@ -5308,13 +5335,13 @@ msgctxt ""
msgid "This example renames the active sheet to \"SheetY\":"
msgstr ""
-#. EfMAM
+#. qEM6N
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id191592745582983\n"
"help.text"
-msgid "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>Value</literal> argument. Vectors are always expanded vertically."
+msgid "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>value</literal> argument. Vectors are always expanded vertically."
msgstr ""
#. tm6AR
@@ -5326,22 +5353,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. 6bCom
+#. FAuKq
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id801592745582116\n"
"help.text"
-msgid "<emph>TargetCell</emph> : The cell or a range as a string from where to start to store the given value."
+msgid "<emph>targetcell</emph>: The cell or a range as a string from where to start to store the given value."
msgstr ""
-#. SWWie
+#. aK7EZ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321592745582192\n"
"help.text"
-msgid "<emph>Value</emph> : A scalar, a vector or an array with the new values to be stored from the target cell or from the top-left corner of the range if <literal>TargetCell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
+msgid "<emph>value</emph>: A scalar, a vector or an array (in Python, one or two-dimensional lists and tuples) with the new values to be stored from the target cell or from the top-left corner of the range if <literal>targetcell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
msgstr ""
#. 7BCXQ
@@ -5398,49 +5425,49 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. 9FVf6
+#. xYrHQ
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id361592231799255\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range where to store the given value, as a string."
+msgid "<emph>targetrange</emph>: The range where to store the given value, as a string."
msgstr ""
-#. gSTGX
+#. dydXF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id461592232081985\n"
"help.text"
-msgid "<emph>Value</emph> : A scalar, a vector or an array with the new values for each cell of the range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
+msgid "<emph>value</emph>: A scalar, a vector or an array with the new values for each cell of the range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied."
msgstr ""
-#. J2xh8
+#. CgwVF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id841592745785192\n"
"help.text"
-msgid "The full range is updated and the remainder of the sheet is left unchanged. If the size of <literal>Value</literal> is smaller than the size of <literal>TargetRange</literal>, then the remaining cells will be emptied."
+msgid "The full range is updated and the remainder of the sheet is left unchanged. If the size of <literal>value</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells will be emptied."
msgstr ""
-#. 6eqih
+#. QFkLr
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id191611776838396\n"
"help.text"
-msgid "If the size of <literal>Value</literal> is larger than the size of <literal>TargetRange</literal>, then <literal>Value</literal> is only partially copied until it fills the size of <literal>TargetRange</literal>."
+msgid "If the size of <literal>value</literal> is larger than the size of <literal>targetrange</literal>, then <literal>value</literal> is only partially copied until it fills the size of <literal>targetrange</literal>."
msgstr ""
-#. nfsWb
+#. ykBk6
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id71611776941663\n"
"help.text"
-msgid "Vectors are expanded vertically, except if the range has a height of exactly 1 row."
+msgid "Vectors are expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row."
msgstr ""
#. FJCPf
@@ -5461,6 +5488,15 @@ msgctxt ""
msgid "'Below the Value and TargetRange have the same size"
msgstr ""
+#. 4LFnH
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id731621689592755\n"
+"help.text"
+msgid "If you want to fill a single row with values, you can use the <literal>Offset</literal> function. In the example below, consider that <literal>arrData</literal> is a one-dimensional array:"
+msgstr ""
+
#. g8mER
#: sf_calc.xhp
msgctxt ""
@@ -5479,22 +5515,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. L8GHj
+#. FtFpL
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id22159576768782\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range to which the style will be applied, as a string."
+msgid "<emph>targetrange</emph>: The range to which the style will be applied, as a string."
msgstr ""
-#. UxxXn
+#. aAGcy
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id181595767687247\n"
"help.text"
-msgid "<emph>Style</emph> : The name of the cell style to apply."
+msgid "<emph>style</emph>: The name of the cell style to apply."
msgstr ""
#. DCAWV
@@ -5515,22 +5551,22 @@ msgctxt ""
msgid "The method returns a string representing the modified area as a range of cells."
msgstr ""
-#. CWJbm
+#. F5XDi
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id891593880376776\n"
"help.text"
-msgid "<emph>TargetRange</emph> : The range to insert the formulas, as a string."
+msgid "<emph>targetrange</emph>: The range to insert the formulas, as a string."
msgstr ""
-#. rRECW
+#. A2UQF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id941593880376500\n"
"help.text"
-msgid "<emph>Formula</emph> : A string, a vector or an array of strings with the new formulas for each cell in the target range."
+msgid "<emph>formula</emph>: A string, a vector or an array of strings with the new formulas for each cell in the target range."
msgstr ""
#. 746E8
@@ -5551,31 +5587,31 @@ msgctxt ""
msgid "If the given formula is a string, the unique formula is pasted along the whole range with adjustment of the relative references."
msgstr ""
-#. uqWBs
+#. zr47n
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id491593880857823\n"
"help.text"
-msgid "If the size of <literal>Formula</literal> is smaller than the size of <literal>TargetRange</literal>, then the remaining cells are emptied."
+msgid "If the size of <literal>formula</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells are emptied."
msgstr ""
-#. oMpK4
+#. LwoGL
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id701611778103306\n"
"help.text"
-msgid "If the size of <literal>Formula</literal> is larger than the size of <literal>TargetRange</literal>, then the formulas are only partially copied until it fills the size of <literal>TargetRange</literal>."
+msgid "If the size of <literal>formula</literal> is larger than the size of <literal>targetrange</literal>, then the formulas are only partially copied until it fills the size of <literal>targetrange</literal>."
msgstr ""
-#. xGTCr
+#. GQC3N
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id761611777946581\n"
"help.text"
-msgid "Vectors are always expanded vertically, except if the range has a height of exactly 1 row."
+msgid "Vectors are always expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row."
msgstr ""
#. rNEEY
@@ -5605,67 +5641,67 @@ msgctxt ""
msgid "Sorts the given range based on up to 3 columns/rows. The sorting order may vary by column/row. It returns a string representing the modified range of cells. The size of the modified area is fully determined by the size of the source area."
msgstr ""
-#. V6NVn
+#. MVGBC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id171595692394598\n"
"help.text"
-msgid "<emph>Range</emph> : The range to be sorted, as a string."
+msgid "<emph>range</emph>: The range to be sorted, as a string."
msgstr ""
-#. zppvu
+#. aenrK
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id171595692814163\n"
"help.text"
-msgid "<emph>SortKeys</emph> : A scalar (if 1 column/row) or an array of column/row numbers starting from 1. The maximum number of keys is 3."
+msgid "<emph>sortkeys</emph>: A scalar (if 1 column/row) or an array of column/row numbers starting from 1. The maximum number of keys is 3."
msgstr ""
-#. rmDya
+#. aQF93
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id421595692962095\n"
"help.text"
-msgid "<emph>SortOrder</emph> : A scalar or an array of strings containing the values \"ASC\" (ascending), \"DESC\" (descending) or \"\" (which defaults to ascending). Each item is paired with the corresponding item in <literal>SortKeys</literal>. If the <literal>SortOrder</literal> array is shorter than <literal>SortKeys</literal>, the remaining keys are sorted in ascending order."
+msgid "<emph>sortorder</emph>: A scalar or an array of strings containing the values \"ASC\" (ascending), \"DESC\" (descending) or \"\" (which defaults to ascending). Each item is paired with the corresponding item in <literal>sortkeys</literal>. If the <literal>sortorder</literal> array is shorter than <literal>sortkeys</literal>, the remaining keys are sorted in ascending order."
msgstr ""
-#. oPgRB
+#. GVpuf
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id361595692394604\n"
"help.text"
-msgid "<emph>DestinationCell</emph> : The destination cell of the sorted range of cells, as a string. If a range is given, only its top-left cell is considered. By default the source Range is overwritten."
+msgid "<emph>destinationcell</emph>: The destination cell of the sorted range of cells, as a string. If a range is given, only its top-left cell is considered. By default the source Range is overwritten."
msgstr ""
-#. JogWo
+#. QyaTf
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id441595693011034\n"
"help.text"
-msgid "<emph>ContainsHeader</emph> : When <literal>True</literal>, the first row/column is not sorted."
+msgid "<emph>containsheader</emph>: When <literal>True</literal>, the first row/column is not sorted."
msgstr ""
-#. Q7Bi2
+#. AbVtY
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id241595693169032\n"
"help.text"
-msgid "<emph>CaseSensitive</emph> : Only for string comparisons. Default = <literal>False</literal>"
+msgid "<emph>casesensitive</emph>: Only for string comparisons. Default = <literal>False</literal>"
msgstr ""
-#. g2ggy
+#. CL5Gm
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id1001595693326226\n"
"help.text"
-msgid "<emph>SortColumns</emph> : When <literal>True</literal>, the columns are sorted from left to right. Default = <literal>False</literal> : rows are sorted from top to bottom."
+msgid "<emph>sortcolumns</emph>: When <literal>True</literal>, the columns are sorted from left to right. Default = <literal>False</literal> : rows are sorted from top to bottom."
msgstr ""
#. LvjpD
@@ -7306,13 +7342,22 @@ msgctxt ""
msgid "Service invocation"
msgstr ""
-#. jKixF
+#. EnxDs
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id361598174756160\n"
"help.text"
-msgid "The <literal>DialogControl</literal><literal/> service is invoked from an existing <literal>Dialog</literal> service instance thru its <literal>Controls()</literal> method. The dialog must be initiated with the <literal>SFDialogs.Dialog</literal> service."
+msgid "The <literal>DialogControl</literal> service is invoked from an existing <literal>Dialog</literal> service instance through its <literal>Controls()</literal> method. The dialog must be initiated with the <literal>SFDialogs.Dialog</literal> service."
+msgstr ""
+
+#. RCFrE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id581598453210170\n"
+"help.text"
+msgid "myControl.Value = \"Dialog started at \" & Now()"
msgstr ""
#. WVG8J
@@ -7324,22 +7369,31 @@ msgctxt ""
msgid "' ... process the controls actual values"
msgstr ""
-#. 2PPv4
+#. gxhUu
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"par_id951598174966322\n"
+"pyc_id861620225235002\n"
"help.text"
-msgid "Alternatively a control instance can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, providing the dialog was initiated with the <literal>Dialog</literal> service. <literal>DialogEvent</literal> returns the <literal>SFDialogs.DialogControl</literal> class instance that triggered the event."
+msgid "text.Value = \"Dialog started at \" + strftime(\"%a, %d %b %Y %H:%M:%S\", localtime())"
msgstr ""
-#. WKCuT
+#. nu3f3
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"bas_id801598175242937\n"
+"pyc_id841620225235377\n"
+"help.text"
+msgid "# ... process the controls actual values"
+msgstr ""
+
+#. 2PPv4
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id951598174966322\n"
"help.text"
-msgid "' oControl represents now the instance of the Control class having triggered the current event"
+msgid "Alternatively a control instance can be retrieved via the <literal>SFDialogs.DialogEvent</literal> service, providing the dialog was initiated with the <literal>Dialog</literal> service. <literal>DialogEvent</literal> returns the <literal>SFDialogs.DialogControl</literal> class instance that triggered the event."
msgstr ""
#. 75WJy
@@ -8593,40 +8647,40 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event - using the <literal>OnNodeExpanded</literal> event - to complete the tree dynamically."
msgstr ""
-#. cK7HA
+#. T8xdA
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id761612711823834\n"
"help.text"
-msgid "<emph>ParentNode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
+msgid "<emph>parentnode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
msgstr ""
-#. g2Ubo
+#. qJ9ej
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id791612711823819\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The text appearing in the tree control box."
+msgid "<emph>displayvalue</emph>: The text appearing in the tree control box."
msgstr ""
-#. GV6Gp
+#. Pzz72
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id911612711823382\n"
"help.text"
-msgid "<emph>DataValue</emph>: Any value associated with the new node. Default value is <literal>Empty</literal>."
+msgid "<emph>datavalue</emph>: Any value associated with the new node. <literal>datavalue</literal> may be a string, a number or a date. Omit the argument when not applicable."
msgstr ""
-#. qbb2x
+#. 2pLPL
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"bas_id401612711823779\n"
+"par_id901620317110685\n"
"help.text"
-msgid "'Dialog stored in current document's standard library"
+msgid "%PRODUCTNAME Basic and Python examples pick up current document's <literal>myDialog</literal> dialog from <literal>Standard</literal> library."
msgstr ""
#. 8B3qP
@@ -8638,22 +8692,22 @@ msgctxt ""
msgid "Return <literal>True</literal> when a subtree, subordinate to a parent node, could be inserted successfully in a tree control. If the parent node had already child nodes before calling this method, the child nodes are erased."
msgstr ""
-#. UkE9k
+#. beond
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id781612713087722\n"
"help.text"
-msgid "<emph>ParentNode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
+msgid "<emph>parentnode</emph>: A node UNO object, of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>."
msgstr ""
-#. 2FTD4
+#. QJ73V
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id36161271308759\n"
"help.text"
-msgid "<emph>FlatTree</emph>: a two dimension array sorted on the columns containing the display values. Such an array can be issued by the <literal>GetRows</literal> method applied on the <literal>SFDatabases.Database</literal> service. When an array item containing the text to be displayed is <literal>Empty</literal> or <literal>Null</literal>, no new subnode is created and the remainder of the row is skipped."
+msgid "<emph>flattree</emph>: a two dimension array sorted on the columns containing the display values. Such an array can be issued by the <literal>GetRows</literal> method applied on the <literal>SFDatabases.Database</literal> service. When an array item containing the text to be displayed is <literal>Empty</literal> or <literal>Null</literal>, no new subnode is created and the remainder of the row is skipped."
msgstr ""
#. r5QNj
@@ -8665,13 +8719,13 @@ msgctxt ""
msgid "Flat tree >>>> Resulting subtree"
msgstr ""
-#. SQH7v
+#. MUi8U
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id51612713087915\n"
"help.text"
-msgid "<emph>WithDataValue</emph>: When <literal>False</literal> default value is used, every column of <literal>FlatTree</literal> contains the text to be displayed in the tree control. When <literal>True</literal>, the texts to be displayed (<literal>DisplayValue</literal>) are in columns 0, 2, 4, ... while the data values (<literal>DataValue</literal>) are in columns 1, 3, 5, ..."
+msgid "<emph>withdatavalue</emph>: When <literal>False</literal> default value is used, every column of <literal>flattree</literal> contains the text to be displayed in the tree control. When <literal>True</literal>, the texts to be displayed (<literal>displayvalue</literal>) are in columns 0, 2, 4, ... while the data values (<literal>datavalue</literal>) are in columns 1, 3, 5, ..."
msgstr ""
#. fWnhZ
@@ -8692,31 +8746,22 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event to complete the tree dynamically."
msgstr ""
-#. QiXVA
+#. JXyjD
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
-"par_id671612780723837\n"
+"par_id791612117823819\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The text appearing in the tree control box."
+msgid "<emph>displayvalue</emph>: The text appearing in the tree control box."
msgstr ""
-#. Cw3b9
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id31612780723267\n"
-"help.text"
-msgid "<emph>DataValue</emph>: Any value associated with the new node. Default value is <literal>Empty</literal>."
-msgstr ""
-
-#. Ynpwt
+#. XxGFd
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id171612781589503\n"
"help.text"
-msgid "Traverses the tree and finds recursively, starting from the root, a node meeting some criteria. Either - 1 match is enough - having its display value matching <literal>DisplayValue</literal> pattern or having its data value equal to <literal>DataValue</literal>. The comparisons may be or not case-sensitive. The first matching occurrence is returned as a node UNO object of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>. <embedvar href=\"text/sbasic/shared/03/sf_dialogcontrol.xhp#XMutableTreeNode\"/>"
+msgid "Traverses the tree and finds recursively, starting from the root, a node meeting some criteria. Either - 1 match is enough - having its display value matching <literal>displayvalue</literal> pattern or having its data value equal to <literal>datavalue</literal>. The comparisons may be or not case-sensitive. The first matching occurrence is returned as a node UNO object of type <literal>com.sun.star.awt.tree.XMutableTreeNode</literal>. <embedvar href=\"text/sbasic/shared/03/sf_dialogcontrol.xhp#XMutableTreeNode\"/>"
msgstr ""
#. 5Jxkj
@@ -8737,40 +8782,31 @@ msgctxt ""
msgid "This method may be called before displaying the dialog box to build the initial tree. It may also be called from a dialog or control event."
msgstr ""
-#. BSnCr
+#. Dd4Ti
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id541613670199211\n"
"help.text"
-msgid "One argument out of <literal>DisplayValue</literal> or <literal>DataValue</literal> must be specified. If both present, one match is sufficient to select the node."
+msgid "One argument out of <literal>displayvalue</literal> or <literal>datavalue</literal> must be specified. If both present, one match is sufficient to select the node."
msgstr ""
-#. fYkEn
+#. MF7PA
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id591612781589560\n"
"help.text"
-msgid "<emph>DisplayValue</emph>: The pattern to be matched. See the <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"String service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method. When equal to the zero-length string (default), this display value is not searched for."
+msgid "<emph>displayvalue</emph>: The pattern to be matched. Refer to <link href=\"text/sbasic/shared/03/sf_string.xhp#IsLike\" name=\"String service IsLike() method\"><literal>SF_String.IsLike()</literal></link> method for the list of possible wildcards. When equal to the zero-length string (default), this display value is not searched for."
msgstr ""
-#. CF4o6
-#: sf_dialogcontrol.xhp
-msgctxt ""
-"sf_dialogcontrol.xhp\n"
-"par_id481612781589626\n"
-"help.text"
-msgid "<emph>DataValue</emph>: A string, a numeric value, a date. Use <literal>Empty</literal> default value when no value applies."
-msgstr ""
-
-#. g7uEG
+#. BE58W
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id141582384726168\n"
"help.text"
-msgid "<emph>CaseSensitive</emph>: Default value is <literal>False</literal>"
+msgid "<emph>casesensitive</emph>: Default value is <literal>False</literal>"
msgstr ""
#. 3oU3L
@@ -10195,67 +10231,76 @@ msgctxt ""
msgid "<variable id=\"ExceptionService\"><link href=\"text/sbasic/shared/03/sf_exception.xhp\" name=\"Exception service\"><literal>ScriptForge</literal>.<literal>Exception</literal> service</link></variable>"
msgstr ""
-#. m5HoF
+#. 4X7Xk
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id181587139648008\n"
"help.text"
-msgid "The <literal>Exception</literal> service is a collection of methods for Basic code debugging and error handling."
+msgid "The <literal>Exception</literal> service is a collection of methods to assist in code debugging in Basic and Python scripts and in error handling in Basic scripts."
msgstr ""
-#. KiitV
+#. XeYa4
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id141587140927573\n"
"help.text"
-msgid "In the advent of a run-time error, the <literal>Exception</literal> service properties and methods help identify the error context and permit to handle it."
+msgid "In <emph>Basic scripts</emph>, when a run-time error occurs, the methods and properties of the <literal>Exception</literal> service help identify the error context and allow to handle it."
msgstr ""
-#. Kn3iF
+#. ENY3v
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id461587140965192\n"
+"par_id401621450898070\n"
"help.text"
msgid "The <literal>SF_Exception</literal> service is similar to the <link href=\"text/sbasic/shared/ErrVBA.xhp\" name=\"VBA Err object\">VBA <literal>Err</literal> object</link>."
msgstr ""
-#. 6rquM
+#. vpB42
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id61587141015326\n"
+"par_id361621450908874\n"
"help.text"
msgid "The <literal>Number</literal> property identifies the error."
msgstr ""
-#. 9Gh4S
+#. TnWpD
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id251608212974671\n"
+"par_id861621450910254\n"
"help.text"
-msgid "Use <literal>Raise()</literal> method to interrupt processing, use <literal>RaiseWarning()</literal> method to trap an anomaly and continue processing."
+msgid "Use the <literal>Raise</literal> method to interrupt processing. The <literal>RaiseWarning</literal> method can be used to trap an anomaly without interrupting the macro execution."
msgstr ""
-#. PddYS
+#. CpxKC
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id621587225732733\n"
"help.text"
-msgid "Errors or warnings raised with the <literal>Exception</literal> service are stored in memory and can be retrieved using its <literal>Console()</literal> method."
+msgid "Errors and warnings raised with the <literal>Exception</literal> service are stored in memory and can be retrieved using the <literal>Console</literal> method."
msgstr ""
-#. i8z6N
+#. CpBSQ
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id411587141146677\n"
"help.text"
-msgid "The <literal>Exception</literal> service console stores events, variable values and information about errors. Use the console when Basic IDE is not accessible, for example in <link href=\"text/scalc/guide/userdefined_function.xhp\" name=\"Calc user-defined function\">Calc user defined functions (UDF)</link> or during events processing. Use <literal>DebugPrint()</literal> method to aggregate additional user data. Console entries can be dumped to a text file or visualized in a dialogue."
+msgid "The <literal>Exception</literal> service console stores events, variable values and information about errors. Use the console when the Basic IDE is not easily accessible, for example in <link href=\"text/scalc/guide/userdefined_function.xhp\" name=\"Calc user-defined function\">Calc user defined functions (UDF)</link> or during events processing."
+msgstr ""
+
+#. NrY9C
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id251621034725811\n"
+"help.text"
+msgid "Use the <literal>DebugPrint</literal> method to add any relevant information to the console. Console entries can be dumped to a text file or visualized in a dialog window."
msgstr ""
#. 9AW2i
@@ -10276,13 +10321,13 @@ msgctxt ""
msgid "Report the error in the <literal>Exception</literal> console"
msgstr ""
-#. SGmPy
+#. N9X2f
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id751587141235313\n"
"help.text"
-msgid "Inform the user about the error using either a standard message either a customized message"
+msgid "Inform the user about the error using either a standard message or a custom message"
msgstr ""
#. C3NMD
@@ -10294,22 +10339,31 @@ msgctxt ""
msgid "Optionally stop its execution"
msgstr ""
-#. yQzKr
+#. vFJRL
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"hd_id201586594659135\n"
+"par_id771621035263403\n"
"help.text"
-msgid "Service invocation"
+msgid "In <emph>Python scripts</emph> the <literal>Exception</literal> service is mostly used for debugging purposes. Methods such as <literal>DebugPrint</literal>, <literal>Console</literal> and <literal>DebugDisplay</literal> are useful to quickly print messages, log data and open the console window from within a Python script."
msgstr ""
-#. 5YFk5
+#. VAaLU
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
-"par_id571586594672714\n"
+"par_id211621035276160\n"
"help.text"
-msgid "To invoke the <literal>Exception</literal> service, first you need to load the <literal>ScriptForge</literal> library using:"
+msgid "Not all methods and properties are available for Python scripts since the Python language already has a comprehensive exception handling system."
+msgstr ""
+
+#. yQzKr
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"hd_id201586594659135\n"
+"help.text"
+msgid "Service invocation"
msgstr ""
#. T8o7G
@@ -10321,6 +10375,15 @@ msgctxt ""
msgid "The following examples show three different approaches to call the method <literal>Raise</literal>. All other methods can be executed in a similar fashion."
msgstr ""
+#. tGmaZ
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id901621036227048\n"
+"help.text"
+msgid "The code snippet below creates an instance of the <literal>Exception</literal> service, logs a message and displays the <literal>Console</literal> window."
+msgstr ""
+
#. HABsh
#: sf_exception.xhp
msgctxt ""
@@ -10330,6 +10393,15 @@ msgctxt ""
msgid "Properties"
msgstr ""
+#. JDNi6
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id911621036526404\n"
+"help.text"
+msgid "The properties listed below are only available for <emph>Basic</emph> scripts."
+msgstr ""
+
#. s3E9G
#: sf_exception.xhp
msgctxt ""
@@ -10339,13 +10411,13 @@ msgctxt ""
msgid "Name"
msgstr ""
-#. qEhnn
+#. b96rE
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id241584978211550\n"
"help.text"
-msgid "ReadOnly"
+msgid "Readonly"
msgstr ""
#. TkMLa
@@ -10519,13 +10591,13 @@ msgctxt ""
msgid "A modal console can only be closed by the user. A non-modal console can either be closed by the user or upon macro termination."
msgstr ""
-#. 2DWxi
+#. HUgnb
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id511598718179819\n"
"help.text"
-msgid "<emph>Modal</emph>: Determine if the console window is Modal (<literal>True</literal>) or Non-modal (<literal>False</literal>). Default value is <literal>True</literal>."
+msgid "<emph>modal</emph>: Determine if the console window is modal (<literal>True</literal>) or non-modal (<literal>False</literal>). Default value is <literal>True</literal>."
msgstr ""
#. xu6FA
@@ -10537,13 +10609,13 @@ msgctxt ""
msgid "Clears the console keeping an optional number of recent messages. If the console is activated in non-modal mode, it is refreshed."
msgstr ""
-#. jbkCo
+#. SE7ei
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id351587215098527\n"
"help.text"
-msgid "<emph>Keep</emph>: The number of recent messages to be kept. Default value is 0."
+msgid "<emph>keep</emph>: The number of recent messages to be kept. Default value is 0."
msgstr ""
#. GLEVv
@@ -10564,13 +10636,40 @@ msgctxt ""
msgid "Exports the contents of the console to a text file. If the file already exists and the console is not empty, it will be overwritten without warning. Returns <literal>True</literal> if successful."
msgstr ""
-#. QMb9C
+#. HEXvU
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id851587218077862\n"
"help.text"
-msgid "<emph>FileName</emph>: The name of the text file the console should be dumped into. The name is expressed according to the current <literal>FileNaming</literal> property of the <literal>SF_FileSystem</literal> service. <link href=\"text/sbasic/shared/00000002.xhp\" name=\"Url notation\">URL notation</link> and the native operating system's format are both admitted."
+msgid "<emph>filename</emph>: The name of the text file the console should be dumped into. The name is expressed according to the current <literal>FileNaming</literal> property of the <literal>SF_FileSystem</literal> service. By default, <link href=\"text/sbasic/shared/00000002.xhp\" name=\"Url notation\">URL notation</link> and the native operating system's format are both admitted."
+msgstr ""
+
+#. F3tVM
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id701621043185177\n"
+"help.text"
+msgid "Concatenates all the arguments into a single human-readable string and displays it in a <literal>MsgBox</literal> with an Information icon and an OK button."
+msgstr ""
+
+#. KaGM6
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id791621097689492\n"
+"help.text"
+msgid "The final string is also added to the Console."
+msgstr ""
+
+#. QhRgF
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id481587218636884\n"
+"help.text"
+msgid "<emph>arg0[, arg1, ...]</emph>: Any number of arguments of any type."
msgstr ""
#. 2qser
@@ -10582,13 +10681,67 @@ msgctxt ""
msgid "Assembles all the given arguments into a single human-readable string and adds it as a new entry in the console."
msgstr ""
-#. BmmDA
+#. mUSEP
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id481587218637988\n"
"help.text"
-msgid "<emph>Arg0[, Arg1, ...]</emph>: Any number of arguments of any type."
+msgid "<emph>arg0[, arg1, ...]</emph>: Any number of arguments of any type."
+msgstr ""
+
+#. CUoch
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id111621426672183\n"
+"help.text"
+msgid "Opens an APSO Python shell as a non-modal window. The Python script keeps running after the shell is opened. The output from <literal>print</literal> statements inside the script are shown in the shell."
+msgstr ""
+
+#. f9ZzM
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id841621426922467\n"
+"help.text"
+msgid "Only a single instance of the APSO Python shell can be opened at any time. Hence, if a Python shell is already open, then calling this method will have no effect."
+msgstr ""
+
+#. KGi8B
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id391621449167833\n"
+"help.text"
+msgid "<emph>variables</emph>: a Python dictionary with variable names and values that will be passed on to the APSO Python shell. By default all local variables are passed using Python's builtin <literal>locals()</literal> function."
+msgstr ""
+
+#. zT7Gq
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id991621449657850\n"
+"help.text"
+msgid "The example below opens the APSO Python shell passing all global and local variables considering the context where the script is running."
+msgstr ""
+
+#. yUoFK
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"par_id521621449800348\n"
+"help.text"
+msgid "When the APSO Python shell is open, any subsequent output printed by the script will be shown in the shell. Hence, the string printed in the example below will be displayed in the Python shell."
+msgstr ""
+
+#. 5xNCX
+#: sf_exception.xhp
+msgctxt ""
+"sf_exception.xhp\n"
+"pyc_id731621449899901\n"
+"help.text"
+msgid "print(\"Hello world!\")"
msgstr ""
#. aXDEK
@@ -10654,13 +10807,13 @@ msgctxt ""
msgid "To raise an exception with the standard values:"
msgstr ""
-#. ZneYd
+#. SABN3
#: sf_exception.xhp
msgctxt ""
"sf_exception.xhp\n"
"par_id751587222598238\n"
"help.text"
-msgid "To raise an exception with an specific code:"
+msgid "To raise an exception with a specific code:"
msgstr ""
#. QXgCy
@@ -20428,13 +20581,13 @@ msgctxt ""
msgid "<variable id=\"UIService\"><link href=\"text/sbasic/shared/03/sf_ui.xhp\" name=\"ScriptForge.UI service\"><literal>ScriptForge</literal>.<literal>UI</literal> service</link></variable>"
msgstr ""
-#. ABBCn
+#. cAtxQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id31587913266153\n"
"help.text"
-msgid "The UI (User Interface) service simplifies the identification and the manipulation of the different windows composing the whole LibreOffice application:"
+msgid "The UI (User Interface) service simplifies the identification and the manipulation of the different windows composing the whole %PRODUCTNAME application:"
msgstr ""
#. nTqj5
@@ -20491,11 +20644,11 @@ msgctxt ""
msgid "Access to the underlying \"documents\""
msgstr ""
-#. 3pR9U
+#. W5BL2
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"par_id421587913266819\n"
+"par_id181620312953395\n"
"help.text"
msgid "The UI service is the starting point to open, create or access to the content of new or existing documents from a user script."
msgstr ""
@@ -20698,6 +20851,177 @@ msgctxt ""
msgid "The list of the currently open documents. Special windows are ignored. This list consists of a zero-based one dimensional array either of filenames (in SF_FileSystem.FileNaming notation) or of window titles for unsaved documents."
msgstr ""
+#. BH9YJ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"hd_id511620762163390\n"
+"help.text"
+msgid "Constants"
+msgstr ""
+
+#. ziD2D
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id761620761856238\n"
+"help.text"
+msgid "Name"
+msgstr ""
+
+#. eBD6E
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id591620761856238\n"
+"help.text"
+msgid "Value"
+msgstr ""
+
+#. 2DU4R
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id711620761856238\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. TGMq5
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id511620761856238\n"
+"help.text"
+msgid "MACROEXECALWAYS"
+msgstr ""
+
+#. VFEvz
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id761620761856107\n"
+"help.text"
+msgid "2"
+msgstr ""
+
+#. adCUF
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id341620761856238\n"
+"help.text"
+msgid "Macros are always executed"
+msgstr ""
+
+#. o7zQn
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id661620761881513\n"
+"help.text"
+msgid "MACROEXECNEVER"
+msgstr ""
+
+#. kfQCf
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id661620761891082\n"
+"help.text"
+msgid "1"
+msgstr ""
+
+#. 7hEDg
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id101620761893011\n"
+"help.text"
+msgid "Macros are never executed"
+msgstr ""
+
+#. EABYh
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id311620761888379\n"
+"help.text"
+msgid "MACROEXECNORMAL"
+msgstr ""
+
+#. LpGCQ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id951620761899067\n"
+"help.text"
+msgid "0"
+msgstr ""
+
+#. 6Jgt7
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id11620761899780\n"
+"help.text"
+msgid "Macro execution depends on user settings"
+msgstr ""
+
+#. BTUQ4
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id311620312548992\n"
+"help.text"
+msgid "The examples below show a <literal>MsgBox</literal> with the names of all currently open documents."
+msgstr ""
+
+#. DCM9L
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id21620312350189\n"
+"help.text"
+msgid "svcUI = CreateScriptService(\"UI\")"
+msgstr ""
+
+#. EBquG
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id631620312351013\n"
+"help.text"
+msgid "sBasic = CreateScriptService(\"Basic\")"
+msgstr ""
+
+#. 3XXYB
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id141620312351286\n"
+"help.text"
+msgid "openDocs = svcUI.Documents()"
+msgstr ""
+
+#. jZeEa
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id661620312351500\n"
+"help.text"
+msgid "strDocs = \"\\n\".join(openDocs)"
+msgstr ""
+
+#. 7hHpR
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id801620312351676\n"
+"help.text"
+msgid "sBasic.MsgBox(strDocs)"
+msgstr ""
+
#. DfpBz
#: sf_ui.xhp
msgctxt ""
@@ -20707,11 +21031,11 @@ msgctxt ""
msgid "List of Methods in the UI Service"
msgstr ""
-#. dfsmh
+#. 4fc2p
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"par_id811596553490262\n"
+"par_id431620322170443\n"
"help.text"
msgid "Note, as an exception, that the methods marked <emph>(*)</emph> are <emph>not applicable to Base documents</emph>."
msgstr ""
@@ -20725,85 +21049,103 @@ msgctxt ""
msgid "Make the specified window active. The method returns <literal>True</literal> if the given window is found and can be activated. There is no change in the actual user interface if no window matches the selection."
msgstr ""
-#. fcE3q
+#. w9DR4
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id381587913266946\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: see the definitions above."
msgstr ""
-#. df2C7
+#. 5kwSb
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id13159655484952\n"
"help.text"
-msgid "Create and store a new LibreOffice Base document embedding an empty database of the given type. The method returns a document object."
+msgid "Creates and stores a new %PRODUCTNAME Base document embedding an empty database of the given type. The method returns a <literal>Document</literal> service instance."
msgstr ""
-#. BtPaW
+#. gqGpB
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441596554849949\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to create. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
+msgid "<emph>filename</emph> : Identifies the file to create. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. If the file already exists, it is overwritten without warning"
msgstr ""
-#. nePdj
+#. ncJxE
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id381596554849698\n"
"help.text"
-msgid "<emph>EmbeddedDatabase</emph> : Either \"HSQLDB\" (default) or \"FIREBIRD\"."
+msgid "<emph>embeddeddatabase</emph> : Either \"HSQLDB\" (default) or \"FIREBIRD\"."
msgstr ""
-#. iyE5E
+#. BWgpN
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id521596554849185\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name used to store the new database in the databases register. When = \"\" (default), no registration takes place. If the name already exists it is overwritten without warning."
+msgid "<emph>registrationname</emph> : The name used to store the new database in the databases register. When = \"\" (default), no registration takes place. If the name already exists it is overwritten without warning."
msgstr ""
-#. A9gBj
+#. XkY2F
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id361620323808010\n"
+"help.text"
+msgid "myBase = svcUI.CreateBaseDocument(r\"C:\\Databases\\MyBaseFile.odb\", \"FIREBIRD\")"
+msgstr ""
+
+#. GtB5n
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id651588521753997\n"
"help.text"
-msgid "Create a new LibreOffice document of a given type or based on a given template. The method returns a document object."
+msgid "Create a new %PRODUCTNAME document of a given type or based on a given template. The method returns a document object."
msgstr ""
-#. CC8kd
+#. 2rUeD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id51588521753302\n"
"help.text"
-msgid "<emph>DocumentType</emph> : \"Calc\", \"Writer\", etc. If absent, the <literal>TemplateFile</literal> argument must be present."
+msgid "<emph>documenttype</emph> : \"Calc\", \"Writer\", etc. If absent, the <literal>TemplateFile</literal> argument must be present."
msgstr ""
-#. 2DPGC
+#. BQ6UD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id401588522663325\n"
"help.text"
-msgid "<emph>TemplateFile</emph> : The full <literal>FileName</literal> of the template to build the new document on. If the file does not exist, the argument is ignored. The \"FileSystem\" service provides the <literal>TemplatesFolder</literal> and <literal>UserTemplatesFolder</literal> properties to help to build the argument."
+msgid "<emph>templatefile</emph> : The full <literal>FileName</literal> of the template to build the new document on. If the file does not exist, the argument is ignored. The <literal>FileSystem</literal> service provides the <literal>TemplatesFolder</literal> and <literal>UserTemplatesFolder</literal> properties to help to build the argument."
msgstr ""
-#. JFB9W
+#. VeNQg
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id131588522824366\n"
"help.text"
-msgid "<emph>Hidden</emph>: if <literal>True</literal>, open the new document in the background (default = False). To use with caution: activation or closure afterwards can only happen programmatically."
+msgid "<emph>hidden</emph>: if <literal>True</literal>, open the new document in the background (default = <literal>False</literal>). To use with caution: activation or closure afterwards can only happen programmatically."
+msgstr ""
+
+#. gWFt9
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id701620762417802\n"
+"help.text"
+msgid "In both examples below, the first call to <literal>CreateDocument</literal> method creates a blank Calc document, whereas the second creates a document from a template file."
msgstr ""
#. W3qxn
@@ -20815,13 +21157,22 @@ msgctxt ""
msgid "Returns a document object referring to either the active window or the given window."
msgstr ""
-#. hD23E
+#. hZmVw
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id851588520551368\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: See the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is used."
+msgstr ""
+
+#. AAjDB
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id521620330287071\n"
+"help.text"
+msgid "To access the name of the currently active window, refer to the <literal>ActiveWindow</literal> property."
msgstr ""
#. CYsyC
@@ -20833,13 +21184,13 @@ msgctxt ""
msgid "Maximizes the active window or the given window."
msgstr ""
-#. G2hSo
+#. hD4TC
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id951587986441954\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above. If the argument is absent, the active window is maximized."
+msgid "<emph>windowname</emph>: see the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is maximized."
msgstr ""
#. vzDdG
@@ -20851,121 +21202,130 @@ msgctxt ""
msgid "Minimizes the active window or the given window."
msgstr ""
-#. snQ6b
+#. Enys5
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id751587986592626\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above. If the argument is absent, the active window is minimized."
+msgid "<emph>windowname</emph>: see the definitions <link href=\"text/sbasic/shared/03/sf_ui.xhp#WindowName\" name=\"WindowName section\">above</link>. If this argument is absent, the active window is minimized."
msgstr ""
-#. tmxLS
+#. WHDDQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id691596555746539\n"
"help.text"
-msgid "Open an existing LibreOffice Base document. The method returns a document object."
+msgid "Open an existing %PRODUCTNAME Base document. The method returns a document object."
msgstr ""
-#. RERE5
+#. yGPbD
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id231596555746385\n"
"help.text"
-msgid "<emph>FileName</emph> : Identifies the file to open. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
+msgid "<emph>filename</emph> : Identifies the file to open. It must follow the SF_FileSystem.FileNaming notation. If the file already exists, it is overwritten without warning"
msgstr ""
-#. xE2FY
+#. DBB9u
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id711596555746281\n"
"help.text"
-msgid "<emph>RegistrationName</emph> : The name to use to find the database in the databases register. It is ignored if <literal>FileName</literal> <> \"\"."
+msgid "<emph>registrationname</emph> : The name to use to find the database in the databases register. It is ignored if <literal>FileName</literal> <> \"\"."
msgstr ""
-#. u4Erc
+#. TqAd2
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"id721596556313545\n"
"help.text"
-msgid "<emph>MacroExecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
+msgid "<emph>macroexecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
msgstr ""
-#. szffG
+#. Dok5e
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id941620762989833\n"
+"help.text"
+msgid "To improve code readability you can use <link href=\"text/sbasic/shared/03/sf_ui.xhp#Constants\" name=\"CHANGE ME\">predefined constants</link> for the <literal>macroexecution</literal> argument, as in the examples above."
+msgstr ""
+
+#. LBgGQ
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id541588523635283\n"
"help.text"
-msgid "Open an existing LibreOffice document with the given options. Returns a document object or one of its subclasses or <literal>Null</literal> if the opening failed, including when due to a user decision."
+msgid "Opens an existing %PRODUCTNAME document with the given options. Returns a document object or one of its subclasses. The method returns <literal>Nothing</literal> (in Basic) / <literal>None</literal> (in Python) if the opening failed, even when the failure is caused by a user decision."
msgstr ""
-#. dZF95
+#. 8tjbg
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id481588523635890\n"
"help.text"
-msgid "<emph>FileName</emph>: Identifies the file to open. It must follow the <literal>FileNaming</literal> notation of the <literal>FileSystem</literal> service."
+msgid "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>FileNaming</literal> notation of the <literal>FileSystem</literal> service."
msgstr ""
-#. NRyuH
+#. PWvQz
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id451588523635507\n"
"help.text"
-msgid "<emph>Password</emph>: To use when the document is protected. If wrong or absent while the document is protected, the user will be prompted to enter a password."
+msgid "<emph>password</emph>: To use when the document is protected. If wrong or absent while the document is protected, the user will be prompted to enter a password."
msgstr ""
-#. hZkGG
+#. 2jjFK
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id611588524329781\n"
"help.text"
-msgid "<emph>ReadOnly</emph>: Default = <literal>False</literal>."
+msgid "<emph>readonly</emph>: Default = <literal>False</literal>."
msgstr ""
-#. Hhywx
+#. BcyEp
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id641588523635497\n"
"help.text"
-msgid "<emph>Hidden</emph>: if <literal>True</literal>, open the new document in the background (default = False). To use with caution: activation or closure afterwards can only happen programmatically."
+msgid "<emph>hidden</emph>: if <literal>True</literal>, open the new document in the background (default = <literal>False</literal>). To use with caution: activation or closure afterwards can only happen programmatically."
msgstr ""
-#. VPmyv
+#. sbgeH
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id981588524474719\n"
"help.text"
-msgid "<emph>MacroExecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
+msgid "<emph>macroexecution</emph>: 0 = behaviour is defined by the user configuration, 1 = macros are not executable, 2 = macros are executable."
msgstr ""
-#. KBCtV
+#. AF7iF
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id611588524584693\n"
"help.text"
-msgid "<emph>FilterName</emph>: The name of a filter that should be used for loading the document. If present, the filter must exist."
+msgid "<emph>filtername</emph>: The name of a filter that should be used for loading the document. If present, the filter must exist."
msgstr ""
-#. 6rbcm
+#. MKueU
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id191588524634348\n"
"help.text"
-msgid "<emph>FilterOptions</emph>: An optional string of options associated with the filter."
+msgid "<emph>filteroptions</emph>: An optional string of options associated with the filter."
msgstr ""
#. qMTrj
@@ -20977,31 +21337,49 @@ msgctxt ""
msgid "Resizes and/or moves the active window. Absent and negative arguments are ignored. If the window is minimized or maximized, calling <literal>Resize</literal> without arguments restores it."
msgstr ""
-#. SxjEP
+#. 6NUcv
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441587986945696\n"
"help.text"
-msgid "<emph>Left, Top</emph>: Distances of the top-left corner from top and left edges of the screen."
+msgid "<emph>left, top</emph>: Distances of the top-left corner from top and left edges of the screen, in pixels."
msgstr ""
-#. ne7hx
+#. AdcjG
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id601587987453825\n"
"help.text"
-msgid "<emph>Width, Height</emph>: New dimensions of the window."
+msgid "<emph>width, height</emph>: New dimensions of the window, in pixels."
+msgstr ""
+
+#. vDNVH
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"par_id801587987507028\n"
+"help.text"
+msgid "In the following examples, the <literal>width</literal> and <literal>height</literal> of the window are changed while <literal>top</literal> and <literal>left</literal> are left unchanged."
+msgstr ""
+
+#. 7HuAE
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id971620331945744\n"
+"help.text"
+msgid "svcUI.Resize(width = 500, height = 500)"
msgstr ""
-#. 4UBqz
+#. HP2Jb
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
-"bas_id801587987507028\n"
+"par_id21620332301809\n"
"help.text"
-msgid "' Top and Height are left unchanged"
+msgid "To resize a window that is not active, first activate it using the <literal>Activate</literal> method."
msgstr ""
#. NnBWM
@@ -21013,58 +21391,130 @@ msgctxt ""
msgid "Display a text and a progressbar in the status bar of the active window. Any subsequent calls in the same macro run refer to the same status bar of the same window, even if the window is not visible anymore. A call without arguments resets the status bar to its normal state."
msgstr ""
-#. dKTqd
+#. rDr2L
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id71587996421829\n"
"help.text"
-msgid "<emph>Text</emph>: An optional text to be displayed in front of the progress bar."
+msgid "<emph>text</emph>: An optional text to be displayed in front of the progress bar."
msgstr ""
-#. WuBNx
+#. hbCpG
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id881587996421777\n"
"help.text"
-msgid "<emph>Percentage</emph>: an optional degree of progress between 0 and 100."
+msgid "<emph>percentage</emph>: an optional degree of progress between 0 and 100."
msgstr ""
-#. DBbfU
+#. qbGdy
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id651620332601083\n"
+"help.text"
+msgid "' Resets the statusbar"
+msgstr ""
+
+#. venZk
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id631620332653004\n"
+"help.text"
+msgid "from time import sleep"
+msgstr ""
+
+#. AQ57P
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id351620332422330\n"
+"help.text"
+msgid "for i in range(101):"
+msgstr ""
+
+#. uUDVJ
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id261620332627647\n"
+"help.text"
+msgid "svcUI.SetStatusbar(\"Test:\", i)"
+msgstr ""
+
+#. qWafN
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id181620332715974\n"
+"help.text"
+msgid "sleep(0.05)"
+msgstr ""
+
+#. PgCrS
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id381620332733373\n"
+"help.text"
+msgid "svcUI.SetStatusbar()"
+msgstr ""
+
+#. oQfWc
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id571598864255776\n"
"help.text"
-msgid "Display a non-modal dialog box. Specify its title, an explicatory text and a percentage of progress represented on a progressbar. The box will remain visible until a call to the method without argument, or until the end of the currently running macro."
+msgid "Displays a non-modal dialog box. Specify its title, an explicatory text and a percentage of progress to be represented on a progressbar. The dialog will remain visible until a call to the method without arguments or until the user manually closes the dialog."
msgstr ""
-#. B27Bg
+#. drhV6
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id441598864535695\n"
"help.text"
-msgid "<emph>Title</emph> : The title appearing on top of the dialog box. Default = \"ScriptForge\"."
+msgid "<emph>title</emph> : The title appearing on top of the dialog box. Default = \"ScriptForge\"."
msgstr ""
-#. 6pZKs
+#. jvrZV
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id311598864255297\n"
"help.text"
-msgid "<emph>Text</emph>: An optional text to be displayed above the progress bar."
+msgid "<emph>text</emph>: An optional text to be displayed above the progress bar."
msgstr ""
-#. FV2pm
+#. Qj3N3
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id881598864255424\n"
"help.text"
-msgid "<emph>Percentage</emph>: an optional degree of progress between 0 and 100."
+msgid "<emph>percentage</emph>: an optional degree of progress between 0 and 100."
+msgstr ""
+
+#. rVBX3
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"bas_id651620333289753\n"
+"help.text"
+msgid "' Closes the Progress Bar window"
+msgstr ""
+
+#. u3gZ8
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id761620333269236\n"
+"help.text"
+msgid "# Closes the Progress Bar window"
msgstr ""
#. ZEG6t
@@ -21076,11 +21526,29 @@ msgctxt ""
msgid "Returns <literal>True</literal> if the given window could be identified."
msgstr ""
-#. aAKnF
+#. rkJbT
#: sf_ui.xhp
msgctxt ""
"sf_ui.xhp\n"
"par_id45158858711917\n"
"help.text"
-msgid "<emph>WindowName</emph>: see the definitions above."
+msgid "<emph>windowname</emph>: see the definitions above."
+msgstr ""
+
+#. F7ntw
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id441620333481074\n"
+"help.text"
+msgid "if svcUI.WindowExists(r\"C:\\Document\\My file.odt\"):"
+msgstr ""
+
+#. nLT8F
+#: sf_ui.xhp
+msgctxt ""
+"sf_ui.xhp\n"
+"pyc_id801620333495532\n"
+"help.text"
+msgid "# ..."
msgstr ""
diff --git a/source/pt/helpcontent2/source/text/scalc/01.po b/source/pt/helpcontent2/source/text/scalc/01.po
index e5b92ebcc8f..9bf4cd5cdcf 100644
--- a/source/pt/helpcontent2/source/text/scalc/01.po
+++ b/source/pt/helpcontent2/source/text/scalc/01.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-05-14 14:15+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2021-01-30 10:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/pt/>\n"
@@ -20545,6 +20545,15 @@ msgctxt ""
msgid "<emph>Text</emph> refers to the text from which to remove all non-printable characters."
msgstr "<emph>texto</emph> é o texto do qual se pretende remover todos os caracteres não imprimíveis."
+#. h3UXC
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id581621538151600\n"
+"help.text"
+msgid "<input>=LEN(CLEAN(CHAR(7) & \"LibreOffice Calc\" & CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 (\"BEL\") and U+0008 (\"BS\") characters at the beginning and end of the string argument. CLEAN does not remove spaces."
+msgstr ""
+
#. zdGBJ
#: 04060110.xhp
msgctxt ""
@@ -20815,14 +20824,14 @@ msgctxt ""
msgid "<emph>Decimals</emph> is the optional number of decimal places."
msgstr "<emph>casas_decimais</emph> é o número opcional de casas decimais."
-#. JFmwv
+#. ezXhx
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3153546\n"
"help.text"
-msgid "<item type=\"input\">=DOLLAR(255)</item> returns $255.00."
-msgstr "<item type=\"input\">=MOEDA(255)</item> devolve 255,00 €."
+msgid "<item type=\"input\">=DOLLAR(255)</item> returns $255.00 for the English (USA) locale and USD (dollar) currency; ¥255.00 for the Japanese locale and JPY (yen) currency; or 255,00 € for the German (Germany) locale and EUR (euro) currency."
+msgstr ""
#. 2beTG
#: 04060110.xhp
@@ -27151,806 +27160,14 @@ msgctxt ""
msgid "<item type=\"input\">=OCT2HEX(144;4)</item> returns 0064."
msgstr "<item type=\"input\">=OCTAHEX(144;4)</item> devolve 0064."
-#. JBzHD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"bm_id3148446\n"
-"help.text"
-msgid "<bookmark_value>CONVERT function</bookmark_value>"
-msgstr "<bookmark_value>Função CONVERTER</bookmark_value>"
-
-#. NNzM9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3148446\n"
-"help.text"
-msgid "CONVERT"
-msgstr "CONVERTER"
-
-#. AZ8gE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154902\n"
-"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_CONVERT\">Converts a value from one unit of measure to the corresponding value in another unit of measure.</ahelp> Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l."
-msgstr "<ahelp hid=\"HID_AAI_FUNC_CONVERT\">Converte um valor de uma unidade de medida para o valor correspondente de outra unidade de medida.</ahelp> Introduza as unidades de medida diretamente como texto, entre aspas, ou como referência. Se introduzir as unidades de medida em células, essas unidades de medida deverão corresponder exatamente à seguinte lista, sensível a maiúsculas e minúsculas. Por exemplo, para inserir um l minúsculo (de litro) numa célula, insira o apóstrofo ' imediatamente seguido de l."
-
-#. BWERF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153055\n"
-"help.text"
-msgid "Property"
-msgstr "Propriedade"
-
-#. XTUci
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147234\n"
-"help.text"
-msgid "Units"
-msgstr "Unidades"
-
-#. cMJxt
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147512\n"
-"help.text"
-msgid "Weight"
-msgstr "Peso"
-
-#. iBfK5
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148476\n"
-"help.text"
-msgid "<emph>g</emph>, sg, lbm, <emph>u</emph>, ozm, stone, ton, grain, pweight, hweight, shweight, brton"
-msgstr "<emph>g</emph>, sg, lbm, <emph>u</emph>, ozm, stone, ton, grain, pweight, hweight, shweight, brton"
-
-#. GaiAA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3155361\n"
-"help.text"
-msgid "Length"
-msgstr "Comprimento"
-
-#. AYaEj
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148925\n"
-"help.text"
-msgid "<emph>m</emph>, mi, Nmi, in, ft, yd, ang, Pica, ell, <emph>parsec</emph>, <emph>lightyear</emph>, survey_mi"
-msgstr "<emph>m</emph>, mi, Nmi, in, ft, yd, ang, Pica, ell, <emph>parsec</emph>, <emph>lightyear</emph>, survey_mi"
-
-#. CSY6D
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3158429\n"
-"help.text"
-msgid "Time"
-msgstr "Hora"
-
-#. CRKWs
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150707\n"
-"help.text"
-msgid "yr, day, hr, mn, <emph>sec</emph>, <emph>s</emph>"
-msgstr "ano, dia, hr, mn, <emph>seg</emph>, <emph>s</emph>"
-
-#. jRyCG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153238\n"
-"help.text"
-msgid "Pressure"
-msgstr "Pressão"
-
-#. 2Bw2Y
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3166437\n"
-"help.text"
-msgid "<emph>Pa</emph>, <emph>atm</emph>, <emph>at</emph>, <emph>mmHg</emph>, Torr, psi"
-msgstr "<emph>Pa</emph>, <emph>atm</emph>, <emph>at</emph>, <emph>mmHg</emph>, Torr, psi"
-
-#. eDDQG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3152944\n"
-"help.text"
-msgid "Force"
-msgstr "Força"
-
-#. UfKga
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3155582\n"
-"help.text"
-msgid "<emph>N</emph>, <emph>dyn</emph>, <emph>dy</emph>, lbf, <emph>pond</emph>"
-msgstr "<emph>N</emph>, <emph>dyn</emph>, <emph>dy</emph>, lbf, <emph>pond</emph>"
-
-#. nDfkL
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153686\n"
-"help.text"
-msgid "Energy"
-msgstr "Energia"
-
-#. T8CAw
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153386\n"
-"help.text"
-msgid "<emph>J</emph>, <emph>e</emph>, <emph>c</emph>, <emph>cal</emph>, <emph>eV</emph>, <emph>ev</emph>, HPh, <emph>Wh</emph>, <emph>wh</emph>, flb, BTU, btu"
-msgstr "<emph>J</emph>, <emph>e</emph>, <emph>c</emph>, <emph>cal</emph>, <emph>eV</emph>, <emph>ev</emph>, HPh, <emph>Wh</emph>, <emph>wh</emph>, flb, BTU, btu"
-
-#. RkeAo
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154100\n"
-"help.text"
-msgid "Power"
-msgstr "Potência"
-
-#. RAPGk
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149915\n"
-"help.text"
-msgid "<emph>W</emph>, <emph>w</emph>, HP, PS"
-msgstr "<emph>W</emph>, <emph>w</emph>, HP, PS"
-
-#. FRDaq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148988\n"
-"help.text"
-msgid "Field strength"
-msgstr "Força de campo"
-
-#. YKEEF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148616\n"
-"help.text"
-msgid "<emph>T</emph>, <emph>ga</emph>"
-msgstr "<emph>T</emph>, <emph>ga</emph>"
-
-#. rxAYG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3151120\n"
-"help.text"
-msgid "Temperature"
-msgstr "Temperatura"
-
-#. V3XFM
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148659\n"
-"help.text"
-msgid "C, F, <emph>K</emph>, <emph>kel</emph>, Reau, Rank"
-msgstr "C, F, <emph>K</emph>, <emph>kel</emph>, Reau, Rank"
-
-#. AF455
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154610\n"
-"help.text"
-msgid "Volume"
-msgstr "Volume"
-
-#. zv7qN
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149423\n"
-"help.text"
-msgid "<emph>l</emph>, <emph>L</emph>, <emph>lt</emph>, tsp, tbs, oz, cup, pt, us_pt, qt, gal, <emph>m3</emph>, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass"
-msgstr "<emph>l</emph>, <emph>L</emph>, <emph>lt</emph>, tsp, tbs, oz, cup, pt, us_pt, qt, gal, <emph>m3</emph>, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass"
-
-#. YpiAY
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149244\n"
-"help.text"
-msgid "Area"
-msgstr "Área"
-
-#. 6EDBv
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150425\n"
-"help.text"
-msgid "<emph>m2</emph>, mi2, Nmi2, in2, ft2, yd2, <emph>ang2</emph>, Pica2, Morgen, <emph>ar</emph>, acre, ha"
-msgstr "<emph>m2</emph>, mi2, Nmi2, in2, ft2, yd2, <emph>ang2</emph>, Pica2, Morgen, <emph>ar</emph>, acre, ha"
-
-#. MdUET
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150629\n"
-"help.text"
-msgid "Speed"
-msgstr "Velocidade"
-
-#. oUP4X
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3159246\n"
-"help.text"
-msgid "<emph>m/s</emph>, <emph>m/sec</emph>, m/h, mph, kn, admkn"
-msgstr "<emph>m/s</emph>, <emph>m/sec</emph>, m/h, mph, kn, admkn"
-
-#. fSWsq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150789\n"
-"help.text"
-msgid "Information"
-msgstr "Informação"
-
-#. UTUhA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3159899\n"
-"help.text"
-msgid "<emph>bit</emph>, <emph>byte</emph>"
-msgstr "<emph>bit</emph>, <emph>byte</emph>"
-
-#. 8WZyq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3143277\n"
-"help.text"
-msgid "Units of measure in <emph>bold</emph> can be preceded by a prefix character from the following list:"
-msgstr "As unidades de medida em <emph>negrito</emph> podem ser precedidas por um caractere de prefixo da lista seguinte:"
-
-#. YBQYC
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148422\n"
-"help.text"
-msgid "Prefix"
-msgstr "Prefixo"
-
-#. vzHyG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148423\n"
-"help.text"
-msgid "Multiplier"
-msgstr "Multiplicador"
-
-#. y8Bch
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149490\n"
-"help.text"
-msgid "Y (yotta)"
-msgstr "Y (yota)"
-
-#. YE3Bo
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149931\n"
-"help.text"
-msgid "10^24"
-msgstr "10^24"
-
-#. Vst48
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149491\n"
-"help.text"
-msgid "Z (zetta)"
-msgstr "Z (zeta)"
-
-#. cBpwF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149932\n"
-"help.text"
-msgid "10^21"
-msgstr "10^21"
-
-#. sVmhZ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149492\n"
-"help.text"
-msgid "E (exa)"
-msgstr "E (exa)"
-
-#. DCgjD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149933\n"
-"help.text"
-msgid "10^18"
-msgstr "10^18"
-
-#. odrAJ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149493\n"
-"help.text"
-msgid "P (peta)"
-msgstr "P (peta)"
-
-#. HnJBh
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149934\n"
-"help.text"
-msgid "10^15"
-msgstr "10^15"
-
-#. 6SoPA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149494\n"
-"help.text"
-msgid "T (tera)"
-msgstr "T (tera)"
-
-#. cgqVx
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149935\n"
-"help.text"
-msgid "10^12"
-msgstr "10^12"
-
-#. Ki9Ca
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149495\n"
-"help.text"
-msgid "G (giga)"
-msgstr "G (giga)"
-
-#. jMqL9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149936\n"
-"help.text"
-msgid "10^9"
-msgstr "10^9"
-
-#. YD6i5
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149496\n"
-"help.text"
-msgid "M (mega)"
-msgstr "M (mega)"
-
-#. 4vqCG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149937\n"
-"help.text"
-msgid "10^6"
-msgstr "10^6"
-
-#. 6WGVB
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "k (kilo)"
-msgstr "k (quilo)"
-
-#. wBWRS
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149938\n"
-"help.text"
-msgid "10^3"
-msgstr "10^3"
-
-#. G2FDE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149498\n"
-"help.text"
-msgid "h (hecto)"
-msgstr "h (hecto)"
-
-#. 9UYSz
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149939\n"
-"help.text"
-msgid "10^2"
-msgstr "10^2"
-
-#. woVg4
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149499\n"
-"help.text"
-msgid "e (deca)"
-msgstr "e (deca)"
-
-#. iiAPq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149940\n"
-"help.text"
-msgid "10^1"
-msgstr "10^1"
-
-#. C7sNq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149500\n"
-"help.text"
-msgid "d (deci)"
-msgstr "d (deci)"
-
-#. eQehn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3143940\n"
-"help.text"
-msgid "10^-1"
-msgstr "10^-1"
-
-#. EUm9F
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149501\n"
-"help.text"
-msgid "c (centi)"
-msgstr "c (centi)"
-
-#. FDbBr
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149941\n"
-"help.text"
-msgid "10^-2"
-msgstr "10^-2"
-
-#. G48jP
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149502\n"
-"help.text"
-msgid "m (milli)"
-msgstr "m (milli)"
-
-#. uUT75
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149942\n"
-"help.text"
-msgid "10^-3"
-msgstr "10^-3"
-
-#. LTWEh
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149503\n"
-"help.text"
-msgid "u (micro)"
-msgstr "u (micro)"
-
-#. cvaeu
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149943\n"
-"help.text"
-msgid "10^-6"
-msgstr "10^-6"
-
-#. GD6Gw
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149504\n"
-"help.text"
-msgid "n (nano)"
-msgstr "n (nano)"
-
-#. 38rEb
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149944\n"
-"help.text"
-msgid "10^-9"
-msgstr "10^-9"
-
-#. FiDAM
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149505\n"
-"help.text"
-msgid "p (pico)"
-msgstr "p (pico)"
-
-#. 9sGcA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149945\n"
-"help.text"
-msgid "10^-12"
-msgstr "10^-12"
-
-#. SMnpF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149506\n"
-"help.text"
-msgid "f (femto)"
-msgstr "f (femto)"
-
-#. cqsCH
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149946\n"
-"help.text"
-msgid "10^-15"
-msgstr "10^-15"
-
-#. Fj46E
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149507\n"
-"help.text"
-msgid "a (atto)"
-msgstr "a (atto)"
-
-#. qtV59
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149947\n"
-"help.text"
-msgid "10^-18"
-msgstr "10^-18"
-
-#. ZxxnU
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149508\n"
-"help.text"
-msgid "z (zepto)"
-msgstr "z (zepto)"
-
-#. GWC7A
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149948\n"
-"help.text"
-msgid "10^-21"
-msgstr "10^-21"
-
-#. cTLp9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149509\n"
-"help.text"
-msgid "y (yocto)"
-msgstr "y (yocto)"
-
-#. KAARJ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149949\n"
-"help.text"
-msgid "10^-24"
-msgstr "10^-24"
-
-#. UVavE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903061174\n"
-"help.text"
-msgid "Information units \"bit\" and \"byte\" may also be prefixed by one of the following IEC 60027-2 / IEEE 1541 prefixes:"
-msgstr "As unidades de informação \"bit\" e \"byte\" também podem ser prefixadas por um dos seguintes prefixos IEC 60027-2 / IEEE 1541:"
-
-#. DZhKD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090966\n"
-"help.text"
-msgid "ki kibi 1024"
-msgstr "ki kibi 1024"
-
-#. K3qEd
+#. AXDcg
#: 04060116.xhp
msgctxt ""
"04060116.xhp\n"
-"par_id0908200903090958\n"
+"hd_id14741462320147\n"
"help.text"
-msgid "Mi mebi 1048576"
-msgstr "Mi mebi 1048576"
-
-#. dBFMg
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090936\n"
-"help.text"
-msgid "Gi gibi 1073741824"
-msgstr "Gi gibi 1073741824"
-
-#. 9RnhS
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090975\n"
-"help.text"
-msgid "Ti tebi 1099511627776"
-msgstr "Ti tebi 1099511627776"
-
-#. 39Jpn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090930\n"
-"help.text"
-msgid "Pi pebi 1125899906842620"
-msgstr "Pi pebi 1125899906842620"
-
-#. GkAoP
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091070\n"
-"help.text"
-msgid "Ei exbi 1152921504606850000"
-msgstr "Ei exbi 1152921504606850000"
-
-#. GTGuN
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091097\n"
-"help.text"
-msgid "Zi zebi 1180591620717410000000"
-msgstr "Zi zebi 1180591620717410000000"
-
-#. QbEGb
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091010\n"
-"help.text"
-msgid "Yi yobi 1208925819614630000000000"
-msgstr "Yi yobi 1208925819614630000000000"
-
-#. RpFzc
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153695\n"
-"help.text"
-msgid "CONVERT(Number; \"FromUnit\"; \"ToUnit\")"
-msgstr "CONVERTER(número; \"da_unidade\"; \"para_unidade\")"
-
-#. f822K
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147522\n"
-"help.text"
-msgid "<emph>Number</emph> is the number to be converted."
-msgstr "<emph>número</emph> é o número a converter."
-
-#. m8taC
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154472\n"
-"help.text"
-msgid "<emph>FromUnit</emph> is the unit from which conversion is taking place."
-msgstr "<emph>da_unidade</emph> é a unidade de medida do número a converter."
-
-#. TAaks
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153790\n"
-"help.text"
-msgid "<emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type."
-msgstr "<emph>para_unidade</emph> é a unidade de medida do resultado. As duas unidades têm de ser do mesmo tipo."
-
-#. pbZjW
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3156336\n"
-"help.text"
-msgid "<item type=\"input\">=CONVERT(10;\"HP\";\"PS\") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS."
-msgstr "<item type=\"input\">=CONVERTER(10;\"HP\";\"PS\") </item>devolve 10,14 arredondado a duas casas decimais. Isto é, 10 HP equivalem a 10,14 PS."
-
-#. R3Ucn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154834\n"
-"help.text"
-msgid "<item type=\"input\">=CONVERT(10;\"km\";\"mi\") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3."
-msgstr "<item type=\"input\">=CONVERTER(10;\"km\";\"mi\") </item>devolve 6,21 arredondado a duas casas decimais. Isto é, 10 quilómetros equivalem a 6,21 milhas. O k é o carácter de prefixo permitido para o fator 10^3."
+msgid "<embedvar href=\"text/scalc/01/func_convert.xhp#convert_head\"/>"
+msgstr ""
#. G7UNe
#: 04060116.xhp
@@ -49543,14 +48760,14 @@ msgctxt ""
msgid "AutoFilter"
msgstr "Filtro automático"
-#. ZGJfP
+#. pGfbC
#: 12040100.xhp
msgctxt ""
"12040100.xhp\n"
"hd_id3153541\n"
"help.text"
-msgid "<link href=\"text/scalc/01/12040100.xhp\" name=\"AutoFilter\">AutoFilter</link>"
-msgstr "<link href=\"text/scalc/01/12040100.xhp\" name=\"AutoFilter\">Filtro automático</link>"
+msgid "<variable id=\"autofilterh1\"><link href=\"text/scalc/01/12040100.xhp\" name=\"AutoFilter\">AutoFilter</link></variable>"
+msgstr ""
#. cTu3x
#: 12040100.xhp
@@ -49561,6 +48778,240 @@ msgctxt ""
msgid "<ahelp hid=\".uno:DataFilterAutoFilter\">Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.</ahelp>"
msgstr "<ahelp hid=\".uno:DataFilterAutoFilter\">Filtra automaticamente o intervalo de células selecionado e cria caixas de lista de uma linha, nas quais poderá escolher os itens que pretende mostrar.</ahelp>"
+#. c9BGE
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id101621534096986\n"
+"help.text"
+msgid "Sort Ascending"
+msgstr ""
+
+#. u7XHt
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id31621544435954\n"
+"help.text"
+msgid "Displays the rows of the cell range in ascending order, based on the values in the cells of the current column."
+msgstr ""
+
+#. 6Q8nn
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id561621534101425\n"
+"help.text"
+msgid "Sort Descending"
+msgstr ""
+
+#. CbVJm
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id861621544431393\n"
+"help.text"
+msgid "Displays the rows of the cell range in descending order, based on the values in the cells of the current column."
+msgstr ""
+
+#. sHhH3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id401621534105620\n"
+"help.text"
+msgid "Top 10"
+msgstr ""
+
+#. onMjn
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id341621544426925\n"
+"help.text"
+msgid "Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown."
+msgstr ""
+
+#. 4oiCy
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id541621534109912\n"
+"help.text"
+msgid "Empty"
+msgstr ""
+
+#. i3DFZ
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id941621544422352\n"
+"help.text"
+msgid "Displays only the rows of the cell range that have an empty cell in the current column."
+msgstr ""
+
+#. s26iT
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id821621534116893\n"
+"help.text"
+msgid "Not Empty"
+msgstr ""
+
+#. GCBF5
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id71621544418559\n"
+"help.text"
+msgid "Displays only the rows of the cell range that have a non-empty cell in the current column."
+msgstr ""
+
+#. s5KFC
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id271621534120995\n"
+"help.text"
+msgid "Text color"
+msgstr ""
+
+#. CCGqV
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id691621544414646\n"
+"help.text"
+msgid "Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected."
+msgstr ""
+
+#. pdme8
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id151621534125831\n"
+"help.text"
+msgid "Background color"
+msgstr ""
+
+#. dzEhB
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id491621544410605\n"
+"help.text"
+msgid "Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected."
+msgstr ""
+
+#. wCDB5
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id851621534131430\n"
+"help.text"
+msgid "Standard Filter"
+msgstr ""
+
+#. kqqrX
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id171621544405886\n"
+"help.text"
+msgid "Opens the <link href=\"text/shared/02/12090000.xhp\" name=\"standard filter\">Standard Filter</link> dialog."
+msgstr ""
+
+#. bbVTh
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id551621534136181\n"
+"help.text"
+msgid "Search text box"
+msgstr ""
+
+#. XeGD3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id421621544399700\n"
+"help.text"
+msgid "Search for a specific entry in the list of values found in the current column. As characters are typed in the text box, this list is updated to show only matching entries."
+msgstr ""
+
+#. igezW
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id581621534140892\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. F52s3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id641621544394836\n"
+"help.text"
+msgid "Click once to select to show all rows and click again to select to hide all rows."
+msgstr ""
+
+#. EADGt
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id731621534146408\n"
+"help.text"
+msgid "Show only current"
+msgstr ""
+
+#. FURWe
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id71621544390147\n"
+"help.text"
+msgid "Display only rows containing the value highlighted in the <emph>Value</emph> box."
+msgstr ""
+
+#. ovQAm
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id11621534151081\n"
+"help.text"
+msgid "Hide only current"
+msgstr ""
+
+#. EJgvW
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id491621544384770\n"
+"help.text"
+msgid "Hide all rows containing the value highlighted in the <emph>Value</emph> box and display all other rows."
+msgstr ""
+
+#. kVCCi
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id621621534155662\n"
+"help.text"
+msgid "Values"
+msgstr ""
+
+#. AzWUy
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id331621544378745\n"
+"help.text"
+msgid "List of unique values found in the current column."
+msgstr ""
+
#. 4DAJx
#: 12040100.xhp
msgctxt ""
@@ -55591,6 +55042,33 @@ msgctxt ""
msgid "Examples"
msgstr "Exemplos"
+#. jug32
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"hd_id980889808897165\n"
+"help.text"
+msgid "Returns"
+msgstr ""
+
+#. 5MoDd
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id631556228511025\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. qKsBn
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id631556228544875\n"
+"help.text"
+msgid "No"
+msgstr ""
+
#. RGGDw
#: ful_func.xhp
msgctxt ""
@@ -57526,6 +57004,1752 @@ msgctxt ""
msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\" name=\"concatenate\">CONCATENATE</link>"
msgstr ""
+#. A2RFP
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"tit\n"
+"help.text"
+msgid "CONVERT function"
+msgstr ""
+
+#. wHx2Y
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"bm_id3148446\n"
+"help.text"
+msgid "<bookmark_value>CONVERT function</bookmark_value>"
+msgstr ""
+
+#. XE5M9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id9522389625800\n"
+"help.text"
+msgid "<variable id=\"convert_head\"> <link href=\"text/scalc/01/func_convert.xhp\">CONVERT</link> </variable> function"
+msgstr ""
+
+#. fmXAR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154902\n"
+"help.text"
+msgid "<ahelp hid=\"HID_AAI_FUNC_CONVERT\"><variable id=\"convert_desc\">Converts a value from one unit of measurement to the corresponding value in another unit of measurement.</variable></ahelp> Enter the units of measurement directly as text in quotation marks or as a reference. The units of measurement specified through the arguments must match the supported unit symbols, which are case-sensitive. For example, the symbol for the unit \"newton\" is the uppercase \"N\"."
+msgstr ""
+
+#. fUwa3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id761620414839890\n"
+"help.text"
+msgid "The measurement units recognized by <literal>CONVERT</literal> fall into 13 groups, which are listed <link href=\"text/scalc/01/func_convert.xhp#Unit_Groups\" name=\"Unit_Groups_Section\">below</link>. CONVERT will perform conversions between any two units within one group but reject any request to convert between units in different groups."
+msgstr ""
+
+#. x6USE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id861620428840333\n"
+"help.text"
+msgid "You can also add binary and decimal prefixes to units of measurement that support them. The list of all prefixes and their corresponding multipliers are shown <link href=\"text/scalc/01/func_convert.xhp#Prefixes\" name=\"Prefixes_Section\">below</link>."
+msgstr ""
+
+#. GvB7m
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id601621101375988\n"
+"help.text"
+msgid "This function may not be compatible with other spreadsheet software."
+msgstr ""
+
+#. wfq9t
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id23219159944266\n"
+"help.text"
+msgid "<input>CONVERT(Number; FromUnit; ToUnit)</input>"
+msgstr ""
+
+#. RiLFj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3147522\n"
+"help.text"
+msgid "<emph>Number</emph> is the number to be converted."
+msgstr ""
+
+#. GErYL
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154472\n"
+"help.text"
+msgid "<emph>FromUnit</emph> is the unit from which conversion is taking place."
+msgstr ""
+
+#. d2Hrk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3153790\n"
+"help.text"
+msgid "<emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type."
+msgstr ""
+
+#. 7D2db
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id541620414925560\n"
+"help.text"
+msgid "If <literal>FromUnit</literal> and <literal>ToUnit</literal> are not valid units from the same group, then <literal>CONVERT</literal> reports an invalid argument error (Err:502)."
+msgstr ""
+
+#. gq5EJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3156336\n"
+"help.text"
+msgid "<input>=CONVERT(-10; \"C\"; \"F\")</input>"
+msgstr ""
+
+#. NacDF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id951620413562988\n"
+"help.text"
+msgid "Here the function converts -10 degrees Celsius to degrees Fahrenheit, returning the value 14. There is not a simple multiplicative relationship between temperature units, as different reference points are used. Hence, as in this case, an input negative number may be converted to a positive value."
+msgstr ""
+
+#. CQPne
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154834\n"
+"help.text"
+msgid "<input>=CONVERT(3.5; \"mi\"; \"yd\")</input>"
+msgstr ""
+
+#. xaEX2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id971620413678102\n"
+"help.text"
+msgid "Here the function converts 3.5 international miles to yards, returning the value 6160. Both units are in the Length and distance group."
+msgstr ""
+
+#. 3GMEy
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id741620413834726\n"
+"help.text"
+msgid "<input>=CONVERT(256; \"Gibit\"; \"Mibyte\")</input>"
+msgstr ""
+
+#. pdEtf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id261620413900652\n"
+"help.text"
+msgid "Here the function converts 256 gigibits to mebibytes, returning the value 32768. Both units (bit and byte) are in the Information group and support binary prefixes."
+msgstr ""
+
+#. cdqCp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id761620413966496\n"
+"help.text"
+msgid "<input>=CONVERT(1; \"dyn\"; \"e\")</input>"
+msgstr ""
+
+#. vDR5q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id531620414005955\n"
+"help.text"
+msgid "Here the function returns an invalid argument error (Err:502) because the two units (dyne and erg) are in different groups (Force and Energy respectively)."
+msgstr ""
+
+#. DGVq5
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id261620415240175\n"
+"help.text"
+msgid "Units of measurement"
+msgstr ""
+
+#. oxx8A
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id481620428685029\n"
+"help.text"
+msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Beware that conversions can only happen between units that belong to the same group."
+msgstr ""
+
+#. Rd9Fp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id461620429183259\n"
+"help.text"
+msgid "The column Prefix indicates whether or not a given unit of measurement supports <link href=\"text/scalc/01/func_convert.xhp#Prefixes\" name=\"Prefixes_Section\">prefixes</link>."
+msgstr ""
+
+#. ELyFm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id301620415514760\n"
+"help.text"
+msgid "Area"
+msgstr ""
+
+#. JFG6V
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id121620479750266\n"
+"help.text"
+msgid "Some measurement units have more than one accepted symbol. The accepted unit symbols are separated by semicolons in the <emph>Unit symbol</emph> column."
+msgstr ""
+
+#. ngLDk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id831620415562967\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. HMAmG
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id251620415562967\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. tpUMy
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id151620415562967\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. GfiJV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id61620415562967\n"
+"help.text"
+msgid "Square angstrom"
+msgstr ""
+
+#. GoABk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620415903987\n"
+"help.text"
+msgid "Are"
+msgstr ""
+
+#. kahhN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id631620415904448\n"
+"help.text"
+msgid "Square foot"
+msgstr ""
+
+#. MFjkC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id651620415904891\n"
+"help.text"
+msgid "Hectare"
+msgstr ""
+
+#. EohjY
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id561620415905331\n"
+"help.text"
+msgid "Square inch"
+msgstr ""
+
+#. XZ9X3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id561620415905004\n"
+"help.text"
+msgid "Square light-year"
+msgstr ""
+
+#. kwEMV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id781620416024343\n"
+"help.text"
+msgid "Square meter"
+msgstr ""
+
+#. T9BaY
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id731620416024782\n"
+"help.text"
+msgid "Square international mile"
+msgstr ""
+
+#. 4i4iC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id621620416250948\n"
+"help.text"
+msgid "Morgen"
+msgstr ""
+
+#. HF5iU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id661620416251507\n"
+"help.text"
+msgid "Square nautical mile"
+msgstr ""
+
+#. hCiCS
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id791620416251948\n"
+"help.text"
+msgid "Square pica point"
+msgstr ""
+
+#. ZfeRr
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id771620416417874\n"
+"help.text"
+msgid "Square pica"
+msgstr ""
+
+#. cHh2s
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id621620416418311\n"
+"help.text"
+msgid "International acre"
+msgstr ""
+
+#. AsFDV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620416418768\n"
+"help.text"
+msgid "US survey acre"
+msgstr ""
+
+#. vFpVJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620416418025\n"
+"help.text"
+msgid "Square yard"
+msgstr ""
+
+#. Y8KWb
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id661620418842010\n"
+"help.text"
+msgid "Energy"
+msgstr ""
+
+#. MVxwP
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id133389281727763\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. 2YCm2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id215779983443756\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. wERLT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id986783687128923\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. GLvVT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id797688281572156\n"
+"help.text"
+msgid "British thermal unit"
+msgstr ""
+
+#. nu34E
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id844417659281393\n"
+"help.text"
+msgid "Thermochemical calorie"
+msgstr ""
+
+#. DBTz9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id672765982649722\n"
+"help.text"
+msgid "International Steam Table calorie"
+msgstr ""
+
+#. uw6BK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id798492531882282\n"
+"help.text"
+msgid "erg"
+msgstr ""
+
+#. i9qGV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id547247548598782\n"
+"help.text"
+msgid "Electron volt"
+msgstr ""
+
+#. sLtDD
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id587393171297892\n"
+"help.text"
+msgid "Foot-pound"
+msgstr ""
+
+#. 2GjCu
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id695171299238861\n"
+"help.text"
+msgid "Horsepower-hour"
+msgstr ""
+
+#. ZPZRc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id498448587944728\n"
+"help.text"
+msgid "Joule"
+msgstr ""
+
+#. PUrZh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id324829753758823\n"
+"help.text"
+msgid "Watt-hour"
+msgstr ""
+
+#. kPnGq
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id281620418969165\n"
+"help.text"
+msgid "Flux density"
+msgstr ""
+
+#. 4o3NF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id474271648545953\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. DCC5e
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id747764511138273\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. dvVVc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id689379352231556\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. nHMaJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id114822916257326\n"
+"help.text"
+msgid "Gauss"
+msgstr ""
+
+#. 2he9q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id626213287964265\n"
+"help.text"
+msgid "Tesla"
+msgstr ""
+
+#. GFyeu
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id511620419033332\n"
+"help.text"
+msgid "Force"
+msgstr ""
+
+#. CcWkm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id786326578562174\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. MAju2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613697367784781\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 3ZxxK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id338735929142246\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. uaZZL
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id332679599387353\n"
+"help.text"
+msgid "Dyne"
+msgstr ""
+
+#. qkEeo
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id297688664469184\n"
+"help.text"
+msgid "Newton"
+msgstr ""
+
+#. EEy3q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id413835658896999\n"
+"help.text"
+msgid "Pound-force"
+msgstr ""
+
+#. UmY6Y
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id472715992174398\n"
+"help.text"
+msgid "Pond"
+msgstr ""
+
+#. Z8snf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id61620419155285\n"
+"help.text"
+msgid "Information"
+msgstr ""
+
+#. A3brF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id426724696915849\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. ABpR9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id612374956817974\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. kNxR2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id538681812985912\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. uXtLh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id287396172896473\n"
+"help.text"
+msgid "Bit"
+msgstr ""
+
+#. CQcQ9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id288619461492324\n"
+"help.text"
+msgid "Byte"
+msgstr ""
+
+#. B3c96
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id21620419214852\n"
+"help.text"
+msgid "Length and distance"
+msgstr ""
+
+#. rfDue
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id939442657661828\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. t8B7a
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385965635167839\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. qBet6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id783715738435884\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. ED5CD
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id871414798381246\n"
+"help.text"
+msgid "Angstrom"
+msgstr ""
+
+#. pZ2tZ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id667871614381886\n"
+"help.text"
+msgid "Ell"
+msgstr ""
+
+#. FxCjJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id116286449743311\n"
+"help.text"
+msgid "Foot"
+msgstr ""
+
+#. VswTE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id174995614358222\n"
+"help.text"
+msgid "Inch"
+msgstr ""
+
+#. YFTAf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id597477613742668\n"
+"help.text"
+msgid "Light-year"
+msgstr ""
+
+#. aqqG6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id414782652978666\n"
+"help.text"
+msgid "Meter"
+msgstr ""
+
+#. kREck
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id246972715165395\n"
+"help.text"
+msgid "International mile"
+msgstr ""
+
+#. 6TCBR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id664674443288268\n"
+"help.text"
+msgid "Nautical mile"
+msgstr ""
+
+#. rUVPA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id139127915416429\n"
+"help.text"
+msgid "Parsec"
+msgstr ""
+
+#. E8DiA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id343241931577938\n"
+"help.text"
+msgid "Pica point"
+msgstr ""
+
+#. J45F6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id314567699952918\n"
+"help.text"
+msgid "Pica"
+msgstr ""
+
+#. jo6cR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id579641593251685\n"
+"help.text"
+msgid "US survey mile"
+msgstr ""
+
+#. bHo6X
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id247251727323315\n"
+"help.text"
+msgid "Yard"
+msgstr ""
+
+#. EVKqC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id101620426269258\n"
+"help.text"
+msgid "Mass and weight"
+msgstr ""
+
+#. sshNo
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id662733781297324\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. 23Fz6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id314237495552874\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. YXvAc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id543131496247122\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. yS2GB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id163896825569756\n"
+"help.text"
+msgid "Short hundredweight"
+msgstr ""
+
+#. AymnT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id219736221925573\n"
+"help.text"
+msgid "Gram"
+msgstr ""
+
+#. Pcwzj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613363919875679\n"
+"help.text"
+msgid "Grain"
+msgstr ""
+
+#. HfoFq
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id961199633533431\n"
+"help.text"
+msgid "Pound"
+msgstr ""
+
+#. TtiGk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id655456352143671\n"
+"help.text"
+msgid "Ounce"
+msgstr ""
+
+#. pmsEB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613492674545171\n"
+"help.text"
+msgid "Pennyweight"
+msgstr ""
+
+#. BE88d
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id566783887997575\n"
+"help.text"
+msgid "Slug"
+msgstr ""
+
+#. VmfEH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id731498557457276\n"
+"help.text"
+msgid "Stone"
+msgstr ""
+
+#. ZLyGB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id618416327957968\n"
+"help.text"
+msgid "Short ton"
+msgstr ""
+
+#. 4nGTC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id556166667325333\n"
+"help.text"
+msgid "Unified atomic mass unit"
+msgstr ""
+
+#. nA8vE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id161338688697922\n"
+"help.text"
+msgid "Long hundredweight"
+msgstr ""
+
+#. 23HRX
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id616379569614142\n"
+"help.text"
+msgid "Long ton"
+msgstr ""
+
+#. BPqQG
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id1001620426284123\n"
+"help.text"
+msgid "Power"
+msgstr ""
+
+#. HvGBm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id765457372987543\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. DGPtJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id222988613874967\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 6DsPs
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id954629589584711\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. 7PLLh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id578436173796358\n"
+"help.text"
+msgid "Mechanical horsepower"
+msgstr ""
+
+#. M6req
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id418898833841613\n"
+"help.text"
+msgid "Pferdestärke or metric horsepower"
+msgstr ""
+
+#. qyteT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id239893771814786\n"
+"help.text"
+msgid "Watt"
+msgstr ""
+
+#. PGKCa
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id541620426359069\n"
+"help.text"
+msgid "Pressure"
+msgstr ""
+
+#. tnByU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id843387541961981\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. Gsj88
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385992865555923\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. geMDd
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id513642579177244\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. tZH3f
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id888153229712212\n"
+"help.text"
+msgid "Standard atmosphere"
+msgstr ""
+
+#. EBaTw
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id849582553771429\n"
+"help.text"
+msgid "Millimeter of mercury"
+msgstr ""
+
+#. AsDNh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id477235647442515\n"
+"help.text"
+msgid "Pascal"
+msgstr ""
+
+#. yyvEQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id453587511744492\n"
+"help.text"
+msgid "Pound per square inch"
+msgstr ""
+
+#. a9ogt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385442861685423\n"
+"help.text"
+msgid "Torr"
+msgstr ""
+
+#. vWzBh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id61620426438099\n"
+"help.text"
+msgid "Speed"
+msgstr ""
+
+#. AXQxd
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id589222947765948\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. HvMee
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id886677898259849\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. PWNGi
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id439227432319741\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. QLETi
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id391572877557741\n"
+"help.text"
+msgid "Admiralty knot"
+msgstr ""
+
+#. X3yym
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id152721538362456\n"
+"help.text"
+msgid "International knot"
+msgstr ""
+
+#. KAWp4
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id117898736774311\n"
+"help.text"
+msgid "Meters per hour"
+msgstr ""
+
+#. pctXg
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id145334267535329\n"
+"help.text"
+msgid "Meters per second"
+msgstr ""
+
+#. 6yYRz
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id233825548718154\n"
+"help.text"
+msgid "Miles per hour"
+msgstr ""
+
+#. FyEd2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id351620426496272\n"
+"help.text"
+msgid "Temperature"
+msgstr ""
+
+#. C5MHQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id916682468647914\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. kqAGM
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id828222863857386\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. sGE7h
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id131675777393493\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. do3zs
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id611894272236225\n"
+"help.text"
+msgid "Degree Celsius"
+msgstr ""
+
+#. 3Ng23
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id446899599712639\n"
+"help.text"
+msgid "Degree Fahrenheit"
+msgstr ""
+
+#. JQDwV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id452842161272274\n"
+"help.text"
+msgid "Kelvin"
+msgstr ""
+
+#. kDHfB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id946395673872875\n"
+"help.text"
+msgid "Degree Rankine"
+msgstr ""
+
+#. mUNBn
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id718454351326149\n"
+"help.text"
+msgid "Degree Réaumur"
+msgstr ""
+
+#. BfAJv
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id291620426558219\n"
+"help.text"
+msgid "Time"
+msgstr ""
+
+#. kFeSN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id935221689591996\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. U8RGh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id664526138752768\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 8X7qR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id889226439751962\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. iXcGB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id246817386878489\n"
+"help.text"
+msgid "Day"
+msgstr ""
+
+#. KCEUt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id464925665919665\n"
+"help.text"
+msgid "Hour"
+msgstr ""
+
+#. Bf2jf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id134873473826283\n"
+"help.text"
+msgid "Minute"
+msgstr ""
+
+#. RB2UJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id424852859961766\n"
+"help.text"
+msgid "Second"
+msgstr ""
+
+#. CKQZz
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id546198897664738\n"
+"help.text"
+msgid "Year"
+msgstr ""
+
+#. CCupk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id151620426617693\n"
+"help.text"
+msgid "Volume"
+msgstr ""
+
+#. YGVzt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id245659124219512\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. jvV7i
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id954441838321316\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. QnLHF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id487448753979859\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. oFBFc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id254311578719497\n"
+"help.text"
+msgid "Cubic angstrom"
+msgstr ""
+
+#. Ccm2G
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id545825775819166\n"
+"help.text"
+msgid "Oil barrel"
+msgstr ""
+
+#. a3nDk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id976829653577442\n"
+"help.text"
+msgid "US bushel"
+msgstr ""
+
+#. Fb3dj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id184258429676826\n"
+"help.text"
+msgid "US cup"
+msgstr ""
+
+#. z98AU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id278184952564879\n"
+"help.text"
+msgid "Cubic foot"
+msgstr ""
+
+#. Be5Nc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id466397614396366\n"
+"help.text"
+msgid "US gallon"
+msgstr ""
+
+#. 6dJSb
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id938562498562468\n"
+"help.text"
+msgid "Australian glass (200 milliliters)"
+msgstr ""
+
+#. vFvu4
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id471177863127144\n"
+"help.text"
+msgid "Gross register tonnage"
+msgstr ""
+
+#. tM2GH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id347175644673122\n"
+"help.text"
+msgid "Humpen (500 milliliters)"
+msgstr ""
+
+#. 3jCKA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id995576717914988\n"
+"help.text"
+msgid "Cubic inch"
+msgstr ""
+
+#. t8skx
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id842329689485738\n"
+"help.text"
+msgid "Liter"
+msgstr ""
+
+#. ZgERp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id236636296681258\n"
+"help.text"
+msgid "Cubic light-year"
+msgstr ""
+
+#. xbjLF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id538319527687728\n"
+"help.text"
+msgid "Cubic meter"
+msgstr ""
+
+#. GG8ep
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id463843338576911\n"
+"help.text"
+msgid "Cubic international mile"
+msgstr ""
+
+#. apJka
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id995778363641811\n"
+"help.text"
+msgid "Australian middy (285 milliliters)"
+msgstr ""
+
+#. 5vKXB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id894695318848125\n"
+"help.text"
+msgid "Measurement ton"
+msgstr ""
+
+#. gAxRC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id392284181269245\n"
+"help.text"
+msgid "Cubic nautical mile"
+msgstr ""
+
+#. GLMFQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id371262895179554\n"
+"help.text"
+msgid "US fluid ounce"
+msgstr ""
+
+#. KdjB5
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id956867693183654\n"
+"help.text"
+msgid "Cubic pica"
+msgstr ""
+
+#. wPWak
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id698697624265559\n"
+"help.text"
+msgid "US pint"
+msgstr ""
+
+#. oaVnc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id615917164511264\n"
+"help.text"
+msgid "US quart"
+msgstr ""
+
+#. nFgfR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id653481929342877\n"
+"help.text"
+msgid "Australian schooner (425 milliliters)"
+msgstr ""
+
+#. yumuN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id912821548196546\n"
+"help.text"
+msgid "Six pack (2 liters)"
+msgstr ""
+
+#. GNQxR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id248216629889251\n"
+"help.text"
+msgid "US tablespoon"
+msgstr ""
+
+#. Bs5pc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id745625921159327\n"
+"help.text"
+msgid "US teaspoon"
+msgstr ""
+
+#. oFoZf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id864223151994899\n"
+"help.text"
+msgid "Metric teaspoon"
+msgstr ""
+
+#. 6eLBT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id311759289592485\n"
+"help.text"
+msgid "Imperial gallon"
+msgstr ""
+
+#. zJyLT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id673293916128784\n"
+"help.text"
+msgid "Imperial pint"
+msgstr ""
+
+#. f9zhg
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id213353742979736\n"
+"help.text"
+msgid "Imperial quart"
+msgstr ""
+
+#. TGDmn
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id817884513513347\n"
+"help.text"
+msgid "Cubic yard"
+msgstr ""
+
+#. ej2DE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id21620415408286\n"
+"help.text"
+msgid "Prefixes"
+msgstr ""
+
+#. TSaMK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id731620426688645\n"
+"help.text"
+msgid "Decimal prefixes"
+msgstr ""
+
+#. cjDA7
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id772395422122114\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. yHdoH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id448471762246791\n"
+"help.text"
+msgid "Multiplier"
+msgstr ""
+
+#. zByEE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id91620427193950\n"
+"help.text"
+msgid "Binary prefixes"
+msgstr ""
+
+#. X7TD3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id422991712375461\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. mAcRr
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id553637738674151\n"
+"help.text"
+msgid "Multiplier"
+msgstr ""
+
+#. gc56z
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id871621424421294\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT\">CONVERT Wiki page</link>"
+msgstr ""
+
#. JEUej
#: func_countifs.xhp
msgctxt ""
@@ -58624,14 +59848,23 @@ msgctxt ""
msgid "<item type=\"input\">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31."
msgstr "<item type=\"input\">=FIMMÊS(DATA(2001;9;14);6)</item> devolve o número de série 37346. Formatado como data, é 2002-03-31."
-#. naTtB
+#. 7eUrP
#: func_eomonth.xhp
msgctxt ""
"func_eomonth.xhp\n"
"par_id3156144\n"
"help.text"
-msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If the date is given as string, it has to be in ISO format."
-msgstr "<item type=\"input\">=FIMMÊS(\"2001-09-14\";6)</item> também funciona. Se for indicada uma data como cadeia, deve estar em formato ISO."
+msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If you specify the date directly, we recommend using the standard ISO 8601 format because this should be independent of your selected locale settings."
+msgstr ""
+
+#. Lu8Ng
+#: func_eomonth.xhp
+msgctxt ""
+"func_eomonth.xhp\n"
+"par_id681621540307527\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH\">EOMONTH wiki page</link>"
+msgstr ""
#. BNTm6
#: func_error_type.xhp
@@ -63862,13 +65095,13 @@ msgctxt ""
msgid "<emph>delimiter</emph> is a text string and can be a range."
msgstr ""
-#. CsnD3
+#. 6vMaP
#: func_textjoin.xhp
msgctxt ""
"func_textjoin.xhp\n"
"par_id621556228397269\n"
"help.text"
-msgid "<emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored."
+msgid "<emph>skip_empty</emph> is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored."
msgstr ""
#. JoYks
diff --git a/source/pt/helpcontent2/source/text/scalc/guide.po b/source/pt/helpcontent2/source/text/scalc/guide.po
index 1e8980eb93e..02c4fee279a 100644
--- a/source/pt/helpcontent2/source/text/scalc/guide.po
+++ b/source/pt/helpcontent2/source/text/scalc/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-04-27 17:02+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2021-04-03 16:37+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textscalcguide/pt/>\n"
@@ -3022,14 +3022,14 @@ msgctxt ""
msgid "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>."
msgstr "Posicione o cursor numa célula vazia, por exemplo, J14, e selecione <emph>Inserir - Função</emph>."
-#. JF5VP
+#. DGtFG
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3156016\n"
"help.text"
-msgid "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#eingabesymbol\" name=\"Shrink or Maximize\"><item type=\"menuitem\">Shrink</item></link> icon."
-msgstr "Selecione a função MÉDIA. Utilize o rato para selecionar todos os números aleatórios. Se não conseguir ver o intervalo porque o assistente de funções está na frente, encolha temporariamente a caixa de diálogo usando o ícone <link href=\"text/shared/00/00000001.xhp#eingabesymbol\" name=\"Shrink or Maximize\"><item type=\"menuitem\">Reduzir</item></link>."
+msgid "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#shrink_maximize\" name=\"Shrink or Maximize\"><item type=\"menuitem\">Shrink</item></link> icon."
+msgstr ""
#. YEqsh
#: cellstyle_conditional.xhp
diff --git a/source/pt/helpcontent2/source/text/shared/01.po b/source/pt/helpcontent2/source/text/shared/01.po
index 87580d9f986..cf6ec77c146 100644
--- a/source/pt/helpcontent2/source/text/shared/01.po
+++ b/source/pt/helpcontent2/source/text/shared/01.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-05-14 14:15+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2021-01-01 16:36+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textshared01/pt/>\n"
@@ -20320,6 +20320,42 @@ msgctxt ""
msgid "Spell out as a date in format \"First of May, Nineteen Ninety-nine\""
msgstr ""
+#. 6hJmz
+#: 05020301.xhp
+msgctxt ""
+"05020301.xhp\n"
+"par_id1308201617965331455819\n"
+"help.text"
+msgid "[NatNum12 MMM=upper]MMM-DD"
+msgstr ""
+
+#. MH8w7
+#: 05020301.xhp
+msgctxt ""
+"05020301.xhp\n"
+"par_id13082016075331121120\n"
+"help.text"
+msgid "Display upper case abbreviated month name in format \"JAN-01\""
+msgstr ""
+
+#. dro72
+#: 05020301.xhp
+msgctxt ""
+"05020301.xhp\n"
+"par_id1308201617965331455820\n"
+"help.text"
+msgid "[NatNum12 MMMM=lower]MMMM"
+msgstr ""
+
+#. PCQE6
+#: 05020301.xhp
+msgctxt ""
+"05020301.xhp\n"
+"par_id13082016075331121121\n"
+"help.text"
+msgid "Display lower case month name in format \"january\""
+msgstr ""
+
#. i25EX
#: 05020301.xhp
msgctxt ""
diff --git a/source/pt/helpcontent2/source/text/shared/06.po b/source/pt/helpcontent2/source/text/shared/06.po
index 1460489b90a..0dde3ea08a2 100644
--- a/source/pt/helpcontent2/source/text/shared/06.po
+++ b/source/pt/helpcontent2/source/text/shared/06.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-05-14 14:15+0200\n"
+"POT-Creation-Date: 2021-05-31 15:15+0200\n"
"PO-Revision-Date: 2021-02-04 20:36+0000\n"
"Last-Translator: Sérgio Marques <smarquespt@gmail.com>\n"
"Language-Team: Portuguese <https://translations.documentfoundation.org/projects/libo_help-master/textshared06/pt/>\n"
@@ -304,14 +304,14 @@ msgctxt ""
msgid "<image src=\"media/screenshots/cui/ui/slantcornertabpage/SlantAndCornerRadius.png\" id=\"img_id91601001943410\"><alt id=\"alt_id101601001943411\">Slant and Corner Radius tab page</alt></image>"
msgstr "<image src=\"media/screenshots/cui/ui/slantcornertabpage/SlantAndCornerRadius.png\" id=\"img_id91601001943410\"><alt id=\"alt_id101601001943411\">Separador Inclinação e raio</alt></image>"
-#. agtWk
+#. Xpwka
#: simpress_screenshots.xhp
msgctxt ""
"simpress_screenshots.xhp\n"
"tit\n"
"help.text"
-msgid "SIMPRESS Screenshots"
-msgstr "Capturas de ecrã do Impress"
+msgid "Impress Screenshots"
+msgstr ""
#. c6FJr
#: simpress_screenshots.xhp