diff options
Diffstat (limited to 'source/nn/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/nn/helpcontent2/source/text/scalc/01.po | 326 |
1 files changed, 280 insertions, 46 deletions
diff --git a/source/nn/helpcontent2/source/text/scalc/01.po b/source/nn/helpcontent2/source/text/scalc/01.po index f8d0e61e40d..561ee5425ab 100644 --- a/source/nn/helpcontent2/source/text/scalc/01.po +++ b/source/nn/helpcontent2/source/text/scalc/01.po @@ -3,9 +3,9 @@ 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: 2019-11-08 20:19+0100\n" -"PO-Revision-Date: 2019-11-05 12:06+0000\n" -"Last-Translator: Kolbjørn Stuestøl <kolbjoern@stuestoel.no>\n" +"POT-Creation-Date: 2019-11-13 13:46+0100\n" +"PO-Revision-Date: 2019-11-13 12:52+0000\n" +"Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: Norwegian Nynorsk <https://vm137.documentfoundation.org/projects/libo_help-master/textscalc01/nn/>\n" "Language: nn\n" "MIME-Version: 1.0\n" @@ -14461,15 +14461,6 @@ msgctxt "" msgid "See COUNTIF() for some more syntax examples that can be used with SUMIF()." msgstr "Sjå TEL.VISS() for fleire syntaksar som kan verta brukte i SUMMER.VISS()." -#. Z8TrQ -#: 04060106.xhp -msgctxt "" -"04060106.xhp\n" -"hd_id72921259523046\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>" -msgstr "" - #. BHGzQ #: 04060106.xhp msgctxt "" @@ -19051,14 +19042,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." msgstr "<ahelp hid=\"HID_FUNC_SVERWEIS\">Loddrett søkjing med tilvising til tilstøytande celler til høgre.</ahelp> Denne funksjonen kontrollerer om ein bestemt verdi finst i den første kolonnen i eit område, namngitt som <item type=\"literal\">Indeks</item>. Dersom denne verdien finst, vert verdien frå den same linja i ei bestemt kolonne returnert. Viss parameteren <item type=\"literal\">Sorteringsrekkefølgje</item> manglar eller er sett til SANN, vert dataane sorterte i stigande rekkefølgje. Viss det eksakte <item type=\"literal\">søkjekriteriet</item> ikkje vart funne, vert den siste verdien som er mindre enn kriteriet returnert. Viss <item type=\"literal\">Sorteringsrekkefølgje</item> er sett til USANN eller null, må der vera eit eksakt samanfall, elles vert feilen <emph>Feil: Verdi ikkje tilgjengeleg</emph> returneret. Med ein verdi på null treng dataane ikkje vera sorterte stigande." -#. zQ7nD +#. qkLkD #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150156\n" "help.text" -msgid "=VLOOKUP(SearchCriterion; Array; Index; Sorted)" -msgstr "=FINN.RAD(Søkjekriteria; Matrise; Indeks; Sortert)" +msgid "=VLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgstr "" #. 7FsgG #: 04060109.xhp @@ -19087,14 +19078,14 @@ msgctxt "" msgid "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." msgstr "<emph>Indeks</emph> er kolonnenummeret i området som inneheld verdien som skal returnerast. Den første kolonnen har talet 1." -#. y3UFE +#. QV6iE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3151208\n" "help.text" -msgid "<emph>Sorted</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." -msgstr "<emph>Sortert</emph> er valfritt og indikerer om den første kolonnen i tabellen er sortert i aukande rekkjefølgje. Skriv inn den logiske verdien USANN eller null viss den første kolonnen ikkje er sortert aukande. Søk i sorterte kolonnar går mykje fortare og søkjet vil alltid returnere ein verdi, sjølv om søkjeverdien ikkje samsvarar nøyaktig eller er større enn den lågaste verdien i den sorterte lista. I usorterte lister må søkjeverdien samsvara nøyaktig, elles vil funksjonen returnere #I/T med meldinga <emph> Feil: verdien er ikkje tilgjengeleg </emph>." +msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." +msgstr "" #. fJQRf #: 04060109.xhp @@ -19762,14 +19753,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">Søkjer etter ein verdi og ein referanse til cellene nedanfor det merkte området.</ahelp> Stadfestar om den første rada i ei matrise inneheld ein viss verdi. Gjev verdien til ei rad i matrisa avgjort av <emph>Indeksen</emph> i same kolonne." -#. LjjvU +#. yxeCS #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3146070\n" "help.text" -msgid "HLOOKUP(SearchCriterion; Array; Index; Sorted)" -msgstr "FINN.KOLONNE(Søkjekriterium; Matrise; Indeks; Sortert)" +msgid "HLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgstr "" #. nhwwF #: 04060109.xhp @@ -21346,14 +21337,14 @@ msgctxt "" msgid "<bookmark_value>LEFTB function</bookmark_value>" msgstr "<bookmark_value>VENSTREB-funksjonen</bookmark_value>" -#. 43HxJ +#. zjvg5 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "hd_id2947083\n" "help.text" -msgid "LEFTB" -msgstr "VENSTREB (LEFTB på engelsk)" +msgid "<variable id=\"leftbvar\"><link href=\"text/scalc/01/04060110.xhp#leftb\" name=\"LEFTB\">LEFTB</link></variable>" +msgstr "" #. f3mWg #: 04060110.xhp @@ -21508,14 +21499,14 @@ msgctxt "" msgid "<bookmark_value>LENB function</bookmark_value>" msgstr "<bookmark_value>LENGDB-funksjonen</bookmark_value>" -#. tE3dg +#. e5FBE #: 04060110.xhp msgctxt "" "04060110.xhp\n" "hd_id2956110\n" "help.text" -msgid "LENB" -msgstr "LENGDB (LENB på engelsk)" +msgid "<variable id=\"lenbvar\"><link href=\"text/scalc/01/04060110.xhp#lenb\" name=\"LENB\">LENB</link></variable>" +msgstr "" #. Cwz9S #: 04060110.xhp @@ -21724,14 +21715,14 @@ msgctxt "" msgid "<bookmark_value>MIDB function</bookmark_value>" msgstr "<bookmark_value>MIDTB-funksjonen</bookmark_value>" -#. wekeb +#. BxEFF #: 04060110.xhp msgctxt "" "04060110.xhp\n" "hd_id2954589\n" "help.text" -msgid "MIDB" -msgstr "MIDTB" +msgid "<variable id=\"midbvar\"><link href=\"text/scalc/01/04060110.xhp#midb\" name=\"MIDB\">MIDB</link></variable>" +msgstr "" #. Qe8mw #: 04060110.xhp @@ -22165,14 +22156,14 @@ msgctxt "" msgid "<bookmark_value>RIGHTB function</bookmark_value>" msgstr "<bookmark_value>HØGREB-funksjonen</bookmark_value>" -#. qocbt +#. YMkyY #: 04060110.xhp msgctxt "" "04060110.xhp\n" "hd_id2949805\n" "help.text" -msgid "RIGHTB" -msgstr "HØGREB (RIGHTB på engelsk)" +msgid "<variable id=\"rightbvar\"><link href=\"text/scalc/01/04060110.xhp#rightb\" name=\"RIGHTB\">RIGHTB</link></variable>" +msgstr "" #. gvrHM #: 04060110.xhp @@ -23558,7 +23549,7 @@ msgctxt "" "par_id3150361\n" "help.text" msgid "$[officename] Calc can be expanded by Add-Ins, which are external programming modules providing additional functions for working with spreadsheets. These are listed in the <emph>Function Wizard</emph> in the <emph>Add-In</emph> category. If you would like to program an Add-In yourself, you can learn here which functions must be exported by the <switchinline select=\"sys\"><caseinline select=\"UNIX\">shared library</caseinline><defaultinline>external DLL</defaultinline></switchinline> so that the Add-In can be successfully attached." -msgstr "$[officename] Calc kan utvidast med Add-ins, som er eksterne programmeringsmodular med ekstra funksjonar for å arbeida med rekneark. Desse er oppførte i <emph>Funksjonsvegvisaren</emph> i kategorien <emph>Add-In</emph>. Viss du vil programmera eit tillegg sjølv, kan du læra her kva for funksjonar som må eksporterast av <switchinline select = \"sys\"> <caseinline select = \"UNIX\">delte bibliotek</caseinline> <defaultinline>ekstern DLL</defaultinline> </switchinline> slik at tillegget kan koplast til slik at det fungerer." +msgstr "$[officename] Calc kan utvidast med Add-ins, som er eksterne programmeringsmodular med ekstra funksjonar for å arbeida med rekneark. Desse er oppførte i <emph>Funksjonsvegvisaren</emph> i kategorien <emph>Add-In</emph>. Viss du vil programmera eit tillegg sjølv, kan du læra her kva for funksjonar som må eksporterast av <switchinline select=\"sys\"> <caseinline select=\"UNIX\">delte bibliotek</caseinline> <defaultinline>ekstern DLL</defaultinline> </switchinline> slik at tillegget kan koplast til slik at det fungerer." #. qyzrA #: 04060112.xhp @@ -33172,15 +33163,6 @@ msgctxt "" msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" msgstr "For berre å telja negative tal: <item type=\"input\">=TEL.VISS(A1:A10;\"<0\")</item>" -#. jGBjw -#: 04060181.xhp -msgctxt "" -"04060181.xhp\n" -"hd_id224412044220134\n" -"help.text" -msgid "<embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>" -msgstr "" - #. GWdLd #: 04060181.xhp msgctxt "" @@ -55780,14 +55762,14 @@ msgctxt "" msgid "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean." msgstr "<emph>Gjennomsnitt_område</emph> – valfritt. Det er eit område med verdiar som gjennomsnittet skal reknast ut for." -#. brAso +#. kCbPD #: func_averageif.xhp msgctxt "" "func_averageif.xhp\n" "par_id45123108916423\n" "help.text" -msgid "Note that if the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If the <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the mean calculation.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and an operation of a string concatenation (&)." -msgstr "Merk at dersom <emph>Gjennomsnitt_område</emph> ikkje er oppgjeve, vert <emph>Område</emph> brukt for begge, både utrekninga av gjennomsnitt og søket i høve til vilkåret. Dersom <emph>Gjennomsnitt_område</emph> er oppgjeve, vert <emph>Område</emph> brukt berre for vilkårstest medan gjennomsnittet vert rekna ut for <emph>Gjennomsnitt_område</emph>.<br/><emph>Kriterium</emph> må vere omslutta av sitatteikn (\"Kriterium\") unntatt når kriteriet er gjeve som eit namn på ein funksjon, ein cellereferanse eller er ei strengsamanslåing (med &)." +msgid "If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation." +msgstr "" #. 8v8Zv #: func_averageif.xhp @@ -57787,6 +57769,87 @@ msgctxt "" msgid "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error codes\">Error codes</link>" msgstr "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error codes\">Feilkoder</link>" +#. sUgSM +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"tit\n" +"help.text" +msgid "FINDB Function" +msgstr "" + +#. EkUr2 +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"bm_id141573508995071\n" +"help.text" +msgid "<bookmark_value>FINDB Function</bookmark_value> <bookmark_value>find text;FINDB Function</bookmark_value>" +msgstr "" + +#. WmZAa +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"hd_id771573508637966\n" +"help.text" +msgid "<variable id=\"findb\"><link href=\"text/scalc/01/func_findb.xhp\" name=\"findb\">FINDB</link></variable>" +msgstr "" + +#. iW2EE +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id831573508637970\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable>" +msgstr "" + +#. yA9fg +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id221573517641172\n" +"help.text" +msgid "FINDB( Find Text ; Text ; Position )" +msgstr "" + +#. puQAw +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id241573517292388\n" +"help.text" +msgid "<emph>Find Text</emph>: The text or text expression to be found." +msgstr "" + +#. YgyTW +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id991573517299918\n" +"help.text" +msgid "<emph>Text</emph>: the text in which the search is to be made." +msgstr "" + +#. pfYPq +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id521573517305077\n" +"help.text" +msgid "<emph>Position</emph>: The position in the text where the search starts." +msgstr "" + +#. VLM4H +#: func_findb.xhp +msgctxt "" +"func_findb.xhp\n" +"par_id481573517830373\n" +"help.text" +msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19." +msgstr "" + #. 2YcR7 #: func_forecastetsadd.xhp msgctxt "" @@ -60874,6 +60937,96 @@ msgctxt "" msgid "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regular expressions</link>" msgstr "<link href=\"http://userguide.icu-project.org/strings/regexp\" name=\"ICU REGEXP\">ICU regulære uttrykk</link>" +#. B64FM +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"tit\n" +"help.text" +msgid "REPLACEB Function" +msgstr "" + +#. GfVed +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"bm_id141573508995071\n" +"help.text" +msgid "<bookmark_value>REPLACEB Function</bookmark_value> <bookmark_value>replace text;REPLACEB Function</bookmark_value>" +msgstr "" + +#. 5MutE +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"hd_id771573508637966\n" +"help.text" +msgid "<variable id=\"replaceb\"><link href=\"text/scalc/01/func_replaceb.xhp\" name=\"replaceb\">REPLACEB</link></variable>" +msgstr "" + +#. djAL7 +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id831573508637970\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns text where an old text is replaced with a new text, using byte positions.</ahelp></variable>" +msgstr "" + +#. Fd4SC +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id701542231253817\n" +"help.text" +msgid "REPLACEB( Text ; Position ; Length ; NewText )" +msgstr "" + +#. eY5FG +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id331573510857418\n" +"help.text" +msgid "<emph>Text</emph>: A text expression or reference to a cell containing a text expression in which the characters are to be replaced." +msgstr "" + +#. bqPxd +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id431573510862075\n" +"help.text" +msgid "<emph>Position</emph>: the character position from which text is to be replaced." +msgstr "" + +#. TtgNA +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id481573510866260\n" +"help.text" +msgid "<emph>Length</emph>: the number of characters to be replaced." +msgstr "" + +#. UuACG +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id911573510871412\n" +"help.text" +msgid "<emph>NewText</emph>: the text to be inserted." +msgstr "" + +#. QH3SH +#: func_replaceb.xhp +msgctxt "" +"func_replaceb.xhp\n" +"par_id431573515742206\n" +"help.text" +msgid "<input>=REPLACEB(\"ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";4;1;\"ab\")</input> returns \"ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ\" ." +msgstr "" + #. E7heY #: func_roundsig.xhp msgctxt "" @@ -60991,6 +61144,87 @@ msgctxt "" msgid "See also <link href=\"text/scalc/01/04060106.xhp#Section21\" name=\"ROUND function\">ROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section7\" name=\"MROUND function\">MROUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section19\" name=\"ROUNDUP function\">ROUNDUP</link>, <link href=\"text/scalc/01/04060106.xhp#Section20\" name=\"ROUNDDOWN function\">ROUNDDOWN</link>." msgstr "Sjå også <link href=\"text/scalc/01/04060106.xhp#Section21\" name=\"ROUND function\">AVRUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section7\" name=\"MROUND function\">MRUND</link>, <link href=\"text/scalc/01/04060106.xhp#Section19\" name=\"ROUNDUP function\">AVRUND.OPP</link>, <link href=\"text/scalc/01/04060106.xhp#Section20\" name=\"ROUNDDOWN function\">AVRUND.NED</link>." +#. hkbrZ +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"tit\n" +"help.text" +msgid "SEARCHB Function" +msgstr "" + +#. ennrh +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"bm_id141573508995071\n" +"help.text" +msgid "<bookmark_value>SEARCHB Function</bookmark_value> <bookmark_value>search text;SEARCHB Function</bookmark_value>" +msgstr "" + +#. AXnND +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"hd_id771573508637966\n" +"help.text" +msgid "<variable id=\"searchb\"><link href=\"text/scalc/01/func_searchb.xhp\" name=\"searchb\">SEARCHB</link></variable>" +msgstr "" + +#. TySAy +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id831573508637970\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable>" +msgstr "" + +#. jADhb +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id531573516878780\n" +"help.text" +msgid "SEARCHB( Find text ; Text ; Position)" +msgstr "" + +#. 6Pmbf +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id241573517292388\n" +"help.text" +msgid "<emph>Find Text</emph>: The text or text expression to be found." +msgstr "" + +#. ovdFE +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id991573517299918\n" +"help.text" +msgid "<emph>Text</emph>: the text in which the search is to be made." +msgstr "" + +#. oDk8C +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id521573517305077\n" +"help.text" +msgid "<emph>Position</emph>: The position in the text where the search starts." +msgstr "" + +#. 2E7js +#: func_searchb.xhp +msgctxt "" +"func_searchb.xhp\n" +"par_id561573517310749\n" +"help.text" +msgid "<input>=SEARCHB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 20." +msgstr "" + #. Mv5R9 #: func_second.xhp msgctxt "" |