Apache OpenOffice (AOO) Bugzilla – Issue 19600
XLS file import freezes OOo
Last modified: 2013-08-07 15:15:02 UTC
The attched file freezes OOO RC4fr and RC3fr at about 10% of loading No problem on RC2, RC1 and 1.0.3 Occurs on Win2k, and linux Linux-log : open("/usr/X11R6/lib/X11/fonts/TrueType/cour.ttf", O_RDONLY) = 30 open("/opt/OpenOffice.org1.1.0/program/libucpdav1.so", O_RDONLY) = 30 --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- --- SIGRTMIN (Real-time signal 0) @ 0 (0) --- Thanks Laurent
Created attachment 9330 [details] this file freezes OOo
I have just tried this on win2k with RC4 and it loads ok. It does take a little time but i see no evidence of it freezing. I am running it against the english (en) version.
also tested this against the fr version on win2k and again it loads ok. So either something has changed on your end or you are trying to open this with reduced resources. Will this document load if you are only running OOo? I will await your confirmation before closing this as WORKSFORME.
I tested it on GNU/Linux with RC4 English and Czech and the load takes about 20 seconds (with UI frozen after about 10%), but the file loads.
I can Reproduce the problem on OpenOffice 1.1 RC4 (default Install, US),quick start off, Win XP Pro Sp1. (And MS Office XP Sp2). It is real problem
Hi, the problem probably is the linked spreadsheet in the file. The subdomain has no DNS entry and therefore could not be resolved. And yes, it takes a lomng time to open but it opens. No freeze so far. Prio is to high, so I correct it. John I assign it to you. If there is a problem with the Excel format, your desk is a good place for it ;-) Frank
*** Issue 19661 has been marked as a duplicate of this issue. ***
yes, I can confirm that this is a problem. It looks like it is caused by the invalid external data stored at an invalid web address http://www.dunton.visteon.com I can re-create it only if i set up an invalid DNS server. I presume that people who re-created it are not using a DNS server. Excel reports this error as an invalid sheet name. Accessing Calc using a correct DNS server will report it as an invalid range. But this looks like a serious regression. I need to pass this on to the correct ownership in order for it to be fixed.
Sorry, I don't understand what you want me to do, John. If the error message from Calc is wrong, I'm obviously not the right person to correct that. If it's the long time that it takes to detect the error, well, you should name that explicitly and assign this issue to abi@openoffice.org.
The issue is that this document *hangs* the application in attempting to resolve an invalid web address. All other info that i supplied is secondary to that fact. My understanding is that the responsibilility for this freezing is the framework component.
added oooqa
I did some more investigation on this. The application does not freeze permanently as I earlier thought with an invalid DNS setting. I got the doc to successfully load in under 10 minutes. This behaviour is not present in 00o1.1Beta2 but apperas to be present in all versions post and including 0Oo 1.1 rc3. I will reassign ownership to Andreas who will shed some light on this.
nothing for ms_interop., so no blocking of 21783, also no crash
ABI->DR: It appears, that despite the fact that the URL is contained only twice in the document, the number of tries to load it is much higher. Since every particular load is timed out, we get an overall very high 'freeze' time. Please have a look at it.
It is an Excel filter issue -> changed component to Spreadsheet accepted & started
Fixed. Filter does not try to access external documents anymore while loading a file.
back to QA
reset resolution to fixed
verified in internal build cws_calc18
Fix available in developer snapshot OOo680m38