Apache OpenOffice (AOO) Bugzilla – Issue 123791
.ods opens slowly, needs several minutes
Last modified: 2014-04-19 06:45:03 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.
Please attach file.
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
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
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).
Email sent with the original xlsx file attached.
(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