Hi Scott,
I mislead you a little in my first post. It's not necessary that the
file be comma separated. Just that the extension be CSV. In either case,
OOo will open the text import dialogue. If it's comma separated, the
user need only click 'OK'; if it's tab delimited, the user will have to
select 'tab', then click 'OK'.
tc
Scott Taylor wrote:
On Thu, May 4, 2006 08:06, Immanuel CRC Office wrote:
Scott:
Usually CSV puts " around text, and then , between cells. This way is
doesn't matter what the text contains. Can you edit your exporter to do
that? It might help.
You are right, that is the proper format for CSV. Maybe it was something
else, but I have had trouble with CSV delimited by commas. Anyway, the
thing is to delimit it by TABS so the spreadsheet automagically opens as a
spreadsheet instead of as data. That was the whole point in the first
place.
--
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]
