Issue 100189 - Calc takes long time to open xls file with html tags
Summary: Calc takes long time to open xls file with html tags
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0.1
Hardware: Unknown Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: crash
Depends on:
Blocks: 104190
  Show dependency tree
Reported: 2009-03-13 18:19 UTC by arvindjindal
Modified: 2013-01-29 21:43 UTC (History)
3 users (show)

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

xls file with HTML tags (8.13 MB, text/plain)
2009-03-13 18:38 UTC, arvindjindal
no flags Details
xls file without HTML tags (1020.50 KB, text/plain)
2009-03-13 18:39 UTC, arvindjindal
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description arvindjindal 2009-03-13 18:19:59 UTC

I am part of Oracle application implementation team and I am developing some
reports using XML publisher technology. My client is using star office calc to
view excel reports which takes long time if data exceeds 5k records.

Oracle apps generally open the output of the report in excel and if excel is not
installed on your computer then it prompts you for different application.
Generally users save the output in .xls format on their computer and then open
in star office. Problem is saved .xls file contains html tags too and star
office takes long time to import that file. If same file is saved in .xls format
without html tags, it opens fast.
Could you please suggest some way around.

Comment 1 arvindjindal 2009-03-13 18:38:58 UTC
Created attachment 60914 [details]
xls file with HTML tags
Comment 2 arvindjindal 2009-03-13 18:39:49 UTC
Created attachment 60915 [details]
xls file without HTML tags
Comment 3 kpalagin 2009-03-16 13:13:24 UTC
Confirming with OO3.0.1 on WinXP - opening File_With_HTML_tags.xls hungs Calc 
with 100% CPU usage.
What is interesting is opening this file inplace using IE does not cause this 
and file opens just fine.

Suggest fixing for 3.2.1.
Comment 4 arvindjindal 2009-03-16 18:07:57 UTC
Thanks for your support.
Just want to let you know that this problem is not only on win XP but also on
Sun OS/Mac which is used by the business extensively.

Also could you please confirm if this issue will be resolved in 3.2.1 version
and when it will be available. We will notify the business users accordingly.

Please let me know if you need any other information.


Comment 5 arvindjindal 2009-03-24 17:45:25 UTC
Could you please provide me update on this issue.
Comment 6 kpalagin 2009-03-24 19:00:58 UTC
not a feature, but defect.

it does not work that fast with OO. If you do not see any progress in, say, 
month, consider raising this issue in dev at sc.openoffice mailing list.
Comment 7 Rainer Bielefeld 2010-05-27 04:56:52 UTC
I agree with suspect in comments from paolopoz Wed May 26 12:49:01 that Issue
104190 might have the same roots (or even be a DUP).