1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 29*b1cdbd2cSJim Jagielski<meta> 30*b1cdbd2cSJim Jagielski<topic id="textsharedguidedragdrop_beamerxml" indexer="include" status="PUBLISH"> 31*b1cdbd2cSJim Jagielski<title id="tit" xml-lang="en-US">Drag-and-Drop With the Data Source View</title> 32*b1cdbd2cSJim Jagielski<filename>/text/shared/guide/dragdrop_beamer.xhp</filename> 33*b1cdbd2cSJim Jagielski</topic> 34*b1cdbd2cSJim Jagielski<history> 35*b1cdbd2cSJim Jagielski<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 36*b1cdbd2cSJim Jagielski<lastedited date="2006-04-18T13:20:21">converted from old format - fpe</lastedited> 37*b1cdbd2cSJim Jagielski</history> 38*b1cdbd2cSJim Jagielski</meta> 39*b1cdbd2cSJim Jagielski<body> 40*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3145071"><bookmark_value>drag and drop; data source view</bookmark_value> 41*b1cdbd2cSJim Jagielski<bookmark_value>data source view; drag and drop</bookmark_value> 42*b1cdbd2cSJim Jagielski<bookmark_value>copying;from data source view</bookmark_value> 43*b1cdbd2cSJim Jagielski<bookmark_value>pasting;from data source view</bookmark_value> 44*b1cdbd2cSJim Jagielski</bookmark><comment>mw added "pasting;"</comment> 45*b1cdbd2cSJim Jagielski<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> 46*b1cdbd2cSJim Jagielski</variable></paragraph> 47*b1cdbd2cSJim Jagielski<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> 48*b1cdbd2cSJim Jagielski<table id="tbl_id3149578"> 49*b1cdbd2cSJim Jagielski<tablerow> 50*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 51*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3147335" xml-lang="en-US" l10n="E"> 52*b1cdbd2cSJim Jagielski<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> 53*b1cdbd2cSJim Jagielski </image></paragraph> 54*b1cdbd2cSJim Jagielski</tablecell> 55*b1cdbd2cSJim Jagielski<tablecell colspan="" rowspan=""> 56*b1cdbd2cSJim Jagielski<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="35">Copying with Drag-and-Drop</paragraph> 57*b1cdbd2cSJim Jagielski</tablecell> 58*b1cdbd2cSJim Jagielski</tablerow> 59*b1cdbd2cSJim Jagielski</table> 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski<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> 62*b1cdbd2cSJim Jagielski<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> 63*b1cdbd2cSJim Jagielski<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> 64*b1cdbd2cSJim Jagielski<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> 65*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3145421" xml-lang="en-US" level="3" l10n="U" oldref="36">Using data in a text document</paragraph> 66*b1cdbd2cSJim Jagielski<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> 67*b1cdbd2cSJim Jagielski<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> 68*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3147230" xml-lang="en-US" level="3" l10n="U" oldref="39">Applying data to a table document</paragraph> 69*b1cdbd2cSJim Jagielski<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> 70*b1cdbd2cSJim Jagielski<paragraph role="heading" id="hd_id3149766" xml-lang="en-US" level="3" l10n="U" oldref="42">Inserting controls in a text form</paragraph> 71*b1cdbd2cSJim Jagielski<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> 72*b1cdbd2cSJim Jagielski<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> 73*b1cdbd2cSJim Jagielski<embed href="text/shared/00/00000004.xhp#related"/> 74*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> 75*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop_graphic.xhp#dragdrop_graphic"/> 76*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop_table.xhp#dragdrop_table"/> 77*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop_fromgallery.xhp#dragdrop_fromgallery"/> 78*b1cdbd2cSJim Jagielski<embed href="text/shared/guide/dragdrop_gallery.xhp#dragdrop_gallery"/> 79*b1cdbd2cSJim Jagielski<switch select="appl"> 80*b1cdbd2cSJim Jagielski<case select="WRITER"><embed href="text/swriter/guide/dragdroptext.xhp#dragdroptext"/> 81*b1cdbd2cSJim Jagielski</case> 82*b1cdbd2cSJim Jagielski</switch> 83*b1cdbd2cSJim Jagielski</body> 84*b1cdbd2cSJim Jagielski</helpdocument> 85
