[EMAIL PROTECTED] wrote:
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]
If it's a CSV file, I don't think that OOo will open it correctly
AUTOMATICALLY. That is, if you are in OOo, and you select File > Open
and select the file, it will open as a text file.
What needs to be done to open it correctly is to select File > Open,
then for File Type, select "Text CSV (*.txt, *.csv)". Then select the
file to open, and it should open correctly, as a spread sheet rather
than as simple text.
But based on what you indicate about the people who will be using the
system, this may be asking a lot of them. When you click the drop-down
arrow to show the list of file types, there are a LOT of different file
types, and CSV is buried pretty much in the middle of the list. For
non-computer-literate users, this may be a bit confusing until they've
done it a couple of times.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
