diff options
| author | Kurt Zenker <kz@openoffice.org> | 2005-10-05 11:14:56 +0000 |
|---|---|---|
| committer | Kurt Zenker <kz@openoffice.org> | 2005-10-05 11:14:56 +0000 |
| commit | c01f7e44fa2d726d04d501c074ac67f605a78497 (patch) | |
| tree | dcde6dd0657a03a90f07a4681dc4ec30f489f7b8 /helpcontent2/source/text/scalc/guide/formula_enter.xhp | |
| parent | INTEGRATION: CWS hc680pp1 (1.4.34); FILE MERGED (diff) | |
| download | help-c01f7e44fa2d726d04d501c074ac67f605a78497.tar.gz help-c01f7e44fa2d726d04d501c074ac67f605a78497.zip | |
INTEGRATION: CWS hc680pp1 (1.2.44); FILE MERGED
2005/09/30 16:33:06 ufi 1.2.44.2: RESYNC: (1.2-1.3); FILE MERGED
2005/08/12 12:34:30 ufi 1.2.44.1: comment
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/formula_enter.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/formula_enter.xhp | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/helpcontent2/source/text/scalc/guide/formula_enter.xhp b/helpcontent2/source/text/scalc/guide/formula_enter.xhp index b122939ab5..6bb67fd8e6 100644 --- a/helpcontent2/source/text/scalc/guide/formula_enter.xhp +++ b/helpcontent2/source/text/scalc/guide/formula_enter.xhp @@ -5,9 +5,9 @@ * * $RCSfile: formula_enter.xhp,v $ * - * $Revision: 1.3 $ + * $Revision: 1.4 $ * - * last change: $Author: rt $ $Date: 2005-09-07 18:37:35 $ + * last change: $Author: kz $ $Date: 2005-10-05 12:14:56 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -42,13 +42,14 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-08-10T11:33:10">converted from old format - fpe</lastedited> +<lastedited date="2005-08-09T11:51:09">converted from old format - fpe</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150868"><bookmark_value>formula bar; input line</bookmark_value> <bookmark_value>input line in formula bar</bookmark_value> <bookmark_value>formulas; inputting</bookmark_value> +<bookmark_value>inserting;formulas</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3150868" xml-lang="en-US" level="1" l10n="U" oldref="9"><variable id="formula_enter"><link href="text/scalc/guide/formula_enter.xhp" name="Entering Formulas in the Formula Bar">Entering Formulas in the Formula Bar</link> </variable></paragraph> @@ -66,11 +67,12 @@ </list> <paragraph role="paragraph" id="par_id3147394" xml-lang="en-US" l10n="U" oldref="8">You can also enter the values and the formulas directly into the cells, even if you cannot see an input cursor. Formulas must always begin with an equals sign.</paragraph> <paragraph role="note" id="par_id3155764" xml-lang="en-US" l10n="U" oldref="6">If you are editing a formula with references, the references and the associated cells will be highlighted with the same color. You can now resize the reference border using the mouse, and the reference in the formula displayed in the input line also changes. <emph>Show references in color </emph>can be deactivated under <link href="text/shared/optionen/01060300.xhp" name="Tools - Options - Spreadsheet - View">Tools - Options - %PRODUCTNAME Calc - View</link>.</paragraph> -<paragraph role="tip" id="par_id3149210" xml-lang="en-US" l10n="U" oldref="7"><variable id="tip">If you would like to view the calculation of individual elements of a formula, select the respective elements and press F9. For example, in the formula =SUM(A1:B12)*SUM(C1:D12) select the section SUM(C1:D12) and press F9 to view the subtotal for this area. +<paragraph role="tip" id="par_id3149210" xml-lang="en-US" l10n="U" oldref="7"><variable id="tip">If you would like to view the calculation of individual elements of a formula, select the respective elements and press F9. For example, in the formula =SUM(A1:B12)*SUM(C1:D12) select the section SUM(C1:D12) and press F9 to view the subtotal for this area. </variable></paragraph> <paragraph role="paragraph" id="par_id3150304" xml-lang="en-US" l10n="U" oldref="5">If an error occurs when creating the formula, an <link href="text/scalc/05/02140000.xhp" name="error message">error message</link> appears in the active cell.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/formulas.xhp#formulas"/> <paragraph role="paragraph" id="par_id3152993" xml-lang="en-US" l10n="U" oldref="13"><link href="text/scalc/main0206.xhp" name="Formula bar">Formula bar</link></paragraph> -</section></body> +</section> +</body> </helpdocument> |