Ask Your Question
0

calc suddenly runs very slowly

asked 2017-06-14 18:05:45 +0200

Hillwalker gravatar image

Running Version 5.3.1.2 on a reasonably modern Win 10 machine.

Very recently, data entry into a newly created calc spreadsheet has become very laggy. It takes a couple of seconds for each a cell to open to accept data. Newly entered data takes a few more seconds to appear in the cell. Moving to a new cell leaves the old cell blank for some some seconds before data reappears. Calculations that should be instant take a couple of seconds once the instruction has been entered.

Problem does not exist if I am editing an older existing spreadsheet. Even with old and new spreadsheets open in separate windows I am able to work normally on the old sheet and not the new. Seems to rule out computer problems.

I have tried both upgrading to 5.3.2 and uninstalling and reverting to 5.2.7/ I have tried renaming the App Data user file and seen a new one created. But the problem is persistent. Can anyone help sort it out please?

Any thoughts or guidance please?

edit retag flag offensive close merge delete

Comments

I have exactly the same problem, but it's not confined to newly created documents. I have a spreadsheet created a couple of years ago that behaves in the same way. I add data to it daily, and every day the first cell entry takes a few seconds to register. I've tried re-saving the document with another name but it makes no difference to this behaviour. I'm using LibreOffice version 5.4.1.2 (x64) on Windows 10 Pro, latest version.

pvandck gravatar imagepvandck ( 2017-10-01 02:03:09 +0200 )edit

4 Answers

Sort by » oldest newest most voted
0

answered 2019-06-28 19:49:54 +0200

Ax89 gravatar image

There is also another potential explanation: explosion of conditional formats.

If you have conditional formatting on a cell or row, and you copy or extend it or copy format, another conditional format entries are created. It is trivially easy to go from one row in the conditional format manager to hundreds or thousands of entries. This will make Libre Office run very slowly.

If this is your situation, there are two options:

  • delete all conditional formats

  • edit one conditional format to cover the entire range of cells and delete all the other entries.

edit flag offensive delete link more
0

answered 2018-03-15 12:43:43 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have found the solution:

open calc>tools>options>load/save>VBA propriety, and now uncheck everythings. image description

i solved

Bye

edit flag offensive delete link more
0

answered 2017-11-17 01:41:43 +0200

Manipot gravatar image

For me, disabling the OPENGL worked.

Uncheck Tools/Options/Libre Office/View/Use OpenGL for all rendering

edit flag offensive delete link more

Comments

This produced a large improvement for me.

rkb gravatar imagerkb ( 2017-12-14 07:47:49 +0200 )edit

Huge improvement for me too. Thank you!

Maxfactor gravatar imageMaxfactor ( 2018-03-22 03:03:01 +0200 )edit
0

answered 2017-06-14 23:20:07 +0200

Hillwalker gravatar image

I have found a fix, if not a solution to the problem. Browsing through other similar questions, I found a reference to disabling Java Runtime Environment which is done by unchecking a tick box at the top of the Tools/Libre Office/Advanced dialogue. Having done that the normal spreadsheet options happenn at normal speeds.

But that doesn't explain why the problem has only just appeared, why it affects only newly created spreadsheets or which other Libre Office functions are likely to be degraded by the absence of JRE.

Words of wisdom from one who understands these things would be welcome

edit flag offensive delete link more

Comments

Hello! I am using Libre Office 5.3 and find the Calc application very much slow. Firstly, I tried the suggestion by disabling JRE; which helped just a bit in improvement of speed. Secondly, I tried allocating more memory to the application and each Block, but in vain.

I hope someone may help in resolving the issue. Regards.

Raabi gravatar imageRaabi ( 2017-11-13 18:02:15 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2017-06-14 18:05:45 +0200

Seen: 5,277 times

Last updated: Jun 28