Ask Your Question
0

Calc start-up times of larger files [closed]

asked 2014-05-01 11:50:21 +0200

Dwelle gravatar image

updated 2015-09-07 00:48:02 +0200

Alex Kemp gravatar image

Hi,

I'm trying to open moderately sized files (~5MB), and it takes around 4 minutes just to open them. I tried versions 4.1.5.3 and 4.2.3.3, no difference.

I'm running on Windows 7, 8 GB RAM, quad core intel i5 4GHz. Files and LibreOffice Calc both from SSD.

I've read few threads here and there mentioning similar problems with no solution. Is this issue being worked on, or anything I can do to speed up the process?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-21 20:10:26.420742

Comments

Hi @Dwelle, please what is the OS, the file format, saving in a network, links to extarnal files/places?

m.a.riosv gravatar imagem.a.riosv ( 2014-05-01 13:28:08 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-05-01 13:10:02 +0200

Pedro gravatar image

The slowness is due to the way Calc handles/distributes calculations by the cores/threads. There was a major rewrite of the Calc code so 4.1 and newer are faster than previous versions but still it is nowhere near Excel (or even Gnumeric)...

You can try increasing the memory available for LibreOffice: go to Tools > Options then under Libreoffice choose Memory and increase Graphics cache to 128Mb and the Memory per object to 20Mb These are some values I got from here

In the same page and comments you can see other tips to accelerate LibreOffice in general, but maybe don't make such a difference to the Calc problem...

Maybe someone else answering this post knows how to optimize this values (based on the user PC specs)or other tips to speed up calculations

edit flag offensive delete link more

Comments

I've gone through the site you posted and did everything, even trying disabling Java, but nothing really helped :/

Dwelle gravatar imageDwelle ( 2014-05-01 13:33:22 +0200 )edit

@Dwelle, I didn't expect it to make such a difference since the real problem is the core/thread data/calculation distribution... LO (and AOO) have inherited code from StarOffice which was created in the single CPU days... I think you need to wait for the next major rewrite :)

Pedro gravatar imagePedro ( 2014-05-01 13:40:14 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-05-01 11:50:21 +0200

Seen: 327 times

Last updated: May 01 '14