diff options
Diffstat (limited to 'source/lv/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/lv/helpcontent2/source/text/scalc/01.po | 1603 |
1 files changed, 1391 insertions, 212 deletions
diff --git a/source/lv/helpcontent2/source/text/scalc/01.po b/source/lv/helpcontent2/source/text/scalc/01.po index e264841d4e2..c6fd443b85b 100644 --- a/source/lv/helpcontent2/source/text/scalc/01.po +++ b/source/lv/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2022-12-08 19:46+0100\n" +"POT-Creation-Date: 2023-03-02 11:50+0100\n" "PO-Revision-Date: 2019-02-27 15:24+0000\n" "Last-Translator: Ingmārs Dīriņš <melhiors14@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -8323,13 +8323,13 @@ msgctxt "" msgid "Always \"Windows (32-bit) NT 5.01\", for compatibility reasons" msgstr "" -#. cFWJe +#. bG56P #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id9841608\n" "help.text" -msgid "The type of the operating system: <br/>\"AIX\" for Advanced Interactive Executive IBM computer operating systems<br/>\"ANDROID\" for Google mobile operating system<br/>\"DRAGONFLY\" for DragonFly operating system forked from FreeBSD<br/>\"EMSCRIPTEN\" for browser WebAssembly system<br/>\"FREEBSD\", \"OPENBSD\" or \"NETBSD\" for operating systems based on the Berkeley Software Distribution (BSD)<br/>\"HAIKU\" for BeOS compatible operating system<br/>\"iOS\" for Apple mobile operating system <br/>\"LINUX\" for GNU/Linux based operating systems<br/>\"MACOSX\" for Apple Mac OS X<br/>\"SOLARIS\" for Oracle Solaris operating system<br/>\"WNT\" for Microsoft Windows" +msgid "The type of the operating system: <br/>\"ANDROID\" for Google mobile operating system<br/>\"DRAGONFLY\" for DragonFly operating system forked from FreeBSD<br/>\"EMSCRIPTEN\" for browser WebAssembly system<br/>\"FREEBSD\", \"OPENBSD\" or \"NETBSD\" for operating systems based on the Berkeley Software Distribution (BSD)<br/>\"HAIKU\" for BeOS compatible operating system<br/>\"iOS\" for Apple mobile operating system <br/>\"LINUX\" for GNU/Linux based operating systems<br/>\"MACOSX\" for Apple Mac OS X<br/>\"SOLARIS\" for Oracle Solaris operating system<br/>\"WNT\" for Microsoft Windows" msgstr "" #. zcvAx @@ -18268,58 +18268,58 @@ msgctxt "" msgid "INDEX" msgstr "INDEX" -#. pe6Sh +#. qitDL #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150268\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content.</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a sub range, specified by row and column number, and/or an optional range index.</ahelp>" msgstr "" -#. T659Y +#. dr8Bi #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149007\n" "help.text" -msgid "INDEX(Reference [; Row [; Column [; Range]]])" +msgid "INDEX(Reference [; [Row] [; [Column] [; Range]]])" msgstr "" -#. Btvgz +#. pnaQW #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3153260\n" "help.text" -msgid "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the reference or range name in parentheses." +msgid "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or use the tilde (~) concatenation/union operator." msgstr "" -#. UzYef +#. D2tov #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3145302\n" "help.text" -msgid "<emph>Row</emph> (optional) represents the row index of the reference range, for which to return a value. In case of zero (no specific row) all referenced rows are returned." +msgid "<emph>Row</emph> (optional) represents the row index of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned." msgstr "" -#. jG6E9 +#. PQAFz #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154628\n" "help.text" -msgid "<emph>Column</emph> (optional) represents the column index of the reference range, for which to return a value. In case of zero (no specific column) all referenced columns are returned." +msgid "<emph>Column</emph> (optional) represents the column index of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned." msgstr "" -#. gAgMJ +#. S6zm8 #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3155514\n" "help.text" -msgid "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range." +msgid "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default 1." msgstr "" #. 7pFH2 @@ -18358,31 +18358,31 @@ msgctxt "" msgid "<item type=\"input\">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6." msgstr "" -#. QQBsJ +#. igC59 #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id3158419\n" +"par_id3148595\n" "help.text" -msgid "<item type=\"input\">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type=\"input\">2</item> as the <emph>range</emph> parameter." +msgid "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range." msgstr "" -#. igC59 +#. GbCcS #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id3148595\n" +"par_id9960020\n" "help.text" -msgid "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range." +msgid "<item type=\"input\">=INDEX((A1:B6;C1:D6);0;0;2)</item> returns a reference to the second range C1:D6 of the multiple range." msgstr "" -#. ubk4L +#. CuDuU #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id9960020\n" +"par_id3158419\n" "help.text" -msgid "<item type=\"input\">=INDEX((multi);0;0;2)</item> returns a reference to the second range of the multiple range." +msgid "<item type=\"input\">=INDEX(multi;4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Sheet - Named Ranges and Expressions - Define</emph> as <emph>multi</emph> with the expression <emph>(A1:B6;C1:D6)</emph> for example. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type=\"input\">2</item> as the <emph>Range</emph> parameter." msgstr "" #. LCBWC @@ -19204,114 +19204,6 @@ msgctxt "" msgid "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." msgstr "" -#. jE43n -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"bm_id3149425\n" -"help.text" -msgid "<bookmark_value>STYLE function</bookmark_value>" -msgstr "<bookmark_value>STYLE funkcija</bookmark_value>" - -#. fhHrk -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"hd_id3149425\n" -"help.text" -msgid "STYLE" -msgstr "STYLE" - -#. mKer9 -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3150826\n" -"help.text" -msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand." -msgstr "" - -#. 2dQ6C -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id1670450904\n" -"help.text" -msgid "The STYLE function should not be used without compelling reason, its purpose is the use with asynchronous Add-In functions to visually notify about the availability of a result. In almost all other cases using conditional formatting instead is a better choice." -msgstr "" - -#. gU3TE -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3149302\n" -"help.text" -msgid "STYLE(\"Style\" [; Time [; \"Style2\"]])" -msgstr "" - -#. Q8SMG -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3150596\n" -"help.text" -msgid "<emph>Style</emph> is the name of a cell style assigned to the cell. Style names must be entered in quotation marks." -msgstr "" - -#. 4QYLv -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3156149\n" -"help.text" -msgid "<emph>Time</emph> is an optional time range in seconds. If this parameter is missing the style will not be changed after a certain amount of time has passed." -msgstr "" - -#. qsWTK -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3149520\n" -"help.text" -msgid "<emph>Style2</emph> is the optional name of a cell style assigned to the cell after a certain amount of time has passed. If this parameter is missing \"Default\" is assumed." -msgstr "" - -#. FuzQq -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3151374\n" -"help.text" -msgid "<item type=\"input\">=STYLE(\"Invisible\";60;\"Default\")</item> formats the cell in transparent format for 60 seconds after the document was recalculated or loaded, then the Default format is assigned. Both cell formats have to be defined beforehand." -msgstr "" - -#. mXCWB -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id8056886\n" -"help.text" -msgid "Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example:" -msgstr "" - -#. BdGi5 -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3668935\n" -"help.text" -msgid "<item type=\"input\">=\"Text\"&T(STYLE(\"myStyle\"))</item>" -msgstr "" - -#. W2bb3 -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" -"par_id3042085\n" -"help.text" -msgid "See also CURRENT() for another example." -msgstr "" - #. XYxM4 #: 04060109.xhp msgctxt "" @@ -41830,6 +41722,15 @@ msgctxt "" msgid "Range" msgstr "Diapazons" +#. MGA8Q +#: 04060199.xhp +msgctxt "" +"04060199.xhp\n" +"par_id3148432\n" +"help.text" +msgid "A1:C108, A:D or 3:13" +msgstr "" + #. fWnpm #: 04060199.xhp msgctxt "" @@ -41893,22 +41794,40 @@ msgctxt "" msgid "Concatenation or union" msgstr "" -#. Hkjhd +#. 56Udn #: 04060199.xhp msgctxt "" "04060199.xhp\n" "par_id2511978\n" "help.text" -msgid "Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. See note below this table." +msgid "Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice." +msgstr "" + +#. FayxP +#: 04060199.xhp +msgctxt "" +"04060199.xhp\n" +"par_id961672071835372\n" +"help.text" +msgid "<input>=COUNT(A1:B2~B2:C3)</input> counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice." msgstr "" -#. MsH7r +#. EYFWA +#: 04060199.xhp +msgctxt "" +"04060199.xhp\n" +"par_id401672243346224\n" +"help.text" +msgid "<input>=INDEX(A1:B2~C1:D2;2;1;2)</input> selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list." +msgstr "" + +#. nVdpz #: 04060199.xhp msgctxt "" "04060199.xhp\n" "par_id181890\n" "help.text" -msgid "Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression." +msgid "A reference list is not allowed inside an array expression." msgstr "" #. LfJJp @@ -45421,13 +45340,13 @@ msgctxt "" msgid "does not contain" msgstr "" -#. fc4Zs +#. 6uyxD #: 05120100.xhp msgctxt "" "05120100.xhp\n" "par_id541662923021543\n" "help.text" -msgid "The cell contents does not contain the text or number defined in the text box on the right." +msgid "The cell content does not contain the text or number defined in the text box on the right." msgstr "" #. yF6EV @@ -45889,15 +45808,6 @@ msgctxt "" msgid "For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents." msgstr "" -#. PydFB -#: 05120200.xhp -msgctxt "" -"05120200.xhp\n" -"par_id471665407993996\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>" -msgstr "" - #. PJRcV #: 05120300.xhp msgctxt "" @@ -45988,15 +45898,6 @@ msgctxt "" msgid "<emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively." msgstr "" -#. jqWLy -#: 05120300.xhp -msgctxt "" -"05120300.xhp\n" -"par_id471665407993996\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>" -msgstr "" - #. ZANZR #: 05120400.xhp msgctxt "" @@ -46114,13 +46015,13 @@ msgctxt "" msgid "<link href=\"text/scalc/01/05120400.xhp#databar\">Data Bar</link>" msgstr "" -#. ZEyNr +#. 94FyT #: 05120400.xhp msgctxt "" "05120400.xhp\n" "par_id41609780964157\n" "help.text" -msgid "Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell." +msgid "Data bar option fills the cell with solid or gradient color corresponding to the numeric value in the cell." msgstr "" #. WHWWc @@ -46591,15 +46492,6 @@ msgctxt "" msgid "Conditions to set the thresholds for each icon can be specified as follows" msgstr "" -#. qxbFT -#: 05120400.xhp -msgctxt "" -"05120400.xhp\n" -"par_id471665407993996\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>" -msgstr "" - #. DdaUm #: 05120400.xhp msgctxt "" @@ -46672,15 +46564,6 @@ msgctxt "" msgid "If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range)." msgstr "" -#. MpYLG -#: 05120500.xhp -msgctxt "" -"05120500.xhp\n" -"par_id471665407993996\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/05120000.xhp#ConditionalFormattingh1\" markup=\"ignore\"/>" -msgstr "" - #. GXZBY #: 06020000.xhp msgctxt "" @@ -49282,22 +49165,58 @@ msgctxt "" msgid "Displays the rows of the cell range in descending order, based on the values in the cells of the current column." msgstr "" -#. sHhH3 +#. DGMci #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"hd_id401621534105620\n" +"hd_id391674926239837\n" "help.text" -msgid "Top 10" +msgid "Filter by Color" msgstr "" -#. onMjn +#. s5KFC #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"par_id341621544426925\n" +"hd_id271621534120995\n" "help.text" -msgid "Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown." +msgid "Text color" +msgstr "" + +#. CCGqV +#: 12040100.xhp +msgctxt "" +"12040100.xhp\n" +"par_id691621544414646\n" +"help.text" +msgid "Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected." +msgstr "" + +#. pdme8 +#: 12040100.xhp +msgctxt "" +"12040100.xhp\n" +"hd_id151621534125831\n" +"help.text" +msgid "Background color" +msgstr "" + +#. dzEhB +#: 12040100.xhp +msgctxt "" +"12040100.xhp\n" +"par_id491621544410605\n" +"help.text" +msgid "Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected." +msgstr "" + +#. EvRxc +#: 12040100.xhp +msgctxt "" +"12040100.xhp\n" +"hd_id771674926517261\n" +"help.text" +msgid "Filter by Condition" msgstr "" #. 4oiCy @@ -49336,40 +49255,40 @@ msgctxt "" msgid "Displays only the rows of the cell range that have a non-empty cell in the current column." msgstr "" -#. s5KFC +#. sHhH3 #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"hd_id271621534120995\n" +"hd_id401621534105620\n" "help.text" -msgid "Text color" +msgid "Top 10" msgstr "" -#. CCGqV +#. onMjn #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"par_id691621544414646\n" +"par_id341621544426925\n" "help.text" -msgid "Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected." +msgid "Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown." msgstr "" -#. pdme8 +#. gV63G #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"hd_id151621534125831\n" +"hd_id91674926632440\n" "help.text" -msgid "Background color" +msgid "Bottom 10" msgstr "" -#. dzEhB +#. uWEex #: 12040100.xhp msgctxt "" "12040100.xhp\n" -"par_id491621544410605\n" +"par_id791674926643175\n" "help.text" -msgid "Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected." +msgid "Displays the 10 rows of the cell range that contain the lowest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown." msgstr "" #. wCDB5 @@ -49426,13 +49345,13 @@ msgctxt "" msgid "Click once to select to show all rows and click again to select to hide all rows." msgstr "" -#. EADGt +#. amB7U #: 12040100.xhp msgctxt "" "12040100.xhp\n" "hd_id731621534146408\n" "help.text" -msgid "Show only current" +msgid "Show only current item" msgstr "" #. FURWe @@ -49444,13 +49363,13 @@ msgctxt "" msgid "Display only rows containing the value highlighted in the <emph>Value</emph> box." msgstr "" -#. ovQAm +#. 8NmUR #: 12040100.xhp msgctxt "" "12040100.xhp\n" "hd_id11621534151081\n" "help.text" -msgid "Hide only current" +msgid "Hide only current item" msgstr "" #. EJgvW @@ -54925,6 +54844,366 @@ msgctxt "" msgid "Only databar is shown. Value becomes hidden." msgstr "" +#. GXyQU +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"tit\n" +"help.text" +msgid "Default Number Formats" +msgstr "" + +#. 8ndNr +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id111674498160040\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format</link>" +msgstr "" + +#. vtUUF +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id211674498160040\n" +"help.text" +msgid "Default number formats" +msgstr "" + +#. PddvV +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id3149182\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number format: General</link>" +msgstr "" + +#. Bdin6 +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3163802\n" +"help.text" +msgid "<ahelp hid=\".uno:NumberFormatStandard\" visibility=\"visible\">Applies the default number format to the selected cells.</ahelp>" +msgstr "" + +#. acBdB +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3155922\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformatstandard.svg\" id=\"img_id3156024\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3156024\">Icon General Number Format</alt></image>" +msgstr "" + +#. obVcY +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3153361\n" +"help.text" +msgid "Number Format: General" +msgstr "" + +#. E7GxE +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id381674560759637\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number format: Number</link>" +msgstr "" + +#. ASdou +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id741674560753997\n" +"help.text" +msgid "Applies the default decimal number format to the selected cells." +msgstr "" + +#. hbYJM +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id901674564711935\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformatdecimal.svg\" id=\"img_id841674564711937\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id191674564711938\">Icon Number format: Number</alt></image>" +msgstr "" + +#. 4JhDr +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id361674564711940\n" +"help.text" +msgid "Number format: Number" +msgstr "" + +#. w2Sfo +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id3156329\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number format: Percent</link>" +msgstr "" + +#. CQAWE +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3155629\n" +"help.text" +msgid "<ahelp hid=\".uno:NumberFormatPercent\">Applies the percentage format to the selected cells.</ahelp>" +msgstr "" + +#. WJkBh +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3153968\n" +"help.text" +msgid "<image id=\"img_id3150869\" src=\"cmd/lc_numberformatpercent.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3150869\">Icon Number Format: Percent</alt></image>" +msgstr "" + +#. beHGN +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3151114\n" +"help.text" +msgid "Number Format: Percent" +msgstr "" + +#. P67mA +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id3152892\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number format: Currency</link>" +msgstr "" + +#. 4gkvd +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3148837\n" +"help.text" +msgid "<ahelp hid=\".uno:NumberFormatCurrency\" visibility=\"visible\">Applies the default currency format to the selected cells.</ahelp>" +msgstr "" + +#. wNvKY +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3155267\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformatcurrency.svg\" id=\"img_id3159096\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3159096\">Currency Number Format Icon</alt></image>" +msgstr "" + +#. KG3Ea +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3150214\n" +"help.text" +msgid "Number Format: Currency" +msgstr "" + +#. VmqXg +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_idN10843\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format : Date</link>" +msgstr "" + +#. czUYu +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_idN10847\n" +"help.text" +msgid "Applies the default date format to the selected cells." +msgstr "" + +#. LLviv +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id951674565406059\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformatdate.svg\" id=\"img_id291674565406060\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id871674565406062\">Icon Number Format : Date</alt></image>" +msgstr "" + +#. GBmzD +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id691674565406063\n" +"help.text" +msgid "Number Format : Date" +msgstr "" + +#. Gx3sL +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id531674560537020\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format: Time</link>" +msgstr "" + +#. Py7SH +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id301674560577097\n" +"help.text" +msgid "Applies the default time format to the selected cells." +msgstr "" + +#. o3DWb +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id491674565650531\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformattime.svg\" id=\"img_id461674565650532\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id231674565650533\">Icon Number Format: Time</alt></image>" +msgstr "" + +#. nABBs +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id431674565650535\n" +"help.text" +msgid "Number Format: Time" +msgstr "" + +#. BcDfm +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_idN1085E\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format: Scientific</link>" +msgstr "" + +#. cFKyR +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_idN10862\n" +"help.text" +msgid "Applies the default scientific format to the selected cells." +msgstr "" + +#. gCjsN +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id691674565759525\n" +"help.text" +msgid "<image src=\"cmd/lc_numberformatscientific.svg\" id=\"img_id411674565759526\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id351674565759527\">Icon Number Format: Scientific</alt></image>" +msgstr "" + +#. 47V9G +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id221674565759529\n" +"help.text" +msgid "Number Format: Scientific" +msgstr "" + +#. SFQkA +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id3149164\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format: Delete Decimal Place</link>" +msgstr "" + +#. qEctd +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3147264\n" +"help.text" +msgid "<ahelp hid=\".uno:NumberFormatDecDecimals\">Removes one decimal place from the numbers in the selected cells.</ahelp>" +msgstr "" + +#. LSFkZ +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3145173\n" +"help.text" +msgid "<image id=\"img_id3153192\" src=\"cmd/lc_numberformatdecdecimals.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153192\">Icon Delete Decimal Place</alt></image>" +msgstr "" + +#. DXLiU +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3154686\n" +"help.text" +msgid "Number Format: Delete Decimal Place" +msgstr "" + +#. u7FnL +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"hd_id3150275\n" +"help.text" +msgid "<link href=\"text/scalc/01/default_number_formats.xhp\">Number Format: Add Decimal Place</link>" +msgstr "" + +#. Nn4EB +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3150792\n" +"help.text" +msgid "<ahelp hid=\".uno:NumberFormatIncDecimals\">Adds one decimal place to the numbers in the selected cells.</ahelp>" +msgstr "" + +#. LUPUq +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3145787\n" +"help.text" +msgid "<image id=\"img_id3145271\" src=\"cmd/lc_numberformatincdecimals.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3145271\">Icon Add Decimal Place</alt></image>" +msgstr "" + +#. jXZSA +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3149262\n" +"help.text" +msgid "Number Format: Add Decimal Place" +msgstr "" + +#. ZS2DP +#: default_number_formats.xhp +msgctxt "" +"default_number_formats.xhp\n" +"par_id3154908\n" +"help.text" +msgid "<link href=\"text/shared/01/05020300.xhp\">Format - Cells - Numbers</link>." +msgstr "" + #. UiW5C #: ex_data_stat_func.xhp msgctxt "" @@ -56473,6 +56752,15 @@ msgctxt "" msgid "<item type=\"input\">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E3 = 13 and E5 = 5, the function returns mode of the first column = 10." msgstr "" +#. 2BiGE +#: func_aggregate.xhp +msgctxt "" +"func_aggregate.xhp\n" +"par_id651677017267822\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AGGREGATE\">AGGREGATE wiki page</link>." +msgstr "" + #. cjxCG #: func_aggregate.xhp msgctxt "" @@ -56581,6 +56869,15 @@ msgctxt "" msgid "<input>=ARABIC(\"\")</input> returns 0." msgstr "" +#. RiAmq +#: func_arabic.xhp +msgctxt "" +"func_arabic.xhp\n" +"par_id721677017247207\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ARABIC\">ARABIC wiki page</link>." +msgstr "" + #. yugTC #: func_asc.xhp msgctxt "" @@ -56671,6 +56968,15 @@ msgctxt "" msgid "<input>=ASC(\"ライト\")</input> returns the string \"ﾗｲﾄ\", which is composed of single-byte characters." msgstr "" +#. tRpRD +#: func_asc.xhp +msgctxt "" +"func_asc.xhp\n" +"par_id931677017229646\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASC\">ASC wiki page</link>." +msgstr "" + #. y9q7t #: func_averageif.xhp msgctxt "" @@ -56995,6 +57301,15 @@ msgctxt "" msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." msgstr "" +#. ExJ9o +#: func_averageif.xhp +msgctxt "" +"func_averageif.xhp\n" +"par_id421677017213184\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">AVERAGEIF wiki page</link>." +msgstr "" + #. TUEKr #: func_averageifs.xhp msgctxt "" @@ -57175,6 +57490,15 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "" +#. doVAz +#: func_averageifs.xhp +msgctxt "" +"func_averageifs.xhp\n" +"par_id371677017196557\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS\">AVERAGEIFS wiki page</link>." +msgstr "" + #. s6GFW #: func_ceiling.xhp msgctxt "" @@ -57688,6 +58012,15 @@ msgctxt "" msgid "<input>=ISO.CEILING(-45.67; 2)</input> returns -44." msgstr "" +#. nBBCB +#: func_ceiling.xhp +msgctxt "" +"func_ceiling.xhp\n" +"par_id971677016806972\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING\">CEILING</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.XCL\">CEILING.XCL</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.PRECISE\">CEILING.PRECISE</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISO.CEILING\">ISO.CEILING</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.MATH\">CEILING.MATH</link> wiki pages." +msgstr "" + #. GuEcB #: func_color.xhp msgctxt "" @@ -57787,6 +58120,15 @@ msgctxt "" msgid "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255." msgstr "" +#. vRBbH +#: func_color.xhp +msgctxt "" +"func_color.xhp\n" +"par_id61677016779611\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/COLOR\">COLOR wiki page</link>." +msgstr "" + #. cfeEJ #: func_concat.xhp msgctxt "" @@ -57859,6 +58201,15 @@ msgctxt "" msgid "<input>=CONCAT(\"Hello \", A1:C3)</input> concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>." msgstr "" +#. EKvvy +#: func_concat.xhp +msgctxt "" +"func_concat.xhp\n" +"par_id701677016751508\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONCAT\">CONCAT wiki page</link>." +msgstr "" + #. D6Gew #: func_concat.xhp msgctxt "" @@ -59839,6 +60190,15 @@ msgctxt "" msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." msgstr "" +#. UXGKC +#: func_countifs.xhp +msgctxt "" +"func_countifs.xhp\n" +"par_id131677016670241\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS\">COUNTIFS wiki page</link>." +msgstr "" + #. GW3GV #: func_date.xhp msgctxt "" @@ -59938,6 +60298,15 @@ msgctxt "" msgid "<item type=\"input\">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY." msgstr "" +#. E6eJP +#: func_date.xhp +msgctxt "" +"func_date.xhp\n" +"par_id701677016652715\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE\">DATE wiki page</link>." +msgstr "" + #. pCLUK #: func_datedif.xhp msgctxt "" @@ -60154,6 +60523,15 @@ msgctxt "" msgid "<item type=\"input\">=DATEDIF(\"1974-04-17\";DATE(2012;06;13);\"yd\")</item> yields 57, his birthday was 57 days ago." msgstr "" +#. WrGbq +#: func_datedif.xhp +msgctxt "" +"func_datedif.xhp\n" +"par_id311677016639702\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEDIF\">DATEDIF wiki page</link>." +msgstr "" + #. 7eFQV #: func_datevalue.xhp msgctxt "" @@ -60235,6 +60613,15 @@ msgctxt "" msgid "<item type=\"input\">=DATEVALUE(\"1954-07-20\")</item> yields 19925." msgstr "" +#. Y9Fwm +#: func_datevalue.xhp +msgctxt "" +"func_datevalue.xhp\n" +"par_id331677016625664\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEVALUE\">DATEVALUE wiki page</link>." +msgstr "" + #. hrZuN #: func_day.xhp msgctxt "" @@ -60316,6 +60703,15 @@ msgctxt "" msgid "<item type=\"input\">=DAY(C4)</item> returns 5 if you enter 1901-08-05 in cell C4 (the date value might get formatted differently after you press Enter)." msgstr "" +#. VAvC5 +#: func_day.xhp +msgctxt "" +"func_day.xhp\n" +"par_id951677016613386\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAY\">DAY wiki page</link>." +msgstr "" + #. MsTm6 #: func_days.xhp msgctxt "" @@ -60388,6 +60784,15 @@ msgctxt "" msgid "<item type=\"input\">=DAYS(\"1990-10-10\";\"1980-10-10\")</item> returns 3652 days." msgstr "" +#. v53e8 +#: func_days.xhp +msgctxt "" +"func_days.xhp\n" +"par_id381677016601040\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYS\">DAYS wiki page</link>." +msgstr "" + #. 8vNn9 #: func_days360.xhp msgctxt "" @@ -60460,6 +60865,15 @@ msgctxt "" msgid "<item type=\"input\">=DAYS360(\"2000-01-01\";NOW())</item> returns the number of interest days from January 1, 2000 until today." msgstr "" +#. TEfFi +#: func_days360.xhp +msgctxt "" +"func_days360.xhp\n" +"par_id981677016583605\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DAYS360\">DAYS360 wiki page</link>." +msgstr "" + #. RpPVW #: func_eastersunday.xhp msgctxt "" @@ -60568,6 +60982,15 @@ msgctxt "" msgid "<item type=\"input\">=EASTERSUNDAY(2000)+49</item> returns the internal serial number 36688. The result is 2000-06-11. Format the serial date number as a date, for example in the format YYYY-MM-DD." msgstr "" +#. 2XGLn +#: func_eastersunday.xhp +msgctxt "" +"func_eastersunday.xhp\n" +"par_id331677016571572\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EASTERSUNDAY\">EASTERSUNDAY wiki page</link>." +msgstr "" + #. ZjahK #: func_edate.xhp msgctxt "" @@ -60649,6 +61072,15 @@ msgctxt "" msgid "<item type=\"input\">=EDATE(\"2001-03-31\";-1)</item> returns the serial number 36950. Formatted as a date, this is 2001-02-28." msgstr "" +#. DmuRa +#: func_edate.xhp +msgctxt "" +"func_edate.xhp\n" +"par_id621677016556933\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EDATE\">EDATE wiki page</link>." +msgstr "" + #. 4kAEM #: func_eomonth.xhp msgctxt "" @@ -60739,13 +61171,13 @@ msgctxt "" msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If you specify the date directly, we recommend using the standard ISO 8601 format because this should be independent of your selected locale settings." msgstr "" -#. Lu8Ng +#. YxPrs #: func_eomonth.xhp msgctxt "" "func_eomonth.xhp\n" -"par_id681621540307527\n" +"par_id791677012677088\n" "help.text" -msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH\">EOMONTH wiki page</link>" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH\">EOMONTH wiki page</link>." msgstr "" #. BNTm6 @@ -60991,6 +61423,15 @@ msgctxt "" msgid "If the ERROR.TYPE function is used as condition of the IF function and the ERROR.TYPE returns #N/A, the IF function returns #N/A as well. Use ISERROR to avoid it as shown in the example above." msgstr "" +#. Attho +#: func_error_type.xhp +msgctxt "" +"func_error_type.xhp\n" +"par_id201677013027422\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ERROR.TYPE\">ERROR.TYPE wiki page</link>." +msgstr "" + #. jKnF4 #: func_error_type.xhp msgctxt "" @@ -61090,6 +61531,15 @@ msgctxt "" msgid "<input>=FINDB(\"ａ\"; \"LibreOffice Ｃａｌｃ\")</input> returns 15. The <emph>Find Text</emph> argument is a text string that comprises a full-width, double-byte \"a\" character, while the <emph>Text</emph> argument comprises 12 single-byte characters followed by four full-width, double-byte characters." msgstr "" +#. E8koD +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id491677016507189\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FINDB\">FINDB wiki page</link>." +msgstr "" + #. aACGP #: func_floor.xhp msgctxt "" @@ -61513,6 +61963,15 @@ msgctxt "" msgid "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44." msgstr "" +#. LtNAq +#: func_floor.xhp +msgctxt "" +"func_floor.xhp\n" +"par_id911677016119101\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR\">FLOOR</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.MATH\">FLOOR.MATH</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.PRECISE\">FLOOR.PRECISE</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.XCL\">FLOOR.XCL</link> wiki pages." +msgstr "" + #. 2YcR7 #: func_forecastetsadd.xhp msgctxt "" @@ -61603,6 +62062,15 @@ msgctxt "" msgid "Returns 113.251442038722, the additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with period length of 4, no missing data, and SUM as aggregation." msgstr "" +#. LBqQW +#: func_forecastetsadd.xhp +msgctxt "" +"func_forecastetsadd.xhp\n" +"par_id691677016005343\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.ADD\">FORECAST.ETS.ADD wiki page</link>." +msgstr "" + #. 2CDcv #: func_forecastetsadd.xhp msgctxt "" @@ -61702,6 +62170,15 @@ msgctxt "" msgid "Returns 120.747806144882, the multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with period length of 4, no missing data, and SUM as aggregation." msgstr "" +#. Gokyv +#: func_forecastetsmult.xhp +msgctxt "" +"func_forecastetsmult.xhp\n" +"par_id501677015984498\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.MULT\">FORECAST.ETS.MULT wiki page</link>." +msgstr "" + #. CMedw #: func_forecastetsmult.xhp msgctxt "" @@ -61828,6 +62305,15 @@ msgctxt "" msgid "Returns 23.4416821953741, the prediction interval for additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation." msgstr "" +#. aFBmX +#: func_forecastetspiadd.xhp +msgctxt "" +"func_forecastetspiadd.xhp\n" +"par_id221677015965308\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.PI.ADD\">FORECAST.ETS.PI.ADD wiki page</link>." +msgstr "" + #. J3FRt #: func_forecastetspiadd.xhp msgctxt "" @@ -61954,6 +62440,15 @@ msgctxt "" msgid "Returns 27.5285874381574, the prediction interval for multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation." msgstr "" +#. tnhnW +#: func_forecastetspimult.xhp +msgctxt "" +"func_forecastetspimult.xhp\n" +"par_id401677015936466\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.PI.MULT\">FORECAST.ETS.PI.MULT wiki page</link>." +msgstr "" + #. LDRam #: func_forecastetspimult.xhp msgctxt "" @@ -62035,6 +62530,15 @@ msgctxt "" msgid "Returns 6, the number of samples in period based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, no missing data, and AVERAGE as aggregation." msgstr "" +#. yhLqx +#: func_forecastetsseason.xhp +msgctxt "" +"func_forecastetsseason.xhp\n" +"par_id101677015916462\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.SEASONALITY\">FORECAST.ETS.SEASONALITY wiki page</link>." +msgstr "" + #. EUN8o #: func_forecastetsseason.xhp msgctxt "" @@ -62134,6 +62638,15 @@ msgctxt "" msgid "Returns 0.0615234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with gamma smoothing, no missing data, and SUM as aggregation." msgstr "" +#. 3xVgX +#: func_forecastetsstatadd.xhp +msgctxt "" +"func_forecastetsstatadd.xhp\n" +"par_id471677015885195\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.STAT.ADD\">FORECAST.ETS.STAT.ADD wiki page</link>." +msgstr "" + #. dnDvk #: func_forecastetsstatadd.xhp msgctxt "" @@ -62233,6 +62746,15 @@ msgctxt "" msgid "Returns 15.8372533480997, the multiplicative statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with root mean squared error, no missing data, and SUM as aggregation." msgstr "" +#. EXXhD +#: func_forecastetsstatmult.xhp +msgctxt "" +"func_forecastetsstatmult.xhp\n" +"par_id31677015816211\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.STAT.MULT\">FORECAST.ETS.STAT.MULT wiki page</link>." +msgstr "" + #. LBeXF #: func_forecastetsstatmult.xhp msgctxt "" @@ -62332,6 +62854,15 @@ msgctxt "" msgid "<emph>MinimumMagnitude</emph>: used only if Polar=TRUE. All frequency components with magnitude less than <emph>MinimumMagnitude</emph> will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed. By default the value of <emph>MinimumMagnitude</emph> is 0.0, and no suppression is done by default." msgstr "" +#. PDupn +#: func_fourier.xhp +msgctxt "" +"func_fourier.xhp\n" +"par_id411677015788900\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FOURIER\">FOURIER wiki page</link>." +msgstr "" + #. P2z9v #: func_hour.xhp msgctxt "" @@ -62404,6 +62935,15 @@ msgctxt "" msgid "<item type=\"input\">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type=\"input\">17:20:00</item>." msgstr "<item type=\"input\">=HOUR(C4)</item> atgriež 17, ja saturs C4 = <item type=\"input\">17:20:00</item>." +#. SWD2F +#: func_hour.xhp +msgctxt "" +"func_hour.xhp\n" +"par_id851677015767824\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/HOUR\">HOUR wiki page</link>." +msgstr "" + #. DiCWs #: func_ifs.xhp msgctxt "" @@ -62557,6 +63097,15 @@ msgctxt "" msgid "If expression is neither TRUE or FALSE, a #VALUE error is returned." msgstr "" +#. kxdSM +#: func_ifs.xhp +msgctxt "" +"func_ifs.xhp\n" +"par_id971677015751595\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IFS\">IFS wiki page</link>." +msgstr "" + #. SzF9N #: func_ifs.xhp msgctxt "" @@ -62638,6 +63187,15 @@ msgctxt "" msgid "<item type=\"input\">=IMCOS(2)</item><br/>returns -0.416146836547142 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMCOS(2)</item><br/>atgriež -0.416146836547142 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. 6zE9Y +#: func_imcos.xhp +msgctxt "" +"func_imcos.xhp\n" +"par_id631677015732848\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOS\">IMCOS wiki page</link>." +msgstr "" + #. C3EAr #: func_imcosh.xhp msgctxt "" @@ -62719,6 +63277,15 @@ msgctxt "" msgid "<item type=\"input\">=IMCOSH(2)</item><br/>returns 3.76219569108363 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMCOSH(2)</item><br/>atgriež 3.76219569108363 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. N8Goo +#: func_imcosh.xhp +msgctxt "" +"func_imcosh.xhp\n" +"par_id331677015717191\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOSH\">IMCOSH wiki page</link>." +msgstr "" + #. 4bYUH #: func_imcot.xhp msgctxt "" @@ -62800,6 +63367,15 @@ msgctxt "" msgid "<item type=\"input\">=IMCOT(2)</item><br/>returns -0.457657554360286 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMCOT(2)</item><br/>atgriež -0.457657554360286 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. AZMcM +#: func_imcot.xhp +msgctxt "" +"func_imcot.xhp\n" +"par_id81677015703376\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCOT\">IMCOT wiki page</link>." +msgstr "" + #. tzbDs #: func_imcsc.xhp msgctxt "" @@ -62881,6 +63457,15 @@ msgctxt "" msgid "<item type=\"input\">=IMCSC(2)</item><br/>returns 1.09975017029462 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMCSC(2)</item><br/>atgriež 1.09975017029462 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. ZXuen +#: func_imcsc.xhp +msgctxt "" +"func_imcsc.xhp\n" +"par_id631677015682837\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCSC\">IMCSC wiki page</link>." +msgstr "" + #. uQfzu #: func_imcsch.xhp msgctxt "" @@ -62962,6 +63547,15 @@ msgctxt "" msgid "<item type=\"input\">=IMCSCH(2)</item><br/>returns 0.275720564771783 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMCSCH(2)</item><br/>atgriež 0.275720564771783 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. q3RAD +#: func_imcsch.xhp +msgctxt "" +"func_imcsch.xhp\n" +"par_id441677015667207\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMCSCH\">IMCSCH wiki page</link>." +msgstr "" + #. eiF7c #: func_imsec.xhp msgctxt "" @@ -63043,6 +63637,15 @@ msgctxt "" msgid "<item type=\"input\">=IMSEC(2)</item><br/>returns -2.40299796172238 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMSEC(2)</item><br/>atgriež -2.40299796172238 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. tFMiP +#: func_imsec.xhp +msgctxt "" +"func_imsec.xhp\n" +"par_id541677015629523\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSEC\">IMSEC wiki page</link>." +msgstr "" + #. 44osd #: func_imsech.xhp msgctxt "" @@ -63124,6 +63727,15 @@ msgctxt "" msgid "<item type=\"input\">=IMSECH(2)</item><br/>returns 0.26580222883408 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMSECH(2)</item><br/>atgriež 0.26580222883408 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. zy4tC +#: func_imsech.xhp +msgctxt "" +"func_imsech.xhp\n" +"par_id251677015610700\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSECH\">IMSECH wiki page</link>." +msgstr "" + #. TFFZg #: func_imsin.xhp msgctxt "" @@ -63205,6 +63817,15 @@ msgctxt "" msgid "<item type=\"input\">=IMSIN(2)</item><br/>returns 0.909297426825682 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMSIN(2)</item><br/>atgriež 0.909297426825682 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. 4Y55R +#: func_imsin.xhp +msgctxt "" +"func_imsin.xhp\n" +"par_id331677015597133\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSIN\">IMSIN wiki page</link>." +msgstr "" + #. Ht2Tp #: func_imsinh.xhp msgctxt "" @@ -63286,6 +63907,15 @@ msgctxt "" msgid "<item type=\"input\">=IMSINH(2)</item><br/>returns 3.62686040784702 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMSINH(2)</item><br/>atgriež 3.62686040784702 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. svBun +#: func_imsinh.xhp +msgctxt "" +"func_imsinh.xhp\n" +"par_id121677015577147\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMSINH\">IMSINH wiki page</link>." +msgstr "" + #. C2DmY #: func_imtan.xhp msgctxt "" @@ -63367,6 +63997,15 @@ msgctxt "" msgid "<item type=\"input\">=IMTAN(2)</item><br/>returns -2.18503986326152 as a string. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" msgstr "<item type=\"input\">=IMTAN(2)</item><br/>atgriež -2.18503986326152 kā virkni. <embedvar href=\"text/scalc/01/ful_func.xhp#func_imag_zero\"/>" +#. mqq7R +#: func_imtan.xhp +msgctxt "" +"func_imtan.xhp\n" +"par_id151677015537314\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/IMTAN\">IMTAN wiki page</link>." +msgstr "" + #. 8YaMz #: func_isoweeknum.xhp msgctxt "" @@ -63448,6 +64087,15 @@ msgctxt "" msgid "<item type=\"input\">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "" +#. QmAho +#: func_isoweeknum.xhp +msgctxt "" +"func_isoweeknum.xhp\n" +"par_id361677015520799\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOWEEKNUM\">ISOWEEKNUM wiki page</link>." +msgstr "" + #. CB8Vn #: func_jis.xhp msgctxt "" @@ -63538,6 +64186,15 @@ msgctxt "" msgid "<input>=JIS(\"ﾗｲﾄ\")</input> returns the string \"ライト\", which is composed of double-byte characters." msgstr "" +#. jqAPC +#: func_jis.xhp +msgctxt "" +"func_jis.xhp\n" +"par_id801677015502335\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">JIS wiki page</link>." +msgstr "" + #. Cauxq #: func_maxifs.xhp msgctxt "" @@ -63718,6 +64375,15 @@ msgctxt "" msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." msgstr "" +#. defwR +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id401677015482616\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS\">MAXIFS wiki page</link>." +msgstr "" + #. zGQnQ #: func_minifs.xhp msgctxt "" @@ -63898,6 +64564,15 @@ msgctxt "" msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." msgstr "" +#. zBVgq +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id941677015454359\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">MINIFS wiki page</link>." +msgstr "" + #. SAxB8 #: func_minute.xhp msgctxt "" @@ -63979,6 +64654,15 @@ msgctxt "" msgid "<item type=\"input\">=MINUTE(NOW())</item> returns the current minute value." msgstr "<item type=\"input\">=MINUTE(NOW())</item> atgriež pašreizējās minūtes vērtību." +#. FZ8uE +#: func_minute.xhp +msgctxt "" +"func_minute.xhp\n" +"par_id831677015434176\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINUTE\">MINUTE wiki page</link>." +msgstr "" + #. FmPSf #: func_month.xhp msgctxt "" @@ -64051,6 +64735,15 @@ msgctxt "" msgid "<item type=\"input\">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter)." msgstr "" +#. J9sqE +#: func_month.xhp +msgctxt "" +"func_month.xhp\n" +"par_id601677015418666\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MONTH\">MONTH wiki page</link>." +msgstr "" + #. kbyFK #: func_networkdays.intl.xhp msgctxt "" @@ -64177,6 +64870,15 @@ msgctxt "" msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days." msgstr "" +#. phSgD +#: func_networkdays.intl.xhp +msgctxt "" +"func_networkdays.intl.xhp\n" +"par_id421677015404173\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS.INTL\">NETWORKDAYS.INTL wiki page</link>." +msgstr "" + #. winzV #: func_networkdays.xhp msgctxt "" @@ -64294,6 +64996,15 @@ msgctxt "" msgid "<item type=\"input\">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays." msgstr "" +#. 95acN +#: func_networkdays.xhp +msgctxt "" +"func_networkdays.xhp\n" +"par_id151677015372427\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS\">NETWORKDAYS wiki page</link>." +msgstr "" + #. HCN8H #: func_now.xhp msgctxt "" @@ -64357,6 +65068,15 @@ msgctxt "" msgid "<item type=\"input\">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number." msgstr "" +#. eoaoB +#: func_now.xhp +msgctxt "" +"func_now.xhp\n" +"par_id481677015356908\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NOW\">NOW wiki page</link>." +msgstr "" + #. G3PMG #: func_numbervalue.xhp msgctxt "" @@ -64492,13 +65212,13 @@ msgctxt "" msgid "<input>=NUMBERVALUE(\"1#!234#!567\"; \".\"; \"#!\")</input> returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string." msgstr "" -#. xxgaf +#. nDXY8 #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" -"par_id451626100385699\n" +"par_id411677015337340\n" "help.text" -msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\">NUMBERVALUE</link> wiki page for more details about this function." +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\">NUMBERVALUE wiki page</link>." msgstr "" #. EJhfD @@ -64591,6 +65311,15 @@ msgctxt "" msgid "<input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;\"p\";\"o\";\"c\";\"e\")</input> returns the value 10.1585." msgstr "" +#. kNCjN +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id471677015317570\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_BARRIER\">OPT_BARRIER wiki page</link>." +msgstr "" + #. HWhRY #: func_opt_prob_hit.xhp msgctxt "" @@ -64690,6 +65419,15 @@ msgctxt "" msgid "<input>=OPT_PROB_HIT(70;0.3;0.1;0.5;60;0)</input> returns the value 0.4239." msgstr "" +#. HsEEF +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id461677015195417\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_PROB_HIT\">OPT_PROB_HIT wiki page</link>." +msgstr "" + #. RFprF #: func_opt_prob_inmoney.xhp msgctxt "" @@ -64807,6 +65545,15 @@ msgctxt "" msgid "<input>=OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;\"p\")</input> returns the value 0.3440." msgstr "" +#. oXMhE +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id181677015166578\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_PROB_INMONEY\">OPT_PROB_INMONEY wiki page</link>." +msgstr "" + #. muQEH #: func_opt_touch.xhp msgctxt "" @@ -65059,6 +65806,15 @@ msgctxt "" msgid "<input>=OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;\"f\";\"o\";\"c\";\"r\")</input> returns the value 15.5516." msgstr "" +#. a6EaS +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id501677015107961\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_TOUCH\">OPT_TOUCH wiki page</link>." +msgstr "" + #. ychjG #: func_opt_touch.xhp msgctxt "" @@ -65185,6 +65941,15 @@ msgctxt "" msgid "<input>=RAWSUBTRACT(0.987654321098765)</input> returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers." msgstr "" +#. En7sf +#: func_rawsubtract.xhp +msgctxt "" +"func_rawsubtract.xhp\n" +"par_id861677015066708\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/RAWSUBTRACT\">RAWSUBTRACT wiki page</link>." +msgstr "" + #. d9DP3 #: func_regex.xhp msgctxt "" @@ -65320,6 +66085,15 @@ msgctxt "" msgid "<item type=\"input\">=REGEX(\"axbxcxd\";\"(.)x\";\"$1y\";2)</item> returns \"axbycxd\", the second match of \"(.)x\" (i.e. \"bx\") replaced with the captured group of one character (i.e. \"b\") followed by \"y\"." msgstr "" +#. WFCu8 +#: func_regex.xhp +msgctxt "" +"func_regex.xhp\n" +"par_id631677014948784\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REGEX\">REGEX wiki page</link>." +msgstr "" + #. iLhWA #: func_regex.xhp msgctxt "" @@ -65428,13 +66202,13 @@ msgctxt "" msgid "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> returns \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ." msgstr "" -#. 4yxc9 +#. bM4dd #: func_replaceb.xhp msgctxt "" "func_replaceb.xhp\n" -"par_id721626381053212\n" +"par_id71677014897959\n" "help.text" -msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\">REPLACEB</link> wiki page for more details about this function." +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPLACEB\">REPLACEB wiki page</link>." msgstr "" #. FuCCt @@ -65563,6 +66337,15 @@ msgctxt "" msgid "<input>=ROMAN(0)</input> returns \"\" (empty text)." msgstr "" +#. 5UDBp +#: func_roman.xhp +msgctxt "" +"func_roman.xhp\n" +"par_id81677014876175\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROMAN\">ROMAN wiki page</link>." +msgstr "" + #. aU68a #: func_rounddown.xhp msgctxt "" @@ -65689,6 +66472,15 @@ msgctxt "" msgid "<input>=ROUNDDOWN(214.2,-1)</input> returns 210. Note the negative value for <emph>Count</emph>, which causes the first integer value before the decimal separator to be rounded towards zero." msgstr "" +#. q3A5j +#: func_rounddown.xhp +msgctxt "" +"func_rounddown.xhp\n" +"par_id161677014850199\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROUNDDOWN\">ROUNDDOWN wiki page</link>." +msgstr "" + #. E7heY #: func_roundsig.xhp msgctxt "" @@ -65797,6 +66589,15 @@ msgctxt "" msgid "<item type=\"input\">=ROUNDSIG(123456789; 4)</item> returns 123500000 or 123.5E6" msgstr "" +#. yiatB +#: func_roundsig.xhp +msgctxt "" +"func_roundsig.xhp\n" +"par_id181677014829126\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROUNDSIG\">ROUNDSIG wiki page</link>." +msgstr "" + #. XVftx #: func_roundsig.xhp msgctxt "" @@ -65887,6 +66688,15 @@ msgctxt "" msgid "<input>=SEARCHB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 20." msgstr "" +#. GGGLC +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id531677014781664\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SEARCHB\">SEARCHB wiki page</link>." +msgstr "" + #. Mv5R9 #: func_second.xhp msgctxt "" @@ -65959,6 +66769,15 @@ msgctxt "" msgid "<item type=\"input\">=SECOND(C4)</item> returns 17 if contents of C4 = <item type=\"input\">12:20:17</item>." msgstr "<item type=\"input\">=SECOND(C4)</item> atgriež 17, ja saturs C4 = <item type=\"input\">12:20:17</item>." +#. EphCW +#: func_second.xhp +msgctxt "" +"func_second.xhp\n" +"par_id71677014729834\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SECOND\">SECOND wiki page</link>." +msgstr "" + #. JBtM4 #: func_skewp.xhp msgctxt "" @@ -66031,6 +66850,15 @@ msgctxt "" msgid "<input>SKEWP(A1:A6)</input> returns 0.2329985562, when the range A1:A6 contains {2;3;1;6;8;5}" msgstr "" +#. Dfeiw +#: func_skewp.xhp +msgctxt "" +"func_skewp.xhp\n" +"par_id31677014685531\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SKEWP\">SKEWP wiki page</link>." +msgstr "" + #. 5iYyJ #: func_skewp.xhp msgctxt "" @@ -66040,6 +66868,195 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060185.xhp#skew\">SKEW</link>" msgstr "" +#. CPDEq +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"tit\n" +"help.text" +msgid "STYLE function" +msgstr "" + +#. rQpNt +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"bm_id346793467934121\n" +"help.text" +msgid "<bookmark_value>STYLE function</bookmark_value>" +msgstr "" + +#. 6AhEB +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"hd_id321673374992325\n" +"help.text" +msgid "<variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">STYLE</link></variable> function" +msgstr "" + +#. y45sr +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id441673375101757\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Applies a style to the cell containing the formula.</variable></ahelp> After a set amount of time, another style can be applied." +msgstr "" + +#. GswPt +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id681673375365338\n" +"help.text" +msgid "This function always returns the numeric value 0, which allows to use it by adding the <emph>STYLE</emph> function to other functions in the same cell without changing its value." +msgstr "" + +#. C6X4Q +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id961673376106137\n" +"help.text" +msgid "<input>STYLE(\"Style\" [; Time [; \"Style2\"]])</input>" +msgstr "" + +#. NkFMi +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id31673375542211\n" +"help.text" +msgid "<emph>Style</emph> is the name of the cell style to be applied to the cell. Style names are not case-sensitive and must be entered in quotation marks." +msgstr "" + +#. 8E46w +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id161673375589532\n" +"help.text" +msgid "<emph>Time</emph> is an optional time range in seconds. After this time is elapsed, the style defined in <emph>Style2</emph> is applied. Leave this parameter blank if you do not want the style to be changed." +msgstr "" + +#. aFQCT +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id81673375703156\n" +"help.text" +msgid "<emph>Style2</emph> is the optional name of a cell style assigned to the cell after the time specified in the <emph>Time</emph> parameter has passed. If this parameter is missing the \"Default\" cell style is applied." +msgstr "" + +#. ryUMD +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id971673376620554\n" +"help.text" +msgid "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" +msgstr "" + +#. U3hrJ +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id491673376748686\n" +"help.text" +msgid "<input>=10+STYLE(\"Good\",60,\"Neutral\")</input>" +msgstr "" + +#. 8deaD +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id11673376842469\n" +"help.text" +msgid "Enters the value 10 into the cell and applies the style named \"Good\". After 60 seconds, the style \"Neutral\" is applied." +msgstr "" + +#. UYv4h +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id271673376901358\n" +"help.text" +msgid "<input>=A1*A2+STYLE(IF(CURRENT()<100,\"Bad\",\"Good\"))</input>" +msgstr "" + +#. Zt8eb +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id1001673377339392\n" +"help.text" +msgid "Enters the result of multiplying the values in cells A1 and A2 and applies the style \"Bad\" if the result is less than 100, otherwise the style \"Good\" is applied. Here the function <emph>CURRENT()</emph> is used to get the currently evaluated value of the function in the cell." +msgstr "" + +#. nMoAR +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id761673377678426\n" +"help.text" +msgid "<input>=\"Total\"&T(STYLE(\"Result\"))</input>" +msgstr "" + +#. hBUAA +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id871673377683120\n" +"help.text" +msgid "Enters the text \"Total\" into the cell and applies the style named \"Result\". Note that this example deals with textual values, hence the output of the <emph>STYLE</emph> function needs to be appended to the text using the & operator. The function <emph>T()</emph> is used to prevent the number \"0\" being appended to the resulting text." +msgstr "" + +#. zzt3s +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id201677014634447\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE\">STYLE wiki page</link>." +msgstr "" + +#. rEQGK +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id631673379195650\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet Functions</link>" +msgstr "" + +#. VZ5Ga +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id151673379420755\n" +"help.text" +msgid "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigning Formats by Formula</link>" +msgstr "" + +#. YADMA +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id461673376361959\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">CURRENT function</link>" +msgstr "" + +#. L6tnb +#: func_style.xhp +msgctxt "" +"func_style.xhp\n" +"par_id381673378944042\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060110.xhp#t\">T function</link>" +msgstr "" + #. mEZBk #: func_sum.xhp msgctxt "" @@ -66121,13 +67138,13 @@ msgctxt "" msgid "A formula such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as an <link href=\"text/scalc/01/04060107.html#hd_id3148474\">array formula</link> by pressing the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum." msgstr "" -#. EYpTW +#. KohAT #: func_sum.xhp msgctxt "" "func_sum.xhp\n" -"par_id661636108218550\n" +"par_id771677014538669\n" "help.text" -msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM</link> wiki page for more details about this function." +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." msgstr "" #. DfceH @@ -66310,6 +67327,15 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "" +#. FEg3K +#: func_sumifs.xhp +msgctxt "" +"func_sumifs.xhp\n" +"par_id971677014512029\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIFS\">SUMIFS wiki page</link>." +msgstr "" + #. UUeQC #: func_switch.xhp msgctxt "" @@ -66418,6 +67444,15 @@ msgctxt "" msgid "<input>=SWITCH(MONTH(A3),1,\"January\",2,\"February\",3,\"March\",\"No match\")</input> returns \"January\" when A3 contains a date in January, \"February\" when A3 contains a date in February , etc..." msgstr "" +#. EErFd +#: func_switch.xhp +msgctxt "" +"func_switch.xhp\n" +"par_id171677014475983\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SWITCH\">SWITCH wiki page</link>." +msgstr "" + #. XELDQ #: func_switch.xhp msgctxt "" @@ -66553,6 +67588,15 @@ msgctxt "" msgid "if A1:B2 contains \"Here\", \"comes\", \"the\", \"sun\" respectively, <input>=TEXTJOIN(\"-\";1;A1:B2)</input> returns \"Here-comes-the-sun\" with dash character as delimiter and empty strings are ignored." msgstr "" +#. AcYv7 +#: func_textjoin.xhp +msgctxt "" +"func_textjoin.xhp\n" +"par_id761677014445916\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN\">TEXTJOIN wiki page</link>." +msgstr "" + #. CdeS7 #: func_textjoin.xhp msgctxt "" @@ -66652,6 +67696,15 @@ msgctxt "" msgid "<item type=\"input\">=TIME(4;20;4)</item> returns 04:20:04" msgstr "<item type=\"input\">=TIME(4;20;4)</item> atgriež 04:20:04" +#. BRwAF +#: func_time.xhp +msgctxt "" +"func_time.xhp\n" +"par_id741677014416564\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIME\">TIME wiki page</link>." +msgstr "" + #. eUYTq #: func_timevalue.xhp msgctxt "" @@ -66742,6 +67795,15 @@ msgctxt "" msgid "<item type=\"input\">=TIMEVALUE(\"24:00\")</item> returns 0. If you use the HH:MM:SS time format, the value is 00:00:00." msgstr "" +#. VGQyM +#: func_timevalue.xhp +msgctxt "" +"func_timevalue.xhp\n" +"par_id191677014389883\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIMEVALUE\">TIMEVALUE wiki page</link>." +msgstr "" + #. 8LaX7 #: func_today.xhp msgctxt "" @@ -66805,6 +67867,15 @@ msgctxt "" msgid "<item type=\"input\">TODAY()</item> returns the current computer system date." msgstr "" +#. sfbxe +#: func_today.xhp +msgctxt "" +"func_today.xhp\n" +"par_id691677014365707\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TODAY\">TODAY wiki page</link>." +msgstr "" + #. Y2uYG #: func_trunc.xhp msgctxt "" @@ -66931,6 +68002,15 @@ msgctxt "" msgid "<input>=TRUNC(214.2,-1)</input> returns 210. Note the negative value for <emph>Count</emph>, which causes the first integer value before the decimal separator to be rounded towards zero." msgstr "" +#. npECj +#: func_trunc.xhp +msgctxt "" +"func_trunc.xhp\n" +"par_id821677013765236\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC\">TRUNC wiki page</link>." +msgstr "" + #. w86Dm #: func_value.xhp msgctxt "" @@ -67057,6 +68137,15 @@ msgctxt "" msgid "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\">VALUE</link> wiki page for more details about this function." msgstr "" +#. mvFfg +#: func_value.xhp +msgctxt "" +"func_value.xhp\n" +"par_id711677013742963\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE\">VALUE wiki page</link>." +msgstr "" + #. dQeP6 #: func_webservice.xhp msgctxt "" @@ -67066,6 +68155,24 @@ msgctxt "" msgid "URI Functions" msgstr "" +#. xmV2h +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"hd_id391677019419915\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/func_webservice.xhp\">URI Functions</link></variable>" +msgstr "" + +#. 9vyBF +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id141677019419921\n" +"help.text" +msgid "These spreadsheet functions are used for inserting data from Universal Resource Identifiers (URI)." +msgstr "" + #. 8sQry #: func_webservice.xhp msgctxt "" @@ -67273,6 +68380,15 @@ msgctxt "" msgid "If cell B1 contains the text \"車\", <item type=\"input\">=ENCODEURL(B1)</item> returns %E8%BB%8A (\"車\" means car in Japanese)." msgstr "" +#. 5jJkd +#: func_webservice.xhp +msgctxt "" +"func_webservice.xhp\n" +"par_id781677019731175\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEBSERVICE\">WEBSERVICE</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FILTERXML\">FILTERXML</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ENCODEURL\">ENCODEURL</link> wiki pages." +msgstr "" + #. VBELn #: func_weekday.xhp msgctxt "" @@ -67516,6 +68632,15 @@ msgctxt "" msgid "To obtain a function indicating whether a day in A1 is a business day, use the IF and WEEKDAY functions as follows: <br/><item type=\"input\">IF(WEEKDAY(A1;2)<6;\"Business day\";\"Weekend\")</item>" msgstr "" +#. NbPmG +#: func_weekday.xhp +msgctxt "" +"func_weekday.xhp\n" +"par_id131677013566555\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKDAY\">WEEKDAY wiki page</link>." +msgstr "" + #. 3iMGJ #: func_weeknum.xhp msgctxt "" @@ -67813,6 +68938,15 @@ msgctxt "" msgid "<item type=\"input\">=WEEKNUM(DATE(1999;1;1);21)</item> returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "" +#. cknMt +#: func_weeknum.xhp +msgctxt "" +"func_weeknum.xhp\n" +"par_id361677013519430\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM\">WEEKNUM wiki page</link>." +msgstr "" + #. ZoCGw #: func_weeknum_ooo.xhp msgctxt "" @@ -67930,6 +69064,15 @@ msgctxt "" msgid "<item type=\"input\">=WEEKNUM_OOO(DATE(1995;1;1);2)</item> returns 52. Week 1 starts on Monday, 1995-01-02." msgstr "" +#. Eprih +#: func_weeknum_ooo.xhp +msgctxt "" +"func_weeknum_ooo.xhp\n" +"par_id521677013377460\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM_OOO\">WEEKNUM_OOO wiki page</link>." +msgstr "" + #. 9CdUK #: func_weeknumadd.xhp msgctxt "" @@ -68020,6 +69163,15 @@ msgctxt "" msgid "<item type=\"input\">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> returns 52." msgstr "<item type=\"input\">=WEEKNUM_EXCEL2003(DATE(2001;12;24);1)</item> atgriež 52." +#. AL2ar +#: func_weeknumadd.xhp +msgctxt "" +"func_weeknumadd.xhp\n" +"par_id801677013334251\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WEEKNUM_EXCEL2003\">WEEKNUM_EXCEL2003 wiki page</link>." +msgstr "" + #. ibEk3 #: func_workday.intl.xhp msgctxt "" @@ -68191,6 +69343,15 @@ msgctxt "" msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017." msgstr "" +#. 6F9Ck +#: func_workday.intl.xhp +msgctxt "" +"func_workday.intl.xhp\n" +"par_id521677013308530\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY.INTL\">WORKDAY.INTL wiki page</link>." +msgstr "" + #. 5dvmu #: func_workday.xhp msgctxt "" @@ -68290,6 +69451,15 @@ msgctxt "" msgid "<link href=\"text/scalc/01/04060102.xhp\">Date functions</link>" msgstr "" +#. yyzCK +#: func_workday.xhp +msgctxt "" +"func_workday.xhp\n" +"par_id501677013269388\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/WORKDAY\">WORKDAY wiki page</link>." +msgstr "" + #. dABAX #: func_year.xhp msgctxt "" @@ -68380,6 +69550,15 @@ msgctxt "" msgid "<input>=YEAR(DATEVALUE('2010-09-28'))</input> returns 2010." msgstr "" +#. 6QEEQ +#: func_year.xhp +msgctxt "" +"func_year.xhp\n" +"par_id371677013165080\n" +"help.text" +msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/YEAR\">YEAR wiki page</link>." +msgstr "" + #. kAjPe #: func_yearfrac.xhp msgctxt "" @@ -69235,13 +70414,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Select a solver engine. The listbox is disabled if only one solver engine is installed.</ahelp>" msgstr "" -#. NMHJR +#. LQubc #: solver_options.xhp msgctxt "" "solver_options.xhp\n" "par_id221589959855748\n" "help.text" -msgid "You can install more solver engines as extensions, if available. Open <menuitem>Tools - Extension Manager</menuitem> and browse to the Extensions web site to search for extensions." +msgid "You can install more solver engines as extensions, if available. Open <menuitem>Tools - Extensions</menuitem> and browse to the Extensions web site to search for extensions." msgstr "" #. QtDyE |