Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=11
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=12", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=10", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Click in a database range." ], "previous_source": "", "target": [ "Click in a database range." ], "id_hash": -6892889147954750633, "content_hash": -6892889147954750633, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id3145751\nhelp.text", "note": "vddXD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110806630/?format=api", "priority": 100, "id": 110806630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=205789d70c031b57", "url": "https://translations.documentfoundation.org/api/units/110806630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.831759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -7684388754638796622, "content_hash": -7684388754638796622, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121549\nhelp.text", "note": "BjSBG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110806669/?format=api", "priority": 100, "id": 110806669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=155b91242bbf88b2", "url": "https://translations.documentfoundation.org/api/units/110806669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.846575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Sort</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Sort</item>." ], "id_hash": -6575395747031862181, "content_hash": -6575395747031862181, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN10635\nhelp.text", "note": "LpURK", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110806699/?format=api", "priority": 100, "id": 110806699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=24bf8067f08d345b", "url": "https://translations.documentfoundation.org/api/units/110806699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.865148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The range of cells that will get sorted is shown in inverted colors." ], "previous_source": "", "target": [ "The range of cells that will get sorted is shown in inverted colors." ], "id_hash": -8960912715893032440, "content_hash": -8960912715893032440, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121547\nhelp.text", "note": "t46AF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110806759/?format=api", "priority": 100, "id": 110806759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=03a4715ca1ea3a08", "url": "https://translations.documentfoundation.org/api/units/110806759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.897875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select the sort options that you want." ], "previous_source": "", "target": [ "Select the sort options that you want." ], "id_hash": -4872610822667135110, "content_hash": -4872610822667135110, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN10645\nhelp.text", "note": "HGBLx", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110806790/?format=api", "priority": 100, "id": 110806790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3c610245e233977a", "url": "https://translations.documentfoundation.org/api/units/110806790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.915453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Click <emph>OK</emph>." ], "id_hash": 7116653827745536730, "content_hash": 7116653827745536730, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN1063D\nhelp.text", "note": "dxfCa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110806802/?format=api", "priority": 100, "id": 110806802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e2c36ef360325ada", "url": "https://translations.documentfoundation.org/api/units/110806802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.925050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range\">Wiki page about defining a data range</link>" ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range\">Wiki page about defining a data range</link>" ], "id_hash": 8456247589295304414, "content_hash": 8456247589295304414, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id1846980\nhelp.text", "note": "biDGg", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110806810/?format=api", "priority": 100, "id": 110806810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f55aa0611cb32ede", "url": "https://translations.documentfoundation.org/api/units/110806810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.933918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table" ], "previous_source": "", "target": [ "Pivot Table" ], "id_hash": 634472502535055328, "content_hash": 634472502535055328, "location": "datapilot.xhp", "context": "datapilot.xhp\ntit\nhelp.text", "note": "zsSK8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110806818/?format=api", "priority": 100, "id": 110806818, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=88ce1961255ae7e0", "url": "https://translations.documentfoundation.org/api/units/110806818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.944786Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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 table function; introduction</bookmark_value><bookmark_value>DataPilot, see pivot table function</bookmark_value>" ], "id_hash": 208459899671545873, "content_hash": 208459899671545873, "location": "datapilot.xhp", "context": "datapilot.xhp\nbm_id3150448\nhelp.text", "note": "q3UkA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110806826/?format=api", "priority": 100, "id": 110806826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=82e4992c9dd60811", "url": "https://translations.documentfoundation.org/api/units/110806826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.955652Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot\"><link href=\"text/scalc/guide/datapilot.xhp\">Pivot Table</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot\"><link href=\"text/scalc/guide/datapilot.xhp\">Pivot Table</link></variable>" ], "id_hash": 7566629879552881874, "content_hash": 7566629879552881874, "location": "datapilot.xhp", "context": "datapilot.xhp\nhd_id3150448\nhelp.text", "note": "NNbkr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110806834/?format=api", "priority": 100, "id": 110806834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e90211c9259b34d2", "url": "https://translations.documentfoundation.org/api/units/110806834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.966506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -2698616069608549419, "content_hash": -2698616069608549419, "location": "datapilot.xhp", "context": "datapilot.xhp\npar_id3156024\nhelp.text", "note": "X3qFY", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110806854/?format=api", "priority": 100, "id": 110806854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=5a8c96fb89d253d5", "url": "https://translations.documentfoundation.org/api/units/110806854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:02.984137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "A table that has been created as a <link href=\"text/scalc/01/12090000.xhp\">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view." ], "previous_source": "", "target": [ "A table that has been created as a <link href=\"text/scalc/01/12090000.xhp\">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view." ], "id_hash": -2121711061278896885, "content_hash": -2121711061278896885, "location": "datapilot.xhp", "context": "datapilot.xhp\npar_id3145069\nhelp.text", "note": "pUGwe", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110806878/?format=api", "priority": 100, "id": 110806878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=628e2b07f4744d0b", "url": "https://translations.documentfoundation.org/api/units/110806878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.007757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Creating Pivot Tables" ], "previous_source": "", "target": [ "Creating Pivot Tables" ], "id_hash": 7178156368634310857, "content_hash": 7178156368634310857, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\ntit\nhelp.text", "note": "cGChV", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110806896/?format=api", "priority": 100, "id": 110806896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e39def2f8ea7f0c9", "url": "https://translations.documentfoundation.org/api/units/110806896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.034942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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 tables</bookmark_value> <bookmark_value>pivot table function; calling up and applying</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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110806905/?format=api", "priority": 100, "id": 110806905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=12a1db8a7f357a74", "url": "https://translations.documentfoundation.org/api/units/110806905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.044411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_createtable\"><link href=\"text/scalc/guide/datapilot_createtable.xhp\">Creating Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_createtable\"><link href=\"text/scalc/guide/datapilot_createtable.xhp\">Creating Pivot Tables</link></variable>" ], "id_hash": 2218872629792340144, "content_hash": 2218872629792340144, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\nhd_id3148491\nhelp.text", "note": "HgqHr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110806928/?format=api", "priority": 100, "id": 110806928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9ecb04e6949bf8b0", "url": "https://translations.documentfoundation.org/api/units/110806928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.394066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Position the cursor within a range of cells containing values, row and column headings." ], "previous_source": "", "target": [ "Position the cursor within a range of cells containing values, row and column headings." ], "id_hash": 4946745694602108261, "content_hash": 4946745694602108261, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156023\nhelp.text", "note": "qrneD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110806983/?format=api", "priority": 100, "id": 110806983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c4a65f0010f39d65", "url": "https://translations.documentfoundation.org/api/units/110806983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.414884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Choose <emph>Insert - Pivot Table</emph>. The <emph>Select Source</emph> dialog appears. Choose <emph>Current selection</emph> and confirm with <emph>OK</emph>. The table headings are shown as buttons in the <emph>Pivot Table</emph> dialog. Drag these buttons as required and drop them into the layout areas \"Filters\", \"Column Fields\", \"Row Fields\" and \"Data Fields\"." ], "previous_source": "", "target": [ "Choose <emph>Insert - Pivot Table</emph>. The <emph>Select Source</emph> dialog appears. Choose <emph>Current selection</emph> and confirm with <emph>OK</emph>. The table headings are shown as buttons in the <emph>Pivot Table</emph> dialog. Drag these buttons as required and drop them into the layout areas \"Filters\", \"Column Fields\", \"Row Fields\" and \"Data Fields\"." ], "id_hash": 1803224476097291832, "content_hash": 1803224476097291832, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3147264\nhelp.text", "note": "LA3ux", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/110807008/?format=api", "priority": 100, "id": 110807008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9906571b6c11a638", "url": "https://translations.documentfoundation.org/api/units/110807008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.429053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Drag the desired buttons into one of the four areas." ], "previous_source": "", "target": [ "Drag the desired buttons into one of the four areas." ], "id_hash": 7476088695115802925, "content_hash": 7476088695115802925, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150868\nhelp.text", "note": "XR8Sd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110807050/?format=api", "priority": 100, "id": 110807050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e7c0670ee5b0e92d", "url": "https://translations.documentfoundation.org/api/units/110807050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.452508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter." ], "previous_source": "", "target": [ "Drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter." ], "id_hash": 3461033577929203645, "content_hash": 3461033577929203645, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id7599414\nhelp.text", "note": "7PXD6", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110807072/?format=api", "priority": 100, "id": 110807072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b0080fb3a82b5fbd", "url": "https://translations.documentfoundation.org/api/units/110807072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.470842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 1622151538385423318, "content_hash": 1622151538385423318, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3154011\nhelp.text", "note": "vFX84", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110807074/?format=api", "priority": 100, "id": 110807074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=96830a3ac9510bd6", "url": "https://translations.documentfoundation.org/api/units/110807074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.478905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href=\"text/scalc/01/12090105.xhp\"><emph>Data Field</emph></link> dialog." ], "previous_source": "", "target": [ "By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href=\"text/scalc/01/12090105.xhp\"><emph>Data Field</emph></link> dialog." ], "id_hash": -8946463972221605814, "content_hash": -8946463972221605814, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3146974\nhelp.text", "note": "VnALH", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110807075/?format=api", "priority": 100, "id": 110807075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=03d7c66aebe6a84a", "url": "https://translations.documentfoundation.org/api/units/110807075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.499509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -7996044650938525023, "content_hash": -7996044650938525023, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156286\nhelp.text", "note": "PAuDC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110807110/?format=api", "priority": 100, "id": 110807110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=110857c13ca59aa1", "url": "https://translations.documentfoundation.org/api/units/110807110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.756478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse." ], "id_hash": -4781468655574914518, "content_hash": -4781468655574914518, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150329\nhelp.text", "note": "AniFD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110807139/?format=api", "priority": 100, "id": 110807139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3da4cf974fcaea2a", "url": "https://translations.documentfoundation.org/api/units/110807139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.779635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Remove a button by dragging it back to the area of the other buttons at the right of the dialog." ], "previous_source": "", "target": [ "Remove a button by dragging it back to the area of the other buttons at the right of the dialog." ], "id_hash": -3170597794887622254, "content_hash": -3170597794887622254, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3153714\nhelp.text", "note": "ADpWF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110807166/?format=api", "priority": 100, "id": 110807166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=53ffc61aa6162192", "url": "https://translations.documentfoundation.org/api/units/110807166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.819365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To open the <link href=\"text/scalc/01/12090105.xhp\"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> area. Use the dialog to select if and to what extent <item type=\"productname\">%PRODUCTNAME</item> calculates display subtotals." ], "previous_source": "", "target": [ "To open the <link href=\"text/scalc/01/12090105.xhp\"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> area. Use the dialog to select if and to what extent <item type=\"productname\">%PRODUCTNAME</item> calculates display subtotals." ], "id_hash": -3723970233023458149, "content_hash": -3723970233023458149, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3147338\nhelp.text", "note": "RVAdg", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110807202/?format=api", "priority": 100, "id": 110807202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4c51cccdb282149b", "url": "https://translations.documentfoundation.org/api/units/110807202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.847632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Exit the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Filters</emph> area. The pivot table is inserted further down." ], "previous_source": "", "target": [ "Exit the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Filters</emph> area. The pivot table is inserted further down." ], "id_hash": -7998443741997083048, "content_hash": -7998443741997083048, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3154020\nhelp.text", "note": "iXULx", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110807247/?format=api", "priority": 100, "id": 110807247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=10ffd1cb52515658", "url": "https://translations.documentfoundation.org/api/units/110807247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.928656Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Deleting Pivot Tables" ], "previous_source": "", "target": [ "Deleting Pivot Tables" ], "id_hash": 4268397367848498995, "content_hash": 4268397367848498995, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\ntit\nhelp.text", "note": "dJsd8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110807250/?format=api", "priority": 100, "id": 110807250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bb3c64ca86d27733", "url": "https://translations.documentfoundation.org/api/units/110807250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:03.943568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>pivot table function; deleting tables</bookmark_value> <bookmark_value>deleting;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot table function; deleting tables</bookmark_value> <bookmark_value>deleting;pivot tables</bookmark_value>" ], "id_hash": 6644619178497048503, "content_hash": 6644619178497048503, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\nbm_id3153726\nhelp.text", "note": "5mACL", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110807381/?format=api", "priority": 100, "id": 110807381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=dc366df02a107fb7", "url": "https://translations.documentfoundation.org/api/units/110807381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.273518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_deletetable\"><link href=\"text/scalc/guide/datapilot_deletetable.xhp\">Deleting Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_deletetable\"><link href=\"text/scalc/guide/datapilot_deletetable.xhp\">Deleting Pivot Tables</link></variable>" ], "id_hash": 4237128376676248591, "content_hash": 4237128376676248591, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\nhd_id3153726\nhelp.text", "note": "aCv9D", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110807396/?format=api", "priority": 100, "id": 110807396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bacd4dcf2f83ec0f", "url": "https://translations.documentfoundation.org/api/units/110807396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.286395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "In order to delete a pivot table, click any cell in the pivot table, then choose <emph>Delete</emph> in the context menu." ], "id_hash": -7854945537660471433, "content_hash": -7854945537660471433, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\npar_id3154014\nhelp.text", "note": "yvJds", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110807444/?format=api", "priority": 100, "id": 110807444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=12fda0a699b53777", "url": "https://translations.documentfoundation.org/api/units/110807444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.327198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 2968794790189037233, "content_hash": 2968794790189037233, "location": "datapilot_deletetable.xhp", "context": "datapilot_deletetable.xhp\npar_id141525148751543\nhelp.text", "note": "oFygT", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110807469/?format=api", "priority": 100, "id": 110807469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a9334721e03f76b1", "url": "https://translations.documentfoundation.org/api/units/110807469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.347465Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Editing Pivot Tables" ], "previous_source": "", "target": [ "Editing Pivot Tables" ], "id_hash": -5217840885408052579, "content_hash": -5217840885408052579, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\ntit\nhelp.text", "note": "9Ft4E", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110807600/?format=api", "priority": 100, "id": 110807600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3796815c2abe4a9d", "url": "https://translations.documentfoundation.org/api/units/110807600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.420450Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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 table function; editing tables</bookmark_value><bookmark_value>editing;pivot tables</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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110807629/?format=api", "priority": 100, "id": 110807629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=af86ebb7db5e9e8b", "url": "https://translations.documentfoundation.org/api/units/110807629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.437341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_edittable\"><link href=\"text/scalc/guide/datapilot_edittable.xhp\">Editing Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_edittable\"><link href=\"text/scalc/guide/datapilot_edittable.xhp\">Editing Pivot Tables</link></variable>" ], "id_hash": -3120591093420124003, "content_hash": -3120591093420124003, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\nhd_id3148663\nhelp.text", "note": "z8AYi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110807678/?format=api", "priority": 100, "id": 110807678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=54b16eef2372189d", "url": "https://translations.documentfoundation.org/api/units/110807678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.477196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -4794520277034496322, "content_hash": -4794520277034496322, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3150868\nhelp.text", "note": "jDNdq", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110807715/?format=api", "priority": 100, "id": 110807715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3d767135e2f38ebe", "url": "https://translations.documentfoundation.org/api/units/110807715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.495049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 1313039945413799093, "content_hash": 1313039945413799093, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3145786\nhelp.text", "note": "oRj6N", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/110807785/?format=api", "priority": 100, "id": 110807785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9238dadfa249acb5", "url": "https://translations.documentfoundation.org/api/units/110807785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.520372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "In the Pivot Table dialog, you can drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the pivot table to use another page field as a filter." ], "previous_source": "", "target": [ "In the Pivot Table dialog, you can drag a button to the <emph>Filters</emph> area to create a button and a listbox on top of the pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the pivot table to use another page field as a filter." ], "id_hash": -3526777788901482499, "content_hash": -3526777788901482499, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id1648915\nhelp.text", "note": "Yrb6G", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/110807821/?format=api", "priority": 100, "id": 110807821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4f0e5e4962ca1ffd", "url": "https://translations.documentfoundation.org/api/units/110807821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.540481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 8064735080719009737, "content_hash": 8064735080719009737, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3147434\nhelp.text", "note": "AeGto", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110807844/?format=api", "priority": 100, "id": 110807844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=efebb1d3bde347c9", "url": "https://translations.documentfoundation.org/api/units/110807844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.559034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To edit the pivot table, click a cell inside the pivot table and open the context menu. In the context menu you find the command <emph>Properties</emph>, which displays the <emph>Pivot Table Layout</emph> dialog for the current pivot table." ], "previous_source": "", "target": [ "To edit the pivot table, click a cell inside the pivot table and open the context menu. In the context menu you find the command <emph>Properties</emph>, which displays the <emph>Pivot Table Layout</emph> dialog for the current pivot table." ], "id_hash": 4029389360636918751, "content_hash": 4029389360636918751, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id3156442\nhelp.text", "note": "vbqKe", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110807910/?format=api", "priority": 100, "id": 110807910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b7eb44465e807bdf", "url": "https://translations.documentfoundation.org/api/units/110807910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.589002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields." ], "id_hash": -2833646734314458467, "content_hash": -2833646734314458467, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id2666096\nhelp.text", "note": "fKGXd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110807939/?format=api", "priority": 100, "id": 110807939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=58acdd4ef63db29d", "url": "https://translations.documentfoundation.org/api/units/110807939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.610471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": -5285605926563982336, "content_hash": -5285605926563982336, "location": "datapilot_edittable.xhp", "context": "datapilot_edittable.xhp\npar_id266609688\nhelp.text", "note": "aBysR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110807960/?format=api", "priority": 100, "id": 110807960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=36a5c16a04745400", "url": "https://translations.documentfoundation.org/api/units/110807960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.632172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Filtering Pivot Tables" ], "previous_source": "", "target": [ "Filtering Pivot Tables" ], "id_hash": -4193519869293477140, "content_hash": -4193519869293477140, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\ntit\nhelp.text", "note": "Yt6DD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808032/?format=api", "priority": 100, "id": 110808032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=45cd9fe5a83842ec", "url": "https://translations.documentfoundation.org/api/units/110808032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.672453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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 table function; filtering tables</bookmark_value><bookmark_value>filtering;pivot tables</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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110808098/?format=api", "priority": 100, "id": 110808098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b5f2083b1af13c78", "url": "https://translations.documentfoundation.org/api/units/110808098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.704042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_filtertable\"><link href=\"text/scalc/guide/datapilot_filtertable.xhp\">Filtering Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_filtertable\"><link href=\"text/scalc/guide/datapilot_filtertable.xhp\">Filtering Pivot Tables</link></variable>" ], "id_hash": 4392305728640105911, "content_hash": 4392305728640105911, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\nhd_id3150792\nhelp.text", "note": "zNm6v", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110808145/?format=api", "priority": 100, "id": 110808145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bcf49ac9ec81bdb7", "url": "https://translations.documentfoundation.org/api/units/110808145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.723336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can use filters to remove unwanted data from a pivot table." ], "previous_source": "", "target": [ "You can use filters to remove unwanted data from a pivot table." ], "id_hash": -5699121300235168760, "content_hash": -5699121300235168760, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id3153192\nhelp.text", "note": "ADCtg", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110808173/?format=api", "priority": 100, "id": 110808173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=30e8a75f679ed408", "url": "https://translations.documentfoundation.org/api/units/110808173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.745278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the <emph>Filter</emph> command. The <link href=\"text/scalc/01/12090103.xhp\"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table." ], "previous_source": "", "target": [ "Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the <emph>Filter</emph> command. The <link href=\"text/scalc/01/12090103.xhp\"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table." ], "id_hash": -8813884753423259217, "content_hash": -8813884753423259217, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id3150441\nhelp.text", "note": "Dr4qw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110808207/?format=api", "priority": 100, "id": 110808207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=05aeca83c4f9a9af", "url": "https://translations.documentfoundation.org/api/units/110808207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.759210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 8922346190446348241, "content_hash": 8922346190446348241, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id315044199\nhelp.text", "note": "TUAcu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110808255/?format=api", "priority": 100, "id": 110808255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=fbd28a966c9d47d1", "url": "https://translations.documentfoundation.org/api/units/110808255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:04.780237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?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": [ "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." ], "id_hash": 5430743094494410191, "content_hash": 5430743094494410191, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344485\nhelp.text", "note": "SQnhK", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110808335/?format=api", "priority": 100, "id": 110808335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=cb5de01235beb5cf", "url": "https://translations.documentfoundation.org/api/units/110808335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.183918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Enable or disable a checkbox to show or hide the associated field member in the pivot table." ], "previous_source": "", "target": [ "Enable or disable a checkbox to show or hide the associated field member in the pivot table." ], "id_hash": 8213935646007170359, "content_hash": 8213935646007170359, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344449\nhelp.text", "note": "y6PoC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110808366/?format=api", "priority": 100, "id": 110808366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f1fdc2f3642d1537", "url": "https://translations.documentfoundation.org/api/units/110808366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.199513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Enable or disable the <emph>All</emph> checkbox to show all or none of the field members." ], "previous_source": "", "target": [ "Enable or disable the <emph>All</emph> checkbox to show all or none of the field members." ], "id_hash": -7579503326579316103, "content_hash": -7579503326579316103, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344493\nhelp.text", "note": "SW9yB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110808385/?format=api", "priority": 100, "id": 110808385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=16d031e1e5592a79", "url": "https://translations.documentfoundation.org/api/units/110808385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.213317Z" } ] }