You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/10/05 22:56:34 UTC
[Bug 123429] New: Calc is unacceptably slow in opening the attached
XLSX file (Cornell)
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Bug ID: 123429
Issue Type: DEFECT
Summary: Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Product: Calc
Version: 3.4.1
Hardware: All
OS: All
Status: CONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: pescetti@apache.org
CC: issues@openoffice.apache.org
The XLSX file available at
http://www.birds.cornell.edu/clementschecklist/download/
takes extremely long to open with OpenOffice 4.0.1.
Some users report that OpenOffice seems to freeze, Rob and me managed to open
the file but we had to wait about 15 minutes with the progress bar stuck at
about 25% (and no particular CPU/RAM usage).
I'll make a copy available for reference.
3.4.1 has a similar behavior.
The issue is discussed here:
http://comments.gmane.org/gmane.comp.apache.openoffice.user/2246
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
--- Comment #7 from Regina Henschel <rb...@t-online.de> ---
Following Microsoft's tip in
http://msdn.microsoft.com/en-us/library/ff726673%28v=office.14%29.aspx#xlMinUsedRange
I can see, that the last used cell is K65536 in the attached document.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #6 from Regina Henschel <rb...@t-online.de> ---
The document does not only contain the rows with real content, but thousands of
rows of the kind
<row r="15" spans="1:11" x14ac:dyDescent="0.25" ><c r="A15" s="4" /></row>
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Andrea Pescetti <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
--- Comment #9 from Andrea Pescetti <pe...@apache.org> ---
Note that 3.3.0 opens the "Cornell" file (Clements Checklist) in <30 seconds,
which is acceptable considering the size, and much different than the 15+
minutes needed on 4.x. Regression.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Andrea Pescetti <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=123919
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Issue 123429] Calc is unacceptably slow in opening the attached
XLSX file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Version|3.4.1 |3.4.0
--- Comment #10 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Additional Info:
----------------
(a) time for opening the document in WIN 7
(a1) Gnumeric 1.12.9: 5s
(a2) LibO 4.2: 4s
(a3) MS Excel Viewer: 4s
(a4) Kingsoft: 4s
(a5) Softmaker FreeOffice: 5s
(b) Already a problem with AOO 3.4.0, I killed the process after 4 minutes
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
giuseppe d'ambrosio <bo...@katamail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |boltthrower@katamail.com
--- Comment #5 from giuseppe d'ambrosio <bo...@katamail.com> ---
Created attachment 81800
--> https://issues.apache.org/ooo/attachment.cgi?id=81800&action=edit
another testcase
1 sheet, 9 rows x 11 cols: opening with excel 2010 takes 0.3 sec.,
while OO takes ~10min.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Armin Le Grand <Ar...@me.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |Armin.Le.Grand@me.com
--- Comment #3 from Armin Le Grand <Ar...@me.com> ---
ALG: Checked, indeed it loads after a loooong time. This would need to be
measured to see if (and what) could be optimized and where the time is spent.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
--- Comment #4 from Armin Le Grand <Ar...@me.com> ---
ALG: Looks as if the 1st part of the load the 69248 strings get read; the long
part after this is actually adding them to the sheet. There seems to be a lot
of processing involved, to get from 'RichStrings' to cell contents. I do not
know much about it (yet)...
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Andreas Säger <vi...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |villeroy@t-online.de
--- Comment #2 from Andreas Säger <vi...@t-online.de> ---
This "spreadsheet" as a first sheet with 107,817 format ranges in 75 unique
format ranges. After removing the formatting overkill the file loads at
acceptable speed.
Nothing to bother about.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Andrea Pescetti <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #81800|0 |1
is obsolete| |
--- Comment #8 from Andrea Pescetti <pe...@apache.org> ---
Comment on attachment 81800
--> https://issues.apache.org/ooo/attachment.cgi?id=81800
another testcase
I moved the "BG8" file and related discussion (comments #5-#6-#7) to
https://issues.apache.org/ooo/show_bug.cgi?id=123919 since it's unclear whether
the root cause is the same.
Let's keep this issue open for the "Cornell" file only.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123429] Calc is unacceptably slow in opening the attached XLSX
file (Cornell)
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123429
Andrea Pescetti <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |performance
Latest|--- |4.0.1
Confirmation on| |
--- Comment #1 from Andrea Pescetti <pe...@apache.org> ---
A copy of the document (just in case the original one is replaced) is available
at
http://people.apache.org/~pescetti/tmp/2013-10-i123429/
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.