diff options
Diffstat (limited to 'source/et/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/et/helpcontent2/source/text/scalc/01.po | 440 |
1 files changed, 256 insertions, 184 deletions
diff --git a/source/et/helpcontent2/source/text/scalc/01.po b/source/et/helpcontent2/source/text/scalc/01.po index 2b82c438706..210fc100e50 100644 --- a/source/et/helpcontent2/source/text/scalc/01.po +++ b/source/et/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: \n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2021-10-04 19:51+0200\n" +"POT-Creation-Date: 2021-10-25 12:48+0200\n" "PO-Revision-Date: 2021-08-10 09:21+0000\n" "Last-Translator: Mihkel Tõnnov <mihhkel@gmail.com>\n" "Language-Team: Estonian <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/et/>\n" @@ -15667,13 +15667,13 @@ msgctxt "" msgid "Array Functions" msgstr "Massiivi funktsioonid" -#. U7gUU +#. BB9Ze #: 04060107.xhp msgctxt "" "04060107.xhp\n" "bm_id3147273\n" "help.text" -msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>" +msgid "<bookmark_value>matrices; functions</bookmark_value><bookmark_value>Function Wizard; arrays</bookmark_value><bookmark_value>array formulas</bookmark_value><bookmark_value>inline array constants</bookmark_value><bookmark_value>formulas; arrays</bookmark_value><bookmark_value>functions; array functions</bookmark_value><bookmark_value>editing; array formulas</bookmark_value><bookmark_value>copying; array formulas</bookmark_value><bookmark_value>deleting; array formulas</bookmark_value><bookmark_value>adjusting array ranges</bookmark_value><bookmark_value>calculating; conditional calculations</bookmark_value><bookmark_value>matrices; calculations</bookmark_value><bookmark_value>conditional calculations with arrays</bookmark_value><bookmark_value>implicit array handling</bookmark_value><bookmark_value>forced array handling</bookmark_value>" msgstr "" #. ALUph @@ -15856,14 +15856,14 @@ msgctxt "" msgid "Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces." msgstr "$[officename] Calcis kuvatakse massiivi valemeid loogelistes sulgudes. Massiivi valemeid ei saa koostada loogelisi sulge käsitsi sisestades." -#. 6GZXu +#. 6zGAy #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3154342\n" "help.text" -msgid "The cells in a results array are automatically protected against changes. However, you can edit or copy the array formula by selecting the entire array cell range." -msgstr "Tulemuste massiivi lahtrid on automaatselt kaitstud muudatuste vastu. Massiivi valemit saab redigeerida ja kopeerida, kui valida kogu massiivi lahtrite vahemik." +msgid "The cells in a results array are automatically protected against changes. However, you can edit, delete or copy the array formula by selecting the entire array cell range." +msgstr "" #. 2tDZj #: 04060107.xhp @@ -16009,14 +16009,14 @@ msgctxt "" msgid "Editing Array Formulas" msgstr "Massiivi valemite redigeerimine" -#. cT3G3 +#. Qi4kV #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3149241\n" "help.text" -msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + /</emph>, where <emph>/</emph> is the <emph>Division</emph> key on the numeric keypad." -msgstr "Vali massiivi valemit sisaldav lahtrivahemik või massiiv. Kogu massiivi valimiseks vii lahtrikursor massiivi vahemikku ja klõpsa <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+/</emph>, kus <emph>/</emph> on numbriklahvistiku <emph>jagamisklahv</emph>." +msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad." +msgstr "" #. BzLzG #: 04060107.xhp @@ -16045,6 +16045,33 @@ msgctxt "" msgid "You can format the separate parts of an array. For example, you can change the font color. Select a cell range and then change the attribute you want." msgstr "Massiivi osi saab vormindada, näiteks saab muuta fondi värvi. Vali lahtrite vahemik ja muuda soovitud atribuuti." +#. Tes4E +#: 04060107.xhp +msgctxt "" +"04060107.xhp\n" +"hd_id541633516074226\n" +"help.text" +msgid "Deleting Array Formulae" +msgstr "" + +#. adAax +#: 04060107.xhp +msgctxt "" +"04060107.xhp\n" +"par_id681633516103267\n" +"help.text" +msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> + <keycode>/</keycode>, where <keycode>/</keycode> is the division key on the numeric keypad." +msgstr "" + +#. 5xB8E +#: 04060107.xhp +msgctxt "" +"04060107.xhp\n" +"par_id61633516164519\n" +"help.text" +msgid "Press <keycode>Delete</keycode> to delete the array contents, including the array formula, or press <keycode>Backspace</keycode> and this brings up the <link href=\"text/scalc/01/02150000.xhp\" name=\"delete contents\">Delete Contents</link> dialog box. Select <emph>Formula</emph> or <emph>Delete All</emph> and click <emph>OK</emph>." +msgstr "" + #. dEcVJ #: 04060107.xhp msgctxt "" @@ -20266,69 +20293,6 @@ msgctxt "" msgid "Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature." msgstr "" -#. Gmvo8 -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"bm_id3149384\n" -"help.text" -msgid "<bookmark_value>ARABIC function</bookmark_value>" -msgstr "<bookmark_value>ARABIC funktsioon</bookmark_value>" - -#. SyuhN -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"hd_id3149384\n" -"help.text" -msgid "ARABIC" -msgstr "ARABIC" - -#. 6Kjyp -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3153558\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ARABISCH\">Calculates the value of a Roman number. The value range must be between 0 and 3999.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ARABISCH\">Arvutab rooma numbri väärtuse. Väärtuste vahemik peab jääma 0 ja 3999 vahele.</ahelp>" - -#. cwSkH -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3155523\n" -"help.text" -msgid "ARABIC(\"Text\")" -msgstr "ARABIC(\"tekst\")" - -#. AQA5o -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3151193\n" -"help.text" -msgid "<emph>Text</emph> is the text that represents a Roman number." -msgstr "" - -#. dVD9Z -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3154621\n" -"help.text" -msgid "<item type=\"input\">=ARABIC(\"MXIV\")</item> returns 1014" -msgstr "<item type=\"input\">=ARABIC(\"MXIV\")</item> tagastab 1014" - -#. g4sEa -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3147553\n" -"help.text" -msgid "<item type=\"input\">=ARABIC(\"MMII\")</item> returns 2002" -msgstr "<item type=\"input\">=ARABIC(\"MMII\")</item> tagastab 2002" - #. teACB #: 04060110.xhp msgctxt "" @@ -22264,114 +22228,6 @@ msgctxt "" msgid "<item type=\"input\">RIGHTB(\"office\";3)</item> returns \"ice\" (3 non-DBCS characters each consisting of 1 byte)." msgstr "<item type=\"input\">=COSH(0)</item> tagastab 1, arvu 0 hüperboolse koosinuse." -#. 84zEq -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"bm_id3153534\n" -"help.text" -msgid "<bookmark_value>ROMAN function</bookmark_value>" -msgstr "<bookmark_value>ROMAN funktsioon</bookmark_value>" - -#. 25vky -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"hd_id3153534\n" -"help.text" -msgid "ROMAN" -msgstr "ROMAN" - -#. r5V5K -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3151256\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_ROEMISCH\">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_ROEMISCH\">Teisendab arvu rooma numbriks. Arvu väärtus peab olema vahemikus 0 kuni 3999, režiim võib olla täisarv 0 kuni 4.</ahelp>" - -#. RdCBS -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3150593\n" -"help.text" -msgid "ROMAN(Number [; Mode])" -msgstr "" - -#. 4rcTC -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3156139\n" -"help.text" -msgid "<emph>Number</emph> is the number that is to be converted into a Roman numeral." -msgstr "<emph>Arv</emph> on Rooma numbritesse teisendatav arv." - -#. HEZFy -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3153318\n" -"help.text" -msgid "<emph>Mode</emph> (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number." -msgstr "<emph>Režiim</emph> (mittekohustuslik) näitab lihtsustuse astet. Mida kõrgem selle väärtus, seda enam Rooma numbreid lihtsustatakse." - -#. Huw7f -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3151371\n" -"help.text" -msgid "<item type=\"input\">=ROMAN(999)</item> returns CMXCIX" -msgstr "<item type=\"input\">=ROMAN(999)</item> tagastab CMXCIX" - -#. ACRz3 -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3153938\n" -"help.text" -msgid "<item type=\"input\">=ROMAN(999;0)</item> returns CMXCIX" -msgstr "<item type=\"input\">=ROMAN(999;0)</item> tagastab CMXCIX" - -#. mtbzC -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3148412\n" -"help.text" -msgid "<item type=\"input\">=ROMAN (999;1)</item> returns LMVLIV" -msgstr "" - -#. 8GQP5 -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3155421\n" -"help.text" -msgid "<item type=\"input\">=ROMAN(999;2)</item> returns XMIX" -msgstr "<item type=\"input\">=ROMAN(999;2)</item> tagastab XMIX" - -#. d8sji -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3149235\n" -"help.text" -msgid "<item type=\"input\">=ROMAN(999;3)</item> returns VMIV" -msgstr "<item type=\"input\">=ROMAN(999;3)</item> tagastab VMIV" - -#. yDGse -#: 04060110.xhp -msgctxt "" -"04060110.xhp\n" -"par_id3150624\n" -"help.text" -msgid "<item type=\"input\">=ROMAN(999;4)</item> returns IM" -msgstr "<item type=\"input\">=ROMAN(999;4)</item> tagastab IM" - #. q3uLN #: 04060110.xhp msgctxt "" @@ -44260,13 +44116,13 @@ msgctxt "" msgid "In the <emph>Formatting</emph> toolbar, click:" msgstr "" -#. sq4wv +#. BCsAA #: 05060000.xhp msgctxt "" "05060000.xhp\n" "par_id521632804983642\n" "help.text" -msgid "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id921632804983642\">Icon</alt> </image>" +msgid "<image id=\"img_id811632804983642\" src=\"cmd/sc_togglemergecells.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id921632804983642\">Icon Merge and Center Cells</alt></image>" msgstr "" #. 86yef @@ -55906,6 +55762,96 @@ msgctxt "" msgid "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>" msgstr "" +#. czFkz +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"tit\n" +"help.text" +msgid "ARABIC Function" +msgstr "" + +#. ze8wK +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"bm_id831542233029549\n" +"help.text" +msgid "<bookmark_value>ARABIC function</bookmark_value> <bookmark_value>text functions;convert roman numbers</bookmark_value>" +msgstr "" + +#. BNUYi +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"hd_id881628776094597\n" +"help.text" +msgid "<variable id=\"Arabic_h1\"><link href=\"text/scalc/01/func_arabic.xhp\" name=\"function ARABIC\">ARABIC</link></variable>" +msgstr "" + +#. xPXrU +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id541542230672101\n" +"help.text" +msgid "<variable id=\"func_arabic_desc\"><ahelp hid=\".\">Returns the numeric value corresponding to a Roman number expressed as text.</ahelp></variable>" +msgstr "" + +#. 2UE9g +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id151634221012221\n" +"help.text" +msgid "The largest Roman number that can be converted is MMMCMXCIX (or one of its simplified versions), which is equivalent to 3999." +msgstr "" + +#. AueXr +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id701542231253817\n" +"help.text" +msgid "<input>ARABIC(Text)</input>" +msgstr "" + +#. sWMEb +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id621542232197446\n" +"help.text" +msgid "<emph>Text</emph>: text representing a Roman number." +msgstr "" + +#. WcE8r +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id451628776707264\n" +"help.text" +msgid "<input>=ARABIC(\"MXIV\")</input> returns the numeric value 1014." +msgstr "" + +#. hDmDF +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id101628778036375\n" +"help.text" +msgid "<input>=ARABIC(\"MMII\")</input> returns the numeric value 2002." +msgstr "" + +#. XAwC8 +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id101628778036134\n" +"help.text" +msgid "<input>=ARABIC(\"\")</input> returns 0." +msgstr "" + #. y9q7t #: func_averageif.xhp msgctxt "" @@ -63538,13 +63484,13 @@ msgctxt "" msgid "The output number is formatted as a valid floating point value and shown using the current cell's number format." msgstr "" -#. 2Ditv +#. CdgXz #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id351625601754290\n" "help.text" -msgid "Refer to the <embedvar href=\"text/shared/01/05020300.xhp#NumbersLink\"/> help page to learn how to change the format of numbers in a cell." +msgid "Refer to the <link href=\"text/shared/01/05020300.xhp\" name=\"num_format_link\">Numbers / Format</link> help page to learn how to change the format of numbers in a cell." msgstr "" #. vEdwF @@ -64564,6 +64510,132 @@ msgctxt "" msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\" name=\"REPLACEB_Wiki\">REPLACEB</link> wiki page for more details about this function." msgstr "" +#. FuCCt +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"tit\n" +"help.text" +msgid "ROMAN Function" +msgstr "" + +#. JqcvP +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"bm_id831542233029549\n" +"help.text" +msgid "<bookmark_value>ROMAN function</bookmark_value> <bookmark_value>text functions;convert to roman numbers</bookmark_value>" +msgstr "" + +#. uXEPr +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"hd_id881628776094597\n" +"help.text" +msgid "<variable id=\"Roman_h1\"><link href=\"text/scalc/01/func_roman.xhp\" name=\"function ROMAN\">ROMAN</link></variable>" +msgstr "" + +#. pdMgk +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id541542230672101\n" +"help.text" +msgid "<variable id=\"func_roman_desc\"><ahelp hid=\".\">Converts a number into a Roman numeral. The value range must be between 0 and 3999. A simplification mode can be specified in the range from 0 to 4.</ahelp></variable>" +msgstr "" + +#. tRsoC +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id701542231253817\n" +"help.text" +msgid "<input>ROMAN(Number [; Mode])</input>" +msgstr "" + +#. rz4bH +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id621542232197446\n" +"help.text" +msgid "<emph>Number</emph>: the number that is to be converted into a Roman numeral." +msgstr "" + +#. bfvWL +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id621542232197337\n" +"help.text" +msgid "<emph>Mode</emph>: optional value ranging between 0 to 4 that indicates the degree of simplification to be used in the conversion. The higher the value, the greater is the simplification of the Roman number." +msgstr "" + +#. BBUCq +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id451628776707264\n" +"help.text" +msgid "<input>=ROMAN(999)</input> returns \"CMXCIX\" (uses simplification mode equal to zero, which is the default)." +msgstr "" + +#. mBktA +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036375\n" +"help.text" +msgid "<input>=ROMAN(999;0)</input> returns \"CMXCIX\"." +msgstr "" + +#. fGqPj +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036134\n" +"help.text" +msgid "<input>=ROMAN(999;1)</input> returns \"LMVLIV\"." +msgstr "" + +#. qBbFo +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036278\n" +"help.text" +msgid "<input>=ROMAN(999;2)</input> returns \"XMIX\"." +msgstr "" + +#. AY5jP +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036364\n" +"help.text" +msgid "<input>=ROMAN(999;3)</input> returns \"VMIV\"." +msgstr "" + +#. B2aqT +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036008\n" +"help.text" +msgid "<input>=ROMAN(999;4)</input> returns \"IM\"." +msgstr "" + +#. CBuwx +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id101628778036019\n" +"help.text" +msgid "<input>=ROMAN(0)</input> returns \"\" (empty text)." +msgstr "" + #. E7heY #: func_roundsig.xhp msgctxt "" |