diff options
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/en-GB/helpcontent2/source/text/scalc/01.po | 803 |
1 files changed, 514 insertions, 289 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po index e3e89d21c66..7fbf93ff70e 100644 --- a/source/en-GB/helpcontent2/source/text/scalc/01.po +++ b/source/en-GB/helpcontent2/source/text/scalc/01.po @@ -3,8 +3,8 @@ 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-05-08 15:11+0200\n" -"PO-Revision-Date: 2018-01-01 13:00+0000\n" +"POT-Creation-Date: 2018-07-02 00:14+0200\n" +"PO-Revision-Date: 2018-06-25 17:43+0000\n" "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: en_GB\n" @@ -14,7 +14,7 @@ msgstr "" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Accelerator-Marker: ~\n" "X-Generator: LibreOffice\n" -"X-POOTLE-MTIME: 1514811638.000000\n" +"X-POOTLE-MTIME: 1529948606.000000\n" #: 01120000.xhp msgctxt "" @@ -1190,7 +1190,7 @@ msgctxt "" "par_id3148797\n" "help.text" msgid "<variable id=\"reihenfuellentext\"><ahelp hid=\".uno:FillSeries\">Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.</ahelp> </variable>" -msgstr "" +msgstr "<variable id=\"reihenfuellentext\"><ahelp hid=\".uno:FillSeries\">Automatically generate series with the options in this dialogue box. Determine direction, increment, time unit and series type.</ahelp> </variable>" #: 02140600.xhp msgctxt "" @@ -1406,7 +1406,7 @@ msgctxt "" "par_id3148605\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/filldlg/day\">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/day\">Use the <emph>Date</emph> series type and this option to create a series using all seven days of the week. Unit of <emph>Increment</emph> is day.</ahelp>" #: 02140600.xhp msgctxt "" @@ -1422,7 +1422,7 @@ msgctxt "" "par_id3150108\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/filldlg/week\">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/week\">Use the <emph>Date</emph> series type and this option to create a series only using the five weekdays. Unit of <emph>Increment</emph> is day.</ahelp>" #: 02140600.xhp msgctxt "" @@ -1438,7 +1438,7 @@ msgctxt "" "par_id3149126\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/filldlg/month\">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/month\">Use the <emph>Date</emph> series type and this option to form a series which unit of <emph>Increment</emph> is month.</ahelp>" #: 02140600.xhp msgctxt "" @@ -1454,7 +1454,7 @@ msgctxt "" "par_id3151300\n" "help.text" msgid "<ahelp hid=\"modules/scalc/ui/filldlg/year\">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"modules/scalc/ui/filldlg/year\">Use the <emph>Date</emph> series type and this option to create a series which unit of <emph>Increment</emph> is year.</ahelp>" #: 02140600.xhp msgctxt "" @@ -2550,7 +2550,7 @@ msgctxt "" "par_id3153969\n" "help.text" msgid "<ahelp hid=\"SC_HID_SELECTTABLES\">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp>" -msgstr "" +msgstr "<ahelp hid=\"SC_HID_SELECTTABLES\">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp>" #: 03070000.xhp msgctxt "" @@ -2641,12 +2641,13 @@ msgid "To remove the highlighting, unmark the menu entry." msgstr "To remove the highlighting, unmark the menu entry." #: 03080000.xhp +#, fuzzy msgctxt "" "03080000.xhp\n" "par_id3145784\n" "help.text" msgid "By default:" -msgstr "" +msgstr "By default:" #: 03080000.xhp msgctxt "" @@ -2662,7 +2663,7 @@ msgctxt "" "par_id3145786\n" "help.text" msgid "These colors can be customized in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME - Application Colors</item>." -msgstr "" +msgstr "These colours can be customised in <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - %PRODUCTNAME - Application Colours</item>." #: 03080000.xhp msgctxt "" @@ -4230,7 +4231,7 @@ msgctxt "" "par_id3882869\n" "help.text" msgid "See also the Wiki page about <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation\">Conditional Counting and Summation</link>." -msgstr "" +msgstr "See also the Wiki page about <link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation\" name=\"wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation\">Conditional Counting and Summation</link>." #: 04060101.xhp msgctxt "" @@ -9950,7 +9951,7 @@ msgctxt "" "par_id3149312\n" "help.text" msgid "<variable id=\"logischtext\">This category contains the <emph>Logical</emph> functions.</variable>" -msgstr "" +msgstr "<variable id=\"logischtext\">This category contains the <emph>Logical</emph> functions.</variable>" #: 04060105.xhp msgctxt "" @@ -9958,7 +9959,7 @@ msgctxt "" "hd_id631520887352751\n" "help.text" msgid "Handling non-logical arguments in logical functions" -msgstr "" +msgstr "Handling non-logical arguments in logical functions" #: 04060105.xhp msgctxt "" @@ -9966,7 +9967,7 @@ msgctxt "" "par_id431520887384579\n" "help.text" msgid "Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE." -msgstr "" +msgstr "Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE." #: 04060105.xhp msgctxt "" @@ -9974,7 +9975,7 @@ msgctxt "" "par_id881520887475288\n" "help.text" msgid "Empty cells and text in cells are ignored." -msgstr "" +msgstr "Empty cells and text in cells are ignored." #: 04060105.xhp msgctxt "" @@ -9982,7 +9983,7 @@ msgctxt "" "par_id461520887504085\n" "help.text" msgid "A #VALUE error is raised if all arguments are ignored." -msgstr "" +msgstr "A #VALUE error is raised if all arguments are ignored." #: 04060105.xhp msgctxt "" @@ -9990,7 +9991,7 @@ msgctxt "" "par_id591520888006686\n" "help.text" msgid "A #VALUE error is raised if one argument is direct text (not text in a cell)." -msgstr "" +msgstr "A #VALUE error is raised if one argument is direct text (not text in a cell)." #: 04060105.xhp msgctxt "" @@ -9998,7 +9999,7 @@ msgctxt "" "par_id321520889630477\n" "help.text" msgid "Errors as argument lead to an error." -msgstr "" +msgstr "Errors as argument lead to an error." #: 04060105.xhp msgctxt "" @@ -10054,7 +10055,7 @@ msgctxt "" "par_id3150038\n" "help.text" msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE." -msgstr "" +msgstr "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE." #: 04060105.xhp msgctxt "" @@ -10350,7 +10351,7 @@ msgctxt "" "par_id3155819\n" "help.text" msgid "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range." -msgstr "" +msgstr "<emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range." #: 04060105.xhp msgctxt "" @@ -13134,7 +13135,7 @@ msgctxt "" "bm_id911516997198644\n" "help.text" msgid "<bookmark_value>CEILING.MATH function</bookmark_value>" -msgstr "" +msgstr "<bookmark_value>CEILING.MATH function</bookmark_value>" #: 04060106.xhp msgctxt "" @@ -13142,7 +13143,7 @@ msgctxt "" "hd_id91516997330445\n" "help.text" msgid "CEILING.MATH" -msgstr "" +msgstr "CEILING.MATH" #: 04060106.xhp msgctxt "" @@ -13150,7 +13151,7 @@ msgctxt "" "par_id81516997342088\n" "help.text" msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>" #: 04060106.xhp msgctxt "" @@ -13158,7 +13159,7 @@ msgctxt "" "hd_id971516997377435\n" "help.text" msgid "Syntax" -msgstr "" +msgstr "Syntax" #: 04060106.xhp msgctxt "" @@ -13166,7 +13167,7 @@ msgctxt "" "par_id841516997669932\n" "help.text" msgid "CEILING.MATH(Number; Significance; Mode)" -msgstr "" +msgstr "CEILING.MATH(Number; Significance; Mode)" #: 04060106.xhp msgctxt "" @@ -13174,7 +13175,7 @@ msgctxt "" "par_id651516997706287\n" "help.text" msgid "<emph>Number</emph> is the number that is to be rounded up." -msgstr "" +msgstr "<emph>Number</emph> is the number that is to be rounded up." #: 04060106.xhp msgctxt "" @@ -13182,7 +13183,7 @@ msgctxt "" "par_id491516997725772\n" "help.text" msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up." -msgstr "" +msgstr "<emph>Significance</emph> is the number that the value is to be rounded up to a multiple of." #: 04060106.xhp msgctxt "" @@ -13190,7 +13191,7 @@ msgctxt "" "par_id451516997742909\n" "help.text" msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero." -msgstr "" +msgstr "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero." #: 04060106.xhp msgctxt "" @@ -13198,7 +13199,7 @@ msgctxt "" "par_id291516998575663\n" "help.text" msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." -msgstr "" +msgstr "This function exists for interoperability with Microsoft Excel 2013 or newer." #: 04060106.xhp msgctxt "" @@ -13206,7 +13207,7 @@ msgctxt "" "hd_id561516997761868\n" "help.text" msgid "Example" -msgstr "" +msgstr "Example" #: 04060106.xhp msgctxt "" @@ -13214,7 +13215,7 @@ msgctxt "" "par_id111516997803684\n" "help.text" msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9" -msgstr "" +msgstr "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9" #: 04060106.xhp msgctxt "" @@ -13222,7 +13223,7 @@ msgctxt "" "par_id1001516997821483\n" "help.text" msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9" -msgstr "" +msgstr "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9" #: 04060106.xhp msgctxt "" @@ -13230,7 +13231,7 @@ msgctxt "" "par_id641516997837754\n" "help.text" msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12" -msgstr "" +msgstr "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12" #: 04060106.xhp msgctxt "" @@ -13238,7 +13239,7 @@ msgctxt "" "bm_id921516998608939\n" "help.text" msgid "<bookmark_value>CEILING.XCL function</bookmark_value>" -msgstr "" +msgstr "<bookmark_value>CEILING.XCL function</bookmark_value>" #: 04060106.xhp msgctxt "" @@ -13246,7 +13247,7 @@ msgctxt "" "hd_id411516998838823\n" "help.text" msgid "CEILING.XCL" -msgstr "" +msgstr "CEILING.XCL" #: 04060106.xhp msgctxt "" @@ -13254,7 +13255,7 @@ msgctxt "" "par_id811516998845826\n" "help.text" msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>" #: 04060106.xhp msgctxt "" @@ -13262,7 +13263,7 @@ msgctxt "" "hd_id361516998851918\n" "help.text" msgid "Syntax" -msgstr "" +msgstr "Syntax" #: 04060106.xhp msgctxt "" @@ -13270,7 +13271,7 @@ msgctxt "" "par_id251516998856873\n" "help.text" msgid "CEILING.XCL(Number; Significance)" -msgstr "" +msgstr "CEILING.XCL(Number; Significance)" #: 04060106.xhp msgctxt "" @@ -13278,7 +13279,7 @@ msgctxt "" "par_id671516998874263\n" "help.text" msgid "<emph>Number</emph> is the number that is to be rounded." -msgstr "" +msgstr "<emph>Number</emph> is the number that is to be rounded." #: 04060106.xhp msgctxt "" @@ -13286,7 +13287,7 @@ msgctxt "" "par_id151516998882622\n" "help.text" msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded." -msgstr "" +msgstr "<emph>Significance</emph> is the value that the number is to be rounded to a multiple of." #: 04060106.xhp msgctxt "" @@ -13294,7 +13295,7 @@ msgctxt "" "par_id341516998889754\n" "help.text" msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions." -msgstr "" +msgstr "This function exists for interoperability with Microsoft Excel 2007 or older versions." #: 04060106.xhp msgctxt "" @@ -13302,7 +13303,7 @@ msgctxt "" "hd_id81516998896303\n" "help.text" msgid "Example" -msgstr "" +msgstr "Example" #: 04060106.xhp msgctxt "" @@ -13310,7 +13311,7 @@ msgctxt "" "par_id91516998917254\n" "help.text" msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3" -msgstr "" +msgstr "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3" #: 04060106.xhp msgctxt "" @@ -13318,7 +13319,7 @@ msgctxt "" "par_id761516998929693\n" "help.text" msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8" -msgstr "" +msgstr "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8" #: 04060106.xhp msgctxt "" @@ -13326,7 +13327,7 @@ msgctxt "" "par_id671516998958873\n" "help.text" msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12" -msgstr "" +msgstr "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12" #: 04060106.xhp msgctxt "" @@ -13958,7 +13959,7 @@ msgctxt "" "par_id7985168\n" "help.text" msgid "QUOTIENT is equivalent to <item type=\"literal\">INT(numerator/denominator)</item> for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to <item type=\"literal\">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>." -msgstr "" +msgstr "QUOTIENT is equivalent to <item type=\"literal\">INT(numerator/denominator)</item> for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to <item type=\"literal\">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>." #: 04060106.xhp msgctxt "" @@ -14645,8 +14646,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3163596\n" "help.text" -msgid "SUM" -msgstr "SUM" +msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -14773,8 +14774,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3151957\n" "help.text" -msgid "SUMIF" -msgstr "SUMIF" +msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -16510,7 +16511,7 @@ msgctxt "" "par_id936615\n" "help.text" msgid "You can view and change the row and column separator in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Calc - Formula - Separators</emph>." -msgstr "" +msgstr "You can view and change the row and column separator in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Calc - Formula - Separators</emph>." #: 04060107.xhp msgctxt "" @@ -19598,7 +19599,7 @@ msgctxt "" "par_id1027200802301521\n" "help.text" msgid "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted." -msgstr "" +msgstr "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted." #: 04060109.xhp msgctxt "" @@ -19731,14 +19732,6 @@ msgstr "<item type=\"input\">=ADDRESS(1;1;2;;\"Sheet2\")</item> returns the foll #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id3159260\n" -"help.text" -msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." -msgstr "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." - -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" "bm_id3150372\n" "help.text" msgid "<bookmark_value>AREAS function</bookmark_value>" @@ -20275,6 +20268,14 @@ msgstr "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> total #: 04060109.xhp msgctxt "" "04060109.xhp\n" +"par_id3159260\n" +"help.text" +msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." +msgstr "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." + +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" "bm_id3154818\n" "help.text" msgid "<bookmark_value>COLUMN function</bookmark_value>" @@ -21070,7 +21071,7 @@ msgctxt "" "par_id3150826\n" "help.text" msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand." -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a colour to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand." #: 04060109.xhp msgctxt "" @@ -21134,7 +21135,7 @@ msgctxt "" "par_id8056886\n" "help.text" msgid "Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example:" -msgstr "" +msgstr "Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example:" #: 04060109.xhp msgctxt "" @@ -21206,7 +21207,7 @@ msgctxt "" "par_id3149939\n" "help.text" msgid "<emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values." -msgstr "" +msgstr "<emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values." #: 04060109.xhp msgctxt "" @@ -21598,7 +21599,7 @@ msgctxt "" "par_id2958769\n" "help.text" msgid "<item type=\"input\">=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</item> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." -msgstr "" +msgstr "<item type=\"input\">=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</item> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." #: 04060109.xhp msgctxt "" @@ -21910,7 +21911,7 @@ msgctxt "" "par_id9912411\n" "help.text" msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." -msgstr "" +msgstr "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." #: 04060110.xhp msgctxt "" @@ -22838,7 +22839,7 @@ msgctxt "" "par_id1551561\n" "help.text" msgid "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." -msgstr "" +msgstr "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\" name=\"wiki.documentfoundation.org Calc/Features/JIS and ASC functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." #: 04060110.xhp msgctxt "" @@ -24726,7 +24727,7 @@ msgctxt "" "par_id3147427\n" "help.text" msgid "<variable id=\"addintext\">The following describes and lists some of the available add-in functions.</variable>" -msgstr "" +msgstr "<variable id=\"addintext\">The following describes and lists some of the available add-in functions.</variable>" #: 04060111.xhp msgctxt "" @@ -35549,8 +35550,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3148437\n" "help.text" -msgid "COUNT" -msgstr "COUNT" +msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35621,8 +35622,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3149729\n" "help.text" -msgid "COUNTA" -msgstr "COUNTA" +msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35693,8 +35694,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3150896\n" "help.text" -msgid "COUNTBLANK" -msgstr "COUNTBLANK" +msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35757,8 +35758,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3164897\n" "help.text" -msgid "COUNTIF" -msgstr "COUNTIF" +msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -41173,8 +41174,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154511\n" "help.text" -msgid "MAX" -msgstr "MAX" +msgid "<variable id=\"max_head\"><link href=\"text/scalc/01/04060184.xhp#max\">MAX</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41253,8 +41254,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166426\n" "help.text" -msgid "MAXA" -msgstr "MAXA" +msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41333,8 +41334,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3153820\n" "help.text" -msgid "MEDIAN" -msgstr "MEDIAN" +msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41405,8 +41406,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154541\n" "help.text" -msgid "MIN" -msgstr "MIN" +msgid "<variable id=\"min_head\"><link href=\"text/scalc/01/04060184.xhp#min\">MIN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41477,8 +41478,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3147504\n" "help.text" -msgid "MINA" -msgstr "MINA" +msgid "<variable id=\"mina_head\"><link href=\"text/scalc/01/04060184.xhp#mina\">MINA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41557,8 +41558,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166465\n" "help.text" -msgid "AVEDEV" -msgstr "AVEDEV" +msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41621,8 +41622,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3145824\n" "help.text" -msgid "AVERAGE" -msgstr "AVERAGE" +msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41685,8 +41686,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3148754\n" "help.text" -msgid "AVERAGEA" -msgstr "AVERAGEA" +msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -56896,6 +56897,78 @@ msgctxt "" msgid "not" msgstr "not" +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id1191767622119\n" +"help.text" +msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id961527953004850\n" +"help.text" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id94162948227556\n" +"help.text" +msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id14734320631377\n" +"help.text" +msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id23526994221948\n" +"help.text" +msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id190621657742\n" +"help.text" +msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id317001803813193\n" +"help.text" +msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id191527781733238\n" +"help.text" +msgid "The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id175721789527973\n" +"help.text" +msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." +msgstr "" + #: exponsmooth_embd.xhp msgctxt "" "exponsmooth_embd.xhp\n" @@ -58184,14 +58257,6 @@ msgctxt "" msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." msgstr "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." -#: func_averageif.xhp -msgctxt "" -"func_averageif.xhp\n" -"par_id171371269326270\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\" />, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>" - #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" @@ -58237,72 +58302,16 @@ msgctxt "" "func_averageifs.xhp\n" "par_id21050267713178\n" "help.text" -msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])" -msgstr "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])" +msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" "par_id165832700711773\n" "help.text" -msgid "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." -msgstr "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id23557225011065\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id115612745015792\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id249477513695\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id157492744623347\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id262061474420658\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it." -msgstr "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id51531273215056\n" -"help.text" -msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502." -msgstr "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id151201977228038\n" -"help.text" -msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text." -msgstr "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text." +msgid "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." +msgstr "" #: func_averageifs.xhp msgctxt "" @@ -58416,14 +58425,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id1279148769260\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_color.xhp msgctxt "" "func_color.xhp\n" @@ -58541,8 +58542,8 @@ msgctxt "" "func_countifs.xhp\n" "par_id462646264626\n" "help.text" -msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>" -msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>" +msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58571,42 +58572,10 @@ msgstr "<emph>Range1</emph> – required argument. It is a range of cells, a nam #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" -"par_id23526994221948\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id190621657742\n" -"help.text" -msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." -msgstr "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id317001803813193\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14223137501158\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria." -msgstr "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id16654883224356\n" +"par_id14734320631377\n" "help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502." -msgstr "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502." +msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58736,14 +58705,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." msgstr "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14337286612130\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\" />, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\" />, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_date.xhp msgctxt "" "func_date.xhp\n" @@ -61544,6 +61505,342 @@ msgctxt "" msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04." +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"tit\n" +"help.text" +msgid "MAXIFS function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"tit\n" +"help.text" +msgid "MINIFS function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." +msgstr "" + #: func_minute.xhp msgctxt "" "func_minute.xhp\n" @@ -62581,80 +62878,16 @@ msgctxt "" "func_sumifs.xhp\n" "par_id11655988824213\n" "help.text" -msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])" -msgstr "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])" +msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_sumifs.xhp msgctxt "" "func_sumifs.xhp\n" "par_id59901690530236\n" "help.text" -msgid "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." -msgstr "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14445505532098\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id24470258022447\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id111151356820933\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631376\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631377\n" -"help.text" -msgid "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument." -msgstr "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id94162948227556\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." -msgstr "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id175721789527973\n" -"help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." -msgstr "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id1191767622119\n" -"help.text" -msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text." -msgstr "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text." +msgid "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." +msgstr "" #: func_sumifs.xhp msgctxt "" @@ -62768,14 +63001,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id11921178730928\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_time.xhp msgctxt "" "func_time.xhp\n" |