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]
