diff options
Diffstat (limited to 'source/ko/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/ko/helpcontent2/source/text/scalc/01.po | 1390 |
1 files changed, 1127 insertions, 263 deletions
diff --git a/source/ko/helpcontent2/source/text/scalc/01.po b/source/ko/helpcontent2/source/text/scalc/01.po index d2fdc52b44d..5823f6b59bf 100644 --- a/source/ko/helpcontent2/source/text/scalc/01.po +++ b/source/ko/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2024-03-04 14:25+0100\n" +"POT-Creation-Date: 2024-06-10 14:48+0200\n" "PO-Revision-Date: 2020-12-31 12:36+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: Korean <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/ko/>\n" @@ -556,13 +556,40 @@ msgctxt "" msgid "<link href=\"text/scalc/01/02120100.xhp\">Headers and Footers</link>" msgstr "" -#. H63aE +#. JxLou #: 02120100.xhp msgctxt "" "02120100.xhp\n" "par_id3150768\n" "help.text" -msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/HeaderFooterContent\">Defines or formats a header or footer for the page style in use.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/HeaderFooterContent\">Defines or formats a header or footer for the page style in use. You can define separate settings for the first page and the remaining pages.</ahelp>" +msgstr "" + +#. UGkAn +#: 02120100.xhp +msgctxt "" +"02120100.xhp\n" +"hd_id311715352188970\n" +"help.text" +msgid "Header or Footer (first and rest)" +msgstr "" + +#. DCiEE +#: 02120100.xhp +msgctxt "" +"02120100.xhp\n" +"par_id451715352194958\n" +"help.text" +msgid "Defines the header or footer settings for the first page or the remaining pages." +msgstr "" + +#. NAXZ4 +#: 02120100.xhp +msgctxt "" +"02120100.xhp\n" +"par_id91715352201503\n" +"help.text" +msgid "The distinction between the first page and the remaining pages depends on the selection of <emph>Same content on first page</emph> in Page <link href=\"text/shared/01/05040300.xhp\">Header</link> and <link href=\"text/shared/01/05040300.xhp\">Footer</link>." msgstr "" #. zcpzd @@ -583,6 +610,15 @@ msgctxt "" msgid "<ahelp hid=\"modules/scalc/ui/headerfootercontent/textviewWND_LEFT\">Enter the text to be displayed at the left side of the header or footer.</ahelp>" msgstr "<ahelp hid=\"modules/scalc/ui/headerfootercontent/textviewWND_LEFT\">머리글 또는 바닥글의 왼쪽에 표시할 텍스트를 입력합니다.</ahelp>" +#. s3Zo8 +#: 02120100.xhp +msgctxt "" +"02120100.xhp\n" +"par_id11715352581714\n" +"help.text" +msgid "When <emph>Same content on first page</emph> above is <emph>not</emph> checked, the left area is not available on the first page." +msgstr "" + #. 3yeo5 #: 02120100.xhp msgctxt "" @@ -2509,13 +2545,13 @@ msgctxt "" msgid "<bookmark_value>spreadsheets; moving</bookmark_value><bookmark_value>spreadsheets; copying</bookmark_value><bookmark_value>moving; spreadsheets</bookmark_value><bookmark_value>copying; spreadsheets</bookmark_value>" msgstr "<bookmark_value>스프레드시트; 이동</bookmark_value><bookmark_value>스프레드시트; 복사</bookmark_value><bookmark_value>이동; 스프레드시트</bookmark_value><bookmark_value>복사; 스프레드시트</bookmark_value>" -#. w7TEG +#. ytArs #: 02180000.xhp msgctxt "" "02180000.xhp\n" "hd_id3153360\n" "help.text" -msgid "<variable id=\"movecopy_sheet\"><link href=\"text/scalc/01/02180000.xhp#movecopysheet\">Move or Copy a Sheet</link></variable>" +msgid "<variable id=\"movecopy_sheet\"><link href=\"text/scalc/01/02180000.xhp\">Move or Copy a Sheet</link></variable>" msgstr "" #. Rv8oA @@ -2536,6 +2572,15 @@ msgctxt "" msgid "When you copy and paste cells containing <link href=\"text/scalc/01/04060102.xhp\">date values</link> between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!" msgstr "다른 스프레드시트 간에 <link href=\"text/scalc/01/04060102.xhp\">날짜 값</link>이 들어 있는 셀을 복사하여 붙여 넣을 경우 두 스프레드시트 문서를 날짜 기준으로 설정해야 합니다. 날짜 기준이 다르면 표시되는 날짜 값이 달라집니다.!" +#. GHQ6R +#: 02180000.xhp +msgctxt "" +"02180000.xhp\n" +"par_id3720376688484858\n" +"help.text" +msgid "When the <link href=\"text/shared/01/02230100.xhp\"><menuitem>Record Changes</menuitem></link> command is active, you cannot delete or move sheets." +msgstr "" + #. 3DmMC #: 02180000.xhp msgctxt "" @@ -14002,96 +14047,6 @@ msgctxt "" msgid "<item type=\"input\">=SINH(0)</item> returns 0, the hyperbolic sine of 0." msgstr "<item type=\"input\">=SINH(0)</item>는 0의 쌍곡 사인 값인 0을 반환합니다." -#. LAWCJ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"bm_id3151957\n" -"help.text" -msgid "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" -msgstr "<bookmark_value>SUMIF 함수</bookmark_value><bookmark_value>추가; 지정된 숫자</bookmark_value>" - -#. CGGGj -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id3151957\n" -"help.text" -msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>" -msgstr "" - -#. p2fHt -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3151986\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value." -msgstr "" - -#. GKQGQ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152028\n" -"help.text" -msgid "SUMIF(Range; Criterion [; SumRange])" -msgstr "" - -#. wmLcE -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152043\n" -"help.text" -msgid "<emph>Range</emph> is the range to which the criterion is to be applied." -msgstr "" - -#. FCxrw -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152083\n" -"help.text" -msgid "<emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed." -msgstr "<emph>SumRange</emph>는 더해질 값의 범위를 말합니다. 만일 이 매개 변수가 입력되지 않으면 값을 더해진 범위 안에서 찾아냅니다." - -#. iGKyo -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id8347422\n" -"help.text" -msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." -msgstr "" - -#. uazzL -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id3152148\n" -"help.text" -msgid "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" -msgstr "음수만 더하려면 <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>를 입력하십시오." - -#. GGT9C -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id6670125\n" -"help.text" -msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." -msgstr "" - -#. G5vdm -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"par_id6062196\n" -"help.text" -msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()." -msgstr "SUMIF()에 사용할 수 있는 구문 예를 보려면 COUNTIF()를 참조하십시오." - #. BHGzQ #: 04060106.xhp msgctxt "" @@ -15091,14 +15046,14 @@ msgctxt "" msgid "<bookmark_value>random numbers; between limits</bookmark_value><bookmark_value>RANDBETWEEN function</bookmark_value>" msgstr "" -#. vqzRX +#. BEzhz #: 04060106.xhp msgctxt "" "04060106.xhp\n" "hd_id3164669\n" "help.text" -msgid "RANDBETWEEN" -msgstr "RANDBETWEEN" +msgid "<variable id=\"randbetween\"><link href=\"text/scalc/01/04060106.xhp#randbetween\">RANDBETWEEN</link></variable>" +msgstr "" #. eADpQ #: 04060106.xhp @@ -15163,13 +15118,13 @@ msgctxt "" msgid "<bookmark_value>random numbers non-volatile; between limits</bookmark_value><bookmark_value>RANDBETWEEN.NV function</bookmark_value>" msgstr "" -#. cgHiZ +#. 873Eh #: 04060106.xhp msgctxt "" "04060106.xhp\n" "hd_id171590240366277\n" "help.text" -msgid "RANDBETWEEN.NV" +msgid "<variable id=\"randbetween_nv_1\"><link href=\"text/scalc/01/04060106.xhp#randbetween_nv_1\">RANDBETWEEN.NV</link></variable>" msgstr "" #. Akjyr @@ -15226,14 +15181,14 @@ msgctxt "" msgid "<bookmark_value>RAND function</bookmark_value><bookmark_value>random numbers;between 0 and 1</bookmark_value>" msgstr "" -#. tTc7D +#. uFBEH #: 04060106.xhp msgctxt "" "04060106.xhp\n" "hd_id3164800\n" "help.text" -msgid "RAND" -msgstr "RAND" +msgid "<variable id=\"rand_1\"><link href=\"text/scalc/01/04060106.xhp#rand_1\">RAND</link></variable>" +msgstr "" #. AXnAh #: 04060106.xhp @@ -15316,13 +15271,13 @@ msgctxt "" msgid "<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value><bookmark_value>RAND.NV function</bookmark_value>" msgstr "" -#. q9iLd +#. mDVmJ #: 04060106.xhp msgctxt "" "04060106.xhp\n" "hd_id71590238179170\n" "help.text" -msgid "RAND.NV" +msgid "<variable id=\"rand_nv_1\"><link href=\"text/scalc/01/04060106.xhp#rand_nv_1\">RAND.NV</link></variable>" msgstr "" #. Fc2hv @@ -18394,6 +18349,15 @@ msgctxt "" msgid "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> totals the cells in the area of A1 up to the cell with the address defined by row 1 and column 3. This means that area A1:C1 is totaled." msgstr "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item>은 A1셀부터 ADDRESS함수에 지정된 부분, 즉 1행 3열의 셀까지를 합산합니다. 다시말하면 A1:C1 범위의 셀 값이 합산되는 것입니다." +#. MssCB +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" +"par_id701677016751509\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">INDIRECT wiki page</link>." +msgstr "" + #. T2BJo #: 04060109.xhp msgctxt "" @@ -41965,13 +41929,13 @@ msgctxt "" msgid "Define Names" msgstr "이름 지정" -#. W7BHS +#. fGnfi #: 04070100.xhp msgctxt "" "04070100.xhp\n" "hd_id3156330\n" "help.text" -msgid "<link href=\"text/scalc/01/04070100.xhp\">Define Names</link>" +msgid "<variable id=\"define_names_h1\"><link href=\"text/scalc/01/04070100.xhp\">Define Names</link></variable>" msgstr "" #. cVATk @@ -41992,13 +41956,13 @@ msgctxt "" msgid "Use the mouse to define ranges or type the reference into the <emph>Define Name </emph>dialog fields." msgstr "마우스를 사용하여 범위를 지정하거나 <emph>이름 지정</emph> 대화 상자 필드에 참조를 입력합니다." -#. BbJTs +#. QVRkv #: 04070100.xhp msgctxt "" "04070100.xhp\n" "par_id3155131\n" "help.text" -msgid "The <emph>Sheet Area</emph> box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." +msgid "The <menuitem>Name Box</menuitem> on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." msgstr "" #. wTVgT @@ -42433,13 +42397,13 @@ msgctxt "" msgid "<bookmark_value>sheets; defining label ranges</bookmark_value><bookmark_value>label ranges in sheets</bookmark_value>" msgstr "<bookmark_value>시트; 레이블 범위 지정</bookmark_value><bookmark_value>시트의 레이블 범위</bookmark_value>" -#. poDQF +#. WgBoC #: 04070400.xhp msgctxt "" "04070400.xhp\n" "hd_id3150791\n" "help.text" -msgid "<link href=\"text/scalc/01/04070400.xhp\">Define Label Range</link>" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/04070400.xhp\">Define Label Range</link></variable>" msgstr "" #. sTpBB @@ -53368,13 +53332,13 @@ msgctxt "" msgid "Edit Sparkline Group" msgstr "" -#. jbHXJ +#. F3xGC #: FormatSparklineMenu.xhp msgctxt "" "FormatSparklineMenu.xhp\n" "par_id801701562077297\n" "help.text" -msgid "Edits the properties of the sparkline group. The properties applies to all sparklines in the group." +msgid "Edits the properties of the sparkline group. The properties apply to all sparklines in the group." msgstr "" #. 2crMd @@ -54628,6 +54592,15 @@ msgctxt "" msgid "This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the <link href=\"text/scalc/01/03080000.xhp\">value highlighting</link> feature." msgstr "" +#. DB6XT +#: common_func.xhp +msgctxt "" +"common_func.xhp\n" +"par_id431716730587722\n" +"help.text" +msgid "Any of the optional arguments can be omitted. An optional argument is required to be preceded by the preceding separators." +msgstr "" + #. GAPGX #: common_func_workdaysintl.xhp msgctxt "" @@ -56212,24 +56185,6 @@ msgctxt "" msgid "Product Name" msgstr "" -#. HZpK7 -#: ex_data_stat_func.xhp -msgctxt "" -"ex_data_stat_func.xhp\n" -"par_id2509201517433075\n" -"help.text" -msgid "Sales" -msgstr "" - -#. NEEL8 -#: ex_data_stat_func.xhp -msgctxt "" -"ex_data_stat_func.xhp\n" -"par_id2509201519383294\n" -"help.text" -msgid "Revenue" -msgstr "" - #. ZyGBE #: ex_data_stat_func.xhp msgctxt "" @@ -56266,29 +56221,29 @@ msgctxt "" msgid "book" msgstr "" -#. 48CjE +#. NTJ7A #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id19479417931163\n" +"par_id491711556981497\n" "help.text" msgid "pencil-case" msgstr "" -#. w8ZSP +#. jwABa #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id85353130721737\n" +"par_id981711556984697\n" "help.text" msgid "not" msgstr "" -#. EYktc +#. cAKeZ #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" -"par_id15693941827291\n" +"par_id581711556987385\n" "help.text" msgid "not" msgstr "" @@ -56365,49 +56320,49 @@ msgctxt "" msgid "A matching expression can be:" msgstr "" -#. fSoyL +#. jQtQq #: 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." +msgid "A number or logical value. A matching cell content equals the number or logical value." msgstr "" -#. 7Hfq9 +#. eEHxH #: ex_data_stat_func.xhp msgctxt "" "ex_data_stat_func.xhp\n" "par_id511619279076504\n" "help.text" -msgid "A value beginning with a comparator (<, <=, =, >, >=, <>)." +msgid "A value beginning with a comparator (<emph><</emph>, <emph><=</emph>, <emph>=</emph>, <emph>></emph>, <emph>>=</emph>, <emph><></emph>)." msgstr "" -#. YEjSD +#. fFaED #: 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." +msgid "For <emph>=</emph>, if the value is empty it matches empty cells." msgstr "" -#. 39AJR +#. HsEcn #: 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." +msgid "For <emph><></emph>, if the value is empty it matches non-empty cells." msgstr "" -#. 9xDer +#. ACRXm #: 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." +msgid "For <emph><></emph>, if the value is not empty it matches any cell content except the value, including empty cells." msgstr "" #. y2EGU @@ -56419,22 +56374,22 @@ msgctxt "" msgid "<emph>Note:</emph> \"=0\" does not match empty cells." msgstr "" -#. QHQaK +#. 2hiEG #: 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\">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." +msgid "For <emph>=</emph> and <emph><></emph>, 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\">Search criteria <emph>=</emph> and <emph><></emph> 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 <emph>=</emph> and <emph><></emph>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies." msgstr "" -#. LX8Cp +#. iGQae #: 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\">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\">if enabled in calculation options</link>)." +msgid "Other Text value. If the property <link href=\"text/shared/optionen/01060500.xhp\">Search criteria <emph>=</emph> and <emph><></emph> 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\">if enabled in calculation options</link>)." msgstr "" #. sACAB @@ -57211,6 +57166,15 @@ msgctxt "" msgid "This function is always recalculated whenever a recalculation occurs." msgstr "" +#. fSXNw +#: ful_func.xhp +msgctxt "" +"ful_func.xhp\n" +"par_id711715953325962\n" +"help.text" +msgid "The function is always <emph>case insensitive</emph>, independent from the setting of <emph>Case sensitive</emph> checkbox in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\"><menuitem>%PRODUCTNAME Calc - Calculate</menuitem></link>." +msgstr "" + #. 8DbP2 #: func_aggregate.xhp msgctxt "" @@ -61666,6 +61630,15 @@ msgctxt "" msgid "<emph>Number</emph> is the internal date number." msgstr "" +#. ABP9p +#: func_day.xhp +msgctxt "" +"func_day.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "DAY() returns the integer part of the day." +msgstr "" + #. rUQip #: func_day.xhp msgctxt "" @@ -62467,22 +62440,22 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_filter.xhp\">FILTER</link></variable>" msgstr "" -#. nKHpG +#. dxbQ9 #: func_filter.xhp msgctxt "" "func_filter.xhp\n" "par_id771708806478128\n" "help.text" -msgid "Filters a data range or array based on conditions you specify." +msgid "Filters a data range or array based on specified conditions." msgstr "" -#. M2JTs +#. tuppo #: func_filter.xhp msgctxt "" "func_filter.xhp\n" "par_id211708281649651\n" "help.text" -msgid "FILTER(Range, Criteria, Return if empty)" +msgid "FILTER( Range; Criteria [; Return if empty])" msgstr "" #. SGrA5 @@ -62503,31 +62476,31 @@ msgctxt "" msgid "<emph>Criteria</emph>: A boolean array whose height (filtering by columns) or width (filtering by rows) is the same as the array, used to select data from the <emph>Range</emph>." msgstr "" -#. KjAXK +#. ZcP2E #: func_filter.xhp msgctxt "" "func_filter.xhp\n" "par_id421709395146863\n" "help.text" -msgid "<emph>Return if empty</emph>: the value to return if all values in the Include array are empty (filter return nothing)." +msgid "<emph>Result if empty</emph>: (optional) the value to return if all values in the <emph>Criteria</emph> array are empty (filter return nothing)." msgstr "" -#. PAajv +#. AFtpH #: func_filter.xhp msgctxt "" "func_filter.xhp\n" "par_id21709506838932\n" "help.text" -msgid "<input>{=FILTER(A2:C13,A2:A13>50)}</input> returns the array {57,49,12|56,33,60|57,,} containing all grades with Maths grade above 50. Note that this is an array formula." +msgid "<input>{=FILTER(A2:C13;A2:A13>50)}</input> returns the array containing all grades with Maths grade above 50. Note that this is an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." msgstr "" -#. WhdTC +#. METQ9 #: func_filter.xhp msgctxt "" "func_filter.xhp\n" "par_id561709507935610\n" "help.text" -msgid "<input>{=FILTER(A2:C13,B2:B13>90,\"No results\")}</input> Returns the string \"No results\", since no grade on Physics is above 90." +msgid "<input>{=FILTER(A2:C13;B2:B13>90;\"No results\")}</input> Returns the string \"No results\", since no grade on Physics is above 90." msgstr "" #. q34Yg @@ -64006,6 +63979,15 @@ msgctxt "" msgid "<emph>Number</emph>, as a time value, is a decimal, for which the hour is to be returned." msgstr "<emph>숫자</emph>는 소수로 표현되는 시간값이며 이 소수에 대한 시간이 산출됩니다." +#. nYJCX +#: func_hour.xhp +msgctxt "" +"func_hour.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "HOUR() returns the integer part of the hour." +msgstr "" + #. dhLTM #: func_hour.xhp msgctxt "" @@ -65284,6 +65266,132 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">JIS wiki page</link>." msgstr "" +#. ANivD +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"tit\n" +"help.text" +msgid "LET function" +msgstr "" + +#. mp4Fy +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>LET function</bookmark_value>" +msgstr "" + +#. cUrJc +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"hd_id721717677746932\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" +msgstr "" + +#. NFFDr +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id71717677746935\n" +"help.text" +msgid "Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function." +msgstr "" + +#. A9iKa +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])" +msgstr "" + +#. voGvK +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id301717681619674\n" +"help.text" +msgid "<emph>Name1</emph>: the first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax." +msgstr "" + +#. CDP5D +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id721717688901981\n" +"help.text" +msgid "Name1 must follow the <link href=\"text/scalc/guide/value_with_name.xhp\">naming rules of %PRODUCTNAME Calc</link>." +msgstr "" + +#. pXGwN +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id951717681624139\n" +"help.text" +msgid "<emph>Name_value1</emph>: the value or calculation to assign to Name1." +msgstr "" + +#. RpF5L +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id421717686226452\n" +"help.text" +msgid "<emph>Name2; Name_value2;...</emph>: (optional) same as Name1 and Name_value1, respectively. Name_value2 must follow Name2 and so on." +msgstr "" + +#. ii4Cd +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id231717686233659\n" +"help.text" +msgid "<emph>Calculation</emph>: a formula expression that uses all names within the LET function." +msgstr "" + +#. AaFRL +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id91717686350018\n" +"help.text" +msgid "<emph>Calculation</emph> must be the last argument in the LET function." +msgstr "" + +#. vGdpF +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id121717701196975\n" +"help.text" +msgid "Calculate the molar mass of the water molecule knowing that the molecule has 2 hydrogen atoms and one oxygen atom." +msgstr "" + +#. s46BC +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id311717701158800\n" +"help.text" +msgid "<input>=LET(mHydro; HLOOKUP(\"Hydrogen\"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP(\"Oxygen\"; $A$1:$DO$4; 4; 0); \"The molar mass of water is \"&(mOxy+2*mHydro)&\" g/mol\")</input> returns \"The molar mass of water is 18.015 g/mol\"." +msgstr "" + +#. TGwea +#: func_let.xhp +msgctxt "" +"func_let.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wiki page</link>." +msgstr "" + #. Cauxq #: func_maxifs.xhp msgctxt "" @@ -65716,6 +65824,15 @@ msgctxt "" msgid "<emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned." msgstr "<emph>숫자</emph>는 소수로 표현되는 시간값이며 이 소수에 대한 분이 산출됩니다." +#. Dk2qr +#: func_minute.xhp +msgctxt "" +"func_minute.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "MINUTE() returns the integer part of the minute." +msgstr "" + #. L77op #: func_minute.xhp msgctxt "" @@ -65806,6 +65923,15 @@ msgctxt "" msgid "<emph>Number</emph> is the internal date number." msgstr "" +#. ppa8y +#: func_month.xhp +msgctxt "" +"func_month.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "MONTH() returns the integer part of the month." +msgstr "" + #. LuUhY #: func_month.xhp msgctxt "" @@ -66958,22 +67084,94 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_randarray.xhp\">RANDARRAY</link></variable>" msgstr "" -#. 3voMF +#. ERqtG #: func_randarray.xhp msgctxt "" "func_randarray.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Generates an array of random numbers between two limit values." msgstr "" -#. n2JxT +#. ArGrF #: func_randarray.xhp msgctxt "" "func_randarray.xhp\n" "par_id211708281649651\n" "help.text" -msgid "RANDARRAY(...)" +msgid "RANDARRAY([Rows [; Columns [; Min [; Max [; Integers] ] ] ])" +msgstr "" + +#. FDbmd +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id101715616072623\n" +"help.text" +msgid "<emph>Rows</emph>: (optional) the number of rows to return. If omitted, the value is 1." +msgstr "" + +#. 6N84A +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id271715616076797\n" +"help.text" +msgid "<emph>Columns</emph>: (optional) the number of columns to return. If omitted, the value is 1." +msgstr "" + +#. 2KCG4 +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id171715616081037\n" +"help.text" +msgid "<emph>Min</emph>: (optional) The lower limit of the generated numbers. If omitted, the minimum value is 0." +msgstr "" + +#. qGeUx +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id361715616086109\n" +"help.text" +msgid "<emph>Max</emph>: (optional) The upper limit of the generated numbers. If omitted, the maximum value is 1." +msgstr "" + +#. BcDGD +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id511715616090373\n" +"help.text" +msgid "<emph>Integers</emph>: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE." +msgstr "" + +#. gCAv3 +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id821708357634624\n" +"help.text" +msgid "If <emph>Rows</emph> and <emph>Columns</emph> are greater than 1, the RANDARRAY function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." +msgstr "" + +#. QgdBu +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id141715790327107\n" +"help.text" +msgid "If <emph>Rows</emph> or <emph>Columns</emph> are references to the content of other cells, the array dimensions do not change when the referenced content changes. The array formula must be deleted and re-entered." +msgstr "" + +#. mz6p3 +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id521715616457946\n" +"help.text" +msgid "<input>{=RANDARRAY(10;4;10;50;1)}</input> returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers)." msgstr "" #. iGDsD @@ -67894,6 +68092,15 @@ msgctxt "" msgid "<emph>Number</emph>, as a time value, is a decimal, for which the second is to be returned." msgstr "<emph>숫자</emph>는 소수로 표현되는 시간값이며 이 소수에 대한 초가 산출됩니다." +#. e2ZnC +#: func_second.xhp +msgctxt "" +"func_second.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "SECOND() rounds to the nearest second, instead of returning the integer part of the seconds." +msgstr "" + #. fwYTM #: func_second.xhp msgctxt "" @@ -67948,22 +68155,94 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sequence.xhp\">SEQUENCE</link></variable>" msgstr "" -#. BoGGv +#. 6fNDF #: func_sequence.xhp msgctxt "" "func_sequence.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Generate a list of sequential numbers in an array." msgstr "" -#. 2wcAc +#. Kk5tL #: func_sequence.xhp msgctxt "" "func_sequence.xhp\n" "par_id211708281649651\n" "help.text" -msgid "SEQUENCE(...)" +msgid "SEQUENCE(Rows, Columns, [Start], [Step])" +msgstr "" + +#. CDwFb +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id601714592655068\n" +"help.text" +msgid "<emph>Rows</emph>: a positive integer. The number of rows to return." +msgstr "" + +#. G48qz +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id521714592660164\n" +"help.text" +msgid "<emph>Columns</emph>: a positive integer. The number of columns to return." +msgstr "" + +#. KNGFY +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id171714592664667\n" +"help.text" +msgid "<emph>Start</emph>: optional. The initial value of the sequence. If omitted, default is 1." +msgstr "" + +#. CZGrA +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id531714592669635\n" +"help.text" +msgid "<emph>Step</emph>: optional. The increment of each subsequent value in the array. If omitted, default is 1." +msgstr "" + +#. J4cjA +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id821708357634624\n" +"help.text" +msgid "If <emph>Rows</emph> and <emph>Columns</emph> are greater than 1, the SEQUENCE function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." +msgstr "" + +#. EmG5r +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id141715790327107\n" +"help.text" +msgid "If <emph>Rows</emph> or <emph>Columns</emph> are references to the content of other cells, the array dimensions do not change when the referenced content changes. The array formula must be deleted and re-entered." +msgstr "" + +#. k3KZZ +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id61714595841660\n" +"help.text" +msgid "The array is filled from the first row to the right up to the value of <emph>Columns</emph>, and then down to the number of rows." +msgstr "" + +#. u9vnG +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id201714595986945\n" +"help.text" +msgid "<input>{=SEQUENCE(3,3,10,11)}</input> returns the 3-by-3 array below with an upper-left value of 10 and filling the array to the right and then downward in steps of 11." msgstr "" #. sNE2S @@ -68092,22 +68371,211 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>" msgstr "" -#. 4Ky6H +#. JkEQn #: func_sort.xhp msgctxt "" "func_sort.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Sorts the contents of a range or array." +msgstr "" + +#. JFZRF +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711543270539\n" +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." msgstr "" -#. NFc8B +#. DmRKh #: func_sort.xhp msgctxt "" "func_sort.xhp\n" "par_id211708281649651\n" "help.text" -msgid "SORT(...)" +msgid "SORT(Range [; SortIndex [; SortOrder [; ByCol] ] ])" +msgstr "" + +#. gmV6H +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id551711457515235\n" +"help.text" +msgid "<emph>Range:</emph> the range or array to sort." +msgstr "" + +#. WQaKY +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id151711457520290\n" +"help.text" +msgid "<emph>SortIndex:</emph> (optional). The number indicating the row or column to sort by." +msgstr "" + +#. P5DGG +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711457525811\n" +"help.text" +msgid "<emph>SortOrder:</emph> (optional). A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order." +msgstr "" + +#. 5Vo8L +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id351711457531579\n" +"help.text" +msgid "<emph>ByCol:</emph> (optional). A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column." +msgstr "" + +#. hDBib +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"hd_id751711480783220\n" +"help.text" +msgid "Example with ascending order" +msgstr "" + +#. RmqyT +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id131711466000482\n" +"help.text" +msgid "<input>{=SORT(A2:C6,2,1)}</input>" +msgstr "" + +#. MBgRu +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id471711472262161\n" +"help.text" +msgid "Sort the range A2:C6 based on the second column in ascending order (Sales)." +msgstr "" + +#. EQiyc +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id31711465709083\n" +"help.text" +msgid "book" +msgstr "" + +#. AA3th +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id861711465758906\n" +"help.text" +msgid "pencil" +msgstr "" + +#. zjCpK +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id331711465788257\n" +"help.text" +msgid "notebook" +msgstr "" + +#. GDXFf +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id821711465827777\n" +"help.text" +msgid "pen" +msgstr "" + +#. ofndu +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id11711465871342\n" +"help.text" +msgid "pencil-case" +msgstr "" + +#. pvfNi +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"hd_id51711480751179\n" +"help.text" +msgid "Example with descending order" +msgstr "" + +#. x5oDE +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id731711466320553\n" +"help.text" +msgid "<input>{=SORT(A2:C6,3,-1)}</input>" +msgstr "" + +#. FSrYH +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id401711479167509\n" +"help.text" +msgid "Sort the range A2:C6 based on the third column in descending order (Revenue)." +msgstr "" + +#. 5KSd6 +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id821711478931934\n" +"help.text" +msgid "pencil-case" +msgstr "" + +#. hHqSc +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id721711478941598\n" +"help.text" +msgid "notebook" +msgstr "" + +#. Eh74E +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id281711478950341\n" +"help.text" +msgid "book" +msgstr "" + +#. KGKEY +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id101711478960309\n" +"help.text" +msgid "pen" +msgstr "" + +#. fjhFK +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id911711478969701\n" +"help.text" +msgid "pencil" msgstr "" #. JDbrP @@ -68146,22 +68614,67 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>" msgstr "" -#. EFPmE +#. jCSNU #: func_sortby.xhp msgctxt "" "func_sortby.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Sorts the contents of a range or array based on the values in a corresponding range or array." msgstr "" -#. 6QrpC +#. 52ZFJ #: func_sortby.xhp msgctxt "" "func_sortby.xhp\n" "par_id211708281649651\n" "help.text" -msgid "SORTBY(...)" +msgid "SORTBY(Range; SortByRange1; SortOrder1 [; SortByRange2; SortOrder2,[...] ])" +msgstr "" + +#. gifyS +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id451711544450734\n" +"help.text" +msgid "<emph>Range</emph>: The array or range to sort." +msgstr "" + +#. i3EwL +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id291711544460323\n" +"help.text" +msgid "<emph>SortByRange1, SortByRange2,... </emph>: range 1, range 2,... are the arrays or ranges to sort on." +msgstr "" + +#. BA6NF +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id501711544465886\n" +"help.text" +msgid "<emph>SortOrder1, SortOrder2,...</emph> : order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending." +msgstr "" + +#. jhZ65 +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id131711466000482\n" +"help.text" +msgid "<input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input>" +msgstr "" + +#. q9cpQ +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id471711472262161\n" +"help.text" +msgid "Sort the range A2:C7 based on the first column in ascending order and third column in descending order." msgstr "" #. fKeqF @@ -68461,6 +68974,240 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." msgstr "" +#. yiPhX +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"tit\n" +"help.text" +msgid "SUMIF Function" +msgstr "" + +#. c4KFv +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"bm_id3151957\n" +"help.text" +msgid "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" +msgstr "" + +#. aJCj8 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id3151957\n" +"help.text" +msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/func_sumif.xhp\">SUMIF</link></variable>" +msgstr "" + +#. AWAK5 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3151986\n" +"help.text" +msgid "<ahelp hid=\".\">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp>" +msgstr "" + +#. DFaC8 +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id411711032873068\n" +"help.text" +msgid "SUMIF can only apply a single criterion to a range. Use <link href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\">SUMIFS</link> if you need to apply multiple criteria." +msgstr "" + +#. F7YsR +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152028\n" +"help.text" +msgid "<input>SUMIF(Range; Criterion [;SumRange])</input>" +msgstr "" + +#. D2NiD +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152043\n" +"help.text" +msgid "<emph>Range: </emph> The range of cells to which the criterion is applied." +msgstr "" + +#. ToLFA +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id521711134077228\n" +"help.text" +msgid "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." +msgstr "" + +#. BMGEn +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id3152083\n" +"help.text" +msgid "<emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed." +msgstr "" + +#. oviCS +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id451710857799382\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#. FsERF +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id171711049202378\n" +"help.text" +msgid "<input>=SUMIF(C2:C6,\">=100\")</input>" +msgstr "" + +#. 6mqDE +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id381711049216331\n" +"help.text" +msgid "Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given." +msgstr "" + +#. AEAwA +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id6670125\n" +"help.text" +msgid "<input>=SUMIF(B2:B5,\">=20\",C2:C6)</input>" +msgstr "" + +#. nUdXV +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id341710857230552\n" +"help.text" +msgid "Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion." +msgstr "" + +#. Zjs4B +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id291710867590698\n" +"help.text" +msgid "Using regular expressions" +msgstr "" + +#. 2XByE +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id911710859836541\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,\"pen\",C2:C5)</input>" +msgstr "" + +#. 3ggQs +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id31710859838046\n" +"help.text" +msgid "Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters \"pen\". Returns 85 because rows A2 and A4:A6 do not meet the criterion." +msgstr "" + +#. L9Ftz +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id781710871590769\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,\"pen*\",C2:C6)</input>" +msgstr "" + +#. netyd +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id431710871624405\n" +"help.text" +msgid "Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters \"pen\". Returns the value 150 because rows A4:A5 do not meet the criterion." +msgstr "" + +#. PdFbx +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id311711128230771\n" +"help.text" +msgid "<input>=SUMIF(ProductName,\"pen*\",Revenue)</input>" +msgstr "" + +#. ZeyUD +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id741711128545751\n" +"help.text" +msgid "A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named \"ProductName\", \"Sales\", and \"Revenue\", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href=\"text/scalc/01/04070100.xhp#definenames)\">Define Names</link> dialog." +msgstr "" + +#. amnCv +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"hd_id531711029933195\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#. BVQrr +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id561711031254255\n" +"help.text" +msgid "If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIF function. For example:" +msgstr "" + +#. pAzfZ +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id331711030450765\n" +"help.text" +msgid "<input>=SUMIF(A2:A6,E2,C2:C6)</input>" +msgstr "" + +#. sFiDn +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id11711031541218\n" +"help.text" +msgid "If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents." +msgstr "" + +#. gyimf +#: func_sumif.xhp +msgctxt "" +"func_sumif.xhp\n" +"par_id771677014538669\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF\">SUMIF wiki page</link>." +msgstr "" + #. DfceH #: func_sumifs.xhp msgctxt "" @@ -69352,22 +70099,139 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_unique.xhp\">UNIQUE</link></variable>" msgstr "" -#. aSANQ +#. AwD6d #: func_unique.xhp msgctxt "" "func_unique.xhp\n" "par_id771708806478128\n" "help.text" -msgid "(...)" +msgid "Returns the array of unique values from a range or array of values." msgstr "" -#. 24EqX +#. A8bJf #: func_unique.xhp msgctxt "" "func_unique.xhp\n" "par_id211708281649651\n" "help.text" -msgid "UNIQUE(...)" +msgid "UNIQUE(Array, [By col], [Uniqueness])" +msgstr "" + +#. DUA7p +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id381715698113514\n" +"help.text" +msgid "<emph>Array</emph>: the range or array from which to return unique values." +msgstr "" + +#. ZDyWq +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id311715698119400\n" +"help.text" +msgid "<emph>By col</emph>: (optional) a logical value that indicates how to compare data: TRUE - compares data horizontally for a match of all cells in each column, across all columns. FALSE or omitted (default) - compares data vertically, for a match of all cells of each row, across all rows." +msgstr "" + +#. DSDnH +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id531715698124705\n" +"help.text" +msgid "<emph>Uniqueness</emph>: (optional) A logical value that defines which values are considered unique. TRUE returns values that occur only once. The default is FALSE or omitted, which returns all distinct values in the range or array." +msgstr "" + +#. fknB6 +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id501715889339407\n" +"help.text" +msgid "The UNIQUE function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." +msgstr "" + +#. RUvGf +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id471715980557106\n" +"help.text" +msgid "Given the data table below, the examples returns unique occurrences of grades and age." +msgstr "" + +#. Kgeri +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"hd_id931715984553129\n" +"help.text" +msgid "Example 1" +msgstr "" + +#. nbDpQ +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id641715980827372\n" +"help.text" +msgid "<input>{=UNIQUE(B1:C10,FALSE(),FALSE())}</input> returns the array below. The grades and ages of the rows with name Andy and Harry are returned only once. The same for rows with name Eva and Irene." +msgstr "" + +#. 9XEhA +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id641715983343641\n" +"help.text" +msgid "<emph>Grade</emph>" +msgstr "" + +#. LFWFS +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id511715983350731\n" +"help.text" +msgid "<emph>Age</emph>" +msgstr "" + +#. i74Ub +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"hd_id981715984567844\n" +"help.text" +msgid "Example 2" +msgstr "" + +#. FuxKt +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id801715981230387\n" +"help.text" +msgid "<input>{=UNIQUE(B1:C10,FALSE(),TRUE())}</input>, with <emph>Uniqueness</emph> as TRUE. Returns the array below with the rows of Andy, Harry, Eva and Irene omitted because their combined grades and ages are not unique." +msgstr "" + +#. dScyG +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id501715983764524\n" +"help.text" +msgid "<emph>Grade</emph>" +msgstr "" + +#. GAopa +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id31715983773608\n" +"help.text" +msgid "<emph>Age</emph>" msgstr "" #. oV47W @@ -70063,6 +70927,15 @@ msgctxt "" msgid "System" msgstr "" +#. cM6zS +#: func_weeknum.xhp +msgctxt "" +"func_weeknum.xhp\n" +"par_id901535122363436\n" +"help.text" +msgid "Description" +msgstr "" + #. V79BD #: func_weeknum.xhp msgctxt "" @@ -70864,40 +71737,40 @@ msgctxt "" msgid "Searches for a value in an array and returns a reference to a cell or range of cells." msgstr "" -#. xMTVW +#. bywFk #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id631708282151776\n" "help.text" -msgid "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets." +msgid "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets." msgstr "" -#. VESoP +#. TwFcc #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id211708281649651\n" "help.text" -msgid "XLOOKUP(Lookup; Array; Return [; NotFound; MatchType; SearchMode ] )" +msgid "XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )" msgstr "" -#. 3zUXb +#. WoJu6 #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id861708281340704\n" "help.text" -msgid "<emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>." +msgid "<emph>Lookup</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>." msgstr "" -#. qUjAU +#. hBE9s #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id831708281625340\n" "help.text" -msgid "<emph>Array</emph>: is the reference of the array or range to search." +msgid "<emph>Array</emph>: is the reference of the array to search. Array must be a 1-dimensional array and must be contained in one sheet only." msgstr "" #. nWhEP @@ -70909,175 +71782,148 @@ msgctxt "" msgid "<emph>Return</emph>: is the reference of the array or range to return." msgstr "" -#. 2LnvD +#. G4DLq #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id821708357634624\n" "help.text" -msgid "If <emph>Return</emph> is an array of values, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." +msgid "If <emph>Return</emph> is a range of cells, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." msgstr "" -#. 3fY6K +#. WTFGZ #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id271708281637035\n" "help.text" -msgid "<emph>NotFound</emph>: a text to return if the <emph>Lookup</emph> value is not found. If a valid match is not found, and <emph>NotFound</emph> is omitted, returns #N/A." +msgid "<emph>NotFound</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>NotFound</emph> is omitted, the function returns the #N/A error." msgstr "" -#. hBDsh +#. ruAWq #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id121708281643207\n" "help.text" -msgid "<emph>MatchType</emph>: Specify the match type:" +msgid "<emph>MatchType</emph>: (optional) specifies the match type. Values can be:" msgstr "" -#. aCZbP +#. go9sN #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id111708281542144\n" "help.text" -msgid "<emph>0</emph> - Exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return #N/A." +msgid "<emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return the #N/A error." msgstr "" -#. w5rBH +#. CtG9A #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id851708281548335\n" "help.text" -msgid "<emph>-1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item." +msgid "<emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item." msgstr "" -#. zQiND +#. CpEkK #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id801708281553430\n" "help.text" -msgid "<emph>1</emph> - Exact match. If <emph>Lookup</emph> value is not found, then return the next larger item." +msgid "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item." msgstr "" -#. 4Jxvx +#. JJ3M2 #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id881708281558005\n" "help.text" -msgid "<emph>2</emph> - A <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meaning." +msgid "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings." msgstr "" -#. CxCof +#. EqTBc #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id871708281607313\n" "help.text" -msgid "<emph>SearchMode</emph>: Specify the search mode to use:" +msgid "<emph>SearchMode</emph>: (optional) specifies the search mode to use." msgstr "" -#. Lc3bp +#. FfKjN #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id281708281579757\n" "help.text" -msgid "<emph>1</emph>: - Search starting at the first item (default)." +msgid "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Array</emph> (default)." msgstr "" -#. HVoEm +#. 8CD3w #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id251708281584285\n" "help.text" -msgid "<emph>-1</emph> - Reverse search starting at the last item." +msgid "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Array</emph>." msgstr "" -#. CFAD4 +#. 6aABE #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id191708281589997\n" "help.text" -msgid "<emph>2</emph> - Binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned." +msgid "<emph>2</emph>: binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned." msgstr "" -#. mAGCX +#. pwwij #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id561708281595885\n" "help.text" -msgid "<emph>-2</emph> - Binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned." +msgid "<emph>-2</emph>: binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned." msgstr "" -#. vD6hn +#. fHQrZ #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" -"par_id961708354814163\n" +"par_id141716739193733\n" "help.text" -msgid "The table below contains a glossary for translators:" +msgid "<input>{=XLOOKUP(\"Atomic Number\";A2:A4;A2:DO4)}</input> returns the array" msgstr "" -#. MSv55 +#. tkRq7 #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" -"par_id781708353695722\n" +"par_id231716739652495\n" "help.text" -msgid "<emph>English</emph>" +msgid "<input>{=XLOOKUP(\"Helium\";B1:DO1;B1:DO4)}</input> returns the array" msgstr "" -#. 5G7WA +#. D5tG5 #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" -"par_id641708353695723\n" +"par_id21716739329244\n" "help.text" -msgid "<emph>French</emph>" -msgstr "" - -#. GRDeG -#: func_xlookup.xhp -msgctxt "" -"func_xlookup.xhp\n" -"par_id671708353695724\n" -"help.text" -msgid "<emph>Italian</emph>" -msgstr "" - -#. JfbWn -#: func_xlookup.xhp -msgctxt "" -"func_xlookup.xhp\n" -"par_id331708353781503\n" -"help.text" -msgid "<emph>Japanese</emph>" -msgstr "" - -#. CmUw2 -#: func_xlookup.xhp -msgctxt "" -"func_xlookup.xhp\n" -"par_id31708356677157\n" -"help.text" -msgid "<input>={XLOOKUP(\"New\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Nouveau\",\"Nuovo\",\"新しい\"}." +msgid "Helium" msgstr "" -#. Z9pX4 +#. vaCSD #: func_xlookup.xhp msgctxt "" "func_xlookup.xhp\n" "par_id671708356683379\n" "help.text" -msgid "<input>={XLOOKUP(\"Reload\", A2:A4, B2:D4,\"Missing\")}</input> returns the array {\"Missing\",\"Missing\",\"Missing\"}." +msgid "<input>{=XLOOKUP(\"Kryptonite\";B1:DO1;B1:DO4;\"Unknown element\")}</input> returns the array {\"Unknown element\",\"Unknown element\",\"Unknown element\",\"Unknown element\"}." msgstr "" #. SzUpN @@ -71116,22 +71962,31 @@ msgctxt "" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xmatch.xhp\">XMATCH</link></variable>" msgstr "" -#. B9dyV +#. 8GYav #: func_xmatch.xhp msgctxt "" "func_xmatch.xhp\n" "par_id581708279355738\n" "help.text" -msgid "Searches for a value in an array or range of cells and returns the relative position of the item." +msgid "Searches for a value in a one-dimensional array and returns the relative position of the item." +msgstr "" + +#. qJsbC +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id321716754048322\n" +"help.text" +msgid "XMATCH outperforms function <link href=\"text/scalc/01/04060109.xhp#Section12\">MATCH</link> as it allows searches according to the search mode." msgstr "" -#. MFVXB +#. NFwz8 #: func_xmatch.xhp msgctxt "" "func_xmatch.xhp\n" "par_id211708281649651\n" "help.text" -msgid "XMATCH(Lookup; Array [; MatchType; SearchMode ] )" +msgid "XMATCH(Lookup; Array [; MatchType [; SearchMode ] ] )" msgstr "" #. NA2BM @@ -71152,22 +72007,22 @@ msgctxt "" msgid "<emph>Array</emph>: is the reference of the array or range to search." msgstr "" -#. EorAV +#. WMXaP #: func_xmatch.xhp msgctxt "" "func_xmatch.xhp\n" -"par_id391708364611193\n" +"par_id471716753503759\n" "help.text" -msgid "XMATCH outperforms function MATCH as it allows searches according to the search mode." +msgid "<input>=XMATCH(\"Atomic Number\",A1:A4)</input> returns 3, the third line of the A1:A4 array." msgstr "" -#. yRpQy +#. QTDzi #: func_xmatch.xhp msgctxt "" "func_xmatch.xhp\n" -"par_id31708356677157\n" +"par_id581716753499133\n" "help.text" -msgid "<input>=XMATCH(\"Save\", A2:A4, 0, 1)</input> returns 2, the second line of the A2:A4 range." +msgid "<input>=XMATCH(\"Li\",A2:DO2)</input> returns 4, the fourth column of the A2:DO2 array." msgstr "" #. 2AAX5 @@ -71233,6 +72088,15 @@ msgctxt "" msgid "<emph>Number</emph> shows the internal date value for which the year is to be returned." msgstr "<emph>숫자</emph>는 년도수를 산출할 내부 날짜값을 지정합니다." +#. 3XHAE +#: func_year.xhp +msgctxt "" +"func_year.xhp\n" +"par_id451715611481885\n" +"help.text" +msgid "YEAR() returns the integer part of the year." +msgstr "" + #. 3RPng #: func_year.xhp msgctxt "" @@ -72907,13 +73771,13 @@ msgctxt "" msgid "<variable id=\"sparklines\"><link href=\"text/scalc/01/sparklines.xhp\">Sparklines</link></variable>" msgstr "" -#. ugfeU +#. g3kgb #: sparklines.xhp msgctxt "" "sparklines.xhp\n" "par_id401698839153661\n" "help.text" -msgid "Opens the <emph>Sparklines Properties</emph> dialog to define sparklines properties." +msgid "Opens the <emph>Sparklines Properties</emph> dialog to define sparkline settings." msgstr "" #. wUPfH |