1 <?xml version=
"1.0" encoding=
"UTF-8"?>
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: 02180000.xhp,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 ************************************************************************
36 <helpdocument version=
"1.0">
38 <topic id=
"textscalc0102180000xml" indexer=
"include" status=
"PUBLISH">
39 <title id=
"tit" xml-lang=
"en-US">Move or Copy a Sheet
</title>
40 <filename>/text/scalc/
01/
02180000.xhp
</filename>
43 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
44 <lastedited date=
"2006-02-16T15:25:21">converted from old format - fpe
</lastedited>
48 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3153360"><bookmark_value>spreadsheets; moving
</bookmark_value>
49 <bookmark_value>spreadsheets; copying
</bookmark_value>
50 <bookmark_value>moving; spreadsheets
</bookmark_value>
51 <bookmark_value>copying; spreadsheets
</bookmark_value>
53 <bookmark xml-lang=
"en-US" branch=
"hid/FID_TAB_MOVE" id=
"bm_id9622978" localize=
"false"/>
54 <bookmark xml-lang=
"en-US" branch=
"hid/.uno:Move" id=
"bm_id3149657" localize=
"false"/>
55 <paragraph role=
"heading" id=
"hd_id3153360" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1">Move or Copy a Sheet
</paragraph>
56 <paragraph role=
"paragraph" id=
"par_id3154686" xml-lang=
"en-US" l10n=
"U" oldref=
"2"><variable id=
"tabelleverschiebenkopierentext"><ahelp hid=
".uno:Move">Moves or copies a sheet to a new location in the document or to a different document.
</ahelp>
57 </variable></paragraph>
58 <section id=
"howtoget">
59 <embed href=
"text/scalc/00/00000402.xhp#btaverko"/>
61 <paragraph role=
"warning" id=
"par_id2282479" xml-lang=
"en-US" l10n=
"NEW">When you copy and paste cells containing
<link href=
"text/scalc/01/04060102.xhp">date values
</link> between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!
</paragraph>
62 <bookmark xml-lang=
"en-US" branch=
"hid/SC:LISTBOX:RID_SCDLG_MOVETAB:LB_DEST" id=
"bm_id3146119" localize=
"false"/>
63 <paragraph role=
"heading" id=
"hd_id3163710" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">To Document
</paragraph>
64 <paragraph role=
"paragraph" id=
"par_id3148645" xml-lang=
"en-US" l10n=
"U" oldref=
"4"><ahelp hid=
"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_DEST">Indicates where the current sheet is to be moved or copied to.
</ahelp> Select
<emph>new document
</emph> if you want to create a new location for the sheet to be moved or copied.
</paragraph>
65 <bookmark xml-lang=
"en-US" branch=
"hid/SC:LISTBOX:RID_SCDLG_MOVETAB:LB_INSERT" id=
"bm_id3147350" localize=
"false"/>
66 <paragraph role=
"heading" id=
"hd_id3154012" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Insert Before
</paragraph>
67 <paragraph role=
"paragraph" id=
"par_id3145366" xml-lang=
"en-US" l10n=
"U" oldref=
"6"><ahelp hid=
"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_INSERT">The current sheet is moved or copied in front of the selected sheet.
</ahelp> The
<emph>move to end position
</emph> option places the current sheet at the end.
</paragraph>
68 <bookmark xml-lang=
"en-US" branch=
"hid/SC:CHECKBOX:RID_SCDLG_MOVETAB:BTN_COPY" id=
"bm_id3156283" localize=
"false"/>
69 <paragraph role=
"heading" id=
"hd_id3153726" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"7">Copy
</paragraph>
70 <paragraph role=
"paragraph" id=
"par_id3144764" xml-lang=
"en-US" l10n=
"U" oldref=
"8"><ahelp hid=
"SC:CHECKBOX:RID_SCDLG_MOVETAB:BTN_COPY">Specifies that the sheet is to be copied. If the option is unmarked, the sheet is moved.
</ahelp> Moving sheets is the default.
</paragraph>