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)
Status: CONFIRMED
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:
URL:
Keywords: performance, regression
: 126169 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
Sample file: elections.xlsx (440.33 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-01-13 22:46 UTC, Andrea Pescetti 		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 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. ***