1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2000, 2010 Oracle and/or its affiliates.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedguidedragdrop_tablexml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Copying Spreadsheet Areas to Text Documents</title>
<filename>/text/shared/guide/dragdrop_table.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2006-04-18T13:28:27">converted from old format - fpe</lastedited>
</history>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154927"><bookmark_value>spreadsheets; copying areas to text documents</bookmark_value>
<bookmark_value>copying; sheet areas, to text documents</bookmark_value>
<bookmark_value>pasting;sheet areas in text documents</bookmark_value>
</bookmark><comment>mw added "pasting;"</comment>
<paragraph role="heading" id="hd_id3154927" xml-lang="en-US" level="1" l10n="U" oldref="24"><variable id="dragdrop_table"><link href="text/shared/guide/dragdrop_table.xhp" name="Copying Spreadsheet Areas to Text Documents">Copying Spreadsheet Areas to Text Documents</link>
</variable></paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3155892" xml-lang="en-US" l10n="U" oldref="25">Open both the text document and the spreadsheet.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="26">Select the sheet area you want to copy.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3149827" xml-lang="en-US" l10n="U" oldref="27">Point to the selected area and press the mouse button. Keep the mouse button pressed for a moment, then drag the area into the text document.</paragraph>
<paragraph role="listitem" id="par_id3152780" xml-lang="en-US" l10n="U" oldref="32"><switchinline select="sys"><caseinline select="WIN">If the documents are not visible next to each other, first drag the mouse pointer to the destination document button. Continue to hold down the mouse button. The document is displayed, and you can move the mouse pointer within the document.
</caseinline></switchinline></paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3156346" xml-lang="en-US" l10n="U" oldref="28">Once the cursor is located in the place where you want to insert the sheet area, release the mouse button. The sheet area is inserted as an OLE object.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3154047" xml-lang="en-US" l10n="U" oldref="29">You can select and edit the OLE object at any time.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3149164" xml-lang="en-US" l10n="U" oldref="30">To edit the OLE object, double-click on it.</paragraph>
<paragraph role="listitem" id="par_id3155389" xml-lang="en-US" l10n="U" oldref="33">Alternatively, select the object and choose <emph>Edit - Object - Edit</emph> or choose <emph>Edit</emph> from the context menu. You edit the object in its own frame within the text document, but you see the icons and menu commands needed for spreadsheets.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3154860" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Open</emph> to open the source document of the OLE object.</paragraph>
</listitem>
</list>
<embed href="text/shared/00/00000004.xhp#related"/>
<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/>
<embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/>
<embed href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/>
<embed href="text/shared/guide/dragdrop_gallery.xhp#dragdrop_gallery"/>
<switch select="appl">
<case select="WRITER"><embed href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/>
</case>
</switch>
</body>
</helpdocument>
|
