Issue 124022

Summary: OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)
Product: Calc Reporter: Andrea Pescetti <pescetti>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, org-apache, rainerbielefeld_ooo_qa
Version: 3.4.0Keywords: performance, regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample file: elections.xlsx none

Description Andrea Pescetti 2014-01-13 22:46:41 UTC
Created attachment 82273 [details]
Sample file: elections.xlsx

The attached XLSX file takes extremely long (25 minutes) to open.

Once opened, it can be saved in a few seconds in ODS format, and the ODS file can be opened in a few seconds too.

Regression with respect to 3.3.0, that opens the same file reasonably fast.
Comment 1 Edwin Sharp 2014-01-14 06:55:53 UTC
4 minutes 47 seconds to open.

AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657

Host/Kernel/OS  "aptosidbox" running Linux 3.12-4.slh.1-aptosid-amd64 x86_64 [ aptosid 2013-01 Ἑσπερίδες - kde-lite - (201305050307) ]
CPU Info        2x AMD Athlon II X2 250 clocked at [ 1800.000 MHz ]
Videocard       Advanced Micro Devices, [AMD/ATI] Cedar [Radeon HD 5000/6000/7350/8350 Series]     [  ]
Processes 113 | Uptime 1:45 | Memory 474.1/3960.1MB | HDD Size 500GB (8%used) | Client Shell | Infobash v3.46
Comment 2 Edwin Sharp 2014-01-14 07:04:16 UTC
IMHO we should undo the 1M rows change - useless for 99.99% of users.
I prefer a fast 65K rows spreadsheet over a sluggish 1M rows spreadsheet.
Comment 3 Rainer Bielefeld 2014-04-18 06:27:05 UTC
To be honest: I think Comment 2 is a crazy idea. Spreadsheets are not only used by housewives for creating grocery store shopping lists. For statistics, data logging analysis and similar 1 million rows is not very much ... No week where I don't need more than 65000 rows

Already reproducible with 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: at 30% progress bar opening process seems to stop.
Comment 4 Edwin Sharp 2014-04-18 07:29:32 UTC
I would never use any spreadsheet program for processing such amount of data.
Statistics? SPSS, Minitab...
Data analysis? Matlab, Maple...

Why punish the housewives?
Comment 5 oooforum (fr) 2015-03-17 13:36:48 UTC
*** Issue 126169 has been marked as a duplicate of this issue. ***