1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3226a8927SAndrew Rist<!--*********************************************************** 4*9bb5fc98Smseidel * 5226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 6226a8927SAndrew Rist * or more contributor license agreements. See the NOTICE file 7226a8927SAndrew Rist * distributed with this work for additional information 8226a8927SAndrew Rist * regarding copyright ownership. The ASF licenses this file 9226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the 10226a8927SAndrew Rist * "License"); you may not use this file except in compliance 11226a8927SAndrew Rist * with the License. You may obtain a copy of the License at 12*9bb5fc98Smseidel * 13226a8927SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14*9bb5fc98Smseidel * 15226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing, 16226a8927SAndrew Rist * software distributed under the License is distributed on an 17226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18226a8927SAndrew Rist * KIND, either express or implied. See the License for the 19226a8927SAndrew Rist * specific language governing permissions and limitations 20226a8927SAndrew Rist * under the License. 21*9bb5fc98Smseidel * 22226a8927SAndrew Rist ***********************************************************--> 23226a8927SAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textsharedguidedragdrop_tablexml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Copying Spreadsheet Areas to Text Documents</title> 28cdf0e10cSrcweir<filename>/text/shared/guide/dragdrop_table.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3154927"><bookmark_value>spreadsheets; copying areas to text documents</bookmark_value> 33cdf0e10cSrcweir<bookmark_value>copying; sheet areas, to text documents</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>pasting;sheet areas in text documents</bookmark_value> 35cdf0e10cSrcweir</bookmark><comment>mw added "pasting;"</comment> 36cdf0e10cSrcweir<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> 37cdf0e10cSrcweir</variable></paragraph> 38cdf0e10cSrcweir<list type="ordered"> 39cdf0e10cSrcweir<listitem> 40cdf0e10cSrcweir<paragraph role="listitem" id="par_id3155892" xml-lang="en-US" l10n="U" oldref="25">Open both the text document and the spreadsheet.</paragraph> 41cdf0e10cSrcweir</listitem> 42cdf0e10cSrcweir<listitem> 43cdf0e10cSrcweir<paragraph role="listitem" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="26">Select the sheet area you want to copy.</paragraph> 44cdf0e10cSrcweir</listitem> 45cdf0e10cSrcweir<listitem> 46cdf0e10cSrcweir<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> 47cdf0e10cSrcweir<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. 48cdf0e10cSrcweir</caseinline></switchinline></paragraph> 49cdf0e10cSrcweir</listitem> 50cdf0e10cSrcweir<listitem> 51cdf0e10cSrcweir<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> 52cdf0e10cSrcweir</listitem> 53cdf0e10cSrcweir<listitem> 54cdf0e10cSrcweir<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> 55cdf0e10cSrcweir</listitem> 56cdf0e10cSrcweir<listitem> 57cdf0e10cSrcweir<paragraph role="listitem" id="par_id3149164" xml-lang="en-US" l10n="U" oldref="30">To edit the OLE object, double-click on it.</paragraph> 58cdf0e10cSrcweir<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> 59cdf0e10cSrcweir</listitem> 60cdf0e10cSrcweir<listitem> 61cdf0e10cSrcweir<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> 62cdf0e10cSrcweir</listitem> 63cdf0e10cSrcweir</list> 64cdf0e10cSrcweir<embed href="text/shared/00/00000004.xhp#related"/> 65cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> 66cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/> 67cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/> 68cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_gallery.xhp#dragdrop_gallery"/> 69cdf0e10cSrcweir<switch select="appl"> 70cdf0e10cSrcweir<case select="WRITER"><embed href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/> 71cdf0e10cSrcweir</case> 72cdf0e10cSrcweir</switch> 73cdf0e10cSrcweir</body> 74cdf0e10cSrcweir</helpdocument> 75