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: https://issues.apache.org/ooo/show_bug.cgi?id=123429
Issue Type: DEFECT Latest Confirmation in: 4.0.1
Developer Difficulty: ---
Attachments:
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 https://issues.apache.org/ooo/show_bug.cgi?id=123429 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 http://msdn.microsoft.com/en-us/library/ff726673%28v=office.14%29.aspx#xlMinUsedRange 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
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.