source/ar/helpcontent2/source/text/scalc/01.po | 1651 ++ source/ast/helpcontent2/source/text/scalc/01.po | 1664 ++ source/bg/helpcontent2/source/text/scalc/01.po | 1668 ++ source/bn-IN/helpcontent2/source/text/scalc/01.po | 1653 ++ source/ca-valencia/helpcontent2/source/text/scalc/01.po | 1652 ++ source/ca/helpcontent2/source/text/scalc/01.po | 1704 ++ source/cs/helpcontent2/source/text/scalc/01.po | 1654 ++ source/da/helpcontent2/source/text/scalc/01.po | 1668 ++ source/de/helpcontent2/source/text/scalc/01.po | 1668 ++ source/en-GB/helpcontent2/source/text/scalc/01.po | 1654 ++ source/es/helpcontent2/source/text/scalc/01.po | 1722 ++ source/et/helpcontent2/source/text/scalc/01.po | 1651 ++ source/eu/helpcontent2/source/text/scalc/01.po | 1654 ++ source/fi/helpcontent2/source/text/scalc/01.po | 1651 ++ source/fr/helpcontent2/source/text/scalc/01.po | 1666 ++ source/gl/helpcontent2/source/text/scalc/01.po | 3080 +++- source/gu/helpcontent2/source/text/scalc/01.po | 1653 ++ source/he/helpcontent2/source/text/scalc/01.po | 1653 ++ source/hi/helpcontent2/source/text/scalc/01.po | 1642 ++ source/hr/helpcontent2/source/text/scalc/01.po | 1653 ++ source/hu/helpcontent2/source/text/scalc/01.po | 1652 ++ source/id/helpcontent2/source/text/scalc/01.po | 1651 ++ source/is/helpcontent2/source/text/scalc/01.po | 1653 ++ source/it/helpcontent2/source/text/scalc/01.po | 1665 ++ source/ja/helpcontent2/source/text/scalc/01.po | 1662 ++ source/km/helpcontent2/source/text/scalc/01.po | 1651 ++ source/ko/helpcontent2/source/text/scalc/01.po | 1653 ++ source/lt/helpcontent2/source/text/scalc/01.po | 1652 ++ source/lv/helpcontent2/source/text/scalc/01.po | 1651 ++ source/nb/helpcontent2/source/text/scalc/01.po | 1668 ++ source/nl/helpcontent2/source/text/scalc/01.po | 1668 ++ source/nn/helpcontent2/source/text/scalc/01.po | 1668 ++ source/pl/helpcontent2/source/text/scalc/01.po | 1668 ++ source/pt-BR/helpcontent2/source/text/scalc/01.po | 1666 ++ source/pt/helpcontent2/source/text/scalc/01.po | 1653 ++ source/ro/helpcontent2/source/text/scalc/01.po | 1651 ++ source/ru/helpcontent2/source/text/scalc/01.po | 1666 ++ source/sk/helpcontent2/source/text/scalc/01.po | 1653 ++ source/sl/helpcontent2/source/text/scalc/01.po |10358 +++++++++++++++- source/sv/helpcontent2/source/text/scalc/01.po | 1653 ++ source/ta/helpcontent2/source/text/scalc/01.po | 1651 ++ source/tr/helpcontent2/source/text/scalc/01.po | 1653 ++ source/uk/helpcontent2/source/text/scalc/01.po | 1653 ++ source/vi/helpcontent2/source/text/scalc/01.po | 1653 ++ source/zh-CN/helpcontent2/source/text/scalc/01.po | 1651 ++ source/zh-TW/helpcontent2/source/text/scalc/01.po | 1653 ++ 46 files changed, 85583 insertions(+), 854 deletions(-)
New commits: commit 358acfa5c4df066088f8057dbffdd131ed6ed278 Author: Aron Budea <[email protected]> AuthorDate: Wed Sep 17 21:03:04 2025 +0930 Commit: Andras Timar <[email protected]> CommitDate: Wed Sep 17 14:07:21 2025 +0200 Backport help translations of new Calc functions Change-Id: I9ee6982cfb1c2f7298c293dbd0b8e0ad25e2215d Reviewed-on: https://gerrit.libreoffice.org/c/translations/+/191079 Tested-by: Andras Timar <[email protected]> Reviewed-by: Andras Timar <[email protected]> diff --git a/source/ar/helpcontent2/source/text/scalc/01.po b/source/ar/helpcontent2/source/text/scalc/01.po index c3c8021d467..7e8ef8fc00d 100644 --- a/source/ar/helpcontent2/source/text/scalc/01.po +++ b/source/ar/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION " "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI " -"POT-Creation-Date: 2025-01-07 15:27+0100 " +"POT-Creation-Date: 2025-09-17 16:16+0930 " "PO-Revision-Date: 2025-01-18 00:54+0000 " "Last-Translator: Weblate Translation Memory <[email protected]> " "Language-Team: Arabic <https://translations.documentfoundation.org/projects/libo_help-25-2/textscalc01/ar/> " @@ -56977,6 +56977,242 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHAR\";>CHAR wiki page</link>." msgstr "" +#. KzRKA +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"tit " +"help.text" +msgid "CHOOSECOLS function" +msgstr "" + +#. RmBsq +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSECOLS function</bookmark_value>" +msgstr "" + +#. pgEyS +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_choosecols.xhp\">CHOOSECOLS</link></variable>" +msgstr "" + +#. qxKzH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified columns from an array." +msgstr "" + +#. tDfbe +#: func_choosecols.xhp +#, fuzzy +msgctxt "" +"func_choosecols.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. NoxBH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSECOLS(Array;Column_1;[Column_2;[Column_3;[...]]])</input>" +msgstr "" + +#. cvwYJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the columns to be returned in a new array." +msgstr "" + +#. weToH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Column_1</emph>: The index of the first column to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. gUFeT +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Column_2; Column_3; ...</emph>: (optional) The list of other column indexes to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. uiDSY +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSECOLS(A1:E3;2;4;5)}</input> returns the array below with columns 2,4 and 5 chosen." +msgstr "" + +#. MdDNC +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSECOLS(A1:E3;1;-1)</input> returns the array below with column 1 and column 5 chosen, note that column 5 is chosen from the end of the array." +msgstr "" + +#. 74pDf +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index." +msgstr "" + +#. d8LnJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS\";>CHOOSECOLS wiki page</link>." +msgstr "" + +#. QsPBU +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"tit " +"help.text" +msgid "CHOOSEROWS function" +msgstr "" + +#. csFBa +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSEROWS function</bookmark_value>" +msgstr "" + +#. 2DzoR +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_chooserows.xhp\">CHOOSEROWS</link></variable>" +msgstr "" + +#. 7945V +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified rows from an array." +msgstr "" + +#. T26fr +#: func_chooserows.xhp +#, fuzzy +msgctxt "" +"func_chooserows.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. xmeqv +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSEROWS(Array;Row_1;[Row_2;[Row_3;[...]]])</input>" +msgstr "" + +#. ckm7y +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the rows to be returned in a new array." +msgstr "" + +#. ziFKi +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Row_1</emph>: The index of the first row to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. VVSCT +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Row_2; Row_3; ...</emph>: (optional) The list of other row indexes to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. C9Vng +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSEROWS(A1:E3;2;3)}</input> returns the array below with rows 2 and 3 chosen." +msgstr "" + +#. NeCWK +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSEROWS(A1:E3;1;-1)</input> returns the array below with row 1 and row 3 chosen, note that row 3 is chosen from the end of the array." +msgstr "" + +#. DRtRZ +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index." +msgstr "" + +#. zEcCF +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS\";>CHOOSEROWS wiki page</link>." +msgstr "" + #. jF3yQ #: func_clean.xhp msgctxt "" @@ -60280,6 +60516,115 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DOLLAR\";>DOLLAR wiki page</link>." msgstr "" +#. hrfhC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"tit " +"help.text" +msgid "DROP function" +msgstr "" + +#. vSAGF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>DROP function</bookmark_value>" +msgstr "" + +#. CH7xF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_drop.xhp\">DROP</link></variable>" +msgstr "" + +#. tzzCD +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id771708806478128 " +"help.text" +msgid "Drops a specified number of contiguous rows or columns from the start or end of an array." +msgstr "" + +#. YVkFY +#: func_drop.xhp +#, fuzzy +msgctxt "" +"func_drop.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. ivgUo +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id851737751444186 " +"help.text" +msgid "DROP(Array; Row; [Column])" +msgstr "" + +#. djzuC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range from which to drop rows or columns." +msgstr "" + +#. 8NwZE +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id111738104866763 " +"help.text" +msgid "<emph>Rows</emph>: the number of rows to drop. A negative value drops from the end of the array." +msgstr "" + +#. XTxhf +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id111738104891522 " +"help.text" +msgid "<emph>Columns</emph>: (optional) the number of columns to drop. A negative value drops from the end of the array." +msgstr "" + +#. 6ECKo +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id631738108398030 " +"help.text" +msgid "The formula <input>{=DROP(A1:E3;1;3)}</input> returns the array below dropping first 1 row and first 3 columns." +msgstr "" + +#. XAV2K +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=DROP(A1:E3;-1;-3)}</input> drops the last row and the last 3 columns." +msgstr "" + +#. FhuUC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DROP\";>DROP wiki page</link>." +msgstr "" + #. RpPVW #: func_eastersunday.xhp msgctxt "" @@ -60937,6 +61282,115 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXACT\";>EXACT wiki page</link>." msgstr "" +#. UABhi +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"tit " +"help.text" +msgid "EXPAND function" +msgstr "" + +#. LVpwH +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>EXPAND function</bookmark_value>" +msgstr "" + +#. yBGiA +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_expand.xhp\">EXPAND</link></variable>" +msgstr "" + +#. 5LotC +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id771708806478128 " +"help.text" +msgid "Expand an array by adding rows or columns." +msgstr "" + +#. WJVx6 +#: func_expand.xhp +#, fuzzy +msgctxt "" +"func_expand.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. Yy9q4 +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=EXPAND(Array;Rows;[Columns];[Pad_with])</input>" +msgstr "" + +#. ppWFd +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: the array or range to expand by the number of rows and/or columns." +msgstr "" + +#. dyQRu +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Rows</emph>: the final number of rows the array will expand. Default is total rows." +msgstr "" + +#. Kk5Vz +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Columns</emph>: (optional) The final number of columns the array will expand. Default is total columns." +msgstr "" + +#. xoxMh +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad in new cells. By default, #N/A is used to fill the new cells." +msgstr "" + +#. 3923w +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=EXPAND(A1:E3;4;7;\"@@@\")}</input> expands the array <literal>A1:E3</literal> to 7 columns and 4 rows, padding the extra cells with the string \"@@@\"." +msgstr "" + +#. PhTg7 +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXPAND\";>EXPAND wiki page</link>." +msgstr "" + #. qdiU7 #: func_filter.xhp msgctxt "" @@ -62764,6 +63218,106 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR\";>HOUR wiki page</link>." msgstr "" +#. wJVKF +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"tit " +"help.text" +msgid "HSTACK function" +msgstr "" + +#. ki2vF +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>HSTACK function</bookmark_value>" +msgstr "" + +#. LBtai +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_hstack.xhp\">HSTACK</link></variable>" +msgstr "" + +#. BM4on +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id771708806478128 " +"help.text" +msgid "Appends arrays horizontally to create a larger array." +msgstr "" + +#. EYr9p +#: func_hstack.xhp +#, fuzzy +msgctxt "" +"func_hstack.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. 5hFvD +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=HSTACK(Array;[Array_1;[Array_2;[...]]])</input>" +msgstr "" + +#. eT93L +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The first array to be returned in a new array." +msgstr "" + +#. igZ74 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Array_1; Array_2; ...</emph>: (optional) the arrays to append sequentially after the previous array." +msgstr "" + +#. dNM4K +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id471739049807951 " +"help.text" +msgid "And the second array as:" +msgstr "" + +#. 4ZNv6 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=HSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of array N15:O19 on the right of the data of array A1:E3, and extra cells filled with #N/A error:" +msgstr "" + +#. uCzt3 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/HSTACK\";>HSTACK wiki page</link>." +msgstr "" + #. DiCWs #: func_ifs.xhp msgctxt "" @@ -69703,6 +70257,124 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/T\";>T wiki page</link>." msgstr "" +#. ndEtp +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"tit " +"help.text" +msgid "TAKE function" +msgstr "" + +#. 7FEnC +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TAKE function</bookmark_value>" +msgstr "" + +#. pB7UF +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_take.xhp\">TAKE</link></variable>" +msgstr "" + +#. M8amC +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns a specified number of contiguous rows or columns from the start or end of an array." +msgstr "" + +#. PevRB +#: func_take.xhp +#, fuzzy +msgctxt "" +"func_take.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. PBxpS +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id851737751444186 " +"help.text" +msgid "TAKE(Array; Row; [Column])" +msgstr "" + +#. A2PcT +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range from which to take rows or columns." +msgstr "" + +#. VY85L +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id111738104866763 " +"help.text" +msgid "<emph>Rows</emph>: the number of rows to take. A negative value takes from the end of the array." +msgstr "" + +#. MGCkb +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id111738104891522 " +"help.text" +msgid "<emph>Columns</emph>: (optional) the number of columns to take. A negative value takes from the end of the array." +msgstr "" + +#. CfyGu +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;;1)}</input> returns the array with 3 rows (default) and 3 columns." +msgstr "" + +#. yhCLT +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;2;4)}</input> returns the array below with 2 rows and 4 columns." +msgstr "" + +#. BQjC5 +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id631738108398030 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;-2;-2)}</input> returns the array below taking 2 rows starting from the last row and 2 columns starting from the last column." +msgstr "" + +#. yTovP +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TAKE\";>TAKE wiki page</link>." +msgstr "" + #. 56Dgq #: func_text.xhp msgctxt "" @@ -69811,6 +70483,258 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXT\";>TEXT wiki page</link>." msgstr "" +#. dnR6C +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"tit " +"help.text" +msgid "TEXTAFTER function" +msgstr "" + +#. yXYYE +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTAFTER function</bookmark_value>" +msgstr "" + +#. rogfF +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"hd_id451747059635188 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_textafter.xhp\">TEXTAFTER</link></variable>" +msgstr "" + +#. sj3QA +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id381747059635191 " +"help.text" +msgid "Returns the text that occurs after a given substring or delimiter." +msgstr "" + +#. sFgek +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTAFTER( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])" +msgstr "" + +#. zZodV +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id91747066169381 " +"help.text" +msgid "<emph>Text</emph>: the original text." +msgstr "" + +#. zgsKn +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id221747066174430 " +"help.text" +msgid "<emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied." +msgstr "" + +#. xprDt +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id821747066179393 " +"help.text" +msgid "<emph>Instance Number</emph>: (optional) the instance of the delimiter after which to extract text. The default is 1. A negative number starts searching from the end." +msgstr "" + +#. hhUE8 +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id121747066183422 " +"help.text" +msgid "<emph>Match Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The default is 0." +msgstr "" + +#. CCWDU +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id201747066188182 " +"help.text" +msgid "<emph>Match End</emph>: (optional) set to 1 to treat the end of text as a delimiter. The default is 0." +msgstr "" + +#. 8sFSe +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id701747066192253 " +"help.text" +msgid "<emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is #N/A." +msgstr "" + +#. 69LCo +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id21747067698384 " +"help.text" +msgid "<input>=TEXTAFTER(\"To be or not to be\";\"or\";1;0;0;\"@@@\")</input> returns the string \"not to be\", taking after the delimiter \"or\"." +msgstr "" + +#. EaiEG +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id971747068062071 " +"help.text" +msgid "<input>=TEXTAFTER(\"To be or not to be\";\"question\";1;0;0;\"@@@\")</input> returns the text \"@@@\" because the delimiter \"question\" is not in the source text." +msgstr "" + +#. UfdCm +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTAFTER\";>TEXTAFTER wiki page</link>." +msgstr "" + +#. GFNEX +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"tit " +"help.text" +msgid "TEXTBEFORE function" +msgstr "" + +#. rsKft +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTBEFORE function</bookmark_value>" +msgstr "" + +#. LDGA7 +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"hd_id451747059635188 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_textbefore.xhp\">TEXTBEFORE</link></variable>" +msgstr "" + +#. DWGTL +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id381747059635191 " +"help.text" +msgid "Returns the text that occurs before a given substring or delimiter." +msgstr "" + +#. tdzNR +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTBEFORE( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])" +msgstr "" + +#. BniCf +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id91747066169381 " +"help.text" +msgid "<emph>Text</emph>: the original text." +msgstr "" + +#. HXcqw +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id221747066174430 " +"help.text" +msgid "<emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied." +msgstr "" + +#. uFJHF +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id821747066179393 " +"help.text" +msgid "<emph>Instance Number</emph>: (optional) the instance of the delimiter before which to extract text. The default is 1. A negative number starts searching from the end." +msgstr "" + +#. mziCS +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id121747066183422 " +"help.text" +msgid "<emph>Match Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The default is 0." +msgstr "" + +#. NkfZ6 +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id201747066188182 " +"help.text" +msgid "<emph>Match End</emph>: (optional) set to 1 to treat the end of text as a delimiter. The default is 0." +msgstr "" + +#. MG8yC +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id701747066192253 " +"help.text" +msgid "<emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is #N/A." +msgstr "" + +#. AGARN +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id21747067698384 " +"help.text" +msgid "<input>=TEXTBEFORE(\"To be or not to be\";\"be\";2;0;0;\"@@@\")</input> returns the string \"To be or not to\", taking up to the second instance of the delimiter \"be\"." +msgstr "" + +#. NK7VF +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id971747068062071 " +"help.text" +msgid "<input>=TEXTBEFORE(\"To be or not to be\";\"question\";1;0;0;\"@@@\")</input> returns the text \"@@@\" because the delimiter \"question\" is not in the source text." +msgstr "" + +#. BTHEE +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTBEFORE\";>TEXTBEFORE wiki page</link>." +msgstr "" + #. BCAZr #: func_textjoin.xhp msgctxt "" @@ -69955,6 +70879,132 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENATE</link>" msgstr "" +#. KA3Af +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"tit " +"help.text" +msgid "TEXTSPLIT function" +msgstr "" + +#. BjPEy +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTSPLIT function</bookmark_value>" +msgstr "" + +#. mCixC +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"hd_id551556227727946 " +"help.text" +msgid "<variable id=\"textsplitfunct\"><link href=\"text/scalc/01/func_textsplit.xhp\">TEXTSPLIT</link></variable>" +msgstr "" + +#. esNA8 +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id121556227727948 " +"help.text" +msgid "<variable id=\"textsplitfunction\">Splits text by a given delimiter to an array of multiple cells.</variable>" +msgstr "" + +#. dxTDq +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTSPLIT(Text [; Column Delimiter [; Row Delimiter [; Ignore Empty [; Match Mode [; Pad With ]]]]])" +msgstr "" + +#. J7wSk +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id741746962354423 " +"help.text" +msgid "<emph>Text</emph>: (optional) the text to split." +msgstr "" + +#. Euuxu +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id91746962359992 " +"help.text" +msgid "<emph>Column Delimiter</emph>: (optional) the text to delimit the columns. Multiple delimiters can be supplied." +msgstr "" + +#. Pqzhk +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id361746962365647 " +"help.text" +msgid "<emph>Row Delimiter</emph>: (optional) the text to delimit the rows. Multiple delimiters can be supplied." +msgstr "" + +#. j3omS +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id521746962371799 " +"help.text" +msgid "<emph>Ignore Empty</emph>: (optional) set to TRUE to ignore consecutive delimiters otherwise creates an empty cell. The default to FALSE." +msgstr "" + +#. aFiwx +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id951746962377042 " +"help.text" +msgid "<emph>Match mode</emph>: (optional) set to 1 to perform a case-insensitive match otherwise does a case-sensitive match. The default to 0." +msgstr "" + +#. y4rDQ +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id651746962382871 " +"help.text" +msgid "<emph>Pad with</emph>: (optional) the value with which to pad. The default is #N/A." +msgstr "" + +#. G3ayA +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id521746970153871 " +"help.text" +msgid "If cell A1 contains <literal>\"AA,BB,,CC/DD,EE,FF/GG,HH,II,JJ\"</literal>, then" +msgstr "" + +#. Vnbsd +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id541746969982707 " +"help.text" +msgid "<input>{=TEXTSPLIT(A1;\",\";\"/\";FALSE();1;\"@@@\")}</input> returns the following array:" +msgstr "" + +#. wVaAc +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTSPLIT\";>TEXTSPLIT wiki page</link>." +msgstr "" + #. pLSAn #: func_time.xhp msgctxt "" @@ -70153,6 +71203,160 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIMEVALUE\";>TIMEVALUE wiki page</link>." msgstr "" +#. 5gfLF +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"tit " +"help.text" +msgid "TOCOL function" +msgstr "" + +#. GRyGe +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TOCOL function</bookmark_value>" +msgstr "" + +#. 774mk +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_tocol.xhp\">TOCOL</link></variable>" +msgstr "" + +#. xQCwR +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id771708806478128 " +"help.text" +msgid "Transforms an array or range into a single column." +msgstr "" + +#. v8Q4Q +#: func_tocol.xhp +#, fuzzy +msgctxt "" +"func_tocol.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. AV4Ra +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id851737751444186 " +"help.text" +msgid "TOCOL(Array; [Ignore]; [By_column])" +msgstr "" + +#. DzGBX +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range to return as a single column." +msgstr "" + +#. FCSvz +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id31737751839305 " +"help.text" +msgid "<emph>Ignore</emph>: (optional) Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:" +msgstr "" + +#. GDiV2 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id971737751690332 " +"help.text" +msgid "<emph>0</emph>: Keep all values (default)" +msgstr "" + +#. ySDuV +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id381737751703531 " +"help.text" +msgid "<emph>1</emph>: Ignore blank cells" +msgstr "" + +#. qsJVZ +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id931737751715731 " +"help.text" +msgid "<emph>2</emph>: Ignore cells with errors" +msgstr "" + +#. pEBgh +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id101737751728979 " +"help.text" +msgid "<emph>3</emph>: Ignore both blank cells and error cells" +msgstr "" + +#. U9F33 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id771737751844889 " +"help.text" +msgid "<emph>By_column</emph>: (optional) Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column." +msgstr "" + +#. ffBcv +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TOCOL(A1:E3)}</input> returns the column" +msgstr "" + +#. 4Mfz9 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>=TOCOL(A1:E3;1)</input> returns the column below without the blank cells." +msgstr "" + +#. RfRPP +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id31737760079923 " +"help.text" +msgid "The formula <input>=TOCOL(A1:E3;1;TRUE())</input> returns the column below without the blank cells, scanned by columns." +msgstr "" + +#. fhPCe +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOCOL\";>TOCOL wiki page</link>." +msgstr "" + #. 8LaX7 #: func_today.xhp msgctxt "" @@ -70225,6 +71429,106 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TODAY\";>TODAY wiki page</link>." msgstr "" +#. KyMHj +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"tit " +"help.text" +msgid "TOROW function" +msgstr "" + +#. hADta +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TOROW function</bookmark_value>" +msgstr "" + +#. e4D64 +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_torow.xhp\">TOROW</link></variable>" +msgstr "" + +#. PqV7k +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id771708806478128 " +"help.text" +msgid "Transforms an array or range into a single row." +msgstr "" + +#. SEcDZ +#: func_torow.xhp +#, fuzzy +msgctxt "" +"func_torow.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. shqrj +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id851737751444186 " +"help.text" +msgid "TOROW(Array, [Ignore], [By_column])" +msgstr "" + +#. 7D5aC +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range to return as a single row." +msgstr "" + +#. crgjU +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3)}</input> returns the row" +msgstr "" + +#. szwfc +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3;1)}</input> returns the row below without the blank cells." +msgstr "" + +#. pDw8G +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id31737760079923 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3;1;TRUE())}</input> returns the row below without the blank cells, scanned by columns." +msgstr "" + +#. cYECo +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOROW\";>TOROW wiki page</link>." +msgstr "" + #. F4uSC #: func_trim.xhp msgctxt "" @@ -70936,6 +72240,115 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\";>VALUE wiki page</link>." msgstr "" +#. XkyPd +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"tit " +"help.text" +msgid "VSTACK function" +msgstr "" + +#. MEU7Q +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>VSTACK function</bookmark_value>" +msgstr "" + +#. oQLBE +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_vstack.xhp\">VSTACK</link></variable>" +msgstr "" + +#. BCxHz +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id771708806478128 " +"help.text" +msgid "Appends arrays vertically to create a larger array." +msgstr "" + +#. uvW6D +#: func_vstack.xhp +#, fuzzy +msgctxt "" +"func_vstack.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. TtDZ6 +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=VSTACK(Array;[Array_1;[Array_2;[...]]])</input>" +msgstr "" + +#. w8o8C +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The first array to be returned in a new array." +msgstr "" + +#. h2682 +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Array_1; Array_2; ...</emph>: (optional) the arrays to append sequentially after the previous array." +msgstr "" + +#. mrv9C +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id471739049807951 " +"help.text" +msgid "And the second array as:" +msgstr "" + +#. aTNJM +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=VSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of array N15:O19 below data of array A1:E3, and extra cells filled with #N/A error:" +msgstr "" + +#. W3uMW +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id391739050327791 " +"help.text" +msgid "<variable id=\"NA\">#N/A</variable>" +msgstr "" + +#. Quwcq +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VSTACK\";>VSTACK wiki page</link>." +msgstr "" + #. dQeP6 #: func_webservice.xhp msgctxt "" @@ -72259,6 +73672,206 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\";>WORKDAY wiki page</link>." msgstr "" +#. F5Etj +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"tit " +"help.text" +msgid "WRAPCOLS function" +msgstr "" + +#. 8MDGd +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>WRAPCOLS function</bookmark_value>" +msgstr "" + +#. S6WJW +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_wrapcols.xhp\">WRAPCOLS</link></variable>" +msgstr "" + +#. vFj7J +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id771708806478128 " +"help.text" +msgid "Converts a single row or column into multiple columns (a 2-demensional array) by specifying the number of values in each column." +msgstr "" + +#. CMPQW +#: func_wrapcols.xhp +#, fuzzy +msgctxt "" +"func_wrapcols.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. Hpucy +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id871737825179033 " +"help.text" +msgid "=WRAPCOLS(Range, Wrap_count, [Pad_with])" +msgstr "" + +#. pnet5 +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id701737825446850 " +"help.text" +msgid "<emph>Range</emph>: the range to wrap." +msgstr "" + +#. A5fZc +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id441737825452403 " +"help.text" +msgid "<emph>Wrap_count</emph>: the maximum number of values in each column." +msgstr "" + +#. c2Mue +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad if there are insufficient number of values. By default, it returns #N/A to fill in the cells." +msgstr "" + +#. eAMgY +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id771738021783517 " +"help.text" +msgid "The formula <input>{=WRAPCOLS(A1:A15;6)}</input> returns the array below. The missing values are replaced by #N/A." +msgstr "" + +#. gt3gw +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPCOLS\";>WRAPCOLS wiki page</link>." +msgstr "" + +#. P7aXo +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"tit " +"help.text" +msgid "WRAPROWS function" +msgstr "" + +#. BGSi7 +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>WRAPROWS function</bookmark_value>" +msgstr "" + +#. J7CpA +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_wraprows.xhp\">WRAPROWS</link></variable>" +msgstr "" + +#. KuEGN +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id771708806478128 " +"help.text" +msgid "Converts a single row or column into multiple rows (a 2-demensional array) by specifying the number of values in each row." +msgstr "" + +#. AGoLi +#: func_wraprows.xhp +#, fuzzy +msgctxt "" +"func_wraprows.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "<link href=\"text/scalc/01/02210000.xhp\">تحديد</link>" + +#. u3CeY +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id871737825179033 " +"help.text" +msgid "=WRAPROWS(Range, Wrap_count, [Pad_with])" +msgstr "" + +#. xDnxq +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id701737825446850 " +"help.text" +msgid "<emph>Range</emph>: the range to wrap." +msgstr "" + +#. 36Has +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id441737825452403 " +"help.text" +msgid "<emph>Wrap_count</emph>: the maximum number of values in each column." +msgstr "" + +#. Arfnd +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad if there are insufficient number of values. By default, it returns #N/A to fill in the cells." +msgstr "" + +#. JsK5T +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id771738021783517 " +"help.text" +msgid "The formula <input>{=WRAPROWS(A1:A15;4)}</input> returns the array below. The missing values are replaced by #N/A." +msgstr "" + +#. i7yWC +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPROWS\";>WRAPROWS wiki page</link>." +msgstr "" + #. SHsJ2 #: func_xlookup.xhp msgctxt "" @@ -75211,6 +76824,42 @@ msgctxt "" msgid "<emph>Imaginary</emph>" msgstr "" +#. KAvDE +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id71737757692138 " +"help.text" +msgid "Consider the array <literal>A1:E3</literal> below:" +msgstr "" + +#. ChcT8 +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id71737753692138 " +"help.text" +msgid "Consider the array <literal>A1:A15</literal> below." +msgstr "" + +#. sG2zy +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id791739049060653 " +"help.text" +msgid "N" +msgstr "" + +#. y4i8s +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id671739049060653 " +"help.text" +msgid "O" +msgstr "" + #. rTRpz #: statistics.xhp msgctxt "" diff --git a/source/ast/helpcontent2/source/text/scalc/01.po b/source/ast/helpcontent2/source/text/scalc/01.po index 203fcedc072..aa4d42885a9 100644 --- a/source/ast/helpcontent2/source/text/scalc/01.po +++ b/source/ast/helpcontent2/source/text/scalc/01.po @@ -3,13 +3,13 @@ msgid "" msgstr "" "Project-Id-Version: " "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI " -"POT-Creation-Date: 2025-01-07 15:27+0100 " +"POT-Creation-Date: 2025-09-17 16:16+0930 " "PO-Revision-Date: 2025-07-31 19:53+0000 " "Last-Translator: Adolfo Jayme Barrientos <[email protected]> " "Language-Team: Asturian <https://translations.documentfoundation.org/projects/libo_help-25-2/textscalc01/ast/> " "Language: ast " "MIME-Version: 1.0 " -"Content-Type: text/plain; charset=utf-8 " +"Content-Type: text/plain; charset=UTF-8 " "Content-Transfer-Encoding: 8bit " "Plural-Forms: nplurals=2; plural=n != 1; " "X-Accelerator-Marker: ~ " @@ -44880,7 +44880,7 @@ msgctxt "" "hd_id3154760 " "help.text" msgid "<variable id=\"options_hd\">Options</variable>" -msgstr "" +msgstr "<variable id=\"options_hd\">Opciones</variable>" #. aNYRd #: 12010000.xhp @@ -50496,7 +50496,7 @@ msgctxt "" "hd_id171701544913091 " "help.text" msgid "<variable id=\"h1\"><link href=\"text/scalc/01/FormatSparklineMenu.xhp\">Sparkline</link></variable>" -msgstr "" +msgstr "<variable id=\"h1\"><link href=\"text/scalc/01/FormatSparklineMenu.xhp\">Minigráfica</link></variable>" #. R9bK6 #: FormatSparklineMenu.xhp @@ -50505,7 +50505,7 @@ msgctxt "" "par_id341701544913094 " "help.text" msgid "Opens a menu for sparklines formatting." -msgstr "" +msgstr "Abre un menú pal formatu de les minigráfiques." #. SwZrq #: FormatSparklineMenu.xhp @@ -56978,6 +56978,242 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHAR\";>CHAR wiki page</link>." msgstr "" +#. KzRKA +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"tit " +"help.text" +msgid "CHOOSECOLS function" +msgstr "" + +#. RmBsq +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSECOLS function</bookmark_value>" +msgstr "" + +#. pgEyS +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_choosecols.xhp\">CHOOSECOLS</link></variable>" +msgstr "" + +#. qxKzH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified columns from an array." +msgstr "Devuelve les columnes especificaes a partir d'una matriz." + +#. tDfbe +#: func_choosecols.xhp +#, fuzzy +msgctxt "" +"func_choosecols.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. NoxBH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSECOLS(Array;Column_1;[Column_2;[Column_3;[...]]])</input>" +msgstr "" + +#. cvwYJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the columns to be returned in a new array." +msgstr "" + +#. weToH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Column_1</emph>: The index of the first column to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. gUFeT +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Column_2; Column_3; ...</emph>: (optional) The list of other column indexes to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. uiDSY +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSECOLS(A1:E3;2;4;5)}</input> returns the array below with columns 2,4 and 5 chosen." +msgstr "" + +#. MdDNC +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSECOLS(A1:E3;1;-1)</input> returns the array below with column 1 and column 5 chosen, note that column 5 is chosen from the end of the array." +msgstr "" + +#. 74pDf +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index." +msgstr "" + +#. d8LnJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS\";>CHOOSECOLS wiki page</link>." +msgstr "" + +#. QsPBU +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"tit " +"help.text" +msgid "CHOOSEROWS function" +msgstr "" + +#. csFBa +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSEROWS function</bookmark_value>" +msgstr "" + +#. 2DzoR +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_chooserows.xhp\">CHOOSEROWS</link></variable>" +msgstr "" + +#. 7945V +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified rows from an array." +msgstr "" + +#. T26fr +#: func_chooserows.xhp +#, fuzzy +msgctxt "" +"func_chooserows.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. xmeqv +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSEROWS(Array;Row_1;[Row_2;[Row_3;[...]]])</input>" +msgstr "" + +#. ckm7y +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the rows to be returned in a new array." +msgstr "" + +#. ziFKi +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Row_1</emph>: The index of the first row to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. VVSCT +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Row_2; Row_3; ...</emph>: (optional) The list of other row indexes to be returned. A negative value chooses from the end of the array." +msgstr "" + +#. C9Vng +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSEROWS(A1:E3;2;3)}</input> returns the array below with rows 2 and 3 chosen." +msgstr "" + +#. NeCWK +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSEROWS(A1:E3;1;-1)</input> returns the array below with row 1 and row 3 chosen, note that row 3 is chosen from the end of the array." +msgstr "" + +#. DRtRZ +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index." +msgstr "" + +#. zEcCF +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS\";>CHOOSEROWS wiki page</link>." +msgstr "" + #. jF3yQ #: func_clean.xhp msgctxt "" @@ -60281,6 +60517,115 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DOLLAR\";>DOLLAR wiki page</link>." msgstr "" +#. hrfhC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"tit " +"help.text" +msgid "DROP function" +msgstr "" + +#. vSAGF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>DROP function</bookmark_value>" +msgstr "" + +#. CH7xF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_drop.xhp\">DROP</link></variable>" +msgstr "" + +#. tzzCD +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id771708806478128 " +"help.text" +msgid "Drops a specified number of contiguous rows or columns from the start or end of an array." +msgstr "" + +#. YVkFY +#: func_drop.xhp +#, fuzzy +msgctxt "" +"func_drop.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. ivgUo +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id851737751444186 " +"help.text" +msgid "DROP(Array; Row; [Column])" +msgstr "" + +#. djzuC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range from which to drop rows or columns." +msgstr "" + +#. 8NwZE +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id111738104866763 " +"help.text" +msgid "<emph>Rows</emph>: the number of rows to drop. A negative value drops from the end of the array." +msgstr "" + +#. XTxhf +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id111738104891522 " +"help.text" +msgid "<emph>Columns</emph>: (optional) the number of columns to drop. A negative value drops from the end of the array." +msgstr "" + +#. 6ECKo +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id631738108398030 " +"help.text" +msgid "The formula <input>{=DROP(A1:E3;1;3)}</input> returns the array below dropping first 1 row and first 3 columns." +msgstr "" + +#. XAV2K +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=DROP(A1:E3;-1;-3)}</input> drops the last row and the last 3 columns." +msgstr "" + +#. FhuUC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DROP\";>DROP wiki page</link>." +msgstr "" + #. RpPVW #: func_eastersunday.xhp msgctxt "" @@ -60938,6 +61283,115 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXACT\";>EXACT wiki page</link>." msgstr "" +#. UABhi +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"tit " +"help.text" +msgid "EXPAND function" +msgstr "" + +#. LVpwH +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>EXPAND function</bookmark_value>" +msgstr "" + +#. yBGiA +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_expand.xhp\">EXPAND</link></variable>" +msgstr "" + +#. 5LotC +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id771708806478128 " +"help.text" +msgid "Expand an array by adding rows or columns." +msgstr "" + +#. WJVx6 +#: func_expand.xhp +#, fuzzy +msgctxt "" +"func_expand.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. Yy9q4 +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=EXPAND(Array;Rows;[Columns];[Pad_with])</input>" +msgstr "" + +#. ppWFd +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: the array or range to expand by the number of rows and/or columns." +msgstr "" + +#. dyQRu +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Rows</emph>: the final number of rows the array will expand. Default is total rows." +msgstr "" + +#. Kk5Vz +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Columns</emph>: (optional) The final number of columns the array will expand. Default is total columns." +msgstr "" + +#. xoxMh +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad in new cells. By default, #N/A is used to fill the new cells." +msgstr "" + +#. 3923w +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=EXPAND(A1:E3;4;7;\"@@@\")}</input> expands the array <literal>A1:E3</literal> to 7 columns and 4 rows, padding the extra cells with the string \"@@@\"." +msgstr "" + +#. PhTg7 +#: func_expand.xhp +msgctxt "" +"func_expand.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EXPAND\";>EXPAND wiki page</link>." +msgstr "" + #. qdiU7 #: func_filter.xhp msgctxt "" @@ -62765,6 +63219,106 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR\";>HOUR wiki page</link>." msgstr "" +#. wJVKF +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"tit " +"help.text" +msgid "HSTACK function" +msgstr "" + +#. ki2vF +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>HSTACK function</bookmark_value>" +msgstr "" + +#. LBtai +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_hstack.xhp\">HSTACK</link></variable>" +msgstr "" + +#. BM4on +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id771708806478128 " +"help.text" +msgid "Appends arrays horizontally to create a larger array." +msgstr "" + +#. EYr9p +#: func_hstack.xhp +#, fuzzy +msgctxt "" +"func_hstack.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. 5hFvD +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=HSTACK(Array;[Array_1;[Array_2;[...]]])</input>" +msgstr "" + +#. eT93L +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The first array to be returned in a new array." +msgstr "" + +#. igZ74 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Array_1; Array_2; ...</emph>: (optional) the arrays to append sequentially after the previous array." +msgstr "" + +#. dNM4K +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id471739049807951 " +"help.text" +msgid "And the second array as:" +msgstr "" + +#. 4ZNv6 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=HSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of array N15:O19 on the right of the data of array A1:E3, and extra cells filled with #N/A error:" +msgstr "" + +#. uCzt3 +#: func_hstack.xhp +msgctxt "" +"func_hstack.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/HSTACK\";>HSTACK wiki page</link>." +msgstr "" + #. DiCWs #: func_ifs.xhp msgctxt "" @@ -63924,7 +64478,7 @@ msgctxt "" "tit " "help.text" msgid "JIS Function" -msgstr "" +msgstr "Función JIS" #. 5Qavf #: func_jis.xhp @@ -63969,7 +64523,7 @@ msgctxt "" "par_id701542231253817 " "help.text" msgid "<input>JIS(Text)</input>" -msgstr "" +msgstr "<input>JIS(Testu)</input>" #. f9YAh #: func_jis.xhp @@ -69704,6 +70258,124 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/T\";>T wiki page</link>." msgstr "" +#. ndEtp +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"tit " +"help.text" +msgid "TAKE function" +msgstr "" + +#. 7FEnC +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TAKE function</bookmark_value>" +msgstr "" + +#. pB7UF +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_take.xhp\">TAKE</link></variable>" +msgstr "" + +#. M8amC +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns a specified number of contiguous rows or columns from the start or end of an array." +msgstr "" + +#. PevRB +#: func_take.xhp +#, fuzzy +msgctxt "" +"func_take.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. PBxpS +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id851737751444186 " +"help.text" +msgid "TAKE(Array; Row; [Column])" +msgstr "" + +#. A2PcT +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range from which to take rows or columns." +msgstr "" + +#. VY85L +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id111738104866763 " +"help.text" +msgid "<emph>Rows</emph>: the number of rows to take. A negative value takes from the end of the array." +msgstr "" + +#. MGCkb +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id111738104891522 " +"help.text" +msgid "<emph>Columns</emph>: (optional) the number of columns to take. A negative value takes from the end of the array." +msgstr "" + +#. CfyGu +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;;1)}</input> returns the array with 3 rows (default) and 3 columns." +msgstr "" + +#. yhCLT +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;2;4)}</input> returns the array below with 2 rows and 4 columns." +msgstr "" + +#. BQjC5 +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id631738108398030 " +"help.text" +msgid "The formula <input>{=TAKE(A1:E3;-2;-2)}</input> returns the array below taking 2 rows starting from the last row and 2 columns starting from the last column." +msgstr "" + +#. yTovP +#: func_take.xhp +msgctxt "" +"func_take.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TAKE\";>TAKE wiki page</link>." +msgstr "" + #. 56Dgq #: func_text.xhp msgctxt "" @@ -69812,6 +70484,258 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXT\";>TEXT wiki page</link>." msgstr "" +#. dnR6C +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"tit " +"help.text" +msgid "TEXTAFTER function" +msgstr "" + +#. yXYYE +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTAFTER function</bookmark_value>" +msgstr "" + +#. rogfF +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"hd_id451747059635188 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_textafter.xhp\">TEXTAFTER</link></variable>" +msgstr "" + +#. sj3QA +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id381747059635191 " +"help.text" +msgid "Returns the text that occurs after a given substring or delimiter." +msgstr "" + +#. sFgek +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTAFTER( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])" +msgstr "" + +#. zZodV +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id91747066169381 " +"help.text" +msgid "<emph>Text</emph>: the original text." +msgstr "" + +#. zgsKn +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id221747066174430 " +"help.text" +msgid "<emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied." +msgstr "" + +#. xprDt +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id821747066179393 " +"help.text" +msgid "<emph>Instance Number</emph>: (optional) the instance of the delimiter after which to extract text. The default is 1. A negative number starts searching from the end." +msgstr "" + +#. hhUE8 +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id121747066183422 " +"help.text" +msgid "<emph>Match Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The default is 0." +msgstr "" + +#. CCWDU +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id201747066188182 " +"help.text" +msgid "<emph>Match End</emph>: (optional) set to 1 to treat the end of text as a delimiter. The default is 0." +msgstr "" + +#. 8sFSe +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id701747066192253 " +"help.text" +msgid "<emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is #N/A." +msgstr "" + +#. 69LCo +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id21747067698384 " +"help.text" +msgid "<input>=TEXTAFTER(\"To be or not to be\";\"or\";1;0;0;\"@@@\")</input> returns the string \"not to be\", taking after the delimiter \"or\"." +msgstr "" + +#. EaiEG +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id971747068062071 " +"help.text" +msgid "<input>=TEXTAFTER(\"To be or not to be\";\"question\";1;0;0;\"@@@\")</input> returns the text \"@@@\" because the delimiter \"question\" is not in the source text." +msgstr "" + +#. UfdCm +#: func_textafter.xhp +msgctxt "" +"func_textafter.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTAFTER\";>TEXTAFTER wiki page</link>." +msgstr "" + +#. GFNEX +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"tit " +"help.text" +msgid "TEXTBEFORE function" +msgstr "" + +#. rsKft +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTBEFORE function</bookmark_value>" +msgstr "" + +#. LDGA7 +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"hd_id451747059635188 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_textbefore.xhp\">TEXTBEFORE</link></variable>" +msgstr "" + +#. DWGTL +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id381747059635191 " +"help.text" +msgid "Returns the text that occurs before a given substring or delimiter." +msgstr "" + +#. tdzNR +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTBEFORE( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; If Not Found ]]]]])" +msgstr "" + +#. BniCf +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id91747066169381 " +"help.text" +msgid "<emph>Text</emph>: the original text." +msgstr "" + +#. HXcqw +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id221747066174430 " +"help.text" +msgid "<emph>Delimiter</emph>: (optional) the delimiter. Multiple delimiters can be supplied." +msgstr "" + +#. uFJHF +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id821747066179393 " +"help.text" +msgid "<emph>Instance Number</emph>: (optional) the instance of the delimiter before which to extract text. The default is 1. A negative number starts searching from the end." +msgstr "" + +#. mziCS +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id121747066183422 " +"help.text" +msgid "<emph>Match Mode</emph>: (optional) set to 1 to perform a case-insensitive match. The default is 0." +msgstr "" + +#. NkfZ6 +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id201747066188182 " +"help.text" +msgid "<emph>Match End</emph>: (optional) set to 1 to treat the end of text as a delimiter. The default is 0." +msgstr "" + +#. MG8yC +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id701747066192253 " +"help.text" +msgid "<emph>If Not Found</emph>: (optional) the value returned if no match is found. The default is #N/A." +msgstr "" + +#. AGARN +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id21747067698384 " +"help.text" +msgid "<input>=TEXTBEFORE(\"To be or not to be\";\"be\";2;0;0;\"@@@\")</input> returns the string \"To be or not to\", taking up to the second instance of the delimiter \"be\"." +msgstr "" + +#. NK7VF +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id971747068062071 " +"help.text" +msgid "<input>=TEXTBEFORE(\"To be or not to be\";\"question\";1;0;0;\"@@@\")</input> returns the text \"@@@\" because the delimiter \"question\" is not in the source text." +msgstr "" + +#. BTHEE +#: func_textbefore.xhp +msgctxt "" +"func_textbefore.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTBEFORE\";>TEXTBEFORE wiki page</link>." +msgstr "" + #. BCAZr #: func_textjoin.xhp msgctxt "" @@ -69956,6 +70880,132 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENATE</link>" msgstr "" +#. KA3Af +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"tit " +"help.text" +msgid "TEXTSPLIT function" +msgstr "" + +#. BjPEy +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"bm_id581556228060864 " +"help.text" +msgid "<bookmark_value>TEXTSPLIT function</bookmark_value>" +msgstr "" + +#. mCixC +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"hd_id551556227727946 " +"help.text" +msgid "<variable id=\"textsplitfunct\"><link href=\"text/scalc/01/func_textsplit.xhp\">TEXTSPLIT</link></variable>" +msgstr "" + +#. esNA8 +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id121556227727948 " +"help.text" +msgid "<variable id=\"textsplitfunction\">Splits text by a given delimiter to an array of multiple cells.</variable>" +msgstr "" + +#. dxTDq +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id541556228253979 " +"help.text" +msgid "TEXTSPLIT(Text [; Column Delimiter [; Row Delimiter [; Ignore Empty [; Match Mode [; Pad With ]]]]])" +msgstr "" + +#. J7wSk +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id741746962354423 " +"help.text" +msgid "<emph>Text</emph>: (optional) the text to split." +msgstr "" + +#. Euuxu +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id91746962359992 " +"help.text" +msgid "<emph>Column Delimiter</emph>: (optional) the text to delimit the columns. Multiple delimiters can be supplied." +msgstr "" + +#. Pqzhk +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id361746962365647 " +"help.text" +msgid "<emph>Row Delimiter</emph>: (optional) the text to delimit the rows. Multiple delimiters can be supplied." +msgstr "" + +#. j3omS +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id521746962371799 " +"help.text" +msgid "<emph>Ignore Empty</emph>: (optional) set to TRUE to ignore consecutive delimiters otherwise creates an empty cell. The default to FALSE." +msgstr "" + +#. aFiwx +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id951746962377042 " +"help.text" +msgid "<emph>Match mode</emph>: (optional) set to 1 to perform a case-insensitive match otherwise does a case-sensitive match. The default to 0." +msgstr "" + +#. y4rDQ +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id651746962382871 " +"help.text" +msgid "<emph>Pad with</emph>: (optional) the value with which to pad. The default is #N/A." +msgstr "" + +#. G3ayA +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id521746970153871 " +"help.text" +msgid "If cell A1 contains <literal>\"AA,BB,,CC/DD,EE,FF/GG,HH,II,JJ\"</literal>, then" +msgstr "" + +#. Vnbsd +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id541746969982707 " +"help.text" +msgid "<input>{=TEXTSPLIT(A1;\",\";\"/\";FALSE();1;\"@@@\")}</input> returns the following array:" +msgstr "" + +#. wVaAc +#: func_textsplit.xhp +msgctxt "" +"func_textsplit.xhp " +"par_id761677014445916 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTSPLIT\";>TEXTSPLIT wiki page</link>." +msgstr "" + #. pLSAn #: func_time.xhp msgctxt "" @@ -70154,6 +71204,160 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIMEVALUE\";>TIMEVALUE wiki page</link>." msgstr "" +#. 5gfLF +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"tit " +"help.text" +msgid "TOCOL function" +msgstr "" + +#. GRyGe +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TOCOL function</bookmark_value>" +msgstr "" + +#. 774mk +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_tocol.xhp\">TOCOL</link></variable>" +msgstr "" + +#. xQCwR +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id771708806478128 " +"help.text" +msgid "Transforms an array or range into a single column." +msgstr "" + +#. v8Q4Q +#: func_tocol.xhp +#, fuzzy +msgctxt "" +"func_tocol.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. AV4Ra +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id851737751444186 " +"help.text" +msgid "TOCOL(Array; [Ignore]; [By_column])" +msgstr "" + +#. DzGBX +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range to return as a single column." +msgstr "" + +#. FCSvz +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id31737751839305 " +"help.text" +msgid "<emph>Ignore</emph>: (optional) Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:" +msgstr "" + +#. GDiV2 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id971737751690332 " +"help.text" +msgid "<emph>0</emph>: Keep all values (default)" +msgstr "" + +#. ySDuV +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id381737751703531 " +"help.text" +msgid "<emph>1</emph>: Ignore blank cells" +msgstr "" + +#. qsJVZ +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id931737751715731 " +"help.text" +msgid "<emph>2</emph>: Ignore cells with errors" +msgstr "" + +#. pEBgh +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id101737751728979 " +"help.text" +msgid "<emph>3</emph>: Ignore both blank cells and error cells" +msgstr "" + +#. U9F33 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id771737751844889 " +"help.text" +msgid "<emph>By_column</emph>: (optional) Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column." +msgstr "" + +#. ffBcv +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TOCOL(A1:E3)}</input> returns the column" +msgstr "" + +#. 4Mfz9 +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>=TOCOL(A1:E3;1)</input> returns the column below without the blank cells." +msgstr "" + +#. RfRPP +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id31737760079923 " +"help.text" +msgid "The formula <input>=TOCOL(A1:E3;1;TRUE())</input> returns the column below without the blank cells, scanned by columns." +msgstr "" + +#. fhPCe +#: func_tocol.xhp +msgctxt "" +"func_tocol.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOCOL\";>TOCOL wiki page</link>." +msgstr "" + #. 8LaX7 #: func_today.xhp msgctxt "" @@ -70226,6 +71430,106 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TODAY\";>TODAY wiki page</link>." msgstr "" +#. KyMHj +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"tit " +"help.text" +msgid "TOROW function" +msgstr "" + +#. hADta +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>TOROW function</bookmark_value>" +msgstr "" + +#. e4D64 +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_torow.xhp\">TOROW</link></variable>" +msgstr "" + +#. PqV7k +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id771708806478128 " +"help.text" +msgid "Transforms an array or range into a single row." +msgstr "" + +#. SEcDZ +#: func_torow.xhp +#, fuzzy +msgctxt "" +"func_torow.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. shqrj +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id851737751444186 " +"help.text" +msgid "TOROW(Array, [Ignore], [By_column])" +msgstr "" + +#. 7D5aC +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range to return as a single row." +msgstr "" + +#. crgjU +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id711737758586509 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3)}</input> returns the row" +msgstr "" + +#. szwfc +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id351737760079923 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3;1)}</input> returns the row below without the blank cells." +msgstr "" + +#. pDw8G +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id31737760079923 " +"help.text" +msgid "The formula <input>{=TOROW(A1:E3;1;TRUE())}</input> returns the row below without the blank cells, scanned by columns." +msgstr "" + +#. cYECo +#: func_torow.xhp +msgctxt "" +"func_torow.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TOROW\";>TOROW wiki page</link>." +msgstr "" + #. F4uSC #: func_trim.xhp msgctxt "" @@ -70937,6 +72241,116 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\";>VALUE wiki page</link>." msgstr "" +#. XkyPd +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"tit " +"help.text" +msgid "VSTACK function" +msgstr "" + +#. MEU7Q +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>VSTACK function</bookmark_value>" +msgstr "" + +#. oQLBE +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_vstack.xhp\">VSTACK</link></variable>" +msgstr "" + +#. BCxHz +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id771708806478128 " +"help.text" +msgid "Appends arrays vertically to create a larger array." +msgstr "" + +#. uvW6D +#: func_vstack.xhp +#, fuzzy +msgctxt "" +"func_vstack.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. TtDZ6 +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=VSTACK(Array;[Array_1;[Array_2;[...]]])</input>" +msgstr "" + +#. w8o8C +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The first array to be returned in a new array." +msgstr "" + +#. h2682 +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Array_1; Array_2; ...</emph>: (optional) the arrays to append sequentially after the previous array." +msgstr "" + +#. mrv9C +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id471739049807951 " +"help.text" +msgid "And the second array as:" +msgstr "" + +#. aTNJM +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=VSTACK(A1:E3;N15:O19)}</input> returns the array below, with data of array N15:O19 below data of array A1:E3, and extra cells filled with #N/A error:" +msgstr "" + +#. W3uMW +#: func_vstack.xhp +#, fuzzy +msgctxt "" +"func_vstack.xhp " +"par_id391739050327791 " +"help.text" +msgid "<variable id=\"NA\">#N/A</variable>" +msgstr "<variable id=\"row_hd\">Filera</variable>" + +#. Quwcq +#: func_vstack.xhp +msgctxt "" +"func_vstack.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VSTACK\";>VSTACK wiki page</link>." +msgstr "" + #. dQeP6 #: func_webservice.xhp msgctxt "" @@ -72261,6 +73675,206 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\";>WORKDAY wiki page</link>." msgstr "" +#. F5Etj +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"tit " +"help.text" +msgid "WRAPCOLS function" +msgstr "" + +#. 8MDGd +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>WRAPCOLS function</bookmark_value>" +msgstr "" + +#. S6WJW +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_wrapcols.xhp\">WRAPCOLS</link></variable>" +msgstr "" + +#. vFj7J +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id771708806478128 " +"help.text" +msgid "Converts a single row or column into multiple columns (a 2-demensional array) by specifying the number of values in each column." +msgstr "" + +#. CMPQW +#: func_wrapcols.xhp +#, fuzzy +msgctxt "" +"func_wrapcols.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. Hpucy +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id871737825179033 " +"help.text" +msgid "=WRAPCOLS(Range, Wrap_count, [Pad_with])" +msgstr "" + +#. pnet5 +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id701737825446850 " +"help.text" +msgid "<emph>Range</emph>: the range to wrap." +msgstr "" + +#. A5fZc +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id441737825452403 " +"help.text" +msgid "<emph>Wrap_count</emph>: the maximum number of values in each column." +msgstr "" + +#. c2Mue +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad if there are insufficient number of values. By default, it returns #N/A to fill in the cells." +msgstr "" + +#. eAMgY +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id771738021783517 " +"help.text" +msgid "The formula <input>{=WRAPCOLS(A1:A15;6)}</input> returns the array below. The missing values are replaced by #N/A." +msgstr "" + +#. gt3gw +#: func_wrapcols.xhp +msgctxt "" +"func_wrapcols.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPCOLS\";>WRAPCOLS wiki page</link>." +msgstr "" + +#. P7aXo +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"tit " +"help.text" +msgid "WRAPROWS function" +msgstr "" + +#. BGSi7 +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>WRAPROWS function</bookmark_value>" +msgstr "" + +#. J7CpA +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_wraprows.xhp\">WRAPROWS</link></variable>" +msgstr "" + +#. KuEGN +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id771708806478128 " +"help.text" +msgid "Converts a single row or column into multiple rows (a 2-demensional array) by specifying the number of values in each row." +msgstr "" + +#. AGoLi +#: func_wraprows.xhp +#, fuzzy +msgctxt "" +"func_wraprows.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Introduz la fórmula como <link href=\"text/scalc/01/04060107.xhp\">matricial</link>." + +#. u3CeY +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id871737825179033 " +"help.text" +msgid "=WRAPROWS(Range, Wrap_count, [Pad_with])" +msgstr "" + +#. xDnxq +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id701737825446850 " +"help.text" +msgid "<emph>Range</emph>: the range to wrap." +msgstr "" + +#. 36Has +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id441737825452403 " +"help.text" +msgid "<emph>Wrap_count</emph>: the maximum number of values in each column." +msgstr "" + +#. Arfnd +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id411737825456380 " +"help.text" +msgid "<emph>Pad_with</emph>: (optional) a specified value to pad if there are insufficient number of values. By default, it returns #N/A to fill in the cells." +msgstr "" + +#. JsK5T +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id771738021783517 " +"help.text" +msgid "The formula <input>{=WRAPROWS(A1:A15;4)}</input> returns the array below. The missing values are replaced by #N/A." +msgstr "" + +#. i7yWC +#: func_wraprows.xhp +msgctxt "" +"func_wraprows.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WRAPROWS\";>WRAPROWS wiki page</link>." +msgstr "" + #. SHsJ2 #: func_xlookup.xhp msgctxt "" @@ -75213,6 +76827,42 @@ msgctxt "" msgid "<emph>Imaginary</emph>" msgstr "<emph>Imaxinariu</emph>" +#. KAvDE +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id71737757692138 " +"help.text" +msgid "Consider the array <literal>A1:E3</literal> below:" +msgstr "Considera la siguiente matriz, <literal>A1:E3</literal>:" + +#. ChcT8 +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id71737753692138 " +"help.text" +msgid "Consider the array <literal>A1:A15</literal> below." +msgstr "Considera la siguiente matriz, <literal>A1:A15</literal>." + +#. sG2zy +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id791739049060653 " +"help.text" +msgid "N" +msgstr "N" + +#. y4i8s +#: stat_data.xhp +msgctxt "" +"stat_data.xhp " +"par_id671739049060653 " +"help.text" +msgid "O" +msgstr "O" + #. rTRpz #: statistics.xhp msgctxt "" diff --git a/source/bg/helpcontent2/source/text/scalc/01.po b/source/bg/helpcontent2/source/text/scalc/01.po index d0b2a9d3f68..94d5b36e517 100644 --- a/source/bg/helpcontent2/source/text/scalc/01.po +++ b/source/bg/helpcontent2/source/text/scalc/01.po @@ -3,13 +3,13 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION " "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI " -"POT-Creation-Date: 2025-01-07 15:27+0100 " +"POT-Creation-Date: 2025-09-17 16:16+0930 " "PO-Revision-Date: 2025-07-22 02:53+0000 " "Last-Translator: Mihail Balabanov <[email protected]> " "Language-Team: Bulgarian <https://translations.documentfoundation.org/projects/libo_help-25-2/textscalc01/bg/> " "Language: bg " "MIME-Version: 1.0 " -"Content-Type: text/plain; charset=utf-8 " +"Content-Type: text/plain; charset=UTF-8 " "Content-Transfer-Encoding: 8bit " "Plural-Forms: nplurals=2; plural=n != 1; " "X-Accelerator-Marker: ~ " @@ -56978,6 +56978,244 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHAR\";>CHAR wiki page</link>." msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHAR\";>Уикистраница за CHAR</link>." +#. KzRKA +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"tit " +"help.text" +msgid "CHOOSECOLS function" +msgstr "Функция CHOOSECOLS" + +#. RmBsq +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSECOLS function</bookmark_value>" +msgstr "<bookmark_value>CHOOSECOLS, функция</bookmark_value>" + +#. pgEyS +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_choosecols.xhp\">CHOOSECOLS</link></variable>" +msgstr "<variable id=\"h1\"><link href=\"text/scalc/01/func_choosecols.xhp\">CHOOSECOLS</link></variable>" + +#. qxKzH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified columns from an array." +msgstr "Връща указаните колони от масив." + +#. tDfbe +#: func_choosecols.xhp +#, fuzzy +msgctxt "" +"func_choosecols.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Въведете формулата като <link href=\"text/scalc/01/04060107.xhp\">формула за масив</link>." + +#. NoxBH +#: func_choosecols.xhp +#, fuzzy +msgctxt "" +"func_choosecols.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSECOLS(Array;Column_1;[Column_2;[Column_3;[...]]])</input>" +msgstr "=CHOOSECOLS(Масив; Колона_1 [; Колона_2 [; Колона_3 [; ...]]])" + +#. cvwYJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the columns to be returned in a new array." +msgstr "<emph>Масив</emph>: масивът, съдържащ колоните, които да бъдат върнати в нов масив." + +#. weToH +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Column_1</emph>: The index of the first column to be returned. A negative value chooses from the end of the array." +msgstr "<emph>Колона_1</emph>: индексът на първата колона, която да бъде върната. При отрицателна стойност се избира откъм края на масива." + +#. gUFeT +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Column_2; Column_3; ...</emph>: (optional) The list of other column indexes to be returned. A negative value chooses from the end of the array." +msgstr "<emph>Колона_2; Колона_3; ...</emph>: (незадължителен) списъкът с индексите на другите колони, които да бъдат върнати. При отрицателна стойност се избира откъм края на масива." + +#. uiDSY +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSECOLS(A1:E3;2;4;5)}</input> returns the array below with columns 2,4 and 5 chosen." +msgstr "Формулата <input>{=CHOOSECOLS(A1:E3;2;4;5)}</input> връща масива по-долу с избраните колони 2, 4 и 5." + +#. MdDNC +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSECOLS(A1:E3;1;-1)</input> returns the array below with column 1 and column 5 chosen, note that column 5 is chosen from the end of the array." +msgstr "Формулата <input>=CHOOSECOLS(A1:E3;1;-1)</input> връща масива по-долу с избраните колони 1 и 5, обърнете внимание, че колона 5 е избрана от края на масива." + +#. 74pDf +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index." +msgstr "Използвайте функцията CHOOSECOLS, за да пренаредите колоните на масив. Освен това можете да дублирате колони, като повтаряте индексите им." + +#. d8LnJ +#: func_choosecols.xhp +msgctxt "" +"func_choosecols.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS\";>CHOOSECOLS wiki page</link>." +msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSECOLS\";>Уикистраница за CHOOSECOLS</link>." + +#. QsPBU +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"tit " +"help.text" +msgid "CHOOSEROWS function" +msgstr "Функция CHOOSEROWS" + +#. csFBa +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>CHOOSEROWS function</bookmark_value>" +msgstr "<bookmark_value>CHOOSEROWS, функция</bookmark_value>" + +#. 2DzoR +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_chooserows.xhp\">CHOOSEROWS</link></variable>" +msgstr "<variable id=\"h1\"><link href=\"text/scalc/01/func_chooserows.xhp\">CHOOSEROWS</link></variable>" + +#. 7945V +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id771708806478128 " +"help.text" +msgid "Returns the specified rows from an array." +msgstr "Връща указаните редове от масив." + +#. T26fr +#: func_chooserows.xhp +#, fuzzy +msgctxt "" +"func_chooserows.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Въведете формулата като <link href=\"text/scalc/01/04060107.xhp\">формула за масив</link>." + +#. xmeqv +#: func_chooserows.xhp +#, fuzzy +msgctxt "" +"func_chooserows.xhp " +"par_id601738075517060 " +"help.text" +msgid "<input>=CHOOSEROWS(Array;Row_1;[Row_2;[Row_3;[...]]])</input>" +msgstr "=CHOOSEROWS(Масив; Ред_1 [; Ред_2 [; Ред_3 [; ...]]])" + +#. ckm7y +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id81738076052161 " +"help.text" +msgid "<emph>Array</emph>: The array containing the rows to be returned in a new array." +msgstr "<emph>Масив</emph>: масивът, съдържащ редовете, които да бъдат върнати в нов масив." + +#. ziFKi +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id191738076047602 " +"help.text" +msgid "<emph>Row_1</emph>: The index of the first row to be returned. A negative value chooses from the end of the array." +msgstr "<emph>Ред_1</emph>: индексът на първия ред, който да бъде върнат. При отрицателна стойност се избира откъм края на масива." + +#. VVSCT +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id1001738076043608 " +"help.text" +msgid "<emph>Row_2; Row_3; ...</emph>: (optional) The list of other row indexes to be returned. A negative value chooses from the end of the array." +msgstr "<emph>Ред_2; Ред_3; ...</emph>: (незадължителен) списъкът с индексите на другите редове, които да бъдат върнати. При отрицателна стойност се избира откъм края на масива." + +#. C9Vng +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id821738091480292 " +"help.text" +msgid "The formula <input>{=CHOOSEROWS(A1:E3;2;3)}</input> returns the array below with rows 2 and 3 chosen." +msgstr "Формулата <input>{=CHOOSEROWS(A1:E3;2;3)}</input> връща масива по-долу с избраните редове 2 и 3." + +#. NeCWK +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id21738975515099 " +"help.text" +msgid "The formula <input>=CHOOSEROWS(A1:E3;1;-1)</input> returns the array below with row 1 and row 3 chosen, note that row 3 is chosen from the end of the array." +msgstr "Формулата <input>=CHOOSEROWS(A1:E3;1;-1)</input> връща масива по-долу с избраните редове 1 и 3, обърнете внимание, че ред 3 е избран от края на масива." + +#. DRtRZ +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id481738974778935 " +"help.text" +msgid "Use the function CHOOSEROWS to reorder the rows of an array. You can also replicate rows by repeating the row index." +msgstr "Използвайте функцията CHOOSEROWS, за да пренаредите редовете на масив. Освен това можете да дублирате редове, като повтаряте индексите им." + +#. zEcCF +#: func_chooserows.xhp +msgctxt "" +"func_chooserows.xhp " +"par_id701677016751508 " +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS\";>CHOOSEROWS wiki page</link>." +msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CHOOSEROWS\";>Уикистраница за CHOOSEROWS</link>." + #. jF3yQ #: func_clean.xhp msgctxt "" @@ -60281,6 +60519,116 @@ msgctxt "" msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DOLLAR\";>DOLLAR wiki page</link>." msgstr "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DOLLAR\";>Уикистраница за DOLLAR</link>." +#. hrfhC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"tit " +"help.text" +msgid "DROP function" +msgstr "Функция DROP" + +#. vSAGF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"bm_id361708283183878 " +"help.text" +msgid "<bookmark_value>DROP function</bookmark_value>" +msgstr "<bookmark_value>DROP, функция</bookmark_value>" + +#. CH7xF +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"hd_id901708806478126 " +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_drop.xhp\">DROP</link></variable>" +msgstr "<variable id=\"h1\"><link href=\"text/scalc/01/func_drop.xhp\">DROP</link></variable>" + +#. tzzCD +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id771708806478128 " +"help.text" +msgid "Drops a specified number of contiguous rows or columns from the start or end of an array." +msgstr "Премахва указан брой последователни редове или колони от началото или края на масив." + +#. YVkFY +#: func_drop.xhp +#, fuzzy +msgctxt "" +"func_drop.xhp " +"par_id131711543270539 " +"help.text" +msgid "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." +msgstr "Въведете формулата като <link href=\"text/scalc/01/04060107.xhp\">формула за масив</link>." + +#. ivgUo +#: func_drop.xhp +#, fuzzy +msgctxt "" +"func_drop.xhp " +"par_id851737751444186 " +"help.text" +msgid "DROP(Array; Row; [Column])" +msgstr "DROP(Масив; Редове [; Колони])" + +#. djzuC +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id391737751833481 " +"help.text" +msgid "<emph>Array</emph>: the array or range from which to drop rows or columns." +msgstr "<emph>Масив</emph>: масивът или диапазонът, от който да се премахнат редове или колони." + +#. 8NwZE +#: func_drop.xhp +msgctxt "" +"func_drop.xhp " +"par_id111738104866763 " +"help.text" +msgid "<emph>Rows</emph>: the number of rows to drop. A negative value drops from the end of the array." -e ... etc. - the rest is truncated
