LIbreOffice calc from the version 5.2 are very slow.
In big spreadsheet this is not very comfortable.
Any Ideas?
Regards Jacek
Do you have a lot of search functions like VLOOKUP(), MATCH()?
no - I don’t use this functions.
Which operating system and version are you running LibreOffice on?
You seem to be experiencing what I describe here. Have a look to see. I have come across several concerns for operating speed but they are not coordinated and none seem to get attention. If all our concerns are related, maybe this is a bigger problem.
Yes, this is the same poblem
For me, disabling the OPENGL worked.
Uncheck
Tools/Options/Libre Office/View/Use OpenGL for all rendering
This worked for me as well. Calc was extremely slow, even with a blank spreadsheet open. Disabling OpenGL causes the program to run normally.
Just resolved my same issue completely. If you do a custom install instead of the typical try uninstalling then reinstall using the typical option. That may clear it up. If not everything i did was uninstalled x64 custom install; installed x86 typical install; uninstalled; installed x64 typical. Was like night and day in performance. Seems either something doesn’t get installed or the ui is looking for something in the languages i had unchecked for a leaner install.
I turned off Tools => Options => LibreOffice => View => “Graphics Output” => “Use anti-aliasing”. And also changed another values to “Small”.
I restarted LibreOffice and now my Calc table is quiet fast.