Units

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

{
    "count": 1559,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=7",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=5",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting."
            ],
            "previous_source": "",
            "target": [
                "Taulukon tietyille arvoille halutaan antaa erityinen korostus. Esimerkiksi liikevaihdon taulukossa voidaan kaikki yli keskitason olevat arvot esittää vihreinä ja alle keskiarvon olevat punaisella. Tämä voidaan tehdä ehdollisella muotoilulla."
            ],
            "id_hash": -4753521984506958934,
            "content_hash": -4753521984506958934,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text",
            "note": "5TVr9",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 329,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 43,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936420/?format=api",
            "priority": 100,
            "id": 1961803,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3e0818f0b973ebaa",
            "url": "https://translations.documentfoundation.org/api/units/1961803/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.736445Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50)."
            ],
            "previous_source": "",
            "target": [
                "Syötä yhteen soluista kaava =RAND(), jolloin saat satunnaisluvun väliltä 0...1. Jos tarvitset kokonaislukuja väliltä 0...50, syötä kaava =INT(RAND()*50)."
            ],
            "id_hash": 7837711463613136779,
            "content_hash": 7837711463613136779,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text",
            "note": "A66qh",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 331,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936422/?format=api",
            "priority": 100,
            "id": 1961805,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ecc5250cd8aaff8b",
            "url": "https://translations.documentfoundation.org/api/units/1961805/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.763384Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected."
            ],
            "previous_source": "",
            "target": [
                "Kopioi kaavaa, jotta saat rivin satunnaislukuja. Napsauta valitun solun oikean alakulman kopiointikahvaa ja vedä oikealle, kunnes riittävä solualue on valittu."
            ],
            "id_hash": 6892568724043407820,
            "content_hash": 6892568724043407820,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text",
            "note": "rCrEf",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 332,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936423/?format=api",
            "priority": 100,
            "id": 1961806,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=dfa752bc729321cc",
            "url": "https://translations.documentfoundation.org/api/units/1961806/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.779000Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers."
            ],
            "previous_source": "",
            "target": [
                "Samaan tapaan kuin yllä on kuvattu, vedä viimeisenä oikealla olevan solun kulmasta alas, jotta saat luotua lisää satunnaislukujen rivejä."
            ],
            "id_hash": -2947348419295557648,
            "content_hash": -2947348419295557648,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text",
            "note": "Tm6MA",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 333,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 24,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936424/?format=api",
            "priority": 100,
            "id": 1961807,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5718ea3a769447f0",
            "url": "https://translations.documentfoundation.org/api/units/1961807/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.790358Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Step 2: Define Cell Styles"
            ],
            "previous_source": "",
            "target": [
                "Vaihe 2: Solutyylien määrittely"
            ],
            "id_hash": 1860090573670708058,
            "content_hash": 1860090573670708058,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text",
            "note": "i3CTm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 334,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936425/?format=api",
            "priority": 100,
            "id": 1961808,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=99d05e8585b1f35a",
            "url": "https://translations.documentfoundation.org/api/units/1961808/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.802578Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2515053443613502634,
            "content_hash": 2515053443613502634,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text",
            "note": "sr6WY",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 335,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 34,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936426/?format=api",
            "priority": 100,
            "id": 1961809,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a2e743c819b4acaa",
            "url": "https://translations.documentfoundation.org/api/units/1961809/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.815221Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu."
            ],
            "previous_source": "",
            "target": [
                "Napsauta tyhjää solua ja valitse komento <emph>Muotoile solut</emph> kohdevalikosta."
            ],
            "id_hash": -6456560012199126547,
            "content_hash": -6456560012199126547,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text",
            "note": "CVM3G",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 336,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936427/?format=api",
            "priority": 100,
            "id": 1961810,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2665b0e091e119ed",
            "url": "https://translations.documentfoundation.org/api/units/1961810/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.828935Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, \"Below\")."
            ],
            "previous_source": "",
            "target": [
                "Seuraavan tyylin määrittämiseksi napsauta jälleen jotain tyhjää solua ja etene edellä kuvatulla tavalla. Määritä solulle eri taustaväri ja nimeä tyyli (esimerkiksi \"Alle\")."
            ],
            "id_hash": 2559261581071111980,
            "content_hash": 2559261581071111980,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text",
            "note": "4bRZa",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 339,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 32,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936430/?format=api",
            "priority": 100,
            "id": 1961813,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a38452d9330c572c",
            "url": "https://translations.documentfoundation.org/api/units/1961813/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.871288Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Step 3: Calculate Average"
            ],
            "previous_source": "",
            "target": [
                "Vaihe 3: Keskiarvojen laskenta"
            ],
            "id_hash": 7675455618679043080,
            "content_hash": 7675455618679043080,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text",
            "note": "x3rxG",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 340,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936431/?format=api",
            "priority": 100,
            "id": 1961814,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ea84b23808a3f408",
            "url": "https://translations.documentfoundation.org/api/units/1961814/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.884037Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "In our particular example, we are calculating the average of the random values. The result is placed in a cell:"
            ],
            "previous_source": "",
            "target": [
                "Esillä olevassa esimerkissämme laskemme satunnaislukujen keskiarvoja. Tulos sijoitetaan soluun:"
            ],
            "id_hash": 4578609383930617086,
            "content_hash": 4578609383930617086,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text",
            "note": "f5sxG",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 341,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 20,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936432/?format=api",
            "priority": 100,
            "id": 1961815,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=bf8a7cf9e6745cfe",
            "url": "https://translations.documentfoundation.org/api/units/1961815/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.895935Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>."
            ],
            "previous_source": "",
            "target": [
                "Sijoita kohdistin tyhjään soluun, esimerkiksi soluun J14, ja valitse <emph>Lisää - Funktio</emph>."
            ],
            "id_hash": -1641327560713127346,
            "content_hash": -1641327560713127346,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text",
            "note": "GhHpd",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 342,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936433/?format=api",
            "priority": 100,
            "id": 1961816,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=6938d54797a2ba4e",
            "url": "https://translations.documentfoundation.org/api/units/1961816/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.917597Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Close the Function Wizard with <item type=\"menuitem\">OK</item>."
            ],
            "previous_source": "",
            "target": [
                "Sulje funktion ohjattu luonti <item type=\"menuitem\">OK</item>:lla."
            ],
            "id_hash": -5015363106791229593,
            "content_hash": -5015363106791229593,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text",
            "note": "YEqsh",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 344,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 7,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936435/?format=api",
            "priority": 100,
            "id": 1961818,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3a65d9d3b01bf767",
            "url": "https://translations.documentfoundation.org/api/units/1961818/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.946764Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Step 4: Apply Cell Styles"
            ],
            "previous_source": "",
            "target": [
                "Vaihe 4: Solutyylien käyttäminen"
            ],
            "id_hash": -6453200130585452393,
            "content_hash": -6453200130585452393,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text",
            "note": "75WFf",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 345,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936436/?format=api",
            "priority": 100,
            "id": 1961819,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2671a0abf7f32097",
            "url": "https://translations.documentfoundation.org/api/units/1961819/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.964238Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Now you can apply the conditional formatting to the sheet:"
            ],
            "previous_source": "",
            "target": [
                "Nyt ehdollista muotoilua voidaan käyttää taulukkoon:"
            ],
            "id_hash": 7382243818509673232,
            "content_hash": 7382243818509673232,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text",
            "note": "AA6JP",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 346,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936437/?format=api",
            "priority": 100,
            "id": 1961820,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e672ffa3df97a310",
            "url": "https://translations.documentfoundation.org/api/units/1961820/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.981056Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select all cells with the random numbers."
            ],
            "previous_source": "",
            "target": [
                "Valitse kaikki solut, joissa on satunnaislukuja."
            ],
            "id_hash": 7136521799982947324,
            "content_hash": 7136521799982947324,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text",
            "note": "7YuzB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 347,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 7,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936438/?format=api",
            "priority": 100,
            "id": 1961821,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e30a04c423d09bfc",
            "url": "https://translations.documentfoundation.org/api/units/1961821/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:43.997202Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Define the condition as follows: If cell value is less than J14, format with cell style \"Below\", and if cell value is greater than or equal to J14, format with cell style \"Above\"."
            ],
            "previous_source": "",
            "target": [
                "Määritä ehdot seuraavasti: jos solun arvo on pienempi kuin J14, muotoillaan solutyylillä \"Alle\", ja jos solun arvo on suurempi tai yhtä suuri kuin J14, muotoillaan solutyylillä \"Yli\"."
            ],
            "id_hash": -3867351834357650696,
            "content_hash": -3867351834357650696,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text",
            "note": "oaUQo",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 349,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936440/?format=api",
            "priority": 100,
            "id": 1961823,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4a5467ff2ba82af8",
            "url": "https://translations.documentfoundation.org/api/units/1961823/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.017956Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Step 5: Copy Cell Style"
            ],
            "previous_source": "",
            "target": [
                "Vaihe 5: Solutyylien kopiointi"
            ],
            "id_hash": 6888277942235367290,
            "content_hash": 6888277942235367290,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text",
            "note": "p9FR7",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 350,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936441/?format=api",
            "priority": 100,
            "id": 1961824,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=df98144af519077a",
            "url": "https://translations.documentfoundation.org/api/units/1961824/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.027002Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "To apply the conditional formatting to other cells later:"
            ],
            "previous_source": "",
            "target": [
                "Ehdollisen muotoilun käyttämiseksi myöhemmin muihin soluihin:"
            ],
            "id_hash": -7215413165649662082,
            "content_hash": -7215413165649662082,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text",
            "note": "GBgrB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 351,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 9,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936442/?format=api",
            "priority": 100,
            "id": 1961826,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1bddb3f469c66f7e",
            "url": "https://translations.documentfoundation.org/api/units/1961826/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.035349Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Click one of the cells that has been assigned conditional formatting."
            ],
            "previous_source": "",
            "target": [
                "Napsauta yhtä niistä soluista, joissa on ehdollinen muotoilu."
            ],
            "id_hash": 7196379235401938805,
            "content_hash": 7196379235401938805,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3153074\nhelp.text",
            "note": "soRTt",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 352,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 11,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936443/?format=api",
            "priority": 100,
            "id": 1961827,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e3deacc95b213775",
            "url": "https://translations.documentfoundation.org/api/units/1961827/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.043738Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Copy the cell to the clipboard."
            ],
            "previous_source": "",
            "target": [
                "Kopioi solu leikepöydälle."
            ],
            "id_hash": 5333275245432870135,
            "content_hash": 5333275245432870135,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3149051\nhelp.text",
            "note": "35S7X",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 353,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 6,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936444/?format=api",
            "priority": 100,
            "id": 1961828,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ca0399942d6914f7",
            "url": "https://translations.documentfoundation.org/api/units/1961828/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.052647Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select the cells that are to receive this same formatting."
            ],
            "previous_source": "",
            "target": [
                "Valitse solut, joille tulee tämä sama muotoilu."
            ],
            "id_hash": 5816052215023921773,
            "content_hash": 5816052215023921773,
            "location": "cellstyle_conditional.xhp",
            "context": "cellstyle_conditional.xhp\npar_id3150436\nhelp.text",
            "note": "ogFEX",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 354,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936445/?format=api",
            "priority": 100,
            "id": 1961829,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d0b6c4acbf9fea6d",
            "url": "https://translations.documentfoundation.org/api/units/1961829/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.061543Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Highlighting Negative Numbers"
            ],
            "previous_source": "",
            "target": [
                "Negatiivisten lukujen korostaminen"
            ],
            "id_hash": -4059404321177657037,
            "content_hash": -4059404321177657037,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\ntit\nhelp.text",
            "note": "HFoKB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 358,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936449/?format=api",
            "priority": 100,
            "id": 1961833,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=47aa19470c852133",
            "url": "https://translations.documentfoundation.org/api/units/1961833/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.115322Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "<bookmark_value>negative numbers</bookmark_value>      <bookmark_value>numbers; highlighting negative numbers</bookmark_value>      <bookmark_value>highlighting;negative numbers</bookmark_value>      <bookmark_value>colors;negative numbers</bookmark_value>      <bookmark_value>number formats;colors for negative numbers</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                "<bookmark_value>negatiiviset luvut</bookmark_value><bookmark_value>luvut;negatiivisten lukujen korostaminen</bookmark_value><bookmark_value>korostaminen;negatiiviset luvut</bookmark_value><bookmark_value>värit;negatiiviset luvut</bookmark_value><bookmark_value>lukumuodot;negatiivisten lukujen värit</bookmark_value>"
            ],
            "id_hash": 2690907695207962454,
            "content_hash": 2690907695207962454,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\nbm_id3147434\nhelp.text",
            "note": "9Zqdi",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 359,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936450/?format=api",
            "priority": 100,
            "id": 1961834,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a558064ab03c5756",
            "url": "https://translations.documentfoundation.org/api/units/1961834/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.124531Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors."
            ],
            "previous_source": "",
            "target": [
                "Solujen lukumuotoa voidaan muotoilla korostamaan negatiiviset luvut punaisina. Vaihtoehtoisesti käyttäjä voi määritellä oman lukumuotonsa, jossa negatiiviset luvut korostetaan jollakin muulla värillä."
            ],
            "id_hash": -2401469527218566303,
            "content_hash": -2401469527218566303,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\npar_id3153878\nhelp.text",
            "note": "YGxpk",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 361,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936452/?format=api",
            "priority": 100,
            "id": 1961836,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5eac443043364b61",
            "url": "https://translations.documentfoundation.org/api/units/1961836/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.142333Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select the cells and choose <emph>Format - Cells</emph>."
            ],
            "previous_source": "",
            "target": [
                "Valitse solut ja suorita <emph>Muotoilu - Solut</emph>."
            ],
            "id_hash": -2610375749824612289,
            "content_hash": -2610375749824612289,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\npar_id3155600\nhelp.text",
            "note": "ZFJHU",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 362,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 8,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936453/?format=api",
            "priority": 100,
            "id": 1961837,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5bc61515fd68f83f",
            "url": "https://translations.documentfoundation.org/api/units/1961837/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.154994Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</emph>."
            ],
            "previous_source": "",
            "target": [
                "Valitse <emph>Luku</emph>-välilehdellä lukumuoto ja merkitse <emph>Negatiiviset luvut punaisina</emph> -valintaruutu. Hyväksy <emph>OK</emph>:lla."
            ],
            "id_hash": -2531380645435629521,
            "content_hash": -2531380645435629521,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\npar_id3146969\nhelp.text",
            "note": "tYEZ3",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 363,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 17,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936454/?format=api",
            "priority": 100,
            "id": 1961838,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5cdebab6fd82a02f",
            "url": "https://translations.documentfoundation.org/api/units/1961838/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.171355Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type=\"menuitem\">Format code</item>. For example, instead of RED, enter <item type=\"literal\">YELLOW</item>. If the new code appears in the list after clicking the <item type=\"menuitem\">Add</item> icon, this is a valid entry."
            ],
            "previous_source": "",
            "target": [
                "Solun lukumuoto määritetään kahdessa osassa. Positiivisten lukujen ja nollan lukumuoto määritetään puolipisteen edessä; puolipisteen jälkeen tulee negatiivisten lukujen määrityskoodi. Koodia (RED) voidaan vaihtaa <item type=\"menuitem\">Muotoilukoodi</item>-kentässä. Esimerkiksi koodin RED (punainen) sijaan voidaan syöttää <item type=\"literal\">YELLOW</item> (keltainen). Jos uusi koodi ilmestyy luetteloon <item type=\"menuitem\">Lisää</item>-kuvakkeen napsautuksella, koodi on kelvollinen."
            ],
            "id_hash": -4422457703490035149,
            "content_hash": -4422457703490035149,
            "location": "cellstyle_minusvalue.xhp",
            "context": "cellstyle_minusvalue.xhp\npar_id3145640\nhelp.text",
            "note": "23n86",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 364,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 70,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936455/?format=api",
            "priority": 100,
            "id": 1961839,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=42a046265d496233",
            "url": "https://translations.documentfoundation.org/api/units/1961839/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.183430Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Consolidating Data"
            ],
            "previous_source": "",
            "target": [
                "Tietojen yhdistäminen"
            ],
            "id_hash": 5372822363492069186,
            "content_hash": 5372822363492069186,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\ntit\nhelp.text",
            "note": "G5Dfz",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 376,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936456/?format=api",
            "priority": 100,
            "id": 1961840,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ca90197921382f42",
            "url": "https://translations.documentfoundation.org/api/units/1961840/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.194727Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "<bookmark_value>consolidating data</bookmark_value>      <bookmark_value>ranges; combining</bookmark_value>      <bookmark_value>combining;cell ranges</bookmark_value>      <bookmark_value>tables; combining</bookmark_value>      <bookmark_value>data; merging cell ranges</bookmark_value>      <bookmark_value>merging;data ranges</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                "<bookmark_value>tietojen yhdistäminen</bookmark_value><bookmark_value>alueet; yhdistäminen</bookmark_value><bookmark_value>yhdistäminen;solualueet</bookmark_value><bookmark_value>taulukot; yhdistäminen</bookmark_value><bookmark_value>aineisto; solualueiden yhdistäminen</bookmark_value><bookmark_value>yhdistäminen;tietoalueet</bookmark_value>"
            ],
            "id_hash": -8699824088904455889,
            "content_hash": -8699824088904455889,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\nbm_id3150791\nhelp.text",
            "note": "dEYi9",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 377,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 14,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936457/?format=api",
            "priority": 100,
            "id": 1961841,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=07440415b476a92f",
            "url": "https://translations.documentfoundation.org/api/units/1961841/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.212385Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "During consolidation, the contents of the cells from several sheets will be combined in one place."
            ],
            "previous_source": "",
            "target": [
                "Yhdistämisessä eri taulukoiden solujen sisällöt kootaan yhteen paikkaan."
            ],
            "id_hash": 2863811470568569986,
            "content_hash": 2863811470568569986,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3153191\nhelp.text",
            "note": "dcJqU",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 379,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 16,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936459/?format=api",
            "priority": 100,
            "id": 1961843,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a7be4d5bfeedbc82",
            "url": "https://translations.documentfoundation.org/api/units/1961843/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.238149Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "To Combine Cell Contents"
            ],
            "previous_source": "",
            "target": [
                "Solusisältöjen yhdistäminen"
            ],
            "id_hash": -7418047071167571604,
            "content_hash": -7418047071167571604,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\nhd_id892056\nhelp.text",
            "note": "GyvFB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 380,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936460/?format=api",
            "priority": 100,
            "id": 1961844,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=190dcd7dc3ee196c",
            "url": "https://translations.documentfoundation.org/api/units/1961844/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.249515Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Open the document that contains the cell ranges to be consolidated."
            ],
            "previous_source": "",
            "target": [
                "Avaa asiakirja, jossa on yhdistettävät solualueet."
            ],
            "id_hash": 830377358914747267,
            "content_hash": 830377358914747267,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3151073\nhelp.text",
            "note": "4tD6G",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 381,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 11,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936461/?format=api",
            "priority": 100,
            "id": 1961845,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=8b8617cef3a3fb83",
            "url": "https://translations.documentfoundation.org/api/units/1961845/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.260620Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog."
            ],
            "previous_source": "",
            "target": [
                "Valitse <item type=\"menuitem\">Tiedot - Yhdistä</item>, jolloin avautuu <emph>Yhdistele tietoja</emph> -valintaikkuna."
            ],
            "id_hash": -1340262079201837017,
            "content_hash": -1340262079201837017,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3154513\nhelp.text",
            "note": "77VUk",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 382,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936462/?format=api",
            "priority": 100,
            "id": 1961846,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=6d666ebd6f3f8027",
            "url": "https://translations.documentfoundation.org/api/units/1961846/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.272156Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas."
            ],
            "previous_source": "",
            "target": [
                "Valitse <emph>Lähdetietoalue</emph>-ruudusta lähdesolualue, joka yhdistetään muiden alueiden kanssa."
            ],
            "id_hash": 3568547474734044916,
            "content_hash": 3568547474734044916,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3147345\nhelp.text",
            "note": "hJHqN",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 383,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 16,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936463/?format=api",
            "priority": 100,
            "id": 1961847,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b186070573a3d6f4",
            "url": "https://translations.documentfoundation.org/api/units/1961847/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.286464Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse."
            ],
            "previous_source": "",
            "target": [
                "Jos aluetta ei ole nimetty, napsauta <emph>Lähdetietoalue</emph>-ruudun viereistä kenttää. Esille tulee vilkkuva tekstikohdistin. Kirjoita ensimmäisen valittavan alueen viite tai valitse alue hiirellä."
            ],
            "id_hash": -667679353442180552,
            "content_hash": -667679353442180552,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3149209\nhelp.text",
            "note": "CvGP2",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 384,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 37,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936464/?format=api",
            "priority": 100,
            "id": 1961848,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=76bbed2a62376238",
            "url": "https://translations.documentfoundation.org/api/units/1961848/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.300907Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field."
            ],
            "previous_source": "",
            "target": [
                "Napsauta <emph>Lisää</emph>-painiketta valitun alueen lisäämiseksi <emph>Yhdistelyalueet</emph>-kentälle."
            ],
            "id_hash": 3848135511423935069,
            "content_hash": 3848135511423935069,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3155529\nhelp.text",
            "note": "zSGyD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 385,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 12,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936465/?format=api",
            "priority": 100,
            "id": 1961849,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b56752dbfdfd625d",
            "url": "https://translations.documentfoundation.org/api/units/1961849/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.313588Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select additional ranges and click <emph>Add</emph> after each selection."
            ],
            "previous_source": "",
            "target": [
                "Valitse lisää alueita ja napsauta <emph>Lisää</emph>-painiketta kunkin valinnan jälkeen."
            ],
            "id_hash": 7169276099035941393,
            "content_hash": 7169276099035941393,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3153816\nhelp.text",
            "note": "Fo56E",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 386,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 9,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936466/?format=api",
            "priority": 100,
            "id": 1961850,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e37e62a0abbc4a11",
            "url": "https://translations.documentfoundation.org/api/units/1961850/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.325129Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box."
            ],
            "previous_source": "",
            "target": [
                "Valitsemalla kohdealueen <emph>Kopioi tulokset kohteeseen</emph> -ruudusta määrität sen, missä tulos esitetään."
            ],
            "id_hash": 398797832588757125,
            "content_hash": 398797832588757125,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3157983\nhelp.text",
            "note": "85CXx",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 387,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 19,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936467/?format=api",
            "priority": 100,
            "id": 1961851,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=8588d0840ca60885",
            "url": "https://translations.documentfoundation.org/api/units/1961851/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.336261Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "If the target range is not named, click in the field next to <emph>Copy results to</emph> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range."
            ],
            "previous_source": "",
            "target": [
                "Jos kohdealuetta ei ole nimetty, napsautetaan <emph>Kopioi tulokset kohteeseen</emph> -ruudun viereistä kenttää ja annetaan viite kohteelle. Vaihtoehtoisesti alueen voi valita hiirellä tai sijoittamalla kohdistimen kohdealueen vasempaan yläkulmaan."
            ],
            "id_hash": -1876994938870961530,
            "content_hash": -1876994938870961530,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3150215\nhelp.text",
            "note": "UByCi",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 388,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 46,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936468/?format=api",
            "priority": 100,
            "id": 1961852,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=65f3930c3f63ea86",
            "url": "https://translations.documentfoundation.org/api/units/1961852/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.350609Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select a function from the <emph>Function</emph> box. The function specifies how the values of the consolidation ranges are linked. The \"Sum\" function is the default setting."
            ],
            "previous_source": "",
            "target": [
                "Valitse funktio <emph>Funktio</emph>-ruudusta. Funktio määrää, miten yhdistettävien alueiden arvot käsitellään. \"Summa\"-funktio on oletusasetuksena."
            ],
            "id_hash": -6052783438683441990,
            "content_hash": -6052783438683441990,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3153813\nhelp.text",
            "note": "JvD9q",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 389,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 26,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936469/?format=api",
            "priority": 100,
            "id": 1961853,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2c00318812e7f4ba",
            "url": "https://translations.documentfoundation.org/api/units/1961853/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.364157Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Click <emph>OK</emph> to consolidate the ranges."
            ],
            "previous_source": "",
            "target": [
                "Napsauta alueiden tietojen yhdistämiseksi <emph>OK</emph>:ta."
            ],
            "id_hash": -897663849380064562,
            "content_hash": -897663849380064562,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3149315\nhelp.text",
            "note": "Z3iG2",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 390,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 6,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936470/?format=api",
            "priority": 100,
            "id": 1961854,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=738adb7c29fdd2ce",
            "url": "https://translations.documentfoundation.org/api/units/1961854/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.379348Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Additional Settings"
            ],
            "previous_source": "",
            "target": [
                "Lisäasetukset"
            ],
            "id_hash": 1386989742513126216,
            "content_hash": 1386989742513126216,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_idN107DE\nhelp.text",
            "note": "qbEFs",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 391,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936471/?format=api",
            "priority": 100,
            "id": 1961855,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=933f93d27d9afb48",
            "url": "https://translations.documentfoundation.org/api/units/1961855/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.395802Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:"
            ],
            "previous_source": "",
            "target": [
                "<emph>Yhdistele tietoja</emph> -valintaikkunassa alinna olevaa <emph>Lisää</emph>-painiketta napsautetaan lisäasetuksia varten:"
            ],
            "id_hash": -8685282467281095460,
            "content_hash": -8685282467281095460,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3147250\nhelp.text",
            "note": "BSAXP",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 392,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936472/?format=api",
            "priority": 100,
            "id": 1961856,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0777ad9cd3c834dc",
            "url": "https://translations.documentfoundation.org/api/units/1961856/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.411727Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range."
            ],
            "previous_source": "",
            "target": [
                "<emph>Linkitä lähdetietoihin</emph> -ruutu valitaan, kun kohdealueelle lisätään tuloksen tuottavat kaavat, eikä itse tuloksia. Kun aineisto linkitetään, lähdealueelle tehtävät muutokset päivittyvät kohdealueelle."
            ],
            "id_hash": -3631865130924125807,
            "content_hash": -3631865130924125807,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3156400\nhelp.text",
            "note": "DEEPq",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 393,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 41,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936473/?format=api",
            "priority": 100,
            "id": 1961857,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4d9905e7e723d191",
            "url": "https://translations.documentfoundation.org/api/units/1961857/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.428007Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed."
            ],
            "previous_source": "",
            "target": [
                "Kohdealueen vierekkäisiin riveihin lisätään vastaavat soluviitteet, jotka järjestetään ohjelmallisesti ja piilotetaan. Vain lopulliset tulokset, jotka perustuvat valittuun funktioon, esitetään."
            ],
            "id_hash": -1379167358946436983,
            "content_hash": -1379167358946436983,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3150538\nhelp.text",
            "note": "VJPHa",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 394,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936474/?format=api",
            "priority": 100,
            "id": 1961858,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=6cdc36981c2f1889",
            "url": "https://translations.documentfoundation.org/api/units/1961858/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.439647Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label."
            ],
            "previous_source": "",
            "target": [
                "<emph>Yhdistele</emph>-alueella valitaan joko <emph>Riviotsikot</emph> tai <emph>Sarakeotsikot</emph>, jos lähdealueen soluja ei yhdistellä solujen vastaavien sijaintien perusteella, vaan täsmäävien rivi- tai sarakeotsikoiden perusteella."
            ],
            "id_hash": 2054559487241974870,
            "content_hash": 2054559487241974870,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3149945\nhelp.text",
            "note": "UubEm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 395,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 45,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936475/?format=api",
            "priority": 100,
            "id": 1961859,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9c8342f7d6f77456",
            "url": "https://translations.documentfoundation.org/api/units/1961859/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.451633Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "To consolidate by row labels or column labels, the label must be contained in the selected source ranges."
            ],
            "previous_source": "",
            "target": [
                "Yhdisteltäessä rivi- tai sarakeotsikoiden perusteella, otsikoiden tulee olla valituilla lähdealueilla."
            ],
            "id_hash": -3469891027884511483,
            "content_hash": -3469891027884511483,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3157871\nhelp.text",
            "note": "AEjpi",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 396,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 18,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936476/?format=api",
            "priority": 100,
            "id": 1961860,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4fd8787e91a0ef05",
            "url": "https://translations.documentfoundation.org/api/units/1961860/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.467558Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column."
            ],
            "previous_source": "",
            "target": [
                "Toisiaan vastaavien otsikkotekstien tulee olla samoja, jotta rivit tai sarakkeet voitaisiin täsmätä tarkasti. Jos rivi- tai sarakeotsikko ei täsmää mihinkään kohdealueen otsikkoon, se muodostaa uuden rivin tai sarakkeen."
            ],
            "id_hash": 9184278295374865548,
            "content_hash": 9184278295374865548,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3150478\nhelp.text",
            "note": "mQ3x2",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 397,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 43,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936477/?format=api",
            "priority": 100,
            "id": 1961861,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ff751c730226248c",
            "url": "https://translations.documentfoundation.org/api/units/1961861/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.485792Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available."
            ],
            "previous_source": "",
            "target": [
                "Yhdistelyalueiden ja kohdealueen aineistot tallentuvat asiakirjaa tallennettaessa. Jos myöhemmin avataan asiakirja, jossa yhdistely on määritetty, aineisto on jälleen käytettävissä."
            ],
            "id_hash": -6048694902205384958,
            "content_hash": -6048694902205384958,
            "location": "consolidate.xhp",
            "context": "consolidate.xhp\npar_id3147468\nhelp.text",
            "note": "UMqz7",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 398,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 35,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936478/?format=api",
            "priority": 100,
            "id": 1961862,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2c0eb808a754f702",
            "url": "https://translations.documentfoundation.org/api/units/1961862/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.498350Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api",
            "source": [
                "Importing and Exporting CSV Files"
            ],
            "previous_source": "",
            "target": [
                "CSV-tiedostojen tuonti ja vienti"
            ],
            "id_hash": 1932064022427195821,
            "content_hash": 1932064022427195821,
            "location": "csv_files.xhp",
            "context": "csv_files.xhp\ntit\nhelp.text",
            "note": "UNSjU",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 400,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/24936480/?format=api",
            "priority": 100,
            "id": 1961864,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9ad011fdec15d9ad",
            "url": "https://translations.documentfoundation.org/api/units/1961864/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2019-07-11T17:51:44.522480Z"
        }
    ]
}