[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    Re: [users] Re: importing tab/space delimited files into calc
From:       "Bill McKelvie" <mckelvie () cyber ! net ! pk>
Date:       2003-12-09 3:40:07
Message-ID: 001101c3c0c8$941a7560$0000a398 () Laptop
[Download RAW message or body]

CPH was right.  But if you choose the file type before selecting the file,
it won't appear in the list of available files.  You need to either choose
the file before choosing the file type or type it in by hand.  Simple now
that we know, but unobvious enough to confuse some of us.

Bill

----- Original Message -----
From: "CPH" <cphennessy@openoffice.org>
To: <users@openoffice.org>
Sent: Tuesday, December 09, 2003 1:23 AM
Subject: Re: [users] Re: importing tab/space delimited files into calc


> On Monday 08 December 2003 14:46, Bruce Bowler wrote:
> > On Sat, 06 Dec 2003 11:15:34 +0500, Bill McKelvie put fingers to
keyboard
> >
> > and said:
> > > Dear Bruce,
> > > Have you tried this?  (It worked with on XP):
> > >
> > > File -> Open -> Files of Type: "Text CSV (*.csv, *.txt)"  (about 1/2
way
> > > down
> > > the list)
> > > ->Open (after choosing your file of course).  You should get a Text
> > > Import dialogue.
> > > The file name still seems to need a .csv or .txt extension.  If your
file
> > > doesn't then I'm stuck.
> >
> > Thanks for the above, you're right it works fine if the file is .csv or
> > .txt.  My problem is that it's neither of those and for various reasons,
> > I can't rename it (well I could, but then I'd have to rename it back for
> > processing by another program, for which we don't have source and
expects
> > a certain file extension.)
>
> When you do "File" -> "Open" change the "file type" to "Text CSV" and it
will
> work
>
> CPH
>
> > Excel doesn't suffer from this problem.
> >
> > I'm SOOOOOOOOO close to dumping M$ but this problem and relatively poor
(I
> > know it's new so I'm not complaining yet) macro/macro
> > recording capabilities are likely to keep at least part of me stuck on
M$
> > for the forseeable future.
> >
> > > I had the a similar problem and the solution was not obvious to
> >
> > me. As
> >
> > > a novice user, I would have appreciated an import sub-menu under the
> > > File Menu.  Do others think it is worth filing an issue on this?
> >
> > YES! with the removal of the filetype restriction.
>
> --
> CPH : openoffice.org volunteer
>
> Maybe your question has been answered already?
> http://support.openoffice.org/#FAQ
>
> Also please reply *only* to users@openoffice.org, as your responses will
be
> answered more quickly, more correctly, and shared to help more people.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.org
> For additional commands, e-mail: users-help@openoffice.org
>
>


[prev in list] [next in list] [prev in thread] [next in thread]