Page 1 of 1
OpenOffice hangs on opening large files
Posted: Mon May 21, 2012 11:49 am
by karthick87
We are running linux in almost all the systems. Where we are getting more no of complaints on openoffice saying it gets hang on opening large files. Files which are bigger than 30MB is not getting opened in openoffice. Is there a wat to fix it?
Note: I am able to open the same file in MS office with in a second.
Re: Openoffice hangs on opening large files
Posted: Mon May 21, 2012 12:20 pm
by RoryOF
In which format are these files saved? It is advisable to work always in .ods format, saving out to .xls format only when necessary.
Re: OpenOffice hangs on opening large files
Posted: Mon May 21, 2012 12:31 pm
by Hagar Delest
If you're still running 3.2, can you upgrade to latest AOO 3.4?
What OS exactly BTW? You should add it to your forum signature.
Re: OpenOffice hangs on opening large files
Posted: Mon May 21, 2012 3:11 pm
by acknak
The architectural constraints have been removed in recent versions of Calc, but the design problems have not been addressed. In my (few) tests, Calc is nearly unusable with large files. Even a simple table with 100k rows is terribly slow, especially with loading and saving, and the temporary files required are huge: a hundred-fold larger than the input file.
I'd expect that a 30Mb file is simply not going to work: there just isn't enough time, memory and disk space.
Re: OpenOffice hangs on opening large files
Posted: Mon May 21, 2012 4:06 pm
by RoryOF
Try if Gnumeric will open the file.
Re: OpenOffice hangs on opening large files
Posted: Tue May 22, 2012 6:12 pm
by karthick87
No Fix for this issue? Any way to speed up calc?
Re: OpenOffice hangs on opening large files
Posted: Tue May 22, 2012 6:31 pm
by vasa1
karthick87 wrote:No Fix for this issue? Any way to speed up calc?
Did you not read the posts above? The only fix I can think of is to reorganize things into smaller files until a "fix" is available. I'm not using OO.o right now but LibreOffice is no better.