On Thu, May 4, 2006 08:11, G. Roderick Singleton wrote: > On Thu, 2006-05-04 at 07:49 -0700, Scott Taylor wrote: >> On Thu, May 4, 2006 07:34, Immanuel CRC Office wrote: >> > Scott Taylor wrote: >> >> Hello all, >> >> >> >> I'm running an old UNIX legacy system where all the apps are writen >> in >> >> PROGRESS. Often people want data to put into a spreadsheet, this is >> >> simple if I write the output as a TAB delimited file and call it >> >> blah.xls; then it just opens in their spreadsheet program without any >> >> data importing functions done by the users. >> >> >> >> When I try to open these files with OOo2.Calc it just opens as a new >> >> plain text file in Writer instead of as a spreadsheet Calc. >> >> >> >> Is there a way to force it to open as a spreadsheet instead? >> >> >> >> This is, basically, the only thing keeping me from converting the >> whole >> >> office to OpenOffice.org. >> >> >> >> Thanks for any insight. >> >> >> > >> > Scott: >> > >> > Is the extension .csv? It is possible Calc is not recognizing it as a >> > spreadsheet file. If it did, it will probably open it fine. What >> happens >> > when you do Insert->Sheet from the Calc menu? This should give you a >> > wizard to select that it is tab delimited. >> > >> > You might have to set up a file association so that OOo knows to open >> it >> > using calc. >> >> Hi Crystle, >> >> I save the files as "blah.xls" replacing blah with whatever is relevant >> at >> the time. I don't want the users to have to think, they are not great >> at >> it. I can open the files fine, myself. However, if I try to open them >> without any user intervention, they open as plain text in Writer instead >> of Calc, even though Calc is supposed to open '.xls' files (file >> association is already done). >> >> If I do set the extention to .csv then the user has to think, and they >> will freak out if they see something (like the import data dialogue) >> other then their file opening as a spreadsheet. >> >> Sorry if I want so clear the first time. >> > > XLS != CVS let's clear that up now. If you want to have these file open > n Calc without operator thought you will have to change the extension > to .csv so that OOo knows that this is a delimited file that should be > opened in Calc. Or you could simply export this files in proper MSO > Excel format which OOo will happily import.
Um yeah. But that's not what I'm trying to achieve here. I can only output plain text, it's an old legacy UNIX system. If I change the extention to .csv the user will be affronted with a dialogue box and will be calling me everytime they want to open a file. Please re-read the very first paragraph. -- Scott --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
