Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=34
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=33", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>Søkjevektor</emph> er eit område med 1 rad eller 1 kolonne som det skal søkjast i." ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942720/?format=api", "priority": 100, "id": 1721429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/1721429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.840361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>Resultatvektor</emph> er eit anna område med 1 rad eller 1 kolonne som resultatet vert henta frå. Resultatet er resultatvektorcella som har same indeks som funnet i søkjevektoren har." ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942721/?format=api", "priority": 100, "id": 1721430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/1721430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.855544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<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)." ], "previous_source": "", "target": [ "<item type=\"input\">=SLÅ.OPP(A1; D1:D100; F1:F100)</item> søkjer den tilsvarande cella i området D1:D100 for talet du skreiv inn i A1. Indeksen vert bestemt av førekomsten der, for eksempel den 12. cella i dette området. Innhaldet i den 12. cella vert då returnert som verdien av funksjonen (i resultatvektoren)." ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942722/?format=api", "priority": 100, "id": 1721431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/1721431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.866611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>VEL-funksjonen</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942734/?format=api", "priority": 100, "id": 1721443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/1721443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.013473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "VEL (CHOOSE på engelsk)" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942735/?format=api", "priority": 100, "id": 1721444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/1721444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.024165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Brukar eit register for å returnera ein verdi frå ei liste med opp til 30 verdiar.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942736/?format=api", "priority": 100, "id": 1721445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/1721445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.037404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "<item type=\"input\">=VEL(A1; B1; B2; B3; \"I dag\"; \"I går\"; \"I morgon\")</item> vil for eksempel returnera innhaldet av celle B2 for A1 = 2; for A1 = 4 vil funksjonen returnera teksten \"I dag\"." ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942740/?format=api", "priority": 100, "id": 1721449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/1721449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.080730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FINN.KOLONNE-funksjonen</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942741/?format=api", "priority": 100, "id": 1721450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/1721450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.093116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "FINN.KOLONNE (HLOOKUP på engelsk)" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942742/?format=api", "priority": 100, "id": 1721451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/1721451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.105526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "<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." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942743/?format=api", "priority": 100, "id": 1721452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/1721452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.116820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>RAD-funksjonen</bookmark_value>" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942744/?format=api", "priority": 100, "id": 1721455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/1721455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.173325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "RAD" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942745/?format=api", "priority": 100, "id": 1721456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/1721456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.190400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph>Referanse</emph> er ei celle, eit område eller namnet på eit område." ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942748/?format=api", "priority": 100, "id": 1721459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/1721459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.227668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Viss du ikkje gjev ein referanse, vert radnummeret for cella som formelen er skrive inn i brukt.<item type=\"productname\">%PRODUCTNAME</item> Calc set automatisk referansen til den gjeldande cella." ], "id_hash": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942749/?format=api", "priority": 100, "id": 1721460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/1721460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.237996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "<item type=\"input\">RAD(B3)</item> returnerer 3 fordi referansen viser til den tredje rada i tabellen." ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942750/?format=api", "priority": 100, "id": 1721461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/1721461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.253636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "<item type=\"input\">{=RAD(D5:D8)}</item> returnerer matrisa med enkeltkolonnen (5, 6, 7, 8) fordi den gjevne referansen inneheld radene 5 til 8." ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942751/?format=api", "priority": 100, "id": 1721462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/1721462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.265534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=RAD(D5:D8)</item> returnerer 5 fordi RAD-funksjonen ikkje er brukt som matriseformel og berre nummeret på den første rada i referansen vert returnert." ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942752/?format=api", "priority": 100, "id": 1721463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/1721463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.275366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "<item type=\"input\">{=RAD(A1:E1)}</item> og <item type=\"input\">=RAD(A1:E1)</item> returnerer begge 1 fordi referansen indeheld berre rad 1 som den første rada i tabellen. (Fordi område med enkeltrader berre har eitt radnummer, gjer det ingen skilnad om formelen er brukt som matriseformel eller ei)." ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24942753/?format=api", "priority": 100, "id": 1721464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/1721464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.285368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "<item type=\"input\">=RAD()</item> returnerer 3 viss formelen vart skriven inn i rad 3." ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942754/?format=api", "priority": 100, "id": 1721465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/1721465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.297092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=RAD(Kanin)}</item> returnerer matrisa med enkeltkolonnen (1, 2, 3) viss «Kanin» er det namngjevne området (C1:D3)." ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942755/?format=api", "priority": 100, "id": 1721466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/1721466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.308086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>RAD-funksjonen</bookmark_value>" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942756/?format=api", "priority": 100, "id": 1721467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/1721467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.320824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "RADER (ROWS på engelsk)" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942757/?format=api", "priority": 100, "id": 1721468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/1721468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.329124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returnerer talet på rader i ein referanse eller tabell.</ahelp>" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942758/?format=api", "priority": 100, "id": 1721469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/1721469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.342193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "RADER(Matrise)" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942759/?format=api", "priority": 100, "id": 1721470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/1721470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.355404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "<emph>Matrise</emph> er referansen eller det namngjevne området som det totale talet på rader skal fastsetjast for." ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942760/?format=api", "priority": 100, "id": 1721471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/1721471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.366609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "<item type=\"input\">=Rader(B5)</item> returnerer 1, fordi ei celle inneheld berre éi rad." ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942761/?format=api", "priority": 100, "id": 1721472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/1721472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.379730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "<item type=\"input\">=RADER(A10;B12)</item> returnerer 3." ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24942762/?format=api", "priority": 100, "id": 1721473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/1721473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.390867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=RADER(Kanin)</item> returnerer 3, viss «Kanin» er det namngjevne området (C1:D3)." ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942763/?format=api", "priority": 100, "id": 1721474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/1721474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.405454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>VERDITYPE-funksjonen</bookmark_value>" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942764/?format=api", "priority": 100, "id": 1721475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/1721475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.423025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "HYPERLENKJE (HYPERLINK på engelsk)" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942765/?format=api", "priority": 100, "id": 1721476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/1721476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.438751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">Når du trykkjer på ei celle som inneheld HYPERLENKJE-funksjonen, vert hyperlenkja opna.</ahelp>" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942766/?format=api", "priority": 100, "id": 1721477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/1721477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.453791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "For å opna ei hyperlenkja celle med tastaturet, marker cella, trykk «F2» for å gå i redigeringsmodus, flytt peikaren framføre hyperlenkja, trykk «Shift+F10» og vel så <emph>Opna hyperlenkje</emph>." ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942768/?format=api", "priority": 100, "id": 1721479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/1721479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.480038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "Talet 0 vert returnert for tomme celler og matriselement." ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942771/?format=api", "priority": 100, "id": 1721482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/1721482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.538613Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HENTPIVOTDATA-funksjon</bookmark_value>" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942778/?format=api", "priority": 100, "id": 1721490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/1721490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.659546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "HENTPIVOTDATA (GETPIVOTDATA på engelsk)" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942779/?format=api", "priority": 100, "id": 1721491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/1721491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.676571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Funksjonen HENTPIVOTDATA returnerer ein resultatverdi frå ein pivottabell. Verdien vert adressert ved hjelp av felt- og elementnamna slik at adresseringa framleis er gyldige sjølv om oppbyggjinga av pivottabellen vert endra.</ahelp>" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942780/?format=api", "priority": 100, "id": 1721492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/1721492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.693688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "To ulike syntaksdefinisjonar kan brukast:" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24942781/?format=api", "priority": 100, "id": 1721493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/1721493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.706780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "HENTPIVOTDATA(pivottabell;vilkår)" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24942783/?format=api", "priority": 100, "id": 1721495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/1721495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.733744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "Den andre syntaksen vert brukt viss nøyaktig to parameter er gjevne, der den første parameteren er ein referanse til ei celle eller eit celleområde. I alle andre tilfelle vert den første syntaksen brukt. Funksjonsvegvisaren viser det første syntaksen." ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942784/?format=api", "priority": 100, "id": 1721496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/1721496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.748873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." ], "previous_source": "", "target": [ "<emph>Målfelt</emph> er ein tekststreng som vel eit av datafelta i pivottabellen. Tekststrengen kan vera namnet på kjeldekolonnen eller namn på datafeltet som vert vist i tabellen (\"Summer → Sal\")." ], "id_hash": -7239259067986216298, "content_hash": -7239259067986216298, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9302346\nhelp.text", "note": "xTLTZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942785/?format=api", "priority": 100, "id": 1721497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/1721497/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.766516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used." ], "previous_source": "", "target": [ "<emph>pivottabell</emph> er ein referanse til ei celle eller eit celleområde som er plassert inne i ein pivottabell eller som indeheld ein pivottabell. Viss celleområdet inneheld fleire pivottabellar, vert den sist brukte pivottabellen brukt." ], "id_hash": 4132487332375574583, "content_hash": 4132487332375574583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8296151\nhelp.text", "note": "yNzcp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942786/?format=api", "priority": 100, "id": 1721498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/1721498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.781176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field." ], "previous_source": "", "target": [ "Viss det ikkje er oppgjeve noko <emph>Felt n / Element n</emph> par, vert totalen returnert. Elles utgjer kvart par vilkår som må oppfyllast. <emph>Felt n</emph> er namnet på eit felt frå pivottabellen. <emph>Element n</emph> er namnet på eit element frå dette feltet." ], "id_hash": -1497535495358537996, "content_hash": -1497535495358537996, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4809411\nhelp.text", "note": "bmrBF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24942787/?format=api", "priority": 100, "id": 1721499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/1721499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.797219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table." ], "previous_source": "", "target": [ "Viss pivottabellen inneheld ein einaste resultatverdi som oppfyller alle vilkåra, eller eit resultat for delsummar som summerer alle passande verdiar, vert det resultatet returnert. Viss det ikkje finst passande verdiar eller det finst fleire utan delsum, vert det returnert ei feilmelding. Desse vilkåra gjeld for resultat som er tekne med i pivottabellen." ], "id_hash": 2388784086717151413, "content_hash": 2388784086717151413, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6454969\nhelp.text", "note": "swvQC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/24942788/?format=api", "priority": 100, "id": 1721500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a126aa7875e1b8b5", "url": "https://translations.documentfoundation.org/api/units/1721500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.812302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive." ], "previous_source": "", "target": [ "Viss kjeldedata inneheld element som er gøymde som følgje av innstillingane for pivottabellen, vert desse ignorerte. Rekkjefølgja på felt og element er ikkje viktig. Namn på felt og element skil ikkje mellom store og små bokstavar." ], "id_hash": -7629710895233941748, "content_hash": -7629710895233941748, "location": "04060109.xhp", "context": "04060109.xhp\npar_id79042\nhelp.text", "note": "vjksc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24942789/?format=api", "priority": 100, "id": 1721501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=161dd25d5ea73f0c", "url": "https://translations.documentfoundation.org/api/units/1721501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.831142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." ], "previous_source": "", "target": [ "Verdiar frå delsummar frå pivottabellen vert berre brukte viss funksjonen «auto» er brukt. (Bortsett frå når dei vert nytta i vilkåret, sjå <item type=\"literal\">andre syntaks</item> nedanfor)." ], "id_hash": -1979321936287154257, "content_hash": -1979321936287154257, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3864253\nhelp.text", "note": "nARMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942791/?format=api", "priority": 100, "id": 1721503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6488092f93773faf", "url": "https://translations.documentfoundation.org/api/units/1721503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.849857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>pivot table</emph> has the same meaning as in the first syntax." ], "previous_source": "", "target": [ "<emph>pivottabell</emph> har den same meininga som ved første syntaks." ], "id_hash": -4232016537115714080, "content_hash": -4232016537115714080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9937131\nhelp.text", "note": "KETgR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942792/?format=api", "priority": 100, "id": 1721504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4544db61b5a39de0", "url": "https://translations.documentfoundation.org/api/units/1721504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.865798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell." ], "previous_source": "", "target": [ "<emph>Avgrensingar</emph> er ei mellomromsseparert liste. Heile strengen må vera innskriven mellom doble hermeteikn (\" \") viss du ikkje refererer til tekststrengen frå ei anna celle. Kvart element kan vera mellom enkle hermeteikn (' ')." ], "id_hash": 5115834849937829754, "content_hash": 5115834849937829754, "location": "04060109.xhp", "context": "04060109.xhp\npar_id5616626\nhelp.text", "note": "GUofE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942793/?format=api", "priority": 100, "id": 1721505, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c6ff18b0f01baf7a", "url": "https://translations.documentfoundation.org/api/units/1721505/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.881188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present." ], "previous_source": "", "target": [ "Ei av innskrivingane kan vera namnet på datafeltet. Namnet på datafeltet kan sløyfast berre viss pivottabellen inneheld berre eitt datafelt." ], "id_hash": 3603286722984903350, "content_hash": 3603286722984903350, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4076357\nhelp.text", "note": "xS3qo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24942794/?format=api", "priority": 100, "id": 1721506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b201722efb6582b6", "url": "https://translations.documentfoundation.org/api/units/1721506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.901121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Each of the other entries specifies a constraint in the form <item type=\"literal\">Field[Item]</item> (with literal characters [ and ]), or only <item type=\"literal\">Item</item> if the item name is unique within all fields that are used in the pivot table." ], "previous_source": "", "target": [ "Kvar av dei andre innskrivingane spesifiserer eit vilkår på forma <item type=\"literal\">Felt[Element]</item> (med teiknmaska [ og ]), eller berre <item type=\"literal\">Element</item> viss elementnamnet er brukt berre ein gong i alle felta som er brukte i pivottabellen." ], "id_hash": -4546692663667297643, "content_hash": -4546692663667297643, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8231757\nhelp.text", "note": "TFWzU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942795/?format=api", "priority": 100, "id": 1721507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=40e6e71c9f3c7295", "url": "https://translations.documentfoundation.org/api/units/1721507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.913535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "A function name can be added in the form <emph>Field[Item;Function]</emph>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, Count (Numbers only), StDev (Sample), StDevP (Population), Var (Sample), and VarP (Population), case-insensitive." ], "previous_source": "", "target": [ "Eit funksjonsnamn kan leggjast til på forma <emph>Felt[element;funksjon]</emph>, som gjer at kriteria berre passar på delsumverdiar som nyttar denne funksjonen. Moglege funksjonsnamn er Summer, Tall, Middel, Maks, Min, Produkt, Tal (berre tal), Stdav (utval), Stdavp (populasjon), Varians (utval) og Variansp (populasjon). Systemet skil ikkje mellom små og store bokstavar." ], "id_hash": -4629497150021799111, "content_hash": -4629497150021799111, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3168736\nhelp.text", "note": "Haoyc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942796/?format=api", "priority": 100, "id": 1721508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3fc0b8dec4447339", "url": "https://translations.documentfoundation.org/api/units/1721508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.923672Z" } ] }