diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
16 files changed, 224 insertions, 218 deletions
diff --git a/helpcontent2/source/text/scalc/guide/borders.xhp b/helpcontent2/source/text/scalc/guide/borders.xhp index f1b32ec60c..160840f2b5 100755 --- a/helpcontent2/source/text/scalc/guide/borders.xhp +++ b/helpcontent2/source/text/scalc/guide/borders.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,12 +29,12 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidebordersxhp" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">User Defined Borders in Cells </title> - <filename>text/scalc/guide/borders.xhp</filename> + <filename>/text/scalc/guide/borders.xhp</filename> </topic> </meta> <body> diff --git a/helpcontent2/source/text/scalc/guide/calculate.xhp b/helpcontent2/source/text/scalc/guide/calculate.xhp index c764a0b755..564da5d59f 100644 --- a/helpcontent2/source/text/scalc/guide/calculate.xhp +++ b/helpcontent2/source/text/scalc/guide/calculate.xhp @@ -1,11 +1,8 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - -<!-- -*********************************************************************** +<?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 @@ -27,55 +24,47 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************ - --> - - + ************************************************************************ --> + <meta> - <topic id="textscalcguidecalculatexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Calculating in Spreadsheets</title> - <filename>/text/scalc/guide/calculate.xhp</filename> - </topic> - </meta> - <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>spreadsheets; calculating</bookmark_value> - <bookmark_value>calculating; spreadsheets</bookmark_value> - <bookmark_value>formulas; calculating</bookmark_value> +<topic id="textscalcguidecalculatexml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Calculating in Spreadsheets</title> +<filename>text/scalc/guide/calculate.xhp</filename> +</topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"> +<bookmark_value>spreadsheets; calculating</bookmark_value> +<bookmark_value>calculating; spreadsheets</bookmark_value> +<bookmark_value>formulas; calculating</bookmark_value> </bookmark><comment>mw changed "formulas;..." entry</comment> -<paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1" l10n="U" - oldref="25"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp" name="Calculating in Spreadsheets">Calculating in Spreadsheets</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3146120" role="paragraph" l10n="CHG" oldref="6">The following is an example of a calculation in $[officename] Calc.</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3153951" role="listitem" l10n="CHG" oldref="7">Click in a cell, and type a number</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN10656" role="listitem" l10n="NEW">Press <item type="keycode">Enter</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_idN1065D" role="listitem" l10n="NEW">The cursor moves down to the next cell.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3155064" role="listitem" l10n="CHG" oldref="9">Enter another number.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN1066F" role="listitem" l10n="NEW">Press the <item type="keycode">Tab</item> key.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10676" role="listitem" l10n="NEW">The cursor moves to the right into the next cell.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3154253" role="listitem" l10n="CHG" oldref="10">Type in a formula, for example, <item type="literal">=A3 * A4 / 100.</item> -</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN1068B" role="listitem" l10n="NEW"> Press <item type="keycode">Enter</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3147343" role="listitem" l10n="U" oldref="20">The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.</paragraph> - <paragraph xml-lang="en-US" id="par_id3155378" role="listitem" l10n="U" oldref="12">When you edit a formula, the new result is calculated automatically.</paragraph> - </listitem> - </list> - <section id="relatedtopics"> - <embed href="text/scalc/guide/calc_date.xhp#calc_date"/> - <embed href="text/scalc/guide/calc_series.xhp#calc_series"/> - <embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> - <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> - </section> - </body> +<paragraph id="hd_id3150791" role="heading" xml-lang="en-US" level="1"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp" name="Calculating in Spreadsheets">Calculating in Spreadsheets</link></variable></paragraph> +<paragraph id="par_id3146120" role="paragraph" xml-lang="en-US">The following is an example of a calculation in $[officename] Calc.</paragraph> +<list type="ordered"> +<listitem> +<paragraph id="par_id3153951" role="listitem" xml-lang="en-US">Click in a cell, and type a number</paragraph> +</listitem> +<listitem> +<paragraph id="par_idN10656" role="listitem" xml-lang="en-US">Press Enter.</paragraph> +<paragraph id="par_idN1065D" role="listitem" xml-lang="en-US">The cursor moves down to the next cell.</paragraph> +</listitem> +<listitem> +<paragraph id="par_id3155064" role="listitem" xml-lang="en-US">Enter another number.</paragraph> +</listitem> +<listitem> +<paragraph id="par_idN1066F" role="listitem" xml-lang="en-US">Press the Tab key.</paragraph> +<paragraph id="par_idN10676" role="listitem" xml-lang="en-US">The cursor moves to the right into the next cell.</paragraph> +</listitem> +<listitem> +<paragraph id="par_id3154253" role="listitem" xml-lang="en-US">Type in a formula, for example, <item type="literal">=A3 * A4 / 100.</item></paragraph> +</listitem> +<listitem> +<paragraph id="par_idN1068B" role="listitem" xml-lang="en-US"> Press Enter.</paragraph> +<paragraph id="par_id3147343" role="listitem" xml-lang="en-US">The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.</paragraph> +<paragraph id="par_id3155378" role="listitem" xml-lang="en-US">When you edit a formula, the new result is calculated automatically.</paragraph> +</listitem> +</list> +<section id="relatedtopics"><embed href="text/scalc/guide/calc_date.xhp#calc_date"/><embed href="text/scalc/guide/calc_series.xhp#calc_series"/><embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/><embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> +</section> +</body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp index 73f47392d5..1582ea1a25 100755 --- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_protect.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,8 +29,8 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidecell_protectxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Protecting Cells from Changes</title> @@ -52,7 +52,7 @@ </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph" l10n="U" oldref="17">In <item type="productname">%PRODUCTNAME</item> Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.</paragraph> <paragraph xml-lang="en-US" id="par_id3145261" role="paragraph" l10n="U" oldref="18">Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.</paragraph> - <paragraph xml-lang="en-US" id="par_id3148576" role="paragraph" l10n="U" oldref="19">Note that the cell protection for cells with the <emph>Protected</emph> attribute is only effective when you protect the whole table. In the default condition, every cell has the <emph>Protected</emph> attribute. Therefore you must remove the attribute selectively for those cells where the user may make changes. You then protect the whole table and save the document.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148576" role="paragraph" l10n="U" oldref="19">Note that the cell protection for cells with the <emph>Protected</emph> attribute is only effective when you protect the whole sheet. In the default condition, every cell has the <emph>Protected</emph> attribute. Therefore you must remove the attribute selectively for those cells where the user may make changes. You then protect the whole sheet and save the document.</paragraph> <paragraph xml-lang="en-US" id="par_id5974303" role="warning" l10n="NEW">These protection features are just switches to prevent accidental action. The features are not intended to provide any secure protection. For example, by exporting a sheet to another file format, a user may be able to surpass the protection features. There is only one secure protection: the password that you can apply when saving an OpenDocument file. A file that has been saved with a password can be opened only with the same password.</paragraph> <list type="ordered"> <listitem> @@ -62,7 +62,8 @@ <paragraph xml-lang="en-US" id="par_id3149019" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Format - Cells</item> and click the <emph>Cell Protection</emph> tab.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3152985" role="listitem" l10n="U" oldref="9">Select the protection options that you want.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152985" role="listitem" l10n="U" oldref="9">Select the protection options that you want. All options will be applied only after you protect the sheet from the Tools menu - see below.</paragraph> + <paragraph xml-lang="en-US" id="par_id31529866655" role="listitem" l10n="NEW">Uncheck <emph>Protected</emph> to allow the user to change the currently selected cells.</paragraph> <paragraph xml-lang="en-US" id="par_id3152898" role="listitem" l10n="U" oldref="10">Select <emph>Protected</emph> to prevent changes to the contents and the format of a cell. </paragraph> <paragraph xml-lang="en-US" id="par_idN1069A" role="listitem" l10n="NEW">Select <emph>Hide formula</emph> to hide and to protect formulas from changes.</paragraph> <paragraph xml-lang="en-US" id="par_idN106A1" role="listitem" l10n="NEW">Select <emph>Hide when printing</emph> to hide protected cells in the printed document. The cells are not hidden onscreen.</paragraph> 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 3e5ac91aa7..b7486f410b 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.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,28 @@ * ************************************************************************ --> - - + + <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_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"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp index 65d2663b99..4adedbf77b 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp @@ -1,12 +1,9 @@ -<?xml version="1.0" encoding="UTF-8"?> -<helpdocument version="1.0"> - -<!-- -*********************************************************************** +<?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 * @@ -27,33 +24,54 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************ - --> - - + ************************************************************************ --> + <meta> - <topic id="textscalcguidedatapilot_filtertablexml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Filtering DataPilot 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><comment>mw deleted "filters;"</comment> -<paragraph xml-lang="en-US" id="hd_id3150792" role="heading" level="1" l10n="U" - oldref="35"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering DataPilot Tables">Filtering DataPilot Tables</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3153192" role="paragraph" l10n="U" oldref="36">You can use filters to remove unwanted data from a DataPilot table.</paragraph><comment>UFI: removed help id</comment> -<paragraph xml-lang="en-US" id="par_id3150441" role="paragraph" l10n="CHG" oldref="37">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> - <section id="relatedtopics"> - <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> - <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> - <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> - <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/> - <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/> - <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/> - <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> - </section> - </body> +<topic id="textscalcguidedatapilot_filtertablexml" indexer="include" status="PUBLISH"> +<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>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 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 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 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 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> +</listitem> +<listitem> +<paragraph id="par_id0720201001344584" role="paragraph" xml-lang="en-US">To edit the custom sort lists, open <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences +</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists.</paragraph> +</listitem> +<listitem> +<paragraph id="par_id0720201001344811" role="paragraph" xml-lang="en-US">The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner.</paragraph> +</listitem> +<listitem> +<paragraph id="par_id0720201001344884" role="paragraph" xml-lang="en-US">You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select="sys"><caseinline select="MAC">Command +</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D.</paragraph> +</listitem></list> +<section id="relatedtopics"><embed href="text/scalc/guide/datapilot.xhp#datapilot"/><embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/><embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/><embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/><embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/><embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/><embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/> +</section> +</body> </helpdocument>
\ No newline at end of file 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/guide/finding.xhp b/helpcontent2/source/text/scalc/guide/finding.xhp index d3bafa15c0..6b23d1a583 100644 --- a/helpcontent2/source/text/scalc/guide/finding.xhp +++ b/helpcontent2/source/text/scalc/guide/finding.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,12 +29,12 @@ * ************************************************************************ --> - - + + <meta> <topic id="textscalcguidefindingxhp" indexer="include"> <title id="tit" xml-lang="en-US">Finding and Replacing in Calc</title> -<filename>text/scalc/guide/finding.xhp</filename> +<filename>/text/scalc/guide/finding.xhp</filename> </topic> </meta> <body> diff --git a/helpcontent2/source/text/scalc/guide/multioperation.xhp b/helpcontent2/source/text/scalc/guide/multioperation.xhp index 107d3e3cca..6a0b5cfff8 100755 --- a/helpcontent2/source/text/scalc/guide/multioperation.xhp +++ b/helpcontent2/source/text/scalc/guide/multioperation.xhp @@ -117,7 +117,7 @@ <paragraph role="listitem" id="par_id3153620" xml-lang="en-US" l10n="U" oldref="96">Choose <emph>Data - Multiple Operations</emph>.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3149981" xml-lang="en-US" l10n="U" oldref="97">With the cursor in the <emph>Formulas </emph>field, click cell B5.</paragraph> +<paragraph role="listitem" id="par_id3149981" xml-lang="en-US" l10n="U" oldref="97">With the cursor in the <emph>Formulas</emph> field, click cell B5.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3156113" xml-lang="en-US" l10n="CHG" oldref="98">Set the cursor in the <emph>Row input cell</emph> field and click cell B1. This means that B1, the selling price, is the horizontally entered variable (with the values 8, 10, 15 and 20).</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp index 0aa8986679..927ced0d9d 100644 --- a/helpcontent2/source/text/scalc/guide/multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/multitables.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="textscalcguidemultitablesxml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Applying Multiple Sheets</title> @@ -55,23 +55,33 @@ <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph" l10n="CHG" oldref="4">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph> </listitem> </list> -<bookmark xml-lang="en-US" branch="hid/FID_TAB_SELECTALL" id="bm_id9065824" localize="false"/> + +<bookmark xml-lang="en-US" branch="hid/FID_TAB_EVENTS" id="bm_id906582498" localize="false"/><comment>Sheet Events</comment> +<paragraph xml-lang="en-US" id="par_id05092009140203598" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog box where you can assign macros to sheet events.</ahelp></paragraph> + +<bookmark xml-lang="en-US" branch="hid/FID_TAB_MENU_SET_TAB_BG_COLOR" id="bm_id906582434" localize="false"/><comment>Tab Color</comment> +<bookmark xml-lang="en-US" branch="hid/FID_TAB_SET_TAB_BG_COLOR" id="bm_id9016345434" localize="false"/> +<paragraph xml-lang="en-US" id="par_id05092009140203523" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a window where you can assign a color to the sheet tab.</ahelp></paragraph> + +<bookmark xml-lang="en-US" branch="hid/.uno:TableSelectAll" id="bm_id9065824" localize="false"/> <paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/FID_TAB_DESELECTALL" id="bm_id9065825" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/> <paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph> <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2" l10n="U" oldref="11">Selecting Multiple Sheets</paragraph> - <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command + <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>you can select multiple sheets.</paragraph> <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph" l10n="CHG">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph> <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2" l10n="U" oldref="12">Undoing a Selection</paragraph> - <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command + <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key. The sheet that is currently visible cannot be removed from the selection.</paragraph> <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2" l10n="CHG" oldref="15">Calculating Across Multiple Sheets</paragraph> <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph" l10n="CHG" oldref="16">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph> + + <section id="relatedtopics"> <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> <embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> diff --git a/helpcontent2/source/text/scalc/guide/text_rotate.xhp b/helpcontent2/source/text/scalc/guide/text_rotate.xhp index 181fa17490..6e9673f4b2 100755 --- a/helpcontent2/source/text/scalc/guide/text_rotate.xhp +++ b/helpcontent2/source/text/scalc/guide/text_rotate.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="textscalcguidetext_rotatexml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Rotating Text</title> @@ -55,7 +55,7 @@ <paragraph xml-lang="en-US" id="par_id3155854" role="listitem" l10n="U" oldref="4">Click the <emph>Alignment</emph> tab.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="U" oldref="5">In the <emph>Text orientation</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="CHG" oldref="5">In the <emph>Text orientation</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph> </listitem> </list><comment>removed a wrong para, i104207</comment> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/value_with_name.xhp b/helpcontent2/source/text/scalc/guide/value_with_name.xhp index cbc431b0f4..5cb9169e04 100755 --- a/helpcontent2/source/text/scalc/guide/value_with_name.xhp +++ b/helpcontent2/source/text/scalc/guide/value_with_name.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="textscalcguidevalue_with_namexml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Naming Cells</title> @@ -69,6 +69,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="par_id328989" role="paragraph" l10n="NEW">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph> + <paragraph xml-lang="en-US" id="par_id32898987" role="paragraph" l10n="NEW">Names must not start with the letter R followed by a number. See the ADDRESS function for more information.</paragraph> <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph" l10n="NEW">Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents.</paragraph> <paragraph xml-lang="en-US" id="hd_id1226233" role="heading" level="2" l10n="NEW">Naming cells and formulas</paragraph> <paragraph xml-lang="en-US" id="par_id5489364" role="paragraph" l10n="NEW">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph> |