On 08/09/2010 10:57 AM, [email protected] wrote: > David B Teague - [email protected] wrote: >> On 8/9/2010 1:05 AM, NoOp wrote: >>> On 08/08/2010 07:49 PM, David B Teague wrote: >>>> I have an excel file that I have converted to a calc file. It contains >>>> membership data: names, addresses, email addresses etc. There are no >>>> formulas. >>>> >>>> I'd like to have this data in a table in an odt file. >>>> <SNIP> >>>> Is this possible? If so how do I do it? >>> Select the .ods/.xls data, copy. Open a new writer doc, Edit|Paste >>> Special|Unformated Text. Select the data that you just pasted& >>> Table|Convert|Text to Table. >>> >>> You'll then have to adjust the columns, fonts, etc., to suit your >>> page/preferences. >> Many thanks. This is better than the method using Thunderbird email as >> an intermediate. I lose some of the right most data that way. >> >> David Teague > > The following (after copying from Calc) might give the desired result, > without the need for reformatting: > Edit | Paste Special | Formatted text [RTF] > Edit | Paste Special | HTML (HyperText Markup Language) > > Mark.
Those do not paste as a table & you'd still need to convert to table. It would be a nice 'wishlist' to be able to select 'Paste as Table' in the Paste Special options. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
