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=169
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=170", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=168", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -9193006166818129083, "content_hash": -9193006166818129083, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id511715983350731\nhelp.text", "note": "LFWFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7771, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218011/?format=api", "priority": 100, "id": 113218971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=006be19910d47b45", "url": "https://translations.documentfoundation.org/api/units/113218971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.069231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "" ], "id_hash": -4892593401872488629, "content_hash": -4892593401872488629, "location": "func_unique.xhp", "context": "func_unique.xhp\nhd_id981715984567844\nhelp.text", "note": "i74Ub", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7772, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113218012/?format=api", "priority": 100, "id": 113218972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3c1a04391af8674b", "url": "https://translations.documentfoundation.org/api/units/113218972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.070110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -3430104060944075568, "content_hash": -3430104060944075568, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id501715983764524\nhelp.text", "note": "dScyG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7774, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218014/?format=api", "priority": 100, "id": 113218974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5065d287b0cdb4d0", "url": "https://translations.documentfoundation.org/api/units/113218974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.071954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -4339115958050337712, "content_hash": -4339115958050337712, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id31715983773608\nhelp.text", "note": "GAopa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7775, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218015/?format=api", "priority": 100, "id": 113218975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=43c85d06992e4c50", "url": "https://translations.documentfoundation.org/api/units/113218975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.072836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"movecopy_sheet\"><link href=\"text/scalc/01/02180000.xhp\">Move or Copy a Sheet</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"movecopy_sheet\"><link href=\"text/scalc/01/02180000.xhp\">Déplacer ou copier une feuille</link></variable>" ], "id_hash": 1994254624815367610, "content_hash": 1994254624815367610, "location": "02180000.xhp", "context": "02180000.xhp\nhd_id3153360\nhelp.text", "note": "ytArs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113233833/?format=api", "priority": 100, "id": 113233954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9bad0403e7ccc5ba", "url": "https://translations.documentfoundation.org/api/units/113233954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:34:10.522005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "When the <link href=\"text/shared/01/02230100.xhp\"><menuitem>Record Changes</menuitem></link> command is active, you cannot delete or move sheets." ], "previous_source": "", "target": [ "" ], "id_hash": -3417779666752492251, "content_hash": -3417779666752492251, "location": "02180000.xhp", "context": "02180000.xhp\npar_id3720376688484858\nhelp.text", "note": "GHQ6R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113233834/?format=api", "priority": 100, "id": 113233955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=50919b8052aa2d25", "url": "https://translations.documentfoundation.org/api/units/113233955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:34:10.523952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"define_names_h1\"><link href=\"text/scalc/01/04070100.xhp\">Define Names</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"define_names_h1\"><link href=\"text/scalc/01/04070100.xhp\">Définir les noms</link></variable>" ], "id_hash": 3534261034148231199, "content_hash": 3534261034148231199, "location": "04070100.xhp", "context": "04070100.xhp\nhd_id3156330\nhelp.text", "note": "fGnfi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4671, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113233835/?format=api", "priority": 100, "id": 113233956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b10c37af6be8f81f", "url": "https://translations.documentfoundation.org/api/units/113233956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:34:13.373409Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The <menuitem>Name Box</menuitem> on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." ], "previous_source": "", "target": [ "" ], "id_hash": -5019432053091108439, "content_hash": -5019432053091108439, "location": "04070100.xhp", "context": "04070100.xhp\npar_id3155131\nhelp.text", "note": "QVRkv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4674, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/113233836/?format=api", "priority": 100, "id": 113233957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3a5765244d4b79a9", "url": "https://translations.documentfoundation.org/api/units/113233957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:34:13.375754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Filters a data range or array based on specified conditions." ], "previous_source": "", "target": [ "" ], "id_hash": -9199004177996162485, "content_hash": -9199004177996162485, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id771708806478128\nhelp.text", "note": "dxbQ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6910, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113242831/?format=api", "priority": 100, "id": 113244136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=0056927043345a4b", "url": "https://translations.documentfoundation.org/api/units/113244136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:30.989854Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "FILTER( Range; Criteria [; Return if empty])" ], "previous_source": "", "target": [ "" ], "id_hash": -8806318181578049432, "content_hash": -8806318181578049432, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id211708281649651\nhelp.text", "note": "tuppo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6911, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113242832/?format=api", "priority": 100, "id": 113244137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=05c9ac458ff9f868", "url": "https://translations.documentfoundation.org/api/units/113244137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:30.991024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Result if empty</emph>: (optional) the value to return if all values in the <emph>Criteria</emph> array are empty (filter return nothing)." ], "previous_source": "", "target": [ "" ], "id_hash": -3309613975401676562, "content_hash": -3309613975401676562, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id421709395146863\nhelp.text", "note": "ZcP2E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6914, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242833/?format=api", "priority": 100, "id": 113244138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5211e39fdc83c0ee", "url": "https://translations.documentfoundation.org/api/units/113244138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:30.992942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>{=FILTER(A2:C13;A2:A13>50)}</input> returns the array containing all grades with Maths grade above 50. Note that this is an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 6775980567866616718, "content_hash": 6775980567866616718, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id21709506838932\nhelp.text", "note": "AFtpH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6915, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242834/?format=api", "priority": 100, "id": 113244139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=de091e6d00a3ab8e", "url": "https://translations.documentfoundation.org/api/units/113244139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:30.993947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>{=FILTER(A2:C13;B2:B13>90;\"No results\")}</input> Returns the string \"No results\", since no grade on Physics is above 90." ], "previous_source": "", "target": [ "" ], "id_hash": -4714812717678269879, "content_hash": -4714812717678269879, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id561709507935610\nhelp.text", "note": "METQ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6916, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113242835/?format=api", "priority": 100, "id": 113244140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3e919ed03c4aea49", "url": "https://translations.documentfoundation.org/api/units/113244140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:30.994936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "RANDARRAY([Rows [; Columns [; Min [; Max [; Integers] ] ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": -3087541549094932463, "content_hash": -3087541549094932463, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id211708281649651\nhelp.text", "note": "ArGrF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113242836/?format=api", "priority": 100, "id": 113244141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5526d951d0eff011", "url": "https://translations.documentfoundation.org/api/units/113244141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.299066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>{=RANDARRAY(10;4;10;50;1)}</input> returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers)." ], "previous_source": "", "target": [ "" ], "id_hash": 5074773011725883336, "content_hash": 5074773011725883336, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id521715616457946\nhelp.text", "note": "mz6p3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/113242837/?format=api", "priority": 100, "id": 113244142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c66d372ab7a917c8", "url": "https://translations.documentfoundation.org/api/units/113244142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.304492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "SORT(Range [; SortIndex [; SortOrder [; ByCol] ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": 6748395899807645412, "content_hash": 6748395899807645412, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id211708281649651\nhelp.text", "note": "DmRKh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113242839/?format=api", "priority": 100, "id": 113244144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=dda71e50fbbcbee4", "url": "https://translations.documentfoundation.org/api/units/113244144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.371025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Range:</emph> the range or array to sort." ], "previous_source": "", "target": [ "" ], "id_hash": 1645809688449997196, "content_hash": 1645809688449997196, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id551711457515235\nhelp.text", "note": "gmV6H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113242840/?format=api", "priority": 100, "id": 113244145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=96d7173117f5598c", "url": "https://translations.documentfoundation.org/api/units/113244145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.372053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SortIndex:</emph> (optional). The number indicating the row or column to sort by." ], "previous_source": "", "target": [ "" ], "id_hash": 3938506842601994020, "content_hash": 3938506842601994020, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id151711457520290\nhelp.text", "note": "WQaKY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113242841/?format=api", "priority": 100, "id": 113244146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b6a8631b32bcb724", "url": "https://translations.documentfoundation.org/api/units/113244146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.373018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SortOrder:</emph> (optional). A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order." ], "previous_source": "", "target": [ "" ], "id_hash": -3717172067221163892, "content_hash": -3717172067221163892, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id131711457525811\nhelp.text", "note": "P5DGG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113242842/?format=api", "priority": 100, "id": 113244147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4c69f3b30447308c", "url": "https://translations.documentfoundation.org/api/units/113244147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.373992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>ByCol:</emph> (optional). A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column." ], "previous_source": "", "target": [ "" ], "id_hash": 6724344827435065277, "content_hash": 6724344827435065277, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id351711457531579\nhelp.text", "note": "5Vo8L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113242843/?format=api", "priority": 100, "id": 113244148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=dd51abfe52809fbd", "url": "https://translations.documentfoundation.org/api/units/113244148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.374985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -9147617564775033183, "content_hash": -9147617564775033183, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id131711466000482\nhelp.text", "note": "jhZ65", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242847/?format=api", "priority": 100, "id": 113244152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=010d224a7e75d6a1", "url": "https://translations.documentfoundation.org/api/units/113244152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.388410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "" ], "id_hash": 5175227711762151243, "content_hash": 5175227711762151243, "location": "func_weeknum.xhp", "context": "func_weeknum.xhp\npar_id901535122363436\nhelp.text", "note": "cM6zS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7853, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242848/?format=api", "priority": 100, "id": 113244153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c7d21a2f2f57374b", "url": "https://translations.documentfoundation.org/api/units/113244153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.547326Z" }, { "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": 7962, "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": 7964, "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": 7965, "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": 7966, "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": 7971, "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": 7972, "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": [ "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": 7658, "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": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">page INDIRECT sur le wiki</link>." ], "id_hash": 5380036932438878388, "content_hash": 5380036932438878388, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751509\nhelp.text", "note": "MssCB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113259862/?format=api", "priority": 100, "id": 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": 7224, "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": 7225, "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": 7226, "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": 7227, "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": 7228, "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": 7229, "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": 7230, "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": 7231, "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": 7232, "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": 7233, "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": 7234, "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": 7235, "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": 7236, "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": 7237, "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" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present." ], "previous_source": "", "target": [ "" ], "id_hash": 7163934109599625286, "content_hash": 7163934109599625286, "location": "common_func.xhp", "context": "common_func.xhp\npar_id431716730587722\nhelp.text", "note": "s37P8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113263597/?format=api", "priority": 100, "id": 113263897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e36b681dd4fd7046", "url": "https://translations.documentfoundation.org/api/units/113263897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:36:47.849680Z" }, { "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 (* ?) or regular expressions for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets." ], "previous_source": "", "target": [ "" ], "id_hash": -5816581931961691979, "content_hash": -5816581931961691979, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id631708282151776\nhelp.text", "note": "mekaB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7943, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/113263599/?format=api", "priority": 100, "id": 113263899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2f47598cea77d0b5", "url": "https://translations.documentfoundation.org/api/units/113263899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:36:48.091841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match." ], "previous_source": "", "target": [ "" ], "id_hash": 3971188993379063238, "content_hash": 3971188993379063238, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id111718970605394\nhelp.text", "note": "GAYga", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/113273796/?format=api", "priority": 100, "id": 113273946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b71c7f59664cd5c6", "url": "https://translations.documentfoundation.org/api/units/113273946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:48:19.699960Z" }, { "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": 8088043945987217076, "content_hash": 8088043945987217076, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id881708281558005\nhelp.text", "note": "WUvAp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113273798/?format=api", "priority": 100, "id": 113273948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f03e811dd85116b4", "url": "https://translations.documentfoundation.org/api/units/113273948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:48:19.704241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match." ], "previous_source": "", "target": [ "" ], "id_hash": -8985921050195676254, "content_hash": -8985921050195676254, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id111718970605394\nhelp.text", "note": "EQfjm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/113273799/?format=api", "priority": 100, "id": 113273949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=034b986a0f61b3a2", "url": "https://translations.documentfoundation.org/api/units/113273949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:48:19.705293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "XLOOKUP( [Search criterion] ; Search Array ; Result Array [ ; [ Result if not found ] [ ; [Match Mode] [ ; Search Mode ] ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 3895744510617587133, "content_hash": 3895744510617587133, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id211708281649651\nhelp.text", "note": "CY5Hu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/113275442/?format=api", "priority": 100, "id": 113275952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b61076fdeb0a0dbd", "url": "https://translations.documentfoundation.org/api/units/113275952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:51.072647Z" } ] }{ "count": 8573, "next": "