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_clipboardxml" indexer=
"include" status=
"PUBLISH">
39 <title xml-lang=
"en-US" id=
"tit">Calculating and Pasting the Result of a Formula in a Text Document
</title>
40 <filename>/text/swriter/guide/calculate_clipboard.xhp
</filename>
44 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3147692"><bookmark_value>pasting;results of formulas
</bookmark_value>
45 <bookmark_value>clipboard;calculating in text
</bookmark_value>
46 <bookmark_value>formulas;pasting results in text documents
</bookmark_value>
48 <paragraph xml-lang=
"en-US" id=
"hd_id3147692" role=
"heading" level=
"1" l10n=
"U"
49 oldref=
"35"><variable id=
"calculate_clipboard"><link href=
"text/swriter/guide/calculate_clipboard.xhp" name=
" Calculating and Pasting the Result of a Formula in a Text Document"> Calculating and Pasting the Result of a Formula in a Text Document
</link>
50 </variable></paragraph>
51 <paragraph xml-lang=
"en-US" id=
"par_id3156366" role=
"paragraph" l10n=
"U" oldref=
"36">If your text already contains a formula, for example
"12+24*2", $[officename] can calculate, and then paste the result of the formula in your document, without using the
<emph>Formula Bar
</emph>.
</paragraph>
54 <paragraph xml-lang=
"en-US" id=
"par_id3154250" role=
"listitem" l10n=
"U" oldref=
"37">Select the formula in the text. The formula can only contain numbers and operators and cannot contain spaces.
</paragraph>
57 <paragraph xml-lang=
"en-US" id=
"par_id3155496" role=
"listitem" l10n=
"U" oldref=
"38">Choose
<emph>Tools - Calculate
</emph>, or press
<switchinline select=
"sys"><caseinline select=
"MAC">Command
58 </caseinline><defaultinline>Ctrl
</defaultinline></switchinline>+Plus Sign (+).
</paragraph>
61 <paragraph xml-lang=
"en-US" id=
"par_id5172582" role=
"listitem" l10n=
"NEW">Place the cursor where you want to insert the result of the formula, and then choose
<item type=
"menuitem">Edit - Paste
</item>, or press
<switchinline select=
"sys"><caseinline select=
"MAC">Command
62 </caseinline><defaultinline>Ctrl
</defaultinline></switchinline>+V.
<br/>The selected formula is replaced by the result.
</paragraph>
65 <embed href=
"text/shared/00/00000004.xhp#related"/>
66 <embed href=
"text/swriter/main0214.xhp#releistename"/>
67 <embed href=
"text/swriter/guide/calculate.xhp#calculate"/>
68 <embed href=
"text/swriter/guide/calculate_intext.xhp#calculate_intext"/>
69 <embed href=
"text/swriter/guide/calculate_intable.xhp#calculate_intable"/>
70 <embed href=
"text/swriter/guide/calculate_multitable.xhp#calculate_multitable"/>