Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Calc opens html-"xls" file without formatting (ignores css)|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, jbf.faure, kozodaevroman, pagalmes.lists, rb.henschel|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
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 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.