OpenOffice hangs on opening large files

Discuss the spreadsheet application

OpenOffice hangs on opening large files

Postby karthick87 » Mon May 21, 2012 11:49 am

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
karthick87
 
Posts: 10
Joined: Mon May 21, 2012 10:08 am

Re: Openoffice hangs on opening large files

Postby RoryOF » Mon May 21, 2012 12:20 pm

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.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14328
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice hangs on opening large files

Postby Hagar Delest » Mon May 21, 2012 12:31 pm

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.
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25074
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: OpenOffice hangs on opening large files

Postby acknak » Mon May 21, 2012 3:11 pm

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.
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17389
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: OpenOffice hangs on opening large files

Postby RoryOF » Mon May 21, 2012 4:06 pm

Try if Gnumeric will open the file.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14328
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice hangs on opening large files

Postby karthick87 » Tue May 22, 2012 6:12 pm

No Fix for this issue? Any way to speed up calc?
OpenOffice version 3.2
karthick87
 
Posts: 10
Joined: Mon May 21, 2012 10:08 am

Re: OpenOffice hangs on opening large files

Postby vasa1 » Tue May 22, 2012 6:31 pm

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 3.5.3.2 on Ubuntu 12.04
vasa1
 
Posts: 254
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 16 guests