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. I do not know how > to do this. If I do what seems reasonable: Select the part of the calc > contents I want, copy and paste into the odt document, I get an image, > as though I had made a screen shot. If I select and copy to a > Thunderbird email message being composed, I get a table that I can copy, > as a table on into a odt document. It seems reasonable that this should > be possible directly. > > 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. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org