Issue 124704 - particular .xlsx document fails to open within acceptable time (unacceptably slow)
Summary: particular .xlsx document fails to open within acceptable time (unacceptably...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All Windows 7
: P3 Major with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance, regression
: 127021 (view as issue list)
Depends on:
Reported: 2014-04-17 18:56 UTC by Mark Brougher
Modified: 2019-07-23 19:15 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Mark Brougher 2014-04-17 18:56:35 UTC
Microsoft has an xls document that shows a matrix of devices that can be used for testing with their Windows Hardware Kit.  As a person who deals with hardware certification, I am forced to open the document to view the data.

The problem is that with OpenOffice, it takes forever to open the document.  It may take hours to open, while opening the same document in Microsoft office 2003 or better just takes a few seconds.

To download the document, please go to this url.

Scroll down and download the "HCK Product Type Test Matrix ".   It will a zip file.

Unzip the file and there you will find the xls file.

Now open the windows-hck-product-type-matrix.xlsx file with OpenOffice.   It will take an extreme amount of time to load the file and at times you will think that it will hang.

Thank you for taking a look a this.  I am attaching the file here also.
Comment 1 Rainer Bielefeld 2014-04-18 06:01:02 UTC
Effect is  Reproducible with "AOO 4.1.0 RC3 – English UI / German locale [AOO410m17(Build:9763))  -  Rev. 1586584 2014-04-11 08:56:50]" on German WIN7 Home Premium (64bit)", “historic” 4. User Profile used for all predecessor versions. Completly fails, I terminated after 30 minutes with 20% Progress Bar.	

Intention "Hardware Certification" of that document is completely unclear, MS Excel Viewer (12.0.6334.50000) 12.0.6514.5000 is unable to open that document, so "takes a a long time" seems not a bad result.

Additional Info:
(a) On my PC (Processor: AMD Athlon 64 Bit 3500+, RAM: 1GB,
    Graphic Card: Nvidia GeForce 7300 LE, Monitor : 1024*768 OS: WIN XP SP3	
    also most other Software has problems to open that document: 
(a1) MX Excel Viewer: does not open document
(a2) GNUMERIC (Error Message: "Not interpretable extension  »ext« has been 
    found in namespace  »{9260A510-F301-46a8-8635-F512D64BE5F5}«"
    Finally opens the document
(a3) King Soft Spreadsheet (
(b) Softmaker FreeOffice opens the document, but Error Message
    "supports only 65000 rows", although document seems to have less rows
(c) LibO 4.2 opens the document, as it seems without bigger problems.
(d) OOo 3.3.0 Opens the document within 1/2 minute, so we have a REGRESSION
Comment 2 Rainer Bielefeld 2014-04-18 06:06:31 UTC
(e) "Stops at 20% progress bar" (with maximum processor load)  is 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
Comment 3 Edwin Sharp 2014-04-18 11:05:18 UTC
Excel 2010: 17 sec
Calc 4.1: can not open

AOO420m1(Build:9800)  -  Rev. 1586681
Win 7
Comment 4 Andre 2014-04-22 07:09:23 UTC
When loading the document with debug support on Windows7 the log messages show lines like:

Error: libxml2 error
Document is empty


Error: libxml2 error
Start tag expected, '<' not found
Comment 5 karko 2017-02-04 13:57:49 UTC
Confirming loading time issue in version 4.1.3 on Windows XP.
Comment 6 karko 2017-02-04 14:06:55 UTC
Seems to be a duplicate of the issue #127021.
Comment 7 oooforum (fr) 2019-07-23 19:15:43 UTC
*** Issue 127021 has been marked as a duplicate of this issue. ***