1

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.

Improve this question
11
  • 2
    How much RAM do you have? And how much does top or htop say libreoffice is using? (It may be soffice.bin)
    – Joe P
    Commented Jun 14, 2017 at 16:20
  • I have 8GB and now it's using 2,1 GB, but it's working well right now. I'll check it when it starts slowing down.
    – João Gabriel Del Solar
    Commented Jun 14, 2017 at 19:38
  • 8GB of RAM should be plenty, but on the other hand 2.1GB being used by Libreoffice seems a lot to me. The slowdown could be caused by swapping, which is what I was thinking about. Run vmstat 5 (where 5 indicates to update every 5 seconds) and keep an eye on the swap si and so columns. If they stay at 0 the problem isn't swapping, but if they increase when LO is being slow, that's the problem
    – Joe P
    Commented Jun 14, 2017 at 20:33
  • @JoeP Now I could check it. It isn't using swap. Now it takes 863 MB and is presenting a slowdown.
    – João Gabriel Del Solar
    Commented Jun 19, 2017 at 15:31
  • Can you tell if it is CPU-bound? In top or htop does Libreoffice use all available CPU when in slowdown? Also what happens to the Load: value?
    – Joe P
    Commented Jun 20, 2017 at 23:35

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .