Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 142858,
    "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2848",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2846",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021543/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618308Z",
            "action": 59,
            "target": "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.",
            "id": 36428630,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428630/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021542/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618264Z",
            "action": 59,
            "target": "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.",
            "id": 36428629,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428629/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021541/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618221Z",
            "action": 59,
            "target": "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.",
            "id": 36428628,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428628/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021540/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618178Z",
            "action": 59,
            "target": "Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list.",
            "id": 36428627,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428627/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021539/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618134Z",
            "action": 59,
            "target": "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.",
            "id": 36428626,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428626/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021538/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618092Z",
            "action": 59,
            "target": "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.",
            "id": 36428625,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428625/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021537/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618049Z",
            "action": 59,
            "target": "Enable or disable the <emph>All</emph> checkbox to show all or none of the field members.",
            "id": 36428624,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428624/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021536/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.618006Z",
            "action": 59,
            "target": "Enable or disable a checkbox to show or hide the associated field member in the pivot table.",
            "id": 36428623,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428623/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021534/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617963Z",
            "action": 59,
            "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": 36428622,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428622/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021514/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617920Z",
            "action": 59,
            "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": 36428621,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428621/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021478/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617878Z",
            "action": 59,
            "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": 36428620,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428620/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021417/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617836Z",
            "action": 59,
            "target": "You can use filters to remove unwanted data from a pivot table.",
            "id": 36428619,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428619/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021380/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617795Z",
            "action": 59,
            "target": "<variable id=\"datapilot_filtertable\"><link href=\"text/scalc/guide/datapilot_filtertable.xhp\">Filtering Pivot Tables</link></variable>",
            "id": 36428618,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428618/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021367/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617754Z",
            "action": 59,
            "target": "<bookmark_value>pivot table function; filtering tables</bookmark_value><bookmark_value>filtering;pivot tables</bookmark_value>",
            "id": 36428617,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428617/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021358/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617712Z",
            "action": 59,
            "target": "Filtering Pivot Tables",
            "id": 36428616,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428616/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021331/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617669Z",
            "action": 59,
            "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": 36428615,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428615/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021309/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617626Z",
            "action": 59,
            "target": "In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.",
            "id": 36428614,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428614/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021288/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617582Z",
            "action": 59,
            "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": 36428613,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428613/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021257/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617541Z",
            "action": 59,
            "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": 36428612,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428612/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021227/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617500Z",
            "action": 59,
            "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": 36428611,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428611/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021212/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617458Z",
            "action": 59,
            "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": 36428610,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428610/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021182/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617417Z",
            "action": 59,
            "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": 36428609,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428609/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021157/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617377Z",
            "action": 59,
            "target": "<variable id=\"datapilot_edittable\"><link href=\"text/scalc/guide/datapilot_edittable.xhp\">Editing Pivot Tables</link></variable>",
            "id": 36428608,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428608/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021135/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617337Z",
            "action": 59,
            "target": "<bookmark_value>pivot table function; editing tables</bookmark_value><bookmark_value>editing;pivot tables</bookmark_value>",
            "id": 36428607,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428607/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021116/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617299Z",
            "action": 59,
            "target": "Editing Pivot Tables",
            "id": 36428606,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428606/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021110/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617256Z",
            "action": 59,
            "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": 36428605,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428605/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021100/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617216Z",
            "action": 59,
            "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": 36428604,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428604/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021090/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617177Z",
            "action": 59,
            "target": "<variable id=\"datapilot_deletetable\"><link href=\"text/scalc/guide/datapilot_deletetable.xhp\">Deleting Pivot Tables</link></variable>",
            "id": 36428603,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428603/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021080/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617136Z",
            "action": 59,
            "target": "<bookmark_value>pivot table function; deleting tables</bookmark_value>      <bookmark_value>deleting;pivot tables</bookmark_value>",
            "id": 36428602,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428602/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021057/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617094Z",
            "action": 59,
            "target": "Deleting Pivot Tables",
            "id": 36428601,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428601/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99021029/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617053Z",
            "action": 59,
            "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": 36428600,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428600/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020990/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.617010Z",
            "action": 59,
            "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": 36428599,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428599/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020956/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616968Z",
            "action": 59,
            "target": "Remove a button by dragging it back to the area of the other buttons at the right of the dialog.",
            "id": 36428598,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428598/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020880/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616928Z",
            "action": 59,
            "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": 36428597,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428597/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020852/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616887Z",
            "action": 59,
            "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": 36428596,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428596/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020828/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616846Z",
            "action": 59,
            "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": 36428595,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428595/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020800/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616806Z",
            "action": 59,
            "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": 36428594,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428594/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020761/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616763Z",
            "action": 59,
            "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": 36428593,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428593/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020700/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616722Z",
            "action": 59,
            "target": "Drag the desired buttons into one of the four areas.",
            "id": 36428592,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428592/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020633/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616680Z",
            "action": 59,
            "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": 36428591,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428591/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020597/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616639Z",
            "action": 59,
            "target": "Position the cursor within a range of cells containing values, row and column headings.",
            "id": 36428590,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428590/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020572/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616598Z",
            "action": 59,
            "target": "<variable id=\"datapilot_createtable\"><link href=\"text/scalc/guide/datapilot_createtable.xhp\">Creating Pivot Tables</link></variable>",
            "id": 36428589,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428589/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020549/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616556Z",
            "action": 59,
            "target": "<bookmark_value>pivot tables</bookmark_value>      <bookmark_value>pivot table function; calling up and applying</bookmark_value>",
            "id": 36428588,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428588/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020524/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616514Z",
            "action": 59,
            "target": "Creating Pivot Tables",
            "id": 36428587,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428587/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020504/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616471Z",
            "action": 59,
            "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": 36428586,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428586/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020469/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616429Z",
            "action": 59,
            "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": 36428585,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428585/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020444/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616389Z",
            "action": 59,
            "target": "<variable id=\"datapilot\"><link href=\"text/scalc/guide/datapilot.xhp\">Pivot Table</link></variable>",
            "id": 36428584,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428584/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020413/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616349Z",
            "action": 59,
            "target": "<bookmark_value>pivot table function; introduction</bookmark_value><bookmark_value>DataPilot, see pivot table function</bookmark_value>",
            "id": 36428583,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428583/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020410/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616309Z",
            "action": 59,
            "target": "Pivot Table",
            "id": 36428582,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428582/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99020409/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:44:05.616256Z",
            "action": 59,
            "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range\">Wiki page about defining a data range</link>",
            "id": 36428581,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428581/?format=api"
        }
    ]
}