I have moved to LibreOffice from Microsoft Office, basically because I refuse to pay the Price for Microsoft Office.
I like LibreOffice as it offers everything I need and does pretty much the same job as Microsoft Office.
I find though that it is no where near as fluent. I use Excel/Calc for keeping my website Stock up to date and upload it to my Site as a CSV.
I find when I am quickly trying to scan through the spreadsheet to find a particular product it has a massive lag and keeps freezing, where as in Excel I could scroll right through without any issues.
Is there something I should do in order to aid with the performance and combat this issue? I have noticed other issues, which are similar, such as saving, if I save a large document, it seems to save ok the first time but then if I make another change and need to save, it can take several minutes for the save to complete as the program stops responding, and on occasions it can stop responding for so long that I need to restart it.
I am now using Linux Mint but it was the exact same in Windows. I have around 1500 cells each using a VLookup.
Has anyone had similar issues and know any ways in order to make the performance slightly smoother?
I submitted an answer below which seemed to work but only for one day. As soon as I turned my computer on the next day it was back to the same old lag... The settings are all the same as they where when I ammended them.
Is there anything else I can try? or any other Office suites that might work better?