Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=167
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=168", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=166", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "book" ], "previous_source": "", "target": [ "" ], "id_hash": -2359569587430672104, "content_hash": -2359569587430672104, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id281711478950341\nhelp.text", "note": "Eh74E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928703/?format=api", "priority": 100, "id": 112929940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=5f411ff636613918", "url": "https://translations.documentfoundation.org/api/units/112929940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.543573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "pen" ], "previous_source": "", "target": [ "" ], "id_hash": 1956476429829669250, "content_hash": 1956476429829669250, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id101711478960309\nhelp.text", "note": "KGKEY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928704/?format=api", "priority": 100, "id": 112929941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9b26ccf2736c0182", "url": "https://translations.documentfoundation.org/api/units/112929941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.544449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "pencil" ], "previous_source": "", "target": [ "" ], "id_hash": 5761910617919835683, "content_hash": 5761910617919835683, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id911711478969701\nhelp.text", "note": "fjhFK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928705/?format=api", "priority": 100, "id": 112929942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=cff66b2dd8a9ce23", "url": "https://translations.documentfoundation.org/api/units/112929942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.545321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sorts the contents of a range or array based on the values in a corresponding range or array." ], "previous_source": "", "target": [ "" ], "id_hash": 3209815888189863367, "content_hash": 3209815888189863367, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id771708806478128\nhelp.text", "note": "jCSNU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7651, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/112928706/?format=api", "priority": 100, "id": 112929943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ac8b8e8b41f635c7", "url": "https://translations.documentfoundation.org/api/units/112929943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.548373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Range</emph>: The array or range to sort." ], "previous_source": "", "target": [ "" ], "id_hash": -7510080128569532738, "content_hash": -7510080128569532738, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id451711544450734\nhelp.text", "note": "gifyS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7653, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/112928708/?format=api", "priority": 100, "id": 112929945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=17c6d5e9c5e49ebe", "url": "https://translations.documentfoundation.org/api/units/112929945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.550182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sort the range A2:C7 based on the first column in ascending order and third column in descending order." ], "previous_source": "", "target": [ "" ], "id_hash": -3531935583756588287, "content_hash": -3531935583756588287, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id471711472262161\nhelp.text", "note": "q9cpQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7657, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/112928717/?format=api", "priority": 100, "id": 112929954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4efc0b4cb0a06b01", "url": "https://translations.documentfoundation.org/api/units/112929954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.558192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "SUMIF Function" ], "previous_source": "", "target": [ "" ], "id_hash": -4894683485981402751, "content_hash": -4894683485981402751, "location": "func_sumif.xhp", "context": "func_sumif.xhp\ntit\nhelp.text", "note": "yiPhX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7691, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/112928718/?format=api", "priority": 100, "id": 112929955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3c12974d7a1b9981", "url": "https://translations.documentfoundation.org/api/units/112929955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.574898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1768163232326674878, "content_hash": 1768163232326674878, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nbm_id3151957\nhelp.text", "note": "c4KFv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7692, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112928719/?format=api", "priority": 100, "id": 112929956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9889c71777bce9be", "url": "https://translations.documentfoundation.org/api/units/112929956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.575816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"sumif_head\"><link href=\"text/scalc/01/func_sumif.xhp\">SUMIF</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -1718123532409173078, "content_hash": -1718123532409173078, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id3151957\nhelp.text", "note": "aJCj8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7693, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928720/?format=api", "priority": 100, "id": 112929957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6827ffc012830baa", "url": "https://translations.documentfoundation.org/api/units/112929957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.576725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3843321165031907330, "content_hash": 3843321165031907330, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3151986\nhelp.text", "note": "AWAK5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7694, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/112928721/?format=api", "priority": 100, "id": 112929958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b556383c9f77a002", "url": "https://translations.documentfoundation.org/api/units/112929958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.577632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "SUMIF can only apply a single criterion to a range. Use <link href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\">SUMIFS</link> if you need to apply multiple criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 6769767900734590567, "content_hash": 6769767900734590567, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id411711032873068\nhelp.text", "note": "DFaC8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7695, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/112928722/?format=api", "priority": 100, "id": 112929959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ddf30c09b7208e67", "url": "https://translations.documentfoundation.org/api/units/112929959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.578583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>SUMIF(Range; Criterion [;SumRange])</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -1077939538385294136, "content_hash": -1077939538385294136, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152028\nhelp.text", "note": "F7YsR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7696, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928723/?format=api", "priority": 100, "id": 112929960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=710a63b375322cc8", "url": "https://translations.documentfoundation.org/api/units/112929960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.579502Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Range: </emph> The range of cells to which the criterion is applied." ], "previous_source": "", "target": [ "" ], "id_hash": -2989314792827269585, "content_hash": -2989314792827269585, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152043\nhelp.text", "note": "D2NiD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7697, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/112928724/?format=api", "priority": 100, "id": 112929961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=5683d208b3b5ce2f", "url": "https://translations.documentfoundation.org/api/units/112929961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.580378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." ], "previous_source": "", "target": [ "" ], "id_hash": 3855818603572050466, "content_hash": 3855818603572050466, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id521711134077228\nhelp.text", "note": "ToLFA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7698, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/112928725/?format=api", "priority": 100, "id": 112929962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b5829e9748413a22", "url": "https://translations.documentfoundation.org/api/units/112929962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.581256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed." ], "previous_source": "", "target": [ "" ], "id_hash": 7720751147039105209, "content_hash": 7720751147039105209, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152083\nhelp.text", "note": "BMGEn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7699, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/112928726/?format=api", "priority": 100, "id": 112929963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=eb259e430e74a0b9", "url": "https://translations.documentfoundation.org/api/units/112929963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.582497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": 3584183046783580861, "content_hash": 3584183046783580861, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id451710857799382\nhelp.text", "note": "oviCS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7700, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/112928727/?format=api", "priority": 100, "id": 112929964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b1bd937dc1833abd", "url": "https://translations.documentfoundation.org/api/units/112929964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.583408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(C2:C6,\">=100\")</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 2864419117131846437, "content_hash": 2864419117131846437, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id171711049202378\nhelp.text", "note": "FsERF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7701, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928728/?format=api", "priority": 100, "id": 112929965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a7c07602bc7b5325", "url": "https://translations.documentfoundation.org/api/units/112929965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.584292Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given." ], "previous_source": "", "target": [ "" ], "id_hash": -5593691264439585702, "content_hash": -5593691264439585702, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id381711049216331\nhelp.text", "note": "6mqDE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7702, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/112928729/?format=api", "priority": 100, "id": 112929966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=325f376e7fdf745a", "url": "https://translations.documentfoundation.org/api/units/112929966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.585164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(B2:B5,\">=20\",C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 8989101747577676093, "content_hash": 8989101747577676093, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id6670125\nhelp.text", "note": "AEAwA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7703, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928730/?format=api", "priority": 100, "id": 112929967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=fcbfb469c235e13d", "url": "https://translations.documentfoundation.org/api/units/112929967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.586077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -7532206754417997645, "content_hash": -7532206754417997645, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id341710857230552\nhelp.text", "note": "nUdXV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7704, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/112928731/?format=api", "priority": 100, "id": 112929968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=177839dd3c1e08b3", "url": "https://translations.documentfoundation.org/api/units/112929968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.586952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Using regular expressions" ], "previous_source": "", "target": [ "" ], "id_hash": 3923644392548870229, "content_hash": 3923644392548870229, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id291710867590698\nhelp.text", "note": "Zjs4B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7705, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928732/?format=api", "priority": 100, "id": 112929969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b67395c962d42855", "url": "https://translations.documentfoundation.org/api/units/112929969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.587874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(A2:A6,\"pen\",C2:C5)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 5916800752083859290, "content_hash": 5916800752083859290, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id911710859836541\nhelp.text", "note": "2XByE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7706, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928733/?format=api", "priority": 100, "id": 112929970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d21cb2ef7ab8f75a", "url": "https://translations.documentfoundation.org/api/units/112929970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.588758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters \"pen\". Returns 85 because rows A2 and A4:A6 do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 7821273840181794619, "content_hash": 7821273840181794619, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id31710859838046\nhelp.text", "note": "3ggQs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7707, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/112928734/?format=api", "priority": 100, "id": 112929971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ec8abf1e6717573b", "url": "https://translations.documentfoundation.org/api/units/112929971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.589644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(A2:A6,\"pen*\",C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 3298483984775573571, "content_hash": 3298483984775573571, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id781710871590769\nhelp.text", "note": "L9Ftz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7708, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928735/?format=api", "priority": 100, "id": 112929972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=adc691b541dcf043", "url": "https://translations.documentfoundation.org/api/units/112929972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.590605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters \"pen\". Returns the value 150 because rows A4:A5 do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 1983887232278440469, "content_hash": 1983887232278440469, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id431710871624405\nhelp.text", "note": "netyd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7709, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/112928736/?format=api", "priority": 100, "id": 112929973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9b882eed3a63aa15", "url": "https://translations.documentfoundation.org/api/units/112929973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.591506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(ProductName,\"pen*\",Revenue)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -4636502449059702525, "content_hash": -4636502449059702525, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id311711128230771\nhelp.text", "note": "PdFbx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7710, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928737/?format=api", "priority": 100, "id": 112929974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3fa7d5967b915903", "url": "https://translations.documentfoundation.org/api/units/112929974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.592430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named \"ProductName\", \"Sales\", and \"Revenue\", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href=\"text/scalc/01/04070100.xhp#definenames)\">Define Names</link> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -5877783338787242018, "content_hash": -5877783338787242018, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id741711128545751\nhelp.text", "note": "ZeyUD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7711, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/112928738/?format=api", "priority": 100, "id": 112929975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2e6deb31f8e07fde", "url": "https://translations.documentfoundation.org/api/units/112929975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.593333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 8910059072576643892, "content_hash": 8910059072576643892, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id531711029933195\nhelp.text", "note": "amnCv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7712, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/112928739/?format=api", "priority": 100, "id": 112929976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=fba6e384dcad6334", "url": "https://translations.documentfoundation.org/api/units/112929976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.594292Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SUMIF(A2:A6,E2,C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -1443753078300397936, "content_hash": -1443753078300397936, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id331711030450765\nhelp.text", "note": "pAzfZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7714, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928741/?format=api", "priority": 100, "id": 112929978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6bf6c23980872e90", "url": "https://translations.documentfoundation.org/api/units/112929978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.596093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents." ], "previous_source": "", "target": [ "" ], "id_hash": 8308122320911959047, "content_hash": 8308122320911959047, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id11711031541218\nhelp.text", "note": "sFiDn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7715, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/112928742/?format=api", "priority": 100, "id": 112929979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f34c613b88738407", "url": "https://translations.documentfoundation.org/api/units/112929979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.596971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF\">SUMIF wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -8292342761969044183, "content_hash": -8292342761969044183, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id771677014538669\nhelp.text", "note": "gyimf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7716, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112928743/?format=api", "priority": 100, "id": 112929980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0cebae31550db529", "url": "https://translations.documentfoundation.org/api/units/112929980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:50:13.597868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/04070400.xhp\">Define Label Range</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 745806529109240621, "content_hash": 745806529109240621, "location": "04070400.xhp", "context": "04070400.xhp\nhd_id3150791\nhelp.text", "note": "WgBoC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4723, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/113178460/?format=api", "priority": 100, "id": 113178479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8a59a31636b92b2d", "url": "https://translations.documentfoundation.org/api/units/113178479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-22T11:50:23.884328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Edits the properties of the sparkline group. The properties apply to all sparklines in the group." ], "previous_source": "", "target": [ "" ], "id_hash": 8768282211305793783, "content_hash": 8768282211305793783, "location": "FormatSparklineMenu.xhp", "context": "FormatSparklineMenu.xhp\npar_id801701562077297\nhelp.text", "note": "F3xGC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5891, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113189908/?format=api", "priority": 100, "id": 113189946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f9af3236ff4228f7", "url": "https://translations.documentfoundation.org/api/units/113189946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-01T02:07:23.040977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Opens the <emph>Sparklines Properties</emph> dialog to define sparkline settings." ], "previous_source": "", "target": [ "" ], "id_hash": 1439769147115236803, "content_hash": 1439769147115236803, "location": "sparklines.xhp", "context": "sparklines.xhp\npar_id401698839153661\nhelp.text", "note": "g3kgb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8233, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113189909/?format=api", "priority": 100, "id": 113189947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=93fb16693c5eedc3", "url": "https://translations.documentfoundation.org/api/units/113189947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-01T02:07:23.256016Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "A number or logical value. A matching cell content equals the number or logical value." ], "previous_source": "", "target": [ "" ], "id_hash": 8122127704362960292, "content_hash": 8122127704362960292, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id171619279059462\nhelp.text", "note": "jQtQq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113202698/?format=api", "priority": 100, "id": 113203003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f0b7981d3ee9c5a4", "url": "https://translations.documentfoundation.org/api/units/113203003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.181943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "A value beginning with a comparator (<emph><</emph>, <emph><=</emph>, <emph>=</emph>, <emph>></emph>, <emph>>=</emph>, <emph><></emph>)." ], "previous_source": "", "target": [ "" ], "id_hash": 7340567712850573898, "content_hash": 7340567712850573898, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id511619279076504\nhelp.text", "note": "eEHxH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113202699/?format=api", "priority": 100, "id": 113203004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e5deef715e28fa4a", "url": "https://translations.documentfoundation.org/api/units/113203004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.185638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "For <emph>=</emph>, if the value is empty it matches empty cells." ], "previous_source": "", "target": [ "" ], "id_hash": -8992990728417598863, "content_hash": -8992990728417598863, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id11619279168512\nhelp.text", "note": "fFaED", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/113202700/?format=api", "priority": 100, "id": 113203005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=03327a945449a271", "url": "https://translations.documentfoundation.org/api/units/113203005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.186793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "For <emph><></emph>, if the value is empty it matches non-empty cells." ], "previous_source": "", "target": [ "" ], "id_hash": 9052876247991250869, "content_hash": 9052876247991250869, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id161619279207350\nhelp.text", "note": "HsEcn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/113202701/?format=api", "priority": 100, "id": 113203006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=fda246fbbd16efb5", "url": "https://translations.documentfoundation.org/api/units/113203006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.187915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "For <emph><></emph>, if the value is not empty it matches any cell content except the value, including empty cells." ], "previous_source": "", "target": [ "" ], "id_hash": -124934913401288217, "content_hash": -124934913401288217, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id271619279215695\nhelp.text", "note": "ACRXm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/113202702/?format=api", "priority": 100, "id": 113203007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7e44245bb2ac09e7", "url": "https://translations.documentfoundation.org/api/units/113203007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.189034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "For <emph>=</emph> and <emph><></emph>, if the value is not empty and can not be interpreted as a number type or one of its subtypes and the property <link href=\"text/shared/optionen/01060500.xhp\">Search criteria <emph>=</emph> and <emph><></emph> must apply to whole cells</link> is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For <emph>=</emph> and <emph><></emph>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies." ], "previous_source": "", "target": [ "" ], "id_hash": 1192473869753466931, "content_hash": 1192473869753466931, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id51619279363954\nhelp.text", "note": "2hiEG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 86, "source_unit": "https://translations.documentfoundation.org/api/units/113202703/?format=api", "priority": 100, "id": 113203008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=908c84aaa2974033", "url": "https://translations.documentfoundation.org/api/units/113203008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.190283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Other Text value. If the property <link href=\"text/shared/optionen/01060500.xhp\">Search criteria <emph>=</emph> and <emph><></emph> must apply to whole cells</link> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\">if enabled in calculation options</link>)." ], "previous_source": "", "target": [ "" ], "id_hash": -1589849070133310911, "content_hash": -1589849070133310911, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id801619279323556\nhelp.text", "note": "iGQae", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 57, "source_unit": "https://translations.documentfoundation.org/api/units/113202704/?format=api", "priority": 100, "id": 113203009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=69efb8b1b0380a41", "url": "https://translations.documentfoundation.org/api/units/113203009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.191503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Generate a list of sequential numbers in an array." ], "previous_source": "", "target": [ "" ], "id_hash": -6242798124648289570, "content_hash": -6242798124648289570, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id771708806478128\nhelp.text", "note": "6fNDF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113202705/?format=api", "priority": 100, "id": 113203010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=295d202e6fdd2ade", "url": "https://translations.documentfoundation.org/api/units/113203010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.316971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Rows</emph>: a positive integer. The number of rows to return." ], "previous_source": "", "target": [ "" ], "id_hash": 2454976934429910441, "content_hash": 2454976934429910441, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id601714592655068\nhelp.text", "note": "CDwFb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113202707/?format=api", "priority": 100, "id": 113203012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a211d483cc78e5a9", "url": "https://translations.documentfoundation.org/api/units/113203012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.319311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Columns</emph>: a positive integer. The number of columns to return." ], "previous_source": "", "target": [ "" ], "id_hash": 2307722559569318300, "content_hash": 2307722559569318300, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id521714592660164\nhelp.text", "note": "G48qz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113202708/?format=api", "priority": 100, "id": 113203013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a006ad70eb48d19c", "url": "https://translations.documentfoundation.org/api/units/113203013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.320301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Start</emph>: optional. The initial value of the sequence. If omitted, default is 1." ], "previous_source": "", "target": [ "" ], "id_hash": -926999271248731669, "content_hash": -926999271248731669, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id171714592664667\nhelp.text", "note": "KNGFY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/113202709/?format=api", "priority": 100, "id": 113203014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7322a313022c61eb", "url": "https://translations.documentfoundation.org/api/units/113203014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.321289Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Step</emph>: optional. The increment of each subsequent value in the array. If omitted, default is 1." ], "previous_source": "", "target": [ "" ], "id_hash": 457523084379426309, "content_hash": 457523084379426309, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id531714592669635\nhelp.text", "note": "CZGrA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113202710/?format=api", "priority": 100, "id": 113203015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=865972d238fa0e05", "url": "https://translations.documentfoundation.org/api/units/113203015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.322285Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If <emph>Rows</emph> and <emph>Columns</emph> are greater than 1, the SEQUENCE function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -6353599120324614087, "content_hash": -6353599120324614087, "location": "func_sequence.xhp", "context": "func_sequence.xhp\npar_id821708357634624\nhelp.text", "note": "J4cjA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/113202711/?format=api", "priority": 100, "id": 113203016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=27d37b434bd12839", "url": "https://translations.documentfoundation.org/api/units/113203016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T02:02:16.323351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/headerfootercontent/HeaderFooterContent\">Defines or formats a header or footer for the page style in use. You can define separate settings for the first page and the remaining pages.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 1750404308428844047, "content_hash": 1750404308428844047, "location": "02120100.xhp", "context": "02120100.xhp\npar_id3150768\nhelp.text", "note": "JxLou", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 52, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/113212281/?format=api", "priority": 100, "id": 113212661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=984aaf71c936ec0f", "url": "https://translations.documentfoundation.org/api/units/113212661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T17:30:29.121255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Header or Footer (first and rest)" ], "previous_source": "", "target": [ "" ], "id_hash": -2030000922189953636, "content_hash": -2030000922189953636, "location": "02120100.xhp", "context": "02120100.xhp\nhd_id311715352188970\nhelp.text", "note": "UGkAn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 53, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/113212282/?format=api", "priority": 100, "id": 113212662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=63d3fceaab27059c", "url": "https://translations.documentfoundation.org/api/units/113212662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T17:30:29.123706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Defines the header or footer settings for the first page or the remaining pages." ], "previous_source": "", "target": [ "" ], "id_hash": 6475450658245443394, "content_hash": 6475450658245443394, "location": "02120100.xhp", "context": "02120100.xhp\npar_id451715352194958\nhelp.text", "note": "DCiEE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 54, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113212283/?format=api", "priority": 100, "id": 113212663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d9dd6c10b549ff42", "url": "https://translations.documentfoundation.org/api/units/113212663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-14T17:30:29.124776Z" } ] }{ "count": 8628, "next": "