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/12/26 12:37:10 UTC

[Bug 123919] New: Calc is unacceptably slow in opening the attached XLSX file (BG8)

https://issues.apache.org/ooo/show_bug.cgi?id=123919

            Bug ID: 123919
        Issue Type: DEFECT
           Summary: Calc is unacceptably slow in opening the attached XLSX
                    file (BG8)
           Product: Calc
           Version: 4.0.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: pescetti@apache.org
                CC: Armin.Le.Grand@me.com, boltthrower@katamail.com,
                    issues@openoffice.apache.org, rb.henschel@t-online.de,
                    villeroy@t-online.de

Created attachment 82171
  --> https://issues.apache.org/ooo/attachment.cgi?id=82171&action=edit
Calc is very slow in opening this file

Moving here part of the discussion from
https://issues.apache.org/ooo/show_bug.cgi?id=123429 since it's unclear if the
root cause is the same for both files.

Let's keep this issue open for discussing the BG_8_RdA_RES5.xlsx file only
(reattached to this issue).

Comment #5 giuseppe d'ambrosio 2013-10-23 10:29:04 UTC

Created attachment [reattached here]
another testcase

1 sheet, 9 rows x 11 cols: opening with excel 2010 takes 0.3 sec.,
while OO takes ~10min.

Comment #6 Regina Henschel 2013-10-23 11:31:02 UTC

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>

Comment #7 Regina Henschel 2013-10-23 13:50:26 UTC

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 123919] Calc is unacceptably slow in opening the attached XLSX file (BG8)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123919

--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Additional info:
(a) 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 istuation is even worse, needs 3 Minutes or so to
   open that document, I am not sure whether roots.
(b) Still Reproducible with server installation of "AOO 4.1.0-Dev – English  UI
/
    English locale - [AOO410m1(Build:9750)  -  Rev. 1546757 - 2013-12-02]" 
    on German WIN7 Home Premium (64bit)", own separate user profile.

-- 
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 123919] Calc is unacceptably slow in opening the attached XLSX file (BG8)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123919

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |elish@apache.org

--- Comment #2 from Edwin Sharp <el...@apache.org> ---
Excel 2010      : 1 sec
Gnumeric 1.10.16: 2 sec
Calc 4.1        : 3 min 16 sec 

AOO410m1(Build:9750)  -  Rev. 1551017
Rev.1551017
Win 7
AMD A6 1.50 GHz 4 GB RAM

-- 
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 123919] Calc is unacceptably slow in opening the attached XLSX file (BG8)

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123919

Andrea Pescetti <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |performance, regression
             Status|UNCONFIRMED                 |CONFIRMED
             Latest|---                         |4.0.1
    Confirmation on|                            |
           See Also|                            |https://issues.apache.org/o
                   |                            |oo/show_bug.cgi?id=123429
     Ever confirmed|0                           |1

--- Comment #1 from Andrea Pescetti <pe...@apache.org> ---
Confirmed with 4.0.1: file takes ~70 seconds to open on my system, while
OpenOffice 3.3.0 opens it in <1 second. 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.