diff options
| author | Release Engineering <releng@openoffice.org> | 2011-02-18 11:14:19 +0100 |
|---|---|---|
| committer | Release Engineering <releng@openoffice.org> | 2011-02-18 11:14:19 +0100 |
| commit | 13d5c878db79389684786e81c31e4d4f304c272a (patch) | |
| tree | 6dfc4820d80d7a981e14d95e78063ba98cd3a7df /helpcontent2/source/text/scalc/guide | |
| parent | 1ad0c2f37631abf7dd99796ba4b21e1eb67d632b (diff) | |
| parent | b82105db49e517a34142584bb82e33fce39af20f (diff) | |
merged DEV300
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
8 files changed, 86 insertions, 101 deletions
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 @@ <!--*********************************************************************** * * 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 * @@ -27,27 +27,22 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalcguidedatapilotxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">DataPilot</title> +<title id="tit" xml-lang="en-US">Pivot Table</title> <filename>/text/scalc/guide/datapilot.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-08-09T09:13:10">FPE: Deleted screenshot, cleaned up -YJ: checked</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150448"><bookmark_value>DataPilot function; introduction</bookmark_value> -<bookmark_value>Pivot table, see DataPilot function</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150448"><bookmark_value>pivot table function; introduction</bookmark_value> +<bookmark_value>DataPilot, see pivot table function</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="1" l10n="U" oldref="7"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp" name="DataPilot">DataPilot</link> +<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="1" l10n="U" oldref="7"><variable id="datapilot"><link href="text/scalc/guide/datapilot.xhp" name="Pivot Table">Pivot Table</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US" l10n="CHG" oldref="2">The <emph>DataPilot</emph> (sometimes known as <emph>Pivot Table</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.</paragraph> -<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U" oldref="9">A table that has been created with the <link href="text/scalc/01/12090000.xhp" name="DataPilot">DataPilot</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> +<paragraph role="paragraph" id="par_id3156024" xml-lang="en-US" l10n="CHG" oldref="2">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.</paragraph> +<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U" oldref="9">A table that has been created as a <link href="text/scalc/01/12090000.xhp" name="pivot table">pivot table</link> is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> 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 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * 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,39 +29,39 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidedatapilot_createtablexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Creating DataPilot Tables</title> + <title xml-lang="en-US" id="tit">Creating Pivot Tables</title> <filename>/text/scalc/guide/datapilot_createtable.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148491"><bookmark_value>DataPilot tables</bookmark_value> - <bookmark_value>DataPilot function; calling up and applying</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148491"><bookmark_value>pivot tables</bookmark_value> + <bookmark_value>pivot table function; calling up and applying</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3148491" role="heading" level="1" l10n="U" oldref="7"><variable id="datapilot_createtable"><link href="text/scalc/guide/datapilot_createtable.xhp" name="Creating DataPilot Tables">Creating DataPilot Tables</link> +<paragraph xml-lang="en-US" id="hd_id3148491" role="heading" level="1" l10n="U" oldref="7"><variable id="datapilot_createtable"><link href="text/scalc/guide/datapilot_createtable.xhp" name="Creating Pivot Tables">Creating Pivot Tables</link> </variable></paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3156023" role="listitem" l10n="U" oldref="8">Position the cursor within a range of cells containing values, row and column headings.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147264" role="listitem" l10n="CHG" oldref="9">Choose <emph>Data - DataPilot - Start</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>DataPilot</emph> dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields".</paragraph> + <paragraph xml-lang="en-US" id="par_id3147264" role="listitem" l10n="CHG" oldref="9">Choose <emph>Data - Pivot Table - Create</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 "Page Fields", "Column Fields", "Row Fields" and "Data Fields".</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3150868" role="listitem" l10n="CHG" oldref="10">Drag the desired buttons into one of the four areas.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph" l10n="NEW">Drag a button to the <emph>Page Fields</emph> 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.</paragraph> + <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph" l10n="NEW">Drag a button to the <emph>Page Fields</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.</paragraph> <paragraph xml-lang="en-US" id="par_id3154011" role="paragraph" l10n="CHG" oldref="11">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.</paragraph> <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3146974" role="listitem" l10n="CHG" oldref="16">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" name="Data Field"><emph>Data Field</emph></link> dialog.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3156286" role="listitem" l10n="U" oldref="17">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 + <paragraph xml-lang="en-US" id="par_id3156286" role="listitem" l10n="U" oldref="17">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.</paragraph> </listitem> </list> @@ -76,7 +76,7 @@ <paragraph xml-lang="en-US" id="par_id3147338" role="listitem" l10n="U" oldref="15">To open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row</emph> or <emph>Column</emph> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph" l10n="CHG" oldref="18">Exit the DataPilot 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>Page Fields</emph> area. The DataPilot table is inserted further down.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph" l10n="CHG" oldref="18">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>Page Fields</emph> area. The pivot table is inserted further down.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> 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 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- *********************************************************************** * * 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,22 +29,21 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidedatapilot_deletetablexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Deleting DataPilot Tables</title> + <title xml-lang="en-US" id="tit">Deleting Pivot Tables</title> <filename>/text/scalc/guide/datapilot_deletetable.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>DataPilot function; deleting tables</bookmark_value> - <bookmark_value>deleting;DataPilot tables</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>pivot table function; deleting tables</bookmark_value> + <bookmark_value>deleting;pivot tables</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1" l10n="U" - oldref="31"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting DataPilot Tables">Deleting DataPilot Tables</link> +<paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1" l10n="U" oldref="31"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting Pivot Tables">Deleting Pivot Tables</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph" l10n="U" oldref="32">In order to delete a DataPilot table, select any cell in the DataPilot table, then choose <emph>Delete</emph> in the context menu.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph" l10n="U" oldref="32">In order to delete a pivot table, click any cell in the pivot table, then choose <emph>Delete</emph> in the context menu.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index 20082ed7dd..b7486f410b 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 @@ <meta> <topic id="textscalcguidedatapilot_edittablexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Editing DataPilot Tables</title> + <title xml-lang="en-US" id="tit">Editing Pivot Tables</title> <filename>/text/scalc/guide/datapilot_edittable.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>DataPilot function; editing tables</bookmark_value> - <bookmark_value>editing;DataPilot tables</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>pivot table function; editing tables</bookmark_value> +<bookmark_value>editing;pivot tables</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3148663" role="heading" level="1" l10n="U" - oldref="25"><variable id="datapilot_edittable"><link href="text/scalc/guide/datapilot_edittable.xhp" name="Editing DataPilot Tables">Editing DataPilot Tables</link> +<paragraph xml-lang="en-US" id="hd_id3148663" role="heading" level="1" l10n="U" oldref="25"><variable id="datapilot_edittable"><link href="text/scalc/guide/datapilot_edittable.xhp" name="Editing Pivot Tables">Editing Pivot Tables</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph" l10n="U" oldref="26">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph" l10n="U" oldref="26">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.</paragraph> <paragraph xml-lang="en-US" id="par_id3145786" role="paragraph" l10n="U" oldref="27">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph" l10n="NEW">In the DataPilot dialog, you can drag a button to the <emph>Page Fields</emph> 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.</paragraph> - <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="29">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.</paragraph> - <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="40">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 <emph>Start</emph>, which displays the <emph>DataPilot</emph> dialog for the current DataPilot table.</paragraph> - <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph" l10n="NEW">In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph> - <paragraph xml-lang="en-US" id="par_id266609688" role="paragraph" l10n="NEW">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph" l10n="NEW">In the Pivot Table dialog, you can drag a button to the <emph>Page Fields</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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="29">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.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="CHG" oldref="40">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>Edit Layout</emph>, which displays the <emph>Pivot Table</emph> dialog for the current pivot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph" l10n="NEW">In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph> + <paragraph xml-lang="en-US" id="par_id266609688" role="paragraph" l10n="NEW">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.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> 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 @@ <meta> <topic id="textscalcguidedatapilot_filtertablexml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Filtering DataPilot Tables</title> +<title xml-lang="en-US" id="tit">Filtering Pivot Tables</title> <filename>/text/scalc/guide/datapilot_filtertable.xhp</filename> </topic> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150792"> -<bookmark_value>DataPilot function; filtering tables</bookmark_value> -<bookmark_value>filtering;DataPilot tables</bookmark_value> +<bookmark_value>pivot table function; filtering tables</bookmark_value> +<bookmark_value>filtering;pivot tables</bookmark_value> </bookmark> -<paragraph id="hd_id3150792" role="heading" xml-lang="en-US" level="1"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering DataPilot Tables">Filtering DataPilot Tables</link></variable></paragraph> -<paragraph id="par_id3153192" role="paragraph" xml-lang="en-US">You can use filters to remove unwanted data from a DataPilot table.</paragraph> -<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">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 DataPilot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the DataPilot table.</paragraph> -<paragraph id="par_id315044199" role="paragraph" xml-lang="en-US">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.</paragraph> +<paragraph id="hd_id3150792" role="heading" xml-lang="en-US" level="1"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering Pivot Tables">Filtering Pivot Tables</link></variable></paragraph> +<paragraph id="par_id3153192" role="paragraph" xml-lang="en-US">You can use filters to remove unwanted data from a pivot table.</paragraph> +<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">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" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the pivot table.</paragraph> +<paragraph id="par_id315044199" role="paragraph" xml-lang="en-US">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.</paragraph> <list type="unordered"> <listitem> <paragraph id="par_id0720201001344485" role="paragraph" xml-lang="en-US">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.</paragraph> </listitem> <listitem> -<paragraph id="par_id0720201001344449" role="paragraph" xml-lang="en-US">Enable or disable a checkbox to show or hide the associated field member in the DataPilot table.</paragraph> +<paragraph id="par_id0720201001344449" role="paragraph" xml-lang="en-US">Enable or disable a checkbox to show or hide the associated field member in the pivot table.</paragraph> </listitem> <listitem> <paragraph id="par_id0720201001344493" role="paragraph" xml-lang="en-US">Enable or disable the <emph>All</emph> checkbox to show all or none of the field members.</paragraph> </listitem> <listitem> -<paragraph id="par_id0720201001344431" role="paragraph" xml-lang="en-US">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 DataPilot table.</paragraph> +<paragraph id="par_id0720201001344431" role="paragraph" xml-lang="en-US">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.</paragraph> </listitem> <listitem> -<paragraph id="par_id0720201001344484" role="paragraph" xml-lang="en-US">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 DataPilot table.</paragraph> +<paragraph id="par_id0720201001344484" role="paragraph" xml-lang="en-US">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.</paragraph> </listitem> <listitem> <paragraph id="par_id0720201001344578" role="paragraph" xml-lang="en-US">Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list.</paragraph> 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 @@ <helpdocument version="1.0"> <meta> <topic id="textscalcguidedatapilot_groupingxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Grouping DataPilot Tables</title> +<title id="tit" xml-lang="en-US">Grouping Pivot Tables</title> <filename>/text/scalc/guide/datapilot_grouping.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id4195684"><bookmark_value>grouping; DataPilot tables</bookmark_value> -<bookmark_value>DataPilot function;grouping table entries</bookmark_value> -<bookmark_value>ungrouping entries in DataPilot tables</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id4195684"><bookmark_value>grouping; pivot tables</bookmark_value> +<bookmark_value>pivot table function;grouping table entries</bookmark_value> +<bookmark_value>ungrouping entries in pivot tables</bookmark_value> </bookmark> -<paragraph role="heading" id="par_idN10643" xml-lang="en-US" level="1" l10n="NEW"><variable id="datapilot_grouping"><link href="text/scalc/guide/datapilot_grouping.xhp">Grouping DataPilot Tables</link> -</variable></paragraph><comment>see http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph role="paragraph" id="par_idN10661" xml-lang="en-US" l10n="NEW">The resulting DataPilot table can contain many different entries. By grouping the entries, you can improve the visible result.</paragraph> +<paragraph role="heading" id="par_idN10643" xml-lang="en-US" level="1" l10n="NEW"><variable id="datapilot_grouping"><link href="text/scalc/guide/datapilot_grouping.xhp">Grouping Pivot Tables</link> +</variable></paragraph><comment>see http://specs.openoffice.org/calc/compatibility/grouping.sxw</comment><paragraph role="paragraph" id="par_idN10661" xml-lang="en-US" l10n="NEW">The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result.</paragraph> <list type="ordered"> <listitem> -<paragraph role="paragraph" id="par_idN10667" xml-lang="en-US" l10n="NEW">Select a cell or range of cells in the DataPilot table.</paragraph> +<paragraph role="paragraph" id="par_idN10667" xml-lang="en-US" l10n="NEW">Select a cell or range of cells in the pivot table.</paragraph> </listitem> <listitem> <paragraph role="paragraph" id="par_idN1066B" xml-lang="en-US" l10n="CHG">Choose <emph>Data - Group and Outline - Group</emph>.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_idN1066E" xml-lang="en-US" l10n="NEW">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 <link href="text/scalc/01/12090400.xhp">Grouping</link> dialogs, either for numeric values, or for date values.</paragraph> -<paragraph role="paragraph" id="par_id3328653" xml-lang="en-US" l10n="NEW">The DataPilot table must be organized in a way that grouping can be applied.</paragraph> +<paragraph role="paragraph" id="par_idN1066E" xml-lang="en-US" l10n="NEW">Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two <link href="text/scalc/01/12090400.xhp">Grouping</link> dialogs, either for numeric values, or for date values.</paragraph> +<paragraph role="paragraph" id="par_id3328653" xml-lang="en-US" l10n="NEW">The pivot table must be organized in a way that grouping can be applied.</paragraph> <list type="unordered"> <listitem> <paragraph role="paragraph" id="par_idN10682" xml-lang="en-US" l10n="CHG">To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>.</paragraph> 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 @@ <!--*********************************************************************** * * 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 * @@ -27,28 +27,24 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalcguidedatapilot_tippsxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Selecting DataPilot Output Ranges</title> +<title id="tit" xml-lang="en-US">Selecting Pivot Table Output Ranges</title> <filename>/text/scalc/guide/datapilot_tipps.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-08-09T09:10:26">converted from old format - fpe</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>DataPilot function; preventing data overwriting</bookmark_value> -<bookmark_value>output ranges of DataPilot tables</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148663"><bookmark_value>pivot table function; preventing data overwriting</bookmark_value> +<bookmark_value>output ranges of pivot tables</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3148663" xml-lang="en-US" level="1" l10n="U" oldref="19"><variable id="datapilot_tipps"><link href="text/scalc/guide/datapilot_tipps.xhp" name="Selecting DataPilot Output Ranges">Selecting DataPilot Output Ranges</link> +<paragraph role="heading" id="hd_id3148663" xml-lang="en-US" level="1" l10n="U" oldref="19"><variable id="datapilot_tipps"><link href="text/scalc/guide/datapilot_tipps.xhp" name="Selecting Pivot Table Output Ranges">Selecting Pivot Table Output Ranges</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="U" oldref="20">Click the button <emph>More</emph> in the <emph>DataPilot</emph> dialog. The dialog will be extended.</paragraph> -<paragraph role="paragraph" id="par_id3153771" xml-lang="en-US" l10n="U" oldref="21">You can select a named range in which the DataPilot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly.</paragraph> -<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US" l10n="U" oldref="23">If you mark the <emph>Ignore empty rows </emph>check box, they will not be taken into account when the DataPilot table is created.</paragraph> -<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="U" oldref="24">If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the DataPilot table is created.</paragraph> +<paragraph role="paragraph" id="par_id3154123" xml-lang="en-US" l10n="U" oldref="20">Click the button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog will be extended.</paragraph> +<paragraph role="paragraph" id="par_id3153771" xml-lang="en-US" l10n="U" oldref="21">You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly.</paragraph> +<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US" l10n="U" oldref="23">If you mark the <emph>Ignore empty rows</emph> check box, they will not be taken into account when the pivot table is created.</paragraph> +<paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="U" oldref="24">If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> 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 @@ * ************************************************************************ --> - + <helpdocument version="1.0"> <meta> <topic id="textscalcguidedatapilot_updatetablexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Updating DataPilot Tables</title> +<title id="tit" xml-lang="en-US">Updating Pivot Tables</title> <filename>/text/scalc/guide/datapilot_updatetable.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-05-15T15:31:12">converted from old format - fpe</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150792"><bookmark_value>Pivot table import</bookmark_value> -<bookmark_value>DataPilot function; refreshing tables</bookmark_value> -<bookmark_value>recalculating;DataPilot tables</bookmark_value> -<bookmark_value>updating;DataPilot tables</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150792"><bookmark_value>pivot table import</bookmark_value> +<bookmark_value>pivot table function; refreshing tables</bookmark_value> +<bookmark_value>recalculating;pivot tables</bookmark_value> +<bookmark_value>updating;pivot tables</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3150792" xml-lang="en-US" level="1" l10n="U" oldref="33"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating DataPilot Tables">Updating DataPilot Tables</link> +<paragraph role="heading" id="hd_id3150792" xml-lang="en-US" level="1" l10n="U" oldref="33"><variable id="datapilot_updatetable"><link href="text/scalc/guide/datapilot_updatetable.xhp" name="Updating Pivot Tables">Updating Pivot Tables</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US" l10n="U" oldref="34">If the data of the source sheet has been changed, $[officename] recalculates the DataPilot table. To recalculate the tables, choose <emph>Data - DataPilot - Refresh</emph>. Do the same after you have imported an Excel Pivot table into $[officename] Calc.</paragraph> +<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US" l10n="U" oldref="34">If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> |