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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
