Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=146
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=147", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=145", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">JIS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 2039448152051293608, "content_hash": 2039448152051293608, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id801677015502335\nhelp.text", "note": "jqAPC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111171966/?format=api", "priority": 100, "id": 112359607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9c4d9349f0d81da8", "url": "https://translations.documentfoundation.org/api/units/112359607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.502903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MAXIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": -2449898255212847766, "content_hash": -2449898255212847766, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\ntit\nhelp.text", "note": "Cauxq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172032/?format=api", "priority": 100, "id": 112359608, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5e0036845a305d6a", "url": "https://translations.documentfoundation.org/api/units/112359608/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.504025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3340120921755827711, "content_hash": -3340120921755827711, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nbm_id658066580665806\nhelp.text", "note": "8HdEW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172101/?format=api", "priority": 100, "id": 112359609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=51a581b7e7e4c201", "url": "https://translations.documentfoundation.org/api/units/112359609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.504988Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" ], "previous_source": "", "target": [ "" ], "id_hash": -1324032980930569323, "content_hash": -1324032980930569323, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id658866588665886\nhelp.text", "note": "kKHTn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172123/?format=api", "priority": 100, "id": 112359610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6da01704d4bb5b95", "url": "https://translations.documentfoundation.org/api/units/112359610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.506028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -7080741019089367299, "content_hash": -7080741019089367299, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id659756597565975\nhelp.text", "note": "DXshy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172186/?format=api", "priority": 100, "id": 112359611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1dbc278efaa40efd", "url": "https://translations.documentfoundation.org/api/units/112359611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.507203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": -4696446051791201984, "content_hash": -4696446051791201984, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id11655988824213\nhelp.text", "note": "PKmRh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172220/?format=api", "priority": 100, "id": 112359612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3ed2df32e0331940", "url": "https://translations.documentfoundation.org/api/units/112359612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.508458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." ], "previous_source": "", "target": [ "" ], "id_hash": 2724450032633823262, "content_hash": 2724450032633823262, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id59901690530236\nhelp.text", "note": "UrwgE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172229/?format=api", "priority": 100, "id": 112359613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a5cf30deb370c01e", "url": "https://translations.documentfoundation.org/api/units/112359613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.509742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -5218410125489394970, "content_hash": -5218410125489394970, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id193452436229521\nhelp.text", "note": "BUavo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172272/?format=api", "priority": 100, "id": 112359614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=37947ba3a1e72ae6", "url": "https://translations.documentfoundation.org/api/units/112359614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.511197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 3417653096642167929, "content_hash": 3417653096642167929, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id94321051525036\nhelp.text", "note": "8CyiM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172306/?format=api", "priority": 100, "id": 112359615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=af6df16246dec479", "url": "https://translations.documentfoundation.org/api/units/112359615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.512607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -5025962791241282951, "content_hash": -5025962791241282951, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id28647227259438\nhelp.text", "note": "j2PKY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111172330/?format=api", "priority": 100, "id": 112359616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3a40317855bb8a79", "url": "https://translations.documentfoundation.org/api/units/112359616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.514579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -4882410858544181930, "content_hash": -4882410858544181930, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id36952767622741\nhelp.text", "note": "c6yAQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172361/?format=api", "priority": 100, "id": 112359617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3c3e313138f6cd56", "url": "https://translations.documentfoundation.org/api/units/112359617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.517042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -6133095175833196497, "content_hash": -6133095175833196497, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id189772445525114\nhelp.text", "note": "nGj4o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111172395/?format=api", "priority": 100, "id": 112359618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2ae2de6e9ecce82f", "url": "https://translations.documentfoundation.org/api/units/112359618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.518756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": 7310294577384814773, "content_hash": 7310294577384814773, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id30455222431067\nhelp.text", "note": "9Ayop", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111172431/?format=api", "priority": 100, "id": 112359619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e573622fc07c78b5", "url": "https://translations.documentfoundation.org/api/units/112359619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.519820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5335659071310958503, "content_hash": -5335659071310958503, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id307691022525348\nhelp.text", "note": "LNubZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172446/?format=api", "priority": 100, "id": 112359620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=35f3ee581beb7059", "url": "https://translations.documentfoundation.org/api/units/112359620/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.520789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 2728227791290826569, "content_hash": 2728227791290826569, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id27619246864839\nhelp.text", "note": "CR2To", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/111172484/?format=api", "priority": 100, "id": 112359621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a5dc9cb8ae3cff49", "url": "https://translations.documentfoundation.org/api/units/112359621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.521755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 158249065123773810, "content_hash": 158249065123773810, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id220502883332563\nhelp.text", "note": "xriFt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172524/?format=api", "priority": 100, "id": 112359622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=823236afb0bd7d72", "url": "https://translations.documentfoundation.org/api/units/112359622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.522782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." ], "previous_source": "", "target": [ "" ], "id_hash": -3964634836356299185, "content_hash": -3964634836356299185, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id15342189586295\nhelp.text", "note": "FQicN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172542/?format=api", "priority": 100, "id": 112359623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=48fac99f32d8064f", "url": "https://translations.documentfoundation.org/api/units/112359623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.523774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 975754287595702701, "content_hash": 975754287595702701, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id8168283329426\nhelp.text", "note": "DwLDF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111172674/?format=api", "priority": 100, "id": 112359624, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8d8a935ad434c9ad", "url": "https://translations.documentfoundation.org/api/units/112359624/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.524733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": 5584486400786439957, "content_hash": 5584486400786439957, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id50762995519951\nhelp.text", "note": "9BMGq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172707/?format=api", "priority": 100, "id": 112359625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cd8014cb2be01f15", "url": "https://translations.documentfoundation.org/api/units/112359625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.525729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -8528842879162885577, "content_hash": -8528842879162885577, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id135761606425300\nhelp.text", "note": "gcYDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172745/?format=api", "priority": 100, "id": 112359626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=09a37696d2605a37", "url": "https://translations.documentfoundation.org/api/units/112359626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.526810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -722999157949055427, "content_hash": -722999157949055427, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id30574750215839\nhelp.text", "note": "wHPFq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172771/?format=api", "priority": 100, "id": 112359627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=75f76418b18a3e3d", "url": "https://translations.documentfoundation.org/api/units/112359627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.527841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS\">MAXIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -4761749996077925314, "content_hash": -4761749996077925314, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id401677015482616\nhelp.text", "note": "defwR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172786/?format=api", "priority": 100, "id": 112359628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3deadd9b7e8ebc3e", "url": "https://translations.documentfoundation.org/api/units/112359628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.528844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": 7812476771991873893, "content_hash": 7812476771991873893, "location": "func_minifs.xhp", "context": "func_minifs.xhp\ntit\nhelp.text", "note": "zGQnQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172791/?format=api", "priority": 100, "id": 112359629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ec6b7e3b5a90e965", "url": "https://translations.documentfoundation.org/api/units/112359629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.529850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1093582569723425218, "content_hash": -1093582569723425218, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nbm_id658066580665806\nhelp.text", "note": "V8Fu7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172844/?format=api", "priority": 100, "id": 112359630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=70d2d07267138e3e", "url": "https://translations.documentfoundation.org/api/units/112359630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.530845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" ], "previous_source": "", "target": [ "" ], "id_hash": -6433400122557603538, "content_hash": -6433400122557603538, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id658866588665886\nhelp.text", "note": "vnegG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172893/?format=api", "priority": 100, "id": 112359631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=26b7f8ac94ffe12e", "url": "https://translations.documentfoundation.org/api/units/112359631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.531885Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -841053936576294524, "content_hash": -841053936576294524, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id659756597565975\nhelp.text", "note": "PmaDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172923/?format=api", "priority": 100, "id": 112359632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7453f9e6996d1184", "url": "https://translations.documentfoundation.org/api/units/112359632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.532982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": 8859664611740713808, "content_hash": 8859664611740713808, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id11655988824213\nhelp.text", "note": "yekSJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172946/?format=api", "priority": 100, "id": 112359633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=faf3da061be78350", "url": "https://translations.documentfoundation.org/api/units/112359633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.534234Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." ], "previous_source": "", "target": [ "" ], "id_hash": 284793519782481500, "content_hash": 284793519782481500, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id59901690530236\nhelp.text", "note": "Gf5P2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172971/?format=api", "priority": 100, "id": 112359634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=83f3ca3284f7ce5c", "url": "https://translations.documentfoundation.org/api/units/112359634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.535259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -6681775116397015665, "content_hash": -6681775116397015665, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id193452436229521\nhelp.text", "note": "KkDwL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172976/?format=api", "priority": 100, "id": 112359635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=234590eee61c8d8f", "url": "https://translations.documentfoundation.org/api/units/112359635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.536272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2823450842571719474, "content_hash": 2823450842571719474, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id94321051525036\nhelp.text", "note": "TGRCF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172977/?format=api", "priority": 100, "id": 112359636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a72ee9950043c332", "url": "https://translations.documentfoundation.org/api/units/112359636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.537279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." ], "previous_source": "", "target": [ "" ], "id_hash": 8689637701657927848, "content_hash": 8689637701657927848, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id28647227259438\nhelp.text", "note": "eRNbh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172978/?format=api", "priority": 100, "id": 112359637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f897cb733229a0a8", "url": "https://translations.documentfoundation.org/api/units/112359637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.538261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 8274293814976130446, "content_hash": 8274293814976130446, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id36952767622741\nhelp.text", "note": "zufoC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172979/?format=api", "priority": 100, "id": 112359638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f2d43262b8dd2d8e", "url": "https://translations.documentfoundation.org/api/units/112359638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.539292Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 8479070192479725407, "content_hash": 8479070192479725407, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id189772445525114\nhelp.text", "note": "iCk4M", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111172980/?format=api", "priority": 100, "id": 112359639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f5abb56a805b675f", "url": "https://translations.documentfoundation.org/api/units/112359639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.540346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": 3935808270846501747, "content_hash": 3935808270846501747, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id30455222431067\nhelp.text", "note": "iqFXq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111173071/?format=api", "priority": 100, "id": 112359640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b69eccc4ffd9a373", "url": "https://translations.documentfoundation.org/api/units/112359640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.541387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 5059510094262033099, "content_hash": 5059510094262033099, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id307691022525348\nhelp.text", "note": "CBaMz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173119/?format=api", "priority": 100, "id": 112359641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c636fd9fd1fddacb", "url": "https://translations.documentfoundation.org/api/units/112359641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.542345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65." ], "previous_source": "", "target": [ "" ], "id_hash": -4181087204647800947, "content_hash": -4181087204647800947, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id27619246864839\nhelp.text", "note": "Dp4Sx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111173174/?format=api", "priority": 100, "id": 112359642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=45f9cb56f8096f8d", "url": "https://translations.documentfoundation.org/api/units/112359642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.543335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2524283094541941754, "content_hash": 2524283094541941754, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id220502883332563\nhelp.text", "note": "7S443", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173196/?format=api", "priority": 100, "id": 112359643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/112359643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.544454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 1511293224466033220, "content_hash": 1511293224466033220, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id15342189586295\nhelp.text", "note": "gNhzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111173197/?format=api", "priority": 100, "id": 112359644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/112359644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.545731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 562770679139324109, "content_hash": 562770679139324109, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id8168283329426\nhelp.text", "note": "uz4wr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111173198/?format=api", "priority": 100, "id": 112359645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=87cf5cf3741ad0cd", "url": "https://translations.documentfoundation.org/api/units/112359645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.547158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -6961485744941843957, "content_hash": -6961485744941843957, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id50762995519951\nhelp.text", "note": "27hDw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111173199/?format=api", "priority": 100, "id": 112359646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1f63d59937cbba0b", "url": "https://translations.documentfoundation.org/api/units/112359646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.549363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -4878672984956085105, "content_hash": -4878672984956085105, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id135761606425300\nhelp.text", "note": "EcoDf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173200/?format=api", "priority": 100, "id": 112359647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3c4b78c4bc65dc8f", "url": "https://translations.documentfoundation.org/api/units/112359647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.551088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -7124754506057414550, "content_hash": -7124754506057414550, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id30574750215839\nhelp.text", "note": "cxmqK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173201/?format=api", "priority": 100, "id": 112359648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1d1fc9867a95886a", "url": "https://translations.documentfoundation.org/api/units/112359648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.552842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">MINIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -4642634868378127656, "content_hash": -4642634868378127656, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id941677015454359\nhelp.text", "note": "zBVgq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173202/?format=api", "priority": 100, "id": 112359649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3f920c2f587ab2d8", "url": "https://translations.documentfoundation.org/api/units/112359649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.554244Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINUTE" ], "previous_source": "", "target": [ "" ], "id_hash": 6583649393914450800, "content_hash": 6583649393914450800, "location": "func_minute.xhp", "context": "func_minute.xhp\ntit\nhelp.text", "note": "SAxB8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173225/?format=api", "priority": 100, "id": 112359650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=db5dd23df9fc9370", "url": "https://translations.documentfoundation.org/api/units/112359650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.555315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MINUTE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6674063580216568736, "content_hash": 6674063580216568736, "location": "func_minute.xhp", "context": "func_minute.xhp\nbm_id3149803\nhelp.text", "note": "7cQwC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173282/?format=api", "priority": 100, "id": 112359651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dc9f09772b2e2ba0", "url": "https://translations.documentfoundation.org/api/units/112359651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.556367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6278203477099020855, "content_hash": -6278203477099020855, "location": "func_minute.xhp", "context": "func_minute.xhp\nhd_id3149803\nhelp.text", "note": "aFbYG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111173324/?format=api", "priority": 100, "id": 112359652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=28df57336fe3fdc9", "url": "https://translations.documentfoundation.org/api/units/112359652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.557452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59." ], "previous_source": "", "target": [ "" ], "id_hash": 3800930512976531485, "content_hash": 3800930512976531485, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148988\nhelp.text", "note": "kGsA6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111173366/?format=api", "priority": 100, "id": 112359653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b4bf9e29d1e8d01d", "url": "https://translations.documentfoundation.org/api/units/112359653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.558570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINUTE(Number)" ], "previous_source": "", "target": [ "" ], "id_hash": -2617622125915151773, "content_hash": -2617622125915151773, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148660\nhelp.text", "note": "LeQE8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173367/?format=api", "priority": 100, "id": 112359654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5bac568b949fe263", "url": "https://translations.documentfoundation.org/api/units/112359654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.559893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned." ], "previous_source": "", "target": [ "" ], "id_hash": 316469162102282401, "content_hash": 316469162102282401, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3154611\nhelp.text", "note": "8eGft", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173393/?format=api", "priority": 100, "id": 112359655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=84645306b578d8a1", "url": "https://translations.documentfoundation.org/api/units/112359655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.561091Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.999)</item> returns 58" ], "previous_source": "", "target": [ "" ], "id_hash": -4031844472942077863, "content_hash": -4031844472942077863, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148463\nhelp.text", "note": "L77op", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173418/?format=api", "priority": 100, "id": 112359656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=480c02d040aa5859", "url": "https://translations.documentfoundation.org/api/units/112359656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.562452Z" } ] }{ "count": 8439, "next": "