OpenOffice hangs on opening large files

Discuss the spreadsheet application
Locked
karthick87
Posts: 10
Joined: Mon May 21, 2012 10:08 am

OpenOffice hangs on opening large files

Post 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.
OpenOffice version 3.2
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Openoffice hangs on opening large files

Post 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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: OpenOffice hangs on opening large files

Post 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.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: OpenOffice hangs on opening large files

Post 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.
AOO4/LO5 • Linux • Fedora 23
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice hangs on opening large files

Post by RoryOF »

Try if Gnumeric will open the file.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
karthick87
Posts: 10
Joined: Mon May 21, 2012 10:08 am

Re: OpenOffice hangs on opening large files

Post by karthick87 »

No Fix for this issue? Any way to speed up calc?
OpenOffice version 3.2
vasa1
Volunteer
Posts: 261
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: OpenOffice hangs on opening large files

Post 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.
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
Locked