Bug 153285 - EDITING: Constant crashing in CALC (macOS AARCH64?)
Summary: EDITING: Constant crashing in CALC (macOS AARCH64?)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Crash
  Show dependency treegraph
 
Reported: 2023-01-30 23:19 UTC by byl sottile
Modified: 2024-10-01 14:48 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Screen snapshot of LibreOffice crash logs in the /Applications/Utilities/Console application (1.11 MB, image/png)
2023-11-24 15:34 UTC, Patrick (volunteer)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description byl sottile 2023-01-30 23:19:25 UTC
Description:
Once started, Calc (office) will work, then start to slow down like it's waiting to react to keystrokes, it gets slower and slower, then finally crashes after freezing.

This has happened with the last 8 sessions, I rebooted my system.. previous versions have never done this.

Responsiveness is really bad, when this happens.. I think you broke something.
Byl S
Oregon


Steps to Reproduce:
1.run it and make about 50 changes.. mostly creating colors and merging/unmerging cells
2.
3.

Actual Results:
after a while, it slows down, then crashes, the responsiveness from keystroke to response gets longer and longer till it crashes.


Expected Results:
Not doing this


Reproducible: Always


User Profile Reset: Yes

Additional Info:
I will try ONE more update.. then I may have to go back to EXCEL I have too much work relying on this product.  thanks in advance
Comment 1 byl sottile 2023-01-30 23:19:51 UTC
Please fix..
Comment 2 Julien Nabet 2023-01-31 07:55:38 UTC
On which env are you? (Linux, macOS, Windows)
You can try to upgrade to 7.4.5 + try https://wiki.documentfoundation.org/QA/FirstSteps

Now if you've got msOffice, don't hesitate to use it if it can help you.
Comment 3 Alex Thurgood 2023-05-10 07:23:33 UTC
I can confirm constant crashing with Calc typing, or copy-pasting multi-line text into a cell, then switching out to another cell.

I don't see a slowdown beforehand though.

The crashing occurs seemingly after a number of edits and then a focus switch.

Version: 7.5.1.2 (AARCH64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 8; OS: Mac OS X 13.3.1; UI render: Skia/Raster; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

To me, this seems related to the lazy redraw of the cell display, so could be a scheduling issue (again), similar to the ones Patrick fixed previously.
Comment 4 Stéphane Guillou (stragu) 2023-05-10 16:03:51 UTC
(In reply to Alex Thurgood from comment #3)
> Version: 7.5.1.2 (AARCH64) / LibreOffice Community

Do you still see it in 7.5.3 ?
Comment 5 Alex Thurgood 2023-05-12 04:03:36 UTC
@Stéphane : I haven't tested with 7.5.3 yet.

It could be linked to bug 146626, as I was using an external Thunderbird monitor connected to my MBPro (mirroring).
Comment 6 Alex Thurgood 2023-05-12 04:07:16 UTC
Here's how I can generally get Calc to crash.

Copy-paste a multiline text passage into a Calc cell. Try and change the default cell positioning from mid to upper, and then set justification to left via the toolbar buttons.

Either when setting left justification, or moving the mouse to click on the Save button, is when the crash occurs.

If I save the changes via the CMD-S keyboard shortcut when the mouse cursor is still in the cell and actively flashing, the crashes don't occur as often.

The crashes seem to occur when I leave the cell and attempt to set an attribute via one of the toolbar buttons, or save the sheet.
Comment 7 Alex Thurgood 2023-05-12 04:10:59 UTC
(In reply to Alex Thurgood from comment #3)


> I don't see a slowdown beforehand though.

Whilst experiencing these crashes again yesterday, I did notice a slowdown after a number of edits.
Comment 8 Stéphane Guillou (stragu) 2023-05-12 12:00:40 UTC
I could not crash it, using:

Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

nor with:

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 2; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Would be good to know the version information from byl sottile.

Alex, any chance you can try and collect a backtrace, and/or do a bibisection?
Comment 9 Julien Nabet 2023-05-13 14:36:56 UTC
On pc Debian x86-64 with master sources updated today, I don't reproduce this.

Since byl didn't respond but Alex provided quite some information, let's consider it may be macOS only.

Patrick: thought you might be interested in this one
Comment 10 Patrick (volunteer) 2023-05-13 14:56:15 UTC
(In reply to Julien Nabet from comment #9)
> Patrick: thought you might be interested in this one

Can anyone attach a crash log?
Comment 11 Patrick (volunteer) 2023-05-17 15:06:53 UTC
(In reply to Patrick Luby from comment #10)
> 
> Can anyone attach a crash log?

If you see the Recovery dialog when it crashes, can you take a sample using the Activity Monitor application before you click on any of the dialog's buttons is as good as a crash log.
Comment 12 Patrick (volunteer) 2023-11-24 15:34:05 UTC
Created attachment 191022 [details]
Screen snapshot of LibreOffice crash logs in the /Applications/Utilities/Console application
Comment 13 Patrick (volunteer) 2023-11-24 15:36:23 UTC
(In reply to Patrick Luby from comment #12)
> Created attachment 191022 [details]
> Screen snapshot of LibreOffice crash logs in the
> /Applications/Utilities/Console application

I forgot to mention that you can find the crash logs for recent crashes in the /Applications/Utilities/Console application. Attachment 191022 [details] shows a screen snapshot of the LibreOffice crashes on my machine where I have selected the newest "soffice" (i.e. LibreOffice) entry and selected the details of the crash log.

Hope that helps.
Comment 14 steve 2024-09-23 10:08:07 UTC
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 854d4e6e6a98688118a71357ba1171218f6e64f3
CPU threads: 4; OS: macOS 14.7; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Not able to reproduce. There were many fixes in regards to re-drawing sheets in calc on macOS. Setting to worksforme.

Would be great if others could also re-test this and confirm whether main no longer exposes the problematic behavior or not.
Comment 15 ady 2024-09-23 17:18:34 UTC
@Steve,

I am re-setting this report to NEW, because you have not mentioned that you were able to reproduce the original problem with an older version. The fact that you cannot reproduce (with whichever version) does not mean that the problem is no longer there. Someone that is/was able to reproduce the problem before has to be able to report that the problem is (somehow, with some yet-to-be-known commit) solved.

If anyone can verify _both_ cases with relevant versions – even better if that someone is the OP – please set the report to WORKSFORME.
Comment 16 Buovjaga 2024-09-23 18:07:24 UTC
byl, Alex: please re-test.
Comment 17 Alex Thurgood 2024-10-01 14:48:12 UTC
Not seeing this currently with:

Version: 24.2.5.2 (AARCH64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: macOS 14.6.1; UI render: Skia/Raster; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded