Show Details (DataPilot)

-Using the DataPilot +Using the pivot table diff --git a/helpcontent2/source/text/scalc/guide/datapilot.xhp b/helpcontent2/source/text/scalc/guide/datapilot.xhp index 9bc65aedf7..7a8ff0a1a9 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot.xhp @@ -4,8 +4,8 @@ - + -DataPilot +Pivot Table /text/scalc/guide/datapilot.xhp - -Sun Microsystems, Inc. -FPE: Deleted screenshot, cleaned up -YJ: checked - -DataPilot function; introduction -Pivot table, see DataPilot function +pivot table function; introduction +DataPilot, see pivot table function -DataPilot +Pivot Table -The DataPilot (sometimes known as Pivot Table) 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. -A table that has been created with the DataPilot is an interactive table. Data can be arranged, rearranged or summarized according to different points of view. +The pivot table (formerly known as DataPilot) 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. +A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp index e605818255..1a6be7babf 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp @@ -1,12 +1,12 @@ - + - - + + - Creating DataPilot Tables + Creating Pivot Tables /text/scalc/guide/datapilot_createtable.xhp -DataPilot tables - DataPilot function; calling up and applying +pivot tables + pivot table function; calling up and applying -Creating DataPilot Tables +Creating Pivot Tables Position the cursor within a range of cells containing values, row and column headings. - Choose Data - DataPilot - Start. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as buttons in the DataPilot dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". + Choose Data - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". Drag the desired buttons into one of the four areas. - Drag a button to the Page Fields area to create a button and a listbox on top of the generated datapilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. + Drag a button to the Page Fields 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. If the button is dropped in the Data Fields area it will be given a caption that also shows the formula that will be used to calculate the data. By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog. - Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the Command + Use the Data Field dialog to select the calculations to be used for the data. To make a multiple selection, press the Command Ctrl key while clicking the desired calculation. @@ -76,7 +76,7 @@ To open the Data Field dialog, double-click one of the buttons in the Row or Column area. Use the dialog to select if and to what extent %PRODUCTNAME calculates display subtotals. - Exit the DataPilot dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Page Fields area. The DataPilot table is inserted further down. + Exit the Pivot Table dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Page Fields area. The pivot table is inserted further down.

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp index de85d0d9ff..ee9fe95802 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp @@ -1,12 +1,12 @@ - + - - + + - Deleting DataPilot Tables + Deleting Pivot Tables /text/scalc/guide/datapilot_deletetable.xhp -DataPilot function; deleting tables - deleting;DataPilot tables +pivot table function; deleting tables + deleting;pivot tables -Deleting DataPilot Tables +Deleting Pivot Tables - In order to delete a DataPilot table, select any cell in the DataPilot table, then choose Delete in the context menu. + In order to delete a pivot table, click any cell in the pivot table, then choose Delete in the context menu.

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index 20082ed7dd..4d8eb444f5 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp @@ -6,7 +6,7 @@ * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * - * Copyright 2000, 2010 Oracle and/or its affiliates. + * Copyright 2000, 2011 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * @@ -33,24 +33,23 @@ - Editing DataPilot Tables + Editing Pivot Tables /text/scalc/guide/datapilot_edittable.xhp -DataPilot function; editing tables - editing;DataPilot tables +pivot table function; editing tables +editing;pivot tables -Editing DataPilot Tables +Editing Pivot Tables - Click one of the buttons in the table that the DataPilot has created and hold the mouse button down. A special symbol will appear next to the mouse pointer. + 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. 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. - In the DataPilot dialog, you can drag a button to the Page Fields area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter. - To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted. - To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command Start, which displays the DataPilot dialog for the current DataPilot table. - In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields. - You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside DataPilot tables. A custom display name is assigned to an item by overwriting the original name with another name. + In the Pivot Table dialog, you can drag a button to the Page Fields 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. + 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. + 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 Layout, which displays the Pivot Table dialog for the current pivot table. + In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields. + 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.

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp index 87e7e3ab5c..4adedbf77b 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp @@ -3,7 +3,7 @@ * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * - * Copyright 2000, 2010 Oracle and/or its affiliates. + * Copyright 2000, 2011 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * @@ -28,34 +28,34 @@ -Filtering DataPilot Tables +Filtering Pivot Tables /text/scalc/guide/datapilot_filtertable.xhp -DataPilot function; filtering tables -filtering;DataPilot tables +pivot table function; filtering tables +filtering;pivot tables -Filtering DataPilot Tables -You can use filters to remove unwanted data from a DataPilot table. -Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the Filter command. The Filter dialog appears. Here you can filter the DataPilot table. -You can also click the arrow on a button in the DataPilot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field. +Filtering Pivot Tables +You can use filters to remove unwanted data from a pivot table. +Click the Filter 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 Filter command. The Filter dialog appears. Here you can filter the pivot table. +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. 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. -Enable or disable a checkbox to show or hide the associated field member in the DataPilot table. +Enable or disable a checkbox to show or hide the associated field member in the pivot table. Enable or disable the All checkbox to show all or none of the field members. -Select a field member in the pop-up window and click the Show only the current item button to show only the selected field member. All other field members are hidden in the DataPilot table. +Select a field member in the pop-up window and click the Show only the current item button to show only the selected field member. All other field members are hidden in the pivot table. -Select a field member in the pop-up window and click the Hide only the current item button to hide only the selected field member. All other field members are shown in the DataPilot table. +Select a field member in the pop-up window and click the Hide only the current item button to hide only the selected field member. All other field members are shown in the pivot table. Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list. diff --git a/helpcontent2/source/text/scalc/guide/datapilot_grouping.xhp b/helpcontent2/source/text/scalc/guide/datapilot_grouping.xhp index 5610db5c59..254374ea0f 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_grouping.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_grouping.xhp @@ -6,8 +6,8 @@ *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * Copyright 2000, 2011 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * @@ -35,27 +35,27 @@ -Grouping DataPilot Tables +Grouping Pivot Tables /text/scalc/guide/datapilot_grouping.xhp -grouping; DataPilot tables -DataPilot function;grouping table entries -ungrouping entries in DataPilot tables +grouping; pivot tables +pivot table function;grouping table entries +ungrouping entries in pivot tables -Grouping DataPilot Tables -see http://specs.openoffice.org/calc/compatibility/grouping.sxwThe resulting DataPilot table can contain many different entries. By grouping the entries, you can improve the visible result. +Grouping Pivot Tables +see http://specs.openoffice.org/calc/compatibility/grouping.sxwThe resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result. -Select a cell or range of cells in the DataPilot table. +Select a cell or range of cells in the pivot table. Choose Data - Group and Outline - Group. -Depending on the format of the selected cells, either a new group field is added to the DataPilot table, or you see one of the two Grouping dialogs, either for numeric values, or for date values. -The DataPilot table must be organized in a way that grouping can be applied. +Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two Grouping dialogs, either for numeric values, or for date values. +The pivot table must be organized in a way that grouping can be applied. To remove a grouping, click inside the group, then choose Data - Group and Outline - Ungroup. diff --git a/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp b/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp index 72a1079d11..8cebe609b0 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_tipps.xhp @@ -4,8 +4,8 @@ - + -Selecting DataPilot Output Ranges +Selecting Pivot Table Output Ranges /text/scalc/guide/datapilot_tipps.xhp - -Sun Microsystems, Inc. -converted from old format - fpe - -DataPilot function; preventing data overwriting -output ranges of DataPilot tables +pivot table function; preventing data overwriting +output ranges of pivot tables -Selecting DataPilot Output Ranges +Selecting Pivot Table Output Ranges -Click the button More in the DataPilot dialog. The dialog will be extended. -You can select a named range in which the DataPilot table is to be created, from the Results to box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the Results to box. You can also click on the appropriate cell to have the coordinates entered accordingly. -If you mark the Ignore empty rows check box, they will not be taken into account when the DataPilot table is created. -If the Identify categories check box is marked, the categories will be identified by their headings and assigned accordingly when the DataPilot table is created. +Click the button More in the Pivot Table dialog. The dialog will be extended. +You can select a named range in which the pivot table is to be created, from the Results to box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the Results to box. You can also click on the appropriate cell to have the coordinates entered accordingly. +If you mark the Ignore empty rows check box, they will not be taken into account when the pivot table is created. +If the Identify categories check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created.

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_updatetable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_updatetable.xhp index 002bd09af0..da16c04b43 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_updatetable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_updatetable.xhp @@ -5,8 +5,8 @@ *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * Copyright 2000, 2011 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * @@ -29,27 +29,23 @@ * ************************************************************************ --> - + -Updating DataPilot Tables +Updating Pivot Tables /text/scalc/guide/datapilot_updatetable.xhp - -Sun Microsystems, Inc. -converted from old format - fpe - -Pivot table import -DataPilot function; refreshing tables -recalculating;DataPilot tables -updating;DataPilot tables +pivot table import +pivot table function; refreshing tables +recalculating;pivot tables +updating;pivot tables -Updating DataPilot Tables +Updating Pivot Tables -If the data of the source sheet has been changed, $[officename] recalculates the DataPilot table. To recalculate the tables, choose Data - DataPilot - Refresh. Do the same after you have imported an Excel Pivot table into $[officename] Calc. +If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose Data - Pivot Table - Refresh. Do the same after you have imported an Excel pivot table into $[officename] Calc.

diff --git a/helpcontent2/source/text/scalc/main0112.xhp b/helpcontent2/source/text/scalc/main0112.xhp index 070b076ca0..3316380e78 100755 --- a/helpcontent2/source/text/scalc/main0112.xhp +++ b/helpcontent2/source/text/scalc/main0112.xhp @@ -6,8 +6,8 @@ *********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * Copyright 2000, 2011 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * @@ -42,7 +42,7 @@

Data -Use the Data menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and open the DataPilot. +Use the Data menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and create a pivot table.

Define Range

diff --git a/helpcontent2/source/text/shared/guide/microsoft_terms.xhp b/helpcontent2/source/text/shared/guide/microsoft_terms.xhp index 8e96a8fc24..8f07bcad9b 100755 --- a/helpcontent2/source/text/shared/guide/microsoft_terms.xhp +++ b/helpcontent2/source/text/shared/guide/microsoft_terms.xhp @@ -1,11 +1,11 @@ - + - - + + Comparing Microsoft Office and $[officename] Terms @@ -135,14 +135,6 @@ -PivotTable - - -DataPilot - - - - Refresh Data (in Excel) diff --git a/helpcontent2/source/text/shared/tree_strings.xhp b/helpcontent2/source/text/shared/tree_strings.xhp index 31991694cb..c2955981f5 100755 --- a/helpcontent2/source/text/shared/tree_strings.xhp +++ b/helpcontent2/source/text/shared/tree_strings.xhp @@ -4,7 +4,7 @@