Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=171
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=172", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=170", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=cb6ba3db4db0abd8", "url": "https://translations.documentfoundation.org/api/units/113218243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:21.828695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d48fe0eb57db46af", "url": "https://translations.documentfoundation.org/api/units/113218244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:21.830379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=ef19260e7ed7cf89", "url": "https://translations.documentfoundation.org/api/units/113218245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:21.832333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=fd2100d581f6d523", "url": "https://translations.documentfoundation.org/api/units/113218246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.396847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6c3fecaa4dfa110c", "url": "https://translations.documentfoundation.org/api/units/113218248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.399731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=fe3688c351e32114", "url": "https://translations.documentfoundation.org/api/units/113218249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.400833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5118c7cd25ef4dfc", "url": "https://translations.documentfoundation.org/api/units/113218250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.401892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=e4eaf56742fbdc93", "url": "https://translations.documentfoundation.org/api/units/113218251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.403088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=331756a9d03aae79", "url": "https://translations.documentfoundation.org/api/units/113218252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.464805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=fe4cd37880f9a86b", "url": "https://translations.documentfoundation.org/api/units/113218253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.468064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=20d15c52742fdfa3", "url": "https://translations.documentfoundation.org/api/units/113218254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.469136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4adb47433c664fa6", "url": "https://translations.documentfoundation.org/api/units/113218256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.565287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5d46cfbc77d953a5", "url": "https://translations.documentfoundation.org/api/units/113218258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.567388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4edefec1aba7ac7c", "url": "https://translations.documentfoundation.org/api/units/113218259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.568296Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=e2134da2ca17718e", "url": "https://translations.documentfoundation.org/api/units/113218260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.569210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=70474455c6ef32a6", "url": "https://translations.documentfoundation.org/api/units/113218261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.570176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=f5d547a14bbb29bf", "url": "https://translations.documentfoundation.org/api/units/113218262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.571145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d0370249a688d1ac", "url": "https://translations.documentfoundation.org/api/units/113218263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.572071Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=158bc6827eaf64ed", "url": "https://translations.documentfoundation.org/api/units/113218264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.572984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=8cf6157ca6bce0eb", "url": "https://translations.documentfoundation.org/api/units/113218265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.573873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=fbfcde223c2d5aa7", "url": "https://translations.documentfoundation.org/api/units/113218266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.574814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=006be19910d47b45", "url": "https://translations.documentfoundation.org/api/units/113218267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.575712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=3c1a04391af8674b", "url": "https://translations.documentfoundation.org/api/units/113218268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.576597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=34df67c5281510f5", "url": "https://translations.documentfoundation.org/api/units/113218269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.577480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5065d287b0cdb4d0", "url": "https://translations.documentfoundation.org/api/units/113218270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.578417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113218271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=43c85d06992e4c50", "url": "https://translations.documentfoundation.org/api/units/113218271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:56:22.579307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113233865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=9bad0403e7ccc5ba", "url": "https://translations.documentfoundation.org/api/units/113233865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:31:19.910979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113233866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=50919b8052aa2d25", "url": "https://translations.documentfoundation.org/api/units/113233866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:31:19.914939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113233867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b10c37af6be8f81f", "url": "https://translations.documentfoundation.org/api/units/113233867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:31:22.368550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113233868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=3a5765244d4b79a9", "url": "https://translations.documentfoundation.org/api/units/113233868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:31:22.370594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=0056927043345a4b", "url": "https://translations.documentfoundation.org/api/units/113243146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:38.412154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=05c9ac458ff9f868", "url": "https://translations.documentfoundation.org/api/units/113243147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:38.413315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5211e39fdc83c0ee", "url": "https://translations.documentfoundation.org/api/units/113243148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:38.415224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=de091e6d00a3ab8e", "url": "https://translations.documentfoundation.org/api/units/113243149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:38.416218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=3e919ed03c4aea49", "url": "https://translations.documentfoundation.org/api/units/113243150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:38.417222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5526d951d0eff011", "url": "https://translations.documentfoundation.org/api/units/113243151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.356554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c66d372ab7a917c8", "url": "https://translations.documentfoundation.org/api/units/113243152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.360824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b3b14373fde00472", "url": "https://translations.documentfoundation.org/api/units/113243153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.424761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=dda71e50fbbcbee4", "url": "https://translations.documentfoundation.org/api/units/113243154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.433321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=96d7173117f5598c", "url": "https://translations.documentfoundation.org/api/units/113243155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.434429Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b6a8631b32bcb724", "url": "https://translations.documentfoundation.org/api/units/113243156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.435435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4c69f3b30447308c", "url": "https://translations.documentfoundation.org/api/units/113243157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.436434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=dd51abfe52809fbd", "url": "https://translations.documentfoundation.org/api/units/113243158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.437452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=7dcc73ff5a3ff8cd", "url": "https://translations.documentfoundation.org/api/units/113243159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.447929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=2a05e7b4d0442c20", "url": "https://translations.documentfoundation.org/api/units/113243160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.449655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c73a6fa62150dd09", "url": "https://translations.documentfoundation.org/api/units/113243161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.450657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=010d224a7e75d6a1", "url": "https://translations.documentfoundation.org/api/units/113243162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.451899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?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": 113243163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c7d21a2f2f57374b", "url": "https://translations.documentfoundation.org/api/units/113243163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.570929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 1299854591831326768, "content_hash": 1299854591831326768, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id211708281649651\nhelp.text", "note": "TwFcc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113242850/?format=api", "priority": 100, "id": 113243165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=920a02dd45c44030", "url": "https://translations.documentfoundation.org/api/units/113243165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.611950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>Lookup</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Array</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1154619499237388382, "content_hash": -1154619499237388382, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id861708281340704\nhelp.text", "note": "WoJu6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/113242851/?format=api", "priority": 100, "id": 113243166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6ff9f7aed1374fa2", "url": "https://translations.documentfoundation.org/api/units/113243166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:34:39.612930Z" } ] }{ "count": 8597, "next": "