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]