Consider renaming it to .csv, opening it in calc, and either changing the Separator Option to Fixed Width (a bit of a pain if you have many columns, since you must "tell" OOo where the columns break), or change the Separated By: from comma to space and check merge delimiters (but I think that could get messed up by a blank field).

Anthony Chilco wrote:
An excel prn formated file is plain, space-delimited text. Both excel and OOo will import it.
tc

Wake wrote:
Correct, and if I'm correct, a .prn file is intended to be printed on a
specific printer. That means it will contain, at best, PCL instructions for
the chosen printer, but at worst it could be a bitmap-type file. I doubt
that either of these can be imported, even by Excel!

jwp

Arnold Huzen wrote:

If I'm correct, then .prn is a file you create when you choose the
option to print anything to a file instead of the normal print to a
printer. I think these kind of files can be created by any windows
program.

Arnold Huzen


Henry Heah schreef:
Hi,

I faced this problem that i can't use Calc to open MS excel's Formatted
Text format file (.prn). Any ideas? Please help me.

Thanks,

Best Regards,

Henry Heah

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







--
Andy Luddy
[EMAIL PROTECTED]
"He who cannot forgive breaks the bridge over which he himself must pass."
                                ... George Herbert (1593-1633)

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to