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.
OpenOffice hangs on opening large files
-
- Posts: 10
- Joined: Mon May 21, 2012 10:08 am
OpenOffice hangs on opening large files
OpenOffice version 3.2
Re: Openoffice hangs on opening large files
In which format are these files saved? It is advisable to work always in .ods format, saving out to .xls format only when necessary.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
- Hagar Delest
- Moderator
- Posts: 32666
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: OpenOffice hangs on opening large files
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.
What OS exactly BTW? You should add it to your forum signature.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: OpenOffice hangs on opening large files
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.
I'd expect that a 30Mb file is simply not going to work: there just isn't enough time, memory and disk space.
AOO4/LO5 • Linux • Fedora 23
Re: OpenOffice hangs on opening large files
Try if Gnumeric will open the file.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 10
- Joined: Mon May 21, 2012 10:08 am
Re: OpenOffice hangs on opening large files
No Fix for this issue? Any way to speed up calc?
OpenOffice version 3.2
Re: OpenOffice hangs on opening large files
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.karthick87 wrote:No Fix for this issue? Any way to speed up calc?
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)