diff options
Diffstat (limited to 'source/ru/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/ru/helpcontent2/source/text/scalc/01.po | 552 |
1 files changed, 375 insertions, 177 deletions
diff --git a/source/ru/helpcontent2/source/text/scalc/01.po b/source/ru/helpcontent2/source/text/scalc/01.po index 654239d095d..15895737509 100644 --- a/source/ru/helpcontent2/source/text/scalc/01.po +++ b/source/ru/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: 01\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2021-04-12 12:06+0200\n" +"POT-Creation-Date: 2021-04-27 17:02+0200\n" "PO-Revision-Date: 2020-11-26 21:36+0000\n" "Last-Translator: bormant <bormant@mail.ru>\n" "Language-Team: Russian <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/ru/>\n" @@ -4948,15 +4948,6 @@ msgctxt "" msgid "<emph>Weight</emph>" msgstr "" -#. BdjTH -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id41616246075884\n" -"help.text" -msgid ">600" -msgstr "" - #. 4SkNQ #: 04060101.xhp msgctxt "" @@ -5002,15 +4993,6 @@ msgctxt "" msgid "<emph>Grade</emph>" msgstr "" -#. FsLvK -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id71616250414319\n" -"help.text" -msgid ">7" -msgstr "" - #. hfPeb #: 04060101.xhp msgctxt "" @@ -5074,24 +5056,6 @@ msgctxt "" msgid "<emph>Age</emph>" msgstr "" -#. 5zWEA -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id411616252568693\n" -"help.text" -msgid ">=8" -msgstr "" - -#. ceFqk -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id441616252573495\n" -"help.text" -msgid "<=10" -msgstr "" - #. 6Dk9D #: 04060101.xhp msgctxt "" @@ -5119,15 +5083,6 @@ msgctxt "" msgid "<emph>Name</emph>" msgstr "" -#. uDvpq -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id251616253264022\n" -"help.text" -msgid "F*" -msgstr "" - #. qBB4C #: 04060101.xhp msgctxt "" @@ -5155,15 +5110,6 @@ msgctxt "" msgid "<emph>Name</emph>" msgstr "" -#. PJCE2 -#: 04060101.xhp -msgctxt "" -"04060101.xhp\n" -"par_id761616253649791\n" -"help.text" -msgid "[ABC].*" -msgstr "" - #. NyqFV #: 04060101.xhp msgctxt "" @@ -5173,13 +5119,13 @@ msgctxt "" msgid "This simple example shows the use of regular expressions. For this example to work as intended, select to enable regular expressions at <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and Charles)." msgstr "" -#. jLLao +#. KBZPC #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3150882\n" "help.text" -msgid "<bookmark_value>DCOUNT function</bookmark_value> <bookmark_value>counting rows;with numeric values</bookmark_value>" +msgid "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>" msgstr "" #. DLGGD @@ -5236,13 +5182,13 @@ msgctxt "" msgid "The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; \"Distance\"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; \"Name\"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric." msgstr "" -#. m4a6A +#. tGFyD #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3156123\n" "help.text" -msgid "<bookmark_value>DCOUNTA function</bookmark_value> <bookmark_value>records;counting in Calc databases</bookmark_value> <bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" +msgid "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" msgstr "" #. aJdyL @@ -5299,13 +5245,13 @@ msgctxt "" msgid "The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; \"Distance\"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; \"Name\"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument." msgstr "" -#. ZFJzE +#. GasLC #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3147256\n" "help.text" -msgid "<bookmark_value>DGET function</bookmark_value> <bookmark_value>cell contents;searching in Calc databases</bookmark_value> <bookmark_value>searching;cell contents in Calc databases</bookmark_value>" +msgid "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>" msgstr "" #. wj7ck @@ -5371,13 +5317,13 @@ msgctxt "" msgid "If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10)." msgstr "" -#. umeGw +#. rB9Ek #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3149766\n" "help.text" -msgid "<bookmark_value>DMAX function</bookmark_value> <bookmark_value>maximum values in Calc databases</bookmark_value> <bookmark_value>searching;maximum values in columns</bookmark_value>" +msgid "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>" msgstr "" #. MDBf2 @@ -5434,13 +5380,13 @@ msgctxt "" msgid "Insert the formula <input>=DMAX(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned." msgstr "" -#. 5cyyS +#. CnaXx #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3159141\n" "help.text" -msgid "<bookmark_value>DMIN function</bookmark_value> <bookmark_value>minimum values in Calc databases</bookmark_value> <bookmark_value>searching;minimum values in columns</bookmark_value>" +msgid "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>" msgstr "" #. iGV4a @@ -5497,13 +5443,13 @@ msgctxt "" msgid "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned." msgstr "" -#. WppQu +#. XEu9j #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3154274\n" "help.text" -msgid "<bookmark_value>DAVERAGE function</bookmark_value> <bookmark_value>averages; in Calc databases</bookmark_value> <bookmark_value>calculating;averages in Calc databases</bookmark_value>" +msgid "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>" msgstr "" #. dQciw @@ -5560,13 +5506,13 @@ msgctxt "" msgid "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned." msgstr "" -#. B6fYC +#. 6fcFr #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3159269\n" "help.text" -msgid "<bookmark_value>DPRODUCT function</bookmark_value> <bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" +msgid "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" msgstr "" #. gvW9Q @@ -5623,13 +5569,13 @@ msgctxt "" msgid "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned." msgstr "" -#. QGMit +#. KsVCV #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3148462\n" "help.text" -msgid "<bookmark_value>DSTDEV function</bookmark_value> <bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" +msgid "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" msgstr "" #. EvGNP @@ -5695,13 +5641,13 @@ msgctxt "" msgid "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned." msgstr "" -#. A72yR +#. VRXXy #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3150429\n" "help.text" -msgid "<bookmark_value>DSTDEVP function</bookmark_value> <bookmark_value>standard deviations in databases;based on populations</bookmark_value>" +msgid "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>" msgstr "" #. FpESx @@ -5758,13 +5704,13 @@ msgctxt "" msgid "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned." msgstr "" -#. gXoTJ +#. Z2CTY #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3154794\n" "help.text" -msgid "<bookmark_value>DSUM function</bookmark_value> <bookmark_value>calculating;sums in Calc databases</bookmark_value> <bookmark_value>sums;cells in Calc databases</bookmark_value>" +msgid "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>" msgstr "" #. ybMg9 @@ -5821,13 +5767,13 @@ msgctxt "" msgid "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned." msgstr "" -#. fbsJf +#. YBFb7 #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3155614\n" "help.text" -msgid "<bookmark_value>DVAR function</bookmark_value> <bookmark_value>variances;based on samples</bookmark_value>" +msgid "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" msgstr "" #. G6ZBW @@ -5893,13 +5839,13 @@ msgctxt "" msgid "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned." msgstr "" -#. sGiDz +#. 7FWS4 #: 04060101.xhp msgctxt "" "04060101.xhp\n" "bm_id3153880\n" "help.text" -msgid "<bookmark_value>DVARP function</bookmark_value> <bookmark_value>variances;based on populations</bookmark_value>" +msgid "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" msgstr "" #. XpcPC @@ -14398,15 +14344,6 @@ msgctxt "" msgid "<emph>Range</emph> is the range to which the criterion is to be applied." msgstr "" -#. 7FPaC -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152062\n" -"help.text" -msgid "<emph>Criterion</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criterion is written into the formula, it has to be surrounded by double quotes." -msgstr "" - #. FCxrw #: 04060106.xhp msgctxt "" @@ -18790,32 +18727,32 @@ msgctxt "" msgid "VLOOKUP" msgstr "VLOOKUP" -#. E5F2D +#. qFEgu #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149984\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." +msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." msgstr "" -#. 8FhyJ +#. j8RoY #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150156\n" "help.text" -msgid "=VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" +msgid "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" msgstr "" -#. 7FsgG +#. LDrCq #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149289\n" "help.text" -msgid "<emph>SearchCriterion</emph> is the value searched for in the first column of the array." -msgstr "<emph>Условие_поиска</emph>: значение для поиска в первом столбце массива." +msgid "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." +msgstr "" #. WFj5E #: 04060109.xhp @@ -18835,13 +18772,13 @@ msgctxt "" msgid "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." msgstr "<emph>Индекс</emph>: количество столбцов в массиве, который содержит возвращаемое значение. Первому столбцу соответствует номер 1." -#. QV6iE +#. qKRbD #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3151208\n" "help.text" -msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." +msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." msgstr "" #. fJQRf @@ -19024,23 +18961,23 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." msgstr "<ahelp hid=\"HID_FUNC_VERGLEICH\">Возвращает относительную позицию в массиве элемента, который совпадает с заданным значением.</ahelp> Функция возвращает позицию значения, найденного в массиве, в виде числа." -#. FsB8G +#. AKi9E #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3159152\n" "help.text" -msgid "MATCH(SearchCriterion; LookupArray [; Type])" +msgid "MATCH(Search; LookupArray [; Type])" msgstr "" -#. BmVBr +#. KZU4F #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149336\n" "help.text" -msgid "<emph>SearchCriterion</emph> is the value which is to be searched for in the single-row or single-column array." -msgstr "<emph>Условие_поиска</emph>: значение для поиска в массиве с одной строкой или столбцом." +msgid "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." +msgstr "" #. 9j4xw #: 04060109.xhp @@ -19285,23 +19222,23 @@ msgctxt "" msgid "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." msgstr "Если с помощью функции LOOKUP не удаётся установить критерий поиска, то он соответствует самому большому значению в векторе просмотра, который меньше, чем критерий поиска, или равен ему." -#. 4nBA6 +#. sLcHB #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154104\n" "help.text" -msgid "LOOKUP(SearchCriterion; SearchVector [; ResultVector])" +msgid "LOOKUP(Lookup; SearchVector [; ResultVector])" msgstr "" -#. QdiFz +#. yGLLE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150646\n" "help.text" -msgid "<emph>SearchCriterion</emph> is the value to be searched for; entered either directly or as a reference." -msgstr "<emph>Условие_поиска</emph>: значение для поиска, которое вводится вручную или посредством создания ссылки на него." +msgid "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference." +msgstr "" #. tFDBC #: 04060109.xhp @@ -19519,13 +19456,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">Служит для поиска значения и ссылки на ячейки в выделенной области.</ahelp> Эта функция проверяет первую строку массива на наличие определенного значения. Функция возвращает значение в тот же столбец в строку массива в соответствии с её номером в <emph>индексе</emph>." -#. y6is6 +#. NWzFA #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3146070\n" "help.text" -msgid "HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" +msgid "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" msgstr "" #. nhwwF @@ -23767,6 +23704,15 @@ msgctxt "" msgid "<emph>Input</emph>: Any number of types (double&, char*, double*, char**, Cell area), where the <link href=\"text/scalc/01/04060112.xhp\" name=\"Cell area\">Cell area</link> is an array of types double array, string array, or cell array." msgstr "" +#. BJLCP +#: 04060112.xhp +msgctxt "" +"04060112.xhp\n" +"hd_id3150653\n" +"help.text" +msgid "GetFunctionCount()" +msgstr "GetFunctionCount()" + #. Hs7Du #: 04060112.xhp msgctxt "" @@ -23803,6 +23749,15 @@ msgctxt "" msgid "<emph>Output</emph>: Reference to a variable, which is supposed to contain the number of Add-In functions. For example: If the Add-In provides 5 functions for $[officename] Calc, then nCount=5." msgstr "" +#. GFJes +#: 04060112.xhp +msgctxt "" +"04060112.xhp\n" +"hd_id3147476\n" +"help.text" +msgid "GetFunctionData()" +msgstr "GetFunctionData()" + #. MMvZL #: 04060112.xhp msgctxt "" @@ -23884,6 +23839,15 @@ msgctxt "" msgid "The pFuncName and pInternalName parameters are char arrays, which are implemented with size 256 in $[officename] Calc." msgstr "Параметры pFuncName и pInternalName являются массивами символов с размером 256 в $[officename] Calc." +#. BDeUC +#: 04060112.xhp +msgctxt "" +"04060112.xhp\n" +"hd_id3148567\n" +"help.text" +msgid "GetParameterDescription()" +msgstr "GetParameterDescription()" + #. sF27k #: 04060112.xhp msgctxt "" @@ -24919,14 +24883,14 @@ msgctxt "" msgid "The Add-in functions are supplied by the <link href=\"text/sbasic/shared/calc_functions.xhp\" name=\"addinanalysis\">UNO <literal>com.sun.star.sheet.addin.Analysis</literal> service</link>." msgstr "" -#. fCaeG +#. zKa2G #: 04060115.xhp msgctxt "" "04060115.xhp\n" "bm_id3153074\n" "help.text" -msgid "<bookmark_value>Bessel functions</bookmark_value>" -msgstr "<bookmark_value>функции Бесселя</bookmark_value>" +msgid "<bookmark_value>Bessel functions</bookmark_value> <bookmark_value>BESSELI function</bookmark_value>" +msgstr "" #. YpfCj #: 04060115.xhp @@ -25000,6 +24964,15 @@ msgctxt "" msgid "=BESSELI(-1, 3), returns -0.022168424924332" msgstr "" +#. eDJhC +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"bm_id161618267677640\n" +"help.text" +msgid "<bookmark_value>BESSELJ function</bookmark_value>" +msgstr "" + #. Cccmx #: 04060115.xhp msgctxt "" @@ -25072,6 +25045,15 @@ msgctxt "" msgid "=BESSELJ(-1, 3), returns -0.019563353982668" msgstr "" +#. xVEFS +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"bm_id151618267791726\n" +"help.text" +msgid "<bookmark_value>BESSELK function</bookmark_value>" +msgstr "" + #. jb2FF #: 04060115.xhp msgctxt "" @@ -25144,6 +25126,15 @@ msgctxt "" msgid "=BESSELK(0, 3), returns Err:502 – invalid argument (X=0)" msgstr "" +#. PndsN +#: 04060115.xhp +msgctxt "" +"04060115.xhp\n" +"bm_id201618267836525\n" +"help.text" +msgid "<bookmark_value>BESSELY function</bookmark_value>" +msgstr "" + #. 9PCdq #: 04060115.xhp msgctxt "" @@ -32947,14 +32938,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">Returns the number of cells that meet with certain criteria within a cell range.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">Возвращает количество ячеек, соответствующих определенным критериям, в диапазоне ячеек.</ahelp>" -#. GxU5g +#. ZS8Ej #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3164967\n" "help.text" -msgid "COUNTIF(Range; Criteria)" -msgstr "COUNTIF(Диапазон; Условие)" +msgid "COUNTIF(Range; Criterion)" +msgstr "" #. sxGvB #: 04060181.xhp @@ -32965,15 +32956,6 @@ msgctxt "" msgid "<emph>Range</emph> is the range to which the criteria are to be applied." msgstr "<emph>Диапазон</emph>: диапазон ячеек, которые требуется проверить на соответствие условию." -#. HvRLc -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"par_id3165000\n" -"help.text" -msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted." -msgstr "" - #. ZpDRv #: 04060181.xhp msgctxt "" @@ -47941,22 +47923,40 @@ msgctxt "" msgid "Protecting Sheet" msgstr "Защита листа" -#. z8zCf +#. du7pC +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"bm_id141619439455954\n" +"help.text" +msgid "<bookmark_value>insert rows;protected sheet</bookmark_value><bookmark_value>insert columns;protected sheet</bookmark_value><bookmark_value>delete columns;protected sheet</bookmark_value><bookmark_value>delete rows;protected sheet</bookmark_value><bookmark_value>protected sheet;insert columns</bookmark_value><bookmark_value>protected sheet;insert rows</bookmark_value><bookmark_value>protected sheet;delete rows</bookmark_value><bookmark_value>protected sheet;delete columns</bookmark_value><bookmark_value>protect;sheet</bookmark_value><bookmark_value>selection;in protected cells</bookmark_value>" +msgstr "" + +#. ZFcP8 #: 06060100.xhp msgctxt "" "06060100.xhp\n" "hd_id3153087\n" "help.text" -msgid "Protecting Sheet" -msgstr "Защита листа" +msgid "<variable id=\"ProtectingSheeth1\"><link href=\"text/scalc/01/06060100.xhp\" name=\"Protecting Sheet\">Protecting Sheet</link></variable>" +msgstr "" -#. HUFRu +#. LcpD8 #: 06060100.xhp msgctxt "" "06060100.xhp\n" "par_id3148664\n" "help.text" -msgid "<variable id=\"tabelletext\"><ahelp hid=\".uno:Protect\">Protects the cells in the current sheet from being modified.</ahelp></variable> Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password." +msgid "<variable id=\"tabelletext\"><ahelp hid=\".uno:Protect\">Protects the cells in the current sheet from being modified.</ahelp></variable>" +msgstr "" + +#. YZ3HB +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id701619429750616\n" +"help.text" +msgid "Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password, and select the elements of the sheet to protect." msgstr "" #. vFHpY @@ -47968,6 +47968,114 @@ msgctxt "" msgid "To protect cells from further editing, the <emph>Protected</emph> check box must be checked on the <link href=\"text/scalc/01/05020600.xhp\" name=\"Format - Cells - Cell Protection\"><emph>Format - Cells - Cell Protection</emph></link> tab page or on the <emph>Format Cells</emph> context menu." msgstr "Для защиты ячеек от дальнейшего изменения необходимо установить флажок <emph>Защитить</emph> на вкладке <link href=\"text/scalc/01/05020600.xhp\" name=\"Формат - Ячейки - Защита ячеек\"><emph>Формат - Ячейки - Защита ячеек</emph></link> или в контекстном меню <emph>Формат ячеек</emph>." +#. eUvfv +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"hd_id901619431276995\n" +"help.text" +msgid "Protect this sheet and contents of the protected cells" +msgstr "" + +#. G5UKV +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id381619431285815\n" +"help.text" +msgid "Mark this checkbox to activate protection of sheet and cell contents." +msgstr "" + +#. SFevC +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"hd_id31619431291108\n" +"help.text" +msgid "Password / Confirm" +msgstr "" + +#. AaZQG +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id851619431300487\n" +"help.text" +msgid "Allows you to enter a password to protect the sheet from unauthorized changes. Confirm the password entered in the first box." +msgstr "" + +#. WX7Gh +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"hd_id711619431316966\n" +"help.text" +msgid "Allow users of this sheet to" +msgstr "" + +#. skcWB +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id41619431361278\n" +"help.text" +msgid "Select the elements to protect from user actions:" +msgstr "" + +#. 9Mc4m +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id661619430257262\n" +"help.text" +msgid "<emph>Select protected cells</emph>: mark this checkbox to allow you to select protected cells. When the checkbox is unmarked, you cannot select protected cells, the cursor cannot enter in a protected range." +msgstr "" + +#. UqBRQ +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id921619430295947\n" +"help.text" +msgid "<emph>Select unprotected cells</emph>: mark this checkbox to allow user to select unprotected cells. When the checkbox is unmarked, user cannot select unprotected cells, the cursor cannot enter in a unprotected cell or range." +msgstr "" + +#. R6DuD +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id101619430333784\n" +"help.text" +msgid "<emph>Insert columns</emph>: Allow column insertions even when the sheet is protected. Note that when column insertions is enabled, you can insert columns even when the range to insert the new columns into contains protected cells which will get shifted after the insertion. Cells of the newly inserted columns inherit the Protection property of the range it belongs: when the new cell is inside a protected range, the cell is protected, and when it is in an unprotected range, the cell is unprotected." +msgstr "" + +#. 36hCi +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id891619430338809\n" +"help.text" +msgid "<emph>Insert rows</emph>: Allow row insertions even when the sheet is protected. Note that when row insertions is enabled, you can insert rows even when the range to insert the new rows into contains protected cells which will get shifted after the insertion. Cells of the newly inserted rows inherit the Protection property of the range it belongs: when the new cell is inside a protected range it is protected, and when it is in an unprotected range, the cell is unprotected." +msgstr "" + +#. hGXEq +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id311619430374686\n" +"help.text" +msgid "<emph>Delete columns</emph>: Allow column deletions. Note that column deletions are only allowed on unprotected cells." +msgstr "" + +#. ebwLU +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id561619430376854\n" +"help.text" +msgid "<emph>Delete rows</emph>: Allow row deletions. Note that row deletions are only allowed on unprotected cells." +msgstr "" + #. cE3Ff #: 06060100.xhp msgctxt "" @@ -48004,13 +48112,40 @@ msgctxt "" msgid "On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited." msgstr "" -#. VfJA6 +#. JQWv7 #: 06060100.xhp msgctxt "" "06060100.xhp\n" "par_id3149566\n" "help.text" -msgid "To later change an unprotected area to a protected area, select the range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page, check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect Sheet</emph> menu. The previously editable range is now protected." +msgid "To later change an unprotected area to a protected area:" +msgstr "" + +#. TzTnE +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id101619439013221\n" +"help.text" +msgid "Select the range of cells that will be protected." +msgstr "" + +#. Cc2Tb +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id601619439028536\n" +"help.text" +msgid "On the <menuitem>Format - Cells - Cell Protection</menuitem> tab page, check the <emph>Protected</emph> box." +msgstr "" + +#. EeKFF +#: 06060100.xhp +msgctxt "" +"06060100.xhp\n" +"par_id641619439061892\n" +"help.text" +msgid "Choose the <menuitem>Tools - Protect Sheet</menuitem> menu. The previously editable range is now protected." msgstr "" #. JaC9W @@ -48031,13 +48166,13 @@ msgctxt "" msgid "If a sheet is protected, you will not be able to modify or delete any Cell Styles." msgstr "Если лист защищён, нельзя удалять и изменять стили ячеек." -#. d39My +#. WEsxm #: 06060100.xhp msgctxt "" "06060100.xhp\n" "par_id3154656\n" "help.text" -msgid "A protected sheet or cell range can no longer be modified until this protection is disabled. To disable the protection, choose the <emph>Tools - Protect Sheet</emph> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password." +msgid "A protected sheet or cell range can no longer be modified until this protection is disabled, with the exceptions of the settings for columns and row of the <menuitem>Tools - Protect Sheet</menuitem> dialog. To disable the protection, choose the <menuitem>Tools - Protect Sheet</menuitem> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password." msgstr "" #. scXrG @@ -48049,24 +48184,6 @@ msgctxt "" msgid "Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command." msgstr "После сохранения защищённые листы можно сохранить снова только командой <emph>Файл - Сохранить как</emph>." -#. A4TcK -#: 06060100.xhp -msgctxt "" -"06060100.xhp\n" -"hd_id3150206\n" -"help.text" -msgid "<link href=\"text/shared/01/password_dlg.xhp\" name=\"Password\">Password (optional)</link>" -msgstr "" - -#. hBPMK -#: 06060100.xhp -msgctxt "" -"06060100.xhp\n" -"par_id3152990\n" -"help.text" -msgid "<ahelp hid=\"modules/scalc/ui/protectsheetdlg/password1\">Allows you to enter a password to protect the sheet from unauthorized changes.</ahelp>" -msgstr "" - #. Gr24z #: 06060100.xhp msgctxt "" @@ -54835,13 +54952,13 @@ msgctxt "" msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." msgstr "" -#. 5DDEz +#. YXQmf #: 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][; … ; [Range127; Criterion127]]</variable>" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable>" msgstr "" #. d8gmy @@ -54871,13 +54988,103 @@ msgctxt "" msgid "<emph>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, to which the corresponding criterion is to be applied." msgstr "" -#. 3wJSR +#. 45WHz #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id23526994221948\n" +"par_id621619279022341\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>)." +msgid "<emph>Criterion</emph>: A criterion is a single cell Reference, Number or Text. It is used in comparisons with cell contents." +msgstr "" + +#. m9EAG +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id731619279029255\n" +"help.text" +msgid "A reference to an empty cell is interpreted as the numeric value 0." +msgstr "" + +#. iYNFV +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id31619279035359\n" +"help.text" +msgid "A matching expression can be:" +msgstr "" + +#. fSoyL +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id171619279059462\n" +"help.text" +msgid "A Number or Logical value. A matching cell content equals the Number or Logical value." +msgstr "" + +#. 7Hfq9 +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id511619279076504\n" +"help.text" +msgid "A value beginning with a comparator (<, <=, =, >, >=, <>)." +msgstr "" + +#. YEjSD +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id11619279168512\n" +"help.text" +msgid "For =, if the value is empty it matches empty cells." +msgstr "" + +#. 39AJR +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id161619279207350\n" +"help.text" +msgid "For <>, if the value is empty it matches non-empty cells." +msgstr "" + +#. 9xDer +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id271619279215695\n" +"help.text" +msgid "For <>, if the value is not empty it matches any cell content except the value, including empty cells." +msgstr "" + +#. y2EGU +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id861619279223855\n" +"help.text" +msgid "<emph>Note:</emph> \"=0\" does not match empty cells." +msgstr "" + +#. 2nrnV +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id51619279363954\n" +"help.text" +msgid "For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes and the property <link href=\"text/shared/optionen/01060500.xhp\" name=\"s\">Search criteria = and <> must apply to whole cells</link> is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies." +msgstr "" + +#. VG8wZ +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id801619279323556\n" +"help.text" +msgid "Other Text value. If the property <link href=\"text/shared/optionen/01060500.xhp\" name=\"s\">Search criteria = and <> must apply to whole cells</link> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. 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 "" #. sACAB @@ -54889,13 +55096,13 @@ msgctxt "" msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." msgstr "" -#. NygMb +#. FyA7p #: 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." +msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion." msgstr "" #. tzFDE @@ -56176,15 +56383,6 @@ msgctxt "" msgid "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition." msgstr "" -#. tSkGD -#: func_averageif.xhp -msgctxt "" -"func_averageif.xhp\n" -"par_id24499731228013\n" -"help.text" -msgid "<emph>Criterion</emph> – required argument. A condition in the form of expression or a cell reference with 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 "" - #. sDeiD #: func_averageif.xhp msgctxt "" @@ -57346,14 +57544,14 @@ msgctxt "" msgid "<bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value>" msgstr "" -#. NRDey +#. wMH8u #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" "hd_id456845684568\n" "help.text" -msgid "<variable id=\"countifs_head\"><link href=\"text/scalc/01/func_countifs.xhp\">COUNTIFS</link></variable> function" -msgstr "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SECOND</link></variable>" +msgid "<variable id=\"countifs_head\"><link href=\"text/scalc/01/func_countifs.xhp\">COUNTIFS</link></variable>" +msgstr "" #. pGTzr #: func_countifs.xhp @@ -57364,13 +57562,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" msgstr "" -#. xRjyE +#. fyEW6 #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" "par_id27421466710275\n" "help.text" -msgid "COUNTIFS(Range1; Criterion1[; Range2; Criterion2][; ... ; [Range127; Criterion127]])" +msgid "COUNTIFS(Range1; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])" msgstr "" #. 2BB8K @@ -63331,14 +63529,14 @@ msgctxt "" msgid "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>" msgstr "<bookmark_value>функция COMBIN</bookmark_value><bookmark_value>количество комбинаций</bookmark_value>" -#. b5txh +#. MpUwQ #: func_sumifs.xhp msgctxt "" "func_sumifs.xhp\n" "hd_id658866588665886\n" "help.text" -msgid "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable> function" -msgstr "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SECOND</link></variable>" +msgid "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable>" +msgstr "" #. ZEdvF #: func_sumifs.xhp @@ -64717,13 +64915,13 @@ msgctxt "" msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1" msgstr "" -#. NHnKC +#. ADL9J #: func_weeknum.xhp msgctxt "" "func_weeknum.xhp\n" "par_id3149792\n" "help.text" -msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);2)</item> returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year." +msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year." msgstr "" #. yBDGQ |