diff options
Diffstat (limited to 'source/si/helpcontent2/source/text/scalc/01.po')
-rw-r--r-- | source/si/helpcontent2/source/text/scalc/01.po | 74 |
1 files changed, 37 insertions, 37 deletions
diff --git a/source/si/helpcontent2/source/text/scalc/01.po b/source/si/helpcontent2/source/text/scalc/01.po index 6c60c77a5bf..d0e08d92556 100644 --- a/source/si/helpcontent2/source/text/scalc/01.po +++ b/source/si/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: 2018-10-21 20:57+0200\n" +"POT-Creation-Date: 2018-11-12 12:22+0100\n" "PO-Revision-Date: 2016-07-06 17:10+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -13909,7 +13909,7 @@ 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>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 "" #: 04060107.xhp @@ -14101,7 +14101,7 @@ msgctxt "" "04060107.xhp\n" "par_id3158432\n" "help.text" -msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10." +msgid "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10." msgstr "" #: 04060107.xhp @@ -14181,7 +14181,7 @@ msgctxt "" "04060107.xhp\n" "par_id3153392\n" "help.text" -msgid "If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula." +msgid "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula." msgstr "" #: 04060107.xhp @@ -14269,7 +14269,7 @@ msgctxt "" "04060107.xhp\n" "par_id6757103\n" "help.text" -msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter." +msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>." msgstr "" #: 04060107.xhp @@ -14333,7 +14333,7 @@ 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\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+/, where / is the Division key on the numeric keypad." +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 "" #: 04060107.xhp @@ -14341,7 +14341,7 @@ msgctxt "" "04060107.xhp\n" "par_id3143274\n" "help.text" -msgid "Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula." +msgid "Either press <emph>F2</emph> or position the cursor in the input line. Both of these actions let you edit the formula." msgstr "" #: 04060107.xhp @@ -14349,7 +14349,7 @@ msgctxt "" "04060107.xhp\n" "par_id3154798\n" "help.text" -msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter." +msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>." msgstr "" #: 04060107.xhp @@ -14381,7 +14381,7 @@ msgctxt "" "04060107.xhp\n" "par_id3154619\n" "help.text" -msgid "Either press F2 or position the cursor in the input line." +msgid "Either press <emph>F2</emph> or position the cursor in the input line." msgstr "" #: 04060107.xhp @@ -14389,7 +14389,7 @@ msgctxt "" "04060107.xhp\n" "par_id3150994\n" "help.text" -msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C." +msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + C</emph>." msgstr "" #: 04060107.xhp @@ -14397,7 +14397,7 @@ msgctxt "" "04060107.xhp\n" "par_id3146787\n" "help.text" -msgid "Select a range of cells where you want to insert the array formula and either press F2 or position the cursor in the input line." +msgid "Select a range of cells where you want to insert the array formula and either press <emph>F2</emph> or position the cursor in the input line." msgstr "" #: 04060107.xhp @@ -14405,7 +14405,7 @@ msgctxt "" "04060107.xhp\n" "par_id3154419\n" "help.text" -msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The selected range now contains the array formula." +msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The selected range now contains the array formula." msgstr "" #: 04060107.xhp @@ -14453,7 +14453,7 @@ msgctxt "" "04060107.xhp\n" "par_id3146080\n" "help.text" -msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key, you can create a copy of the array formula in the given range." +msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline> key, you can create a copy of the array formula in the given range." msgstr "" #: 04060107.xhp @@ -14853,7 +14853,7 @@ msgctxt "" "04060107.xhp\n" "par_id3150403\n" "help.text" -msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift+Command+Enter</item> </caseinline><defaultinline><item type=\"keycode\">Shift+Ctrl+Enter</item></defaultinline></switchinline>." +msgid "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>." msgstr "" #: 04060107.xhp @@ -14885,7 +14885,7 @@ msgctxt "" "04060107.xhp\n" "par_id3145777\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array." +msgid "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the <emph>Data</emph> array that are within the values given by the <emph>Classes</emph> array." msgstr "" #: 04060107.xhp @@ -15237,8 +15237,8 @@ msgctxt "" "04060107.xhp\n" "bm_id3151030\n" "help.text" -msgid "<bookmark_value>MDETERM function</bookmark_value> <bookmark_value>determinants</bookmark_value>" -msgstr "<bookmark_value>SIGN function</bookmark_value><bookmark_value>algebraic signs</bookmark_value>" +msgid "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>" +msgstr "" #: 04060107.xhp msgctxt "" @@ -15285,8 +15285,8 @@ msgctxt "" "04060107.xhp\n" "bm_id3151348\n" "help.text" -msgid "<bookmark_value>MINVERSE function</bookmark_value> <bookmark_value>inverse arrays</bookmark_value>" -msgstr "<bookmark_value>SIGN function</bookmark_value><bookmark_value>algebraic signs</bookmark_value>" +msgid "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>" +msgstr "" #: 04060107.xhp msgctxt "" @@ -15437,7 +15437,7 @@ msgctxt "" "04060107.xhp\n" "par_id3159366\n" "help.text" -msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes." +msgid "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes." msgstr "" #: 04060107.xhp @@ -15461,7 +15461,7 @@ msgctxt "" "04060107.xhp\n" "par_id3178518\n" "help.text" -msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift+Command+Enter</emph></caseinline><defaultinline><emph>Shift+Ctrl+Enter</emph></defaultinline></switchinline>. The result will be as follows:" +msgid "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:" msgstr "" #: 04060107.xhp @@ -15541,7 +15541,7 @@ msgctxt "" "04060107.xhp\n" "par_id0811200804502261\n" "help.text" -msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return)." +msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Return</emph> rather than just <emph>Return</emph>)." msgstr "" #: 04060107.xhp @@ -16061,7 +16061,7 @@ msgctxt "" "04060107.xhp\n" "par_id3158106\n" "help.text" -msgid "The formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>" +msgid "The formula in the <emph>Formula</emph> bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>." msgstr "" #: 04060107.xhp @@ -16077,7 +16077,7 @@ msgctxt "" "04060107.xhp\n" "bm_id3158146\n" "help.text" -msgid "<bookmark_value>slopes, see also regression lines</bookmark_value> <bookmark_value>regression lines;LINEST function</bookmark_value>" +msgid "<bookmark_value>slopes, see also regression lines</bookmark_value><bookmark_value>regression lines; LINEST function</bookmark_value>" msgstr "" #: 04060107.xhp @@ -16101,7 +16101,7 @@ msgctxt "" "04060107.xhp\n" "bm_id3158204\n" "help.text" -msgid "<bookmark_value>standard errors;array functions</bookmark_value>" +msgid "<bookmark_value>standard errors; array functions</bookmark_value>" msgstr "" #: 04060107.xhp @@ -16253,7 +16253,7 @@ msgctxt "" "04060107.xhp\n" "bm_id3163286\n" "help.text" -msgid "<bookmark_value>SUMPRODUCT function</bookmark_value> <bookmark_value>scalar products</bookmark_value> <bookmark_value>dot products</bookmark_value> <bookmark_value>inner products</bookmark_value>" +msgid "<bookmark_value>SUMPRODUCT function</bookmark_value><bookmark_value>scalar products</bookmark_value><bookmark_value>dot products</bookmark_value><bookmark_value>inner products</bookmark_value>" msgstr "" #: 04060107.xhp @@ -16277,7 +16277,7 @@ msgctxt "" "04060107.xhp\n" "par_id3163347\n" "help.text" -msgid "SUMPRODUCT(Array1; Array2...Array30)" +msgid "SUMPRODUCT(Array1; Array2; ...; Array30)" msgstr "" #: 04060107.xhp @@ -16285,7 +16285,7 @@ msgctxt "" "04060107.xhp\n" "par_id3163362\n" "help.text" -msgid "<emph>Array1, Array2...Array30</emph> represent arrays whose corresponding elements are to be multiplied." +msgid "<emph>Array1, Array2; ...; Array30</emph> represent arrays whose corresponding elements are to be multiplied." msgstr "" #: 04060107.xhp @@ -16685,7 +16685,7 @@ msgctxt "" "04060107.xhp\n" "par_id3166196\n" "help.text" -msgid "<emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0." +msgid "<emph>LinearType</emph> (optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0." msgstr "" #: 04060107.xhp @@ -16693,7 +16693,7 @@ msgctxt "" "04060107.xhp\n" "par_id3166245\n" "help.text" -msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated from the output data is displayed." +msgid "Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field, click <emph>OK</emph>. The trend data calculated from the output data is displayed." msgstr "" #: 04060107.xhp @@ -16701,8 +16701,8 @@ msgctxt "" "04060107.xhp\n" "bm_id3166317\n" "help.text" -msgid "<bookmark_value>GROWTH function</bookmark_value> <bookmark_value>exponential trends in arrays</bookmark_value>" -msgstr "<bookmark_value>SIGN function</bookmark_value><bookmark_value>algebraic signs</bookmark_value>" +msgid "<bookmark_value>GROWTH function</bookmark_value><bookmark_value>exponential trends in arrays</bookmark_value>" +msgstr "" #: 04060107.xhp msgctxt "" @@ -16757,7 +16757,7 @@ msgctxt "" "04060107.xhp\n" "par_id3173817\n" "help.text" -msgid "<emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." +msgid "<emph>FunctionType</emph> (optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." msgstr "" #: 04060107.xhp @@ -16765,7 +16765,7 @@ msgctxt "" "04060107.xhp\n" "par_id3173852\n" "help.text" -msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>." +msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>." msgstr "" #: 04060108.xhp @@ -24325,7 +24325,7 @@ msgctxt "" "04060115.xhp\n" "par_id3156294\n" "help.text" -msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes places between 0 and the lower limit." +msgid "<emph>UpperLimit</emph> is optional. It is the upper limit of the integral. If this value is missing, the calculation takes place between 0 and the lower limit." msgstr "" #: 04060115.xhp @@ -24373,7 +24373,7 @@ msgctxt "" "04060115.xhp\n" "par_id2949715\n" "help.text" -msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes places between 0 and this limit." +msgid "<emph>LowerLimit</emph> is the limit of the integral. The calculation takes place between 0 and this limit." msgstr "" #: 04060115.xhp @@ -59661,7 +59661,7 @@ msgctxt "" "xml_source.xhp\n" "hd_id240920171003006302\n" "help.text" -msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source (Experimental)</link>" +msgid "<link href=\"text/scalc/01/xml_source.xhp\">XML Source</link>" msgstr "" #: xml_source.xhp |