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=33
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=34", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=32", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>COLUMNS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>KOLONNE-funksjonen</bookmark_value>" ], "id_hash": 4594670014859081288, "content_hash": 4594670014859081288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154643\nhelp.text", "note": "cGRsQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942390/?format=api", "priority": 100, "id": 1721363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bfc38c08efd07648", "url": "https://translations.documentfoundation.org/api/units/1721363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.981965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "COLUMNS" ], "previous_source": "", "target": [ "KOLONNAR (COLUMNS på engelsk)" ], "id_hash": 4605148601445119632, "content_hash": 4605148601445119632, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154643\nhelp.text", "note": "VF3tg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942391/?format=api", "priority": 100, "id": 1721364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bfe8c640ff05f690", "url": "https://translations.documentfoundation.org/api/units/1721364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.996295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Returns the number of columns in the given reference.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Returnerer talet på kolonnar i den oppgjevne referansen.</ahelp>" ], "id_hash": -6672832419299237583, "content_hash": -6672832419299237583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151182\nhelp.text", "note": "eydFV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942392/?format=api", "priority": 100, "id": 1721365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=23655644d1f56131", "url": "https://translations.documentfoundation.org/api/units/1721365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.008920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "COLUMNS(Array)" ], "previous_source": "", "target": [ "KOLONNAR(Matrise)" ], "id_hash": 1178941322166737854, "content_hash": 1178941322166737854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154047\nhelp.text", "note": "DDKAg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942393/?format=api", "priority": 100, "id": 1721366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=905c70e2dec71bbe", "url": "https://translations.documentfoundation.org/api/units/1721366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.022743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Array</emph> is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell." ], "previous_source": "", "target": [ "<emph>Matrise</emph> er referansen til eit celleområde der det totale talet på kolonnar finst. Argumentet kan også vera ei enkelt celle." ], "id_hash": -4574496684817857887, "content_hash": -4574496684817857887, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154745\nhelp.text", "note": "YUPGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24942394/?format=api", "priority": 100, "id": 1721367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=40841f807b3ac2a1", "url": "https://translations.documentfoundation.org/api/units/1721367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.037074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column." ], "previous_source": "", "target": [ "<item type=\"input\">=KOLONNAR(B5)</item> returnerer 1 fordi ei celle inneheld berre ein enkelt kolonne." ], "id_hash": 6507744520544517154, "content_hash": 6507744520544517154, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149577\nhelp.text", "note": "dkd2t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942395/?format=api", "priority": 100, "id": 1721368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=da502729740cfc22", "url": "https://translations.documentfoundation.org/api/units/1721368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.048634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns." ], "previous_source": "", "target": [ "<item type=\"input\">=KOLONNER(A1:C5)</item> er lik 3. Referansen omfattar tre kolonnar." ], "id_hash": 3411673746354730818, "content_hash": 3411673746354730818, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145649\nhelp.text", "note": "AyKRA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24942396/?format=api", "priority": 100, "id": 1721369, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=af58b3324cfff742", "url": "https://translations.documentfoundation.org/api/units/1721369/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.060336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=KOLONNAR(Kanin)</item> Returnerer 2 viss <item type=\"literal\">Kanin</item> er det namngjevne området (C1:D3)." ], "id_hash": 8816812195949992683, "content_hash": 8816812195949992683, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155846\nhelp.text", "note": "F9UyA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942397/?format=api", "priority": 100, "id": 1721370, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=fa5b9bfa8eee5aeb", "url": "https://translations.documentfoundation.org/api/units/1721370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.071588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>vertical search function</bookmark_value> <bookmark_value>VLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>loddrett søkjefunksjon</bookmark_value><bookmark_value>FINN.RAD-funksjonen</bookmark_value>" ], "id_hash": -460514873228285841, "content_hash": -460514873228285841, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153152\nhelp.text", "note": "G5anB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24942398/?format=api", "priority": 100, "id": 1721371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=799bec29a771a86f", "url": "https://translations.documentfoundation.org/api/units/1721371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.087237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "VLOOKUP" ], "previous_source": "", "target": [ "FINN.RAD (VLOOKUP på engelsk)" ], "id_hash": 9082438316321787784, "content_hash": 9082438316321787784, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153152\nhelp.text", "note": "fZRnb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942399/?format=api", "priority": 100, "id": 1721372, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=fe0b4d8722c1cf88", "url": "https://translations.documentfoundation.org/api/units/1721372/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.102230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument." ], "previous_source": "", "target": [ "<emph>Matrise</emph> er referansen som skal innehalda minst så mange kolonnar som det er ført opp i Indeks-argumentet." ], "id_hash": 4049811973206833510, "content_hash": 4049811973206833510, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153884\nhelp.text", "note": "WFj5E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24942402/?format=api", "priority": 100, "id": 1721376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b833d288661df966", "url": "https://translations.documentfoundation.org/api/units/1721376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.168921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "<emph>Indeks</emph> er kolonnenummeret i området som inneheld verdien som skal returnerast. Den første kolonnen har talet 1." ], "id_hash": 4473339114076965019, "content_hash": 4473339114076965019, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156005\nhelp.text", "note": "tEMvM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942403/?format=api", "priority": 100, "id": 1721377, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=be147e39366b089b", "url": "https://translations.documentfoundation.org/api/units/1721377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.180555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type=\"input\">100</item>, E1 contains the name <item type=\"input\">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type=\"literal\">Sorted</item> parameter is not necessary." ], "previous_source": "", "target": [ "Du ønskjer å skriva inn nummeret på ein rett i cella A1 og at namnet på den valde retten skal visast i nabocella B1 med ein gong. Verdien til konverteringa frå nummer til namn finst i området D1:E100. D1 inneheld <item type=\"input\">100</item>, E1 inneheld namnet <item type=\"input\">Grønnsakssuppe</item> og så vidare opp til 100 menyoppføringar Tala i kolonne D er sorterte i stigande rekkjefølgje, difor er den valfrie parameteren <item type=\"literal\">Sortert</item> ikkje nødvendig." ], "id_hash": 5590887794157254537, "content_hash": 5590887794157254537, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154129\nhelp.text", "note": "fJQRf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/24942404/?format=api", "priority": 100, "id": 1721379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cd96d2d3b5cf7789", "url": "https://translations.documentfoundation.org/api/units/1721379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.218984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Enter the following formula in B1:" ], "previous_source": "", "target": [ "Skriv inn denne formelen i B1:" ], "id_hash": 3302636846429914310, "content_hash": 3302636846429914310, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145663\nhelp.text", "note": "2pTXc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942405/?format=api", "priority": 100, "id": 1721380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=add552b6b59244c6", "url": "https://translations.documentfoundation.org/api/units/1721380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.233344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=FINN.RAD(A1; D1:E100; 2)</item>" ], "id_hash": -3636120927334144249, "content_hash": -3636120927334144249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151172\nhelp.text", "note": "W7BCf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942406/?format=api", "priority": 100, "id": 1721381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4d89e74815e26707", "url": "https://translations.documentfoundation.org/api/units/1721381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.247892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "As soon as you enter a number in A1 B1 will show the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number displays the text with the next number down. To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered." ], "previous_source": "", "target": [ "Så snart du skriv inn eit tal i A1 vil B1 visa den teksten som ligg i den andre kolonnen i referansen D1:E100. Skriv du inn eit tal som ikkje finst, vil teksten tilsvarande det neste talet i rada verta vist. Dette kan du forhindra ved å skriva inn USANN som den siste parameteren i formelen. Det vil då verta vist ei feilmelding om ikkje-eksisterande tal vert skrivne inn." ], "id_hash": 259841606044098307, "content_hash": 259841606044098307, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149200\nhelp.text", "note": "oY9FV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/24942407/?format=api", "priority": 100, "id": 1721382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=839b249062201f03", "url": "https://translations.documentfoundation.org/api/units/1721382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.262011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>sheet numbers; looking up</bookmark_value> <bookmark_value>SHEET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>arknummer; slå opp</bookmark_value><bookmark_value>ARK-funksjonen</bookmark_value>" ], "id_hash": -2724982189634343269, "content_hash": -2724982189634343269, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153905\nhelp.text", "note": "BPHvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942408/?format=api", "priority": 100, "id": 1721383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5a2eeb22d7942e9b", "url": "https://translations.documentfoundation.org/api/units/1721383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.275950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "SHEET" ], "previous_source": "", "target": [ "ARK (SHEET på engelsk)" ], "id_hash": 8718762049278515776, "content_hash": 8718762049278515776, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153905\nhelp.text", "note": "tEpv8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942409/?format=api", "priority": 100, "id": 1721384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f8ff43e3cc671a40", "url": "https://translations.documentfoundation.org/api/units/1721384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.291801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string." ], "previous_source": "", "target": [ "<emph>Referanse</emph> er valfri og er referansen til ei celle, eit område eller eit arknamn." ], "id_hash": 4523632215762722536, "content_hash": 4523632215762722536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154588\nhelp.text", "note": "9yCD8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24942412/?format=api", "priority": 100, "id": 1721387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bec72b88730cdee8", "url": "https://translations.documentfoundation.org/api/units/1721387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.329148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>number of sheets; function</bookmark_value> <bookmark_value>SHEETS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>tal på ark; funksjon</bookmark_value><bookmark_value>TAL.PÅ.ARK-funksjonen</bookmark_value>" ], "id_hash": -8252590773715677554, "content_hash": -8252590773715677554, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148829\nhelp.text", "note": "7ZBfD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942414/?format=api", "priority": 100, "id": 1721389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=0d78e86a5802ce8e", "url": "https://translations.documentfoundation.org/api/units/1721389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.355192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "SHEETS" ], "previous_source": "", "target": [ "TAL.PÅ.ARK (SHEETS på engelsk)" ], "id_hash": -3688537779430513678, "content_hash": -3688537779430513678, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148829\nhelp.text", "note": "vGLG7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942415/?format=api", "priority": 100, "id": 1721390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4ccfae6eac6fa3f2", "url": "https://translations.documentfoundation.org/api/units/1721390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.370788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Finn arkmengda i ein referanse.</ahelp> Om du ikkje oppgjev nokon parametrar, gjev han arkmengda i dette dokumentet." ], "id_hash": -294850980343089500, "content_hash": -294850980343089500, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148820\nhelp.text", "note": "A5DpQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942416/?format=api", "priority": 100, "id": 1721391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7be87a9876f976a4", "url": "https://translations.documentfoundation.org/api/units/1721391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.384163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Reference</emph> is the reference to a sheet or an area. This parameter is optional." ], "previous_source": "", "target": [ "<emph>Referanse</emph> er referansen til eit ark eller eit område. Denne parameteren er valfri." ], "id_hash": 4590120515219508661, "content_hash": 4590120515219508661, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153060\nhelp.text", "note": "5B3KF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942418/?format=api", "priority": 100, "id": 1721393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bfb3624a01e44db5", "url": "https://translations.documentfoundation.org/api/units/1721393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.417246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated." ], "previous_source": "", "target": [ "<item type=\"input\">=TAL.PÅ.ARK(Ark1.A1:Ark3.G12)</item> returnerer 3 viss Ark1, Ark2 og Ark3 finst i den oppgjevne rekkjefølgja." ], "id_hash": 4255690796962648702, "content_hash": 4255690796962648702, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150507\nhelp.text", "note": "95EFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942419/?format=api", "priority": 100, "id": 1721394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bb0f403b72db927e", "url": "https://translations.documentfoundation.org/api/units/1721394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.430395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>MATCH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SAMANLIKNA-funksjonen</bookmark_value>" ], "id_hash": -1826328122546240505, "content_hash": -1826328122546240505, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158407\nhelp.text", "note": "JB3Ps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942420/?format=api", "priority": 100, "id": 1721395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=66a7943fb4534407", "url": "https://translations.documentfoundation.org/api/units/1721395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.441794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "MATCH" ], "previous_source": "", "target": [ "SAMANLIKNA (MATCH på engelsk)" ], "id_hash": 2535335821939796260, "content_hash": 2535335821939796260, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158407\nhelp.text", "note": "ExoT8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942421/?format=api", "priority": 100, "id": 1721396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a32f527f4d0b6924", "url": "https://translations.documentfoundation.org/api/units/1721396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.456692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returnerer den relative posisjonen til eit element i ein tabell, der elementet svarar til ein viss verdi.</ahelp> Gjev posisjonen til verdien funnen i søkjetabellen som eit tal." ], "id_hash": -2486715686627209743, "content_hash": -2486715686627209743, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154896\nhelp.text", "note": "GPfn3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24942422/?format=api", "priority": 100, "id": 1721397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5d7d694219318df1", "url": "https://translations.documentfoundation.org/api/units/1721397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.470639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>LookupArray</emph> is the reference searched. A lookup array can be a single row or column, or part of a single row or column." ], "previous_source": "", "target": [ "<emph>Søkjetabell</emph> er referansen som det skal søkjast i. Ein søkjetabell kan vera ei einskild rad eller ein einskild kolonne eller ein del av desse." ], "id_hash": -4473176383460664918, "content_hash": -4473176383460664918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159167\nhelp.text", "note": "9j4xw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24942425/?format=api", "priority": 100, "id": 1721400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=41ec15c7762919aa", "url": "https://translations.documentfoundation.org/api/units/1721400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.506969Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel." ], "previous_source": "", "target": [ "<emph>Type</emph> kan ha verdiane 1, 0 eller -1. Viss Type = 1 eller viss denne valfrie parameteren manglar, går ein ut frå at den første kolonnen i søkjeområdet er sortert i stigande rekkjefølgje. Med Type = -1 går ein ut frå at kolonnen er sortert i fallande rekkjefølgje. Dette svarar til slik det vert gjort i Microsoft Excel." ], "id_hash": 4627981797138480774, "content_hash": 4627981797138480774, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147239\nhelp.text", "note": "Z4dMn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/24942426/?format=api", "priority": 100, "id": 1721401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c039e4eca569be86", "url": "https://translations.documentfoundation.org/api/units/1721401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.517467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." ], "previous_source": "", "target": [ "Viss Type = 0, vil berre identiske resultat verta funne. Viss søkekriteriet finst fleire stadar, vil berre det første funnet verta returnert. Det er berre med Type = 0 at du kan leita etter regulære uttrykk (dersom slått på i innstillingane for utrekning) eller jokerteikn (dersom slått på i innstillingane for utrekning)." ], "id_hash": 6051458463366102660, "content_hash": 6051458463366102660, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154265\nhelp.text", "note": "8cpYu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942427/?format=api", "priority": 100, "id": 1721402, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d3fb196911f7be84", "url": "https://translations.documentfoundation.org/api/units/1721402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.527987Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=SAMANLIKNA(200;D1:D100)</item> søkjer i området D1:D100, som er sortert etter kolonne D, etter verdien 200. Så snart denne verdien er nådd, vert radnummeret der verdien vart funne returnert. Viss ein høgare verdi vart funnen i søket i kolonnen, vert radnummeret for den førre rada returnert." ], "id_hash": -8348883544228323497, "content_hash": -8348883544228323497, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155343\nhelp.text", "note": "eFMjk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/24942429/?format=api", "priority": 100, "id": 1721404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/1721404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.557330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>OFFSET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FORSKYVING-funksjonen</bookmark_value>" ], "id_hash": -3038312647783775519, "content_hash": -3038312647783775519, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158430\nhelp.text", "note": "JqPAK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942430/?format=api", "priority": 100, "id": 1721405, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/1721405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.570531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "OFFSET" ], "previous_source": "", "target": [ "FORSKYVING (OFFSET på engelsk)" ], "id_hash": 4884207378341721603, "content_hash": 4884207378341721603, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158430\nhelp.text", "note": "MwiPA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942431/?format=api", "priority": 100, "id": 1721406, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/1721406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.581763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returnerer verdien av ei celle som ligg eit visst tal på rader og kolonnar frå eit gjeve referansepunkt.</ahelp>" ], "id_hash": -7919841624111631330, "content_hash": -7919841624111631330, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149167\nhelp.text", "note": "tSGCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24942432/?format=api", "priority": 100, "id": 1721407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/1721407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.592894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Reference</emph> is the reference from which the function searches for the new reference." ], "previous_source": "", "target": [ "<emph>Referanse</emph> er cella som funksjonen leitar etter den nye referansen frå." ], "id_hash": -3109094795117095836, "content_hash": -3109094795117095836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152360\nhelp.text", "note": "3Q5gL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24942434/?format=api", "priority": 100, "id": 1721409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/1721409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.614818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row." ], "previous_source": "", "target": [ "<emph>Rader</emph> er talet på rader som referansen vart korrigert oppover (negativ verdi) eller nedover med. Bruk 0 for å verta verande i den same rada." ], "id_hash": -7759693311848095052, "content_hash": -7759693311848095052, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156032\nhelp.text", "note": "Q5SeM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24942435/?format=api", "priority": 100, "id": 1721410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/1721410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.624850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column" ], "previous_source": "", "target": [ "<emph>Kolonnar</emph> er talet på kolonnar som referansen vart korrigert til venstre (negativ verdi) eller til høgre. Bruk 0 for å bli i den same kolonnen." ], "id_hash": -2855369498407954685, "content_hash": -2855369498407954685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3166458\nhelp.text", "note": "CEqaQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942436/?format=api", "priority": 100, "id": 1721411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/1721411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.633542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Høgd</emph> (valfri) er den loddrette høgda på eit område som byrjar ved den nye referanseposisjonen." ], "id_hash": -6370777246515822578, "content_hash": -6370777246515822578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150708\nhelp.text", "note": "K2dos", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942437/?format=api", "priority": 100, "id": 1721412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/1721412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.643919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Breidd</emph> (valfri) er den vassrette breidda på eit område som byrjar ved den nye referanseposisjonen." ], "id_hash": 6677511436333980503, "content_hash": 6677511436333980503, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147278\nhelp.text", "note": "NEDfS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942438/?format=api", "priority": 100, "id": 1721413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/1721413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.653377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column." ], "previous_source": "", "target": [ "Argumenta <emph>Høgd</emph> og <emph>Breidd</emph> kan ikkje resultera i null eller negativ startrad eller startkolonne." ], "id_hash": 3258256735597929644, "content_hash": 3258256735597929644, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8662373\nhelp.text", "note": "uQEQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942439/?format=api", "priority": 100, "id": 1721414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/1721414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.662428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns." ], "previous_source": "", "target": [ "Argumenta <emph>Høgd</emph> og <emph>Breidd</emph> kan ikkje resultera i null eller negativt tal på rader eller kolonnar." ], "id_hash": 4191163419148031225, "content_hash": 4191163419148031225, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9051484\nhelp.text", "note": "cuFvq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942440/?format=api", "priority": 100, "id": 1721415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/1721415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.674184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100." ], "previous_source": "", "target": [ "<item type=\"input\">=FORSKYVING(A1; 2; 2)</item> returnerer verdien i celle C3 (A1 flytt to rader og to kolonnar nedover). Viss C3 inneheld verdien <item type=\"input\">100</item> returnerer denne funksjonen verdien 100." ], "id_hash": -2369817467347873031, "content_hash": -2369817467347873031, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149744\nhelp.text", "note": "cUGMh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24942441/?format=api", "priority": 100, "id": 1721416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/1721416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.684907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4)." ], "previous_source": "", "target": [ "<item type=\"input\">=FORSKYVING(B2:C3;1;1)</item> returnerer ein referanse til B2:C3 flytt 1 rad ned og 1 kolonne til høgre (C3:D4)." ], "id_hash": -742657699281128448, "content_hash": -742657699281128448, "location": "04060109.xhp", "context": "04060109.xhp\npar_id7439802\nhelp.text", "note": "pZtbS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942708/?format=api", "priority": 100, "id": 1721417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/1721417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.693732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2)." ], "previous_source": "", "target": [ "<item type=\"input\">=FORSKYVING(B2:C3;-1;-1)</item> returnerer ein referanse til B2:C3 flytt 1 rad opp og ein kolonne til venstre (A1:B2)." ], "id_hash": 3535053803764573335, "content_hash": 3535053803764573335, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3009430\nhelp.text", "note": "QQGzq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942709/?format=api", "priority": 100, "id": 1721418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/1721418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.702438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4)." ], "previous_source": "", "target": [ "<item type=\"input\">=FORSKYVING(B2:C3;0;0;3;4)</item> returnerer ein referanse til B2:C3 med storleiken endra til 3 rader og 4 kolonnar (B2:E4)." ], "id_hash": 5510456478988959992, "content_hash": 5510456478988959992, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2629169\nhelp.text", "note": "ZngJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942710/?format=api", "priority": 100, "id": 1721419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/1721419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.711434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5)." ], "previous_source": "", "target": [ "<item type=\"input\">=FORSKYVING(B2:C3;1;0;3;4)</item> returnerer ein referanse til B2:C3 flytt ei rad ned og med storleiken endra til 3 rader og 4 kolonnar (B3:E5)." ], "id_hash": 1923255265426347232, "content_hash": 1923255265426347232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6668599\nhelp.text", "note": "4XD3D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24942711/?format=api", "priority": 100, "id": 1721420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/1721420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.724155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMER(FORSKYVING(A1;2;2;5;6))</item> bestemmer summen av området som startar i celle C3 og har ei høgd på 5 rader og ei breidd på 6 kolonnar (område=C3:H7)." ], "id_hash": -7553978692711600114, "content_hash": -7553978692711600114, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153739\nhelp.text", "note": "jpz9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942712/?format=api", "priority": 100, "id": 1721421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/1721421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.737217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>LOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SLÅ.OPP-funksjonen</bookmark_value>" ], "id_hash": 7361603316006066001, "content_hash": 7361603316006066001, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3159273\nhelp.text", "note": "AFMxC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942714/?format=api", "priority": 100, "id": 1721423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/1721423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.763489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "SLÅ.OPP (LOOKUP på engelsk)" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942715/?format=api", "priority": 100, "id": 1721424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/1721424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.775888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "Viss SLÅ.OPP ikkje kan finna søkjekriteriet, vert den største verdien i søkjevektoren som er mindre enn eller lik søkjekriteriet bruk." ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942717/?format=api", "priority": 100, "id": 1721426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/1721426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.802943Z" } ] }{ "count": 8628, "next": "