e-mail from Frank Stecher from Hamburg 20097 DE: Hi,
what's about Insert Sheet from File ? Give it a try. Frank That solved my problems, it automatically imported the .txt file into the spreadsheet without having to first select .csv format. Thanks Frank! -----Original Message----- From: Michael Adams [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2008 6:04 AM To: [email protected] Cc: Koid, Jian Subject: Re: [discuss] data importing features on calc But if you are importing it as a .csv you can rename it from .txt to .csv without drama? Aren't .txt files containing .csv data non standard? (I know .csv is a type of text data, but calling a car a Ford narrows things down a bit). This rattles the poor programs paramaters a tad. On Wed, 26 Mar 2008 15:44:35 -0400 Koid, Jian wrote: > My input file is .txt > > And I don't want to associate text files to a spreadsheet program > > -----Original Message----- > From: Michael Adams [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2008 3:09 PM > To: [email protected] > Cc: Koid, Jian > Subject: Re: [discuss] data importing features on calc > > On Wed, 26 Mar 2008 11:43:46 -0400 > Koid, Jian wrote: > > > The data importing feature on calc (ms excels data import feature) > > is very hard to get to: > > > > file > open > > > > > select .csv file type (from a very long list of file types) > > > > open. > > > > This feels like a complicated way to do something simple especially > > compared to Excel's way of doing it where it's right on the data > > tab. > > > > Data > import external data > import data > > > > Basically my concern is that we have to find a .csv file type from > > the long list of different file types every time I need to import a > > text file. Also the text file will be imported to a new spreadsheet > > and has to be moved to the one I'm working on thus adding > > additional steps to a simple operation that is done fairly often > > (for data manipulation) > > > > You could use Windows File Association (Set .csv files to Open With > OO.o) then the procedure would be: > > o double click the file. > OR > o one click and tap[Enter]. > > -- > Michael > > All shall be well, and all shall be well, and all manner of things > shall be well > > - Julian of Norwich 1342 - 1416 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
