LibreOffice 7.2 and 7.3 freeze/crash editing macOS Calc Spreadsheets

English
, ,
#1

Ever since updating to 7.2 (and also with 7.3), LibreOffice routinely freezes when editing in Calc Spreadsheets. The app becomes unresponsive and I get the spinning beachball. I’ve left it for 30 minutes with no resolution.

This seems to perhaps happen more frequently after pasting data from one open sheet to another, though I can’t say for sure. I can say that it happens frequently enough that if I don’t Command-S every 30 seconds, I will lose data almost certainly.

Rolling back to 7.1 resolves this.

I have this issue on both M1 and Intel Macs, all running Mojave.

#3

I have not noticed any extra instability using LO 7.2.5 on a MacBook Air with Catalina (release right after Mojave), for what that is worth.

#10

Hello community,

i hope it’s o.k. to reply to this “old” post, but this way the assumed context of my problem gets apparent.
I have the exact same experience as DaveHamilton:
no problems with 7.1.8,
but any release afterwards up until 7.4.2.3 causes the same problem for Calc on MacOS Catalina. Notebook is INTEL, Catalina is latest release.
I literally tested any intermediate Office release.
Each test of different release prepared by erasing all preference files, cache files etc.
Also: tried with “No Java”, “Java 8”, “Java 11”, “Java 17”, because i had JAVA related problems with Base.

I always use a non administrative account, therefore also tested this with LibreOffice installed to my localuser account (alternative to the administratively installed LibreOffice), but that did not change the problem.
It is super difficult to reproduce, i was not able to observe any pattern.
But it rarely takes more then 1 hr to occur.
Definitely for me it is not triggered by clipboard activities.
Sometimes it’s just clicking to a different cell, and the application gets unresponsive.
Waiting for the application to recover does not help, i always have to kill it.

I’d be super glad if there would be a fix, since i try to have LibreOffice be my only office solution.
If there is a debugging mode or other options to generate log files, i’d be happy to provide any evidence data.
From the MacOS logs so far i see nothing that looks related, unless someone would tell me what to look for?

#11

In the meantime i eventually managed to obtain any background information after Calc hangs again, which is:

Sampling process 4196 for 3 seconds with 1 millisecond of run time between samples
Sampling completed, processing symbols...
Analysis of sampling soffice (pid 4196) every 1 millisecond
Process:         soffice [4196]
Path:            /Applications/LibreOffice.app/Contents/MacOS/soffice
Load Address:    0x106ef7000
Identifier:      org.libreoffice.script
Version:         7.4.2.3 (7.4.2.3)
Code Type:       X86-64
Parent Process:  ??? [1]

Date/Time:       2022-11-04 17:08:10.557 +0100
Launch Time:     2022-11-04 16:05:56.632 +0100
OS Version:      Mac OS X 10.15.7 (19H2026)
Report Version:  7
Analysis Tool:   /usr/bin/sample

Physical footprint:         191.9M
Physical footprint (peak):  242.0M
----

