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=171
{ "count": 8597, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=172", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=170", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"randbetween_nv_1\"><link href=\"text/scalc/01/04060106.xhp#randbetween_nv_1\">RANDBETWEEN.NV</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 5434617537649224664, "content_hash": 5434617537649224664, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id171590240366277\nhelp.text", "note": "873Eh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1679, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/113217987/?format=api", "priority": 100, "id": 113218947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=cb6ba3db4db0abd8", "url": "https://translations.documentfoundation.org/api/units/113218947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.310143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"rand_1\"><link href=\"text/scalc/01/04060106.xhp#rand_1\">RAND</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 6093336122251495087, "content_hash": 6093336122251495087, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id3164800\nhelp.text", "note": "uFBEH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1686, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/113217988/?format=api", "priority": 100, "id": 113218948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d48fe0eb57db46af", "url": "https://translations.documentfoundation.org/api/units/113218948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.311914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"rand_nv_1\"><link href=\"text/scalc/01/04060106.xhp#rand_nv_1\">RAND.NV</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 8005471656327237513, "content_hash": 8005471656327237513, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id71590238179170\nhelp.text", "note": "mDVmJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1696, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/113217989/?format=api", "priority": 100, "id": 113218949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ef19260e7ed7cf89", "url": "https://translations.documentfoundation.org/api/units/113218949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.313907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Generates an array of random numbers between two limit values." ], "previous_source": "", "target": [ "" ], "id_hash": 9016488845980914979, "content_hash": 9016488845980914979, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id771708806478128\nhelp.text", "note": "ERqtG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7453, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113217990/?format=api", "priority": 100, "id": 113218950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fd2100d581f6d523", "url": "https://translations.documentfoundation.org/api/units/113218950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.880714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Min</emph>: (optional) The lower limit of the generated numbers. If omitted, the minimum value is 0." ], "previous_source": "", "target": [ "" ], "id_hash": -1423158741028957940, "content_hash": -1423158741028957940, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id171715616081037\nhelp.text", "note": "2KCG4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7457, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113217992/?format=api", "priority": 100, "id": 113218952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6c3fecaa4dfa110c", "url": "https://translations.documentfoundation.org/api/units/113218952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.883917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Max</emph>: (optional) The upper limit of the generated numbers. If omitted, the maximum value is 1." ], "previous_source": "", "target": [ "" ], "id_hash": 9094606869995135252, "content_hash": 9094606869995135252, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id361715616086109\nhelp.text", "note": "qGeUx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7458, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113217993/?format=api", "priority": 100, "id": 113218953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fe3688c351e32114", "url": "https://translations.documentfoundation.org/api/units/113218953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.885041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Integers</emph>: (optional) returns whole numbers (TRUE) or decimal numbers (FALSE). Default is FALSE." ], "previous_source": "", "target": [ "" ], "id_hash": -3379731836422894084, "content_hash": -3379731836422894084, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id511715616090373\nhelp.text", "note": "BcDGD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7459, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/113217994/?format=api", "priority": 100, "id": 113218954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5118c7cd25ef4dfc", "url": "https://translations.documentfoundation.org/api/units/113218954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.886157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "If <emph>Rows</emph> or <emph>Columns</emph> are references to the content of other cells, the array dimensions do not change when the referenced content changes. The array formula must be deleted and re-entered." ], "previous_source": "", "target": [ "" ], "id_hash": 7271894372197325971, "content_hash": 7271894372197325971, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id141715790327107\nhelp.text", "note": "QgdBu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7461, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/113217995/?format=api", "priority": 100, "id": 113218955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e4eaf56742fbdc93", "url": "https://translations.documentfoundation.org/api/units/113218955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.887379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "SEQUENCE(Rows, Columns, [Start], [Step])" ], "previous_source": "", "target": [ "" ], "id_hash": -5541865529113137543, "content_hash": -5541865529113137543, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id211708281649651\nhelp.text", "note": "Kk5tL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113217996/?format=api", "priority": 100, "id": 113218956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=331756a9d03aae79", "url": "https://translations.documentfoundation.org/api/units/113218956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.948014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "If <emph>Rows</emph> or <emph>Columns</emph> are references to the content of other cells, the array dimensions do not change when the referenced content changes. The array formula must be deleted and re-entered." ], "previous_source": "", "target": [ "" ], "id_hash": 9100881461522311275, "content_hash": 9100881461522311275, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id141715790327107\nhelp.text", "note": "EmG5r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/113217997/?format=api", "priority": 100, "id": 113218957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fe4cd37880f9a86b", "url": "https://translations.documentfoundation.org/api/units/113218957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.951723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The array is filled from the first row to the right up to the value of <emph>Columns</emph>, and then down to the number of rows." ], "previous_source": "", "target": [ "" ], "id_hash": -6858599248302186589, "content_hash": -6858599248302186589, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id61714595841660\nhelp.text", "note": "k3KZZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/113217998/?format=api", "priority": 100, "id": 113218958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=20d15c52742fdfa3", "url": "https://translations.documentfoundation.org/api/units/113218958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:02.952699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Returns the array of unique values from a range or array of values." ], "previous_source": "", "target": [ "" ], "id_hash": -3829388704046755930, "content_hash": -3829388704046755930, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id771708806478128\nhelp.text", "note": "AwD6d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7788, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/113218000/?format=api", "priority": 100, "id": 113218960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4adb47433c664fa6", "url": "https://translations.documentfoundation.org/api/units/113218960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.058781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "UNIQUE(Array, [By col], [Uniqueness])" ], "previous_source": "", "target": [ "" ], "id_hash": -2502084134586199131, "content_hash": -2502084134586199131, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id211708281649651\nhelp.text", "note": "A8bJf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7789, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113218002/?format=api", "priority": 100, "id": 113218962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5d46cfbc77d953a5", "url": "https://translations.documentfoundation.org/api/units/113218962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.060906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Array</emph>: the range or array from which to return unique values." ], "previous_source": "", "target": [ "" ], "id_hash": -3540112149304595332, "content_hash": -3540112149304595332, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id381715698113514\nhelp.text", "note": "DUA7p", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7790, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/113218003/?format=api", "priority": 100, "id": 113218963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4edefec1aba7ac7c", "url": "https://translations.documentfoundation.org/api/units/113218963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.061808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>By col</emph>: (optional) a logical value that indicates how to compare data: TRUE - compares data horizontally for a match of all cells in each column, across all columns. FALSE or omitted (default) - compares data vertically, for a match of all cells of each row, across all rows." ], "previous_source": "", "target": [ "" ], "id_hash": 7067077601845014926, "content_hash": 7067077601845014926, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id311715698119400\nhelp.text", "note": "ZDyWq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7791, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/113218004/?format=api", "priority": 100, "id": 113218964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e2134da2ca17718e", "url": "https://translations.documentfoundation.org/api/units/113218964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.062752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Uniqueness</emph>: (optional) A logical value that defines which values are considered unique. TRUE returns values that occur only once. The default is FALSE or omitted, which returns all distinct values in the range or array." ], "previous_source": "", "target": [ "" ], "id_hash": -1132861646059916634, "content_hash": -1132861646059916634, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id531715698124705\nhelp.text", "note": "DSDnH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7792, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/113218005/?format=api", "priority": 100, "id": 113218965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=70474455c6ef32a6", "url": "https://translations.documentfoundation.org/api/units/113218965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.063725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "The UNIQUE function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 8490771430562802111, "content_hash": 8490771430562802111, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id501715889339407\nhelp.text", "note": "fknB6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7793, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/113218006/?format=api", "priority": 100, "id": 113218966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f5d547a14bbb29bf", "url": "https://translations.documentfoundation.org/api/units/113218966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.064682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Given the data table below, the examples returns unique occurrences of grades and age." ], "previous_source": "", "target": [ "" ], "id_hash": 5780091162103173548, "content_hash": 5780091162103173548, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id471715980557106\nhelp.text", "note": "RUvGf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7794, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113218007/?format=api", "priority": 100, "id": 113218967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d0370249a688d1ac", "url": "https://translations.documentfoundation.org/api/units/113218967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.065606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example 1" ], "previous_source": "", "target": [ "" ], "id_hash": -7670819276522035987, "content_hash": -7670819276522035987, "location": "func_unique.xhp", "context": "func_unique.xhp\nhd_id931715984553129\nhelp.text", "note": "Kgeri", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7795, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113218008/?format=api", "priority": 100, "id": 113218968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=158bc6827eaf64ed", "url": "https://translations.documentfoundation.org/api/units/113218968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.066518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>{=UNIQUE(B1:C10,FALSE(),FALSE())}</input> returns the array below. The grades and ages of the rows with name Andy and Harry are returned only once. The same for rows with name Eva and Irene." ], "previous_source": "", "target": [ "" ], "id_hash": 933957597843480811, "content_hash": 933957597843480811, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id641715980827372\nhelp.text", "note": "nbDpQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7796, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/113218009/?format=api", "priority": 100, "id": 113218969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=8cf6157ca6bce0eb", "url": "https://translations.documentfoundation.org/api/units/113218969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.067416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 8934259999416081063, "content_hash": 8934259999416081063, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id641715983343641\nhelp.text", "note": "9XEhA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7797, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218010/?format=api", "priority": 100, "id": 113218970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fbfcde223c2d5aa7", "url": "https://translations.documentfoundation.org/api/units/113218970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.068350Z" }, { "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": 7798, "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": 7799, "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": [ "<input>{=UNIQUE(B1:C10,FALSE(),TRUE())}</input>, with <emph>Uniqueness</emph> as TRUE. Returns the array below with the rows of Andy, Harry, Eva and Irene omitted because their combined grades and ages are not unique." ], "previous_source": "", "target": [ "" ], "id_hash": -5413494130597359371, "content_hash": -5413494130597359371, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id801715981230387\nhelp.text", "note": "FuxKt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7800, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/113218013/?format=api", "priority": 100, "id": 113218973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=34df67c5281510f5", "url": "https://translations.documentfoundation.org/api/units/113218973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:58:03.071007Z" }, { "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": 7801, "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": 7802, "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": [ "" ], "id_hash": 1994254624815367610, "content_hash": 1994254624815367610, "location": "02180000.xhp", "context": "02180000.xhp\nhd_id3153360\nhelp.text", "note": "ytArs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 282, "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": 285, "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": [ "" ], "id_hash": 3534261034148231199, "content_hash": 3534261034148231199, "location": "04070100.xhp", "context": "04070100.xhp\nhd_id3156330\nhelp.text", "note": "fGnfi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4658, "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": 4661, "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": 6937, "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": 6938, "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": 6941, "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": 6942, "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": 6943, "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": 7454, "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": 7462, "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": [ "<input>{=SEQUENCE(3,3,10,11)}</input> returns the 3-by-3 array below with an upper-left value of 10 and filling the array to the right and then downward in steps of 11." ], "previous_source": "", "target": [ "" ], "id_hash": 3724832532271727730, "content_hash": 3724832532271727730, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id201714595986945\nhelp.text", "note": "u9vnG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/113242838/?format=api", "priority": 100, "id": 113244143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b3b14373fde00472", "url": "https://translations.documentfoundation.org/api/units/113244143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.362065Z" }, { "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": 7598, "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": 7599, "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": 7600, "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": 7601, "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": 7602, "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": [ "SORTBY(Range; SortByRange1; SortOrder1 [; SortByRange2; SortOrder2,[...] ])" ], "previous_source": "", "target": [ "" ], "id_hash": -158624346296813363, "content_hash": -158624346296813363, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id211708281649651\nhelp.text", "note": "52ZFJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113242844/?format=api", "priority": 100, "id": 113244149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7dcc73ff5a3ff8cd", "url": "https://translations.documentfoundation.org/api/units/113244149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.384989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SortByRange1, SortByRange2,... </emph>: range 1, range 2,... are the arrays or ranges to sort on." ], "previous_source": "", "target": [ "" ], "id_hash": -6195290948603991008, "content_hash": -6195290948603991008, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id291711544460323\nhelp.text", "note": "i3EwL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113242845/?format=api", "priority": 100, "id": 113244150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2a05e7b4d0442c20", "url": "https://translations.documentfoundation.org/api/units/113244150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.386467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SortOrder1, SortOrder2,...</emph> : order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending." ], "previous_source": "", "target": [ "" ], "id_hash": 5132537484656303369, "content_hash": 5132537484656303369, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id501711544465886\nhelp.text", "note": "BA6NF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/113242846/?format=api", "priority": 100, "id": 113244151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c73a6fa62150dd09", "url": "https://translations.documentfoundation.org/api/units/113244151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:36:31.387447Z" }, { "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": 7628, "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": 7880, "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": [ "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" } ] }