file PRN

momilla · Guest

Hi all, I'm trying to create a PRN file to export on AS400, is it possible with calc?To format my file with fixed width i have a lot of trouble.Can anyone help me?? Thanks

Guest · Posted: Thu Nov 13, 2003 10:27 am Post subject:

Don't know what AS400 is, but in Windows a PRN file is determined from the print dialogue, and works for all Windows programs so far as I know. Just select to Print to File in that dialogue window.

David.

ftack · Posted: Fri Nov 14, 2003 5:47 am Post subject:

PRN is just a file extension, bu I presume you want to create an ASCII text file of your data. Do this using File Save As Text CSV. Unless you specify an extension yourself, Calc will create a text file with the .CSV extension.

In the file Save As dialog, you see the "Edit filter settings" checkbox, which is on the first time you save, but "off" on subsequent file save as commands. By default, a Comma Separated values text file is created. You can change the Field delimiter from comma to for example tab, ; , etc., and the text delimiter between ", ' and nothing (just press the delete key: nothing does not show up in the drop down list!).

What you want right now is a "fixed width" file:in the "export of text files" dialog, specify:

Field delimiter (press delete)
Text delimiter (press delete)
Check "Fixed column width"

Pharaoh · Newbie Joined: 02 Nov 2005 Posts: 3 Location: Utah

When I try this place place holders (ex. - 0r * ) then size the column to them. I export and can't get the file to come out right. Either it is missing spaces or has too many. Any Ideas on how I would fix this?

Thanks