Call graph:
    2821 Thread_105352   DispatchQueue_1: com.apple.main-thread  (serial)
    + 2821 start  (in libdyld.dylib) + 1  [0x7fff6e3f1cc9]
    +   2821 main  (in soffice) + 16  [0x106efaf60]
    +     2821 soffice_main  (in libsofficeapp.dylib) + 248  [0x106fc9b68]
    +       2821 ImplSVMain()  (in libvcllo.dylib) + 109  [0x10a13043d]
    +         2821 AquaSalInstance::SVMainHook(int*)  (in libvclplug_osxlo.dylib) + 178  [0x10f02f802]
    +           2821 NSApplicationMain  (in AppKit) + 777  [0x7fff318dc706]
    +             2821 -[NSApplication run]  (in AppKit) + 707  [0x7fff3190a94f]
    +               2821 -[VCL_NSApplication sendEvent:]  (in libvclplug_osxlo.dylib) + 77  [0x10f06521d]
    +                 2821 AquaSalInstance::handleAppDefinedEvent(NSEvent*)  (in libvclplug_osxlo.dylib) + 92  [0x10f02d78c]
    +                   2821 ImplSVMain()  (in libvcllo.dylib) + 139  [0x10a13045b]
    +                     2821 desktop::Desktop::Main()  (in libsofficeapp.dylib) + 4264  [0x106f9ca88]
    +                       2821 Application::Execute()  (in libvcllo.dylib) + 350  [0x10a128f9e]
    +                         2821 Application::Yield()  (in libvcllo.dylib) + 69  [0x10a129055]
    +                           2821 AquaSalInstance::DoYield(bool, bool)  (in libvclplug_osxlo.dylib) + 798  [0x10f02df3e]
    +                             2821 AquaSalTimer::callTimerCallback()  (in libvclplug_osxlo.dylib) + 71  [0x10f03c4c7]
    +                               2821 Scheduler::CallbackTaskScheduling()  (in libvcllo.dylib) + 676  [0x10a119494]
    +                                 2821 AquaSalInstance::AnyInput(VclInputFlags)  (in libvclplug_osxlo.dylib) + 193  [0x10f02e251]
    +                                   2821 -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:]  (in AppKit) + 1352  [0x7fff31918c10]
    +                                     2821 _DPSNextEvent  (in AppKit) + 883  [0x7fff3191a3c9]
    +                                       2821 _BlockUntilNextEventMatchingListInModeWithFilter  (in HIToolbox) + 64  [0x7fff332d1569]
    +                                         2821 ReceiveNextEventCommon  (in HIToolbox) + 359  [0x7fff332d16e4]
    +                                           2821 RunCurrentEventLoopInMode  (in HIToolbox) + 292  [0x7fff332d1aad]
    +                                             2821 CFRunLoopRunSpecific  (in CoreFoundation) + 466  [0x7fff346b5c33]
    +                                               2821 __CFRunLoopRun  (in CoreFoundation) + 2284  [0x7fff346b6b7c]
    +                                                 2821 __CFRunLoopDoSource1  (in CoreFoundation) + 541  [0x7fff346b8062]
    +                                                   2821 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE1_PERFORM_FUNCTION__  (in CoreFoundation) + 41  [0x7fff346b8113]
    +                                                     2821 mshMIGPerform  (in HIServices) + 174  [0x7fff3295af64]
    +                                                       2821 _XCopyAttributeValue  (in HIServices) + 443  [0x7fff3299b4cb]
    +                                                         2821 _AXXMIGCopyAttributeValue  (in HIServices) + 389  [0x7fff3297a3f6]
    +                                                           2821 CopyAttributeValue  (in AppKit) + 161  [0x7fff31d88615]
    +                                                             2821 CopyCarbonUIElementAttributeValue  (in AppKit) + 67  [0x7fff31d8b7da]
    +                                                               2821 CarbonCopyAttributeValueCallback(__CFData const*, unsigned int, __CFString const*, void const**, void*)  (in HIToolbox) + 81  [0x7fff3335ad6c]
    +                                                                 2821 HLTBCopyUIElementAttributeValue  (in HIToolbox) + 57  [0x7fff33358694]
    +                                                                   2821 Accessible::GetNamedAttributeData(__CFString const*, void const*, void const**, unsigned char*)  (in HIToolbox) + 151  [0x7fff333588eb]
    +                                                                     2821 Accessible::SendEvent(OpaqueEventRef*, bool) const  (in HIToolbox) + 88  [0x7fff33359396]
    +                                                                       2821 SendEventToEventTargetWithOptions  (in HIToolbox) + 45  [0x7fff332a9c2d]
    +                                                                         2821 SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*)  (in HIToolbox) + 329  [0x7fff332a9d7d]
    +                                                                           2821 DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*)  (in HIToolbox) + 1254  [0x7fff332aa8ef]
    +                                                                             2821 NSSLMMenuEventHandler  (in AppKit) + 1054  [0x7fff31c4d312]
    +                                                                               2821 -[NSCarbonMenuImpl _carbonGetAccessibleAttributeEvent:handlerCallRef:axElement:]  (in AppKit) + 37  [0x7fff31e0aec4]
    +                                                                                 2821 CallNextEventHandler  (in HIToolbox) + 102  [0x7fff333445f1]
    +                                                                                   2821 SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*)  (in HIToolbox) + 329  [0x7fff332a9d7d]
    +                                                                                     2821 DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*)  (in HIToolbox) + 1254  [0x7fff332aa8ef]
    +                                                                                       2821 HIObject::EventHook(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*)  (in HIToolbox) + 135  [0x7fff332aafcb]
    +                                                                                         2821 HIObject::HandleClassAccessibilityEvent(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*)  (in HIToolbox) + 106  [0x7fff3345f592]
    +                                                                                           2821 HIObject::DispatchAccessibilityEvent(OpaqueEventRef*, unsigned long long, AccessibilityHandlers const*, void*)  (in HIToolbox) + 485  [0x7fff3345f8af]
    +                                                                                             2821 MenuData::GetNamedAccessibleAttributeSelf(unsigned long long, __CFString const*, unsigned int, OpaqueEventRef*)  (in HIToolbox) + 180  [0x7fff33446e2c]
    +                                                                                               2821 MenuData::HandleGetNamedAccessibleAttribute(unsigned long long, __CFString const*, unsigned int, OpaqueEventRef*)  (in HIToolbox) + 153  [0x7fff33446edb]
    +                                                                                                 2821 OpenMenuForInspection(MenuData*)  (in HIToolbox) + 89  [0x7fff334460c4]
    +                                                                                                   2821 _SimulateMenuOpening  (in HIToolbox) + 110  [0x7fff3344faf0]
    +                                                                                                     2821 SendMenuOpening(MenuSelectData*, MenuData*, double, unsigned int, unsigned int, __CFDictionary*, unsigned char, unsigned char*)  (in HIToolbox) + 298  [0x7fff3332e503]
    +                                                                                                       2821 SendMenuPopulate(MenuData*, OpaqueEventTargetRef*, unsigned int, double, unsigned int, OpaqueEventRef*, unsigned char, unsigned char*)  (in HIToolbox) + 318  [0x7fff332fb2e6]
    +                                                                                                         2821 SendEventToEventTargetWithOptions  (in HIToolbox) + 45  [0x7fff332a9c2d]
    +                                                                                                           2821 SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*)  (in HIToolbox) + 329  [0x7fff332a9d7d]
    +                                                                                                             2821 DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*)  (in HIToolbox) + 1254  [0x7fff332aa8ef]
    +                                                                                                               2821 NSSLMMenuEventHandler  (in AppKit) + 1197  [0x7fff31c4d3a1]
    +                                                                                                                 2821 -[NSCarbonMenuImpl _carbonPopulateEvent:handlerCallRef:]  (in AppKit) + 360  [0x7fff31c4d578]
    +                                                                                                                   2821 -[NSMenu _populateWithEventRef:]  (in AppKit) + 81  [0x7fff31b0be21]
    +                                                                                                                     2821 -[NSMenu _populateFromDelegateWithEventRef:]  (in AppKit) + 306  [0x7fff31bf3dc3]
    +                                                                                                                       2821 -[SalNSMenu menuNeedsUpdate:]  (in libvclplug_osxlo.dylib) + 426  [0x10f0645ea]
    +                                                                                                                         2821 ImplWindowFrameProc(vcl::Window*, SalEvent, void const*)  (in libvcllo.dylib) + 6885  [0x109e0bde5]
    +                                                                                                                           2821 Menu::HandleMenuActivateEvent(Menu*) const  (in libvcllo.dylib) + 146  [0x109d9f5f2]
    +                                                                                                                             2821 Menu::Activate()  (in libvcllo.dylib) + 147  [0x109d97583]
    +                                                                                                                               2821 framework::MenuBarManager::Activate(Menu*)  (in libfwklo.dylib) + 1727  [0x10787d16f]
    +                                                                                                                                 2821 SfxOfficeDispatch::addStatusListener(com::sun::star::uno::Reference<com::sun::star::frame::XStatusListener> const&, com::sun::star::util::URL const&)  (in libsfxlo.dylib) + 110  [0x1081b391e]
    +                                                                                                                                   2821 SfxDispatchController_Impl::addStatusListener(com::sun::star::uno::Reference<com::sun::star::frame::XStatusListener> const&, com::sun::star::util::URL const&)  (in libsfxlo.dylib) + 132  [0x1081b39e4]
    +                                                                                                                                     2821 SfxDispatcher::QueryState(unsigned short, com::sun::star::uno::Any&)  (in libsfxlo.dylib) + 115  [0x108173af3]
    +                                                                                                                                       2821 SfxShell::GetSlotState(unsigned short, SfxInterface const*, SfxItemSet*)  (in libsfxlo.dylib) + 654  [0x108187bce]
    +                                                                                                                                         2821 Idle::Start(bool)  (in libvcllo.dylib) + 25  [0x10a0ded59]
    +                                                                                                                                           2821 Task::Start(bool)  (in libvcllo.dylib) + 41  [0x10a119b09]
    +                                                                                                                                             2821 std::__1::mutex::lock()  (in libc++.1.dylib) + 9  [0x7fff6b6f8539]
    +                                                                                                                                               2821 _pthread_mutex_firstfit_lock_slow  (in libsystem_pthread.dylib) + 222  [0x7fff6e5f5937]
    +                                                                                                                                                 2821 _pthread_mutex_firstfit_lock_wait  (in libsystem_pthread.dylib) + 83  [0x7fff6e5f7917]
    +                                                                                                                                                   2821 __psynch_mutexwait  (in libsystem_kernel.dylib) + 10  [0x7fff6e535052]
    2821 Thread_105478: PipeIPC
    + 2821 thread_start  (in libsystem_pthread.dylib) + 15  [0x7fff6e5f5b8b]
    +   2821 _pthread_start  (in libsystem_pthread.dylib) + 148  [0x7fff6e5fa109]
    +     2821 osl_thread_start_Impl(void*)  (in libuno_sal.dylib.3) + 128  [0x106f489f0]
    +       2821 threadFunc  (in libuno_salhelpergcc3.dylib.3) + 15  [0x107b62c0f]
    +         2821 non-virtual thunk to salhelper::Thread::run()  (in libuno_salhelpergcc3.dylib.3) + 32  [0x107b62ae0]
    +           2821 desktop::PipeIpcThread::execute()  (in libsofficeapp.dylib) + 65  [0x106fc68b1]
    +             2821 osl_acceptPipe  (in libuno_sal.dylib.3) + 25  [0x106f416f9]
    +               2821 __accept  (in libsystem_kernel.dylib) + 10  [0x7fff6e5393ae]
    2821 Thread_105487: com.apple.NSEventThread
    + 2821 thread_start  (in libsystem_pthread.dylib) + 15  [0x7fff6e5f5b8b]
    +   2821 _pthread_start  (in libsystem_pthread.dylib) + 148  [0x7fff6e5fa109]
    +     2821 _NSEventThread  (in AppKit) + 132  [0x7fff31abbbf4]
    +       2821 CFRunLoopRunSpecific  (in CoreFoundation) + 466  [0x7fff346b5c33]
    +         2821 __CFRunLoopRun  (in CoreFoundation) + 1329  [0x7fff346b67c1]
    +           2821 __CFRunLoopServiceMachPort  (in CoreFoundation) + 247  [0x7fff346b7d07]
    +             2821 mach_msg  (in libsystem_kernel.dylib) + 60  [0x7fff6e533160]
    +               2821 mach_msg_trap  (in libsystem_kernel.dylib) + 10  [0x7fff6e532dea]
    2821 Thread_121115
      2821 start_wqthread  (in libsystem_pthread.dylib) + 15  [0x7fff6e5f5b77]
        2821 _pthread_wqthread  (in libsystem_pthread.dylib) + 390  [0x7fff6e5f6aa1]
          2821 __workq_kernreturn  (in libsystem_kernel.dylib) + 10  [0x7fff6e5344be]

