I think I have figured out what is going on with the delimited files problem. If I right click the delimited txt file -> OpenWith the wizard will fire up for OpenOffice Calc and will open the document correctly. However, I cannot first start Calc then do File -> Open -> my delimited file because if I do it is opened with Writer and no wizard ever pops up. I also noticed that although Calc does not have the option to save a file as .txt, if, after your done editing your delimited txt file with Calc, you click save and not save as, it will save the file in its current format. Therefore it would seem that following these steps one could use Calc to work on these delimited files.
However, Excel will open delimted files in other formats such as .upl and not just .txt, where as OpenOffice Calc will not recognize a delimited .upl as such. Or at least that is the way it works in version 109 and 125 on NT machines. Can anyone else confirm this? Robert >>> [EMAIL PROTECTED] 10/07/05 11:21 AM >>> I am not certain I understand the question. Are you asking whether or not to open the file using the Text CSV filetype or whether or not you should change the extensionon? Quite frankly, I think that if you use the correct file type, it shouldn't matter but try both and let us know. On Fri, 2005-10-07 at 09:50 -0500, Robert Volke wrote: > Thank you for the swift response and sorry for my slow one. I see that > there is a fixed file option, but I still have a problem. OpenOffice > will only open delimited files saved as .csv right? If that is true, > how do I get it so that it can open files delimited by fixed width? > Thank you, > > Robert Volke > > >>> [EMAIL PROTECTED] 10/05/05 11:46 AM >>> > On Wed, 2005-10-05 at 10:35 -0500, Robert Volke wrote: > > I was wondering if in OpenOffice you can open a file delimited by > fixed > > length. Has anyone experimented with this? In the past I have > renamed > > tab delimited files to have the .csv extension so OpenOffice Calc > can > > open them, and that seems to work for the most part. However the > > OpenOffice wizard does not have the option to split columns by fixed > > length upon import. I'm lost at the moment and any help would be > > greatly appreciated. > > > > Yes it works fine. Just use the fixed file option and set your > columns. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
