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/hye/units/?format=api&page=152
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=153", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=151", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">STYLE</link></variable> function" ], "previous_source": "", "target": [ "" ], "id_hash": -1520579132033131848, "content_hash": -1520579132033131848, "location": "func_style.xhp", "context": "func_style.xhp\nhd_id321673374992325\nhelp.text", "note": "6AhEB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111182391/?format=api", "priority": 100, "id": 112385224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6ae5d155f64b1ab8", "url": "https://translations.documentfoundation.org/api/units/112385224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.430302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Applies a style to the cell containing the formula.</variable></ahelp> After a set amount of time, another style can be applied." ], "previous_source": "", "target": [ "" ], "id_hash": 6065142634155186855, "content_hash": 6065142634155186855, "location": "func_style.xhp", "context": "func_style.xhp\npar_id441673375101757\nhelp.text", "note": "y45sr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111182458/?format=api", "priority": 100, "id": 112385225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d42bb7175ce59aa7", "url": "https://translations.documentfoundation.org/api/units/112385225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.431306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "This function always returns the numeric value 0, which allows to use it by adding the <emph>STYLE</emph> function to other functions in the same cell without changing its value." ], "previous_source": "", "target": [ "" ], "id_hash": 1313034526901143741, "content_hash": 1313034526901143741, "location": "func_style.xhp", "context": "func_style.xhp\npar_id681673375365338\nhelp.text", "note": "GswPt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111182506/?format=api", "priority": 100, "id": 112385226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9238d5f209c408bd", "url": "https://translations.documentfoundation.org/api/units/112385226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.432317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "The STYLE function should not be used without compelling reason, its purpose is the use with asynchronous Add-In functions to visually notify about the availability of a result. In almost all other cases using conditional formatting instead is a better choice." ], "previous_source": "", "target": [ "" ], "id_hash": 4340852398694219373, "content_hash": 4340852398694219373, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1670450904\nhelp.text", "note": "V9E4f", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111182575/?format=api", "priority": 100, "id": 112385227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=bc3dce41fe923e6d", "url": "https://translations.documentfoundation.org/api/units/112385227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.433406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "STYLE(\"Style\" [; Time [; \"Style2\"]])" ], "previous_source": "", "target": [ "" ], "id_hash": 1305044713307895830, "content_hash": 1305044713307895830, "location": "func_style.xhp", "context": "func_style.xhp\npar_id961673376106137\nhelp.text", "note": "m2FBk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111182602/?format=api", "priority": 100, "id": 112385228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=921c734098b7f816", "url": "https://translations.documentfoundation.org/api/units/112385228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.434499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Style</emph> is the name of the cell style to be applied to the cell. Style names are not case-sensitive and must be entered in quotation marks." ], "previous_source": "", "target": [ "" ], "id_hash": 6015326205682868444, "content_hash": 6015326205682868444, "location": "func_style.xhp", "context": "func_style.xhp\npar_id31673375542211\nhelp.text", "note": "NkFMi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111182688/?format=api", "priority": 100, "id": 112385229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d37abb5041d360dc", "url": "https://translations.documentfoundation.org/api/units/112385229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.435530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Time</emph> is an optional time range in seconds. After this time is elapsed, the style defined in <emph>Style2</emph> is applied. Leave this parameter blank if you do not want the style to be changed." ], "previous_source": "", "target": [ "" ], "id_hash": 4574010901924514365, "content_hash": 4574010901924514365, "location": "func_style.xhp", "context": "func_style.xhp\npar_id161673375589532\nhelp.text", "note": "8E46w", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182710/?format=api", "priority": 100, "id": 112385230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=bf7a26ae5ff98a3d", "url": "https://translations.documentfoundation.org/api/units/112385230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.436570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Style2</emph> is the optional name of a cell style assigned to the cell after the time specified in the <emph>Time</emph> parameter has passed. If this parameter is missing the \"Default\" cell style is applied." ], "previous_source": "", "target": [ "" ], "id_hash": 1618184598095757033, "content_hash": 1618184598095757033, "location": "func_style.xhp", "context": "func_style.xhp\npar_id81673375703156\nhelp.text", "note": "aFQCT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182800/?format=api", "priority": 100, "id": 112385231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9674f25186817ee9", "url": "https://translations.documentfoundation.org/api/units/112385231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.437736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" ], "previous_source": "", "target": [ "" ], "id_hash": -4148967812045054790, "content_hash": -4148967812045054790, "location": "func_style.xhp", "context": "func_style.xhp\npar_id971673376620554\nhelp.text", "note": "ryUMD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111182847/?format=api", "priority": 100, "id": 112385232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=466be7c1d2865cba", "url": "https://translations.documentfoundation.org/api/units/112385232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.438886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=10+STYLE(\"Good\",60,\"Neutral\")</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 8774010481600811310, "content_hash": 8774010481600811310, "location": "func_style.xhp", "context": "func_style.xhp\npar_id491673376748686\nhelp.text", "note": "U3hrJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182902/?format=api", "priority": 100, "id": 112385233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f9c38c0bdb5ed12e", "url": "https://translations.documentfoundation.org/api/units/112385233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.439928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Enters the value 10 into the cell and applies the style named \"Good\". After 60 seconds, the style \"Neutral\" is applied." ], "previous_source": "", "target": [ "" ], "id_hash": -1878993523197637285, "content_hash": -1878993523197637285, "location": "func_style.xhp", "context": "func_style.xhp\npar_id11673376842469\nhelp.text", "note": "8deaD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111182918/?format=api", "priority": 100, "id": 112385234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=65ec7958928b8d5b", "url": "https://translations.documentfoundation.org/api/units/112385234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.440946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=A1*A2+STYLE(IF(CURRENT()<100,\"Bad\",\"Good\"))</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 5410722021459901413, "content_hash": 5410722021459901413, "location": "func_style.xhp", "context": "func_style.xhp\npar_id271673376901358\nhelp.text", "note": "UYv4h", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182943/?format=api", "priority": 100, "id": 112385235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=cb16bf02e3803be5", "url": "https://translations.documentfoundation.org/api/units/112385235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.442038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Enters the result of multiplying the values in cells A1 and A2 and applies the style \"Bad\" if the result is less than 100, otherwise the style \"Good\" is applied. Here the function <emph>CURRENT()</emph> is used to get the currently evaluated value of the function in the cell." ], "previous_source": "", "target": [ "" ], "id_hash": -2021632878714423934, "content_hash": -2021632878714423934, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1001673377339392\nhelp.text", "note": "Zt8eb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/111182975/?format=api", "priority": 100, "id": 112385236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=63f1b79b9df9f582", "url": "https://translations.documentfoundation.org/api/units/112385236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.443074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=\"Total\"&T(STYLE(\"Result\"))</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -4503359689536300631, "content_hash": -4503359689536300631, "location": "func_style.xhp", "context": "func_style.xhp\npar_id761673377678426\nhelp.text", "note": "nMoAR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111183065/?format=api", "priority": 100, "id": 112385237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4180da38e16019a9", "url": "https://translations.documentfoundation.org/api/units/112385237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.444148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Enters the text \"Total\" into the cell and applies the style named \"Result\". Note that this example deals with textual values, hence the output of the <emph>STYLE</emph> function needs to be appended to the text using the & operator. The function <emph>T()</emph> is used to prevent the number \"0\" being appended to the resulting text." ], "previous_source": "", "target": [ "" ], "id_hash": -953226345366165529, "content_hash": -953226345366165529, "location": "func_style.xhp", "context": "func_style.xhp\npar_id871673377683120\nhelp.text", "note": "hBUAA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/111183097/?format=api", "priority": 100, "id": 112385238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=72c575b075e7e7e7", "url": "https://translations.documentfoundation.org/api/units/112385238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.445374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE\">STYLE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7002454760026936309, "content_hash": 7002454760026936309, "location": "func_style.xhp", "context": "func_style.xhp\npar_id201677014634447\nhelp.text", "note": "zzt3s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183135/?format=api", "priority": 100, "id": 112385239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e12db780ef2613f5", "url": "https://translations.documentfoundation.org/api/units/112385239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.446790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet Functions</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 7518784913983819571, "content_hash": 7518784913983819571, "location": "func_style.xhp", "context": "func_style.xhp\npar_id631673379195650\nhelp.text", "note": "rEQGK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183168/?format=api", "priority": 100, "id": 112385240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e858170b04924f33", "url": "https://translations.documentfoundation.org/api/units/112385240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.448644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigning Formats by Formula</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 5770525440401091501, "content_hash": 5770525440401091501, "location": "func_style.xhp", "context": "func_style.xhp\npar_id151673379420755\nhelp.text", "note": "VZ5Ga", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111183184/?format=api", "priority": 100, "id": 112385241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d015065082762bad", "url": "https://translations.documentfoundation.org/api/units/112385241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.450924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">CURRENT function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2897871533713709166, "content_hash": -2897871533713709166, "location": "func_style.xhp", "context": "func_style.xhp\npar_id461673376361959\nhelp.text", "note": "YADMA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183206/?format=api", "priority": 100, "id": 112385242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=57c8b13194472792", "url": "https://translations.documentfoundation.org/api/units/112385242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.452905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#t\">T function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 5689967768727522419, "content_hash": 5689967768727522419, "location": "func_style.xhp", "context": "func_style.xhp\npar_id381673378944042\nhelp.text", "note": "L6tnb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183242/?format=api", "priority": 100, "id": 112385243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=cef6d389f66d0c73", "url": "https://translations.documentfoundation.org/api/units/112385243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.454689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "SUM Function" ], "previous_source": "", "target": [ "" ], "id_hash": -835747380684224227, "content_hash": -835747380684224227, "location": "func_sum.xhp", "context": "func_sum.xhp\ntit\nhelp.text", "note": "mEZBk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183270/?format=api", "priority": 100, "id": 112385244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7466d42f6c5a891d", "url": "https://translations.documentfoundation.org/api/units/112385244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.456218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<bookmark_value>SUM function</bookmark_value> <bookmark_value>adding;numbers in cell ranges</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6085024028718732676, "content_hash": 6085024028718732676, "location": "func_sum.xhp", "context": "func_sum.xhp\nid431636401649762\nhelp.text", "note": "fLyVA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183290/?format=api", "priority": 100, "id": 112385245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d472591d417f1584", "url": "https://translations.documentfoundation.org/api/units/112385245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.457313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"sum_head\"><link href=\"text/scalc/01/func_sum.xhp\">SUM</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -2868028676740648335, "content_hash": -2868028676740648335, "location": "func_sum.xhp", "context": "func_sum.xhp\nhd_id121636398275790\nhelp.text", "note": "jDti4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183311/?format=api", "priority": 100, "id": 112385246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5832b71d2d3d7271", "url": "https://translations.documentfoundation.org/api/units/112385246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.458797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"func_sum_desc\"><ahelp hid=\".\">Adds a set of numbers.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5625976177105928921, "content_hash": -5625976177105928921, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id491636401806866\nhelp.text", "note": "c32xJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111183348/?format=api", "priority": 100, "id": 112385247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=31ec847980ca7d27", "url": "https://translations.documentfoundation.org/api/units/112385247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.460293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": -1464919939241204293, "content_hash": -1464919939241204293, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163656\nhelp.text", "note": "vfwu7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183361/?format=api", "priority": 100, "id": 112385248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6bab8f13a52425bb", "url": "https://translations.documentfoundation.org/api/units/112385248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.461697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=SUM(2;3;4)</input> returns 9." ], "previous_source": "", "target": [ "" ], "id_hash": -6946537612386304541, "content_hash": -6946537612386304541, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163704\nhelp.text", "note": "h8z3Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183381/?format=api", "priority": 100, "id": 112385249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1f98f0d88ad2fde3", "url": "https://translations.documentfoundation.org/api/units/112385249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.463225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUM(A1;A3;B5)</item> calculates the sum of the three cells." ], "previous_source": "", "target": [ "" ], "id_hash": 652939789567612619, "content_hash": 652939789567612619, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151740\nhelp.text", "note": "6ohPR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111183404/?format=api", "priority": 100, "id": 112385250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=890fb54778e556cb", "url": "https://translations.documentfoundation.org/api/units/112385250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.464997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUM(A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range." ], "previous_source": "", "target": [ "" ], "id_hash": -3872165459397171147, "content_hash": -3872165459397171147, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id931636109030406\nhelp.text", "note": "FbQ6a", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111183420/?format=api", "priority": 100, "id": 112385251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4a434e07c1182835", "url": "https://translations.documentfoundation.org/api/units/112385251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.466659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "A formula such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link> by pressing the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum." ], "previous_source": "", "target": [ "" ], "id_hash": -8203016005970044413, "content_hash": -8203016005970044413, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151756\nhelp.text", "note": "UmyxD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111183456/?format=api", "priority": 100, "id": 112385252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0e2908676d4fda03", "url": "https://translations.documentfoundation.org/api/units/112385252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.468150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 4469010790866011402, "content_hash": 4469010790866011402, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id771677014538669\nhelp.text", "note": "KohAT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183524/?format=api", "priority": 100, "id": 112385253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=be051da2eef4c50a", "url": "https://translations.documentfoundation.org/api/units/112385253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.469658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "SUMIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": -3540436716313482577, "content_hash": -3540436716313482577, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\ntit\nhelp.text", "note": "DfceH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183542/?format=api", "priority": 100, "id": 112385254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4eddd79086626aaf", "url": "https://translations.documentfoundation.org/api/units/112385254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.470778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2704983415798147745, "content_hash": -2704983415798147745, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nbm_id658066580665806\nhelp.text", "note": "jDeBL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183560/?format=api", "priority": 100, "id": 112385255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5a75f7ea3a07555f", "url": "https://translations.documentfoundation.org/api/units/112385255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.471809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -3689655749840634933, "content_hash": -3689655749840634933, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id658866588665886\nhelp.text", "note": "MpUwQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183561/?format=api", "priority": 100, "id": 112385256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4ccbb5a4e7457bcb", "url": "https://translations.documentfoundation.org/api/units/112385256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.472866Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 9169675903449353869, "content_hash": 9169675903449353869, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id659756597565975\nhelp.text", "note": "ZEdvF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111183599/?format=api", "priority": 100, "id": 112385257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ff413ba6b28ece8d", "url": "https://translations.documentfoundation.org/api/units/112385257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.473864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": 8486374903425621466, "content_hash": 8486374903425621466, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id11655988824213\nhelp.text", "note": "xhKwv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183620/?format=api", "priority": 100, "id": 112385258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f5c5a9030d795dda", "url": "https://translations.documentfoundation.org/api/units/112385258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.474894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." ], "previous_source": "", "target": [ "" ], "id_hash": -3181281400957303016, "content_hash": -3181281400957303016, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id59901690530236\nhelp.text", "note": "mP5Et", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/111183656/?format=api", "priority": 100, "id": 112385259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=53d9d16bc5620718", "url": "https://translations.documentfoundation.org/api/units/112385259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.475955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": 100979218881927587, "content_hash": 100979218881927587, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id193452436229521\nhelp.text", "note": "zahGz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183688/?format=api", "priority": 100, "id": 112385260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8166c010872759a3", "url": "https://translations.documentfoundation.org/api/units/112385260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.476965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -3980841953204373942, "content_hash": -3980841953204373942, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id94321051525036\nhelp.text", "note": "tqgKL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183724/?format=api", "priority": 100, "id": 112385261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/112385261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.477870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111183777/?format=api", "priority": 100, "id": 112385262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/112385262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.478793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -9075336950328213574, "content_hash": -9075336950328213574, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id36952767622741\nhelp.text", "note": "TzCFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183820/?format=api", "priority": 100, "id": 112385263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/112385263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.479822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/111183870/?format=api", "priority": 100, "id": 112385264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/112385264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.480874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183913/?format=api", "priority": 100, "id": 112385265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/112385265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.482125Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183957/?format=api", "priority": 100, "id": 112385266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/112385266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.483614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111184004/?format=api", "priority": 100, "id": 112385267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/112385267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.484784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184009/?format=api", "priority": 100, "id": 112385268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/112385268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.486035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Calculates the sum 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 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "" ], "id_hash": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111184010/?format=api", "priority": 100, "id": 112385269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/112385269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.487403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111184011/?format=api", "priority": 100, "id": 112385270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/112385270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.488883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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 SUMIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111184012/?format=api", "priority": 100, "id": 112385271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/112385271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.490122Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184013/?format=api", "priority": 100, "id": 112385272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/112385272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.491419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111184014/?format=api", "priority": 100, "id": 112385273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/112385273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:44.492648Z" } ] }{ "count": 8439, "next": "