Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=172
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=171", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=75ffc5ebf63cfe2c", "url": "https://translations.documentfoundation.org/api/units/113244154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.592849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=920a02dd45c44030", "url": "https://translations.documentfoundation.org/api/units/113244155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.594006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6ff9f7aed1374fa2", "url": "https://translations.documentfoundation.org/api/units/113244156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.594968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fe4ad30a34e8402c", "url": "https://translations.documentfoundation.org/api/units/113244157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.595946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9860535b719e5cf2", "url": "https://translations.documentfoundation.org/api/units/113244158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.597623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c051a02ea88056f7", "url": "https://translations.documentfoundation.org/api/units/113244159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.599907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b196ec63c5ad1f6b", "url": "https://translations.documentfoundation.org/api/units/113244160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.600895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=1faa33ea886a16a7", "url": "https://translations.documentfoundation.org/api/units/113244161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.601836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d6046aa06d13c4b5", "url": "https://translations.documentfoundation.org/api/units/113244162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.602791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=1bab0ff6349149a3", "url": "https://translations.documentfoundation.org/api/units/113244163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.603724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d900f2d29c92a31f", "url": "https://translations.documentfoundation.org/api/units/113244164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.604670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=dd28e71a1d5d547d", "url": "https://translations.documentfoundation.org/api/units/113244165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.605627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4eb2a55197056039", "url": "https://translations.documentfoundation.org/api/units/113244166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.606560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=66cd3bb0e3028e16", "url": "https://translations.documentfoundation.org/api/units/113244167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.607506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=010632fb2af2145b", "url": "https://translations.documentfoundation.org/api/units/113244168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.608441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4745aacf21800d62", "url": "https://translations.documentfoundation.org/api/units/113244169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.609405Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5d59276bf3f4038a", "url": "https://translations.documentfoundation.org/api/units/113244170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.611629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=bdb43f9edf83ed48", "url": "https://translations.documentfoundation.org/api/units/113244171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.612583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d03fec63b6d4a97e", "url": "https://translations.documentfoundation.org/api/units/113244172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.613617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4906f788fcc2da23", "url": "https://translations.documentfoundation.org/api/units/113244173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.614565Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c27b7d3b8e6f74a2", "url": "https://translations.documentfoundation.org/api/units/113244174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.617378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=80495877132ee5f5", "url": "https://translations.documentfoundation.org/api/units/113244175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.618388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a3a760a187b3426e", "url": "https://translations.documentfoundation.org/api/units/113244176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.619387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=036db664e11dc349", "url": "https://translations.documentfoundation.org/api/units/113244177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.620569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113244178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=afdcd4e61a12b350", "url": "https://translations.documentfoundation.org/api/units/113244178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.621536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113252657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=dce89ac5c53ba546", "url": "https://translations.documentfoundation.org/api/units/113252657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-06T11:52:22.944459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=caa9bb15dc8068b4", "url": "https://translations.documentfoundation.org/api/units/113260312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:12.688208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9b9f4099e437fb5b", "url": "https://translations.documentfoundation.org/api/units/113260313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.690601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3203a03e957d1f1e", "url": "https://translations.documentfoundation.org/api/units/113260314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.691701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c213342978d2dfc8", "url": "https://translations.documentfoundation.org/api/units/113260315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.692653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a939546d74ae54ad", "url": "https://translations.documentfoundation.org/api/units/113260316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.693610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=bf3d323b8f643634", "url": "https://translations.documentfoundation.org/api/units/113260317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.694573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=089c35dd77a59f45", "url": "https://translations.documentfoundation.org/api/units/113260318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.695490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d5ec14bbdd666e50", "url": "https://translations.documentfoundation.org/api/units/113260319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.696448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b19ae7f19d417dea", "url": "https://translations.documentfoundation.org/api/units/113260320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.697385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e2376440ba361aa1", "url": "https://translations.documentfoundation.org/api/units/113260321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.698306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f0ef2a3d7b5460eb", "url": "https://translations.documentfoundation.org/api/units/113260322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.699232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2db7b6db8a923604", "url": "https://translations.documentfoundation.org/api/units/113260323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.700150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=64cff8ea20ad02c8", "url": "https://translations.documentfoundation.org/api/units/113260324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.701068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=205e7db1a465f02c", "url": "https://translations.documentfoundation.org/api/units/113260325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.702046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?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": 113260326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=491e1e89ed39acc0", "url": "https://translations.documentfoundation.org/api/units/113260326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:28:15.703009Z" } ] }{ "count": 8591, "next": null, "previous": "