OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

file PRN

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
momilla
Guest





PostPosted: Thu Nov 13, 2003 2:40 am    Post subject: file PRN Reply with quote

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
Back to top
Guest






PostPosted: Thu Nov 13, 2003 10:27 am    Post subject: Reply with quote

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.
Back to top
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Fri Nov 14, 2003 5:47 am    Post subject: Reply with quote

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"
Back to top
View user's profile Send private message
Pharaoh
Newbie
Newbie


Joined: 02 Nov 2005
Posts: 3
Location: Utah

PostPosted: Wed Nov 02, 2005 11:20 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group