diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
4 files changed, 10 insertions, 10 deletions
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/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"> |