Issue 123919

Summary: Calc is unacceptably slow in opening the attached XLSX file (BG8)
Product: Calc Reporter: Andrea Pescetti <pescetti>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: Armin.Le.Grand, boltthrower, elish, issues, rb.henschel, villeroy
Version: 4.0.0Keywords: performance, regression
Target Milestone: ---   
Hardware: All   
OS: All   
See Also:
Issue Type: DEFECT Latest Confirmation in: 4.0.1
Developer Difficulty: ---
Description Flags
Calc is very slow in opening this file none

Description Andrea Pescetti 2013-12-26 11:37:10 UTC
Created attachment 82171 [details]
Calc is very slow in opening this file

Moving here part of the discussion from since it's unclear if the root cause is the same for both files.

Let's keep this issue open for discussing the BG_8_RdA_RES5.xlsx file only (reattached to this issue).

Comment #5 giuseppe d'ambrosio 2013-10-23 10:29:04 UTC

Created attachment [reattached here]
another testcase

1 sheet, 9 rows x 11 cols: opening with excel 2010 takes 0.3 sec.,
while OO takes ~10min.

Comment #6 Regina Henschel 2013-10-23 11:31:02 UTC

The document does not only contain the rows with real content, but thousands of rows of the kind
<row r="15" spans="1:11" x14ac:dyDescent="0.25" ><c r="A15" s="4" /></row>

Comment #7 Regina Henschel 2013-10-23 13:50:26 UTC

Following Microsoft's tip in I can see, that the last used cell is K65536 in the attached document.
Comment 1 Andrea Pescetti 2013-12-26 11:44:48 UTC
Confirmed with 4.0.1: file takes ~70 seconds to open on my system, while OpenOffice 3.3.0 opens it in <1 second. Regression.
Comment 2 Edwin Sharp 2013-12-26 12:48:32 UTC
Excel 2010      : 1 sec
Gnumeric 1.10.16: 2 sec
Calc 4.1        : 3 min 16 sec 

AOO410m1(Build:9750)  -  Rev. 1551017
Win 7
AMD A6 1.50 GHz 4 GB RAM
Comment 3 Rainer Bielefeld 2013-12-26 12:53:21 UTC
Additional info:
(a) server installation of  "AOO 3.4.0 – German UI / German locale 
   [AOO340m1(Build:9590) - Rev.1327774]" on German WIN7 Home Premium (64bit)", 
   own separate user profile istuation is even worse, needs 3 Minutes or so to
   open that document, I am not sure whether roots.
(b) Still Reproducible with server installation of "AOO 4.1.0-Dev – English  UI /
    English locale - [AOO410m1(Build:9750)  -  Rev. 1546757 - 2013-12-02]" 
    on German WIN7 Home Premium (64bit)", own separate user profile.