I have to admit I did not know that in order to use File -> Open in Calc
to open a delimited file, you must specify its format as Text CSV
(*.csv, *.txt). This seems rather strange but then again I'm sure there
is a good reason for it. Its even more tricky since if the file has
extension .upl you must first select the file then specify its extension
as Text CSV. Thank you again for your help,
Robert Volke
>>> [EMAIL PROTECTED] 10/21/05 6:52 AM >>>
On Thu, 2005-10-20 at 15:15 -0500, Robert Volke wrote:
> I think I have figured out what is going on with the delimited files
> problem. If I right click the delimited txt file -> OpenWith the
wizard
> will fire up for OpenOffice Calc and will open the document
correctly.
> However, I cannot first start Calc then do File -> Open -> my
delimited
> file because if I do it is opened with Writer and no wizard ever
pops
> up. I also noticed that although Calc does not have the option to
save
> a file as .txt, if, after your done editing your delimited txt file
with
> Calc, you click save and not save as, it will save the file in its
> current format. Therefore it would seem that following these steps
one
> could use Calc to work on these delimited files.
>
> However, Excel will open delimted files in other formats such as
.upl
> and not just .txt, where as OpenOffice Calc will not recognize a
> delimited .upl as such. Or at least that is the way it works in
version
> 109 and 125 on NT machines. Can anyone else confirm this?
>
> Robert
I do not understand. If you select Text CVS as the filetype, you
should
be able to open _any_ delimited file in Calc. If you do not bother to
do
this selection, then OOo will open in Writer. So is the problem that
you want automatic recognition and aren't getting it or that you and
your users are unaware of that they must specify the filetype. Please
explain. If it is the former, suggest that you enter an Request for
Enhancement (RFE) into Issue
Tracker as this is the best way to have requests such as this
evaluated.
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the
address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and
find
issues.
Thanks for bringing this to our attention. It is important that you
file
any examples with the issue to ensure your need is understood.
>
> >>> [EMAIL PROTECTED] 10/07/05 11:21 AM >>>
> I am not certain I understand the question. Are you asking whether
or
> not to open the file using the Text CSV filetype or whether or not
you
> should change the extensionon? Quite frankly, I think that if you
use
> the correct file type, it shouldn't matter but try both and let us
> know.
>
> On Fri, 2005-10-07 at 09:50 -0500, Robert Volke wrote:
> > Thank you for the swift response and sorry for my slow one. I see
> that
> > there is a fixed file option, but I still have a problem.
> OpenOffice
> > will only open delimited files saved as .csv right? If that is
> true,
> > how do I get it so that it can open files delimited by fixed width?
> > Thank you,
> >
> > Robert Volke
> >
> > >>> [EMAIL PROTECTED] 10/05/05 11:46 AM >>>
> > On Wed, 2005-10-05 at 10:35 -0500, Robert Volke wrote:
> > > I was wondering if in OpenOffice you can open a file delimited
by
> > fixed
> > > length. Has anyone experimented with this? In the past I have
> > renamed
> > > tab delimited files to have the .csv extension so OpenOffice
Calc
> > can
> > > open them, and that seems to work for the most part. However
the
> > > OpenOffice wizard does not have the option to split columns by
> fixed
> > > length upon import. I'm lost at the moment and any help would
be
> > > greatly appreciated.
> > >
> >
> > Yes it works fine. Just use the fixed file option and set your
> > columns.
--
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]
