diff options
| author | Ivo Hinkelmann <ihi@openoffice.org> | 2006-06-29 08:57:06 +0000 |
|---|---|---|
| committer | Ivo Hinkelmann <ihi@openoffice.org> | 2006-06-29 08:57:06 +0000 |
| commit | ce003d1b51e1e417426845fdfb14559733a11973 (patch) | |
| tree | eb184dd5f205d855730d4900754120d84ecd8fb0 | |
| parent | 35ca63d945704efbba42498c245adecccb14205d (diff) | |
INTEGRATION: CWS hcscalc01 (1.4.70); FILE MERGED
2006/02/15 09:49:53 ufi 1.4.70.1: 15.2.
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/relativ_absolut_ref.xhp | 15 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/value_with_name.xhp | 35 |
2 files changed, 30 insertions, 20 deletions
diff --git a/helpcontent2/source/text/scalc/guide/relativ_absolut_ref.xhp b/helpcontent2/source/text/scalc/guide/relativ_absolut_ref.xhp index 6de33c45b1..697a8990f1 100644 --- a/helpcontent2/source/text/scalc/guide/relativ_absolut_ref.xhp +++ b/helpcontent2/source/text/scalc/guide/relativ_absolut_ref.xhp @@ -1,13 +1,14 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: relativ_absolut_ref.xhp,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:45:24 $ + * last change: $Author: ihi $ $Date: 2006-06-29 09:55:43 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,7 +33,8 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> + ************************************************************************ + --> <helpdocument version="1.0"> <meta> @@ -42,7 +44,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-10-11T09:19:47">converted from old format - fpe</lastedited> +<lastedited date="2006-02-14T11:46:48">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -70,8 +72,7 @@ <paragraph role="paragraph" id="par_id3145791" xml-lang="en-US" l10n="U" oldref="39">Absolute references are used when a calculation refers to one specific cell in your sheet. If a formula that refers to exactly this cell is copied relatively to a cell below the original cell, the reference will also be moved down if you did not define the cell coordinates as absolute.</paragraph> <paragraph role="paragraph" id="par_id3147005" xml-lang="en-US" l10n="U" oldref="10">Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9).</paragraph> <section id="relatedtopics"> -<embed href="text/scalc/guide/address_byname.xhp#address_byname"/> -<embed href="text/scalc/guide/address_auto.xhp#address_auto"/> +<embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/><comment>mw changed link target from "address_byname" to "value_with_name"</comment><embed href="text/scalc/guide/address_auto.xhp#address_auto"/> </section> </body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/guide/value_with_name.xhp b/helpcontent2/source/text/scalc/guide/value_with_name.xhp index 5bdcef3cbe..1c3afdc9ac 100755 --- a/helpcontent2/source/text/scalc/guide/value_with_name.xhp +++ b/helpcontent2/source/text/scalc/guide/value_with_name.xhp @@ -1,13 +1,14 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: value_with_name.xhp,v $ * - * $Revision: 1.4 $ + * $Revision: 1.5 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:49:04 $ + * last change: $Author: ihi $ $Date: 2006-06-29 09:57:06 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,7 +33,8 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> + ************************************************************************ + --> <helpdocument version="1.0"> <meta> @@ -42,23 +44,27 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-08-10T10:43:53">converted from old format - fpe</lastedited> +<lastedited date="2006-02-14T12:54:05">converted from old format - fpe</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147434"><bookmark_value>cells; defining names</bookmark_value> -<bookmark_value>names; for cells</bookmark_value> +<bookmark_value>names; defining for cells</bookmark_value> <bookmark_value>values; defining names</bookmark_value> <bookmark_value>constants definition</bookmark_value> <bookmark_value>variables; defining names</bookmark_value> <bookmark_value>cell ranges; defining names</bookmark_value> -<bookmark_value>defining names; cell ranges</bookmark_value> +<bookmark_value>defining;names for cell ranges</bookmark_value> <bookmark_value>formulas; defining names</bookmark_value> -<bookmark_value>cell names;in formulas</bookmark_value> -</bookmark> +<bookmark_value>addressing; by defined names</bookmark_value> +<bookmark_value>cell names; defining/addressing</bookmark_value> +<bookmark_value>references; by defined names</bookmark_value> +</bookmark><comment>mw changed index entry "defining;..."</comment><comment>mw copied three index entries from Calc guide address_byname, deleted "cell names;in formulas" and changed the remaining "cell names;..."entry.</comment><comment>mw changed "names;...", "addressing;..." and "references,..." entries.</comment> <paragraph role="heading" id="hd_id3147434" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp" name="Naming Cells">Naming Cells</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3155855" xml-lang="en-US" l10n="U" oldref="2">$[officename] Calc lets you assign names to cell ranges. </paragraph> +<paragraph role="paragraph" id="par_id5489364" xml-lang="en-US" 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> +<paragraph role="paragraph" id="par_id953398" xml-lang="en-US" l10n="NEW">For example, it is much easier to read a formula for sales tax if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate."</paragraph> +<paragraph role="paragraph" id="par_id4889675" xml-lang="en-US" l10n="NEW">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph> <list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3153954" xml-lang="en-US" l10n="U" oldref="3">Select a cell or range of cells, then choose <emph>Insert - Names - Define</emph>. The <emph>Define Names</emph> dialog appears.</paragraph> @@ -67,18 +73,21 @@ <paragraph role="listitem" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="4">Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog.</paragraph> </listitem> </list> +<paragraph role="paragraph" id="par_id5774101" xml-lang="en-US" l10n="NEW">You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells.</paragraph> <paragraph role="paragraph" id="par_id3154942" xml-lang="en-US" l10n="U" oldref="5">If you type the name in a formula, after the first few characters entered you will see the entire name as a tip.</paragraph> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3154510" xml-lang="en-US" l10n="U" oldref="6">Press the Enter key in order to accept the name from the tip.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="7">If more than one name starts with the same characters, you can scroll through all the names using the Tab key.</paragraph> +<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="7">If more than one name starts with the same characters, you can scroll through all the names using the Tab key.<comment>mw copied contents from Calc guide address_byname.xhp</comment></paragraph> </listitem> </list> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id3153711" xml-lang="en-US" l10n="U" oldref="8"><link href="text/scalc/01/04070100.xhp" name="Insert - Names - Define">Insert - Names - Define</link></paragraph> <embed href="text/scalc/guide/goalseek.xhp#goalseek"/> -<paragraph role="paragraph" id="par_idN1076C" xml-lang="en-US" l10n="NEW"><link href="text/scalc/guide/address_byname.xhp">Addressing by Name</link></paragraph> -</section></body> +<embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> +<embed href="text/scalc/guide/address_auto.xhp#address_auto"/><comment>mw deleted one EMBED paragraph and copied two EMBED paragraphs from Calc guide address_byname.xhp</comment> +</section> +</body> </helpdocument> |