2007/2/18, Mark Knecht <[EMAIL PROTECTED]>:

On 2/18/07, Alan Frayer <[EMAIL PROTECTED]> wrote:
> Mark Knecht wrote:
> > Hi,
> >   This is just a generic question. It seems that on all my Linux and
> > Windows systems Open Office, when I click on an icon for a generic xls
> > file that Open Office hasn't seen before, will open it using Writer
> > instead of Calc. Why is this? Once I tell it to use Calc it opens the
> > next time with Calc, but never the first time.
> >
> >   Am I missing some config option inside of OO to make xls files
> > associate by default with Calc and then have this work better?
> >
> >   In Windows the default 'Open with...' association just says
> > 'OpenOffice.org 2.0'.
>
> True xls files should open in Calc automatically. I have no problem with
> this in Windows or Linux. If I use Writer to load an xls file, OOo
> launches Calc and opens the file. If I tell Windows to default to OOo in
> opening an xls file, OOo opens Calc on its own.
>
> This begs the question of whether the file being opened is really xls,
> or is simply a text file with an xls extension. Asking OOo to open a
> text file with an xls extension will still result in launching Writer,
> because OOo knows the difference. I have seen third-party applications
> produce text files with xls extensions, expecting Excel to import the
> file into itself.
>
> Verify that the files are really xls files, and not text files with xls
> extensions. You may need to "import" these xls files into Calc, rather
> than simply opening them with OOo.
>
> --
> Alan Frayer

Alan,
   Hi. Indeed you make a good point. I'm not sure what constitutes a
correctly formatted XLS file but I suspect that this one is not since
it is readable in a Linux text editor. Looks more like some form of
XML or something more generic.

   I've attached a zipped copy along with this email. It's only 7K so
not a big burden to anyone. If the attachment survives the list's
email server then you can look at it yourself.

   I have no problem opening these files if I right click and tell
whatever OS I'm on to use scalc. I can then copy and paste the data
into the 2nd spreadsheet I keep with this data week by week. I Was
just looking for how to make it a bit faster.

Thanks,
Mark


Hello,

On OOo with X11 on a Mac, I can't chose which part of OpenOffice.org will be
used to work on a file. I only have "Open with OOo 2.1" and that it.
The so-called xls in your little zip-file opens in OOo... Writer/web and
pretends it's html.

Good luck!
--
Guy
using dutch OOo 2.1 RC 2 on a iMac Intel DualCore Tiger
and dutch OOo 2.1 RC 1 on a G4 PPC Powerbook Tiger
-- please reply only to [email protected] --
Dodoes can't afford to have headaches

Reply via email to