To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=62492
User intersol changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |REOPENED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Mar 7 05:13:41 -0800
2006 -------
Let me be more specific: here are the real facts:
The submited file it's 100% valid Microsoft Office Spreadsheet in XML format
WITH and additional 3 bytes header before the first XML tag. We know that this
file was generated by MS Office.
Microsoft office not only open this file but also keep it's header (0xEF 0xBb
0xBF). This is working with ANY EXTENSION - even if you use XLS or XML.
Now let's investigate OpenOffice.org behavior:
Case 1: File > Open > test.XML in SCALC.EXE works.
Case 2: File > Open > test.XLS in SCALC.EXE does not work.
So I think there is a bug in filter detection algoritm. It should work like
this:
if recognize_binary_format()
{
... open with binary filter
}
else /* not known binary */
{
if (recognize_XML_format())
{
... open using detected filter
}
else if is_text_only()
{
... open as text in writer
}
else
{
... message: unrecognized binary format
}
XML file extension has not any meaning for the normal user - the file can be a
HTML page, spreadsheet, configuration or any king of file. People must need to
know what application is going to open their files in order to act.
Normal people is not opening formated files (like XML) in order to edit them as
plain text. They expect to edit the data from them not the file. So OOo must
(not should) detect corectly the file format.
As any power user who blamed MS for hiding the file extension from files any
application must be able to open all suported files without requesting a
specific extension for them. Extension is only informative and It can't
guarantee you that the data inside it's valid.
Currently hundreds (maybe more) developers are generating spreadsheet reports in
microsoft XML format because it's very simple and it's just plain uncompressed
xml. They are generating those files with XLS extension in order to make users
to open them in a spreadsheet application BUT how nice OpenOffice.org it's
smarter It can't accept opening an spreadsheet file (in XML format) stored in a
file with XLS extension.
If all file formats used were XML how do you expect for a user to make his
computer open those files with a specific aapplication. File extension
association it's a user configurable option, but recognizind the file format it
the job of the application.
The problem should stay open and must be assigned to the filter detection.
---------------------------------------------------------------------
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]
