Issue 123791

Summary: .ods opens slowly, needs several minutes
Product: Calc Reporter: dsikioa
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: dsikioa, elish, issues, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)Keywords: performance
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
ods version none

Description dsikioa 2013-12-02 08:13:30 UTC 
Just installed AOO 4.0.1. for Linux (RHEL 6.4 64-bit). Computer is Lenovo W530 with 4-core i7, 16GB RAM and plenty of free disk space. I have xlsx-file sized 2.7MB, containing 4 sheets of data and one containing column graphs about data on the other sheets. Biggest sheet has 14000+ lines and 7 columns, others have less lines. With Excel viewer on KVM Windows 7 at the same machine it takes some 2-3 seconds to open that file but AOO 4.0.1 takes 15 minutes and Lotus Symphony 3.0.1 whopping 30 minutes. 

[b]Following formulas used:[/b]
Column A: text like "start" or "stop"
Column B: Date, like 10/19/2013
Column C: Time, like 02:07:57.95
Column D: sum column B and C like "=B828+C828"
Column E: Mostly nothing, for commenting
Column F: =TEXT(D828;"p.k t:mm")
Column G: =ROUND((D829-D828)*$E$1;1)

AutoFilter is ON

Graph type Column, left one from the selection
Graphs data series like $Sheet1'.$F$1:$G$13954
Data series in columns
First row as label selected
First column as label selected

When I save this file to ODS format, size is 1.2MB and opening that file takes less than 5 minutes.
Comment 1 Edwin Sharp 2013-12-02 13:17:12 UTC 
Please attach file.
Comment 2 dsikioa 2013-12-03 06:30:16 UTC 
Created attachment 82033 [details]
ods version

Original xlsx file is too big, so attached is the ods version, which still takes almost 5 minutes to open. If the xlsx version is required, we need to figure out some other way to deploy it, like dropbox
Comment 3 Edwin Sharp 2013-12-03 08:36:36 UTC 
Thank you.

5 minutes 28 seconds to open attachment.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian

Host/Kernel/OS  "aptosidbox" running Linux 3.12-0.slh.3-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]  X.Org 1.14.3  [ 1360x768@60.0hz ]
Processes 124 | Uptime 1:35 | Memory 861.3/3960.1MB | HDD Size 500GB (1%used) | GLX Renderer Gallium 0.4 on AMD CEDAR | GLX Version Yes | Client Shell | Infobash v3.46
Comment 4 Rainer Bielefeld 2014-04-18 07:20:44 UTC 
Currently we only have confirmed problems concerning performance problems to open an .ods. Because this also seems to be a real problem I hijack the report for this problem

(a) Version has been modified erroneous, 
(b) Opening time results (All: on WIN 7)
(b1) OOo 2.0.2:              40s
(b2) OOo 3.1.1              200s
(b3) OOo 3.3.0              150s
(b4) AOo 3.4.1              160s
(b5) AOO 4.1.0 RC3          200s
(b6) LibO 4.2                80s
(b7) Gnumeric 1.12.9          7s    !
     So it seems that Problem appeared with 3.1.1 or more early

(c) Currently we do not know what in the document causes the problems. Amount of data? Formulas? Charts?
 
@dsikioa@hotmail.com
Please send your document to me by email, I will submit a separate bug report for .xlsx related problems (if they do exist).
Comment 5 dsikioa 2014-04-18 22:20:47 UTC 
Email sent with the original xlsx file attached.
Comment 6 Rainer Bielefeld 2014-04-19 06:45:03 UTC 
(b) Opening time results (All: on WIN 7)

                      .odt        .XLSX
----------------------------------------------------
(b1) OOo 2.0.2:        40s        unsupported
(b2) OOo 3.1.1        200s        50% after 13 minutes
(b3) OOo 3.3.0        150s        not tested
(b4) AOo 3.4.1        160s        not tested
(b5) AOO 4.1.0 RC3    200s        50% after 10 minutes
(b6) LibO 4.2          80s        30s
(b7) Gnumeric 1.12.9    7s !!      5s

I will submit a separate issue for .xlsx related problems