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=172
{ "count": 8597, "next": null, "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=171", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Array</emph>: is the reference of the array to search. Array must be a 1-dimensional array and must be contained in one sheet only." ], "previous_source": "", "target": [ "<emph>Matrise</emph>: er referansen for matrisa det skal søkjast i. Matrisa må vera eindimensjonal og finnast i berre eitt ark." ], "id_hash": 9100318037846278188, "content_hash": 9100318037846278188, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id831708281625340\nhelp.text", "note": "hBE9s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/113242852/?format=api", "priority": 100, "id": 113245732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=fe4ad30a34e8402c", "url": "https://translations.documentfoundation.org/api/units/113245732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.630241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If <emph>Return</emph> is a range of cells, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "Viss <emph>Retur</emph> er eit celleområde, må funksjonen XSLÅ.OPP skrivast inn som ein <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">matriseformel</link>." ], "id_hash": 1756495506887826674, "content_hash": 1756495506887826674, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id821708357634624\nhelp.text", "note": "G4DLq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113242853/?format=api", "priority": 100, "id": 113245733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9860535b719e5cf2", "url": "https://translations.documentfoundation.org/api/units/113245733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.631733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>NotFound</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>NotFound</emph> is omitted, the function returns the #N/A error." ], "previous_source": "", "target": [ "<emph>IkkjeFunne</emph>: ein tekst eller eit celleinnhald som skal returnerast viss <emph>SlåOpp</emph>-verdien ikkje vert funnen. Viss det ikkje vert gjort funn og <emph>IkkjeFunne</emph> er sløyfa, vil funksjonen returner #I/T-feilen." ], "id_hash": 4634661613796873975, "content_hash": 4634661613796873975, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id271708281637035\nhelp.text", "note": "WTFGZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/113242854/?format=api", "priority": 100, "id": 113245734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c051a02ea88056f7", "url": "https://translations.documentfoundation.org/api/units/113245734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.632720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>MatchType</emph>: (optional) specifies the match type. Values can be:" ], "previous_source": "", "target": [ "<emph>Samsvartype</emph>: (valfri) spesifiserer typen samsvar. Verdiane kan vera:" ], "id_hash": 3573303267627442027, "content_hash": 3573303267627442027, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id121708281643207\nhelp.text", "note": "ruAWq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113242855/?format=api", "priority": 100, "id": 113245735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b196ec63c5ad1f6b", "url": "https://translations.documentfoundation.org/api/units/113245735/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.633711Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found and <emph>NotFound</emph> text is omitted, then return the #N/A error." ], "previous_source": "", "target": [ "<emph>0</emph>: nøyaktig samsvar (standard). Viss verdien i <emph>SlåOpp</emph> ikkje vert funne og teksten <emph>IkkjeFunne</emph> er sløyfa, vert #I/T-feilen returnert." ], "id_hash": -6941678793234180441, "content_hash": -6941678793234180441, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id111708281542144\nhelp.text", "note": "go9sN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242856/?format=api", "priority": 100, "id": 113245736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1faa33ea886a16a7", "url": "https://translations.documentfoundation.org/api/units/113245736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.634691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item." ], "previous_source": "", "target": [ "<emph>-1</emph>: prøv på nøyaktig samsvar. Viss verdien i <emph>SlåOpp</emph> ikkje vert funnen, vert det neste, mindre elementet returnert." ], "id_hash": 6198196224425968821, "content_hash": 6198196224425968821, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id851708281548335\nhelp.text", "note": "CtG9A", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113242857/?format=api", "priority": 100, "id": 113245737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d6046aa06d13c4b5", "url": "https://translations.documentfoundation.org/api/units/113245737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.635686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item." ], "previous_source": "", "target": [ "<emph>1</emph>: prøv på nøyaktig samsvar. Viss verdien i <emph>SlåOpp</emph> ikkje vert funnen, vert det neste, større elementet returnert." ], "id_hash": -7229667226694891101, "content_hash": -7229667226694891101, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id801708281553430\nhelp.text", "note": "CpEkK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113242858/?format=api", "priority": 100, "id": 113245738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1bab0ff6349149a3", "url": "https://translations.documentfoundation.org/api/units/113245738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.636657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>SearchMode</emph>: (optional) specifies the search mode to use." ], "previous_source": "", "target": [ "<emph>Søkjemodus</emph>: (valfri) spesifiserer kva søkjemodus som skal brukast." ], "id_hash": 6712869343943545981, "content_hash": 6712869343943545981, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id871708281607313\nhelp.text", "note": "EqTBc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/113242860/?format=api", "priority": 100, "id": 113245740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=dd28e71a1d5d547d", "url": "https://translations.documentfoundation.org/api/units/113245740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.638580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Array</emph> (default)." ], "previous_source": "", "target": [ "<emph>1</emph>: returnerer den første førekomsten frå det første elementet i <emph>Matrise</emph> (standard)." ], "id_hash": -3552595386197254087, "content_hash": -3552595386197254087, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id281708281579757\nhelp.text", "note": "FfKjN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/113242861/?format=api", "priority": 100, "id": 113245741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4eb2a55197056039", "url": "https://translations.documentfoundation.org/api/units/113245741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.639552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Array</emph>." ], "previous_source": "", "target": [ "<emph>-1</emph>: omvendt søk. Returnerer den første førekomsten frå det siste elementet i <emph>Matrise</emph>." ], "id_hash": -1815729443851563498, "content_hash": -1815729443851563498, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id251708281584285\nhelp.text", "note": "8CD3w", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113242862/?format=api", "priority": 100, "id": 113245742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=66cd3bb0e3028e16", "url": "https://translations.documentfoundation.org/api/units/113245742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.640546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>2</emph>: binary search that relies on <emph>Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned." ], "previous_source": "", "target": [ "<emph>2</emph>: binært søk som er avhengig av at <emph>Matrise</emph> er sortert i stigande rekkjefølgje. Viss ikkje sortert, vert det returnert ugyldige resultat." ], "id_hash": -9149569538617895845, "content_hash": -9149569538617895845, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id191708281589997\nhelp.text", "note": "6aABE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242863/?format=api", "priority": 100, "id": 113245743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=010632fb2af2145b", "url": "https://translations.documentfoundation.org/api/units/113245743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.641535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>-2</emph>: binary search that relies on <emph>Array</emph> being sorted in descending order. If not sorted, invalid results will be returned." ], "previous_source": "", "target": [ "<emph>-2</emph>: binært søk som er avhengig av at <emph>Matrise</emph> er sortert i synkande rekkjefølgje. Viss ikkje sortert, vert det returnert ugyldige resultat." ], "id_hash": -4087673280171864734, "content_hash": -4087673280171864734, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id561708281595885\nhelp.text", "note": "pwwij", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242864/?format=api", "priority": 100, "id": 113245744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4745aacf21800d62", "url": "https://translations.documentfoundation.org/api/units/113245744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.642510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>{=XLOOKUP(\"Atomic Number\";A2:A4;A2:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "<input>{=XSLÅ.OPP(\"Atomnummer\";A2:A4;A2:DO4)}</input> returnerer matrisa" ], "id_hash": -2496921173792390262, "content_hash": -2496921173792390262, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id141716739193733\nhelp.text", "note": "fHQrZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/113242865/?format=api", "priority": 100, "id": 113245745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5d59276bf3f4038a", "url": "https://translations.documentfoundation.org/api/units/113245745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.644794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>{=XLOOKUP(\"Helium\";B1:DO1;B1:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "<input>{=XSLÅ.OPP(\"Helium\";B1:DO1;B1:DO4)}</input> returnerer matrisa" ], "id_hash": 4446248683708869960, "content_hash": 4446248683708869960, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id231716739652495\nhelp.text", "note": "tkRq7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113242866/?format=api", "priority": 100, "id": 113245746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bdb43f9edf83ed48", "url": "https://translations.documentfoundation.org/api/units/113245746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.645842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "Helium" ], "id_hash": 5782600359580313982, "content_hash": 5782600359580313982, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id21716739329244\nhelp.text", "note": "D5tG5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7990, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242867/?format=api", "priority": 100, "id": 113245747, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d03fec63b6d4a97e", "url": "https://translations.documentfoundation.org/api/units/113245747/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.647043Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>{=XLOOKUP(\"Kryptonite\";B1:DO1;B1:DO4;\"Unknown element\")}</input> returns the array {\"Unknown element\",\"Unknown element\",\"Unknown element\",\"Unknown element\"}." ], "previous_source": "", "target": [ "<input>{=XSLÅ.OPP(\"Kryptonitt\";B1:DO1;B1:DO4;\"Ukjend element\")}</input> returnerer matrisa {\"Ukjend element\",\"Ukjend element\",\"Ukjend element\",\"Ukjend element\"}." ], "id_hash": -3961206654497531357, "content_hash": -3961206654497531357, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id671708356683379\nhelp.text", "note": "vaCSD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113242868/?format=api", "priority": 100, "id": 113245748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4906f788fcc2da23", "url": "https://translations.documentfoundation.org/api/units/113245748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.648007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Searches for a value in a one-dimensional array and returns the relative position of the item." ], "previous_source": "", "target": [ "Søkjer etter ein verdi i ei eindimensjonal matrise og returnerer den relative plasseringa av elementet." ], "id_hash": 4790560323384865954, "content_hash": 4790560323384865954, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id581708279355738\nhelp.text", "note": "8GYav", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113242869/?format=api", "priority": 100, "id": 113245749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c27b7d3b8e6f74a2", "url": "https://translations.documentfoundation.org/api/units/113245749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.650979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "XMATCH outperforms function <link href=\"text/scalc/01/04060109.xhp#Section12\">MATCH</link> as it allows searches according to the search mode." ], "previous_source": "", "target": [ "XSAMSVAR utkonkurer funksjonen <link href=\"text/scalc/01/04060109.xhp#Section12\">SAMSVAR</link> sidan han tillet søk ut frå søkjemodus." ], "id_hash": 20644941746071029, "content_hash": 20644941746071029, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id321716754048322\nhelp.text", "note": "qJsbC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113242870/?format=api", "priority": 100, "id": 113245750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=80495877132ee5f5", "url": "https://translations.documentfoundation.org/api/units/113245750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.652009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "XMATCH(Lookup; Array [; MatchType [; SearchMode ] ] )" ], "previous_source": "", "target": [ "XSAMSVAR(oppslag;matrise [; samsvartype[; søkjemodus]] )" ], "id_hash": 2569128359320830574, "content_hash": 2569128359320830574, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id211708281649651\nhelp.text", "note": "NFwz8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113242871/?format=api", "priority": 100, "id": 113245751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a3a760a187b3426e", "url": "https://translations.documentfoundation.org/api/units/113245751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.652984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>=XMATCH(\"Atomic Number\",A1:A4)</input> returns 3, the third line of the A1:A4 array." ], "previous_source": "", "target": [ "<input>=XSAMSVAR(\"Atomnummer\",A1:A4)</input> returnerer 3, den tredje linja i A1:A4-matrida." ], "id_hash": -8976317937889721527, "content_hash": -8976317937889721527, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id471716753503759\nhelp.text", "note": "WMXaP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/113242872/?format=api", "priority": 100, "id": 113245752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=036db664e11dc349", "url": "https://translations.documentfoundation.org/api/units/113245752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.654153Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>=XMATCH(\"Li\",A2:DO2)</input> returns 4, the fourth column of the A2:DO2 array." ], "previous_source": "", "target": [ "<input>=XSAMSVAR(\"Li\",A2:DO2)</input> returnerer 4, den fjerde kolonnen i A2:DO2-matrisa." ], "id_hash": 3448865499403957072, "content_hash": 3448865499403957072, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id581716753499133\nhelp.text", "note": "QTDzi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113242873/?format=api", "priority": 100, "id": 113245753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=afdcd4e61a12b350", "url": "https://translations.documentfoundation.org/api/units/113245753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:39:33.655115Z" }, { "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 specify it in a separate cell and use a reference to this cell in the condition of the SUMIF function. For example:" ], "previous_source": "", "target": [ "Dersom du treng å lett kunna endra eit kriterium, kan du skriva dette inn i ei eiga celle og bruka ein referanse til denne cella som kriterium i funksjonen SUMMER.VISS. For eksempel:" ], "id_hash": 6694771020294497606, "content_hash": 6694771020294497606, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id561711031254255\nhelp.text", "note": "BVQrr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7685, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/113252534/?format=api", "priority": 100, "id": 113252758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=dce89ac5c53ba546", "url": "https://translations.documentfoundation.org/api/units/113252758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-06T11:54:20.469632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">INDIRECT wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">INDIREKTE wiki page</link>." ], "id_hash": 5380036932438878388, "content_hash": 5380036932438878388, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751509\nhelp.text", "note": "MssCB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113259862/?format=api", "priority": 100, "id": 113260837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=caa9bb15dc8068b4", "url": "https://translations.documentfoundation.org/api/units/113260837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:48.449341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "LET function" ], "previous_source": "", "target": [ "LET-funksjonen" ], "id_hash": 1990380590024096603, "content_hash": 1990380590024096603, "location": "func_let.xhp", "context": "func_let.xhp\ntit\nhelp.text", "note": "ANivD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113259863/?format=api", "priority": 100, "id": 113260838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9b9f4099e437fb5b", "url": "https://translations.documentfoundation.org/api/units/113260838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.916336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>LET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>LET-funksjonen</bookmark_value>" ], "id_hash": -5619471719371825378, "content_hash": -5619471719371825378, "location": "func_let.xhp", "context": "func_let.xhp\nbm_id361708283183878\nhelp.text", "note": "mp4Fy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113259864/?format=api", "priority": 100, "id": 113260839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3203a03e957d1f1e", "url": "https://translations.documentfoundation.org/api/units/113260839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.917741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" ], "id_hash": 4761206583786135496, "content_hash": 4761206583786135496, "location": "func_let.xhp", "context": "func_let.xhp\nhd_id721717677746932\nhelp.text", "note": "cUrJc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/113259865/?format=api", "priority": 100, "id": 113260840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c213342978d2dfc8", "url": "https://translations.documentfoundation.org/api/units/113260840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.918736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function." ], "previous_source": "", "target": [ "Tilordnar namn til utrekningsresultat. Dette gjer det mogleg å lagra mellomliggjande utrekningar, verdiar eller definera namn i ein formel. Desse namna gjeld berre innføre ramma av LET-funksjonen." ], "id_hash": 2970498258313303213, "content_hash": 2970498258313303213, "location": "func_let.xhp", "context": "func_let.xhp\npar_id71717677746935\nhelp.text", "note": "NFFDr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/113259866/?format=api", "priority": 100, "id": 113260841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a939546d74ae54ad", "url": "https://translations.documentfoundation.org/api/units/113260841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.919704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])" ], "previous_source": "", "target": [ "LET(Namn1; Namneverdi1; Utrekning_eller_Namn2; [Namneverdi2; Utrekning_eller_Namn3 [; ...]])" ], "id_hash": 4556853629358978612, "content_hash": 4556853629358978612, "location": "func_let.xhp", "context": "func_let.xhp\npar_id211708281649651\nhelp.text", "note": "A9iKa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113259867/?format=api", "priority": 100, "id": 113260842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bf3d323b8f643634", "url": "https://translations.documentfoundation.org/api/units/113260842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.920704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Name1</emph>: the first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax." ], "previous_source": "", "target": [ "<emph>Namn1</emph>: det første namnet som skal tileignast. Må byrja med ein bokstav. Kan ikkje vera utverdien frå ein formel eller i konfikt med områdesyntaksen." ], "id_hash": -8602941962873102523, "content_hash": -8602941962873102523, "location": "func_let.xhp", "context": "func_let.xhp\npar_id301717681619674\nhelp.text", "note": "voGvK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/113259868/?format=api", "priority": 100, "id": 113260843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=089c35dd77a59f45", "url": "https://translations.documentfoundation.org/api/units/113260843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.921675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Name1 must follow the <link href=\"text/scalc/guide/value_with_name.xhp\">naming rules of %PRODUCTNAME Calc</link>." ], "previous_source": "", "target": [ "Namn1 må følgja <link href=\"text/scalc/guide/value_with_name.xhp\">namnereglane i %PRODUCTNAME Calc</link>." ], "id_hash": 6191346384833506896, "content_hash": 6191346384833506896, "location": "func_let.xhp", "context": "func_let.xhp\npar_id721717688901981\nhelp.text", "note": "CDP5D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113259869/?format=api", "priority": 100, "id": 113260844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d5ec14bbdd666e50", "url": "https://translations.documentfoundation.org/api/units/113260844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.922660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Name_value1</emph>: the value or calculation to assign to Name1." ], "previous_source": "", "target": [ "<emph>Namneverdi1</emph>: verdien eller utrekninga som skal tilordnast Namn1." ], "id_hash": 3574424279183359466, "content_hash": 3574424279183359466, "location": "func_let.xhp", "context": "func_let.xhp\npar_id951717681624139\nhelp.text", "note": "pXGwN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113259870/?format=api", "priority": 100, "id": 113260845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b19ae7f19d417dea", "url": "https://translations.documentfoundation.org/api/units/113260845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.923632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Name2; Name_value2;...</emph>: (optional) same as Name1 and Name_value1, respectively. Name_value2 must follow Name2 and so on." ], "previous_source": "", "target": [ "<emph>Namn2; Namneverdi2;…</emph>: (valfri) same som Namn1 og Namneverdi1. Namneverdi2 må koma etter Namn2 og så vidare." ], "id_hash": 7077235568600816289, "content_hash": 7077235568600816289, "location": "func_let.xhp", "context": "func_let.xhp\npar_id421717686226452\nhelp.text", "note": "RpF5L", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113259871/?format=api", "priority": 100, "id": 113260846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e2376440ba361aa1", "url": "https://translations.documentfoundation.org/api/units/113260846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.924589Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Calculation</emph>: a formula expression that uses all names within the LET function." ], "previous_source": "", "target": [ "<emph>Utrekning</emph>: eit formeluttrykk som brukar alle namna i LET-funksjonen." ], "id_hash": 8137769495232274667, "content_hash": 8137769495232274667, "location": "func_let.xhp", "context": "func_let.xhp\npar_id231717686233659\nhelp.text", "note": "ii4Cd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113259872/?format=api", "priority": 100, "id": 113260847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f0ef2a3d7b5460eb", "url": "https://translations.documentfoundation.org/api/units/113260847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.925596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Calculation</emph> must be the last argument in the LET function." ], "previous_source": "", "target": [ "<emph>Utrekning</emph> må vera det siste argumentet i LET-funksjonen." ], "id_hash": -5929069330371037692, "content_hash": -5929069330371037692, "location": "func_let.xhp", "context": "func_let.xhp\npar_id91717686350018\nhelp.text", "note": "AaFRL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113259873/?format=api", "priority": 100, "id": 113260848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2db7b6db8a923604", "url": "https://translations.documentfoundation.org/api/units/113260848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.928762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Calculate the molar mass of the water molecule knowing that the molecule has 2 hydrogen atoms and one oxygen atom." ], "previous_source": "", "target": [ "Reknar ut molarmassen for vassmolekylet ut frå kunnskapen om at molekylet har to hydrogenatom og eitt oksygenatom." ], "id_hash": -1959073628428631352, "content_hash": -1959073628428631352, "location": "func_let.xhp", "context": "func_let.xhp\npar_id121717701196975\nhelp.text", "note": "vGdpF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113259874/?format=api", "priority": 100, "id": 113260849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=64cff8ea20ad02c8", "url": "https://translations.documentfoundation.org/api/units/113260849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.929794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<input>=LET(mHydro; HLOOKUP(\"Hydrogen\"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP(\"Oxygen\"; $A$1:$DO$4; 4; 0); \"The molar mass of water is \"&(mOxy+2*mHydro)&\" g/mol\")</input> returns \"The molar mass of water is 18.015 g/mol\"." ], "previous_source": "", "target": [ "<input>=LET(mHydro; FINN.KOLONNE(\"Hydrogen\"; $A$1:$DO$4; 4; 0); mOxy; FINN.KOLONNE(\"Oksygen\"; $A$1:$DO$4; 4; 0); \"Molarmassen for vatn er \"&(mOxy+2*mHydro)&\" g/mol\")</input> returnerer «Molarmassen for vatn er 18,015 g/mol»." ], "id_hash": -6890932177909452756, "content_hash": -6890932177909452756, "location": "func_let.xhp", "context": "func_let.xhp\npar_id311717701158800\nhelp.text", "note": "s46BC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/113259875/?format=api", "priority": 100, "id": 113260850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=205e7db1a465f02c", "url": "https://translations.documentfoundation.org/api/units/113260850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.930782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wikiside (engelsk)</link>." ], "id_hash": -3954689845045384000, "content_hash": -3954689845045384000, "location": "func_let.xhp", "context": "func_let.xhp\npar_id701677016751508\nhelp.text", "note": "TGwea", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113259876/?format=api", "priority": 100, "id": 113260851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=491e1e89ed39acc0", "url": "https://translations.documentfoundation.org/api/units/113260851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:31:51.931773Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present." ], "previous_source": "", "target": [ "Kva som helst av dei valfrie innstillingane kan sløydast. Ei valfri innstillinga krev at alle dei føregåande skiljeteikna er til stades." ], "id_hash": 7163934109599625286, "content_hash": 7163934109599625286, "location": "common_func.xhp", "context": "common_func.xhp\npar_id431716730587722\nhelp.text", "note": "s37P8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113263597/?format=api", "priority": 100, "id": 113264247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e36b681dd4fd7046", "url": "https://translations.documentfoundation.org/api/units/113264247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.452535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The function is always <emph>case insensitive</emph>, independent from the setting of <emph>Case sensitive</emph> checkbox in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline> - <link href=\"text/shared/optionen/01060500.xhp\"><menuitem>%PRODUCTNAME Calc - Calculate</menuitem></link>. You can however, use the mode modifier <emph>(?-i)</emph> in <link href=\"text/shared/01/02100001.xhp\">regular expressions</link> to force search for a case-sensitive match." ], "previous_source": "", "target": [ "Funksjonen skil ikkje mellom <emph>små og store bokstavar</emph>, uavhengig av kva som er sett for <emph>Skil mellom store og små bokstavar</emph> i <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>% PRODUCTNAME → Innstillingar</menuitem></caseinline><defaultinline><menuitem>Verktøy → Innstillingar</menuitem></defaultinline></switchinline> → <link href=\"text/shared/optionen/01060500.xhp\"> <menuitem>%PRODUCTNAME Calc → Renk ut</menuitem></link>. Du kan imidlartid bruka modusmodifikatoren <emph>(?-i)</emph> i <link href=\"text/shared/01/02100001.xhp\">regulære uttrykk</link> for å tvinga fram søk som skil mellom store og små bokstavar." ], "id_hash": 8143334107426306829, "content_hash": 8143334107426306829, "location": "ful_func.xhp", "context": "ful_func.xhp\npar_id711715953325962\nhelp.text", "note": "GC9sp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/113263598/?format=api", "priority": 100, "id": 113264248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f102ef39b877bb0d", "url": "https://translations.documentfoundation.org/api/units/113264248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.483723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) or regular expressions for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets." ], "previous_source": "", "target": [ "Funksjonen XSLÅ.OPP er ein nyare og fleksibel erstatning for eldre funksjonar som <link href=\"text/scalc/01/04060109.xhp#Section9\">FINN.RAD</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">FINN.KOLONNE</link> og <link href=\"text/scalc/01/04060109.xhp#Section14\">SLÅ.OPP</link>. XSLÅ.OPP har støtte for omtrentleg og eksakt samsvar, jokerteikn (* ?) eller regulære uttrykk for delvise treff og oppslag i loddrette eller vassrette område. XSLÅ.OPP kan utføra eit omvendt søk og tilbyr eit raskt binært søkealternativ når du arbeidar med store datasett." ], "id_hash": -5816581931961691979, "content_hash": -5816581931961691979, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id631708282151776\nhelp.text", "note": "mekaB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/113263599/?format=api", "priority": 100, "id": 113264249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2f47598cea77d0b5", "url": "https://translations.documentfoundation.org/api/units/113264249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.655569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings, or a match using <link href=\"text/shared/01/02100001.xhp\">regular expressions</link>." ], "previous_source": "", "target": [ "<emph>2</emph>: eit <link href=\"text/scalc/guide/wildcards.xhp\">jokerteikn</link> samsvarar der teikna *, ? og ~ har spesielle tydningar, eller samsvar med <link href=\"text/shared/01/02100001.xhp\">regulære uttrykk</link>." ], "id_hash": 7742948860253220236, "content_hash": 7742948860253220236, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id881708281558005\nhelp.text", "note": "DEt3s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113263600/?format=api", "priority": 100, "id": 113264250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=eb747af6e968ad8c", "url": "https://translations.documentfoundation.org/api/units/113264250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.658121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>MatchType</emph> value 2 cannot be combined with binary search (<emph>SearchMode</emph> value <emph>2</emph> or <emph>-2</emph>)." ], "previous_source": "", "target": [ "<emph>Trefftype</emph> verdi 2 kan ikkje kombinerast med binært søk (<emph>Søkjemodus</emph> verdi <emph>2</emph> eller <emph>-2</emph>)." ], "id_hash": -6918799063031769504, "content_hash": -6918799063031769504, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id551718627629229\nhelp.text", "note": "jo6AY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113263601/?format=api", "priority": 100, "id": 113264251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1ffb7ce8d7af9660", "url": "https://translations.documentfoundation.org/api/units/113264251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.659659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>MatchType</emph>: (optional) specifies the match type. Values can be:" ], "previous_source": "", "target": [ "<emph>Trefftype</emph>: (valfri) spesifiserer samsvarstypen. Verdiar kan vera:" ], "id_hash": -4604727202788001869, "content_hash": -4604727202788001869, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id121708281643207\nhelp.text", "note": "yxFjM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113263602/?format=api", "priority": 100, "id": 113264252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=4018b901863e37b3", "url": "https://translations.documentfoundation.org/api/units/113264252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.669756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>0</emph>: exact match (default). If <emph>Lookup</emph> value is not found, then return the #N/A error." ], "previous_source": "", "target": [ "<emph>0</emph>: eksakt samsvar (standard). Viss <emph>Slåopp</emph>-verdien ikkje vert funne, vert feilen #I/T returnert." ], "id_hash": 4437159862272514847, "content_hash": 4437159862272514847, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id111708281542144\nhelp.text", "note": "jmwqp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113263603/?format=api", "priority": 100, "id": 113264253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bd93f562ba5fdb1f", "url": "https://translations.documentfoundation.org/api/units/113264253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.670751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>-1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next smaller item." ], "previous_source": "", "target": [ "<emph>-1</emph>: forsøk på eksakt samsvar. Viss <emph>Slåopp</emph>-verdien ikkje finnst, vert det neste, mindre elementet returnert." ], "id_hash": -1223053634279782436, "content_hash": -1223053634279782436, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id851708281548335\nhelp.text", "note": "9SMUK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113263604/?format=api", "priority": 100, "id": 113264254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6f06d7331b80c7dc", "url": "https://translations.documentfoundation.org/api/units/113264254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.671724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>1</emph>: attempt exact match. If <emph>Lookup</emph> value is not found, then return the next larger item." ], "previous_source": "", "target": [ "<emph>1</emph>: forsøk på eksakt samsvar. Viss <emph>Slåopp</emph>-verdien ikkje finnst, vert det neste, større elementet returnert." ], "id_hash": -7821622240499558148, "content_hash": -7821622240499558148, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id801708281553430\nhelp.text", "note": "hwonA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113263605/?format=api", "priority": 100, "id": 113264255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1374040353ba98fc", "url": "https://translations.documentfoundation.org/api/units/113264255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.672703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings, or a match using <link href=\"text/shared/01/02100001.xhp\">regular expressions</link>." ], "previous_source": "", "target": [ "<emph>2</emph>: eit <link href=\"text/scalc/guide/wildcards.xhp\">jokerteikn</link> samsvarar der teikna *, ? og ~ har spesielle tydningar eller samsvar med <link href=\"text/shared/01/02100001.xhp\">regulære uttrykk</link>." ], "id_hash": -2298453037209563759, "content_hash": -2298453037209563759, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id881708281558005\nhelp.text", "note": "y5cx9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113263606/?format=api", "priority": 100, "id": 113264256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=601a4123f034cd91", "url": "https://translations.documentfoundation.org/api/units/113264256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:59.673689Z" } ] }