To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=64271
User as changed the following:
What |Old value |New value
================================================================================
Assigned to|as |brko
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu May 11 00:08:52 -0700
2006 -------
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. .-)
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]