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. -- Scott --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
