Bug 158691 - Calc not responding after copying cells with Windows' "Offer suggested actions" set ON
Summary: Calc not responding after copying cells with Windows' "Offer suggested action...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/calc-fr...
Whiteboard:
Keywords:
Depends on:
Blocks: Clipboard
  Show dependency treegraph
 
Reported: 2023-12-13 19:58 UTC by myufoxy
Modified: 2024-03-12 05:25 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description myufoxy 2023-12-13 19:58:42 UTC
Description:
Copying multiple cells causes Calc to not respond and memory use to increase rapidly and appears would use all available memory given time. I close the program before it goes over a Gig or so as I wasn't interested in causing OOM errors on my OS. The Calc application CPU stays around 8-12%.

There are multiple ways to reproduce this issue. However, making a new spreadsheet copying a 2x2 is enough to freeze it. There is no need to change the cells or for a specific spreadsheet file. I just installed LibreOffice and this laptop is brand new. I wouldn't expect problems like this.



Steps to Reproduce:
1. In the Windows search menu search "Offer suggested actions" and it should take you to a setting in System > Clipboard. Toggle "Suggested actions" on
2. Open Calc and new file or existing file whatever you prefer.
3. Copy multiple cells or copy a whole row or copy a whole column.
4. Attempt any other action. Calc should be frozen and will go not responding in a few minutes.
5. Check Task Manager and the Calc process memory usage will be climbing and continue to climb. Careful, I don't not know the max it will climb. It could cause OOM if left alone for too long. 
6. Stop Calc from task bar or kill the process from Task Manager.

Actual Results:
Calc stops responding and freezes

Expected Results:
Calc to copy cells to the Windows clipboard and continue to be responsive.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice CommunityBuild ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1CPU threads: 20; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: winLocale: en-US (en_US); UI: en-USCalc: CL threaded

My system info.

Edition Windows 11 Pro
Version 22H2
Installed on ‎12/‎5/‎2023
OS build 22621.2792
Experience Windows Feature Experience Pack 1000.22681.1000.0

Troubleshooting steps I remember taking:
Safemode
Safemode disable hardware acceleration
Disable JRE
Multiple reboots
Install repair
Delete LibreOffice profile
Updating Windows and Laptop drivers (Just because)

This appears to be due to the Windows clipboard "Suggested actions" feature. When I disabled that feature the issue is now resolved. 

Workaround:
In the Windows search menu search "Offer suggested actions" and it should take you to a setting in System > Clipboard. Toggle "Suggested actions" off. It says this is for getting suggestions for actions when you copy a date, time, or phone number.

I found the workaround from the suggestions in this thread.
https://ask.libreoffice.org/t/calc-freezes-on-copy-nov-22-solution-recomendations-make-no-difference/87840/8

Request: Fix the compatibility issue between LibreOffice and Windows clipboard features such as the "Suggested actions". It also seems the clipboard history feature might affect LibreOffice as well based on other reports, but I didn't test enabling that feature.

P.S this is my first bug report. I hope I am doing this correctly.
For the priority, I thought normal fits because of the high visibility to users because Windows is setting "Offer suggested actions" is enabled by default. It wasn't easy finding the answer and I could see new users giving up on LibreOffice if this is their initial experience. The issue was starting to disappoint me to switch to something else. Anyway, the clipboard feature is new and I haven't been able to use it to comment on it's value, but it looks nice from what I have seen. It is a shame I have to disable it for LibreOffice.
Comment 1 Stéphane Guillou (stragu) 2023-12-28 14:05:54 UTC
Thanks for the report. This is possibly related to bug 153131, I asked there.
Comment 2 Michael Weghorn 2023-12-28 14:53:56 UTC
(In reply to Stéphane Guillou (stragu) from comment #1)
> Thanks for the report. This is possibly related to bug 153131, I asked there.

Reading [1], "Offer suggested actions" seems to be a new Windows 11 feature. Since I don't have Windows 11 here, I can't test, but if anybody can get a traceback while LO is "frozen", that might help to identify whether it's related.

[1] https://learn.microsoft.com/en-us/windows/whats-new/whats-new-windows-11-version-23h2
Comment 3 Buovjaga 2024-01-17 17:47:44 UTC
Apparently "Offer suggested actions" is only available on activated Windows installs, so I can't test it in my virtual machine.
Comment 4 Stéphane Guillou (stragu) 2024-03-12 05:25:29 UTC
I can't reproduce with Windows 11, Suggested Actions on, and:

Version: 7.6.5.2 (X86_64) / LibreOffice Community
Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b
CPU threads: 4; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

However, confirmed as two users confirmed the workaround in https://ask.libreoffice.org/t/calc-freezes-on-copy-nov-22-solution-recomendations-make-no-difference/87840