Total number in stack (recursive counted multiple, when >=5):

Sort by top of stack, same collapsed (when >= 5):
        __accept  (in libsystem_kernel.dylib)        2821
        __psynch_mutexwait  (in libsystem_kernel.dylib)        2821
        __workq_kernreturn  (in libsystem_kernel.dylib)        2821
        mach_msg_trap  (in libsystem_kernel.dylib)        2821

Maybe this would ring a bell for someone?
As far as i can tell, Console.app does not logs anything…
I still offer to provide extensive logging and reporting!

#12

Hello again,

just in case someone is crossing this post in the same situation as me:
apparently the developers are aware of this issue, as i just realised
and the problem seems to be rooted in the MacOS API.

If i understood it right, the following bugs are related to this:

“https://bugs.documentfoundation.org/show_bug.cgi”:
id={146598|148051|148435}
And
https://gerrit.libreoffice.org/c/core/+/143046

I’d be super glad if they find a solution, as otherwise a considered option seems be to drop LO support on MacOS altogether, which would be a nightmare.
There is a substantial discomfort in the scientific environment i know with being forced to use MS Office, and the approaching forced switch to cloud based Office 365 contributes to that.
Loosing the cross platform compatibility of LibreOffice now would be a major blow to any ambitions to consider LO as a viable alternative, for which the motivation seems to be better now then ever before, at least in my wider environment.

