Apache OpenOffice (AOO) Bugzilla – Issue 104190
OOo opens html-"xls" file very slowly (or hangs)
Last modified: 2013-01-29 21:41:54 UTC
Right click on the file > open with > calc. And calc don't respond. Tried on windows Me/xp sp3/ vista sp2.
Created attachment 64099 [details] File
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated [OOO310m11 (Build 9399)]" and can confirm the reported hang. XLS-Viewer can't open this "Microsoft Excel 11" document, too, so I believe document is damaged. But of course, OOo should not hang trying to open it.
OOo does not really hang, but it takes a lot of time with high processor load to open "berg.xls". "Ooo Dev 3.2.0 multilingual version English UI WIN XP: [DEV300m53 (Build 9412)" opens "berg.xls" within a minute as a WRITER/HTML document! The sample document is not a real EXCEL spreadsheet, but a HTML document. So INVALID.
1. Excel 2003 opens it fast. 2. It may be open by writer but OOo hangs this way: Right click on the file > open with > calc(win xp, vista). So CALC really hangs. I waited 12 minutes on core 2 duo 3.16Gh. But if this document is HTML maybe i should fill another issue.
This is exactly the same problem as in Issue 70981. As long as the FEATURE is not integrated, you can not estimate that OOo will open such documents quickly. Still can't confirm a hang, it takes 3 minutes, then the document has been opened (AMD Athlon 64bit 3500+ / 1GB RAM) @diman: Please compare source code of both sample files using WIN Editor! *** This issue has been marked as a duplicate of 70981 ***
Source code of both sample files is similiar but: 1.File in issue 70981 is opened with Calc(NOT with WRITER)quite fast and well. 2.File in issue 70981 is opened with WRITER slowly. 3.File in this issue is not opened with calc at all, it hangs (on my computer tried wait more than 15 min with no result) So problems are different. rainerbielefeld, Did you open open it with Сalc or with Writer? Did you use OOo 3.1 or 3.2.
@diman: my OOo 3.1 decides to open "berg.xls" with WRITER, "atto.xls" with CALC. The reason seems to be that OOo isn't "really" able to handle those EXCEL-HTML documents. Let's wait for further comments here.
There is summary for this file (berg.xls): File can be opened with calc this way: Start OpenOffice.org and then File - Open. Choose the document and then choose the file type "HTML Document (OpenOffice.org Calc) (*.html;*.htm)"It takes 4 minutes to load WITH CALC on Core 2 duo 3,16 Mh. That is really long. The second way I tried (as I wrote before) hangs calc: Right click on the file => open with => calc. Rainerbielefeld, issue 70981 is about ignoring css and this issue is about performance and stability. I don't think that this is duplicate of 70981. If so, please reopen issue.
Reopen for above mentioned reasons.
No problem to load this file with OOo 3.2.0 (FR) and OOO320m14 under Ubuntu 8.04. I used file type "HTML document (OpenOffice.org Calc)". It is more difficult to open it with Firefox but both give similar results. @diman: Please try again with OOo 3.2 on your OS. Regards. JBF
@jbfaure. Yes, 3.2 seems open it "HTML document (OpenOffice.org Calc)" more or less well.
I still takes more than 1 minute for me to open sample document "berg.xls" with "Ooo-Dev 3.2.1 multilingual version English UI WIN XP: [OOO300m14 (Build 9489)]"! When document is open, OOo3.2 is very lazy, reactions often need several seconds, and I see lots of HTML code as comments. Indeed, there is some progress, 14 will open the document as a CALC document, not as a WRITER document.
Is this a duplicated of issue 100189?