diff options
Diffstat (limited to 'source/vi/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/vi/helpcontent2/source/text/scalc/01.po | 717 |
1 files changed, 678 insertions, 39 deletions
diff --git a/source/vi/helpcontent2/source/text/scalc/01.po b/source/vi/helpcontent2/source/text/scalc/01.po index 595077e732c..36a4a3b711a 100644 --- a/source/vi/helpcontent2/source/text/scalc/01.po +++ b/source/vi/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-02-02 00:04+0100\n" +"POT-Creation-Date: 2024-02-28 17:20+0100\n" "PO-Revision-Date: 2020-12-31 12:36+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: Vietnamese <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/vi/>\n" @@ -529,42 +529,6 @@ msgctxt "" msgid "<ahelp hid=\"modules/scalc/ui/navigatorpanel/documents\">Displays the names of all open documents.</ahelp> To switch to another open document in the Navigator, click the document name. The status (active, inactive) of the document is shown in brackets after the name. You can switch the active document in the <emph>Window</emph> menu." msgstr "" -#. 9DPjf -#: 02120000.xhp -msgctxt "" -"02120000.xhp\n" -"tit\n" -"help.text" -msgid "Headers & Footers" -msgstr "Phần đầu và phần chân" - -#. Vm7Du -#: 02120000.xhp -msgctxt "" -"02120000.xhp\n" -"hd_id3145251\n" -"help.text" -msgid "<link href=\"text/scalc/01/02120000.xhp\">Headers & Footers</link>" -msgstr "<link href=\"text/scalc/01/02120100.xhp\">Phần đầu/chân</link>" - -#. b7G8C -#: 02120000.xhp -msgctxt "" -"02120000.xhp\n" -"par_id3151073\n" -"help.text" -msgid "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".\">Allows you to define and format headers and footers.</ahelp> </variable>" -msgstr "<variable id=\"kopfundfusszeilentext\"><ahelp hid=\".uno:EditHeaderAndFooter\">Cho phép bạn đặt và định dạng phần đầu và phần chân của trang.</ahelp></variable>" - -#. yaZ62 -#: 02120000.xhp -msgctxt "" -"02120000.xhp\n" -"par_id3153415\n" -"help.text" -msgid "The <emph>Headers/Footers</emph> dialog contains the tabs for defining headers and footers. There will be separate tabs for the left and right page headers and footers if the <emph>Same content left/right</emph> option was not marked in the <link href=\"text/scalc/01/05070000.xhp\"><emph>Page Style</emph></link> dialog." -msgstr "" - #. CTq6U #: 02120100.xhp msgctxt "" @@ -53332,13 +53296,13 @@ msgctxt "" msgid "Insert the document title in the cell. The document title is set in the document properties in <menuitem>File - Properties - Description</menuitem> tab." msgstr "" -#. JfG9p +#. rMdGX #: FormatSparklineMenu.xhp msgctxt "" "FormatSparklineMenu.xhp\n" "tit\n" "help.text" -msgid "FormatSparklineMenu" +msgid "Format Sparkline Menu" msgstr "" #. CGFJG @@ -62476,6 +62440,60 @@ msgctxt "" msgid "<link href=\"text/scalc/05/02140000.xhp\">Error codes</link>" msgstr "" +#. qdiU7 +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"tit\n" +"help.text" +msgid "FILTER function" +msgstr "" + +#. uj4VA +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>FILTER function</bookmark_value>" +msgstr "" + +#. ymoUm +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_filter.xhp\">FILTER</link></variable>" +msgstr "" + +#. XqJ48 +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. PNSyJ +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "FILTER(...)" +msgstr "" + +#. q34Yg +#: func_filter.xhp +msgctxt "" +"func_filter.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTER\">FILTER wiki page</link>." +msgstr "" + #. sUgSM #: func_findb.xhp msgctxt "" @@ -66868,6 +66886,60 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>" msgstr "" +#. CNANB +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"tit\n" +"help.text" +msgid "RANDARRAY function" +msgstr "" + +#. 2CEfW +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>RANDARRAY function</bookmark_value>" +msgstr "" + +#. 42Cqg +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_randarray.xhp\">RANDARRAY</link></variable>" +msgstr "" + +#. 3voMF +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. n2JxT +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "RANDARRAY(...)" +msgstr "" + +#. iGDsD +#: func_randarray.xhp +msgctxt "" +"func_randarray.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/RANDARRAY\">RANDARRAY wiki page</link>." +msgstr "" + #. zr5G3 #: func_rawsubtract.xhp msgctxt "" @@ -67804,6 +67876,60 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND\">SECOND wiki page</link>." msgstr "" +#. rXRmt +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"tit\n" +"help.text" +msgid "SEQUENCE function" +msgstr "" + +#. Wvq6Q +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>SEQUENCE function</bookmark_value>" +msgstr "" + +#. PpKCo +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sequence.xhp\">SEQUENCE</link></variable>" +msgstr "" + +#. BoGGv +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. 2wcAc +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "SEQUENCE(...)" +msgstr "" + +#. sNE2S +#: func_sequence.xhp +msgctxt "" +"func_sequence.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEQUENCE\">SEQUENCE wiki page</link>." +msgstr "" + #. JBtM4 #: func_skewp.xhp msgctxt "" @@ -67894,6 +68020,114 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060185.xhp#skew\">SKEW</link>" msgstr "" +#. ZzbFz +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"tit\n" +"help.text" +msgid "SORT function" +msgstr "" + +#. Zo6YN +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>SORT function</bookmark_value>" +msgstr "" + +#. Ra8Tv +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sort.xhp\">SORT</link></variable>" +msgstr "" + +#. 4Ky6H +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. NFc8B +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "SORT(...)" +msgstr "" + +#. JDbrP +#: func_sort.xhp +msgctxt "" +"func_sort.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORT\">SORT wiki page</link>." +msgstr "" + +#. wvW3s +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"tit\n" +"help.text" +msgid "SORTBY function" +msgstr "" + +#. u8gwR +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>SORTBY function</bookmark_value>" +msgstr "" + +#. AcwQa +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_sortby.xhp\">SORTBY</link></variable>" +msgstr "" + +#. EFPmE +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. 6QrpC +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "SORTBY(...)" +msgstr "" + +#. fKeqF +#: func_sortby.xhp +msgctxt "" +"func_sortby.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SORTBY\">SORTBY wiki page</link>." +msgstr "" + #. CPDEq #: func_style.xhp msgctxt "" @@ -69046,6 +69280,60 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\">TRUNC wiki page</link>." msgstr "" +#. 8hfFB +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"tit\n" +"help.text" +msgid "UNIQUE function" +msgstr "" + +#. CeV2j +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>UNIQUE function</bookmark_value>" +msgstr "" + +#. RcWgN +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"hd_id901708806478126\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_unique.xhp\">UNIQUE</link></variable>" +msgstr "" + +#. aSANQ +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id771708806478128\n" +"help.text" +msgid "(...)" +msgstr "" + +#. 24EqX +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "UNIQUE(...)" +msgstr "" + +#. oV47W +#: func_unique.xhp +msgctxt "" +"func_unique.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/UNIQUE\">UNIQUE wiki page</link>." +msgstr "" + #. w86Dm #: func_value.xhp msgctxt "" @@ -70495,6 +70783,357 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\">WORKDAY wiki page</link>." msgstr "" +#. SHsJ2 +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"tit\n" +"help.text" +msgid "XLOOKUP Function" +msgstr "" + +#. EFZfF +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>XLOOKUP function</bookmark_value>" +msgstr "" + +#. DDESR +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"hd_id821708279355736\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xlookup.xhp\">XLOOKUP</link></variable>" +msgstr "" + +#. yC7FC +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id581708279355738\n" +"help.text" +msgid "Searches for a value in an array and returns a reference to a cell or range of cells." +msgstr "" + +#. xMTVW +#: 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." +msgstr "" + +#. VESoP +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "XLOOKUP(Lookup; Array; Return [; NotFound; MatchType; SearchMode ] )" +msgstr "" + +#. 3zUXb +#: 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>." +msgstr "" + +#. qUjAU +#: 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." +msgstr "" + +#. nWhEP +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id241708281629922\n" +"help.text" +msgid "<emph>Return</emph>: is the reference of the array or range to return." +msgstr "" + +#. 2LnvD +#: 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>." +msgstr "" + +#. 3fY6K +#: 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." +msgstr "" + +#. hBDsh +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id121708281643207\n" +"help.text" +msgid "<emph>MatchType</emph>: Specify the match type:" +msgstr "" + +#. aCZbP +#: 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." +msgstr "" + +#. w5rBH +#: 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." +msgstr "" + +#. zQiND +#: 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." +msgstr "" + +#. 4Jxvx +#: 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." +msgstr "" + +#. CxCof +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id871708281607313\n" +"help.text" +msgid "<emph>SearchMode</emph>: Specify the search mode to use:" +msgstr "" + +#. Lc3bp +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id281708281579757\n" +"help.text" +msgid "<emph>1</emph>: - Search starting at the first item (default)." +msgstr "" + +#. HVoEm +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id251708281584285\n" +"help.text" +msgid "<emph>-1</emph> - Reverse search starting at the last item." +msgstr "" + +#. CFAD4 +#: 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." +msgstr "" + +#. mAGCX +#: 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." +msgstr "" + +#. vD6hn +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id961708354814163\n" +"help.text" +msgid "The table below contains a glossary for translators:" +msgstr "" + +#. MSv55 +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id781708353695722\n" +"help.text" +msgid "<emph>English</emph>" +msgstr "" + +#. 5G7WA +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id641708353695723\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\",\"新しい\"}." +msgstr "" + +#. Z9pX4 +#: 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\"}." +msgstr "" + +#. SzUpN +#: func_xlookup.xhp +msgctxt "" +"func_xlookup.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XLOOKUP\">XLOOKUP wiki page</link>." +msgstr "" + +#. z6i4f +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"tit\n" +"help.text" +msgid "XMATCH Function" +msgstr "" + +#. Q8WY3 +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"bm_id361708283183878\n" +"help.text" +msgid "<bookmark_value>XMATCH function</bookmark_value>" +msgstr "" + +#. Y5Xci +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"hd_id821708279355736\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_xmatch.xhp\">XMATCH</link></variable>" +msgstr "" + +#. B9dyV +#: 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." +msgstr "" + +#. MFVXB +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id211708281649651\n" +"help.text" +msgid "XMATCH(Lookup; Array [; MatchType; SearchMode ] )" +msgstr "" + +#. NA2BM +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id861708281340704\n" +"help.text" +msgid "<emph>Lookup</emph>: The value of any type to search for in <emph>Array</emph>." +msgstr "" + +#. BuCGn +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id831708281625340\n" +"help.text" +msgid "<emph>Array</emph>: is the reference of the array or range to search." +msgstr "" + +#. EorAV +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id391708364611193\n" +"help.text" +msgid "XMATCH outperforms function MATCH as it allows searches according to the search mode." +msgstr "" + +#. yRpQy +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id31708356677157\n" +"help.text" +msgid "<input>=XMATCH(\"Save\", A2:A4, 0, 1)</input> returns 2, the second line of the A2:A4 range." +msgstr "" + +#. 2AAX5 +#: func_xmatch.xhp +msgctxt "" +"func_xmatch.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XMATCH\">XMATCH wiki page</link>." +msgstr "" + #. dABAX #: func_year.xhp msgctxt "" |