Issue 112705

Summary: Spreadsheet hangs with "Adapt row height" when opening XLS
Product: Calc Reporter: j4m0 <kana.reiko>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: hagar_de_lest, issues, jsc, maison.godard, steve.yin.aoo
Version: OOO320m18Keywords: performance
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: 3.4.1
Developer Difficulty: ---
Attachments:
Description Flags
Report with opening problem (freezes at "Adapt row height") none

Description j4m0 2010-06-25 17:46:03 UTC 
Recently we received several important spreadsheets from our partners.
All of them have XLS format. And we cannot open none of them because 
of the error. "Adapt row height" appears to start after document importing.
Spreadsheet consumes CPU extensively and as a result it freezes.

We've also tried to open it with excel 2007. It opens it without problems
immediately.

I've attached a problematic document to this issue.
Comment 1 j4m0 2010-06-25 17:47:37 UTC 
Created attachment 70226 [details]
Report with opening problem (freezes at "Adapt row height")
Comment 2 hagar_de_lest 2011-03-17 11:38:38 UTC 
Works fine with LibO 3.3.1. Hangs with OOo 3.3.0 (both vanilla versions on Ubuntu 10.10).

Cross platform bug IMHO.
Comment 3 gg43 2013-01-31 01:10:20 UTC 
Platform: 
Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64)
Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1369110

My test:
Now open file ok, but needs be very patient (on my HP G62 open file, using Open Office Calc, in 5 minutes and 35 seconds vs. only 3 seconds using Ms Office Starter 2010).

So I change Issued type in Enhancement
Like 67412. I don't define Duplicate because in my opinion in this example we have some difference with 67412 and may be the solution for bug  67412 don't be sufficient for this bug
Comment 4 Steve Yin 2014-07-28 09:27:06 UTC 
It seems there are no reasons to call <AdjustRowHeight> or <UpdateAllRowHeights> in loading process. Removing these two calls will dramatically improve the loading performance of spreadsheet documents with over 1000 rows.
Comment 5 jsc 2014-07-28 11:18:55 UTC 
can you explain this further, why do you think that there is no need to call this functions. I don't understand it.