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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
