diff options
author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2021-05-31 16:27:05 +0200 |
---|---|---|
committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2021-05-31 16:31:43 +0200 |
commit | 387ea1005f554dadedc7073e947bbd93dfa38c25 (patch) | |
tree | 612159922b977ccf3b51ad8bfdf8780efd5099a4 /source/mk/helpcontent2 | |
parent | 48ffdf216a07738135223c4f95e9f942be8a5dd9 (diff) |
update translations for master
and force-fix errors using pocheck
Change-Id: I5a54db2572738c26858f69eba71239fa9474f0a4
Diffstat (limited to 'source/mk/helpcontent2')
-rw-r--r-- | source/mk/helpcontent2/source/text/sbasic/shared.po | 65 | ||||
-rw-r--r-- | source/mk/helpcontent2/source/text/sbasic/shared/03.po | 1118 | ||||
-rw-r--r-- | source/mk/helpcontent2/source/text/scalc/01.po | 2845 | ||||
-rw-r--r-- | source/mk/helpcontent2/source/text/scalc/guide.po | 6 | ||||
-rw-r--r-- | source/mk/helpcontent2/source/text/shared/01.po | 38 | ||||
-rw-r--r-- | source/mk/helpcontent2/source/text/shared/06.po | 6 |
6 files changed, 2930 insertions, 1148 deletions
diff --git a/source/mk/helpcontent2/source/text/sbasic/shared.po b/source/mk/helpcontent2/source/text/sbasic/shared.po index 73aa306f10f..d4760520838 100644 --- a/source/mk/helpcontent2/source/text/sbasic/shared.po +++ b/source/mk/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: 2018-10-21 20:26+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -610,6 +610,51 @@ msgctxt "" msgid "<variable id=\"functexample\">Example:</variable>" msgstr "" +#. 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 "Changes the current drive." -#. rkzEY -#: 03020402.xhp -msgctxt "" -"03020402.xhp\n" -"par_id3154685\n" -"help.text" -msgid "ChDrive Text As String" -msgstr "ChDrive Text As String" - #. ncuAv #: 03020402.xhp msgctxt "" diff --git a/source/mk/helpcontent2/source/text/sbasic/shared/03.po b/source/mk/helpcontent2/source/text/sbasic/shared/03.po index 2ca5bab795e..90ffacdab9d 100644 --- a/source/mk/helpcontent2/source/text/sbasic/shared/03.po +++ b/source/mk/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: 2018-07-12 14:33+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\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/mk/helpcontent2/source/text/scalc/01.po b/source/mk/helpcontent2/source/text/scalc/01.po index 57265168cb2..97a171c13d6 100644 --- a/source/mk/helpcontent2/source/text/scalc/01.po +++ b/source/mk/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2021-05-14 14:15+0200\n" +"POT-Creation-Date: 2021-05-31 15:15+0200\n" "PO-Revision-Date: 2018-11-12 13:53+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -20545,6 +20545,15 @@ msgctxt "" msgid "<emph>Text</emph> refers to the text from which to remove all non-printable characters." msgstr "<emph>text</emph> refers to the text from which to remove all non-printable characters." +#. 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>decimals</emph> is the optional number of decimal places." -#. JFmwv +#. ezXhx #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3153546\n" "help.text" -msgid "<item type=\"input\">=DOLLAR(255)</item> returns $255.00." -msgstr "DOLLAR(255) returns $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,805 +27160,13 @@ msgctxt "" msgid "<item type=\"input\">=OCT2HEX(144;4)</item> returns 0064." msgstr "=OCT2HEX(144;4) returns 0064." -#. JBzHD -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"bm_id3148446\n" -"help.text" -msgid "<bookmark_value>CONVERT function</bookmark_value>" -msgstr "" - -#. NNzM9 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"hd_id3148446\n" -"help.text" -msgid "CONVERT" -msgstr "" - -#. 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\">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." - -#. BWERF -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3153055\n" -"help.text" -msgid "Property" -msgstr "Property" - -#. XTUci -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3147234\n" -"help.text" -msgid "Units" -msgstr "Units" - -#. cMJxt -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3147512\n" -"help.text" -msgid "Weight" -msgstr "Тежина" - -#. 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 "" - -#. GaiAA -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3155361\n" -"help.text" -msgid "Length" -msgstr "Должина" - -#. 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 "" - -#. CSY6D -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3158429\n" -"help.text" -msgid "Time" -msgstr "Време" - -#. CRKWs -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3150707\n" -"help.text" -msgid "yr, day, hr, mn, <emph>sec</emph>, <emph>s</emph>" -msgstr "" - -#. jRyCG -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3153238\n" -"help.text" -msgid "Pressure" -msgstr "Pressure" - -#. 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 "" - -#. eDDQG -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3152944\n" -"help.text" -msgid "Force" -msgstr "Force" - -#. 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 "" - -#. nDfkL -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3153686\n" -"help.text" -msgid "Energy" -msgstr "Energy" - -#. 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 "" - -#. RkeAo -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3154100\n" -"help.text" -msgid "Power" -msgstr "Степен" - -#. RAPGk -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149915\n" -"help.text" -msgid "<emph>W</emph>, <emph>w</emph>, HP, PS" -msgstr "" - -#. FRDaq -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3148988\n" -"help.text" -msgid "Field strength" -msgstr "Field strength" - -#. YKEEF +#. AXDcg #: 04060116.xhp msgctxt "" "04060116.xhp\n" -"par_id3148616\n" -"help.text" -msgid "<emph>T</emph>, <emph>ga</emph>" -msgstr "" - -#. rxAYG -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3151120\n" -"help.text" -msgid "Temperature" -msgstr "Temperature" - -#. V3XFM -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3148659\n" -"help.text" -msgid "C, F, <emph>K</emph>, <emph>kel</emph>, Reau, Rank" -msgstr "" - -#. AF455 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3154610\n" -"help.text" -msgid "Volume" -msgstr "Том" - -#. 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 "" - -#. YpiAY -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149244\n" -"help.text" -msgid "Area" -msgstr "Област" - -#. 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 "" - -#. MdUET -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3150629\n" -"help.text" -msgid "Speed" -msgstr "Брзина" - -#. 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 "" - -#. fSWsq -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3150789\n" -"help.text" -msgid "Information" -msgstr "Информации" - -#. UTUhA -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3159899\n" -"help.text" -msgid "<emph>bit</emph>, <emph>byte</emph>" -msgstr "" - -#. 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 "" - -#. YBQYC -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3148422\n" -"help.text" -msgid "Prefix" -msgstr "" - -#. vzHyG -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3148423\n" -"help.text" -msgid "Multiplier" -msgstr "" - -#. y8Bch -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149490\n" -"help.text" -msgid "Y (yotta)" -msgstr "" - -#. YE3Bo -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149931\n" -"help.text" -msgid "10^24" -msgstr "" - -#. Vst48 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149491\n" -"help.text" -msgid "Z (zetta)" -msgstr "" - -#. cBpwF -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149932\n" -"help.text" -msgid "10^21" -msgstr "" - -#. sVmhZ -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149492\n" -"help.text" -msgid "E (exa)" -msgstr "" - -#. DCgjD -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149933\n" -"help.text" -msgid "10^18" -msgstr "" - -#. odrAJ -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149493\n" -"help.text" -msgid "P (peta)" -msgstr "" - -#. HnJBh -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149934\n" -"help.text" -msgid "10^15" -msgstr "" - -#. 6SoPA -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149494\n" -"help.text" -msgid "T (tera)" -msgstr "" - -#. cgqVx -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149935\n" -"help.text" -msgid "10^12" -msgstr "" - -#. Ki9Ca -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149495\n" -"help.text" -msgid "G (giga)" -msgstr "" - -#. jMqL9 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149936\n" -"help.text" -msgid "10^9" -msgstr "" - -#. YD6i5 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149496\n" -"help.text" -msgid "M (mega)" -msgstr "" - -#. 4vqCG -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149937\n" -"help.text" -msgid "10^6" -msgstr "" - -#. 6WGVB -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149497\n" -"help.text" -msgid "k (kilo)" -msgstr "" - -#. wBWRS -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149938\n" -"help.text" -msgid "10^3" -msgstr "" - -#. G2FDE -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149498\n" -"help.text" -msgid "h (hecto)" -msgstr "" - -#. 9UYSz -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149939\n" -"help.text" -msgid "10^2" -msgstr "" - -#. woVg4 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149499\n" -"help.text" -msgid "e (deca)" -msgstr "" - -#. iiAPq -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149940\n" -"help.text" -msgid "10^1" -msgstr "" - -#. C7sNq -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149500\n" -"help.text" -msgid "d (deci)" -msgstr "" - -#. eQehn -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3143940\n" -"help.text" -msgid "10^-1" -msgstr "" - -#. EUm9F -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149501\n" -"help.text" -msgid "c (centi)" -msgstr "" - -#. FDbBr -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149941\n" -"help.text" -msgid "10^-2" -msgstr "" - -#. G48jP -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149502\n" -"help.text" -msgid "m (milli)" -msgstr "" - -#. uUT75 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149942\n" -"help.text" -msgid "10^-3" -msgstr "" - -#. LTWEh -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149503\n" -"help.text" -msgid "u (micro)" -msgstr "" - -#. cvaeu -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149943\n" -"help.text" -msgid "10^-6" -msgstr "" - -#. GD6Gw -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149504\n" +"hd_id14741462320147\n" "help.text" -msgid "n (nano)" -msgstr "" - -#. 38rEb -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149944\n" -"help.text" -msgid "10^-9" -msgstr "" - -#. FiDAM -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149505\n" -"help.text" -msgid "p (pico)" -msgstr "" - -#. 9sGcA -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149945\n" -"help.text" -msgid "10^-12" -msgstr "" - -#. SMnpF -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149506\n" -"help.text" -msgid "f (femto)" -msgstr "" - -#. cqsCH -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149946\n" -"help.text" -msgid "10^-15" -msgstr "" - -#. Fj46E -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149507\n" -"help.text" -msgid "a (atto)" -msgstr "" - -#. qtV59 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149947\n" -"help.text" -msgid "10^-18" -msgstr "" - -#. ZxxnU -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149508\n" -"help.text" -msgid "z (zepto)" -msgstr "" - -#. GWC7A -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149948\n" -"help.text" -msgid "10^-21" -msgstr "" - -#. cTLp9 -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149509\n" -"help.text" -msgid "y (yocto)" -msgstr "" - -#. KAARJ -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3149949\n" -"help.text" -msgid "10^-24" -msgstr "" - -#. 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 "" - -#. DZhKD -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903090966\n" -"help.text" -msgid "ki kibi 1024" -msgstr "" - -#. K3qEd -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903090958\n" -"help.text" -msgid "Mi mebi 1048576" -msgstr "" - -#. dBFMg -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903090936\n" -"help.text" -msgid "Gi gibi 1073741824" -msgstr "" - -#. 9RnhS -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903090975\n" -"help.text" -msgid "Ti tebi 1099511627776" -msgstr "" - -#. 39Jpn -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903090930\n" -"help.text" -msgid "Pi pebi 1125899906842620" -msgstr "" - -#. GkAoP -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903091070\n" -"help.text" -msgid "Ei exbi 1152921504606850000" -msgstr "" - -#. GTGuN -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903091097\n" -"help.text" -msgid "Zi zebi 1180591620717410000000" -msgstr "" - -#. QbEGb -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id0908200903091010\n" -"help.text" -msgid "Yi yobi 1208925819614630000000000" -msgstr "" - -#. RpFzc -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3153695\n" -"help.text" -msgid "CONVERT(Number; \"FromUnit\"; \"ToUnit\")" -msgstr "" - -#. f822K -#: 04060116.xhp -msgctxt "" -"04060116.xhp\n" -"par_id3147522\n" -"help.text" -msgid "<emph>Number</emph> is the number to be converted." -msgstr "Number: the number to be converted." - -#. 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 "From unit: the unit from which conversion is taking place." - -#. 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 "To unit: the unit to which conversion is taking place." - -#. 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 "" - -#. 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." +msgid "<embedvar href=\"text/scalc/01/func_convert.xhp#convert_head\"/>" msgstr "" #. G7UNe @@ -49543,14 +48760,14 @@ msgctxt "" msgid "AutoFilter" msgstr "Автоматски филтер" -#. 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\">AutoFilter</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\">Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.</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 "Examples" +#. 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,13 +59848,22 @@ 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 "=EOMONTH(\"9.14.2001\";6) returns 3.31.2002." -#. 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." +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 @@ -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/mk/helpcontent2/source/text/scalc/guide.po b/source/mk/helpcontent2/source/text/scalc/guide.po index 274d3afcc70..6bea209db1c 100644 --- a/source/mk/helpcontent2/source/text/scalc/guide.po +++ b/source/mk/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: 2018-11-14 12:05+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -3022,13 +3022,13 @@ msgctxt "" msgid "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." msgstr "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</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." +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 diff --git a/source/mk/helpcontent2/source/text/shared/01.po b/source/mk/helpcontent2/source/text/shared/01.po index 29f6d5134a6..e68e3ac9778 100644 --- a/source/mk/helpcontent2/source/text/shared/01.po +++ b/source/mk/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: 2020-11-18 18:36+0000\n" "Last-Translator: sophie <gautier.sophie@gmail.com>\n" "Language-Team: Macedonian <https://weblate.documentfoundation.org/projects/libo_help-master/textshared01/mk/>\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/mk/helpcontent2/source/text/shared/06.po b/source/mk/helpcontent2/source/text/shared/06.po index 7923b899053..6d4642afda0 100644 --- a/source/mk/helpcontent2/source/text/shared/06.po +++ b/source/mk/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: 2018-09-03 13:13+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -304,13 +304,13 @@ 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 "" -#. agtWk +#. Xpwka #: simpress_screenshots.xhp msgctxt "" "simpress_screenshots.xhp\n" "tit\n" "help.text" -msgid "SIMPRESS Screenshots" +msgid "Impress Screenshots" msgstr "" #. c6FJr |