Units

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 8439,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=153",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=151",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435858,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6ae5d155f64b1ab8",
            "url": "https://translations.documentfoundation.org/api/units/112435858/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:28.915834Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435859,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d42bb7175ce59aa7",
            "url": "https://translations.documentfoundation.org/api/units/112435859/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.256776Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435860,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9238d5f209c408bd",
            "url": "https://translations.documentfoundation.org/api/units/112435860/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.259234Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435861,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bc3dce41fe923e6d",
            "url": "https://translations.documentfoundation.org/api/units/112435861/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.260839Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435862,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=921c734098b7f816",
            "url": "https://translations.documentfoundation.org/api/units/112435862/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.262327Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435863,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d37abb5041d360dc",
            "url": "https://translations.documentfoundation.org/api/units/112435863/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.263622Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435864,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bf7a26ae5ff98a3d",
            "url": "https://translations.documentfoundation.org/api/units/112435864/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.264592Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435865,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9674f25186817ee9",
            "url": "https://translations.documentfoundation.org/api/units/112435865/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.265568Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435866,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=466be7c1d2865cba",
            "url": "https://translations.documentfoundation.org/api/units/112435866/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.266541Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435867,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f9c38c0bdb5ed12e",
            "url": "https://translations.documentfoundation.org/api/units/112435867/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.268206Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435868,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=65ec7958928b8d5b",
            "url": "https://translations.documentfoundation.org/api/units/112435868/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.269563Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435869,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cb16bf02e3803be5",
            "url": "https://translations.documentfoundation.org/api/units/112435869/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.273157Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435870,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=63f1b79b9df9f582",
            "url": "https://translations.documentfoundation.org/api/units/112435870/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.274477Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435871,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4180da38e16019a9",
            "url": "https://translations.documentfoundation.org/api/units/112435871/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.275567Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435872,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=72c575b075e7e7e7",
            "url": "https://translations.documentfoundation.org/api/units/112435872/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.276629Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435873,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e12db780ef2613f5",
            "url": "https://translations.documentfoundation.org/api/units/112435873/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.277762Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435874,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e858170b04924f33",
            "url": "https://translations.documentfoundation.org/api/units/112435874/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.278972Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435875,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d015065082762bad",
            "url": "https://translations.documentfoundation.org/api/units/112435875/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.280034Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435876,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=57c8b13194472792",
            "url": "https://translations.documentfoundation.org/api/units/112435876/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.281052Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435877,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cef6d389f66d0c73",
            "url": "https://translations.documentfoundation.org/api/units/112435877/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.282083Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435878,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7466d42f6c5a891d",
            "url": "https://translations.documentfoundation.org/api/units/112435878/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.283160Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435879,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d472591d417f1584",
            "url": "https://translations.documentfoundation.org/api/units/112435879/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.284133Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435880,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5832b71d2d3d7271",
            "url": "https://translations.documentfoundation.org/api/units/112435880/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.285123Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435881,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=31ec847980ca7d27",
            "url": "https://translations.documentfoundation.org/api/units/112435881/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.286138Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435882,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6bab8f13a52425bb",
            "url": "https://translations.documentfoundation.org/api/units/112435882/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.287159Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435883,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1f98f0d88ad2fde3",
            "url": "https://translations.documentfoundation.org/api/units/112435883/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.288174Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435884,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=890fb54778e556cb",
            "url": "https://translations.documentfoundation.org/api/units/112435884/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.289228Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435885,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4a434e07c1182835",
            "url": "https://translations.documentfoundation.org/api/units/112435885/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.290232Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435886,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0e2908676d4fda03",
            "url": "https://translations.documentfoundation.org/api/units/112435886/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.291271Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435887,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=be051da2eef4c50a",
            "url": "https://translations.documentfoundation.org/api/units/112435887/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.292407Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435888,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4eddd79086626aaf",
            "url": "https://translations.documentfoundation.org/api/units/112435888/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.293401Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435889,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a75f7ea3a07555f",
            "url": "https://translations.documentfoundation.org/api/units/112435889/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.294393Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435890,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4ccbb5a4e7457bcb",
            "url": "https://translations.documentfoundation.org/api/units/112435890/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.295619Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435891,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ff413ba6b28ece8d",
            "url": "https://translations.documentfoundation.org/api/units/112435891/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.296772Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435892,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f5c5a9030d795dda",
            "url": "https://translations.documentfoundation.org/api/units/112435892/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.297787Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435893,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=53d9d16bc5620718",
            "url": "https://translations.documentfoundation.org/api/units/112435893/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.298777Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435894,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8166c010872759a3",
            "url": "https://translations.documentfoundation.org/api/units/112435894/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.299928Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435895,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=48c13555c047f64a",
            "url": "https://translations.documentfoundation.org/api/units/112435895/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.301217Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435896,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=08dd48c1d790d52e",
            "url": "https://translations.documentfoundation.org/api/units/112435896/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.302384Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435897,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=020ded207ab5bfba",
            "url": "https://translations.documentfoundation.org/api/units/112435897/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.303494Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435898,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ccc4502556f5ac58",
            "url": "https://translations.documentfoundation.org/api/units/112435898/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.304580Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435899,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=124a51a3a77eba4d",
            "url": "https://translations.documentfoundation.org/api/units/112435899/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.305765Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435900,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1d7551f4f17a7493",
            "url": "https://translations.documentfoundation.org/api/units/112435900/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.306826Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435901,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=52415ad58a0f0cd8",
            "url": "https://translations.documentfoundation.org/api/units/112435901/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.307804Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435902,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8dcadca63e700be0",
            "url": "https://translations.documentfoundation.org/api/units/112435902/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.308877Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435903,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=541d228e1fbc52d6",
            "url": "https://translations.documentfoundation.org/api/units/112435903/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.309851Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435904,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b22c6359cd3be45a",
            "url": "https://translations.documentfoundation.org/api/units/112435904/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.310857Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435905,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9c3bbb9064ae1818",
            "url": "https://translations.documentfoundation.org/api/units/112435905/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.312025Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435906,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b24ba91863ca4954",
            "url": "https://translations.documentfoundation.org/api/units/112435906/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.313086Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112435907,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8b4d05fb8c14f668",
            "url": "https://translations.documentfoundation.org/api/units/112435907/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:23:29.314039Z"
        }
    ]
}