Hi Scott,
If you output the data as comma separated (i.e. commas as the delimiter) and use 'CSV' as the extension, it will open by default in calc. For any other text format file, you'd have to open calc, use 'file / open' and select 'csv' as the file type, the specify the delimiter used.
tc

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

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to