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 | |
| parent | 1ad0c2f37631abf7dd99796ba4b21e1eb67d632b (diff) | |
| parent | b82105db49e517a34142584bb82e33fce39af20f (diff) | |
merged DEV300
27 files changed, 231 insertions, 276 deletions
diff --git a/helpcontent2/source/auxiliary/scalc.tree b/helpcontent2/source/auxiliary/scalc.tree index d1c1507d9f..087ee9ce84 100755 --- a/helpcontent2/source/auxiliary/scalc.tree +++ b/helpcontent2/source/auxiliary/scalc.tree @@ -114,14 +114,14 @@ <!-- removed scalc/text/scalc/guide/database_group.xhp --> <topic id="scalc/text/scalc/guide/database_sort.xhp">Sorting Database Ranges</topic> </node> - <node id="0809" title="Data Pilot"> -<topic id="scalc/text/scalc/guide/datapilot.xhp">DataPilot</topic> -<topic id="scalc/text/scalc/guide/datapilot_createtable.xhp">Creating DataPilot Tables</topic> -<topic id="scalc/text/scalc/guide/datapilot_deletetable.xhp">Deleting DataPilot Tables</topic> -<topic id="scalc/text/scalc/guide/datapilot_edittable.xhp">Editing DataPilot Tables</topic> -<topic id="scalc/text/scalc/guide/datapilot_filtertable.xhp">Filtering DataPilot Tables</topic> -<topic id="scalc/text/scalc/guide/datapilot_tipps.xhp">Selecting DataPilot Output Ranges</topic> -<topic id="scalc/text/scalc/guide/datapilot_updatetable.xhp">Updating DataPilot Tables</topic> + <node id="0809" title="Pivot Tables"> +<topic id="scalc/text/scalc/guide/datapilot.xhp">Pivot Tables</topic> +<topic id="scalc/text/scalc/guide/datapilot_createtable.xhp">Creating Pivot Tables</topic> +<topic id="scalc/text/scalc/guide/datapilot_deletetable.xhp">Deleting Pivot Tables</topic> +<topic id="scalc/text/scalc/guide/datapilot_edittable.xhp">Editing Pivot Tables</topic> +<topic id="scalc/text/scalc/guide/datapilot_filtertable.xhp">Filtering Pivot Tables</topic> +<topic id="scalc/text/scalc/guide/datapilot_tipps.xhp">Selecting Pivot Table Output Ranges</topic> +<topic id="scalc/text/scalc/guide/datapilot_updatetable.xhp">Updating Pivot Tables</topic> </node> <node id="0810" title="Scenarios"> <topic id="scalc/text/scalc/guide/scenario.xhp">Using Scenarios</topic> diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp index a432a91a4f..09d8faede5 100644 --- a/helpcontent2/source/text/scalc/00/00000412.xhp +++ b/helpcontent2/source/text/scalc/00/00000412.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 * @@ -77,7 +77,7 @@ </table> </section> </section> -<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab +<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="10"><variable id="dnstot">Choose <emph>Data - Sort - Options</emph> tab </variable></paragraph> <paragraph role="paragraph" id="par_id3155308" xml-lang="en-US" l10n="U" oldref="11"><variable id="dnftr">Choose <emph>Data - Filter</emph> </variable></paragraph> @@ -128,17 +128,17 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id3166424" xml-lang="en-US" l10n="U" oldref="22"><variable id="dntegs">Choose <emph>Data - Subtotals</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US" l10n="U" oldref="23"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs +<paragraph role="paragraph" id="par_id3154574" xml-lang="en-US" l10n="U" oldref="23"><variable id="dntezd">Choose <emph>Data - Subtotals - 1st, 2nd, 3rd Group</emph> tabs </variable></paragraph> -<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab +<paragraph role="paragraph" id="par_id3151277" xml-lang="en-US" l10n="U" oldref="24"><variable id="dntopi">Choose <emph>Data - Subtotals - Options</emph> tab </variable></paragraph> <paragraph role="paragraph" id="par_id3145133" xml-lang="en-US" l10n="U" oldref="25"><variable id="datengueltig">Choose <emph>Data - Validity</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab +<paragraph role="paragraph" id="par_id3152992" xml-lang="en-US" l10n="U" oldref="26"><variable id="datengueltigwerte">Menu <emph>Data - Validity - Criteria</emph> tab </variable></paragraph> -<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US" l10n="U" oldref="27"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab +<paragraph role="paragraph" id="par_id3150367" xml-lang="en-US" l10n="U" oldref="27"><variable id="datengueltigeingabe">Choose <emph>Data - Validity - Input Help</emph> tab </variable></paragraph> -<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U" oldref="28"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab +<paragraph role="paragraph" id="par_id3154486" xml-lang="en-US" l10n="U" oldref="28"><variable id="datengueltigfehler">Choose <emph>Data - Validity - Error Alert</emph> tab </variable></paragraph> <paragraph role="paragraph" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="29"><variable id="dnmfo">Choose <emph>Data - Multiple Operations</emph> </variable></paragraph> @@ -194,21 +194,21 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id3154709" xml-lang="en-US" l10n="U" oldref="41"><variable id="dnglef">Choose <emph>Data - Group and Outline - Remove</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id1774346" xml-lang="en-US" l10n="NEW"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some DataPilot tables) +<paragraph role="paragraph" id="par_id1774346" xml-lang="en-US" l10n="CHG"><variable id="dngdrill">Choose <emph>Data - Group and Outline - Show Details</emph> (for some pivot tables) </variable></paragraph> -<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="U" oldref="42"><variable id="dndtpt">Choose <emph>Data - DataPilot</emph> +<paragraph role="paragraph" id="par_id3155759" xml-lang="en-US" l10n="CHG" oldref="42"><variable id="dndtpt">Choose <emph>Data - Pivot Table</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="U" oldref="43"><variable id="dndpa">Choose <emph>Data - DataPilot - Start</emph> +<paragraph role="paragraph" id="par_id3154625" xml-lang="en-US" l10n="CHG" oldref="43"><variable id="dndpa">Choose <emph>Data - Pivot Table - Create</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US" l10n="U" oldref="53"><variable id="dndq">Choose <emph>Data - DataPilot - Start</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>. +<paragraph role="paragraph" id="par_id3147558" xml-lang="en-US" l10n="CHG" oldref="53"><variable id="dndq">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>. </variable></paragraph> <section id="dndpaz"> -<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US" l10n="U" oldref="50">Choose <emph>Data - DataPilot - Start</emph>, in the Select Source dialog choose the option <emph>Current selection</emph>.</paragraph> -<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="U" oldref="54">Choose <emph>Data - DataPilot - Start</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph> +<paragraph role="paragraph" id="par_id3153297" xml-lang="en-US" l10n="CHG" oldref="50">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Current selection</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3145118" xml-lang="en-US" l10n="CHG" oldref="54">Choose <emph>Data - Pivot Table - Create</emph>, in the Select Source dialog choose the option <emph>Data source registered in $[officename]</emph>, click <emph>OK</emph> to see <emph>Select Data Source</emph> dialog.</paragraph> </section> -<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="U" oldref="44"><variable id="dndpak">Choose <emph>Data - DataPilot - Refresh</emph> +<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="CHG" oldref="44"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph> </variable></paragraph> -<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="U" oldref="45"><variable id="dndploe">Choose <emph>Data - DataPilot - Delete</emph> +<paragraph role="paragraph" id="par_id3151344" xml-lang="en-US" l10n="CHG" oldref="45"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph> </variable></paragraph> <paragraph role="paragraph" id="par_id3150397" xml-lang="en-US" l10n="U" oldref="46"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph> </variable></paragraph> diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index 8c78a37c18..9dbf21f342 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.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 * @@ -594,29 +594,29 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GETPIVOTDATA" id="bm_id897854" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3747062" role="heading" level="2" l10n="NEW">GETPIVOTDATA</paragraph> - <paragraph xml-lang="en-US" id="par_id3593859" role="paragraph" l10n="NEW"><ahelp hid=".">The GETPIVOTDATA function returns a result value from a DataPilot table. The value is addressed using field and item names, so it remains valid if the layout of the DataPilot table changes.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3593859" role="paragraph" l10n="CHG"><ahelp hid=".">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id9741508" role="heading" level="3" l10n="NEW">Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id909451" role="paragraph" l10n="NEW">Two different syntax definitions can be used:</paragraph> - <paragraph xml-lang="en-US" id="par_id1665089" role="code" l10n="NEW">GETPIVOTDATA(TargetField; DataPilot; [ Field 1; Item 1; ... ])</paragraph> - <paragraph xml-lang="en-US" id="par_id4997100" role="code" l10n="NEW">GETPIVOTDATA(DataPilot; Constraints)</paragraph> + <paragraph xml-lang="en-US" id="par_id1665089" role="code" l10n="CHG">GETPIVOTDATA(TargetField; pivot table; [ Field 1; Item 1; ... ])</paragraph> + <paragraph xml-lang="en-US" id="par_id4997100" role="code" l10n="CHG">GETPIVOTDATA(pivot table; Constraints)</paragraph> <paragraph xml-lang="en-US" id="par_id1672109" role="paragraph" l10n="NEW">The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax.</paragraph> <paragraph xml-lang="en-US" id="hd_id9464094" role="heading" level="3" l10n="NEW">First Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id9302346" role="paragraph" l10n="NEW"> - <emph>TargetField</emph> is a string that selects one of the DataPilot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like "Sum - Sales").</paragraph> + <emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like "Sum - Sales").</paragraph> <paragraph xml-lang="en-US" id="par_id8296151" role="paragraph" l10n="NEW"> - <emph>DataPilot</emph> is a reference to a cell or cell range that is positioned within a DataPilot table or contains a DataPilot table. If the cell range contains several DataPilot tables, the table that was created last is used.</paragraph> - <paragraph xml-lang="en-US" id="par_id4809411" role="paragraph" l10n="NEW">If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the DataPilot table. <emph>Item n</emph> is the name of an item from that field.</paragraph> - <paragraph xml-lang="en-US" id="par_id6454969" role="paragraph" l10n="NEW">If the DataPilot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the DataPilot table.</paragraph> - <paragraph xml-lang="en-US" id="par_id79042" role="paragraph" l10n="NEW">If the source data contains entries that are hidden by settings of the DataPilot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive.</paragraph> - <paragraph xml-lang="en-US" id="par_id7928708" role="paragraph" l10n="CHG">If no constraint for a page field is given, the field's selected value is implicitly used. If a constraint for a page field is given, it must match the field's selected value, or an error is returned. Page fields are the fields at the top left of a DataPilot table, populated using the "Page Fields" area of the DataPilot Layout dialog. From each page field, an item (value) can be selected, which means only that item is included in the calculation.</paragraph> - <paragraph xml-lang="en-US" id="par_id3864253" role="paragraph" l10n="NEW">Subtotal values from the DataPilot table are only used if they use the function "auto" (except when specified in the constraint, see <item type="literal">Second Syntax</item> below).</paragraph> + <emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used.</paragraph> + <paragraph xml-lang="en-US" id="par_id4809411" role="paragraph" l10n="NEW">If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field.</paragraph> + <paragraph xml-lang="en-US" id="par_id6454969" role="paragraph" l10n="NEW">If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id79042" role="paragraph" l10n="NEW">If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive.</paragraph> + <paragraph xml-lang="en-US" id="par_id7928708" role="paragraph" l10n="CHG">If no constraint for a page field is given, the field's selected value is implicitly used. If a constraint for a page field is given, it must match the field's selected value, or an error is returned. Page fields are the fields at the top left of a pivot table, populated using the "Page Fields" area of the pivot table layout dialog. From each page field, an item (value) can be selected, which means only that item is included in the calculation.</paragraph> + <paragraph xml-lang="en-US" id="par_id3864253" role="paragraph" l10n="NEW">Subtotal values from the pivot table are only used if they use the function "auto" (except when specified in the constraint, see <item type="literal">Second Syntax</item> below).</paragraph> <paragraph xml-lang="en-US" id="hd_id3144016" role="heading" level="3" l10n="NEW">Second Syntax</paragraph> <paragraph xml-lang="en-US" id="par_id9937131" role="paragraph" l10n="NEW"> - <emph>DataPilot</emph> has the same meaning as in the first syntax.</paragraph> + <emph>pivot table</emph> has the same meaning as in the first syntax.</paragraph> <paragraph xml-lang="en-US" id="par_id5616626" role="paragraph" l10n="CHG"> <emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell.</paragraph> - <paragraph xml-lang="en-US" id="par_id4076357" role="paragraph" l10n="NEW">One of the entries can be the data field name. The data field name can be left out if the DataPilot table contains only one data field, otherwise it must be present. </paragraph> - <paragraph xml-lang="en-US" id="par_id8231757" role="paragraph" l10n="CHG">Each of the other entries specifies a constraint in the form <item type="literal">Field[Item]</item> (with literal characters [ and ]), or only <item type="literal">Item</item> if the item name is unique within all fields that are used in the DataPilot table.<comment>i82342</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id4076357" role="paragraph" l10n="NEW">One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present.</paragraph> + <paragraph xml-lang="en-US" id="par_id8231757" role="paragraph" l10n="CHG">Each of the other entries specifies a constraint in the form <item type="literal">Field[Item]</item> (with literal characters [ and ]), or only <item type="literal">Item</item> if the item name is unique within all fields that are used in the pivot table.<comment>i82342</comment></paragraph> <paragraph xml-lang="en-US" id="par_id3168736" role="paragraph" l10n="CHG">A function name can be added in the form <emph>Field[Item;Function]</emph>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, Count (Numbers only), StDev (Sample), StDevP (Population), Var (Sample), and VarP (Population), case-insensitive.</paragraph><comment>UFI: Example from spec doc is quite difficult to localize. Try to find other one</comment> </section> </sort> diff --git a/helpcontent2/source/text/scalc/01/12080200.xhp b/helpcontent2/source/text/scalc/01/12080200.xhp index 6dc8912078..c50dd95530 100644 --- a/helpcontent2/source/text/scalc/01/12080200.xhp +++ b/helpcontent2/source/text/scalc/01/12080200.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 * @@ -52,7 +52,7 @@ <embed href="text/scalc/00/00000412.xhp#dngde"/> </section> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id6036561" xml-lang="en-US" l10n="NEW"><link href="text/scalc/01/12080700.xhp">Show Details command in DataPilot tables</link></paragraph> +<paragraph role="paragraph" id="par_id6036561" xml-lang="en-US" l10n="CHG"><link href="text/scalc/01/12080700.xhp">Show Details command in pivot tables</link></paragraph> </section> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12080700.xhp b/helpcontent2/source/text/scalc/01/12080700.xhp index 06a1436c1b..f22563129b 100644 --- a/helpcontent2/source/text/scalc/01/12080700.xhp +++ b/helpcontent2/source/text/scalc/01/12080700.xhp @@ -7,7 +7,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 * @@ -35,17 +35,17 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0112080700xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Show Details (DataPilot)</title> +<title id="tit" xml-lang="en-US">Show Details (Pivot Table)</title> <filename>/text/scalc/01/12080700.xhp</filename> </topic> </meta> <body> <section id="details"> -<paragraph role="heading" id="hd_id3344523" xml-lang="en-US" level="1" l10n="NEW"><link href="text/scalc/01/12080700.xhp">Show Details (DataPilot)</link></paragraph> -<paragraph role="paragraph" id="par_id871303" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Inserts a new "drill-down" sheet with more information about the current DataPilot cell. You can also double-click a DataPilot cell to insert the "drill-down" sheet. The new sheet shows a subset of rows from the original data source that constitutes the result data displayed in the current cell.</ahelp></paragraph> +<paragraph role="heading" id="hd_id3344523" xml-lang="en-US" level="1" l10n="NEW"><link href="text/scalc/01/12080700.xhp">Show Details (Pivot Table)</link></paragraph> +<paragraph role="paragraph" id="par_id871303" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Inserts a new "drill-down" sheet with more information about the current pivot table cell. You can also double-click a pivot table cell to insert the "drill-down" sheet. The new sheet shows a subset of rows from the original data source that constitutes the result data displayed in the current cell.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dngdrill"/> -</section><paragraph role="note" id="par_id7132480" xml-lang="en-US" l10n="NEW">Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for DataPilot tables that are based on cell ranges or database data.</paragraph> +</section><paragraph role="note" id="par_id7132480" xml-lang="en-US" l10n="NEW">Hidden items are not evaluated, the rows for the hidden items are included. Show Details is available only for pivot tables that are based on cell ranges or database data.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090000.xhp b/helpcontent2/source/text/scalc/01/12090000.xhp index ef77f1c7d8..377869e05e 100755 --- a/helpcontent2/source/text/scalc/01/12090000.xhp +++ b/helpcontent2/source/text/scalc/01/12090000.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,31 +27,27 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090000xml" 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/01/12090000.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-07-20T11:56:09">converted from old format - fpe</lastedited> -</history> </meta> <body> <section id="datenpilot"> -<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/12090000.xhp" name="DataPilot">DataPilot</link></paragraph> -<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US" l10n="U" oldref="2">A DataPilot table provides a summary of large amounts of data. You can then rearrange the DataPilot table to view different summaries of the data.</paragraph> +<paragraph role="heading" id="hd_id3150275" xml-lang="en-US" level="1" l10n="CHG" oldref="1"><link href="text/scalc/01/12090000.xhp" name="Pivot Table">Pivot Table</link></paragraph> +<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US" l10n="CHG" oldref="2">A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.</paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndtpt"/> </section> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> -<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="2" l10n="U" oldref="3"><link href="text/scalc/01/12090100.xhp" name="Start">Start</link></paragraph> +<paragraph role="heading" id="hd_id3155923" xml-lang="en-US" level="2" l10n="CHG" oldref="3"><link href="text/scalc/01/12090100.xhp" name="Create">Create</link></paragraph> <embed href="text/scalc/01/12090100.xhp#datenpilot"/> <embed href="text/scalc/01/12090200.xhp#aktualisieren"/> <embed href="text/scalc/01/12090300.xhp#loeschen"/> -<paragraph role="paragraph" id="par_idN105FB" xml-lang="en-US" l10n="NEW"><link href="text/scalc/01/12090102.xhp" name="DataPilot dialog">DataPilot dialog</link></paragraph> +<paragraph role="paragraph" id="par_idN105FB" xml-lang="en-US" l10n="CHG"><link href="text/scalc/01/12090102.xhp" name="Pivot table dialog">Pivot table dialog</link></paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090100.xhp b/helpcontent2/source/text/scalc/01/12090100.xhp index 0d3718bd67..32513bbf4f 100644 --- a/helpcontent2/source/text/scalc/01/12090100.xhp +++ b/helpcontent2/source/text/scalc/01/12090100.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,40 +27,35 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090100xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Select Source</title> <filename>/text/scalc/01/12090100.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-07-26T10:32:32">converted from old format - fpe</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="hid/.uno:DataDataPilotRun" id="bm_id4138161" localize="false"/><!-- HID added by script --> <bookmark xml-lang="en-US" branch="hid/.uno:DataDataPilotRun" id="bm_id3153822" localize="false"/> <paragraph role="heading" id="hd_id3153663" xml-lang="en-US" level="1" l10n="U" oldref="1">Select Source</paragraph> <section id="datenpilot"> -<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:DataDataPilotRun">Opens a dialog where you can select the source for your DataPilot table, and then create your table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:DataDataPilotRun">Opens a dialog where you can select the source for your pivot table, and then create your table.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndpa"/> </section> <paragraph role="heading" id="hd_id3154760" xml-lang="en-US" level="2" l10n="U" oldref="5">Selection</paragraph> -<paragraph role="paragraph" id="par_id3150543" xml-lang="en-US" l10n="U" oldref="6">Select a data source for the DataPilot table.</paragraph> +<paragraph role="paragraph" id="par_id3150543" xml-lang="en-US" l10n="U" oldref="6">Select a data source for the pivot table.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DAPITYPE:BTN_SELECTION" id="bm_id3154908" localize="false"/> <paragraph role="heading" id="hd_id3148799" xml-lang="en-US" level="3" l10n="U" oldref="7">Current Selection</paragraph> -<paragraph role="paragraph" id="par_id3125865" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DAPITYPE:BTN_SELECTION">Uses the selected cells as the data source for the DataPilot table.</ahelp></paragraph> -<paragraph role="note" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="13">The data columns in the DataPilot table use the same number format as the first data row in the current selection.</paragraph> +<paragraph role="paragraph" id="par_id3125865" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid=".">Uses the selected cells as the data source for the pivot table.</ahelp></paragraph> +<paragraph role="note" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="13">The data columns in the pivot table use the same number format as the first data row in the current selection.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DAPITYPE:BTN_DATABASE" id="bm_id3149664" localize="false"/> <paragraph role="heading" id="hd_id3147348" xml-lang="en-US" level="3" l10n="U" oldref="9">Data source registered in $[officename]</paragraph> -<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DAPITYPE:BTN_DATABASE">Uses a table or query in a database that is registered in $[officename] as the data source for the DataPilot table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3145271" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid=".">Uses a table or query in a database that is registered in $[officename] as the data source for the pivot table.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DAPITYPE:BTN_EXTERNAL" id="bm_id3153876" localize="false"/> <paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="3" l10n="U" oldref="11">External source/interface</paragraph> -<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid=".">Opens the <emph>External Source</emph> dialog where you can select the OLAP data source for the DataPilot table.</ahelp></paragraph> -<paragraph role="paragraph" id="par_idN10670" xml-lang="en-US" l10n="NEW"><link href="text/scalc/01/12090102.xhp" name="DataPilot dialog">DataPilot dialog</link></paragraph> +<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid=".">Opens the <emph>External Source</emph> dialog where you can select the OLAP data source for the pivot table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN10670" xml-lang="en-US" l10n="NEW"><link href="text/scalc/01/12090102.xhp" name="Pivot table dialog">Pivot table dialog</link></paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090101.xhp b/helpcontent2/source/text/scalc/01/12090101.xhp index 8855a6bf2c..a6739bc7bd 100755 --- a/helpcontent2/source/text/scalc/01/12090101.xhp +++ b/helpcontent2/source/text/scalc/01/12090101.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 * @@ -29,7 +29,7 @@ ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090101xml" indexer="include" status="PUBLISH"> @@ -59,7 +59,7 @@ <paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="3" l10n="U" oldref="9">Type</paragraph> <paragraph role="paragraph" id="par_id3150010" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:LISTBOX:RID_SCDLG_DAPIDATA:LB_OBJTYPE">Click the source type of for the selected data source.</ahelp> You can choose from four source types: "Table", "Query" and "SQL" or SQL (Native).</paragraph> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U" oldref="11"><link href="text/scalc/01/12090102.xhp" name="DataPilot dialog">DataPilot dialog</link></paragraph> +<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U" oldref="11"><link href="text/scalc/01/12090102.xhp" name="Pivot table dialog">Pivot table dialog</link></paragraph> </section> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090102.xhp b/helpcontent2/source/text/scalc/01/12090102.xhp index 8f5e66bc8a..f9b6187b7e 100644 --- a/helpcontent2/source/text/scalc/01/12090102.xhp +++ b/helpcontent2/source/text/scalc/01/12090102.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,27 +29,26 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalc0112090102xml" indexer="include"> - <title xml-lang="en-US" id="tit">DataPilot</title> + <title xml-lang="en-US" id="tit">Pivot Table</title> <filename>/text/scalc/01/12090102.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id2306894"><bookmark_value>DataPilot function;show details</bookmark_value> - <bookmark_value>DataPilot function;drill down</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id2306894"><bookmark_value>pivot table function;show details</bookmark_value> +<bookmark_value>pivot table function;drill down</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/.uno:DataPilotExec" id="bm_id1491879" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:DataPilotExec" id="bm_id3154514" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3149165" role="heading" level="1" l10n="U" oldref="1">DataPilot</paragraph> - <paragraph xml-lang="en-US" id="par_id3155922" role="paragraph" l10n="CHG" oldref="13"><ahelp hid=".uno:DataPilotExec">Specify the layout of the table that is generated by the DataPilot.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3149165" role="heading" level="1" l10n="U" oldref="1">Pivot Table</paragraph> + <paragraph xml-lang="en-US" id="par_id3155922" role="paragraph" l10n="CHG" oldref="13"><ahelp hid=".uno:DataPilotExec">Specify the layout of the table that is generated by the pivot table.</ahelp></paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndpaz"/> </section> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> - <paragraph xml-lang="en-US" id="par_id3148798" role="paragraph" l10n="U" oldref="34">The DataPilot displays data fields as buttons which you can drag and drop to define the DataPilot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148798" role="paragraph" l10n="U" oldref="34">The pivot table displays data fields as buttons which you can drag and drop to define the pivot table.</paragraph> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPLAY_SELECT" id="bm_id3335062" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPLAY_COLUMN" id="bm_id9569689" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPLAY_ROW" id="bm_id7529526" localize="false"/> @@ -57,7 +56,7 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPLAY_PAGE" id="bm_id7411420" localize="false"/><comment>UFI: changed help id from 59001 to dply_page</comment> <paragraph xml-lang="en-US" id="hd_id3154908" role="heading" level="2" l10n="U" oldref="18">Layout</paragraph> - <paragraph xml-lang="en-US" id="par_id3150768" role="paragraph" l10n="CHG" oldref="19"><ahelp hid="HID_SC_DPLAY_SELECT">To define the layout of a DataPilot table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag and drop to rearrange the data fields on a DataPilot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150768" role="paragraph" l10n="CHG" oldref="19"><ahelp hid="HID_SC_DPLAY_SELECT">To define the layout of a pivot table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag and drop to rearrange the data fields on a pivot table.</paragraph> <paragraph xml-lang="en-US" id="par_id3147229" role="paragraph" l10n="CHG" oldref="20">$[officename] automatically adds a caption to buttons that are dragged into the <emph>Data Fields </emph>area. The caption contains the name of the data field as well as the formula that created the data.</paragraph> <paragraph xml-lang="en-US" id="par_id3145749" role="paragraph" l10n="CHG" oldref="21">To change the function that is used by a data field, double-click a button in the <emph>Data Fields</emph> area to open the <link href="text/scalc/01/12090105.xhp" name="Data Field">Data Field</link> dialog. You can also double-click buttons in the <emph>Row Fields</emph> or <emph>Column Fields</emph> areas.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_PIVOT_LAYOUT:BTN_REMOVE" id="bm_id1926938" localize="false"/> @@ -71,19 +70,19 @@ <bookmark xml-lang="en-US" branch="hid/sc:MoreButton:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE" id="bm_id4284798" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154944" role="heading" level="2" l10n="U" oldref="22">More</paragraph> - <paragraph xml-lang="en-US" id="par_id3145647" role="paragraph" l10n="U" oldref="23"><ahelp hid="SC:MOREBUTTON:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE">Displays or hides additional options for defining the DataPilot table.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3145647" role="paragraph" l10n="U" oldref="23"><ahelp hid="SC:MOREBUTTON:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE">Displays or hides additional options for defining the pivot table.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3151073" role="heading" level="2" l10n="U" oldref="2">Result</paragraph> - <paragraph xml-lang="en-US" id="par_id3155417" role="paragraph" l10n="U" oldref="3">Specify the settings for displaying the results of the DataPilot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155417" role="paragraph" l10n="U" oldref="3">Specify the settings for displaying the results of the pivot table.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_INAREA" id="bm_id7418660" localize="false"/> <bookmark xml-lang="en-US" branch="hid/sc:ImageButton:RID_SCDLG_PIVOT_LAYOUT:RB_INAREA" id="bm_id7418760" localize="false"/> <paragraph xml-lang="en-US" id="hd_id0509200913025625" role="heading" level="3" l10n="NEW">Selection from</paragraph> - <paragraph xml-lang="en-US" id="par_id0509200913025615" role="paragraph" l10n="NEW"><ahelp hid=".">Select the area that contains the data for the current datapilot table.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id0509200913025615" role="paragraph" l10n="NEW"><ahelp hid=".">Select the area that contains the data for the current pivot table.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA" id="bm_id7419660" localize="false"/> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_PIVOT_LAYOUT:LB_OUTAREA" id="bm_id2334665" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155603" role="heading" level="2" l10n="U" oldref="4">Results to</paragraph> - <paragraph xml-lang="en-US" id="par_id3153838" role="paragraph" l10n="U" oldref="5"><ahelp hid="SC:EDIT:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA">Select the area where you want to display the results of the DataPilot table.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="par_id3153838" role="paragraph" l10n="U" oldref="5"><ahelp hid="SC:EDIT:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA">Select the area where you want to display the results of the pivot table.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#eingabesymbol"/> - <paragraph xml-lang="en-US" id="par_id3155961" role="warning" l10n="CHG" oldref="6">If the selected area contains data, the DataPilot overwrites the data. To prevent the loss of existing data, let the DataPilot automatically select the area to display the results.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155961" role="warning" l10n="CHG" oldref="6">If the selected area contains data, the pivot table overwrites the data. To prevent the loss of existing data, let the pivot table automatically select the area to display the results.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS" id="bm_id7835016" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3147364" role="heading" level="2" l10n="U" oldref="7">Ignore empty rows</paragraph> <paragraph xml-lang="en-US" id="par_id3154022" role="paragraph" l10n="U" oldref="8"><ahelp hid="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS">Ignores empty fields in the data source.</ahelp></paragraph> @@ -100,16 +99,15 @@ <paragraph xml-lang="en-US" id="par_id3152583" role="paragraph" l10n="U" oldref="17"><ahelp hid="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW">Calculates and displays the grand total of the row calculation.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_FILTER" id="bm_id6004516" localize="false"/> <paragraph xml-lang="en-US" id="par_idN10897" role="heading" level="2" l10n="NEW">Add filter</paragraph> - <paragraph xml-lang="en-US" id="par_idN1089B" role="paragraph" l10n="NEW"><ahelp hid=".">Adds a Filter button to DataPilot tables that are based on spreadsheet data.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/.uno:DataPilotFilter" id="bm_id4442201" localize="false"/> + <paragraph xml-lang="en-US" id="par_idN1089B" role="paragraph" l10n="NEW"><ahelp hid=".">Adds a Filter button to pivot tables that are based on spreadsheet data.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/.uno:DataPilotFilter" id="bm_id6278267" localize="false"/> <paragraph xml-lang="en-US" id="par_idN108B2" role="paragraph" l10n="NEW"><ahelp hid=".">Opens the Filter dialog.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_PIVOT_LAYOUT:BTN_DRILLDOWN" id="bm_id7366252" localize="false"/> <paragraph xml-lang="en-US" id="par_idN108C9" role="heading" level="2" l10n="NEW">Enable drill to details</paragraph> <paragraph xml-lang="en-US" id="par_idN108CD" role="paragraph" l10n="NEW"><ahelp hid=".">Select this check box and double-click an item label in the table to show or hide details for the item. Clear this check box and double-click a cell in the table to edit the contents of the cell.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="par_idN108DC" role="heading" level="2" l10n="NEW">To examine details inside a DataPilot table</paragraph> + <paragraph xml-lang="en-US" id="par_idN108DC" role="heading" level="2" l10n="NEW">To examine details inside a pivot table</paragraph> <paragraph xml-lang="en-US" id="par_idN108E0" role="paragraph" l10n="NEW">Do one of the following:</paragraph> - <list type="ordered"> + <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN108E6" role="paragraph" l10n="CHG">Select a range of cells and choose <emph>Data - Group and Outline - Show Details</emph>.</paragraph> </listitem> @@ -122,7 +120,7 @@ <paragraph xml-lang="en-US" id="par_idN10900" role="heading" level="2" l10n="NEW">Show Detail</paragraph> <paragraph xml-lang="en-US" id="par_idN10904" role="paragraph" l10n="NEW"><ahelp hid=".">Choose the field that you want to view the details for.</ahelp></paragraph> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3149817" role="paragraph" l10n="U" oldref="35"><link href="text/scalc/04/01020000.xhp" name="DataPilot shortcut keys">DataPilot shortcut keys</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3149817" role="paragraph" l10n="U" oldref="35"><link href="text/scalc/04/01020000.xhp" name="Pivot table shortcut keys">Pivot table shortcut keys</link></paragraph> </section> </body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/12090105.xhp b/helpcontent2/source/text/scalc/01/12090105.xhp index 4f761bedb3..5484d260e7 100644..100755 --- a/helpcontent2/source/text/scalc/01/12090105.xhp +++ b/helpcontent2/source/text/scalc/01/12090105.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,25 +27,20 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090105xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Data field</title> <filename>/text/scalc/01/12090105.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-09-27T11:52:36">UFI: added info from spec sc-features Field Options in DataPilot -YJ: checked</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_PIVOTSUBT" id="bm_id3153194" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id7292397"><bookmark_value>calculating;Data Pilot</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id7292397"><bookmark_value>calculating;pivot table</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3150871" xml-lang="en-US" level="1" l10n="U" oldref="1">Data field</paragraph> -<paragraph role="paragraph" id="par_id3154124" xml-lang="en-US" l10n="U" oldref="16">The contents of this dialog is different for data fields in the <emph>Data</emph> area, and data fields in the<emph> Row</emph> or<emph> Column</emph> area of the <link href="text/scalc/01/12090102.xhp" name="DataPilot">DataPilot</link> dialog.</paragraph> +<paragraph role="paragraph" id="par_id3154124" xml-lang="en-US" l10n="U" oldref="16">The contents of this dialog is different for data fields in the <emph>Data</emph> area, and data fields in the <emph>Row</emph> or <emph>Column</emph> area of the <link href="text/scalc/01/12090102.xhp" name="Pivot table">Pivot Table</link> dialog.</paragraph> <paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="2" l10n="U" oldref="2">Subtotals</paragraph> <paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_SC_PIVOTSUBT">Specify the subtotals that you want to calculate.</ahelp></paragraph> <!-- removed HID SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_NONE --> @@ -141,7 +136,7 @@ YJ: checked</lastedited> <paragraph role="tablecontent" id="par_idN10787" xml-lang="en-US" l10n="NEW">% of row</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_idN1078D" xml-lang="en-US" l10n="NEW">Each result is divided by the total result for its row in the DataPilot table. If there are several data fields, the total for the result's data field is used. If there are subtotals with manually selected summary functions, the total with the data field's summary function is still used. </paragraph> +<paragraph role="tablecontent" id="par_idN1078D" xml-lang="en-US" l10n="NEW">Each result is divided by the total result for its row in the pivot table. If there are several data fields, the total for the result's data field is used. If there are subtotals with manually selected summary functions, the total with the data field's summary function is still used. </paragraph> </tablecell> </tablerow> <tablerow> diff --git a/helpcontent2/source/text/scalc/01/12090106.xhp b/helpcontent2/source/text/scalc/01/12090106.xhp index 6f04ba9d2c..842d7bb1e3 100644..100755 --- a/helpcontent2/source/text/scalc/01/12090106.xhp +++ b/helpcontent2/source/text/scalc/01/12090106.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 * @@ -40,12 +40,12 @@ </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id711386"><bookmark_value>hiding;data fields, from calculations in Data Pilot</bookmark_value> -<bookmark_value>display options in Data Pilot</bookmark_value> -<bookmark_value>sorting;options in Data Pilot</bookmark_value> -<bookmark_value>data field options for Data Pilot</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id711386"><bookmark_value>hiding;data fields, from calculations in pivot table</bookmark_value> +<bookmark_value>display options in pivot table</bookmark_value> +<bookmark_value>sorting;options in pivot table</bookmark_value> +<bookmark_value>data field options for pivot table</bookmark_value> </bookmark><comment>mw changed "hiding..." entry</comment><paragraph role="heading" id="par_idN10542" xml-lang="en-US" level="1" l10n="NEW">Data Field Options</paragraph> -<paragraph role="paragraph" id="par_idN10546" xml-lang="en-US" l10n="NEW">You can specify additional options for column, row, and page data fields in the <link href="text/scalc/01/12090105.xhp">DataPilot</link>.</paragraph> +<paragraph role="paragraph" id="par_idN10546" xml-lang="en-US" l10n="NEW">You can specify additional options for column, row, and page data fields in the <link href="text/scalc/01/12090105.xhp">pivot table</link>.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_SORT_BY" id="bm_id6588335" localize="false"/><paragraph role="heading" id="par_idN10557" xml-lang="en-US" level="2" l10n="NEW">Sort by</paragraph> <paragraph role="paragraph" id="par_idN1055B" xml-lang="en-US" l10n="NEW"><ahelp hid="1495387653">Select the data field that you want to sort columns or rows by.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DPSUBTOTAL_OPT:RB_SORT_ASC" id="bm_id6422009" localize="false"/><paragraph role="heading" id="par_idN1055E" xml-lang="en-US" level="3" l10n="NEW">Ascending</paragraph> @@ -59,7 +59,7 @@ <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_LAYOUT" id="bm_id113223" localize="false"/><paragraph role="heading" id="par_idN1058C" xml-lang="en-US" level="3" l10n="NEW">Layout</paragraph> <paragraph role="paragraph" id="par_idN10590" xml-lang="en-US" l10n="NEW"><ahelp hid="1495387654">Select the layout mode for the field in the list box.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_DPSUBTOTAL_OPT:CB_LAYOUT_EMPTY" id="bm_id2646870" localize="false"/><paragraph role="heading" id="par_idN10593" xml-lang="en-US" level="3" l10n="NEW">Empty line after each item</paragraph> -<paragraph role="paragraph" id="par_idN10597" xml-lang="en-US" l10n="NEW"><ahelp hid="1495385090">Adds an empty row after the data for each item in the DataPilot table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN10597" xml-lang="en-US" l10n="NEW"><ahelp hid="1495385090">Adds an empty row after the data for each item in the pivot table.</ahelp></paragraph> <paragraph role="heading" id="par_idN1059A" xml-lang="en-US" level="2" l10n="NEW">Show automatically</paragraph> <paragraph role="paragraph" id="par_idN1059E" xml-lang="en-US" l10n="NEW">Displays the top or bottom nn items when you sort by a specified field.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_DPSUBTOTAL_OPT:CB_SHOW" id="bm_id4634540" localize="false"/><paragraph role="heading" id="par_idN105A1" xml-lang="en-US" level="3" l10n="NEW">Show</paragraph> @@ -73,6 +73,6 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_SC_DPSUBT_HIDE" id="bm_id2068849" localize="false"/><paragraph role="heading" id="par_idN105BD" xml-lang="en-US" level="2" l10n="NEW">Hide items</paragraph> <paragraph role="paragraph" id="par_idN105C1" xml-lang="en-US" l10n="NEW"><ahelp hid="59010">Select the items that you want to hide from the calculations.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_DPSUBTOTAL_OPT:LB_HIERARCHY" id="bm_id6507461" localize="false"/><paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="3" l10n="NEW">Hierarchy</paragraph> -<paragraph role="paragraph" id="par_idN105C8" xml-lang="en-US" l10n="NEW"><ahelp hid="1495387657">Select the hierarchy that you want to use. The DataPilot must be based on an external source data that contains data hierarchies.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN105C8" xml-lang="en-US" l10n="NEW"><ahelp hid="1495387657">Select the hierarchy that you want to use. The pivot table must be based on an external source data that contains data hierarchies.</ahelp></paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090200.xhp b/helpcontent2/source/text/scalc/01/12090200.xhp index 91081ce184..e619640974 100644 --- a/helpcontent2/source/text/scalc/01/12090200.xhp +++ b/helpcontent2/source/text/scalc/01/12090200.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,7 +27,7 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090200xml" indexer="include" status="PUBLISH"> @@ -44,9 +44,9 @@ <bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id7263611" localize="false"/><!-- HID added by script --> <bookmark xml-lang="en-US" branch="hid/.uno:RecalcPivotTable" id="bm_id3145069" localize="false"/> <paragraph role="heading" id="hd_id3151385" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/12090200.xhp" name="Refresh">Refresh</link></paragraph> -<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:RecalcPivotTable">Updates the DataPilot table.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:RecalcPivotTable">Updates the pivot table.</ahelp></paragraph> </section> -<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U" oldref="3">After you import an Excel spreadsheet that contains a Pivot table, click in the table, and then choose <emph>Data - DataPilot - Refresh</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U" oldref="3">After you import an Excel spreadsheet that contains a pivot table, click in the table, and then choose <emph>Data - Pivot Table - Refresh</emph>.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#dndpak"/> </section> diff --git a/helpcontent2/source/text/scalc/01/12090300.xhp b/helpcontent2/source/text/scalc/01/12090300.xhp index e4ae79f4d5..2746a04605 100644 --- a/helpcontent2/source/text/scalc/01/12090300.xhp +++ b/helpcontent2/source/text/scalc/01/12090300.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 * @@ -32,21 +32,15 @@ <title xml-lang="en-US" id="tit">Delete</title> <filename>/text/scalc/01/12090300.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> -</history> </meta> <body> - - - <section id="loeschen"> - <bookmark xml-lang="en-US" branch="hid/.uno:DeletePivotTable" id="bm_id8594613" localize="false"/><!-- HID added by script --> +<section id="loeschen"> +<bookmark xml-lang="en-US" branch="hid/.uno:DeletePivotTable" id="bm_id8594613" localize="false"/><!-- HID added by script --> <bookmark branch="hid/.uno:DeletePivotTable" xml-lang="en-US" id="bm_id3148491"/><paragraph id="hd_id3150276" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/scalc/01/12090300.xhp" name="Delete">Delete</link></paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3159400" xml-lang="en-US" oldref="2"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected DataPilot table.</ahelp></paragraph> - </section> - <section id="howtoget"> - <embed href="text/scalc/00/00000412.xhp#dndploe"/> +<paragraph l10n="U" role="paragraph" id="par_id3159400" xml-lang="en-US" oldref="2"><ahelp hid=".uno:DeletePivotTable" visibility="visible">Deletes the selected pivot table.</ahelp></paragraph> +</section> +<section id="howtoget"> +<embed href="text/scalc/00/00000412.xhp#dndploe"/> </section> - </body> +</body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/01/12090400.xhp b/helpcontent2/source/text/scalc/01/12090400.xhp index 0b8deac477..6337482c43 100755 --- a/helpcontent2/source/text/scalc/01/12090400.xhp +++ b/helpcontent2/source/text/scalc/01/12090400.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,21 +27,17 @@ * for a copy of the LGPLv3 License. * ************************************************************************--> - + <helpdocument version="1.0"> <meta> <topic id="textscalc0112090400xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Grouping</title> <filename>/text/scalc/01/12090400.xhp</filename> </topic> -<history> -<created date="2004-07-20T10:53:05">UFI: Grouping dialog of DataPilot</created> -<lastedited date="2004-09-27T13:04:52">YJ: checked</lastedited> -</history> </meta> <body> <paragraph role="heading" id="par_idN1054D" xml-lang="en-US" level="1" l10n="NEW">Grouping</paragraph> -<paragraph role="paragraph" id="par_idN10551" xml-lang="en-US" l10n="NEW">Grouping DataPilot tables displays the <emph>Grouping</emph> dialog for either values or dates.</paragraph> +<paragraph role="paragraph" id="par_idN10551" xml-lang="en-US" l10n="NEW">Grouping pivot tables displays the <emph>Grouping</emph> dialog for either values or dates.</paragraph> <section id="howtoget"> <embed href="text/scalc/00/00000412.xhp#grouping"/> </section> diff --git a/helpcontent2/source/text/scalc/04/01020000.xhp b/helpcontent2/source/text/scalc/04/01020000.xhp index 7e312d217f..71a0d715ed 100755 --- a/helpcontent2/source/text/scalc/04/01020000.xhp +++ b/helpcontent2/source/text/scalc/04/01020000.xhp @@ -7,7 +7,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 * @@ -558,7 +558,7 @@ </tablerow> </table> <section id="datenpiloten"> -<paragraph role="heading" id="hd_id3154205" xml-lang="en-US" level="2" l10n="U" oldref="178">Using the DataPilot</paragraph> +<paragraph role="heading" id="hd_id3154205" xml-lang="en-US" level="2" l10n="CHG" oldref="178">Using the pivot table</paragraph> <table id="tbl_id2419507"> <tablerow> <tablecell colspan="" rowspan=""> 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"/> 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 @@ <body> <section id="daten"> <bookmark xml-lang="en-US" branch="hid/.uno:DataMenu" id="bm_id9612414" localize="false"/><paragraph role="heading" id="hd_id3153254" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/main0112.xhp" name="Data">Data</link></paragraph> -<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".">Use the <emph>Data </emph>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.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="CHG" oldref="2"><ahelp hid=".">Use the <emph>Data</emph> 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.</ahelp></paragraph> </section> <paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="2" l10n="U" oldref="3"><link href="text/scalc/01/12010000.xhp" name="Define Range">Define Range</link></paragraph> <embed href="text/scalc/01/12010000.xhp#bereichtext"/> diff --git a/helpcontent2/source/text/shared/00/00000207.xhp b/helpcontent2/source/text/shared/00/00000207.xhp index 3b770282ee..6bed5d8418 100644..100755 --- a/helpcontent2/source/text/shared/00/00000207.xhp +++ b/helpcontent2/source/text/shared/00/00000207.xhp @@ -7,7 +7,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 * @@ -35,13 +35,13 @@ <helpdocument version="1.0"> <meta> <topic id="textshared0000000207xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Export of text files</title> +<title id="tit" xml-lang="en-US">Export text files</title> <filename>/text/shared/00/00000207.xhp</filename> </topic> </meta> <body> -<paragraph role="heading" id="hd_id3153116" xml-lang="en-US" level="1" l10n="U" oldref="1">Export of text files</paragraph> -<paragraph role="paragraph" id="par_id3150379" xml-lang="en-US" l10n="U" oldref="7">The <emph>Export of text files</emph> dialog allows you to define the export options for text files. The dialog will be displayed if you save spreadsheet data as file type "Text CSV", and if the <emph>Edit filter settings</emph> check box is marked in the <emph>Save As</emph> dialog.</paragraph> +<paragraph role="heading" id="hd_id3153116" xml-lang="en-US" level="1" l10n="U" oldref="1">Export text files</paragraph> +<paragraph role="paragraph" id="par_id3150379" xml-lang="en-US" l10n="U" oldref="7">The <emph>Export text files</emph> dialog allows you to define the export options for text files. The dialog will be displayed if you save spreadsheet data as file type "Text CSV", and if the <emph>Edit filter settings</emph> check box is marked in the <emph>Save As</emph> dialog.</paragraph> <paragraph role="heading" id="hd_id3155577" xml-lang="en-US" level="2" l10n="U" oldref="2">Field options</paragraph> <paragraph role="paragraph" id="par_id3152427" xml-lang="en-US" l10n="U" oldref="8">Defines the field separator, text separator and character set that is used for the text export.</paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_IMPORTOPT:DDLB_FONT" id="bm_id3154841" localize="false"/><paragraph role="heading" id="hd_id3152876" xml-lang="en-US" level="3" l10n="U" oldref="5">Character set</paragraph> @@ -50,10 +50,14 @@ <paragraph role="paragraph" id="par_id3150838" xml-lang="en-US" l10n="CHG" oldref="9"><ahelp hid="SC:COMBOBOX:RID_SCDLG_IMPORTOPT:ED_FIELDSEP">Choose or enter the field delimiter, which separates data fields.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/sc:ComboBox:RID_SCDLG_IMPORTOPT:ED_TEXTSEP" id="bm_id3146938" localize="false"/><paragraph role="heading" id="hd_id3154682" xml-lang="en-US" level="3" l10n="U" oldref="4">Text delimiter</paragraph> <paragraph role="paragraph" id="par_id3154863" xml-lang="en-US" l10n="CHG" oldref="10"><ahelp hid="SC:COMBOBOX:RID_SCDLG_IMPORTOPT:ED_TEXTSEP">Choose or enter the text delimiter, which encloses every data field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/sc_CheckBox_RID_SCDLG_IMPORTOPT_CB_SAVESHOWN" id="bm_id7735831" localize="false"/><paragraph role="heading" id="hd_id7145298" xml-lang="en-US" level="3" l10n="NEW">Save cell content as shown</paragraph> + +<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_QUOTEALL" id="bm_id314783281" localize="false"/><paragraph role="heading" id="hd_id783149793" xml-lang="en-US" level="3" l10n="NEW">Quote all text cells</paragraph> +<paragraph role="paragraph" id="par_id3152778363" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Exports all text cells with leading and trailing quote characters as set in the Text delimiter box. If not checked, only those text cells get quoted that contain the Field delimiter character.</ahelp></paragraph> + +<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_SAVESHOWN" id="bm_id7735831" localize="false"/><paragraph role="heading" id="hd_id7145298" xml-lang="en-US" level="3" l10n="NEW">Save cell content as shown</paragraph> <paragraph role="paragraph" id="par_id5719779" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Enabled by default, data will be saved as displayed, including applied number formats. If this checkbox is not marked, raw data content will be saved, as in older versions of the software.</ahelp></paragraph> <paragraph role="warning" id="par_id3541062" xml-lang="en-US" l10n="NEW">Depending on the number format, saving cell content as shown may write values that during an import cannot be interpreted as numerical values anymore.</paragraph> -<bookmark xml-lang="en-US" branch="hid/SC_CHECKBOX_RID_SCDLG_IMPORTOPT_CB_FIXEDWIDTH" id="bm_id3143281" localize="false"/><paragraph role="heading" id="hd_id3149793" xml-lang="en-US" level="3" l10n="U" oldref="12">Fixed column width</paragraph> +<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_IMPORTOPT:CB_FIXEDWIDTH" id="bm_id3143281" localize="false"/><paragraph role="heading" id="hd_id3149793" xml-lang="en-US" level="3" l10n="U" oldref="12">Fixed column width</paragraph> <paragraph role="paragraph" id="par_id3152363" xml-lang="en-US" l10n="U" oldref="13"><ahelp hid="SC_CHECKBOX_RID_SCDLG_IMPORTOPT_CB_FIXEDWIDTH">Exports all data fields with a fixed width.</ahelp></paragraph> <list type="unordered"> <listitem> 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 @@ <?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. * * OpenOffice.org - a multi-platform office productivity suite @@ -29,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textsharedguidemicrosoft_termsxml" indexer="include"> <title id="tit" xml-lang="en-US">Comparing Microsoft Office and $[officename] Terms</title> @@ -135,14 +135,6 @@ </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3154942" xml-lang="en-US" l10n="U" oldref="51">PivotTable</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3156181" xml-lang="en-US" l10n="U" oldref="52"><link href="text/scalc/01/12090102.xhp" name="DataPilot">DataPilot</link></paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> <paragraph role="tablecontent" id="par_id3153950" xml-lang="en-US" l10n="CHG" oldref="26">Refresh Data (in Excel)</paragraph> </tablecell> <tablecell> 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 @@ <!--*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * + * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite @@ -38,8 +38,8 @@ </history> </meta> <body> - - + + <comment>This file contains extra strings for the contents (*.tree) files. No indexing!</comment> <switch select="sys"> <case select="OS2"> <paragraph role="heading" level="1" id="hd_id3155364" l10n="U" xml-lang="en-US" oldref="1" localize="false">Note to translators:</paragraph> @@ -132,7 +132,7 @@ <paragraph role="paragraph" id="par_id3166425" l10n="U" xml-lang="en-US" oldref="67"><node id="0806" title="Filtering and Sorting"></paragraph> <paragraph role="paragraph" id="par_id3154716" l10n="U" xml-lang="en-US" oldref="68"><node id="0807" title="Printing"></paragraph> <paragraph role="paragraph" id="par_id3150344" l10n="U" xml-lang="en-US" oldref="69"><node id="0808" title="Data Ranges"></paragraph> - <paragraph role="paragraph" id="par_id3150364" l10n="U" xml-lang="en-US" oldref="70"><node id="0809" title="Data Pilot"></paragraph> + <paragraph role="paragraph" id="par_id3150364" l10n="U" xml-lang="en-US" oldref="70"><node id="0809" title="Pivot Table"></paragraph> <paragraph role="paragraph" id="par_id3149966" l10n="U" xml-lang="en-US" oldref="71"><node id="0810" title="Scenarios"></paragraph> <paragraph role="paragraph" id="par_id3146811" l10n="U" xml-lang="en-US" oldref="72"><node id="0811" title="References"></paragraph> <paragraph role="paragraph" id="par_id3148421" l10n="U" xml-lang="en-US" oldref="73"><node id="0812" title="Viewing, Selecting, Copying"></paragraph> |