Issue 112705 - Spreadsheet hangs with "Adapt row height" when opening XLS
Summary: Spreadsheet hangs with "Adapt row height" when opening XLS
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m18
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2010-06-25 17:46 UTC by j4m0
Modified: 2014-08-25 17:11 UTC (History)
5 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---

Attachments
Report with opening problem (freezes at "Adapt row height") (122.58 KB, text/plain)
2010-06-25 17:47 UTC, j4m0 		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 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.