1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4*226a8927SAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*226a8927SAndrew Rist * or more contributor license agreements. See the NOTICE file 8*226a8927SAndrew Rist * distributed with this work for additional information 9*226a8927SAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the 11*226a8927SAndrew Rist * "License"); you may not use this file except in compliance 12*226a8927SAndrew Rist * with the License. You may obtain a copy of the License at 13*226a8927SAndrew Rist * 14*226a8927SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*226a8927SAndrew Rist * 16*226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing, 17*226a8927SAndrew Rist * software distributed under the License is distributed on an 18*226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*226a8927SAndrew Rist * KIND, either express or implied. See the License for the 20*226a8927SAndrew Rist * specific language governing permissions and limitations 21*226a8927SAndrew Rist * under the License. 22*226a8927SAndrew Rist * 23*226a8927SAndrew Rist ***********************************************************--> 24*226a8927SAndrew Rist 25*226a8927SAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir<helpdocument version="1.0"> 29cdf0e10cSrcweir<meta> 30cdf0e10cSrcweir<topic id="textsharedguidedragdrop_beamerxml" indexer="include" status="PUBLISH"> 31cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Drag-and-Drop With the Data Source View</title> 32cdf0e10cSrcweir<filename>/text/shared/guide/dragdrop_beamer.xhp</filename> 33cdf0e10cSrcweir</topic> 34cdf0e10cSrcweir<history> 35cdf0e10cSrcweir<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 36cdf0e10cSrcweir<lastedited date="2006-04-18T13:20:21">converted from old format - fpe</lastedited> 37cdf0e10cSrcweir</history> 38cdf0e10cSrcweir</meta> 39cdf0e10cSrcweir<body> 40cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3145071"><bookmark_value>drag and drop; data source view</bookmark_value> 41cdf0e10cSrcweir<bookmark_value>data source view; drag and drop</bookmark_value> 42cdf0e10cSrcweir<bookmark_value>copying;from data source view</bookmark_value> 43cdf0e10cSrcweir<bookmark_value>pasting;from data source view</bookmark_value> 44cdf0e10cSrcweir</bookmark><comment>mw added "pasting;"</comment> 45cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145071" xml-lang="en-US" level="1" l10n="U" oldref="10"><variable id="dragdrop_beamer"><link href="text/shared/guide/dragdrop_beamer.xhp" name="Drag-and-Drop With the Data Source View">Drag-and-Drop With the Data Source View</link> 46cdf0e10cSrcweir</variable></paragraph> 47cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151111" xml-lang="en-US" l10n="U" oldref="34">A fast way of copying from a data source into a text or spreadsheet document, or of creating forms based on a data source, is by drag-and-drop.</paragraph> 48cdf0e10cSrcweir<table id="tbl_id3149578"> 49cdf0e10cSrcweir<tablerow> 50cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 51cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3147335" xml-lang="en-US" l10n="E"> 52cdf0e10cSrcweir<image id="img_id3155390" src="res/helpimg/copydata.png" width="8.47mm" height="8.47mm"><alt id="alt_id3155390" xml-lang="en-US">Mouse pointer copying data</alt> 53cdf0e10cSrcweir </image></paragraph> 54cdf0e10cSrcweir</tablecell> 55cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 56cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="35">Copying with Drag-and-Drop</paragraph> 57cdf0e10cSrcweir</tablecell> 58cdf0e10cSrcweir</tablerow> 59cdf0e10cSrcweir</table> 60cdf0e10cSrcweir 61cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149233" xml-lang="en-US" l10n="U" oldref="28">If you want to reverse a drag-and-drop, position the cursor in your document and choose <emph>Edit - Undo</emph>.</paragraph> 62cdf0e10cSrcweir<paragraph role="tip" id="par_id3149656" xml-lang="en-US" l10n="U" oldref="46">It is also possible to copy by drag-and-drop from a document into a data source:</paragraph> 63cdf0e10cSrcweir<paragraph role="tip" id="par_id3153379" xml-lang="en-US" l10n="U" oldref="47">A text table or the selected range of a spreadsheet can be dragged using drag-and-drop to a table container in the data source explorer.</paragraph> 64cdf0e10cSrcweir<paragraph role="tip" id="par_id3151211" xml-lang="en-US" l10n="U" oldref="48">Plain text can be copied using drag-and-drop from one document to a data field in the data source view.</paragraph> 65cdf0e10cSrcweir<paragraph role="heading" id="hd_id3145421" xml-lang="en-US" level="3" l10n="U" oldref="36">Using data in a text document</paragraph> 66cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="U" oldref="12">You can insert a database field in a text document by dragging a field name from the column header of the data source view into the document. This is especially useful when designing form letters. Simply drag the desired fields - home address, form of address, and so on - into your document.</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153105" xml-lang="en-US" l10n="U" oldref="37">To insert a complete record, select the corresponding header and drag it into the document. When you release the mouse button, the <link href="text/shared/02/12070000.xhp" name="Insert database columns"><emph>Insert database columns</emph></link> dialog appears, in which you can decide whether to use all database fields, and whether to copy the data into the document as text, a table or fields. All currently selected records will be inserted.</paragraph> 68cdf0e10cSrcweir<paragraph role="heading" id="hd_id3147230" xml-lang="en-US" level="3" l10n="U" oldref="39">Applying data to a table document</paragraph> 69cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="40">You can insert one or more records into the current sheet of a spreadsheet by selecting the rows in the data source view and dragging and dropping them into the spreadsheet. The data is inserted at the place where you release the mouse button.</paragraph> 70cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149766" xml-lang="en-US" level="3" l10n="U" oldref="42">Inserting controls in a text form</paragraph> 71cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US" l10n="U" oldref="43">When you create a text form linked to a database, you can generate controls by drag-and-drop from the data source view.</paragraph> 72cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149562" xml-lang="en-US" l10n="U" oldref="45">When you drag a database column into the text document, you insert a field. If you hold down Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while dragging, a text field is inserted, grouped with an appropriate label field. The text field already contains all the database information that you need for the form.</paragraph> 73cdf0e10cSrcweir<embed href="text/shared/00/00000004.xhp#related"/> 74cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> 75cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/> 76cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_table.xhp#dragdrop_table"/> 77cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/> 78cdf0e10cSrcweir<embed href="text/shared/guide/dragdrop_gallery.xhp#dragdrop_gallery"/> 79cdf0e10cSrcweir<switch select="appl"> 80cdf0e10cSrcweir<case select="WRITER"><embed href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/> 81cdf0e10cSrcweir</case> 82cdf0e10cSrcweir</switch> 83cdf0e10cSrcweir</body> 84cdf0e10cSrcweir</helpdocument> 85