Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=172
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=171", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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 (* ?) 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": [ "" ], "id_hash": -720639798116811220, "content_hash": -720639798116811220, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id631708282151776\nhelp.text", "note": "bywFk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/113242849/?format=api", "priority": 100, "id": 113243164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=75ffc5ebf63cfe2c", "url": "https://translations.documentfoundation.org/api/units/113243164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.610763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 1299854591831326768, "content_hash": 1299854591831326768, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id211708281649651\nhelp.text", "note": "TwFcc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113242850/?format=api", "priority": 100, "id": 113243165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=920a02dd45c44030", "url": "https://translations.documentfoundation.org/api/units/113243165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.611950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>Lookup</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1154619499237388382, "content_hash": -1154619499237388382, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id861708281340704\nhelp.text", "note": "WoJu6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/113242851/?format=api", "priority": 100, "id": 113243166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6ff9f7aed1374fa2", "url": "https://translations.documentfoundation.org/api/units/113243166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.612930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 9100318037846278188, "content_hash": 9100318037846278188, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id831708281625340\nhelp.text", "note": "hBE9s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=fe4ad30a34e8402c", "url": "https://translations.documentfoundation.org/api/units/113243167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.613925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 1756495506887826674, "content_hash": 1756495506887826674, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id821708357634624\nhelp.text", "note": "G4DLq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=9860535b719e5cf2", "url": "https://translations.documentfoundation.org/api/units/113243168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.615483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 4634661613796873975, "content_hash": 4634661613796873975, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id271708281637035\nhelp.text", "note": "WTFGZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c051a02ea88056f7", "url": "https://translations.documentfoundation.org/api/units/113243169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.616476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>MatchType</emph>: (optional) specifies the match type. Values can be:" ], "previous_source": "", "target": [ "" ], "id_hash": 3573303267627442027, "content_hash": 3573303267627442027, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id121708281643207\nhelp.text", "note": "ruAWq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b196ec63c5ad1f6b", "url": "https://translations.documentfoundation.org/api/units/113243170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.617495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -6941678793234180441, "content_hash": -6941678793234180441, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id111708281542144\nhelp.text", "note": "go9sN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=1faa33ea886a16a7", "url": "https://translations.documentfoundation.org/api/units/113243171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.618455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 6198196224425968821, "content_hash": 6198196224425968821, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id851708281548335\nhelp.text", "note": "CtG9A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d6046aa06d13c4b5", "url": "https://translations.documentfoundation.org/api/units/113243172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.619419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -7229667226694891101, "content_hash": -7229667226694891101, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id801708281553430\nhelp.text", "note": "CpEkK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=1bab0ff6349149a3", "url": "https://translations.documentfoundation.org/api/units/113243173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.620373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings." ], "previous_source": "", "target": [ "" ], "id_hash": 6413392855759495967, "content_hash": 6413392855759495967, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id881708281558005\nhelp.text", "note": "JJ3M2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113242859/?format=api", "priority": 100, "id": 113243174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d900f2d29c92a31f", "url": "https://translations.documentfoundation.org/api/units/113243174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.621601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>SearchMode</emph>: (optional) specifies the search mode to use." ], "previous_source": "", "target": [ "" ], "id_hash": 6712869343943545981, "content_hash": 6712869343943545981, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id871708281607313\nhelp.text", "note": "EqTBc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=dd28e71a1d5d547d", "url": "https://translations.documentfoundation.org/api/units/113243175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.622603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Array</emph> (default)." ], "previous_source": "", "target": [ "" ], "id_hash": -3552595386197254087, "content_hash": -3552595386197254087, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id281708281579757\nhelp.text", "note": "FfKjN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4eb2a55197056039", "url": "https://translations.documentfoundation.org/api/units/113243176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.623550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Array</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1815729443851563498, "content_hash": -1815729443851563498, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id251708281584285\nhelp.text", "note": "8CD3w", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=66cd3bb0e3028e16", "url": "https://translations.documentfoundation.org/api/units/113243177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.624507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -9149569538617895845, "content_hash": -9149569538617895845, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id191708281589997\nhelp.text", "note": "6aABE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=010632fb2af2145b", "url": "https://translations.documentfoundation.org/api/units/113243178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.625469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -4087673280171864734, "content_hash": -4087673280171864734, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id561708281595885\nhelp.text", "note": "pwwij", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113243179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4745aacf21800d62", "url": "https://translations.documentfoundation.org/api/units/113243179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.626433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<input>{=XLOOKUP(\"Atomic Number\";A2:A4;A2:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "" ], "id_hash": -2496921173792390262, "content_hash": -2496921173792390262, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id141716739193733\nhelp.text", "note": "fHQrZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7987, "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": 113243180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5d59276bf3f4038a", "url": "https://translations.documentfoundation.org/api/units/113243180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.628447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<input>{=XLOOKUP(\"Helium\";B1:DO1;B1:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "" ], "id_hash": 4446248683708869960, "content_hash": 4446248683708869960, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id231716739652495\nhelp.text", "note": "tkRq7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7988, "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": 113243181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=bdb43f9edf83ed48", "url": "https://translations.documentfoundation.org/api/units/113243181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.629426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "" ], "id_hash": 5782600359580313982, "content_hash": 5782600359580313982, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id21716739329244\nhelp.text", "note": "D5tG5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242867/?format=api", "priority": 100, "id": 113243182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d03fec63b6d4a97e", "url": "https://translations.documentfoundation.org/api/units/113243182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.630372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -3961206654497531357, "content_hash": -3961206654497531357, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id671708356683379\nhelp.text", "note": "vaCSD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7990, "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": 113243183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4906f788fcc2da23", "url": "https://translations.documentfoundation.org/api/units/113243183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.631330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "Searches for a value in a one-dimensional array and returns the relative position of the item." ], "previous_source": "", "target": [ "" ], "id_hash": 4790560323384865954, "content_hash": 4790560323384865954, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id581708279355738\nhelp.text", "note": "8GYav", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7995, "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": 113243184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c27b7d3b8e6f74a2", "url": "https://translations.documentfoundation.org/api/units/113243184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.634228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 20644941746071029, "content_hash": 20644941746071029, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id321716754048322\nhelp.text", "note": "qJsbC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7996, "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": 113243185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=80495877132ee5f5", "url": "https://translations.documentfoundation.org/api/units/113243185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.635219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "XMATCH(Lookup; Array [; MatchType [; SearchMode ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 2569128359320830574, "content_hash": 2569128359320830574, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id211708281649651\nhelp.text", "note": "NFwz8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7997, "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": 113243186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=a3a760a187b3426e", "url": "https://translations.documentfoundation.org/api/units/113243186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.636191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<input>=XMATCH(\"Atomic Number\",A1:A4)</input> returns 3, the third line of the A1:A4 array." ], "previous_source": "", "target": [ "" ], "id_hash": -8976317937889721527, "content_hash": -8976317937889721527, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id471716753503759\nhelp.text", "note": "WMXaP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8000, "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": 113243187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=036db664e11dc349", "url": "https://translations.documentfoundation.org/api/units/113243187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.637343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<input>=XMATCH(\"Li\",A2:DO2)</input> returns 4, the fourth column of the A2:DO2 array." ], "previous_source": "", "target": [ "" ], "id_hash": 3448865499403957072, "content_hash": 3448865499403957072, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id581716753499133\nhelp.text", "note": "QTDzi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8001, "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": 113243188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=afdcd4e61a12b350", "url": "https://translations.documentfoundation.org/api/units/113243188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.638311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 6694771020294497606, "content_hash": 6694771020294497606, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id561711031254255\nhelp.text", "note": "BVQrr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113252599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=dce89ac5c53ba546", "url": "https://translations.documentfoundation.org/api/units/113252599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-06T11:51:07.135650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">INDIRECT wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 5380036932438878388, "content_hash": 5380036932438878388, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751509\nhelp.text", "note": "MssCB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=caa9bb15dc8068b4", "url": "https://translations.documentfoundation.org/api/units/113259982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:49.692150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "LET function" ], "previous_source": "", "target": [ "" ], "id_hash": 1990380590024096603, "content_hash": 1990380590024096603, "location": "func_let.xhp", "context": "func_let.xhp\ntit\nhelp.text", "note": "ANivD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=9b9f4099e437fb5b", "url": "https://translations.documentfoundation.org/api/units/113259983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.771757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<bookmark_value>LET function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -5619471719371825378, "content_hash": -5619471719371825378, "location": "func_let.xhp", "context": "func_let.xhp\nbm_id361708283183878\nhelp.text", "note": "mp4Fy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=3203a03e957d1f1e", "url": "https://translations.documentfoundation.org/api/units/113259984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.772879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4761206583786135496, "content_hash": 4761206583786135496, "location": "func_let.xhp", "context": "func_let.xhp\nhd_id721717677746932\nhelp.text", "note": "cUrJc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c213342978d2dfc8", "url": "https://translations.documentfoundation.org/api/units/113259985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.773851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 2970498258313303213, "content_hash": 2970498258313303213, "location": "func_let.xhp", "context": "func_let.xhp\npar_id71717677746935\nhelp.text", "note": "NFFDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=a939546d74ae54ad", "url": "https://translations.documentfoundation.org/api/units/113259986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.774821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])" ], "previous_source": "", "target": [ "" ], "id_hash": 4556853629358978612, "content_hash": 4556853629358978612, "location": "func_let.xhp", "context": "func_let.xhp\npar_id211708281649651\nhelp.text", "note": "A9iKa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=bf3d323b8f643634", "url": "https://translations.documentfoundation.org/api/units/113259987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.775803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -8602941962873102523, "content_hash": -8602941962873102523, "location": "func_let.xhp", "context": "func_let.xhp\npar_id301717681619674\nhelp.text", "note": "voGvK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=089c35dd77a59f45", "url": "https://translations.documentfoundation.org/api/units/113259988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.776741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 6191346384833506896, "content_hash": 6191346384833506896, "location": "func_let.xhp", "context": "func_let.xhp\npar_id721717688901981\nhelp.text", "note": "CDP5D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d5ec14bbdd666e50", "url": "https://translations.documentfoundation.org/api/units/113259989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.777717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>Name_value1</emph>: the value or calculation to assign to Name1." ], "previous_source": "", "target": [ "" ], "id_hash": 3574424279183359466, "content_hash": 3574424279183359466, "location": "func_let.xhp", "context": "func_let.xhp\npar_id951717681624139\nhelp.text", "note": "pXGwN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b19ae7f19d417dea", "url": "https://translations.documentfoundation.org/api/units/113259990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.778715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": 7077235568600816289, "content_hash": 7077235568600816289, "location": "func_let.xhp", "context": "func_let.xhp\npar_id421717686226452\nhelp.text", "note": "RpF5L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=e2376440ba361aa1", "url": "https://translations.documentfoundation.org/api/units/113259991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.779655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>Calculation</emph>: a formula expression that uses all names within the LET function." ], "previous_source": "", "target": [ "" ], "id_hash": 8137769495232274667, "content_hash": 8137769495232274667, "location": "func_let.xhp", "context": "func_let.xhp\npar_id231717686233659\nhelp.text", "note": "ii4Cd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=f0ef2a3d7b5460eb", "url": "https://translations.documentfoundation.org/api/units/113259992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.780617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>Calculation</emph> must be the last argument in the LET function." ], "previous_source": "", "target": [ "" ], "id_hash": -5929069330371037692, "content_hash": -5929069330371037692, "location": "func_let.xhp", "context": "func_let.xhp\npar_id91717686350018\nhelp.text", "note": "AaFRL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=2db7b6db8a923604", "url": "https://translations.documentfoundation.org/api/units/113259993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.781569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -1959073628428631352, "content_hash": -1959073628428631352, "location": "func_let.xhp", "context": "func_let.xhp\npar_id121717701196975\nhelp.text", "note": "vGdpF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=64cff8ea20ad02c8", "url": "https://translations.documentfoundation.org/api/units/113259994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.782526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": [ "" ], "id_hash": -6890932177909452756, "content_hash": -6890932177909452756, "location": "func_let.xhp", "context": "func_let.xhp\npar_id311717701158800\nhelp.text", "note": "s46BC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=205e7db1a465f02c", "url": "https://translations.documentfoundation.org/api/units/113259995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.783499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -3954689845045384000, "content_hash": -3954689845045384000, "location": "func_let.xhp", "context": "func_let.xhp\npar_id701677016751508\nhelp.text", "note": "TGwea", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 113259996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=491e1e89ed39acc0", "url": "https://translations.documentfoundation.org/api/units/113259996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:25:55.784481Z" } ] }{ "count": 8591, "next": null, "previous": "