1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <helpdocument version=
"1.0">
5 ***********************************************************************
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9 * Copyright 2008 by Sun Microsystems, Inc.
11 * OpenOffice.org - a multi-platform office productivity suite
13 * $RCSfile: soffice2xmlhelp.xsl,v $
16 * This file is part of OpenOffice.org.
18 * OpenOffice.org is free software: you can redistribute it and/or modify
19 * it under the terms of the GNU Lesser General Public License version 3
20 * only, as published by the Free Software Foundation.
22 * OpenOffice.org is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU Lesser General Public License version 3 for more details
26 * (a copy is included in the LICENSE file that accompanied this code).
28 * You should have received a copy of the GNU Lesser General Public License
29 * version 3 along with OpenOffice.org. If not, see
30 * <http://www.openoffice.org/license.html>
31 * for a copy of the LGPLv3 License.
33 ************************************************************************
38 <topic id=
"textswriterguidecalculate_intextxml" indexer=
"include" status=
"PUBLISH">
39 <title xml-lang=
"en-US" id=
"tit">Calculating Complex Formulas in Text Documents
</title>
40 <filename>/text/swriter/guide/calculate_intext.xhp
</filename>
44 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3147406"><bookmark_value>formulas; complex formulas in text
</bookmark_value>
45 <bookmark_value>calculating;formulas/mean values
</bookmark_value>
46 </bookmark><comment>mw reduced
"calculating;" entries to one entry
</comment>
47 <paragraph xml-lang=
"en-US" id=
"hd_id3147406" role=
"heading" level=
"1" l10n=
"U"
48 oldref=
"20"><variable id=
"calculate_intext"><link href=
"text/swriter/guide/calculate_intext.xhp" name=
"Calculating Complex Formulas in Text Documents">Calculating Complex Formulas in Text Documents
</link>
49 </variable></paragraph>
50 <paragraph xml-lang=
"en-US" id=
"par_id3145245" role=
"paragraph" l10n=
"U" oldref=
"25">You can use predefined functions in a formula, and then insert the result of the calculation into a text document.
</paragraph>
51 <paragraph xml-lang=
"en-US" id=
"par_id3152901" role=
"paragraph" l10n=
"U" oldref=
"26">For example, to calculate the mean value of three numbers, do the following:
</paragraph>
54 <paragraph xml-lang=
"en-US" id=
"par_id3145078" role=
"listitem" l10n=
"U" oldref=
"27">Click in the document where you want to insert the formula, and then press F2.
</paragraph>
57 <paragraph xml-lang=
"en-US" id=
"par_id3156382" role=
"listitem" l10n=
"U" oldref=
"28">Click the
<item type=
"menuitem">Formula
</item>
58 <emph/>icon, and choose
"Mean" from the Statistical Functions list.
</paragraph>
61 <paragraph xml-lang=
"en-US" id=
"par_id3149692" role=
"listitem" l10n=
"U" oldref=
"30">Type the three numbers, separated by vertical slashes (|).
</paragraph>
64 <paragraph xml-lang=
"en-US" id=
"par_id3149481" role=
"listitem" l10n=
"U" oldref=
"32">Press
<emph>Enter
</emph>. The result is inserted as a field into the document.
</paragraph>
67 <paragraph xml-lang=
"en-US" id=
"par_id3149823" role=
"paragraph" l10n=
"U" oldref=
"35">To edit the formula, double-click the field in the document.
</paragraph>
68 <embed href=
"text/shared/00/00000004.xhp#related"/>
69 <embed href=
"text/swriter/guide/calculate_intext2.xhp#calculate_intext2"/>
70 <embed href=
"text/swriter/main0214.xhp#releistename"/>
71 <embed href=
"text/swriter/guide/calculate.xhp#calculate"/>
72 <embed href=
"text/swriter/guide/calculate_clipboard.xhp#calculate_clipboard"/>
73 <embed href=
"text/swriter/guide/calculate_intable.xhp#calculate_intable"/>
74 <embed href=
"text/swriter/guide/calculate_multitable.xhp#calculate_multitable"/>