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=95
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=96", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=94", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Reknar ut gjennomsnittet for verdiane i område C2:C6 som svarar til alle verdiane i område B2:B6 unntatt den største og minste verdien. Returnerer 127,5 fordi den tredje og fjerde rada ikkje oppfyller minst eitt av kriteria." ], "id_hash": 5272279988237403964, "content_hash": 5272279988237403964, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text", "note": "oghLv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950752/?format=api", "priority": 100, "id": 1726988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/1726988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.997162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=GJENNOMSNITT.VISS.SETT(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAKS(B2:B6))</item>" ], "id_hash": -39274590102270107, "content_hash": -39274590102270107, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id303162761931870\nhelp.text", "note": "C7fCW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950753/?format=api", "priority": 100, "id": 1726989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/1726989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.006892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Reknar ut gjennomsnittet for verdiane i område C2:C6 som svarar til alle verdiane i område A2:A6 som byrjar med «pen» og for alle cellene i området B2:B6 unntatt maksimum. Returnerer 65 fordi berre den andre rada oppfyller alle kriteria." ], "id_hash": 2035057651168597951, "content_hash": 2035057651168597951, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id40031348913642\nhelp.text", "note": "eo7jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950754/?format=api", "priority": 100, "id": 1726990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/1726990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.017586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referanse til ei celle som kriterium" ], "id_hash": -3065874459700111046, "content_hash": -3065874459700111046, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id31201205191857\nhelp.text", "note": "qyrrP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950755/?format=api", "priority": 100, "id": 1726991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/1726991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.028855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Dersom du ønskjer å lett kunna endra eit kriterium, kan du skrive dette inn i ei eige celle og bruke ein referanse til denne cella som kriterium i funksjonen GJENNOMSNITT.VISS.SETT. For eksempel kan funksjonen ovanfor skrivast slik:" ], "id_hash": -6864261810427536110, "content_hash": -6864261810427536110, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id316794795433\nhelp.text", "note": "DqjCH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950756/?format=api", "priority": 100, "id": 1726992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/1726992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.039198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=GJENNOMSNITT.VISS.SETT(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAKS(B2:B6))</item>" ], "id_hash": 7459219915114670295, "content_hash": 7459219915114670295, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id67531072426731\nhelp.text", "note": "B8bav", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950757/?format=api", "priority": 100, "id": 1726993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/1726993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.049134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Viss E2 = pen vil funksjonen returnera 65 fordi lenkja til cella er bytt ut med innhaldet." ], "id_hash": -7828342925869082649, "content_hash": -7828342925869082649, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id65612244926745\nhelp.text", "note": "E3TZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24950758/?format=api", "priority": 100, "id": 1726994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/1726994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.060279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "COLOR function" ], "previous_source": "", "target": [ "FARGE-funksjonen" ], "id_hash": -8037245958908344347, "content_hash": -8037245958908344347, "location": "func_color.xhp", "context": "func_color.xhp\ntit\nhelp.text", "note": "GuEcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950759/?format=api", "priority": 100, "id": 1726995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1075f7622ed307e5", "url": "https://translations.documentfoundation.org/api/units/1726995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.070726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>fargar;numeriske verdiar</bookmark_value> <bookmark_value>fargar;utrekning i rekneark</bookmark_value> <bookmark_value>FARGE-funksjonen</bookmark_value>" ], "id_hash": -3503870829010199345, "content_hash": -3503870829010199345, "location": "func_color.xhp", "context": "func_color.xhp\nbm_id1102201617201921\nhelp.text", "note": "N8CUu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950760/?format=api", "priority": 100, "id": 1726996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4f5fc00b99fe5ccf", "url": "https://translations.documentfoundation.org/api/units/1726996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.080087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">COLOR</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">FARGE</link></variable>" ], "id_hash": -8821725746593725306, "content_hash": -8821725746593725306, "location": "func_color.xhp", "context": "func_color.xhp\nhd_id456845684568\nhelp.text", "note": "qjPSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950761/?format=api", "priority": 100, "id": 1726997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=0592ef2c485d0486", "url": "https://translations.documentfoundation.org/api/units/1726997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.090168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." ], "previous_source": "", "target": [ "<ahelp hid=\".\">Returnerer ein talverdi som er rekna ut på grunnlag av dei tre fargane (raud, grøn og blå) og alfakanalen i RGBA-systemet.</ahelp> Resultatet er avhengig av kva fargesystem som er brukt i datamaskinen." ], "id_hash": -1203832068311828611, "content_hash": -1203832068311828611, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001848\nhelp.text", "note": "HXh5E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950762/?format=api", "priority": 100, "id": 1726998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6f4b211caf0cb77d", "url": "https://translations.documentfoundation.org/api/units/1726998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.099733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Red, Green and Blue</emph> – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component." ], "previous_source": "", "target": [ "<emph>Raud, Grøn og Blå</emph> – nødvendige argument. Verdien for raud-, grøn- og blåkomponenten i fargen. Verdien må vera mellom 0 og 255. Null betyr ingen fargekomponent og 255 betyr full fargekomponent." ], "id_hash": 224638577614200603, "content_hash": 224638577614200603, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304318587\nhelp.text", "note": "ASLWJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950764/?format=api", "priority": 100, "id": 1727000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=831e13989d8b1f1b", "url": "https://translations.documentfoundation.org/api/units/1727000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.120163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Alpha</emph> – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color." ], "previous_source": "", "target": [ "<emph>Alfa</emph> – valfritt argument. Verdien for alfakanalen eller samansett alfa. Alfa er eit heiltal mellom 0 og 255. Verdien 0 betyr full gjennomsikt og verdien 255 full dekkevne (ingen gjennomsikt)." ], "id_hash": 8574439046245092510, "content_hash": 8574439046245092510, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304315587\nhelp.text", "note": "GoCn2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24950765/?format=api", "priority": 100, "id": 1727001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f6fe86e21bad8c9e", "url": "https://translations.documentfoundation.org/api/units/1727001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.129792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">COLOR(255;255;255;1)</item> returns 33554431" ], "previous_source": "", "target": [ "<item type=\"input\">FARGE(255;255;255;1)</item> returnerer 33554431" ], "id_hash": -3533301182499384046, "content_hash": -3533301182499384046, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001888\nhelp.text", "note": "fb2sj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950766/?format=api", "priority": 100, "id": 1727002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4ef7314b74a81512", "url": "https://translations.documentfoundation.org/api/units/1727002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.143329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;0)</item> returns 255" ], "previous_source": "", "target": [ "<item type=\"input\">FARGE(0;0;255;0)</item> returnerer 255" ], "id_hash": 4921398467606995934, "content_hash": 4921398467606995934, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185378\nhelp.text", "note": "gxbF2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950767/?format=api", "priority": 100, "id": 1727003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c44c51d4e3dde3de", "url": "https://translations.documentfoundation.org/api/units/1727003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.155698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;255)</item> returns 4278190335" ], "previous_source": "", "target": [ "<item type=\"input\">FARGE(0;0;255;255)</item> returnerer 4278190335" ], "id_hash": 8589781915333483172, "content_hash": 8589781915333483172, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185326\nhelp.text", "note": "f8bh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950768/?format=api", "priority": 100, "id": 1727004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f73509243186daa4", "url": "https://translations.documentfoundation.org/api/units/1727004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.165898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255." ], "previous_source": "", "target": [ "<item type=\"input\">FARGE(0;0;400;0)</item> returnerer Feil:502 (ugyldig argument) fordi verdien av blå er større enn 255." ], "id_hash": -224256149759823711, "content_hash": -224256149759823711, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618188326\nhelp.text", "note": "JAYa2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24950769/?format=api", "priority": 100, "id": 1727005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7ce348384ede70a1", "url": "https://translations.documentfoundation.org/api/units/1727005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.178033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "CONCAT function" ], "previous_source": "", "target": [ "KJED.SAMAN-funksjonen" ], "id_hash": 8796333322820937330, "content_hash": 8796333322820937330, "location": "func_concat.xhp", "context": "func_concat.xhp\ntit\nhelp.text", "note": "cfeEJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950770/?format=api", "priority": 100, "id": 1727006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=fa12da8d58ac6672", "url": "https://translations.documentfoundation.org/api/units/1727006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.189291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>CONCAT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>KJED.SAMAN-funksjonen</bookmark_value>" ], "id_hash": 7991029942349640886, "content_hash": 7991029942349640886, "location": "func_concat.xhp", "context": "func_concat.xhp\nbm_id741556228031712\nhelp.text", "note": "WEfAD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950771/?format=api", "priority": 100, "id": 1727007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=eee5d764ef42b4b6", "url": "https://translations.documentfoundation.org/api/units/1727007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.200231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatenates one or more strings</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Kjedar saman ein eller fleire strengar</ahelp></variable>" ], "id_hash": -5610100621238531896, "content_hash": -5610100621238531896, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id891556226436781\nhelp.text", "note": "jUBjE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950773/?format=api", "priority": 100, "id": 1727009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3224eb3564e108c8", "url": "https://translations.documentfoundation.org/api/units/1727009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.227118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M." ], "previous_source": "", "target": [ "KJED.SAMAN er ei forbetring av KJEDA.SAMAN i og med at KJED.SAMAN også godtek område som argument, for eksempel B2:E5, K:K eller K:M." ], "id_hash": -7887419252229086841, "content_hash": -7887419252229086841, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id701556226865876\nhelp.text", "note": "JPUiF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24950774/?format=api", "priority": 100, "id": 1727010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=128a41fabc4ee187", "url": "https://translations.documentfoundation.org/api/units/1727010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.238774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." ], "previous_source": "", "target": [ "Når område vert brukt, vert cellene kjeda saman rad for rad frå øvst til nedst." ], "id_hash": -2290829766087122999, "content_hash": -2290829766087122999, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id461556226873963\nhelp.text", "note": "Gjz3x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24950775/?format=api", "priority": 100, "id": 1727011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=603556770f7c5fc9", "url": "https://translations.documentfoundation.org/api/units/1727011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.249446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>=CONCAT(\"Hello \", A1:C3)</input> concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>." ], "previous_source": "", "target": [ "<input>KJED.SAMAN(\"Hallo \",A1:C3)</input> kjedar saman strengen «Hallo » med alle strengane i området <literal>A1:C3</literal>." ], "id_hash": -5928279230692924343, "content_hash": -5928279230692924343, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id531556227248228\nhelp.text", "note": "aTwgH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950778/?format=api", "priority": 100, "id": 1727014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2dba8572f538e449", "url": "https://translations.documentfoundation.org/api/units/1727014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.280065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "COUNTIFS function" ], "previous_source": "", "target": [ "TEL.VISS.SETT-funksjonen" ], "id_hash": -6243986017061160968, "content_hash": -6243986017061160968, "location": "func_countifs.xhp", "context": "func_countifs.xhp\ntit\nhelp.text", "note": "JEUej", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6797, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950780/?format=api", "priority": 100, "id": 1727016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2958e7ccae9037f8", "url": "https://translations.documentfoundation.org/api/units/1727016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.300771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>TEL.VISS.SETT function</bookmark_value> <bookmark_value>telja rader;oppfylla kriteria</bookmark_value> <bookmark_value>telja kolonnar;oppfylla kriteria</bookmark_value>" ], "id_hash": 7428600837714162632, "content_hash": 7428600837714162632, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nbm_id452245224522\nhelp.text", "note": "Kprey", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6798, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24950781/?format=api", "priority": 100, "id": 1727017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e717b11a7e1f33c8", "url": "https://translations.documentfoundation.org/api/units/1727017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.310867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"countifs_des\">Returnerer kor mange celler som oppfyller kriteria i fleire område.</variable></ahelp>" ], "id_hash": -2781884893230868017, "content_hash": -2781884893230868017, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id462646264626\nhelp.text", "note": "pGTzr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6800, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950783/?format=api", "priority": 100, "id": 1727019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5964c26dbcf2d9cf", "url": "https://translations.documentfoundation.org/api/units/1727019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.338915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Enkel bruk" ], "id_hash": -659577220271956714, "content_hash": -659577220271956714, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id3861259759512\nhelp.text", "note": "ZuFZj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950787/?format=api", "priority": 100, "id": 1727023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=76d8b60343c01d16", "url": "https://translations.documentfoundation.org/api/units/1727023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.397635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(B2:B6;\">=20\")</item>" ], "id_hash": -4670497673572942546, "content_hash": -4670497673572942546, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id15856592423333\nhelp.text", "note": "uDqwg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950788/?format=api", "priority": 100, "id": 1727024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3f2f0f1c7a657d2e", "url": "https://translations.documentfoundation.org/api/units/1727024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.411602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion." ], "previous_source": "", "target": [ "Tel kor mange rader i området B2:B6 som har verdiar større enn eller lik 20. Returnerer 3 fordi den femte og sjette rada ikkje oppfyller kriteria." ], "id_hash": -7561950072014493005, "content_hash": -7561950072014493005, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id323511393121175\nhelp.text", "note": "JCUwJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950789/?format=api", "priority": 100, "id": 1727025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=170e8e7974562ab3", "url": "https://translations.documentfoundation.org/api/units/1727025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.425619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -2064120978503549065, "content_hash": -2064120978503549065, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id74301057922522\nhelp.text", "note": "4aGmq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950790/?format=api", "priority": 100, "id": 1727026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=635ac4e7fedd3f77", "url": "https://translations.documentfoundation.org/api/units/1727026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.435650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Tel kor mange rader i området C2:C6 som samtidig har verdiar større enn 70 og verdiar større enn eller lik 20 i området B2:B6. Returnerer 2 fordi den andre, femte og sjette rada ikkje oppfyller minst eitt kriterium." ], "id_hash": -4863093154484712128, "content_hash": -4863093154484712128, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109622995127628\nhelp.text", "note": "AyFxS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24950791/?format=api", "priority": 100, "id": 1727027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3c82d28ab14e0d40", "url": "https://translations.documentfoundation.org/api/units/1727027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.446095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Bruka regulære uttrykk og nøsta funksjonar" ], "id_hash": 7805936436593049902, "content_hash": 7805936436593049902, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id298462825526166\nhelp.text", "note": "AGcGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950792/?format=api", "priority": 100, "id": 1727028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ec5441d4da68412e", "url": "https://translations.documentfoundation.org/api/units/1727028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.457968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\"[:alpha:]*\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(B2:B6;\"[:alpha:]*\")</item>" ], "id_hash": 5738611906303249504, "content_hash": 5738611906303249504, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22736248573471\nhelp.text", "note": "iHFsx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950793/?format=api", "priority": 100, "id": 1727029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cfa3a51fd3084c60", "url": "https://translations.documentfoundation.org/api/units/1727029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.470021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion." ], "previous_source": "", "target": [ "Tel kor mange rader i området B2:B6 som inneheld alfabetsymbol. Returnerer 1 fordi berre den sjette rada oppfyller kriteriet." ], "id_hash": 4173716747243937198, "content_hash": 4173716747243937198, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22137303324873\nhelp.text", "note": "yiHkH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24950794/?format=api", "priority": 100, "id": 1727030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b9ec0544b092ddae", "url": "https://translations.documentfoundation.org/api/units/1727030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.480323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAKS(B2:B6))</item>" ], "id_hash": 2557626990426261548, "content_hash": 2557626990426261548, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id82271340221411\nhelp.text", "note": "pNABF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950795/?format=api", "priority": 100, "id": 1727031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a37e8432684f082c", "url": "https://translations.documentfoundation.org/api/units/1727031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.493816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Tel kor mange rader det er i området B2:B6. Reknar ikkje med rader som inneheld maksimums- og minimumsverdien i dette området. Returnerer 2 fordi den tredje, femte og sjette rada ikkje oppfyller minst eitt kriterium." ], "id_hash": -4856747075060767854, "content_hash": -4856747075060767854, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id1105320769334\nhelp.text", "note": "72QET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24950796/?format=api", "priority": 100, "id": 1727032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3c995e447315e392", "url": "https://translations.documentfoundation.org/api/units/1727032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.507008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(A2:A6;\"pen.*\";B2:B6;\"<\"&MAKS(B2:B6))</item>" ], "id_hash": -849600324358677609, "content_hash": -849600324358677609, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id267603146513224\nhelp.text", "note": "jdWB5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950797/?format=api", "priority": 100, "id": 1727033, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/1727033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.520336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria." ], "previous_source": "", "target": [ "Tel kor mange rader som samsvarar med alle cellene i området A2:A6 som byrjar med «pen» og alle cellene i området B2:B6 unntatt dei som inneheld minimum. Returnerer 1 fordi berre den andre rada oppfyller alle kriteria." ], "id_hash": -1581394730398256572, "content_hash": -1581394730398256572, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id111252614832220\nhelp.text", "note": "L6af2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24950798/?format=api", "priority": 100, "id": 1727034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/1727034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.533229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referanse til ei celle som kriterium" ], "id_hash": -8660103929084940670, "content_hash": -8660103929084940670, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id212582362610399\nhelp.text", "note": "rG36d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950799/?format=api", "priority": 100, "id": 1727035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/1727035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.547990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Dersom du ønskjer å lett kunna endra eit kriterium, kan du skrive dette inn i ei eige celle og bruke ein referanse til denne cella som kriterium i funksjonen TEL.VISS.SETT. For eksempel kan funksjonen ovanfor skrivast slik:" ], "id_hash": -3306896990901796710, "content_hash": -3306896990901796710, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id3245551524846\nhelp.text", "note": "ABwGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24950800/?format=api", "priority": 100, "id": 1727036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/1727036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.561604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=TEL.VISS.SETT(A2:A6;E2&\".*\";B2:B6;\"<\"&MAKS(B2:B6))</item>" ], "id_hash": 5460089609370278782, "content_hash": 5460089609370278782, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109501907712434\nhelp.text", "note": "3TTwe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950801/?format=api", "priority": 100, "id": 1727037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/1727037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.575505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." ], "previous_source": "", "target": [ "Viss E2 = pen vil funksjonen returnera 1 fordi lenkja til cella er bytt ut med innhaldet og såleis verkar som funksjonen ovanfor." ], "id_hash": 750788171635273601, "content_hash": 750788171635273601, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id738533068520\nhelp.text", "note": "CNQBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24950802/?format=api", "priority": 100, "id": 1727038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/1727038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.588417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "DATE" ], "previous_source": "", "target": [ "DATO (DATE på engelsk)" ], "id_hash": 2251092497364006255, "content_hash": 2251092497364006255, "location": "func_date.xhp", "context": "func_date.xhp\ntit\nhelp.text", "note": "GW3GV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950803/?format=api", "priority": 100, "id": 1727039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/1727039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.601600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DATE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DATO-funksjonen</bookmark_value>" ], "id_hash": -8529043966727092037, "content_hash": -8529043966727092037, "location": "func_date.xhp", "context": "func_date.xhp\nbm_id3155511\nhelp.text", "note": "xCZGR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950804/?format=api", "priority": 100, "id": 1727040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/1727040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.611670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATO</link></variable>" ], "id_hash": 1935387799744484713, "content_hash": 1935387799744484713, "location": "func_date.xhp", "context": "func_date.xhp\nhd_id3155511\nhelp.text", "note": "TioqL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950805/?format=api", "priority": 100, "id": 1727041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/1727041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.623862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATUM\">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATUM\">Denne funksjonen reknar ut ein dato skrive som år, månad, dag og viser resultatet slik cella er formatert.</ahelp> Standardformatet for ei celle som inneheld DATO-funksjonen er datoformatet, men du kan formatera cella med kva talformat som helst." ], "id_hash": -3191741950403674441, "content_hash": -3191741950403674441, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153551\nhelp.text", "note": "Wa2yU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950806/?format=api", "priority": 100, "id": 1727042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/1727042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.636716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "DATE(Year; Month; Day)" ], "previous_source": "", "target": [ "DATO(År; Månad; Dag)" ], "id_hash": -368305019053121377, "content_hash": -368305019053121377, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3150474\nhelp.text", "note": "wCGHA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950807/?format=api", "priority": 100, "id": 1727043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/1727043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.653607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99." ], "previous_source": "", "target": [ "<emph>År</emph> er eit heiltal mellom 1583 og 9957 eller mellom 0 og 99." ], "id_hash": -2694903448988203180, "content_hash": -2694903448988203180, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152815\nhelp.text", "note": "zExSG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950808/?format=api", "priority": 100, "id": 1727044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/1727044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.666653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "In <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx." ], "previous_source": "", "target": [ "I <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Innstillingar</item></caseinline><defaultinline><item type=\"menuitem\">Verktøy - Innstillingar</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - Generelt </item>kan du velja frå kva år eit tosifra tal skal verta oppfatta som 20xx." ], "id_hash": -4638706367466650632, "content_hash": -4638706367466650632, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153222\nhelp.text", "note": "WVjaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24950809/?format=api", "priority": 100, "id": 1727045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/1727045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.681392Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Month</emph> is an integer indicating the month." ], "previous_source": "", "target": [ "<emph>Månad</emph> er eit heiltal som viser månaden." ], "id_hash": 7683876209887228883, "content_hash": 7683876209887228883, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3155817\nhelp.text", "note": "uuZQH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950810/?format=api", "priority": 100, "id": 1727046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/1727046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.696476Z" } ] }