On Fri, 2005-10-21 at 10:05 -0500, Robert Volke wrote: > I have to admit I did not know that in order to use File -> Open in Calc > to open a delimited file, you must specify its format as Text CSV > (*.csv, *.txt). This seems rather strange but then again I'm sure there > is a good reason for it. Its even more tricky since if the file has > extension .upl you must first select the file then specify its extension > as Text CSV. Thank you again for your help, > > Robert Volke
Must be a windows thing because I can open files with no extension under Linux providing it really is a delimited or fixed width file. > > >>> [EMAIL PROTECTED] 10/21/05 6:52 AM >>> > On Thu, 2005-10-20 at 15:15 -0500, Robert Volke wrote: > > 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 > > I do not understand. If you select Text CVS as the filetype, you > should > be able to open _any_ delimited file in Calc. If you do not bother to > do > this selection, then OOo will open in Writer. So is the problem that > you want automatic recognition and aren't getting it or that you and > your users are unaware of that they must specify the filetype. Please > explain. If it is the former, suggest that you enter an Request for > Enhancement (RFE) into Issue > Tracker as this is the best way to have requests such as this > evaluated. > > If you haven't already registered, do the following: > > 1. To file an issue you must register with OOo by clicking the > My Pages tab and selecting the Register link > http://www.openoffice.org/servlets/Join > 2. Fill in your information > 3. Reply to the confirmation email that will be sent to the > address > you provided. > 4. Once you have confirmed, go to www.openoffice.org again > 5. And click on the "My Pages" tab from which you can file and > find > issues. > > Thanks for bringing this to our attention. It is important that you > file > any examples with the issue to ensure your need is understood. > > > > > >>> [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]
