LO Calc hangs saving large xlsx files [closed]

asked 2018-12-26 21:53:49 +0100

euphrates gravatar image

updated 2020-10-20 11:47:17 +0100

Alex Kemp gravatar image

I have problems working with LO Calc on large (10-40MB) spreadsheets. The spreadsheets contain large amounts of text (few thousands of news article texts, each in one cell). It takes a very long time to save them, copying large numbers of cells to clipboard causes calc to freeze completely, and I end up having to force quit. Both actions also cause the soffice.bin CPU usage to spike to %100. MEM use also hit 100%, though more gradually. Even navigating between cells can at times cause hangs. I have a fairly modern laptop with an ssd drive and no performance issues otherwise. I used to have the same issue in LO v.5.3.x in the past and upgrading to v.6 seemed to improve the situation somewhat. But it is back to debilitating levels now after a clean OS install with the LO version packed with the distro. I'm sorry if this is a duplicate. I'm aware that similar issues have been brought up in various forums in the past but the ones I've seen are closed without a solution. Many thanks in advance for any help. (current LO V.6.0.7.3. OS:Linux Mint 19)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 14:51:40.906066

Comments

Does it happen also saving it in .ods format?

Tyco72 gravatar imageTyco72 ( 2019-02-22 09:00:32 +0100 )edit