diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
11 files changed, 143 insertions, 123 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/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index 3e5ac91aa7..20082ed7dd 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.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="textscalcguidedatapilot_edittablexml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Editing DataPilot Tables</title> @@ -50,6 +50,8 @@ <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> + <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..87e7e3ab5c 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.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,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 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> +<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> +<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> +</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> +</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> +</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/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 3c821540ae..6a0b5cfff8 100755 --- a/helpcontent2/source/text/scalc/guide/multioperation.xhp +++ b/helpcontent2/source/text/scalc/guide/multioperation.xhp @@ -49,7 +49,7 @@ </variable></paragraph> <paragraph role="heading" id="hd_id3145171" xml-lang="en-US" level="2" l10n="U" oldref="1">Multiple Operations in Columns or Rows</paragraph> <paragraph role="paragraph" id="par_id4123966" xml-lang="en-US" l10n="NEW">The <item type="menuitem">Data - Multiple Operations</item> command provides a planning tool for "what if" questions. In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.</paragraph> -<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="CHG" oldref="2">In the <emph>Formula</emph> field, enter the cell reference to the formula that applies to the data range. In the <emph>Column input cell/Row input cell</emph> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</paragraph> +<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="CHG" oldref="2">In the <emph>Formulas</emph> field, enter the cell reference to the formula that applies to the data range. In the <emph>Column input cell/Row input cell</emph> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</paragraph> <paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="3" l10n="U" oldref="7">Examples</paragraph> <paragraph role="paragraph" id="par_id3153189" xml-lang="en-US" l10n="U" oldref="8">You produce toys which you sell for $10 each. Each toy costs $2 to make, in addition to which you have fixed costs of $10,000 per year. How much profit will you make in a year if you sell a particular number of toys?</paragraph> <paragraph role="paragraph" id="par_id6478774" xml-lang="en-US" l10n="NEW"> @@ -105,7 +105,7 @@ </list> <paragraph role="heading" id="hd_id3146139" xml-lang="en-US" level="2" l10n="U" oldref="3">Multiple Operations Across Rows and Columns</paragraph> <paragraph role="paragraph" id="par_id3148584" xml-lang="en-US" l10n="CHG" oldref="4"> -<item type="productname">%PRODUCTNAME</item> allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the <emph>Formula</emph> field. The <emph>Row input cell</emph> and the <emph>Column input cell</emph> fields are used to enter the reference to the corresponding cells of the formula.</paragraph> +<item type="productname">%PRODUCTNAME</item> allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the <emph>Formulas</emph> field. The <emph>Row input cell</emph> and the <emph>Column input cell</emph> fields are used to enter the reference to the corresponding cells of the formula.</paragraph> <paragraph role="heading" id="hd_id3149949" xml-lang="en-US" level="3" l10n="U" oldref="57">Calculating with Two Variables</paragraph> <paragraph role="paragraph" id="par_id3154808" xml-lang="en-US" l10n="U" oldref="58">Consider columns A and B of the sample table above. You now want to vary not just the quantity produced annually, but also the selling price, and you are interested in the profit in each case.</paragraph> <paragraph role="paragraph" id="par_id3149731" xml-lang="en-US" l10n="CHG" oldref="59">Expand the table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and 20.</paragraph> @@ -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 420f432c60..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_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/.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/rename_table.xhp b/helpcontent2/source/text/scalc/guide/rename_table.xhp index f43a5d288f..b80c07a946 100644 --- a/helpcontent2/source/text/scalc/guide/rename_table.xhp +++ b/helpcontent2/source/text/scalc/guide/rename_table.xhp @@ -51,7 +51,7 @@ <paragraph xml-lang="en-US" id="par_id3155131" role="listitem" l10n="U" oldref="12">Click the name of the sheet that you want to change.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3146976" role="listitem" l10n="U" oldref="13">Open the context menu and choose the <emph>Rename</emph> command. A dialog box appears where you can enter a new name.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146976" role="listitem" l10n="U" oldref="13">Open the context menu and choose the <emph>Rename Sheet</emph> command. A dialog box appears where you can enter a new name.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3149260" role="listitem" l10n="U" oldref="15">Enter a new name for the sheet and click <emph>OK</emph>.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/row_height.xhp b/helpcontent2/source/text/scalc/guide/row_height.xhp index 6b658b9403..f5a8a9a0e6 100644 --- a/helpcontent2/source/text/scalc/guide/row_height.xhp +++ b/helpcontent2/source/text/scalc/guide/row_height.xhp @@ -70,7 +70,7 @@ </listitem> <listitem> <paragraph role="listitem" id="par_id3166432" xml-lang="en-US" l10n="U" oldref="9">Start the context menu on the header at the left-hand side.</paragraph> -<paragraph role="listitem" id="par_id3150519" xml-lang="en-US" l10n="U" oldref="10">You will see the commands <emph>Height</emph> and <emph>Optimal row height</emph>. Choosing either opens a dialog.</paragraph> +<paragraph role="listitem" id="par_id3150519" xml-lang="en-US" l10n="U" oldref="10">You will see the commands <emph>Row Height</emph> and <emph>Optimal row height</emph>. Choosing either opens a dialog.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/text_rotate.xhp b/helpcontent2/source/text/scalc/guide/text_rotate.xhp index 65f5fc35bc..634bf62801 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 direction</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> |