Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=144
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=145", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=143", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> is the internal date number." ], "previous_source": "", "target": [ "El <emph>númberu</emph> correspuende al númberu internu de la fecha." ], "id_hash": -1028852632776909961, "content_hash": -1028852632776909961, "location": "func_isoweeknum.xhp", "context": "func_isoweeknum.xhp\npar_id3147511\nhelp.text", "note": "SneoF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99322873/?format=api", "priority": 100, "id": 99530577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=71b8c7fb491b5b77", "url": "https://translations.documentfoundation.org/api/units/99530577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.370065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ISOWEEKNUM(DATE(1995;1;1))</item> returns 52. Week 1 starts on Monday, 1995-01-02." ], "previous_source": "", "target": [ "" ], "id_hash": -1648942822929675803, "content_hash": -1648942822929675803, "location": "func_isoweeknum.xhp", "context": "func_isoweeknum.xhp\npar_id3149792\nhelp.text", "note": "4f8kJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99322874/?format=api", "priority": 100, "id": 99530581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=691dc73d3058c9e5", "url": "https://translations.documentfoundation.org/api/units/99530581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.371850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ISOWEEKNUM(DATE(1999;1;1))</item> returns 53. Week 1 starts on Monday, 1999-01-04." ], "previous_source": "", "target": [ "" ], "id_hash": 458443577839507361, "content_hash": 458443577839507361, "location": "func_isoweeknum.xhp", "context": "func_isoweeknum.xhp\npar_id3149794\nhelp.text", "note": "AMrEN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99322875/?format=api", "priority": 100, "id": 99530584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=865cb8014eaed7a1", "url": "https://translations.documentfoundation.org/api/units/99530584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.373245Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISOWEEKNUM\">ISOWEEKNUM wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -7460904711201333809, "content_hash": -7460904711201333809, "location": "func_isoweeknum.xhp", "context": "func_isoweeknum.xhp\npar_id361677015520799\nhelp.text", "note": "QmAho", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99322876/?format=api", "priority": 100, "id": 99530588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=18758ab1d9ce5dcf", "url": "https://translations.documentfoundation.org/api/units/99530588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.374574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "JIS Function" ], "previous_source": "", "target": [ "" ], "id_hash": 7057626728066740893, "content_hash": 7057626728066740893, "location": "func_jis.xhp", "context": "func_jis.xhp\ntit\nhelp.text", "note": "CB8Vn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99322877/?format=api", "priority": 100, "id": 99530591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e1f1ba1dc3b8729d", "url": "https://translations.documentfoundation.org/api/units/99530591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.375882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>JIS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3563936801635725437, "content_hash": -3563936801635725437, "location": "func_jis.xhp", "context": "func_jis.xhp\nbm_id831542233029549\nhelp.text", "note": "5Qavf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99322878/?format=api", "priority": 100, "id": 99530595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4e8a5a5c888f8f83", "url": "https://translations.documentfoundation.org/api/units/99530595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.377127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"Jis_h1\"><link href=\"text/scalc/01/func_jis.xhp\">JIS</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 7591514567420430778, "content_hash": 7591514567420430778, "location": "func_jis.xhp", "context": "func_jis.xhp\nhd_id881628776094597\nhelp.text", "note": "v8tni", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99322879/?format=api", "priority": 100, "id": 99530599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e95a7a470a4c49ba", "url": "https://translations.documentfoundation.org/api/units/99530599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.378526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"func_jis_desc\"><ahelp hid=\".\">Converts single-byte (half-width) ASCII or katakana characters to double-byte (full-width) characters.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 6214237881509134202, "content_hash": 6214237881509134202, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id541542230672101\nhelp.text", "note": "3XKQ3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99322880/?format=api", "priority": 100, "id": 99530603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d63d686dc520bf7a", "url": "https://translations.documentfoundation.org/api/units/99530603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.379794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." ], "previous_source": "", "target": [ "" ], "id_hash": 6317124298538348084, "content_hash": 6317124298538348084, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id151634221012221\nhelp.text", "note": "iDoUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99322881/?format=api", "priority": 100, "id": 99530605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d7aaef14785dee34", "url": "https://translations.documentfoundation.org/api/units/99530605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.381063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>JIS(Text)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 5584603384776652790, "content_hash": 5584603384776652790, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id701542231253817\nhelp.text", "note": "AjjnX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99322882/?format=api", "priority": 100, "id": 99530609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cd807f30a10e77f6", "url": "https://translations.documentfoundation.org/api/units/99530609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.382290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Text</emph>: the text string that contains characters to be converted." ], "previous_source": "", "target": [ "" ], "id_hash": 5398048392791212936, "content_hash": 5398048392791212936, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id621542232197446\nhelp.text", "note": "f9YAh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99322883/?format=api", "priority": 100, "id": 99530613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cae9b869c4b04388", "url": "https://translations.documentfoundation.org/api/units/99530613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.383460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Applying the JIS function to a string composed of double-byte characters will return the input string without any modifications." ], "previous_source": "", "target": [ "" ], "id_hash": -3680525441438024042, "content_hash": -3680525441438024042, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id481637763523789\nhelp.text", "note": "b289j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99322899/?format=api", "priority": 100, "id": 99530617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4cec259c7c4c7e96", "url": "https://translations.documentfoundation.org/api/units/99530617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.384684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=JIS(\"LibreOffice\")</input> returns the string \"ＬｉｂｒｅＯｆｆｉｃｅ\". Note that the returned string uses double-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": -3426965960520570276, "content_hash": -3426965960520570276, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id451628776707264\nhelp.text", "note": "BBEVj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99322928/?format=api", "priority": 100, "id": 99530619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5070f89da1d0ea5c", "url": "https://translations.documentfoundation.org/api/units/99530619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.385984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=JIS(\"ﾗｲﾄ\")</input> returns the string \"ライト\", which is composed of double-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": -186225817581584923, "content_hash": -186225817581584923, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id101628778036375\nhelp.text", "note": "fEFNT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99322959/?format=api", "priority": 100, "id": 99530622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7d6a649b070afde5", "url": "https://translations.documentfoundation.org/api/units/99530622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.387343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99323000/?format=api", "priority": 100, "id": 99530626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c4d9349f0d81da8", "url": "https://translations.documentfoundation.org/api/units/99530626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.388703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323030/?format=api", "priority": 100, "id": 99530630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5e0036845a305d6a", "url": "https://translations.documentfoundation.org/api/units/99530630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.389943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99323033/?format=api", "priority": 100, "id": 99530633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51a581b7e7e4c201", "url": "https://translations.documentfoundation.org/api/units/99530633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.391156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7168, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99323034/?format=api", "priority": 100, "id": 99530636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6da01704d4bb5b95", "url": "https://translations.documentfoundation.org/api/units/99530636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.392437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99323123/?format=api", "priority": 100, "id": 99530640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1dbc278efaa40efd", "url": "https://translations.documentfoundation.org/api/units/99530640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.393761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7170, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99323218/?format=api", "priority": 100, "id": 99530644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3ed2df32e0331940", "url": "https://translations.documentfoundation.org/api/units/99530644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.395102Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7171, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99323275/?format=api", "priority": 100, "id": 99530648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a5cf30deb370c01e", "url": "https://translations.documentfoundation.org/api/units/99530648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.396460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323332/?format=api", "priority": 100, "id": 99530651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=37947ba3a1e72ae6", "url": "https://translations.documentfoundation.org/api/units/99530651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.397616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323361/?format=api", "priority": 100, "id": 99530654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=af6df16246dec479", "url": "https://translations.documentfoundation.org/api/units/99530654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.398915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99323410/?format=api", "priority": 100, "id": 99530656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3a40317855bb8a79", "url": "https://translations.documentfoundation.org/api/units/99530656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.400239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323448/?format=api", "priority": 100, "id": 99530660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3c3e313138f6cd56", "url": "https://translations.documentfoundation.org/api/units/99530660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.401791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99323488/?format=api", "priority": 100, "id": 99530664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2ae2de6e9ecce82f", "url": "https://translations.documentfoundation.org/api/units/99530664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.403167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99323546/?format=api", "priority": 100, "id": 99530668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e573622fc07c78b5", "url": "https://translations.documentfoundation.org/api/units/99530668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.404612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323617/?format=api", "priority": 100, "id": 99530673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=35f3ee581beb7059", "url": "https://translations.documentfoundation.org/api/units/99530673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.406002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99323696/?format=api", "priority": 100, "id": 99530677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a5dc9cb8ae3cff49", "url": "https://translations.documentfoundation.org/api/units/99530677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.407483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323730/?format=api", "priority": 100, "id": 99530681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=823236afb0bd7d72", "url": "https://translations.documentfoundation.org/api/units/99530681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.408970Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99323775/?format=api", "priority": 100, "id": 99530686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=48fac99f32d8064f", "url": "https://translations.documentfoundation.org/api/units/99530686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.410400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99323833/?format=api", "priority": 100, "id": 99530690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8d8a935ad434c9ad", "url": "https://translations.documentfoundation.org/api/units/99530690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.411762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99323879/?format=api", "priority": 100, "id": 99530704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cd8014cb2be01f15", "url": "https://translations.documentfoundation.org/api/units/99530704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.525568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99323918/?format=api", "priority": 100, "id": 99530711, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=09a37696d2605a37", "url": "https://translations.documentfoundation.org/api/units/99530711/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.530154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99323940/?format=api", "priority": 100, "id": 99530718, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=75f76418b18a3e3d", "url": "https://translations.documentfoundation.org/api/units/99530718/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.535820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7186, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99323961/?format=api", "priority": 100, "id": 99530721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3deadd9b7e8ebc3e", "url": "https://translations.documentfoundation.org/api/units/99530721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.538752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7187, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324043/?format=api", "priority": 100, "id": 99530732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ec6b7e3b5a90e965", "url": "https://translations.documentfoundation.org/api/units/99530732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.551489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324074/?format=api", "priority": 100, "id": 99530737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=70d2d07267138e3e", "url": "https://translations.documentfoundation.org/api/units/99530737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.555459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99324095/?format=api", "priority": 100, "id": 99530743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=26b7f8ac94ffe12e", "url": "https://translations.documentfoundation.org/api/units/99530743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.559492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7190, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99324120/?format=api", "priority": 100, "id": 99530745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7453f9e6996d1184", "url": "https://translations.documentfoundation.org/api/units/99530745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.561041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99324147/?format=api", "priority": 100, "id": 99530752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=faf3da061be78350", "url": "https://translations.documentfoundation.org/api/units/99530752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.565149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99324165/?format=api", "priority": 100, "id": 99530759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=83f3ca3284f7ce5c", "url": "https://translations.documentfoundation.org/api/units/99530759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.569060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324183/?format=api", "priority": 100, "id": 99530767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=234590eee61c8d8f", "url": "https://translations.documentfoundation.org/api/units/99530767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.573283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324210/?format=api", "priority": 100, "id": 99530769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a72ee9950043c332", "url": "https://translations.documentfoundation.org/api/units/99530769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.574715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99324236/?format=api", "priority": 100, "id": 99530773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f897cb733229a0a8", "url": "https://translations.documentfoundation.org/api/units/99530773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.577527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7196, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324248/?format=api", "priority": 100, "id": 99530783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f2d43262b8dd2d8e", "url": "https://translations.documentfoundation.org/api/units/99530783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.582500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99324254/?format=api", "priority": 100, "id": 99530788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f5abb56a805b675f", "url": "https://translations.documentfoundation.org/api/units/99530788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.585495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7198, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99324270/?format=api", "priority": 100, "id": 99530794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b69eccc4ffd9a373", "url": "https://translations.documentfoundation.org/api/units/99530794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.588064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99324302/?format=api", "priority": 100, "id": 99530800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c636fd9fd1fddacb", "url": "https://translations.documentfoundation.org/api/units/99530800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.591825Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 7200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99324329/?format=api", "priority": 100, "id": 99530815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=45f9cb56f8096f8d", "url": "https://translations.documentfoundation.org/api/units/99530815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.715296Z" } ] }