StarCalc: Importing data from text file

[Joel Hammer]

OK. That works.

You have to work down the long list and find the cvs type. It's really
buried there. Once you pick this data type, then calc will parse it for you
as data.

Sigh.

I think I used to know that.

It would be nice if SO were smart enuf to know you wanted to import a text
file as data, without making you go through this.

This isn't fixed in SO 6.0, either. If anything, it it a bit more obscure.
Even worse. If you don't have a txt suffix on the file, when you choose
cvs as the template, it won't even show you the file in the file explorer.

Joel

On Tue, Jun 10, 2003 at 09:31:53PM -0400, Brett I. Holcomb wrote:
> I haven't tried it in starcalc but what about File/open, then select your 
> file.  I know in Excel that will open the import dialogs.
> 
> Joel Hammer wrote:
> 
> > I may just be missing this, ( I spent 15-30 minutes trying) but is there
> > a way to import a text file (data in columns) into StarCalc? I imported
> > the text file into staroffice, but it insists on importing it into the
> > wordprocessor. I tried to paste the wordprocessor page into starcalc,
> > but it put everything into one column.
> > 
> > I did solve this problem by using excel with win4lin to import it
> > into excel and then save it with an excel format, which starcalc reads
> > just fine.  But, that solution is not politically correct!
> > 
> > Joel
> 
> -- 
> Brett I. Holcomb
> brettholcomb at R777charter.net
> AKA Grunt <><
> Registered Linux User #188143
> Remove R777 to email
> _______________________________________________
> Linux-users mailing list
> Linux-users at linux-sxs.org
> Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users