Created attachment 35631 [details]
problematic file

I can confirm for WinXP and OOo-dev2m162 that something is wrong.

From the body it seems to be a Microsoft Excel 2003 XML file. But the header
doesn't start as other files, which I save from Excel. It is no xsl-format. So
the file is corrupted.

But nevertheless OOo doesn't acts right. If I choose the filter 'Microsoft Excel
2003 XML' in file-open dialog, than it doesn't open with that filter but opens
with Writer/Web.
If I have an opened spreadsheet and use Insert Sheet From File and use that
filter, it opens the file correct and it look like in Excel.

The correct filter in OOo is 'Web Page Query' and with that filter the file
opens correct with Calc.
The file seems to be the format, which you get, if you 'save as' in Excel as
(German)'Webseite'. In this case Excel uses the extension 'htm'.

For problems with Excel-XML-Format and handling of xsl-extensions see also issue
62492.

I don't know whether the autodetection of the file format should detect such files.

The problem is that its automaticly created by one accounting sw. (export to 
excel).
I believe that there is a problem in the filter for opening xls files, it 
should open in Calc in any case (just like MS excel). I believe its Excel
XML.

Hi Andreas,

please have a look at this one.

Frank

a) This is not a valid XLS file.
b) Further it's not a valid Excel 2003 xml file
c) It's simple HTML ... which can(!) be interpreted as a calc sheet.
It's similar to problems regarding TXT and CSV. CSV isnt a real format. CSV is TXT 
interpreted as CSV - nothing else.

Excel does not  have problems loading such files, because it detect it as HTML and load 
it as HTML searching for the right structure inside.

But OOo does not provide real distinguished applications. E.g. calc and writer/web does 
not resists in different processes at runtime. And if you load this file we detect the HTML 
format. Further we will find two filters available for this format: one filter for the writer/
web module and one for the calc module. But the writer/web filter is the preferred filter 
for HTML files. So loading if this document into calc can work only in case you select 
"calc webquery" inside the file open dialog (which btw. works). Selecting the XSL filter 
does not help - because OOo validates your preselection. And it finds out that XSL is 
wrong. So it ignores your selection XSL and detect HTML as real format of this file.

This behaviour can be changed only in case OOo will be splitted into real distinguished 
applications - means standalone writer, calc, impress etcpp. But this step is far away 
from today. Even for OOo 3.0 I dont think it can be implemented so easy.

The only solution: use the right preselection inside the file open dialog. The trick to use a 
wrong extension to force loading of a file in a special way isnt realy functional. It works 
by luck only ... as it worked in OOo 1.1 by luck.

Regards
Andreas

PS: May be there is a workaround for your problem ...
OOo installs (behind soffice.exe) several other exe files as e.g. scalc.exe.
If you now register XLS files on windows to be opened with scalc.exe instead of soffice.
exe it should preselect the application "calc". Then opening of HTML files renamed to 
XLS by using the system windows explorer should work as you aspect. .-)

.

The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html

As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew