Issue 89332 - The html based xls file does not open in Spreadsheet component
Summary: The html based xls file does not open in Spreadsheet component
Alias: None
Product: General
Classification: Code
Component: code (show other issues)
Version: OOo 3.2 RC4
Hardware: PC All
: P3 Trivial with 3 votes (vote)
Target Milestone: OOo 3.3
Assignee: kla
QA Contact: issues@framework
Keywords: oooqa
: 96362 108350 109698 109739 110207 (view as issue list)
Depends on:
Reported: 2008-05-12 14:11 UTC by biq
Modified: 2010-06-17 20:25 UTC (History)
5 users (show)

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

Sample file, following description by RG (97 bytes, text/plain)
2009-01-28 18:24 UTC, realgrouchy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description biq 2008-05-12 14:11:38 UTC
In 3 beta ooffice the html table in a file with "xls" suffix opens in Writer
component, while in ooffice 2.4 it opens correctly in Spreadsheet component.
Comment 1 biq 2008-05-12 17:12:00 UTC
I cannot verify on Windows, so I correct the OS as Linux.
Comment 2 caolanm 2008-09-15 10:05:58 UTC
Comment 3 realgrouchy 2009-01-28 18:23:43 UTC
I can confirm this, and will upload a sample file.

There are two problems here:
Definition: The "html based xls file" is a file with extension .xls, and which,
when viewed in plaintext, contains a table created with html tags in the format
<table border="0"

Problem 0: When clicking this file on the desktop or in a folder, it opens
properly in the Calc component. This is not a problem.

Problem 1: When opening this file using File > Open (or the "open a file" button
in the welcome screen), it opens in the HTML editor component.

Problem 2: When attempting to open a very large file of this format (I'm not
sure if the limit is amount of total data or number of rows, but my file has
over 3200 rows), it has the following response:

Problem 2a: When opening it using File > Open, it opens in the HTML editor
component, and only the first 3200 rows are rendered. The rest are concatenated
into a long paragraph.

Problem 2b: When clicking on the file from the desktop, the OOo title screen
opens, and the process grows to over 100MB (taking 99% of the processor,
according to Windows Task Manager), and the file does not open in five minutes
(I gave up after that).

Such a file opens fine in Excel for XP (which was my workaround until the other
computer with that program was discarded), but the file doesn't open properly in
Excel:mac 2004 or 2008, as accented characters are not decoded properly. (é
comes out as È, etc.)

Unfortunately, the vendor whose software creates these files treats this problem
as "worksforme [in Excel for XP]", and I am not in a position to get them to
create a properly working file.

In addition, double-clicking the files to open them is a very time-consuming
workaround for me. I keep my files on the OSX part of my computer, and access
them in OOo/XP via networked folders. I also don't have space on my XP virtual
hard drive to save them. And for some reason, I can't open files on folders
networked via Parallels (see issue #85650).

While 3200 rows may be a reasonable limit for an HTML editor, it is not for a
spreadsheet program. Therefore any workarounds involving opening the file in
OOo's HTML editor component is not a true solution. OOo should obey the file's
.xls extension when opening such files, and when opening them in the spreadsheet
module, they should be able to accept files with over 3200 lines.

- RG>
Comment 4 realgrouchy 2009-01-28 18:24:52 UTC
Created attachment 59728 [details]
Sample file, following description by RG
Comment 5 Rainer Bielefeld 2010-01-16 10:52:09 UTC
I see this opening as "Text Encoded" with "Ooo 3.2.0 RC2 WIN XP DE-multilingual
version German UI activated [OOo320m9 (Build 9476)]", so I modify OS
Worked fine with "2.4.1  Multilingual version English UI WIN XP:
Comment 6 Rainer Bielefeld 2010-01-16 10:59:47 UTC
*** Issue 108350 has been marked as a duplicate of this issue. ***
Comment 7 stephan_schaefer 2010-01-27 16:30:58 UTC
HTML files with "xls" suffix should always open in calc. Would be great if the
filter detection could be changed accordingly.

Setting component to framework and target to 3.3 (if possible in that time frame).
Comment 8 Mathias_Bauer 2010-01-27 20:06:47 UTC
Taking over for further assignment
Comment 9 Rainer Bielefeld 2010-03-02 12:54:58 UTC
*** Issue 109698 has been marked as a duplicate of this issue. ***
Comment 10 Mathias_Bauer 2010-03-02 16:51:26 UTC
I think it doesn't matter as in fact the code here is wrong and was wrong. I
assume that solar.hrc was not included in addonmenu.cxx, but due to changes in
other CWS integrated into m72 it is now included indirectly and so we have the
clash. Let's remove the line defining the constant SID_SFX_START and move on.
Comment 11 Rainer Bielefeld 2010-03-18 07:30:28 UTC
*** Issue 110207 has been marked as a duplicate of this issue. ***
Comment 12 niklas.nebel 2010-04-14 19:38:26 UTC
taking the issue
Comment 13 niklas.nebel 2010-04-14 19:43:01 UTC
Fixed in CWS "calc53". HTML files with extension XLS are opened in Calc by
default (with the "Web Page Query" filter), both if passed to "soffice" or
"scalc", and from the "Open" dialog.
Comment 14 realgrouchy 2010-04-14 19:48:40 UTC
Thanks nn! This might allow me to stop needing MSO!
Comment 15 niklas.nebel 2010-04-22 16:41:44 UTC
*** Issue 109739 has been marked as a duplicate of this issue. ***
Comment 16 niklas.nebel 2010-04-29 17:29:11 UTC
reassigning to QA for verification
Comment 17 kla 2010-05-06 14:54:11 UTC
Seen ok in cws calc53 -> verified
Comment 18 caolanm 2010-05-10 13:55:16 UTC
*** Issue 96362 has been marked as a duplicate of this issue. ***
Comment 19 Regina Henschel 2010-05-14 09:51:57 UTC
*** Issue 111579 has been marked as a duplicate of this issue. ***
Comment 20 caolanm 2010-05-31 21:12:56 UTC
closing, integrated DEV300_m80
Comment 21 realgrouchy 2010-06-17 20:15:05 UTC
I just installed 3.2.1 and it is still opening in the Writer/Web component, not
in the Calc component.

I thought this was fixed? Or is there a setting I am missing?
Comment 22 caolanm 2010-06-17 20:23:28 UTC
See the "target" field, the target is 3.3, not 3.2.1, its supposed to be fixed
in that version. Any of the development milestones made available with a number
>= DEV300_m80 should have the fix in it, e.g. currently has DEV300_m82 available
Comment 23 realgrouchy 2010-06-17 20:25:44 UTC
Oops, thanks for that. I look forward to seeing it in 3.3, then!