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=9
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=10", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/units/?format=api&page=8", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In order to delete a pivot table, click any cell in the pivot table, then choose <emph>Delete</emph> in the context menu." ], "previous_source": "", "target": [ "Poistaaksesi pivot-taulukon, napsauta mitä tahansa pivot-taulukon solua ja valitse kohdevalikosta <emph>Poista</emph>." ], "id_hash": -7854945537660471433, "content_hash": -7854945537660471433, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\npar_id3154014\nhelp.text", "note": "yvJds", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24937169/?format=api", "priority": 100, "id": 1961995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=12fda0a699b53777", "url": "https://translations.documentfoundation.org/api/units/1961995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.085791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion." ], "previous_source": "", "target": [ "" ], "id_hash": 2968794790189037233, "content_hash": 2968794790189037233, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\npar_id141525148751543\nhelp.text", "note": "oFygT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24937170/?format=api", "priority": 100, "id": 1961996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a9334721e03f76b1", "url": "https://translations.documentfoundation.org/api/units/1961996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.097920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Editing Pivot Tables" ], "previous_source": "", "target": [ "Pivot-taulukoiden muokkaaminen" ], "id_hash": -5217840885408052579, "content_hash": -5217840885408052579, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\ntit\nhelp.text", "note": "9Ft4E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24937171/?format=api", "priority": 100, "id": 1961997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3796815c2abe4a9d", "url": "https://translations.documentfoundation.org/api/units/1961997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.108350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot table function; editing tables</bookmark_value><bookmark_value>editing;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukkotoiminto; taulukoiden muokkaaminen</bookmark_value><bookmark_value>muokkaaminen;pivot-taulukot</bookmark_value>" ], "id_hash": 3424683741553794699, "content_hash": 3424683741553794699, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\nbm_id3148663\nhelp.text", "note": "sdZ2P", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24937172/?format=api", "priority": 100, "id": 1961998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=af86ebb7db5e9e8b", "url": "https://translations.documentfoundation.org/api/units/1961998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.120346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click one of the buttons in the pivot table and hold the mouse button down. A special symbol will appear next to the mouse pointer." ], "previous_source": "", "target": [ "Napsauta jotain pivot-taulukon painikkeista ja pidä hiiren painike painettuna. Erityinen merkki ilmestyy hiiren osoittimen viereen." ], "id_hash": -4794520277034496322, "content_hash": -4794520277034496322, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3150868\nhelp.text", "note": "jDNdq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24937176/?format=api", "priority": 100, "id": 1962000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3d767135e2f38ebe", "url": "https://translations.documentfoundation.org/api/units/1962000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.145149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row." ], "previous_source": "", "target": [ "Vetämällä painiketta eri asemaan saman rivin painikkeisiin nähden voidaan sarakkeiden järjestystä vaihtaa. Jos painike vedetään taulukon vasempaan reunaan riviotsikoiden alueelle, voidaan sarake vaihtaa riviksi." ], "id_hash": 1313039945413799093, "content_hash": 1313039945413799093, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3145786\nhelp.text", "note": "oRj6N", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24937178/?format=api", "priority": 100, "id": 1962001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9238dadfa249acb5", "url": "https://translations.documentfoundation.org/api/units/1962001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.161584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To remove a button from the table, just drag it out of the pivot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted." ], "previous_source": "", "target": [ "Painike poistetaan taulukosta vetämällä se pivot-taulukon ulkopuolelle. Vapauta hiiren painike, kun hiiren osoitin taulukolla muuttuu 'ei käytössä' -kuvakkeeksi. Painike on poistettu." ], "id_hash": 8064735080719009737, "content_hash": 8064735080719009737, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3147434\nhelp.text", "note": "AeGto", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24937182/?format=api", "priority": 100, "id": 1962003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=efebb1d3bde347c9", "url": "https://translations.documentfoundation.org/api/units/1962003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.194026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields." ], "previous_source": "", "target": [ "Pivot-taulukossa voi käyttää vedä ja pudota tai leikkaa/liitä -komentoja tietokenttien järjestelyyn." ], "id_hash": -2833646734314458467, "content_hash": -2833646734314458467, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id2666096\nhelp.text", "note": "fKGXd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24937186/?format=api", "priority": 100, "id": 1962005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=58acdd4ef63db29d", "url": "https://translations.documentfoundation.org/api/units/1962005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.224590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside pivot tables. A custom display name is assigned to an item by overwriting the original name with another name." ], "previous_source": "", "target": [ "Voit määritellä mukautettuja nimiä pivot-taulukoissa kentille, kenttien osille, välisummille (joillakin rajauksilla) ja kokonaissummille. Mukautettu nimi annetaan kohteelle korvaamalla alkuperäinen nimi toisella." ], "id_hash": -5285605926563982336, "content_hash": -5285605926563982336, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id266609688\nhelp.text", "note": "aBysR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24937187/?format=api", "priority": 100, "id": 1962006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=36a5c16a04745400", "url": "https://translations.documentfoundation.org/api/units/1962006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.238249Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Filtering Pivot Tables" ], "previous_source": "", "target": [ "Pivot-taulukoiden suodattaminen" ], "id_hash": -4193519869293477140, "content_hash": -4193519869293477140, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\ntit\nhelp.text", "note": "Yt6DD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24937188/?format=api", "priority": 100, "id": 1962007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=45cd9fe5a83842ec", "url": "https://translations.documentfoundation.org/api/units/1962007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.250287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot table function; filtering tables</bookmark_value><bookmark_value>filtering;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukkotoiminto; taulukoiden suodattaminen</bookmark_value><bookmark_value>suodattaminen;pivot-taulukot</bookmark_value>" ], "id_hash": 3887178478322269304, "content_hash": 3887178478322269304, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\nbm_id3150792\nhelp.text", "note": "DjYdz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24937189/?format=api", "priority": 100, "id": 1962008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=b5f2083b1af13c78", "url": "https://translations.documentfoundation.org/api/units/1962008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.261492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can use filters to remove unwanted data from a pivot table." ], "previous_source": "", "target": [ "Pivot-taulukosta voi poistaa epätoivottuja tietoja suodattimilla." ], "id_hash": -5699121300235168760, "content_hash": -5699121300235168760, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id3153192\nhelp.text", "note": "ADCtg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24937191/?format=api", "priority": 100, "id": 1962010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=30e8a75f679ed408", "url": "https://translations.documentfoundation.org/api/units/1962010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.286541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field." ], "previous_source": "", "target": [ "Voit myös napsauttaa painikkeen nuolta pivot-taulukossa, jolloin ponnahdusikkuna ilmestyy. Tässä ikkunassa voi muokata siihen liittyvän kentän näkyvyysasetuksia." ], "id_hash": 8922346190446348241, "content_hash": 8922346190446348241, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id315044199\nhelp.text", "note": "TUAcu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24937193/?format=api", "priority": 100, "id": 1962012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=fbd28a966c9d47d1", "url": "https://translations.documentfoundation.org/api/units/1962012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.309474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list." ], "previous_source": "", "target": [ "Ponnahdusikkunassa näkyy kenttään liittyvät kentän osat luettelona. Kunkin kentän osan nimen vasemmalla puolella on valintaruutu. Kun kentällä on vaihtoehtoinen näyttönimi, joka eroaa alkuperäisestä nimestä, tämä nimi näkyy luettelossa." ], "id_hash": 5430743094494410191, "content_hash": 5430743094494410191, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344485\nhelp.text", "note": "SQnhK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24937194/?format=api", "priority": 100, "id": 1962013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=cb5de01235beb5cf", "url": "https://translations.documentfoundation.org/api/units/1962013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.321324Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enable or disable a checkbox to show or hide the associated field member in the pivot table." ], "previous_source": "", "target": [ "Kentän osaan liittyvän valintaruudun merkitseminen näyttää tai piilottaa sen pivot-taulukossa." ], "id_hash": 8213935646007170359, "content_hash": 8213935646007170359, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344449\nhelp.text", "note": "y6PoC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24937195/?format=api", "priority": 100, "id": 1962014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f1fdc2f3642d1537", "url": "https://translations.documentfoundation.org/api/units/1962014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.333350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Enable or disable the <emph>All</emph> checkbox to show all or none of the field members." ], "previous_source": "", "target": [ "Merkitse <emph>Kaikki</emph>-valintaruutu kaikkien kentän osien esittämiseksi. Merkittä ei näytetään mitään." ], "id_hash": -7579503326579316103, "content_hash": -7579503326579316103, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344493\nhelp.text", "note": "SW9yB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24937196/?format=api", "priority": 100, "id": 1962015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=16d031e1e5592a79", "url": "https://translations.documentfoundation.org/api/units/1962015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.345154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Show only the current item</item> button to show only the selected field member. All other field members are hidden in the pivot table." ], "previous_source": "", "target": [ "Valitse kentän osa ponnahdusikkunasta ja napsauta <item type=\"menuitem\">Näytä vain nykyinen tietue</item> -painiketta vain valitun kentän osan esittämiseksi. Kaikki muut kentän osat ovat piilotettuina pivot-taulukossa." ], "id_hash": 7497645380392457234, "content_hash": 7497645380392457234, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344431\nhelp.text", "note": "SKUBa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24937197/?format=api", "priority": 100, "id": 1962016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e80cfcbfce241412", "url": "https://translations.documentfoundation.org/api/units/1962016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.355181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Hide only the current item</item> button to hide only the selected field member. All other field members are shown in the pivot table." ], "previous_source": "", "target": [ "Valitse kentän osa ponnahdusikkunasta ja napsauta <item type=\"menuitem\">Piilota vain nykyinen tietue</item> -painiketta vain valitun kentän osan piilottamiseksi. Kaikki muut kentän osat näkyvät pivot-taulukossa." ], "id_hash": -3961528024547314001, "content_hash": -3961528024547314001, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344484\nhelp.text", "note": "BMRWS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24937198/?format=api", "priority": 100, "id": 1962017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=4905d340311a36af", "url": "https://translations.documentfoundation.org/api/units/1962017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.367236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list." ], "previous_source": "", "target": [ "Komennot mahdollistavat kentän osien järjestämiseen nousevaan tai laskevaan järjestykseen tai mukautetun järjestämisluettelon käytön." ], "id_hash": 6398235513205658305, "content_hash": 6398235513205658305, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344578\nhelp.text", "note": "YyzoD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24937199/?format=api", "priority": 100, "id": 1962018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d8cb194cc9e992c1", "url": "https://translations.documentfoundation.org/api/units/1962018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.378551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To edit the custom sort lists, open <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists." ], "previous_source": "", "target": [ "Mukautettuja järjestämisluetteloita voi muokatata valitsemalla <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME ▸ Asetukset</caseinline><defaultinline>Työkalut ▸ Asetukset</defaultinline></switchinline> - %PRODUCTNAME Calc ▸ Järjestämisluettelot." ], "id_hash": 6419540318379617403, "content_hash": 6419540318379617403, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344584\nhelp.text", "note": "VmFtw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24937200/?format=api", "priority": 100, "id": 1962019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d916c9e84a50ac7b", "url": "https://translations.documentfoundation.org/api/units/1962019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.391150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner." ], "previous_source": "", "target": [ "Nuoli, jolla ponnahdussikkuna avataan, on normaalisti musta. Kun kentässä on yksi tai useampia piilotettuja osia, nuoli on sininen ja sen oikeassa alakulmassa näkyy pieni neliö." ], "id_hash": 6742025525394214573, "content_hash": 6742025525394214573, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344811\nhelp.text", "note": "fWvXo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24937201/?format=api", "priority": 100, "id": 1962020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=dd907c7e9bbd0ead", "url": "https://translations.documentfoundation.org/api/units/1962020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.402701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D." ], "previous_source": "", "target": [ "Ponnahdusikkuna voidaan avata myös sijoittamalla solukohdistin painikkeelle ja painamalla <switchinline select=\"sys\"><caseinline select=\"MAC\">Komento</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D." ], "id_hash": -1902121773667146174, "content_hash": -1902121773667146174, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344884\nhelp.text", "note": "DBnSP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24937202/?format=api", "priority": 100, "id": 1962021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=659a4e532108a642", "url": "https://translations.documentfoundation.org/api/units/1962021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.413204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Grouping Pivot Tables" ], "previous_source": "", "target": [ "Pivot-taulukoiden ryhmittely" ], "id_hash": -4335655469519626496, "content_hash": -4335655469519626496, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\ntit\nhelp.text", "note": "CeKoE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24937203/?format=api", "priority": 100, "id": 1962022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=43d4a8525ecd9f00", "url": "https://translations.documentfoundation.org/api/units/1962022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.427162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>grouping; pivot tables</bookmark_value><bookmark_value>pivot table function;grouping table entries</bookmark_value><bookmark_value>ungrouping entries in pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ryhmittely; pivot-taulukot</bookmark_value><bookmark_value>pivot-taulukkotoiminto;taulukkomerkintöjen ryhmittely</bookmark_value><bookmark_value>merkintöjen ryhmittelyn purku pivot-taulukoissa</bookmark_value>" ], "id_hash": -30881756764189150, "content_hash": -30881756764189150, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\nbm_id4195684\nhelp.text", "note": "Kvc5K", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24937204/?format=api", "priority": 100, "id": 1962023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7f924934b207ce22", "url": "https://translations.documentfoundation.org/api/units/1962023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.440300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<variable id=\"datapilot_grouping\"><link href=\"text/scalc/guide/datapilot_grouping.xhp\">Grouping Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_grouping\"><link href=\"text/scalc/guide/datapilot_grouping.xhp\">Pivot-taulukoiden ryhmittely</link></variable>" ], "id_hash": 842687667894254175, "content_hash": 842687667894254175, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10643\nhelp.text", "note": "NEBhF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24937205/?format=api", "priority": 100, "id": 1962024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=8bb1d3f81d707a5f", "url": "https://translations.documentfoundation.org/api/units/1962024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.454013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result." ], "previous_source": "", "target": [ "Tulokseksi saatavassa pivot-taulukossa voi olla monia erilaisia merkintöjä. Niitä ryhmittelemällä näkyvää tulosta voidaan parantaa." ], "id_hash": -3903438331949886913, "content_hash": -3903438331949886913, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10661\nhelp.text", "note": "EMuyW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24937206/?format=api", "priority": 100, "id": 1962025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=49d43384b57bd23f", "url": "https://translations.documentfoundation.org/api/units/1962025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.466938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Select a cell or range of cells in the pivot table." ], "previous_source": "", "target": [ "Valitse solu tai solualue pivot-taulukossa." ], "id_hash": -8236415449389356388, "content_hash": -8236415449389356388, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10667\nhelp.text", "note": "jwZEk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24937207/?format=api", "priority": 100, "id": 1962026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=0db25fc9849baa9c", "url": "https://translations.documentfoundation.org/api/units/1962026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.479516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <emph>Data - Group and Outline - Group</emph>." ], "previous_source": "", "target": [ "Valitse <emph>Tiedot - Ryhmittele ja jäsennä - Ryhmä</emph>" ], "id_hash": 6138031007450000332, "content_hash": 6138031007450000332, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN1066B\nhelp.text", "note": "dqrNE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24937208/?format=api", "priority": 100, "id": 1962027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d52eaaae3b63ebcc", "url": "https://translations.documentfoundation.org/api/units/1962027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.493277Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two <link href=\"text/scalc/01/12090400.xhp\">Grouping</link> dialogs, either for numeric values, or for date values." ], "previous_source": "", "target": [ "Valittujen solujen muotoilusta riippuen joko uusi ryhmä lisätään pivot-taulukkoon tai näet joko numeerisille tai päivämääräarvoille tarkoitetun <link href=\"text/scalc/01/12090400.xhp\">Ryhmittely</link>-valintaikkunan." ], "id_hash": 8530320587308899497, "content_hash": 8530320587308899497, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN1066E\nhelp.text", "note": "JwFoj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24937209/?format=api", "priority": 100, "id": 1962028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f661c960eabf9ca9", "url": "https://translations.documentfoundation.org/api/units/1962028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.506714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The pivot table must be organized in a way that grouping can be applied." ], "previous_source": "", "target": [ "Pivot-taulukko täytyy järjestää siten, että ryhmittelyä voi käyttää." ], "id_hash": 7825656805752664044, "content_hash": 7825656805752664044, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_id3328653\nhelp.text", "note": "smas8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24937210/?format=api", "priority": 100, "id": 1962029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ec9a516719016fec", "url": "https://translations.documentfoundation.org/api/units/1962029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.518525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>." ], "previous_source": "", "target": [ "Ryhmittelyjen poistamiseksi napsautetaan ryhmän sisällä ja suoritetaan <emph>Tiedot - Ryhmittele ja jäsennä – Pura ryhmittely</emph>." ], "id_hash": -2586084008307701345, "content_hash": -2586084008307701345, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10682\nhelp.text", "note": "QCfxM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24937211/?format=api", "priority": 100, "id": 1962030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=5c1c624bcd80499f", "url": "https://translations.documentfoundation.org/api/units/1962030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.529611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Selecting Pivot Table Output Ranges" ], "previous_source": "", "target": [ "Pivot-taulukoiden tuotosalueiden valitseminen" ], "id_hash": 2466387850413975974, "content_hash": 2466387850413975974, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\ntit\nhelp.text", "note": "CG8kj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24937212/?format=api", "priority": 100, "id": 1962031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=a23a5eaeb643a9a6", "url": "https://translations.documentfoundation.org/api/units/1962031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.540792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot table function; preventing data overwriting</bookmark_value><bookmark_value>output ranges of pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukkotoiminto; päällekirjoituksen esto</bookmark_value><bookmark_value>tulosalueet pivot-taulukoille</bookmark_value>" ], "id_hash": -5676268997689810682, "content_hash": -5676268997689810682, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\nbm_id3148663\nhelp.text", "note": "Xwk6m", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24937213/?format=api", "priority": 100, "id": 1962032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=3139d76bb722e106", "url": "https://translations.documentfoundation.org/api/units/1962032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.556883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click the button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog will be extended." ], "previous_source": "", "target": [ "Napsauta <emph>Pivot-taulukko</emph> -valintaikkunan <emph>Lisää</emph>-painiketta. Valintaikkuna laajenee." ], "id_hash": 1881129433481891917, "content_hash": 1881129433481891917, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3154123\nhelp.text", "note": "kikhM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24937215/?format=api", "priority": 100, "id": 1962034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=9a1b1d40cb38504d", "url": "https://translations.documentfoundation.org/api/units/1962034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.582559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly." ], "previous_source": "", "target": [ "Käyttäjä voi valita nimetyn alueen, jolle pivot-taulukko luodaan <emph>Tulokset</emph>-ruudusta. Jos tuotos- eli tulosalueella ei ole nimeä, syötä alueen vasemman yläkulman solun osoite <emph>Tulokset</emph>-ruudun oikealla puolella olevaan kenttään. Voit myös napsauttaaa solua koordinaattien syöttämiseksi." ], "id_hash": 9082077293261694422, "content_hash": 9082077293261694422, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3153771\nhelp.text", "note": "rRGaZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/24937216/?format=api", "priority": 100, "id": 1962035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=fe0a052de78125d6", "url": "https://translations.documentfoundation.org/api/units/1962035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.594843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If you mark the <emph>Ignore empty rows</emph> check box, they will not be taken into account when the pivot table is created." ], "previous_source": "", "target": [ "Jos merkitset <emph>Ohita tyhjät rivit </emph>-valintaruudun, tyhjiä rivejä ei huomioida pivot-taulukkoa luotaessa." ], "id_hash": -3345562501342870709, "content_hash": -3345562501342870709, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3146974\nhelp.text", "note": "EHd6K", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24937217/?format=api", "priority": 100, "id": 1962036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=51922ca16d97434b", "url": "https://translations.documentfoundation.org/api/units/1962036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.606478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created." ], "previous_source": "", "target": [ "Jos <emph>Tunnista luokat</emph> -valintaruutu merkitään, luokat tunnistetaan otsikoidensa perusteella ja sijoitetaan vastaavasti pivot-taulukkoa luotaessa." ], "id_hash": -191296208716936319, "content_hash": -191296208716936319, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3145273\nhelp.text", "note": "qRCKc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24937218/?format=api", "priority": 100, "id": 1962037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=7d58611c988c4b81", "url": "https://translations.documentfoundation.org/api/units/1962037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.617915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Updating Pivot Tables" ], "previous_source": "", "target": [ "Pivot-taulukoiden päivittäminen" ], "id_hash": -6788373997742917749, "content_hash": -6788373997742917749, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\ntit\nhelp.text", "note": "6WBqj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24937219/?format=api", "priority": 100, "id": 1962038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=21cad9d0be08f78b", "url": "https://translations.documentfoundation.org/api/units/1962038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.629899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>pivot table import</bookmark_value><bookmark_value>pivot table function; refreshing tables</bookmark_value><bookmark_value>recalculating;pivot tables</bookmark_value><bookmark_value>updating;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot-taulukon tuonti</bookmark_value><bookmark_value>pivot-taulukkotoiminto; taulukkojen päivittäminen</bookmark_value><bookmark_value>uudelleen laskenta;pivot-taulukot</bookmark_value><bookmark_value>päivittäminen;pivot-taulukot</bookmark_value>" ], "id_hash": 3203889524059853912, "content_hash": 3203889524059853912, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\nbm_id3150792\nhelp.text", "note": "8o6oz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24937220/?format=api", "priority": 100, "id": 1962039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=ac76808c152ed458", "url": "https://translations.documentfoundation.org/api/units/1962039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.639860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc." ], "previous_source": "", "target": [ "Jos lähdetaulukon tietoja on muutettu, $[officename] laskee pivot-taulukon uudelleen. Taulukko lasketaan uudelleen valitsemalla <emph>Tiedot - Pivot-taulukko - Päivitä</emph>. Toimi samoin, kun olet tuonut Excelin pivot-taulukon $[officename] Calciin." ], "id_hash": 6120207290802278664, "content_hash": 6120207290802278664, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\npar_id3154684\nhelp.text", "note": "gaKCU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24937222/?format=api", "priority": 100, "id": 1962041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=d4ef581ad0069108", "url": "https://translations.documentfoundation.org/api/units/1962041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.664373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Importing and Exporting dBASE Files" ], "previous_source": "", "target": [ "dBASE-tiedostojen tuonti ja vienti" ], "id_hash": 7395598904683807561, "content_hash": 7395598904683807561, "location": "dbase_files.xhp", "context": "dbase_files.xhp\ntit\nhelp.text", "note": "kDqTU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24937223/?format=api", "priority": 100, "id": 1962042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=e6a272052ef24349", "url": "https://translations.documentfoundation.org/api/units/1962042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.676356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<bookmark_value>exporting;spreadsheets to dBASE</bookmark_value> <bookmark_value>importing;dBASE files</bookmark_value> <bookmark_value>dBASE import/export</bookmark_value> <bookmark_value>spreadsheets; importing from/exporting to dBASE files</bookmark_value> <bookmark_value>tables in databases;importing dBASE files</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>vienti;laskentataulukot dBASEen</bookmark_value> <bookmark_value>tuonti;dBASE-tiedostot</bookmark_value> <bookmark_value>dBASE -tuonti/ -vienti</bookmark_value> <bookmark_value>laskentataulukot; dBASE-tiedostomuodon tuonti/ -vienti </bookmark_value><bookmark_value>taulut tietokannoissa;dBASE-tiedostojen tuonti</bookmark_value>" ], "id_hash": -6115726648041509010, "content_hash": -6115726648041509010, "location": "dbase_files.xhp", "context": "dbase_files.xhp\nbm_id1226844\nhelp.text", "note": "DkG3C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24937224/?format=api", "priority": 100, "id": 1962043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=2b20930420186f6e", "url": "https://translations.documentfoundation.org/api/units/1962043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.686436Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "<variable id=\"dbase_files\"><link href=\"text/scalc/guide/dbase_files.xhp\">Importing and Exporting dBASE Files</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"dbase_files\"><link href=\"text/scalc/guide/dbase_files.xhp\">dBASE-tiedostojen tuonti ja vienti</link></variable>" ], "id_hash": 161637248228085591, "content_hash": 161637248228085591, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10738\nhelp.text", "note": "phARr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24937225/?format=api", "priority": 100, "id": 1962044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=823e40388b1b4f57", "url": "https://translations.documentfoundation.org/api/units/1962044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.698350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME." ], "previous_source": "", "target": [ "Käyttäjä voi avata ja tallentaa dBASE-tiedostomuotoista aineistoa (*.dbf -tiedostotunnus) $[officename] Basessa tai Calcissa. %PRODUCTNAME Basessa, dBASE-tietokanta on *.dbf -tiedostotunnuksellisten tiedostojen kansio. Kukin tiedosto vastaa taulua tietokannassa. Kaavat ja muotoilut menetetään, kun dBASE-tiedosto avataan ja tallennetaan %PRODUCTNAMEsta." ], "id_hash": 1782665680064101011, "content_hash": 1782665680064101011, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10756\nhelp.text", "note": "J3aQ5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/24937226/?format=api", "priority": 100, "id": 1962045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=98bd4cfdb5803a93", "url": "https://translations.documentfoundation.org/api/units/1962045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.711436Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "To Import a dBASE File Into a Spreadsheet" ], "previous_source": "", "target": [ "dBASE-tiedoston tuominen taulukkolaskentaan" ], "id_hash": 8437163193353355654, "content_hash": 8437163193353355654, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10759\nhelp.text", "note": "jVz9V", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24937227/?format=api", "priority": 100, "id": 1962046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f516d338ebd3c186", "url": "https://translations.documentfoundation.org/api/units/1962046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.724080Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Choose <emph>File - Open</emph>." ], "previous_source": "", "target": [ "Valitse <emph>Tiedosto - Avaa</emph>" ], "id_hash": 1683519698946321679, "content_hash": 1683519698946321679, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10760\nhelp.text", "note": "v3JdV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24937228/?format=api", "priority": 100, "id": 1962047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=975d103f1c116d0f", "url": "https://translations.documentfoundation.org/api/units/1962047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.734810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Locate the *.dbf file that you want to import." ], "previous_source": "", "target": [ "Paikallista tuotava *.dbf-tiedosto." ], "id_hash": 411317677609335887, "content_hash": 411317677609335887, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN1071F\nhelp.text", "note": "FmmZC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24937229/?format=api", "priority": 100, "id": 1962048, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=85b54b3f9fbe3c4f", "url": "https://translations.documentfoundation.org/api/units/1962048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.746860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "Click <emph>Open</emph>." ], "previous_source": "", "target": [ "Napsauta <emph>Avaa</emph>." ], "id_hash": -7192977753618697200, "content_hash": -7192977753618697200, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10768\nhelp.text", "note": "cBR6P", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24937230/?format=api", "priority": 100, "id": 1962049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=1c2d68d7d6453410", "url": "https://translations.documentfoundation.org/api/units/1962049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.759534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/fi/?format=api", "source": [ "The <emph>Import dBASE files</emph> dialog opens." ], "previous_source": "", "target": [ "<emph>DBase-tiedostojen tuonti</emph> -valintaikkuna avautuu." ], "id_hash": -2029065530847235774, "content_hash": -2029065530847235774, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10730\nhelp.text", "note": "WQGdy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24937231/?format=api", "priority": 100, "id": 1962050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=63d74fa66fdc7142", "url": "https://translations.documentfoundation.org/api/units/1962050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.771316Z" }, { "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": 8173225935057001163, "content_hash": 8173225935057001163, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10774\nhelp.text", "note": "S2JPc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24937232/?format=api", "priority": 100, "id": 1962051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/fi/?checksum=f16d21af30151acb", "url": "https://translations.documentfoundation.org/api/units/1962051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.788202Z" } ] }{ "count": 1559, "next": "