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=8
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=9", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=7", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "For example, if the language is set to \"Default\" and you are using a german locale setting, the currency format will be \"1.234,00 €\". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format \"$ English (US)\" from the <item type=\"menuitem\">Format</item> list box , you will get the following format: \"$ 1.234,00\". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting." ], "previous_source": "", "target": [ "Jos esimerkiksi kielivalinta on \"Oletus\" ja käytät saksankielistä lokaaliasetusta, valuuttamuotoiluksi tulee \"1.234,00 €\". Pistettä käytetään ennen tuhansien numeroa ja pilkkua ennen desimaalinumeroita. Jos sitten valitsen alisteisen valuuttamuotoilun \"$ englanti (Yhdysvallat)\" <item type=\"menuitem\">Muotoilu</item>-luetteloruudusta, muotoiluksitulee: \"$ 1.234,00\". Kuten näkyy, erotinmerkit säilyvät samoina. Vain valuuttasymboli on vaihtunut ja siirtynyt, mutta perusmuotoilu säilyy lokaaliasetuksen mukaisena." ], "id_hash": -6926324213646934264, "content_hash": -6926324213646934264, "location": "currency_format.xhp", "context": "currency_format.xhp\npar_id3150749\nhelp.text", "note": "7b98J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 99, "source_unit": "https://translations.documentfoundation.org/api/units/24936895/?format=api", "priority": 100, "id": 1961926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1fe0c0d32e633f08", "url": "https://translations.documentfoundation.org/api/units/1961926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.241448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If, under <item type=\"menuitem\">Language</item>, you convert the cells to \"English (US)\", the English-language locale setting is also transferred and the default currency format is now \"$ 1,234.00\"." ], "previous_source": "", "target": [ "Jos muunnat <item type=\"menuitem\">Kieli</item>-kohdassa solut \"englanti (Yhdysvallat)\"-kielelle, englanninkielinen lokaaliasetus siirretään myös ja oletusvaluuttamuodoksi tulee \"$ 1,234.00\"." ], "id_hash": 7309778055375444582, "content_hash": 7309778055375444582, "location": "currency_format.xhp", "context": "currency_format.xhp\npar_id3145640\nhelp.text", "note": "MNnnJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936896/?format=api", "priority": 100, "id": 1961927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e5718c6999995a66", "url": "https://translations.documentfoundation.org/api/units/1961927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.254581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Defining Database Ranges" ], "previous_source": "", "target": [ "Tietokanta-alueiden määritys" ], "id_hash": 8161635055328480313, "content_hash": 8161635055328480313, "location": "database_define.xhp", "context": "database_define.xhp\ntit\nhelp.text", "note": "QoTwd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936898/?format=api", "priority": 100, "id": 1961929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f143f3d7333acc39", "url": "https://translations.documentfoundation.org/api/units/1961929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.279952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>tables; database ranges</bookmark_value> <bookmark_value>database ranges; defining</bookmark_value> <bookmark_value>ranges; defining database ranges</bookmark_value> <bookmark_value>defining;database ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>taulukot; tietokanta-alue</bookmark_value><bookmark_value>tietokanta-alue (Calc); määrittäminen</bookmark_value><bookmark_value>alueet; tietokanta-alueen määrittäminen</bookmark_value><bookmark_value>määrittäminen; tietokanta-alueet</bookmark_value>" ], "id_hash": -3601115479747594988, "content_hash": -3601115479747594988, "location": "database_define.xhp", "context": "database_define.xhp\nbm_id3154758\nhelp.text", "note": "vjEu6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936899/?format=api", "priority": 100, "id": 1961930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4e06448cfa7bf514", "url": "https://translations.documentfoundation.org/api/units/1961930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.291759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database." ], "previous_source": "", "target": [ "Laskentataulukon solualue voidaan määrittää käytettäväksi kortistotyyppisenä tietokantana. Kukin tietokanta-alueen rivi vastaa tietuetta ja kukin rivin solu vastaa kenttää. Alueella voi suorittaa tietokannan taulun tapaan lajittelua, ryhmittelyä, hakua ja laskentaa." ], "id_hash": -6147964892927180623, "content_hash": -6147964892927180623, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3153768\nhelp.text", "note": "4BdV5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/24936901/?format=api", "priority": 100, "id": 1961932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2aae0a80d180c0b1", "url": "https://translations.documentfoundation.org/api/units/1961932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.318312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the %PRODUCTNAME Data Sources view." ], "previous_source": "", "target": [ "Tietokanta-alueelle pääsee vain alueen sisältävästä laskentataulukosta. Tietokanta-alueelle ei pääse %PRODUCTNAMEn tietolähteen näkymästä." ], "id_hash": -6972678064157051446, "content_hash": -6972678064157051446, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3145801\nhelp.text", "note": "YkmRD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24936902/?format=api", "priority": 100, "id": 1961933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1f3c123e54c2b5ca", "url": "https://translations.documentfoundation.org/api/units/1961933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.330384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To define a database range" ], "previous_source": "", "target": [ "Tietokanta-alueen määrittäminen" ], "id_hash": -4980107857182101692, "content_hash": -4980107857182101692, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10648\nhelp.text", "note": "7A9DZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 470, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936903/?format=api", "priority": 100, "id": 1961934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3ae31a4a25876f44", "url": "https://translations.documentfoundation.org/api/units/1961934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.342948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select the range of cells that you want to define as a database range." ], "previous_source": "", "target": [ "Valitse solualue, jonka määrität tietokanta-alueeksi." ], "id_hash": -5716380299882385718, "content_hash": -5716380299882385718, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3155064\nhelp.text", "note": "ViixK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936904/?format=api", "priority": 100, "id": 1961935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=30ab566768782eca", "url": "https://translations.documentfoundation.org/api/units/1961935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.356790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Define Range</item>." ], "previous_source": "", "target": [ "Valitse <item type=\"menuitem\">Tiedot - Määritä alue</item>." ], "id_hash": -8718462659865829421, "content_hash": -8718462659865829421, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10654\nhelp.text", "note": "koZRd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936905/?format=api", "priority": 100, "id": 1961936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0701cc673b309fd3", "url": "https://translations.documentfoundation.org/api/units/1961936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.369387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the <emph>Name</emph> box, enter a name for the database range." ], "previous_source": "", "target": [ "Nimeä laskentataulukon tietokanta-alue <emph>Nimi</emph>-ruudussa." ], "id_hash": 365860580262899119, "content_hash": 365860580262899119, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3153715\nhelp.text", "note": "C4Pvr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936906/?format=api", "priority": 100, "id": 1961937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=8513cc4263e36daf", "url": "https://translations.documentfoundation.org/api/units/1961937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.379407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <emph>More</emph>." ], "previous_source": "", "target": [ "Napsauta <emph>Lisää</emph>." ], "id_hash": -3797940598461728499, "content_hash": -3797940598461728499, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN1066A\nhelp.text", "note": "2X6GR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936907/?format=api", "priority": 100, "id": 1961938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4b4b0125e6a7790d", "url": "https://translations.documentfoundation.org/api/units/1961938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.390478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Specify the options for the database range." ], "previous_source": "", "target": [ "Määritä tietokanta-alueen asetukset." ], "id_hash": -8982738920191813812, "content_hash": -8982738920191813812, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3154253\nhelp.text", "note": "zp2Nx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936908/?format=api", "priority": 100, "id": 1961939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0356e68b6fe4174c", "url": "https://translations.documentfoundation.org/api/units/1961939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.402382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Hyväksy <emph>OK</emph>:lla." ], "id_hash": 6797402938266597101, "content_hash": 6797402938266597101, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10675\nhelp.text", "note": "gDERf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936909/?format=api", "priority": 100, "id": 1961940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=de5539f54a93b6ed", "url": "https://translations.documentfoundation.org/api/units/1961940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.412757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Filtering Cell Ranges" ], "previous_source": "", "target": [ "Solualueiden suodatus" ], "id_hash": 7455717594612681674, "content_hash": 7455717594612681674, "location": "database_filter.xhp", "context": "database_filter.xhp\ntit\nhelp.text", "note": "q4WSq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936910/?format=api", "priority": 100, "id": 1961941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e77807a67484cbca", "url": "https://translations.documentfoundation.org/api/units/1961941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.424357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>cell ranges;applying/removing filters</bookmark_value> <bookmark_value>filtering;cell ranges/database ranges</bookmark_value> <bookmark_value>database ranges;applying/removing filters</bookmark_value> <bookmark_value>removing;cell range filters</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>solualueet;suodattimien käyttö/poistaminen</bookmark_value><bookmark_value>suodatus;solualueet/tietokanta-alueet</bookmark_value><bookmark_value>tietokanta-alueet;suodattimien käyttö/poistaminen</bookmark_value><bookmark_value>poistaminen;solualueen suodattimet</bookmark_value>" ], "id_hash": 8596340142817540448, "content_hash": 8596340142817540448, "location": "database_filter.xhp", "context": "database_filter.xhp\nbm_id3153541\nhelp.text", "note": "DERXE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936911/?format=api", "priority": 100, "id": 1961942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f74c55d08511f960", "url": "https://translations.documentfoundation.org/api/units/1961942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.436258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells." ], "previous_source": "", "target": [ "Laskentataulukoiden solualueiden suodattamiseen voidaan käyttää useita suodattimia. Oletussuodatin käyttää käyttäjän määrittämiä asetuksia aineiston suodattamisessa. Automaattinen suodatus suodattaa aineiston määrätyn arvon tai merkkijonon mukaisesti. Erityissuodatus käyttää soluissa määritettyjä suodatusehtoja." ], "id_hash": -4490544092738168518, "content_hash": -4490544092738168518, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3145069\nhelp.text", "note": "4znQt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/24936913/?format=api", "priority": 100, "id": 1961944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=41ae61f0881cd93a", "url": "https://translations.documentfoundation.org/api/units/1961944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.461286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Apply a Standard Filter to a Cell Range" ], "previous_source": "", "target": [ "Oletussuodattimen käyttö solualueella" ], "id_hash": 5578512712961670346, "content_hash": 5578512712961670346, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10682\nhelp.text", "note": "e7DZH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936914/?format=api", "priority": 100, "id": 1961945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=cd6adbc19714bcca", "url": "https://translations.documentfoundation.org/api/units/1961945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.474111Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click in a cell range." ], "previous_source": "", "target": [ "Napsauta solualueella." ], "id_hash": -781988736639477845, "content_hash": -781988736639477845, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3150398\nhelp.text", "note": "SiEGx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936915/?format=api", "priority": 100, "id": 1961946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7525d1631e3f57ab", "url": "https://translations.documentfoundation.org/api/units/1961946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.486395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - More Filters - Standard Filter</item>." ], "previous_source": "", "target": [ "" ], "id_hash": 5808399452450022911, "content_hash": 5808399452450022911, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10693\nhelp.text", "note": "WG4wc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936916/?format=api", "priority": 100, "id": 1961947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d09b94871cdb65ff", "url": "https://translations.documentfoundation.org/api/units/1961947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.499329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the <emph>Standard Filter</emph> dialog, specify the filter options that you want." ], "previous_source": "", "target": [ "Määritä <emph>Oletussuodatin</emph>-valintaikkunassa käytettävät suodatusasetukset." ], "id_hash": 1534539389418284111, "content_hash": 1534539389418284111, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3156422\nhelp.text", "note": "Hxxpj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936917/?format=api", "priority": 100, "id": 1961948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=954bc771c01f244f", "url": "https://translations.documentfoundation.org/api/units/1961948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.512213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Hyväksy <emph>OK</emph>:lla." ], "id_hash": 7457560869786805481, "content_hash": 7457560869786805481, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106A5\nhelp.text", "note": "vcg5k", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936918/?format=api", "priority": 100, "id": 1961949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e77e9419667ee4e9", "url": "https://translations.documentfoundation.org/api/units/1961949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.524430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The records that match the filter options that you specified are shown." ], "previous_source": "", "target": [ "Valitun suodatusehdon täyttävät tietueet näytetään." ], "id_hash": -242174767239507446, "content_hash": -242174767239507446, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153143\nhelp.text", "note": "qmFD9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936919/?format=api", "priority": 100, "id": 1961950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7ca39f551120520a", "url": "https://translations.documentfoundation.org/api/units/1961950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.536691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Apply an AutoFilter to a Cell Range" ], "previous_source": "", "target": [ "Automaattisen suodatuksen käyttö solualueella" ], "id_hash": -8482260120029773788, "content_hash": -8482260120029773788, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153728\nhelp.text", "note": "zUCBf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936920/?format=api", "priority": 100, "id": 1961951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0a48f55c9d29c024", "url": "https://translations.documentfoundation.org/api/units/1961951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.548537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click in a cell range or a database range." ], "previous_source": "", "target": [ "Napsauta solualuetta tai tietokanta-aluetta." ], "id_hash": -7248638314472881967, "content_hash": -7248638314472881967, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3144764\nhelp.text", "note": "tqAMd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936921/?format=api", "priority": 100, "id": 1961952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1b67a9dba08ec0d1", "url": "https://translations.documentfoundation.org/api/units/1961952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.560661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you want to apply multiple AutoFilters to the same sheet, you must first define database ranges, then apply the AutoFilters to the database ranges." ], "previous_source": "", "target": [ "Jos halutaan käyttää useampaa automaattista suodatusta samassa taulukossa, ensin pitää määrittää tietokanta-alueet ja käyttää sitten automaattista suodatusta tietokanta-alueisiin." ], "id_hash": -14938434316189351, "content_hash": -14938434316189351, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id9303872\nhelp.text", "note": "EFRDW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24936922/?format=api", "priority": 100, "id": 1961953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7fcaed92b9154159", "url": "https://translations.documentfoundation.org/api/units/1961953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.573239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - AutoFilter</item>." ], "previous_source": "", "target": [ "" ], "id_hash": 3378529364349136589, "content_hash": 3378529364349136589, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3154944\nhelp.text", "note": "ayGC2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936923/?format=api", "priority": 100, "id": 1961954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=aee2f28e8141aecd", "url": "https://translations.documentfoundation.org/api/units/1961954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.588729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "An arrow button is added to the head of each column in the database range." ], "previous_source": "", "target": [ "Nuolivalitsin lisätään kuhunkin sarakeotsikkoon tietokanta-alueella." ], "id_hash": 1785195128466246270, "content_hash": 1785195128466246270, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106DB\nhelp.text", "note": "8jfFs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936924/?format=api", "priority": 100, "id": 1961955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=98c64982cefd0a7e", "url": "https://translations.documentfoundation.org/api/units/1961955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.599824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click the arrow button in the column that contains the value or string that you want to set as the filter criteria." ], "previous_source": "", "target": [ "Napsauta sen sarakkeen nuolivalitsinta, jossa on suodatusehdoksi asetettava arvo tai merkkijono." ], "id_hash": -7524984236917080831, "content_hash": -7524984236917080831, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153878\nhelp.text", "note": "buscD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24936925/?format=api", "priority": 100, "id": 1961956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1791e2b4a224bd01", "url": "https://translations.documentfoundation.org/api/units/1961956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.611722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select the value or string that you want to use as the filter criteria." ], "previous_source": "", "target": [ "Valitse arvo tai merkkijono, jota käytetään suodatusehtona." ], "id_hash": -6159115828387426799, "content_hash": -6159115828387426799, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10749\nhelp.text", "note": "vFUzG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936926/?format=api", "priority": 100, "id": 1961957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2a866cc9567b4e11", "url": "https://translations.documentfoundation.org/api/units/1961957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.623313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The records that match the filter criteria that you selected are shown." ], "previous_source": "", "target": [ "Valitun suodatusehdon täyttävät tietueet näytetään." ], "id_hash": 2406891623540612906, "content_hash": 2406891623540612906, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN1074C\nhelp.text", "note": "H4Cqe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936927/?format=api", "priority": 100, "id": 1961958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a166ff2dea005f2a", "url": "https://translations.documentfoundation.org/api/units/1961958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.636025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Remove a Filter From a Cell Range" ], "previous_source": "", "target": [ "Suodatuksen poistaminen solualueelta" ], "id_hash": -4190959145163739741, "content_hash": -4190959145163739741, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106E8\nhelp.text", "note": "fkmqA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936928/?format=api", "priority": 100, "id": 1961959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=45d6b8dcb4572da3", "url": "https://translations.documentfoundation.org/api/units/1961959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.649061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click in a filtered cell range." ], "previous_source": "", "target": [ "Napsauta suodatettua solualuetta." ], "id_hash": 5281635393044491942, "content_hash": 5281635393044491942, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN1075C\nhelp.text", "note": "85fDm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936929/?format=api", "priority": 100, "id": 1961960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c94c23681b8c2ea6", "url": "https://translations.documentfoundation.org/api/units/1961960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.663431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Filter - Reset Filter</item>." ], "previous_source": "", "target": [ "Valitse <item type=\"menuitem\">Tiedot - Suodatus - Poista suodatus</item>." ], "id_hash": -1143336285952618008, "content_hash": -1143336285952618008, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106EC\nhelp.text", "note": "H7icE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936930/?format=api", "priority": 100, "id": 1961961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=70220db4a0fad1e8", "url": "https://translations.documentfoundation.org/api/units/1961961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.678225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Sorting Data" ], "previous_source": "", "target": [ "Lajittelu tietokanta-alueilla" ], "id_hash": -1678035711575406533, "content_hash": -1678035711575406533, "location": "database_sort.xhp", "context": "database_sort.xhp\ntit\nhelp.text", "note": "ueLu8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936932/?format=api", "priority": 100, "id": 1961963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=68b66b693320c83b", "url": "https://translations.documentfoundation.org/api/units/1961963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.714569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>database ranges; sorting</bookmark_value> <bookmark_value>sorting; database ranges</bookmark_value> <bookmark_value>data;sorting in databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>tietokanta-alueet (Calc);lajittelu</bookmark_value><bookmark_value>lajittelu;tietokanta-alueet (Calc)</bookmark_value><bookmark_value>aineisto;lajittelu tietokanta-alueilla (Calc)</bookmark_value>" ], "id_hash": 1824297674026058534, "content_hash": 1824297674026058534, "location": "database_sort.xhp", "context": "database_sort.xhp\nbm_id3150767\nhelp.text", "note": "qvJdv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936933/?format=api", "priority": 100, "id": 1961964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=99513511a8e50326", "url": "https://translations.documentfoundation.org/api/units/1961964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.728062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click in a database range." ], "previous_source": "", "target": [ "Napsauta tietokanta-alueella." ], "id_hash": -6892889147954750633, "content_hash": -6892889147954750633, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id3145751\nhelp.text", "note": "vddXD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936935/?format=api", "priority": 100, "id": 1961966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=205789d70c031b57", "url": "https://translations.documentfoundation.org/api/units/1961966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.752621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted." ], "previous_source": "", "target": [ "Jos valitaan solualue, vain nämä solut lajitellaan. Jos napsautetaan yhtä solua valitsematta, silloin koko tietokanta-alue lajitellaan." ], "id_hash": -7684388754638796622, "content_hash": -7684388754638796622, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121549\nhelp.text", "note": "BjSBG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936936/?format=api", "priority": 100, "id": 1961967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=155b91242bbf88b2", "url": "https://translations.documentfoundation.org/api/units/1961967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.763775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Sort</item>." ], "previous_source": "", "target": [ "Valitse <item type=\"menuitem\">Tiedot - Lajittele</item>." ], "id_hash": -6575395747031862181, "content_hash": -6575395747031862181, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN10635\nhelp.text", "note": "LpURK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936937/?format=api", "priority": 100, "id": 1961968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=24bf8067f08d345b", "url": "https://translations.documentfoundation.org/api/units/1961968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.774789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The range of cells that will get sorted is shown in inverted colors." ], "previous_source": "", "target": [ "Lajiteltavien solujen alue esitetään käänteisväreissä." ], "id_hash": -8960912715893032440, "content_hash": -8960912715893032440, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121547\nhelp.text", "note": "t46AF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936938/?format=api", "priority": 100, "id": 1961969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=03a4715ca1ea3a08", "url": "https://translations.documentfoundation.org/api/units/1961969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.786334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Hyväksy <emph>OK</emph>:lla." ], "id_hash": 7116653827745536730, "content_hash": 7116653827745536730, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN1063D\nhelp.text", "note": "dxfCa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936940/?format=api", "priority": 100, "id": 1961971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e2c36ef360325ada", "url": "https://translations.documentfoundation.org/api/units/1961971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.812841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Pivot Table" ], "previous_source": "", "target": [ "Pivot-taulukko" ], "id_hash": 634472502535055328, "content_hash": 634472502535055328, "location": "datapilot.xhp", "context": "datapilot.xhp\ntit\nhelp.text", "note": "zsSK8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936942/?format=api", "priority": 100, "id": 1961973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=88ce1961255ae7e0", "url": "https://translations.documentfoundation.org/api/units/1961973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.836152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot table function; introduction</bookmark_value><bookmark_value>DataPilot, see pivot table function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukkotoiminto; esittely</bookmark_value><bookmark_value>tietojen ohjaus, katso pivot-taulukkotoiminto</bookmark_value>" ], "id_hash": 208459899671545873, "content_hash": 208459899671545873, "location": "datapilot.xhp", "context": "datapilot.xhp\nbm_id3150448\nhelp.text", "note": "q3UkA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936943/?format=api", "priority": 100, "id": 1961974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=82e4992c9dd60811", "url": "https://translations.documentfoundation.org/api/units/1961974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.847003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports." ], "previous_source": "", "target": [ "<emph>Pivot-taulukon</emph> (tunnettiin aiemmin nimellä <emph>tietojen ohjaus</emph>) avulla voi yhdistää, verrata ja analysoida suuria tietomääriä. Voit tarkastella lähdeaineiston erilaisia yhteenvetoja tai esittää kiinnostavan alueen yksityiskohtia sekä luoda raportteja." ], "id_hash": -2698616069608549419, "content_hash": -2698616069608549419, "location": "datapilot.xhp", "context": "datapilot.xhp\npar_id3156024\nhelp.text", "note": "X3qFY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24936945/?format=api", "priority": 100, "id": 1961976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5a8c96fb89d253d5", "url": "https://translations.documentfoundation.org/api/units/1961976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.871131Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Creating Pivot Tables" ], "previous_source": "", "target": [ "Pivot-taulukoiden luominen" ], "id_hash": 7178156368634310857, "content_hash": 7178156368634310857, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\ntit\nhelp.text", "note": "cGChV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936947/?format=api", "priority": 100, "id": 1961978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e39def2f8ea7f0c9", "url": "https://translations.documentfoundation.org/api/units/1961978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.896258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot tables</bookmark_value> <bookmark_value>pivot table function; calling up and applying</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukot</bookmark_value><bookmark_value>pivot-taulukkotoiminto; käynnistys ja käyttö</bookmark_value>" ], "id_hash": -7880776485035476364, "content_hash": -7880776485035476364, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\nbm_id3148491\nhelp.text", "note": "kEK57", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936948/?format=api", "priority": 100, "id": 1961979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=12a1db8a7f357a74", "url": "https://translations.documentfoundation.org/api/units/1961979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.905544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Position the cursor within a range of cells containing values, row and column headings." ], "previous_source": "", "target": [ "Sijoita kohdistin solualueelle, jossa on arvot sekä rivi- ja sarakeotsikot." ], "id_hash": 4946745694602108261, "content_hash": 4946745694602108261, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156023\nhelp.text", "note": "qrneD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936950/?format=api", "priority": 100, "id": 1961981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=c4a65f0010f39d65", "url": "https://translations.documentfoundation.org/api/units/1961981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.928097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Drag the desired buttons into one of the four areas." ], "previous_source": "", "target": [ "Vedä painikkeita neljälle alueelle tarpeita vastaavasti." ], "id_hash": 7476088695115802925, "content_hash": 7476088695115802925, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150868\nhelp.text", "note": "XR8Sd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936952/?format=api", "priority": 100, "id": 1961983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e7c0670ee5b0e92d", "url": "https://translations.documentfoundation.org/api/units/1961983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.949029Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data." ], "previous_source": "", "target": [ "Jos painike pudotetaan <emph>Tietokentät</emph>-alueelle, sen nimikkeeseen tulee näkyviin myös aineiston laskennassa käytettävä kaava." ], "id_hash": 1622151538385423318, "content_hash": 1622151538385423318, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3154011\nhelp.text", "note": "vFX84", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936954/?format=api", "priority": 100, "id": 1961985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=96830a3ac9510bd6", "url": "https://translations.documentfoundation.org/api/units/1961985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.972360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Use the <item type=\"menuitem\">Data Field</item> dialog to select the calculations to be used for the data. To make a multiple selection, press the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while clicking the desired calculation." ], "previous_source": "", "target": [ "<item type=\"menuitem\">Tietokenttä</item>-valintaikkunaa käytetään aineistolle suoritettavan laskentatavan valitsemiseen. Monivalinta suoritetaan painamalla <switchinline select=\"sys\"><caseinline select=\"MAC\">Komento</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-näppäintä napsautettaessa halutuissa kohdin." ], "id_hash": -7996044650938525023, "content_hash": -7996044650938525023, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156286\nhelp.text", "note": "PAuDC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24936956/?format=api", "priority": 100, "id": 1961987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=110857c13ca59aa1", "url": "https://translations.documentfoundation.org/api/units/1961987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.994196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse." ], "previous_source": "", "target": [ "Painikkeiden asemaa voidaan muuttaa milloin tahansa hiirellä." ], "id_hash": -4781468655574914518, "content_hash": -4781468655574914518, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150329\nhelp.text", "note": "AniFD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936957/?format=api", "priority": 100, "id": 1961988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3da4cf974fcaea2a", "url": "https://translations.documentfoundation.org/api/units/1961988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.005874Z" } ] }{ "count": 1559, "next": "