Ask Your Question

How can I make LibreOffice multi-threaded

asked 2016-05-11 06:08:39 +0100

miklcct gravatar image

LibreOffice is very slow. Even a simple operation on my spreadsheet, such as deleting sheets, takes more than 10 minutes of 100% CPU core usage, completely frozen in process. I cannot even do anything to my other opened documents.

However, it only uses one core. Is it possible to make LibreOffice uses another thread on my different documents such that I can work on those when doing time consuming operations in a document?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-05-11 13:23:43 +0100

petermau gravatar image

updated 2016-05-11 13:25:04 +0100

There are a number of performance issues with regard to calc, I do not believe that multi-threading is the problem. It would help to give more details of the problem, for example: version of LibO, operating system, size of spreadsheet, type of spreadsheet, is it a normal .ods or some other type like .xls or .xlsx. Has the problem just starting after changing levels of LibO? If it is a large spreadsheet, have you enough memory set? (tools > options >memory) Sometimes there is a problem with anti-aliasing and other graphics settings ( tools >options > view > graphics)

There are a number of questions already about calc performance, and some known bugs. With more details, someone may well be able to help your annoying problem..Peter

edit flag offensive delete link more


They are .ods files which contains tens of thousands of formulae with indirect references where the user can type in the sheet names into a specified cell in order to fetch data from that sheet.

miklcct gravatar imagemiklcct ( 2016-05-11 17:57:09 +0100 )edit

Tens of thousands of formulas using INDIRECT will slow things down, as there are no known cells or ranges that could be listened to for changes each of those formula cells has to be recalculated on every input.

erAck gravatar imageerAck ( 2018-02-27 16:28:06 +0100 )edit

The problem @erAck mentioned is also present in sheets containing lots of formulae calling OFFSET().
The only way I know to go round the problem is to temporarily switch off the AutoCalculate option.

Lupp gravatar imageLupp ( 2018-07-18 11:50:07 +0100 )edit

shouldn't we make @erAck's and @Lupp's comment an answer and check it 'solved'?

newbie-02 gravatar imagenewbie-02 ( 2020-10-04 08:16:44 +0100 )edit

answered 2020-10-04 05:37:10 +0100

updated 2020-10-04 06:24:42 +0100

To resolve this challenge in part, if possible, upgrade to LibreOffice version 6 or 7 or more recent. Which support multi-threaded calculation.

Steps to activate multi-threaded calculation:

  1. Using LibreOffice 6 Calc, navigate to Tools->Options ->LibreOffice Calc
  2. Click on Calculate
  3. Under CPU threading settings, check the box next to Enable multi-threaded calculation
  4. Click on OK button image description

Below is the same answer as above. But with details if you're interested in those. Starting with version 6, LibreOffice now support some multi-threads.

edit flag offensive delete link more

answered 2018-02-27 13:41:41 +0100

Agustín gravatar image

updated 2018-02-27 13:42:27 +0100

I have the same problem,

  • Problem description: Libreoffice uses only one CPU out of many when convert, concat, insert fields in odt documents, I use Unoruntime

  • Installation: Libreoffice 4.4

Java version "1.7.0_91" OpenJDK Runtime Environment (IcedTea 2.6.2) (suse-21.2-x86_64) OpenJDK 64-Bit Server VM (build 24.91-b01, mixed mode)

SUSE Linux Enterprise Server 12 SP1 (x86_64)

  • Current behavior: it work very slowly, uses one CPU core at 100% percent, and doesn't use rest CPU cores. This behavior is in linux and windows systems.

  • Expected behavior: Libreoffice will use all avalable CPU.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-11 06:08:39 +0100

Seen: 7,994 times

Last updated: Oct 04