Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=5
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=6", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=4", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>drag and drop; referencing cells</bookmark_value> <bookmark_value>cells; referencing by drag and drop </bookmark_value> <bookmark_value>references;inserting by drag and drop</bookmark_value> <bookmark_value>inserting;references, by drag and drop</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>vedä ja pudota; soluviitteet</bookmark_value><bookmark_value>solut; viitteet vedä ja pudota -toiminnolla </bookmark_value><bookmark_value>viitteet;lisääminen vetäen ja pudottaen</bookmark_value><bookmark_value>lisääminen;viitteet, vetäen ja pudottaen</bookmark_value>" ], "id_hash": -5934776886678972865, "content_hash": -5934776886678972865, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\nbm_id3154686\nhelp.text", "note": "DN7Zz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24936139/?format=api", "priority": 100, "id": 1961734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2da36fdd884d163f", "url": "https://translations.documentfoundation.org/api/units/1961734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.815872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link, or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file." ], "previous_source": "", "target": [ "Rakenneselaimella voidaan viitata yhdestä laskentataulukosta toisen taulukon tai eri asiakirjan soluihin. Solut voidaan lisätä kopioina, linkkeinä tai hyperlinkkeinä. Lisättävä alue pitää nimetä alkuperäisessä tiedostossa, jolloin se voidaan lisätä kohdetiedostoon." ], "id_hash": -1064802108390599568, "content_hash": -1064802108390599568, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3156444\nhelp.text", "note": "ANUwC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/24936141/?format=api", "priority": 100, "id": 1961736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7139101fbd4a9470", "url": "https://translations.documentfoundation.org/api/units/1961736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.848020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open the document that contains the source cells." ], "previous_source": "", "target": [ "Avaa asiakirja, jossa lähdesolut ovat." ], "id_hash": 8536920173048683671, "content_hash": 8536920173048683671, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3152576\nhelp.text", "note": "eV8oB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936142/?format=api", "priority": 100, "id": 1961737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f6793baab66edc97", "url": "https://translations.documentfoundation.org/api/units/1961737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.863673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To set the source range as the range, select the cells and choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. Save the source document, and do not close it." ], "previous_source": "", "target": [ "" ], "id_hash": 4526186671920706091, "content_hash": 4526186671920706091, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154011\nhelp.text", "note": "SFWrp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24936143/?format=api", "priority": 100, "id": 1961738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=bed03ecc1ef0f22b", "url": "https://translations.documentfoundation.org/api/units/1961738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.873763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open the sheet in which you want to insert something." ], "previous_source": "", "target": [ "Avaa taulukko, johon haluat lisätä jotakin." ], "id_hash": -5193122400437830357, "content_hash": -5193122400437830357, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3151073\nhelp.text", "note": "UMVry", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936144/?format=api", "priority": 100, "id": 1961739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=37ee52b0eec77d2b", "url": "https://translations.documentfoundation.org/api/units/1961739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.885975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the Navigator, the source file object appears under \"Range names\"." ], "previous_source": "", "target": [ "Rakenneselaimessa lähteen objektit näkyvät \"Alueiden nimet\" -kohdassa." ], "id_hash": 5453365853304296294, "content_hash": 5453365853304296294, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3150752\nhelp.text", "note": "36bq3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936146/?format=api", "priority": 100, "id": 1961741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=cbae3f59b4729366", "url": "https://translations.documentfoundation.org/api/units/1961741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.912706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Using the <emph>Drag Mode</emph> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy." ], "previous_source": "", "target": [ "Käyttäen rakenneselaimen <emph>Vetotila</emph>-kuvaketta valitse, viittaatko hyperlinkkinä, linkkinä vai kopiotko." ], "id_hash": 8610010747941911183, "content_hash": 8610010747941911183, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154754\nhelp.text", "note": "FAErG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936147/?format=api", "priority": 100, "id": 1961742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f77ce7284f5f7a8f", "url": "https://translations.documentfoundation.org/api/units/1961742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.922470Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click the name under \"Range names\" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference." ], "previous_source": "", "target": [ "Napsauta rakenneselaimen \"Alueiden nimet\"-kohdassa nimeä ja vedä käsiteltävän taulukon siihen soluun, johon haluat viitteen lisättävän." ], "id_hash": 230719825451888764, "content_hash": 230719825451888764, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154256\nhelp.text", "note": "Thq7N", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24936148/?format=api", "priority": 100, "id": 1961743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=8333ae7576b3307c", "url": "https://translations.documentfoundation.org/api/units/1961743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.933537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "This method can also be used to insert a range from another sheet of the same document into the current sheet. Select the active document as source in step 4 above." ], "previous_source": "", "target": [ "Tätä menetelmää voidaan käyttää myös saman asiakirjan eri taulukkojen alueiden lisäämiseen käsiteltävään taulukkoon. Valitse aktiivinen asiakirja lähteeksi vaiheessa 4 yllä." ], "id_hash": -7443407704774671154, "content_hash": -7443407704774671154, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3149565\nhelp.text", "note": "GK9kZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936149/?format=api", "priority": 100, "id": 1961744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=18b3b4211e8004ce", "url": "https://translations.documentfoundation.org/api/units/1961744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.946385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "previous_source": "", "target": [ "Yhden taulukon solussa voidaan viitata toisen taulukon soluun." ], "id_hash": -8607370243769690863, "content_hash": -8607370243769690863, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9663075\nhelp.text", "note": "S3C6m", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936153/?format=api", "priority": 100, "id": 1961748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=088c7a5df9d71511", "url": "https://translations.documentfoundation.org/api/units/1961748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.000237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file." ], "previous_source": "", "target": [ "Samaan tapaan viittaus voidaan tehdä myös toisen asiakirjan soluun, edellyttäen että asiakirja on jo tallennettu tiedostoksi." ], "id_hash": -2429795404084310918, "content_hash": -2429795404084310918, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id1879329\nhelp.text", "note": "guASx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936154/?format=api", "priority": 100, "id": 1961749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5e47a1f41ead8c7a", "url": "https://translations.documentfoundation.org/api/units/1961749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.013487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Reference a Cell in the Same Document" ], "previous_source": "", "target": [ "Soluun viittaaminen samassa asiakirjassa" ], "id_hash": -8036396515988521485, "content_hash": -8036396515988521485, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id7122409\nhelp.text", "note": "miL8J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936155/?format=api", "priority": 100, "id": 1961750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1078fbf286513df3", "url": "https://translations.documentfoundation.org/api/units/1961750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.027676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "previous_source": "", "target": [ "Esimerkin vuoksi kirjoita seuraava kaava taulukko1:n soluun A1:" ], "id_hash": -3303896142266824515, "content_hash": -3303896142266824515, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id4943693\nhelp.text", "note": "paXnm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936156/?format=api", "priority": 100, "id": 1961752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=522633f6a16708bd", "url": "https://translations.documentfoundation.org/api/units/1961752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.058388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<item type=\"literal\">=Sheet2.A1</item>" ], "previous_source": "", "target": [ "<item type=\"literal\">=Taulukko2.A1</item>" ], "id_hash": 8487635637370999137, "content_hash": 8487635637370999137, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9064302\nhelp.text", "note": "2HPD8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936157/?format=api", "priority": 100, "id": 1961753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f5ca23a48c71d161", "url": "https://translations.documentfoundation.org/api/units/1961753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.071286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number." ], "previous_source": "", "target": [ "Napauta <emph>Taulukko2</emph> -taulukkovalitsinta laskentataulukon alareunassa. Aseta kohdistin siellä soluun A1 ja kirjoita tekstiä tai luku." ], "id_hash": -2577446353386241861, "content_hash": -2577446353386241861, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7609790\nhelp.text", "note": "zwUqn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936158/?format=api", "priority": 100, "id": 1961754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5c3b12328ec980bb", "url": "https://translations.documentfoundation.org/api/units/1961754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.082879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change." ], "previous_source": "", "target": [ "Kun vaihdat takaisin Taulukko1:lle, näet saman sisällön solussa A1 täälläkin. Jos solun Taulukko2.A1 sisältö muuttuu, niin samalla muuttuu myös solun Taulukko1.A1 esitettävä sisältö." ], "id_hash": 1625573124372639045, "content_hash": 1625573124372639045, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id809961\nhelp.text", "note": "PYRuC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936159/?format=api", "priority": 100, "id": 1961755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=968f3224daa72d45", "url": "https://translations.documentfoundation.org/api/units/1961755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.096323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Reference a Cell in Another Document" ], "previous_source": "", "target": [ "Soluun viittaaminen toisessa asiakirjassa" ], "id_hash": -8988584149462720279, "content_hash": -8988584149462720279, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id9209570\nhelp.text", "note": "mK8vG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936160/?format=api", "priority": 100, "id": 1961756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=03422256f19160e9", "url": "https://translations.documentfoundation.org/api/units/1961756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.108687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "previous_source": "", "target": [ "Valitse <emph>Tiedosto - Avaa</emph> ladataksesi olemassa olevan taulukkolaskenta-asiakirjan." ], "id_hash": -146034786211442772, "content_hash": -146034786211442772, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id5949278\nhelp.text", "note": "hRAmo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936161/?format=api", "priority": 100, "id": 1961757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7df92e22bb044fac", "url": "https://translations.documentfoundation.org/api/units/1961757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.122026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula." ], "previous_source": "", "target": [ "Valitse <emph>Tiedosto - Uusi</emph> avataksesi uuden taulukkolaskenta-asiakirjan. Aseta kohdistin soluun, johon lisäät ulkoista aineistoa ja syötä yhtäsuuruusmerkki osoittamaan, että haluat aloittaa kaavan." ], "id_hash": 8075084161029904148, "content_hash": 8075084161029904148, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8001953\nhelp.text", "note": "XywAr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24936162/?format=api", "priority": 100, "id": 1961758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f0107642c5921714", "url": "https://translations.documentfoundation.org/api/units/1961758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.135699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document." ], "previous_source": "", "target": [ "Vaihda nyt juuri lataamaasi asiakirjaan. Napsauta solua, jossa uuteen asiakirjaan lisättävä aineisto on." ], "id_hash": -6970258483961703397, "content_hash": -6970258483961703397, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8571123\nhelp.text", "note": "BrDJf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936163/?format=api", "priority": 100, "id": 1961759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1f44aad6becf541b", "url": "https://translations.documentfoundation.org/api/units/1961759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.149417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you." ], "previous_source": "", "target": [ "Vaihda takaisin uuteen laskentataulukkoon. Syöttörivillä näkyy nyt miten $[officename] Calc on lisännyt viittauksen kaavaan." ], "id_hash": 6930991381245622366, "content_hash": 6930991381245622366, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8261665\nhelp.text", "note": "rCxaG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936164/?format=api", "priority": 100, "id": 1961760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e02fd3f07470785e", "url": "https://translations.documentfoundation.org/api/units/1961760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.163892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Confirm the formula by clicking the green check mark." ], "previous_source": "", "target": [ "Hyväksy kaava napsauttamalla vihreää pukkimerkkiä." ], "id_hash": -7075107501787663034, "content_hash": -7075107501787663034, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7697683\nhelp.text", "note": "ACCDQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936166/?format=api", "priority": 100, "id": 1961762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1dd02b36703eb546", "url": "https://translations.documentfoundation.org/api/units/1961762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.192867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>HTML; in sheet cells</bookmark_value><bookmark_value>references; URL in cells</bookmark_value><bookmark_value>cells; Internet references</bookmark_value><bookmark_value>URL; in Calc</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HTML; taulukon soluissa</bookmark_value><bookmark_value>viitteet; URL-osoitteet soluissa</bookmark_value><bookmark_value>solut; Internet-viitteet</bookmark_value><bookmark_value>URL-osoite; Calcissa</bookmark_value>" ], "id_hash": 7445518397165399414, "content_hash": 7445518397165399414, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\nbm_id3150441\nhelp.text", "note": "7ELAq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936169/?format=api", "priority": 100, "id": 1961766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e753cb88bfaded76", "url": "https://translations.documentfoundation.org/api/units/1961766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.240294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure:" ], "previous_source": "", "target": [ "Jos esimerkiksi löytyy Internet-sivu, jossa on ajankohtaista pörssitietoa laskentataulukkosoluissa, sivu on ladattavissa $[officename] Calciin seuraavalla tavalla:" ], "id_hash": -5481595565578359873, "content_hash": -5481595565578359873, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id1955626\nhelp.text", "note": "VHDGU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936171/?format=api", "priority": 100, "id": 1961768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=33ed75e037586bbf", "url": "https://translations.documentfoundation.org/api/units/1961768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.263588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data." ], "previous_source": "", "target": [ "Sijoita kohdistin $[officename] Calcin asiakirjassa siihen soluun, johon lisäät ulkoista aineistoa." ], "id_hash": -8747435212634940298, "content_hash": -8747435212634940298, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152993\nhelp.text", "note": "2MWuc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936172/?format=api", "priority": 100, "id": 1961769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=069ade051f269c76", "url": "https://translations.documentfoundation.org/api/units/1961769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.277689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type=\"menuitem\">File - Open</item> dialog." ], "previous_source": "", "target": [ "Kirjoita asiakirjan tai verkkosivun URL-osoite valintaikkunaan. URL-osoitteen pitää olla muotoa: http://www.my-bank.com/table.html. Paikallisen tai lähiverkon tiedoston URL-osoite on polku, joka näkyy <item type=\"menuitem\">Tiedosto - Avaa</item> -valintaikkunasta." ], "id_hash": -5817784293971594154, "content_hash": -5817784293971594154, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152892\nhelp.text", "note": "EQzxX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24936174/?format=api", "priority": 100, "id": 1961771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2f43140231f9f456", "url": "https://translations.documentfoundation.org/api/units/1961771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.301090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "$[officename] loads the Web page or file in the \"background\", that is, without displaying it. In the large list box of the <item type=\"menuitem\">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from." ], "previous_source": "", "target": [ "$[officename] lataa verkkosivun tai tiedoston \"taustalla\", se on, näyttämättä sitä. <item type=\"menuitem\">Ulkoiset tiedot</item> -valintaikkunan suuremmassa luetteloruudussa näkyvät kaikki valittavissa olevat taulukot tai aluenimet." ], "id_hash": 2696750813408066630, "content_hash": 2696750813408066630, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153068\nhelp.text", "note": "ZVqcc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24936175/?format=api", "priority": 100, "id": 1961772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a56cc893a8eefc46", "url": "https://translations.documentfoundation.org/api/units/1961772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.314843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select one or more sheets or named ranges. You can also activate the automatic update function every \"n\" seconds and click <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Valitse yksi tai useampia taulukoita tai nimettyjä alueita. Voit myös aktivoida päivitystoiminnon päivittämään \"n\":n sekunnin välein ja napsauttaa <item type=\"menuitem\">OK</item>:ta." ], "id_hash": -6590297703472980074, "content_hash": -6590297703472980074, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153914\nhelp.text", "note": "xzgJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24936176/?format=api", "priority": 100, "id": 1961773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=248a8f27d46b9f96", "url": "https://translations.documentfoundation.org/api/units/1961773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.328272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "previous_source": "", "target": [ "Sisältö lisätään linkkinä $[officename] Calc -asiakirjaan." ], "id_hash": 2106220966743135416, "content_hash": 2106220966743135416, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3157979\nhelp.text", "note": "BQaFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936177/?format=api", "priority": 100, "id": 1961774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9d3acccf5d3454b8", "url": "https://translations.documentfoundation.org/api/units/1961774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.341261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry." ], "previous_source": "", "target": [ "Tallenna laskentataulukko. Kun avaat sen myöhemmin uudestaan, $[officename] Calc päivittää linkitetyt solut varmistuskyselyn jälkeen." ], "id_hash": -4663235078393552702, "content_hash": -4663235078393552702, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3144768\nhelp.text", "note": "LAC7R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 301, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936178/?format=api", "priority": 100, "id": 1961775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3f48dc67303620c2", "url": "https://translations.documentfoundation.org/api/units/1961775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.354222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Muotoilun asettaminen kaavalla" ], "id_hash": -3609957716354299150, "content_hash": -3609957716354299150, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\ntit\nhelp.text", "note": "4DFzJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 303, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936180/?format=api", "priority": 100, "id": 1961777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/1961777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.380384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>formats; assigning by formulas</bookmark_value> <bookmark_value>cell formats; assigning by formulas</bookmark_value> <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulas</bookmark_value> <bookmark_value>formulas;assigning cell formats</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>muotoilut; asettaminen kaavalla</bookmark_value><bookmark_value>solumuotoilut; asettaminen kaavalla</bookmark_value><bookmark_value>STYLE-funktion esimerkki</bookmark_value><bookmark_value>solutyylit;asettaminen kaavalla</bookmark_value><bookmark_value>kaavat;solumuotoilun asettaminen</bookmark_value>" ], "id_hash": 164411229929034979, "content_hash": 164411229929034979, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\nbm_id3145673\nhelp.text", "note": "ewC9e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936181/?format=api", "priority": 100, "id": 1961778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/1961778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.392404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; \"Red\"; \"Green\")) applies the cell style \"Red\" to cells if the value is greater than 3, otherwise the cell style \"Green\" is applied." ], "previous_source": "", "target": [ "STYLE-funktio voidaan lisätä solussa olevaan kaavaan. Esimerkiksi yhdessä CURRENT-funktion kanssa, voidaan solun väri määrätä sen arvosta riippuvaksi. Kaava =...+STYLE(IF(CURRENT()>3; \"Punainen_oma\"; \"Vihreä_oma\")) käyttää solutyyliä \"Punainen_oma\" niissä soluissa, joissa arvo on suurempi kuin 3, muuten käytetään \"Vihreä_oma\" -solutyyliä." ], "id_hash": 3545701820741360435, "content_hash": 3545701820741360435, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150275\nhelp.text", "note": "EzSnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 306, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/24936397/?format=api", "priority": 100, "id": 1961780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/1961780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.419259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you would like to apply a formula to all cells in a selected area, you can use the <item type=\"menuitem\">Find & Replace</item> dialog." ], "previous_source": "", "target": [ "Kun aiotaan käyttää kaavaa valitun alueen kaikkiin soluihin, voidaan käyttää <item type=\"menuitem\">Etsi ja korvaa</item> -valintaikkunaa." ], "id_hash": 4662496989831300287, "content_hash": 4662496989831300287, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3151385\nhelp.text", "note": "bMcgv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936398/?format=api", "priority": 100, "id": 1961781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/1961781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.433666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Valitse kaikki tarvittavat solut." ], "id_hash": -7915414649820688558, "content_hash": -7915414649820688558, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149456\nhelp.text", "note": "qAH7F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 308, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936399/?format=api", "priority": 100, "id": 1961782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/1961782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.446095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Valitse valikkokomento <emph>Muokkaa - Etsi ja korvaa</emph>." ], "id_hash": -3871256957612398730, "content_hash": -3871256957612398730, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3148797\nhelp.text", "note": "FyUDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936400/?format=api", "priority": 100, "id": 1961783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/1961783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.458023Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -3542223392916196599, "content_hash": -3542223392916196599, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150767\nhelp.text", "note": "STxmA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936401/?format=api", "priority": 100, "id": 1961784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/1961784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.473057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" on säännöllinen lauseke, joka tarkoittaa käsiteltävän solun sisältöä." ], "id_hash": 2250458990697445731, "content_hash": 2250458990697445731, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153770\nhelp.text", "note": "EN8wF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 311, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936402/?format=api", "priority": 100, "id": 1961785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/1961785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.486835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enter the following formula in the <item type=\"menuitem\">Replace</item> field: <item type=\"literal\">=&+STYLE(IF(CURRENT()>3;\"Red\";\"Green\"))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7564866201628513913, "content_hash": 7564866201628513913, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153143\nhelp.text", "note": "r8m3j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936403/?format=api", "priority": 100, "id": 1961786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/1961786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.499475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The \"&\" symbol designates the current contents of the <emph>Find</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles \"Red\" and \"Green\" already exist." ], "previous_source": "", "target": [ "" ], "id_hash": 2301038259609661742, "content_hash": 2301038259609661742, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3146975\nhelp.text", "note": "prHDb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24936404/?format=api", "priority": 100, "id": 1961787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/1961787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.512606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Kaikki solut, joiden sisältö sopii valintaan, ovat nyt korostettuina." ], "id_hash": 8123534687943202457, "content_hash": 8123534687943202457, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3144767\nhelp.text", "note": "A3CBV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936406/?format=api", "priority": 100, "id": 1961789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/1961789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.539435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Valitse <item type=\"menuitem\">Avaa</item>." ], "id_hash": 6497422687296759040, "content_hash": 6497422687296759040, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3147127\nhelp.text", "note": "CxKWs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936407/?format=api", "priority": 100, "id": 1961790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/1961790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.552578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Ehdollisen muotoilun käyttäminen" ], "id_hash": 4878667856389839357, "content_hash": 4878667856389839357, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\ntit\nhelp.text", "note": "smBjq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936408/?format=api", "priority": 100, "id": 1961791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/1961791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.566534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>conditional formatting; cells</bookmark_value> <bookmark_value>cells; conditional formatting</bookmark_value> <bookmark_value>formatting; conditional formatting</bookmark_value> <bookmark_value>styles;conditional styles</bookmark_value> <bookmark_value>cell formats; conditional</bookmark_value> <bookmark_value>random numbers;examples</bookmark_value> <bookmark_value>cell styles; copying</bookmark_value> <bookmark_value>copying; cell styles</bookmark_value> <bookmark_value>tables; copying cell styles</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ehdollinen muotoilu; solut</bookmark_value><bookmark_value>solut; ehdollinen muotoilu</bookmark_value><bookmark_value>muotoilu; ehdollinen muotoilu</bookmark_value><bookmark_value>tyylit;ehdolliset tyylit</bookmark_value><bookmark_value>solutyylit; ehdolliset</bookmark_value><bookmark_value>satunnaisluvut;esimerkit</bookmark_value><bookmark_value>solutyylit; kopiointi</bookmark_value><bookmark_value>kopiointi; solutyylit</bookmark_value><bookmark_value>taulukot; solutyylien kopiointi</bookmark_value>" ], "id_hash": -279766961116655222, "content_hash": -279766961116655222, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nbm_id3149263\nhelp.text", "note": "3TV3y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936409/?format=api", "priority": 100, "id": 1961792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/1961792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.579995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled)." ], "previous_source": "", "target": [ "Ehdollisen muotoilun käyttäminen vaatii, että automaattinen laskenta on käytössä. Merkitään tarvittaessa <emph>Työkalut - Solun sisältö - Automaattinen laskenta</emph> (valikkorivillä näkyy merkki, kun automaattinen laskenta on käytössä)." ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 321, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936412/?format=api", "priority": 100, "id": 1961795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/1961795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.623012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually." ], "previous_source": "", "target": [ "Ehdollisella muotoilulla voidaan esimerkiksi korostaa summia, jotka ylittävät kaikkien summien keskiarvon. Kun summat muuttuvat, niiden muotoilut muuttuvat vastaavasti, ilman käyttäjän suorittamaa tyylin vaihtamista." ], "id_hash": 3980182931444228703, "content_hash": 3980182931444228703, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154944\nhelp.text", "note": "Yy9Z2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 322, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936413/?format=api", "priority": 100, "id": 1961796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/1961796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.636466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "Ehtojen asettaminen" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936414/?format=api", "priority": 100, "id": 1961797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/1961797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.648901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Valitse solut, joissa käytät ehdollista tyyliä." ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936415/?format=api", "priority": 100, "id": 1961798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/1961798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.660802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Ehdollisen muotoilun esimerkki: ali ja yli keskiarvon menevien summien korostaminen" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 327, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936418/?format=api", "priority": 100, "id": 1961801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/1961801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.706567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Vaihe 1: Numeroarvojen luominen" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936419/?format=api", "priority": 100, "id": 1961802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/1961802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.721667Z" } ] }