Bug 150962 - LibreOffice CALC hangs or crashes on different standard situations without any message ( sorting, saving, fill out fields )
Summary: LibreOffice CALC hangs or crashes on different standard situations without an...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: MacOS-Performance
  Show dependency treegraph
Reported: 2022-09-14 18:00 UTC by Rainer Primosch
Modified: 2023-05-12 04:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

The CALC document with anonymized data (150.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-09-15 15:21 UTC, Rainer Primosch

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Primosch 2022-09-14 18:00:13 UTC
I work with LibreOffice Calc with a sheet.
If i make changes, add a new row odr change a field and i klick save the document, LibreOffice crashes and try to save changes.
Also if i try to sort the data in alphabetical order, LibreOffice also crash often.

The sav data tialog, newer is finished. Si i have to stop LibreOffice immediate.

With the same document i can work on Windows10 without any problem!

The document is a sheet with names, mail adresses and some additional fields.
Only 40 rows of data

The problem occures on 80% of tryes! Had to install OpenOffice again that i can handle that document.

Steps to Reproduce:
1. open a CALC document
2. add some new data in an empty row
3. save the document


1. open a CALC document
2. sort the list in alphabetical order

Actual Results:

LibreOffice crashes and is closing.
LibreOffice try to save the changes, but never will finished.
So had to close the application immidiate.

Expected Results:
Save the file without crashing!
Sorting the file without a crash!

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 20; OS: Mac OS X 12.5.1; UI render: default; VCL: osx
Locale: de-AT (de_AT.UTF-8); UI: de-DE
Calc: threaded
Comment 1 Rainer Primosch 2022-09-14 18:02:23 UTC
It crashed 80-90%, so unfortunately i had to work on the documents with an other application.
Comment 2 Rafael Lima 2022-09-15 14:30:30 UTC
Can you provided a sample file for testing? If it contains personal data, please anonymize the data before submitting it.
Comment 3 Rainer Primosch 2022-09-15 15:21:44 UTC
Created attachment 182468 [details]
The CALC document with anonymized data

With this document LO crashes often on MacOs.
Comment 4 Rainer Primosch 2022-09-15 15:23:34 UTC
I have attached the document and have anonymized the data.
Comment 5 Rafael Lima 2022-09-15 19:57:44 UTC
The file is working fine in Linux (kf5) using:

Version: / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 1:7.4.1~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded

Since you said the file also works in Windows 10, then it seems to be a MacOS-related issue.

Let's wait to see if anyone else using Mac can test it.
Comment 6 Rainer Primosch 2022-09-16 07:46:37 UTC
Yesthe file is working also without Problems on Windows with the actual version of LibreOffice.
I am shure that it is a Mac related issue.
Comment 7 eisa01 2023-03-18 10:15:53 UTC
I actually also had lots of random crashes in Calc too

Using LO 7.5 it is stable for me though

If that doesn't work, Have you tried upgrading and resetting profile?

I was at one point using the App Store version as well, but stopped doing that likely because of this issue (it lags the community edition)

Version: (AARCH64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 10; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 8 Alex Thurgood 2023-05-10 07:31:12 UTC
(In reply to eisa01 from comment #7)
> I actually also had lots of random crashes in Calc too
> Using LO 7.5 it is stable for me though

I'm using LO7512 and still get regular crashes when editing text in a Calc sheet, and often attempting to save, or switching focus.

See my comment 3 in bug 153285. I think that these two are probably the same thing.