@developers: thank you very much for keeping the effort up so far!

Fingers crossed!

#2

Try one or both parts from answer at LibreOffice 7.3.0.3 unstable Cheers, Al

[Edit] Sorry I misread. Try Computation related issues in Calc First steps to take before submitting a bug - The Document Foundation Wiki

#4

I have tried all the solutions suggested thus far, but both OpenCL and Skia were already disabled.

The issue happens when I copy a formula to the clipboard and then switch to a different sheet (in the same document or a different document). Maybe that helps?

#5

Do you have a clipboard management tool installed? They frequently cause problems.

1 Like
#6

@EarnestAl Yes, I definitely do… and I can’t imagine life without one. I use Keyboard Maestro on the Mac here. To be fair, though, this happens even if I’m not using something from the Clipboard Stack.

This path routinely causes a freeze:

  1. Copy (Command-C) formula to main clipboard
  2. Switch to another sheet (in same workbook or different workbook)
  3. Paste (Command-V).

One thing which mitigates it is putting in a step 1a and 2a, both of which are “Command-S to save current document”. So I’m obsessively saving (to mitigate any data loss), but doing so seems to ‘reset’ whatever causes the spin-of-death, and generally keeps things flowing smoothly.

And, again, this is new with 7.2.x builds and forward. 7.1.x (and prior) work great, without any need to obsessively save.

#7

The clipboard manager intercepts the copy regardless and reinterprets it.

I can’t help with this, sorry.

#8

Ok. Thanks for the tip! I’ve disabled Clipboard Management for LibreOffice. I’ll continue to test and we’ll see if that’s it.

For what it’s worth, this wasn’t an issue in 7.1, so clearly it is doable for these things to co-exist if that’s the issue here. I’ll report back!

#9

There were a number of Paste bug-fixes for LibreOffice in version 7.2, in the same release notes see:

#13

This remains to be an issue on multiple Macs we run here even through LibreOffice 7.4. We see this error regardless of whether or not we’re running a clipboard manager (Keyboard Maestro is the one we use).

I’m surprised no one else is seeing this.

The way to replicate: Open two sheets in Libreoffice. Select a group of cells from one, paste into the other.

Do this a couple of times and, boom, it’ll spin with the beachball.

Saving in between each “paste” operation often (but not always) prevents this.

#14

Turns out others are seeing this:

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