Libreoffice Calc is slowing down when working with big cells

[João Gabriel]

I'm experiencing Libreoffice Calc slowing down when working with large cells.

My file in libreoffice calc is a little bit worked out, with more than 10 spreadsheets, with formulas and automatic formatting. Not too complex, but with some details.

In one of the spreadsheets, I have large cells, almost 20, with more than 10 lines in each cell.

In this spreadsheet, libreoffice calc becomes too lazy. When I click one of this big cells, it takes almost 10 seconds to select it.

When I close and reopen it, it becomes fast again, but just for some time. After some use, it's slows down again.

I have the costume to suspend my computer with my spreadsheet opened. The problem can be related to suspend/awake process, but I don't have any evidence in this sense.

I have tried some solutions:

- Reinstalled libreoffice from Ubuntu Repository
- Checked my video card instalation (somebody said that could be lack of OpenGL support)
- Installed last version from ppa:libreoffice/ppa

None of those solved it.

My system details are:

- Ubuntu 16.04 LTS
- Libreoffice Version: 5.1.6.2

Along with that, Libreoffice is crashing without giving any evidence of what cause it and without reporting the error.