Issue 124022 - OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)
Summary: OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance, regression
: 126169 (view as issue list)
Depends on:
Reported: 2014-01-13 22:46 UTC by Andrea Pescetti
Modified: 2015-03-17 13:36 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample file: elections.xlsx (440.33 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-01-13 22:46 UTC, Andrea Pescetti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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. ***