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=23
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=24", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=22", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "underline (_)" ], "previous_source": "", "target": [ "alaviiva (_)" ], "id_hash": -1053212889508042268, "content_hash": -1053212889508042268, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3362224\nhelp.text", "note": "4VANL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940126/?format=api", "priority": 100, "id": 1962909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/1962909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.022189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell." ], "previous_source": "", "target": [ "Nimet eivät saa olla samoja kuin soluviitteet. Esimerkiksi nimi A1 on epäkelpo, koska A1 on soluviite vasemman yläkulman soluun." ], "id_hash": 6661512041254287758, "content_hash": 6661512041254287758, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id328989\nhelp.text", "note": "BvnNt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24940129/?format=api", "priority": 100, "id": 1962912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/1962912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.058171Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Naming cells and formulas" ], "previous_source": "", "target": [ "Solujen ja kaavojen nimeäminen" ], "id_hash": 1905302747077356412, "content_hash": 1905302747077356412, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id1226233\nhelp.text", "note": "ci2B9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940131/?format=api", "priority": 100, "id": 1962915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/1962915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.104939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as \"=SUM(Start)\". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces." ], "previous_source": "", "target": [ "Hyvä tapa solujen ja solualueiden viitteiden luettavuuden parantamiseksi on alueiden nimeäminen. Esimerkiksi alueelle A1:B2 voidaan antaa nimeksi <emph>Alku</emph>. Tällöin voidaan kirjoittaa kaava \"=SUM(Alku)\". Jopa rivien ja sarakkeiden lisäämisen ja poistamisen jälkeenkin $[officename] sijoittaa oikean nimen oikealle alueelle. Välilyönnit eivät ole sallittuja aluenimissä ." ], "id_hash": -1484430074523089168, "content_hash": -1484430074523089168, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5489364\nhelp.text", "note": "FPo7Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24940132/?format=api", "priority": 100, "id": 1962916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/1962916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.118036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "For example, it is much easier to read a formula for sales tax if you can write \"= Amount * Tax_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"Tax_rate.\"" ], "previous_source": "", "target": [ "Esimerkiksi on paljon helpompaa lukea tuottoverotuksen kaavaa, jos kirjoitetaan \"= summa * veroprosentti\" tämän asemesta \"= A5 * B12\". Tässä tapauksessa A5-solulle annetaan nimi \"summa\" ja solulle B12 \"veroprosentti.\"" ], "id_hash": -399800468479881712, "content_hash": -399800468479881712, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id953398\nhelp.text", "note": "aZZC8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24940133/?format=api", "priority": 100, "id": 1962917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/1962917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.140139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names," ], "previous_source": "", "target": [ "Usein tarvittavien kaavojen tai kaavojen osien nimeämiseen käytetään <emph>Määritä nimet</emph> -valintaikkunaa. Alueiden nimeämiseksi:" ], "id_hash": 5827339612856761597, "content_hash": 5827339612856761597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id4889675\nhelp.text", "note": "LViNz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24940134/?format=api", "priority": 100, "id": 1962918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/1962918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.157757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears." ], "previous_source": "", "target": [ "" ], "id_hash": -8630882832493047597, "content_hash": -8630882832493047597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3153954\nhelp.text", "note": "UNzu6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24940135/?format=api", "priority": 100, "id": 1962919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/1962919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.171462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog." ], "previous_source": "", "target": [ "Kirjoita valitun alueen nimi <emph>Nimi</emph>-kenttään. Napsauta <emph>Lisää</emph>-painiketta. Juuri määritelty nimi ilmestyvät luetteloon kentän alla. Napsauta OK-painiketta valintaikkunan sulkemiseksi." ], "id_hash": -2987755555787780700, "content_hash": -2987755555787780700, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3156283\nhelp.text", "note": "XRBXG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940136/?format=api", "priority": 100, "id": 1962920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/1962920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.184870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells." ], "previous_source": "", "target": [ "Samassa valintaikkunassa voidaan nimetä myös muita solualueita antamalla niille nimi kentässä ja valitsemalla vastaava solualue sen jälkeen." ], "id_hash": 5640040777354047699, "content_hash": 5640040777354047699, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5774101\nhelp.text", "note": "wehKd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940137/?format=api", "priority": 100, "id": 1962921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/1962921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.200732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you type the name in a formula, after the first few characters entered you will see the entire name as a tip." ], "previous_source": "", "target": [ "Jos nimeä kirjoitetaan kaavassa, koko nimi ilmestyy vihjeenä muutamien ensimmäisten kirjainten jälkeen." ], "id_hash": -6183046363094129229, "content_hash": -6183046363094129229, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154942\nhelp.text", "note": "3sCdF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940138/?format=api", "priority": 100, "id": 1962922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/1962922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.212396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Press the Enter key in order to accept the name from the tip." ], "previous_source": "", "target": [ "Painetaan Enteriä vihjeestä saadun nimen hyväksymiseksi." ], "id_hash": -5008415895440623148, "content_hash": -5008415895440623148, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154510\nhelp.text", "note": "SgWa3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24940139/?format=api", "priority": 100, "id": 1962923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/1962923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.224597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Inserting External Data in Table (WebQuery)" ], "previous_source": "", "target": [ "Ulkoisen aineiston lisääminen taulukkoon (web-kysely)" ], "id_hash": 4395953768542974508, "content_hash": 4395953768542974508, "location": "webquery.xhp", "context": "webquery.xhp\ntit\nhelp.text", "note": "tT8Ku", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940142/?format=api", "priority": 100, "id": 1962926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/1962926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.264258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>HTML WebQuery</bookmark_value><bookmark_value>ranges; inserting in tables</bookmark_value><bookmark_value>external data; inserting</bookmark_value><bookmark_value>tables; inserting external data</bookmark_value><bookmark_value>web pages; importing data</bookmark_value><bookmark_value>WebQuery filter</bookmark_value><bookmark_value>inserting; external data</bookmark_value><bookmark_value>data sources; external data</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HTML-web-kysely</bookmark_value><bookmark_value>alueet; lisääminen taulukoihin</bookmark_value><bookmark_value>ulkoinen aineisto; lisääminen</bookmark_value><bookmark_value>taulukot; lisääminen, ulkoinen aineisto</bookmark_value><bookmark_value>verkkosivut; aineiston tuonti</bookmark_value><bookmark_value>web-kysely -suodatin</bookmark_value><bookmark_value>lisääminen; ulkoinen aineisto</bookmark_value><bookmark_value>tietolähteet; ulkoinen aineisto</bookmark_value>" ], "id_hash": 6483911236528808730, "content_hash": 6483911236528808730, "location": "webquery.xhp", "context": "webquery.xhp\nbm_id3154346\nhelp.text", "note": "eaFpE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940143/?format=api", "priority": 100, "id": 1962927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/1962927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.277230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet." ], "previous_source": "", "target": [ "<emph>($[officename] Calcin) web-kysely</emph> -tuontisuodattimen avulla voidaan lisätä taulukkoja HTML-asiakirjoista Calcin laskentataulukkoon." ], "id_hash": -1754040601858356598, "content_hash": -1754040601858356598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155131\nhelp.text", "note": "Uf8QW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940145/?format=api", "priority": 100, "id": 1962929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/1962929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.302587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet." ], "previous_source": "", "target": [ "Samaa menetelmää voidaan käyttää nimettyjen alueiden lisäämiseen Calcin tai Microsoft Excelin laskentataulukoista." ], "id_hash": -5329861810833699027, "content_hash": -5329861810833699027, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148575\nhelp.text", "note": "eBygd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940146/?format=api", "priority": 100, "id": 1962930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/1962930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.314702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "Seuraavat lisäämistavat ovat käytettävissä:" ], "id_hash": -391306406609619005, "content_hash": -391306406609619005, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149664\nhelp.text", "note": "odxLF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940147/?format=api", "priority": 100, "id": 1962931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/1962931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.327654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Lisääminen valintaikkunaa käyttäen" ], "id_hash": 5827784301768704225, "content_hash": 5827784301768704225, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3146976\nhelp.text", "note": "kNB42", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940148/?format=api", "priority": 100, "id": 1962932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/1962932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.339654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Aseta solukohdistin soluun, josta uuden sisällön lisääminen alkaa." ], "id_hash": 368152759068690997, "content_hash": 368152759068690997, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154319\nhelp.text", "note": "WJEih", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940149/?format=api", "priority": 100, "id": 1962933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/1962933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.349412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the <emph>Browse</emph> button to open a file selection dialog." ], "previous_source": "", "target": [ "Syötä HTML-asiakirjan URL-osoite tai laskentataulukon nimi. Paina Enteriä lopettaessasi. Napsauta <emph>...</emph> -painiketta ikkunan avaamiseksi tiedostojen valintaan." ], "id_hash": -8100371161362078385, "content_hash": -8100371161362078385, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149958\nhelp.text", "note": "AGj3g", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24940151/?format=api", "priority": 100, "id": 1962935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/1962935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.373641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "Valitse valintaikkunan suuresta luetteloruudusta lisättävät nimetyt alueet tai taulukot." ], "id_hash": -7837232548087131163, "content_hash": -7837232548087131163, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149400\nhelp.text", "note": "5b5MC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24940152/?format=api", "priority": 100, "id": 1962936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/1962936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.388061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "Voit myös määrittää, että alueet tai taulukot päivitetään n:n sekunnin välein." ], "id_hash": -2554167218865827598, "content_hash": -2554167218865827598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155064\nhelp.text", "note": "Kegfn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940153/?format=api", "priority": 100, "id": 1962937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/1962937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.402188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images." ], "previous_source": "", "target": [ "Tuontisuodatin voi luoda nimet solualueille \"lennosta\". Muotoilu pyritään säilyttämään mahdollisimman tarkkaan, mutta suodattimen tarkoituksena ei ole ladata kuvia." ], "id_hash": -356872810792596919, "content_hash": -356872810792596919, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155443\nhelp.text", "note": "ywoJU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940154/?format=api", "priority": 100, "id": 1962938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/1962938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.415459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Lisääminen rakenneselaimella" ], "id_hash": 6041129146140853600, "content_hash": 6041129146140853600, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149021\nhelp.text", "note": "HA9v2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940155/?format=api", "priority": 100, "id": 1962939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/1962939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.429430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document)." ], "previous_source": "", "target": [ "Avaa kaksi asiakirjaa: $[officename] Calcin laskentataulukko, johon ulkoinen aineisto lisätään (kohdedokumentti) ja asiakirja, josta ulkoinen aineisto saadaan (lähdedokumentti)." ], "id_hash": 5609490903737553245, "content_hash": 5609490903737553245, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3153965\nhelp.text", "note": "KpQYC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24940156/?format=api", "priority": 100, "id": 1962940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/1962940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.440681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document." ], "previous_source": "", "target": [ "Valitse rakenneselaimen alemmasta yhdistelmäruudusta lähdedokumentti. Rakenneselain esittää nyt lähdeasiakirjan sisältämät aluenimet ja tietokanta-alueet tai taulukot." ], "id_hash": 2800687121260673831, "content_hash": 2800687121260673831, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152990\nhelp.text", "note": "z9DtM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24940158/?format=api", "priority": 100, "id": 1962942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/1962942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.466554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Vedä tarvittava ulkoinen aineisto rakenneselaimesta kohdedokumenttiin." ], "id_hash": 3362152370996996680, "content_hash": 3362152370996996680, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3157978\nhelp.text", "note": "LS3Wf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24940160/?format=api", "priority": 100, "id": 1962944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/1962944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.494889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:" ], "previous_source": "", "target": [ "Jos HTML-asiakirja on ladattu <emph>web-kysely</emph> -suodattimella lähdedokumentiksi, rakenneselaimessa näkyvät taulukot, jotka on nimetty alkaen \"HTML_table1\":stä, ja myös kaksi luotua aluenimeä:" ], "id_hash": 2359732934821486848, "content_hash": 2359732934821486848, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3144768\nhelp.text", "note": "9GfqA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24940161/?format=api", "priority": 100, "id": 1962945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/1962945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.510199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_all</item> - koko asiakirjan nimenä" ], "id_hash": -6219590455625739876, "content_hash": -6219590455625739876, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152873\nhelp.text", "note": "rcjUt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24940162/?format=api", "priority": 100, "id": 1962946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/1962946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.525056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_tables</item> - kaikkien HTML-taulukoiden nimenä asiakirjassa" ], "id_hash": 6160391056425820477, "content_hash": 6160391056425820477, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149897\nhelp.text", "note": "ecFZG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24940163/?format=api", "priority": 100, "id": 1962947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/1962947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.537651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Ulkoisen aineiston linkin muokkaus" ], "id_hash": -5310202282854161437, "content_hash": -5310202282854161437, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149126\nhelp.text", "note": "TGhCr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940164/?format=api", "priority": 100, "id": 1962948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/1962948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.552830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "Avataan <emph>Muokkaa - DDE-linkit</emph>. Tässä on muokattavissa ulkoisen aineiston linkki." ], "id_hash": -3508314855120126624, "content_hash": -3508314855120126624, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3159228\nhelp.text", "note": "GEeyF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940165/?format=api", "priority": 100, "id": 1962949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/1962949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.564940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "19xx/20xx Years" ], "previous_source": "", "target": [ "Vuodet 19xx/20xx" ], "id_hash": -2226618037042233508, "content_hash": -2226618037042233508, "location": "year2000.xhp", "context": "year2000.xhp\ntit\nhelp.text", "note": "ysgCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940167/?format=api", "priority": 100, "id": 1962951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=611976b1439ebf5c", "url": "https://translations.documentfoundation.org/api/units/1962951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.590963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>vuodet; 2-numeroisina</bookmark_value><bookmark_value>päivämäärät; 19xx/20xx</bookmark_value>" ], "id_hash": 144255379794335542, "content_hash": 144255379794335542, "location": "year2000.xhp", "context": "year2000.xhp\nbm_id3150439\nhelp.text", "note": "BzWuf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940168/?format=api", "priority": 100, "id": 1962952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=82007f80ed949736", "url": "https://translations.documentfoundation.org/api/units/1962952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.607017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years." ], "previous_source": "", "target": [ "Päivämäärän vuosiluvut kirjoitetaan usein kahdella numerolla. $[officename]ssa vuosi käsitellään sisäisesti nelinumeroisena. Niinpä laskettaessa päivämäärien 1/1/99 ja 1/1/01 eroa tulos on oikea eli kaksi vuotta." ], "id_hash": -5471096442838752680, "content_hash": -5471096442838752680, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3151116\nhelp.text", "note": "DeEcT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24940170/?format=api", "priority": 100, "id": 1962954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3412c2c5b8b16258", "url": "https://translations.documentfoundation.org/api/units/1962954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.636909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029." ], "previous_source": "", "target": [ "Lehdellä <emph><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Asetukset</caseinline><defaultinline>Työkalut - Asetukset</defaultinline></switchinline> - $[officename] - Yleistä</emph> käyttäjä voi määrittää sadan vuoden ajanjakson, jota käytetään syötettäessä vuosilukuja kaksinumeroisesti. Oletuksena on 1930 ... 2029." ], "id_hash": 6606832830083740336, "content_hash": 6606832830083740336, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3154011\nhelp.text", "note": "VVD69", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1558, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24940171/?format=api", "priority": 100, "id": 1962955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=dbb02f745787b2b0", "url": "https://translations.documentfoundation.org/api/units/1962955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.652778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020." ], "previous_source": "", "target": [ "Tämä tarkoittaa, että jos syötetty päivämäärä on 1.1.30 tai myöhempi, se käsitellään sisäisesti päivämääränä 1.1.1930 ja vastaavasti tehdään myöhemmissä päivämäärissä. Kaikki pienemmät kaksinumeroiset vuodet tarkoittavat vuosia 20xx. Esimerkiksi 1.1.20 muuntuu päivämääräksi 1.1.2020." ], "id_hash": -4671804847480460976, "content_hash": -4671804847480460976, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3150010\nhelp.text", "note": "zB3Ff", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24940172/?format=api", "priority": 100, "id": 1962956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3f2a6a3e55faa950", "url": "https://translations.documentfoundation.org/api/units/1962956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.666281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error." ], "previous_source": "", "target": [ "" ], "id_hash": -4760976697520235798, "content_hash": -4760976697520235798, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265127\nhelp.text", "note": "rpHje", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24958216/?format=api", "priority": 100, "id": 8436848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3ded9ceb1864daea", "url": "https://translations.documentfoundation.org/api/units/8436848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:51.788683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 2067932330409150668, "content_hash": 2067932330409150668, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265196\nhelp.text", "note": "yhhMM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/24958217/?format=api", "priority": 100, "id": 8436849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9cb2c57f859548cc", "url": "https://translations.documentfoundation.org/api/units/8436849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.176374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The conversion is done for single scalar values only, not within ranges." ], "previous_source": "", "target": [ "" ], "id_hash": 5004329085934676593, "content_hash": 5004329085934676593, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id761567607207916\nhelp.text", "note": "iCp9E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24958218/?format=api", "priority": 100, "id": 8436850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c572f2ca224aaa71", "url": "https://translations.documentfoundation.org/api/units/8436850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.223929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The conversion is done for single scalar values, as in =A1+A2, or =\"1E2\"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string." ], "previous_source": "", "target": [ "" ], "id_hash": -577015322624017718, "content_hash": -577015322624017718, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265448\nhelp.text", "note": "C6ykS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24958219/?format=api", "priority": 100, "id": 8436851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=77fe079f0909baca", "url": "https://translations.documentfoundation.org/api/units/8436851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.380233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally)." ], "previous_source": "", "target": [ "" ], "id_hash": -8039049485159181135, "content_hash": -8039049485159181135, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485359\nhelp.text", "note": "Wn9uE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24958220/?format=api", "priority": 100, "id": 8436852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=106f8f16014cd4b1", "url": "https://translations.documentfoundation.org/api/units/8436852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.653223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In A2 enter <literal>=A1+1</literal> (which correctly results in 101)." ], "previous_source": "", "target": [ "" ], "id_hash": 3204216414153960538, "content_hash": 3204216414153960538, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485341\nhelp.text", "note": "CFpmx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24958221/?format=api", "priority": 100, "id": 8436853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ac77a9da1d1f6c5a", "url": "https://translations.documentfoundation.org/api/units/8436853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.837332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<literal>=SUM(\"1E2\";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type." ], "previous_source": "", "target": [ "" ], "id_hash": 1527828562654866949, "content_hash": 1527828562654866949, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id611567607779380\nhelp.text", "note": "hoF73", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24958222/?format=api", "priority": 100, "id": 8436855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9533effba2bd2e05", "url": "https://translations.documentfoundation.org/api/units/8436855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.957745Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Changing the default text to number conversion settings" ], "previous_source": "", "target": [ "" ], "id_hash": -7919377630657334895, "content_hash": -7919377630657334895, "location": "numbers_text.xhp", "context": "numbers_text.xhp\nhd_id871567772424915\nhelp.text", "note": "RNrFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24958223/?format=api", "priority": 100, "id": 8436856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1218b800ea7eb191", "url": "https://translations.documentfoundation.org/api/units/8436856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:53.065319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default)." ], "previous_source": "", "target": [ "" ], "id_hash": 7593992851450333545, "content_hash": 7593992851450333545, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id2078005\nhelp.text", "note": "EruAD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24958336/?format=api", "priority": 100, "id": 8467443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e9634843818d8969", "url": "https://translations.documentfoundation.org/api/units/8467443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:06.904196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "When referencing a sheet with name containing spaces, use single quotes around the name: <item type=\"literal\">='Sheet with spaces in name'.A1</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 4874882256296687640, "content_hash": 4874882256296687640, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id3147338\nhelp.text", "note": "Epbaf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24958337/?format=api", "priority": 100, "id": 8467444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c3a70f95786b3818", "url": "https://translations.documentfoundation.org/api/units/8467444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.068741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a \"$\" sign to designate it as an <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">absolute reference</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 4638398756215628616, "content_hash": 4638398756215628616, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7099826\nhelp.text", "note": "Vp5Cb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/24958338/?format=api", "priority": 100, "id": 8467446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c05ee717eed8a348", "url": "https://translations.documentfoundation.org/api/units/8467446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.564676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:" ], "previous_source": "", "target": [ "" ], "id_hash": 6382220259405813353, "content_hash": 6382220259405813353, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3150327\nhelp.text", "note": "G6mwG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24958552/?format=api", "priority": 100, "id": 8537023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d8923382f02f5669", "url": "https://translations.documentfoundation.org/api/units/8537023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.558884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc." ], "previous_source": "", "target": [ "" ], "id_hash": -7294777281101260977, "content_hash": -7294777281101260977, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148869\nhelp.text", "note": "cKHUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1451, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24958554/?format=api", "priority": 100, "id": 8537025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1ac3beb6545e974f", "url": "https://translations.documentfoundation.org/api/units/8537025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.764737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1." ], "previous_source": "", "target": [ "" ], "id_hash": 8918437824977058734, "content_hash": 8918437824977058734, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148606\nhelp.text", "note": "WtG8F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1452, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24958555/?format=api", "priority": 100, "id": 8537026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=fbc4a7f32d2a3bae", "url": "https://translations.documentfoundation.org/api/units/8537026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.923707Z" } ] }