Issue 64271 - excel import does not work (worked in 1.1.x)
Summary: excel import does not work (worked in 1.1.x)
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: branislav.klocok
QA Contact: issues@sc
Keywords: oooqa, regression
Depends on:
Reported: 2006-04-11 11:26 UTC by branislav.klocok
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

problematic file (54.92 KB, application/
2006-04-11 11:26 UTC, branislav.klocok
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description branislav.klocok 2006-04-11 11:26:19 UTC

I got reported from several users following problem:
- The import of attached file has worked in OOo 1.1.x without problems
- The attached file is generated automaticly from one local accounting system 
and has quite strange format (some HTML mix), nevertheless OOo 1.1.x handled 
the file correctly in calc.
- In 2.0.2 the file shows some strange symptoms during import:
   - Windows:
   Opening file through File-Open (in OOo) gets an error message (unsupported 
   Opening file through clicking in windows explorer opens the file in OOo 
   - Linux:
   Opening file through File-Open (in OOo)opens the file in OOo Writer/Web
   Opening file through clicking in Konqueror opens the file correctly in OOo 
Comment 1 branislav.klocok 2006-04-11 11:26:55 UTC
Created attachment 35631 [details]
problematic file
Comment 2 Regina Henschel 2006-04-11 16:02:41 UTC
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.
Comment 3 Regina Henschel 2006-04-11 16:40:37 UTC
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

I don't know whether the autodetection of the file format should detect such files.
Comment 4 branislav.klocok 2006-04-11 17:18:10 UTC
The problem is that its automaticly created by one accounting sw. (export to 
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
Comment 5 frank 2006-05-09 14:55:10 UTC
Hi Andreas,

please have a look at this one.

Comment 6 andreas.schluens 2006-05-11 08:08:52 UTC
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.


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. .-)
Comment 7 andreas.schluens 2006-05-11 08:09:19 UTC
Comment 8 ace_dent 2008-05-17 21:32:53 UTC
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,
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
Comment 9 ace_dent 2008-05-17 23:36:07 UTC
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).