In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (R N D Martin) wrote:
> *From:* [EMAIL PROTECTED] (R N D Martin) > *To:* users@openoffice.org > *Date:* Wed, 16 Apr 2008 14:11 +0100 (BST) > > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] (R N D Martin) wrote: > > > *From:* [EMAIL PROTECTED] (R N D Martin) > > *To:* users@openoffice.org > > *Date:* Tue, 15 Apr 2008 18:02 +0100 (BST) > > > > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > > (Ahromi > > Irawan) wrote: > > > > > *From:* Ahromi Irawan <[EMAIL PROTECTED]> > > > *To:* users@openoffice.org > > > *Date:* Tue, 15 Apr 2008 10:00:11 +0700 > > > > > > Pada Tanggal 04/14/2008 09:26 PM, R N D Martin Menulis: > > > > In Lotus I am used to creating a table and then using cop and > > > > paste to > > > > batch paste direct to the cells in the table, but in OO I > > seem > > to have > > > > to paste special into the document as text, and then turn > > what > I > have > > > > pasted into a table. I find this rather long winded and > > > awkward. > Have I > > > > missed something? > > > > > > > > Niall Martin > > > > > > > Edit | Paste Special | Formatted Text > > > > > > HTH > > > > > > -- > > > Ahromi Irawan > > > Cirebon > > > > > Thanks. I'll try that again, but my memory is that it pasted an > > image > > of the bit of the spreadsheet rather than distributing the items > > over > > the fields. > > > > Niall Martin > > > I repeated the operation, and found it pasted everything in column > 1 of > the table I created, definitely not what I wanted. > > Niall Martin > I've had some off list correspondence with Barbara Duprey which I'm pasting below, as it seems to add something to the discussion. her second last sentence seems to enlighten. Niall Martin Thanks, Niall. Yes, it does, and I think we may be getting closer here. If you click *below* the table you're working with (I generally add an empty paragraph before my paste point), rather than inside the table, then do the Paste Special for formatted text, you should get an independent table that looks pretty much like what you had in Calc. If you want to append the data from that copy to your existing, nicely formatted table, just add an empty row at the bottom of the formatted one. Then click somewhere in the copied table, Table > Select > Table, and Ctrl-C. Now you have all your spreadsheet data in a good form for normal pasting. Click in the first cell (or whichever one is to be the top left of the appended data) of the empty new row of the formatted table, then Ctrl-V. Your data should populate the formatted table in the appropriate columns, adding all the rows it needs. Now you can delete the copied temporary table. That should do it, I hope, though you may have to do a little more to get the copied data to match the existing table's format. I do a very similar thing getting data from Base tables and queries into Writer tables. Unfortunately, the clipboard formats for Writer, Calc, and Base seem to be incompatible without the intermediate step. (By the way, let's keep all this on the list so others can help, too.) Niall Martin wrote: > Thanks for your message.. Initially I created my table, then did > paste special on to it. No go. I then explored the other options. > DDE seemed to give the wrong answer. Paste special taking the > formatted text option put everything in a single column of the table, > instead of distributing the items in the appropriate columns. What > succeeded was paste special, taking the unformatted text option, > highlighting the pasted text, followed by table/convert to table. It > does seem a roundabout way of doing things, particularly if having set > up the table you then want to add more data to it. I hope this > clarifies the process. > > > > On 16 Apr 2008 at 14:20, Barbara Duprey wrote: > > Date sent: Wed, 16 Apr 2008 14:20:01 -0500 > From: Barbara Duprey <[EMAIL PROTECTED]> > To: users@openoffice.org, > [EMAIL PROTECTED] > *Subject: * *Re: [users] Re: Spreadsheet to > word processor table* > > R N D Martin wrote: > > In article <[EMAIL PROTECTED]>, > > [EMAIL PROTECTED] (Brian Barker) wrote: > > > > > >> *From:* Brian Barker <[EMAIL PROTECTED]> > >> *To:* users@openoffice.org > >> *Date:* Tue, 15 Apr 2008 22:55:54 +0100 > >> > >> At 15:26 14/04/2008 +0100, Niall Martin wrote: > >> > >>> In Lotus I am used to creating a table and then using copy and > >>> > >> paste >to batch paste direct to the cells in the table, but in OO I > >> seem to >have to paste special into the document as text, and then > >> turn what >I have pasted into a table. I find this rather long > >> winded and >awkward. Have I missed something? > >> > >> Possibly. I think that, in Writer, this is even easier than you > >> hope. Don't create any table first. Instead, copy the cells from > >> your spreadsheet and then use Edit | Paste Special... (or > >> Ctrl+Shift+V), selecting "DDE link" from the options. This creates > >> a table with your imported values, which you can then format as you > >> require. > >> > >> Note that this technique actually creates a link to the source > >> spreadsheet instead of a copy - so the spreadsheet file must > >> continue to be available and any subsequent change to it will be > >> reflected in your Writer document. If this is not what you need, > >> after you have pasted the link, go to Edit | Links..., select the > >> relevant link in the list, and press Break Link. You will now have > >> an independent text document. > >> > >> I trust this helps. > >> > >> Brian Barker > >> > >> > > I did experiment briefly with the DDE option, but abandoned it at > > once, since it did not seem to be doing what I wanted. Your second > > paragraph I regard as a workaround which I will try some time, but > > still regard as rather clumsy. Thanks for your comment. > > > > Niall Martin > Niall, have you done the Paste Special as formatted test? That seems > to preserve more of the formatting than the DDE link, whether later > broken or not. You should end up with a table immediately after doing > the Paste Special that comes pretty close to what you had in Calc. > When you say "turn what I have pasted into a table" what kind of steps > are you going through? Maybe we can help with that part. > > Niall Martin > Phone 0131 4678468 > Please reply to: niall<at>rndmartin.cix.co.uk > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
