Apache OpenOffice (AOO) Bugzilla – Issue 124704
particular .xlsx document fails to open within acceptable time (unacceptably slow)
Last modified: 2019-07-23 19:15:43 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. http://msdn.microsoft.com/library/windows/hardware/dn423132.aspx 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.
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 (9.1.0.4514): (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 here.
(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
Excel 2010: 17 sec Calc 4.1: can not open AMD A6 1.5GHz 4GB RAM AOO420m1(Build:9800) - Rev. 1586681 Rev.1586681 Win 7
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
Confirming loading time issue in version 4.1.3 on Windows XP.
Seems to be a duplicate of the issue #127021.
*** Issue 127021 has been marked as a duplicate of this issue. ***