Calc keeps hanging and crashing (provisional)

English
#1

Hi

I’ve been having serious problems with Calc for a while now. As I need it more frequently I need to do something about it.

This is the issue:
When spreadsheets have a moderate number of rows (say 500) Calc often hangs. This happens most often when I save, and when I sort or filter data. I then get a pop-up informing me Calc is not responding. It takes 30 seconds or more for the pop-up to disappear.

With a large number of rows this happens more frequently, but 1 time in 2 the system doesn’t recover and just crashes.

I work on a recent Dell xps 13 (32 GB memory)
Ubuntu 24.04.2 LTS
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4

Any suggestions on where I could start looking for the cause of the problem would be greatly appreciated.

Thank you.
sample.ods (365.8 KB)

#2

could you provide a sample .ods file ?

like what ? average?

  1. Safe Mode
  2. https://askubuntu.com/questions/437437/gui-performance-monitor-tool
Writer freezes opening documents with external images created in MS Word
#3

Hi
I’ve added a sample file to the original post.

It’s probably not every single time, although it feels like that. I realise that is not relevant. I’ve edited the original post. I’ll start monitoring more closely and also keep the monitoring tool open while working with calc.

Waiting time is about 30 seconds for documents with 1000 to 2000 rows.
For larger documents it is more if it happens at all.

#4

thanks for following up :+1:

#5

I see two issues that could be impacting performance.

  • Excessive cell formatting.
    Delete all columns starting with U and all rows starting with 5001.
  • Display page breaks.
    Menu / Tools / Options / LibreOffice Calc / View, Visual Aids. Uncheck Page breaks.
#6

Hi. I’m having the same issue and I don’t know what gives.

Computer 1 (desktop) LO 7.4.7.2 running on LMDE 6 (Linux Mint) > crashing

File contents

  1. 20,000 rows
  2. conditional formatting
  3. It crashes when I a) select the rows and columsn and b) click on Sort c) after a few seconds it crashes
  4. This started about 3 weeks ago

Computer 2 (laptop) LO 7.4.7.2, LMDE 6

  1. Identical software setup and no issues, and I can sort this large dataset.

Computer 3 (laptop): LO 25.2.3.2 on LMDE 7

For good measure, I tried on a third computer and had no issues.

The file I’m working with has a lot of personal information (budget/finances) and it’s not possible to share it.

I’m not sure why it crashes on one instance and works without issues on another.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.