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]
