I tried that and the formatting doesn't come out right. I have played
with different fonts and font sizes and can't get the spacing right.
How do I size the column to number of characters?
Shane
G. Roderick Singleton wrote:
On Thu, 2006-03-02 at 13:49 -0700, Shane Johnson wrote:
I could use some help please.
I am trying to mimic something I did all the time in Excel and need
to do in Calc. I need to export a calc file as a space delimited text
file with the column width set at:
Column 1 22 Characters
Column 2 1 Character
Column 3 5 Characters
I have searched the mail archives and can't find anything on this.
I have tried save as a CSV files and formatting it as fixed width but I
can't get it to work right. With Excel I would just get the data into
the columns I needed and then size the columns by the number of
characters that I needed in the column and then export it to a space
delimited file. Please let me know the best way to do this. If I need
to use something besides inches for the measurement of the column width
I can do that but I need to know how to figure out how to do it. I
appreciate your help.
Shane
It is an option of save > text csv. Try it.
--
Thank you,
Shane D. Johnson
IT Administrator
Rasmussen Equipment Company
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
