Issue 70981 - Calc opens html-"xls" file without formatting (ignores css)
Summary: Calc opens html-"xls" file without formatting (ignores css)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 76158 77209 83971 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-10-29 17:45 UTC by diman
Modified: 2013-08-07 15:12 UTC (History)
5 users (show)

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

Attachments
bug file (49.87 KB, application/vnd.ms-excel)
2006-10-29 17:46 UTC, diman 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description diman 2006-10-29 17:45:37 UTC 
Calc refuses to open xls file, entrusting it to Writer/Web. 
Opened file is scrolled very slowly at P4 2.8 GHz, 512 Mb, WinXP SP2.
I assumed it to be xml.
But renaming file to *.XML does not help.
Excel  open it fine.
Comment 1 diman 2006-10-29 17:46:47 UTC 
Created attachment 40146 [details]
bug file
Comment 2 Regina Henschel 2006-10-29 19:39:46 UTC 
Please do this: Start OpenOffice.org and then File - Open. Choose the document
and then choose the file typ "HTML Document (OpenOffice.org Calc)
(*.html;*.htm)". You find this in the section, which begins with "OpenOffice.org
Spreadsheet".

Does it open correct?
Comment 3 diman 2006-10-30 16:26:08 UTC 
Yes it does. Thank you.
 But is it bug that calc doesn't open it automaticly or is't normal?
Anyway such things are confusing especially for beginers.
Comment 4 diman 2006-10-30 17:13:27 UTC 
Some more note. It works but but all formating is lost.
Comment 5 diman 2006-10-30 17:44:49 UTC 
By the way i used "HTML Document (STAROFFICE Calc)" because there is no "HTML
Document (OpenOffice.org Calc)" in OOo 2.0.
Comment 6 Regina Henschel 2006-10-30 20:13:56 UTC 
You can also use the filter "Web Page Query", which seems to work a little bit
better. But formatting is not kept too. I adjust the summary to reflect the
remaining problem.

You should use a newer version, actual 2.0.4.

If you need the formatting, you can open the file in writer, copy the table and
paste it into the spreadsheet as "Formatted text (RTF)". Background color is
lost in import to writer, but font style bold is kept.
Comment 7 frank 2006-11-02 10:47:58 UTC 
Hi,

the problem with the lost formatting is caused by a not implemented cascadibg
Stylewsheet interpreter for the HTML filter. Therefore this Issue is an Feature
request and is handled by the requirements team.

Frank
Comment 8 pagalmes.lists 2007-03-22 15:04:14 UTC 
I just wanted to add that this issue will impact many big companies.
This HTML-XLS format is used by many critical software for companies 
like "wmware", "Cognos"...

also see issue 75653
Comment 9 lohmaier 2007-04-15 13:41:49 UTC 
*** Issue 76158 has been marked as a duplicate of this issue. ***
Comment 10 frank 2007-07-06 13:04:33 UTC 
*** Issue 77209 has been marked as a duplicate of this issue. ***
Comment 11 frank 2007-11-27 13:16:39 UTC 
*** Issue 83971 has been marked as a duplicate of this issue. ***
Comment 12 Rainer Bielefeld 2009-08-14 17:40:05 UTC 
*** Issue 104190 has been marked as a duplicate of this issue. ***
Comment 13 jbf.faure 2010-04-02 18:08:33 UTC 
Add me to cc.