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 2014/01/13 23:46:41 UTC

[Bug 124022] New: OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

            Bug ID: 124022
        Issue Type: DEFECT
           Summary: OpenOffice is unacceptably slow in opening the
                    attached file (elections.xlsx)
           Product: Calc
           Version: 3.4.1
          Hardware: All
                OS: All
            Status: CONFIRMED
          Keywords: regression
          Severity: normal
          Priority: P3
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: pescetti@apache.org
                CC: issues@openoffice.apache.org

Created attachment 82273
  --> https://issues.apache.org/ooo/attachment.cgi?id=82273&action=edit
Sample file

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.

-- 
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 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

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

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

--- Comment #1 from Edwin Sharp <el...@apache.org> ---
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

-- 
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 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #82273|Sample file                 |Sample file: elections.xlsx
        description|                            |

-- 
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 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |performance

-- 
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.

[Issue 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rainerbielefeld_ooo_qa@biel
                   |                            |efeldundbuss.de
            Version|3.4.1                       |3.4.0

--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
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.

-- 
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 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

--- Comment #2 from Edwin Sharp <el...@apache.org> ---
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.

-- 
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 124022] OpenOffice is unacceptably slow in opening the attached file (elections.xlsx)

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

--- Comment #4 from Edwin Sharp <el...@apache.org> ---
I would never use any spreadsheet program for processing such amount of data.
Statistics? SPSS, Minitab...
Data analysis? Matlab, Maple...

Why punish the housewives?

-- 
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.