UNSUBSCRIBE PLEASE. -----Original Message----- >From: "G. Roderick Singleton" <[EMAIL PROTECTED]> >Sent: May 6, 2006 3:25 PM >To: [email protected] >Subject: Re: [users] importing tab-delim txt file to OO.o Calc > >On Sat, 2006-05-06 at 15:47 -0400, Eric Beversluis wrote: >> On Sat, 2006-05-06 at 15:31 -0400, G. Roderick Singleton wrote: >> > On Sat, 2006-05-06 at 15:26 -0400, Eric Beversluis wrote: >> > > I've got a tab delimited text file (gedit) that I want to import to Calc >> > > and have the tab-delimited fields assigned to different cells in each >> > > row. I have been over and over the menus and the help and can't find how >> > > to do it. It seems to me I've done with with Excel by just copying and >> > > pasting the file, but in OO.o that just dumps each row into one cell. Am >> > > I missing some instructions somewhere? >> > > >> > >> gedit was inserting spaces rather than tabs.... >> >> > I would guess that in the open dialogue you have checked a delimiter >> > option other than Tab or you have selected fixed width as the option. >> > Try selecting just the Tab delimiter. >> I don't see any such options. (I don't need them--once I got real tabs >> in my file, Calc did what I expected.) Is there supposed to be some >> place to select a delimited in the Calc Open dialog? > >If the file, is tagged as CSV, then yes. You get a dialogue box with >lots of options. If you look at or near page 182 of >http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf >you will see a graphic of this. Fixed width will allow you to separate >the file into its various columns by moving the dividers in the window >at the bottom. > >-- >PLEASE KEEP MESSAGES ON THE LIST. >OpenOffice.org Documentation Co-Lead >http://documentation.openoffice.org/ > >--------------------------------------------------------------------- >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]
