helpcontent2/source/text/scalc/guide/formula_copy.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4 <!--
   5  ***********************************************************************
   6  *
   7  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   8  *
   9  * Copyright 2008 by Sun Microsystems, Inc.
  10  *
  11  * OpenOffice.org - a multi-platform office productivity suite
  12  *
  13  * $RCSfile: formula_copy.xhp,v $
  14  * $Revision: 1.6.4.1 $
  15  *
  16  * This file is part of OpenOffice.org.
  17  *
  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.
  21  *
  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).
  27  *
  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.
  32  *
  33  ************************************************************************
  34  -->
  35
  36 <helpdocument version="1.0">
  37 <meta>
  38 <topic id="textscalcguideformula_copyxml" indexer="include" status="PUBLISH">
  39 <title id="tit" xml-lang="en-US">Copying Formulas</title>
  40 <filename>/text/scalc/guide/formula_copy.xhp</filename>
  41 </topic>
  42 <history>
  43 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
  44 <lastedited date="2006-04-18T14:55:39">converted from old format - fpe</lastedited>
  45 </history>
  46 </meta>
  47 <body>
  48 <bookmark xml-lang="en-US" branch="index" id="bm_id3151113"><bookmark_value>formulas; copying and pasting</bookmark_value>
  49 <bookmark_value>copying; formulas</bookmark_value>
  50 <bookmark_value>pasting;formulas</bookmark_value>
  51 </bookmark><comment>mw added "pasting;" and changed "formulas;"</comment>
  52 <paragraph role="heading" id="hd_id3151113" xml-lang="en-US" level="1" l10n="U" oldref="54"><variable id="formula_copy"><link href="text/scalc/guide/formula_copy.xhp" name="Copying Formulas">Copying Formulas</link>
  53 </variable></paragraph>
  54 <section id="copytext">
  55 <paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="U" oldref="11">There are various ways to copy a formula. One suggested method is:</paragraph>
  56 <list type="ordered">
  57 <listitem>
  58 <paragraph role="listitem" id="par_id3150439" xml-lang="en-US" l10n="U" oldref="30">Select the cell containing the formula.</paragraph>
  59 </listitem>
  60 <listitem>
  61 <paragraph role="listitem" id="par_id3154319" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Edit - Copy</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C to copy it.</paragraph>
  62 </listitem>
  63 <listitem>
  64 <paragraph role="listitem" id="par_id3159155" xml-lang="en-US" l10n="U" oldref="32">Select the cell into which you want the formula to be copied.</paragraph>
  65 </listitem>
  66 <listitem>
  67 <paragraph role="listitem" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="33">Choose <emph>Edit - Paste</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V. The formula will be positioned in the new cell.</paragraph>
  68 </listitem>
  69 </list>
  70 <paragraph role="paragraph" id="par_id3149961" xml-lang="en-US" l10n="U" oldref="34">If you want to copy a formula into multiple cells, there is a quick and easy way to copy into adjacent cell areas:</paragraph>
  71 <list type="ordered">
  72 <listitem>
  73 <paragraph role="listitem" id="par_id3149400" xml-lang="en-US" l10n="U" oldref="12">Select the cell containing the formula.</paragraph>
  74 </listitem>
  75 <listitem>
  76 <paragraph role="listitem" id="par_id3154018" xml-lang="en-US" l10n="U" oldref="13">Position the mouse on the bottom right of the highlighted border of the cell, and continue holding down the mouse button until the pointer changes to a cross-hair symbol.</paragraph>
  77 </listitem>
  78 <listitem>
  79 <paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="14">With the mouse button pressed, drag it down or to the right over all the cells into which you want to copy the formula.</paragraph>
  80 </listitem>
  81 <listitem>
  82 <paragraph role="listitem" id="par_id3153714" xml-lang="en-US" l10n="U" oldref="15">When you release the mouse button, the formula will be copied into the cells and automatically adjusted.</paragraph>
  83 </listitem>
  84 </list>
  85 <paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" l10n="U" oldref="53">If you do not want values and texts to be automatically adjusted, then hold down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key when dragging. Formulas, however, are always adjusted accordingly.</paragraph>
  86 </section>
  87 <section id="relatedtopics">
  88 <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/>
  89 </section>
  90 </body>
  91 </helpdocument>