Bug 153327 - LO crashes on create/edit comment in Calc
Summary: LO crashes on create/edit comment in Calc
Status: RESOLVED DUPLICATE of bug 154050
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: corruptProfile
Depends on:
Blocks: User-Profile-Upgrade
  Show dependency treegraph
 
Reported: 2023-02-02 14:24 UTC by Paul
Modified: 2023-03-12 18:06 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
file causing crash in Calc when exiting comment creation (2.03 MB, application/xml)
2023-02-06 15:37 UTC, Daniel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paul 2023-02-02 14:24:12 UTC
Create or edit a comment in Calc. As soon as I change focus away from the comment field back to the underlying spreadsheet, the app crashes.

To test, I tried the same operation on the earlier LO version (7.4.5) and there was no problem. So this seems new in 7.5 released today.

Can anyone replicate this?

Using the newly released version of LO 7.5 for Mac Silicon downloaded from the LO main download site today, running on a M1 Mac on the current version of MacOS (13.2 Ventura).
Comment 1 Xisco Faulí 2023-02-02 14:55:13 UTC
I can't reproduce it in

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 13545b53c530cec8157a4991792e8e3cb1c6df78
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: x11
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded
Comment 2 Telesto 2023-02-02 21:25:52 UTC
No issue
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Mac OS X 12.3.1; UI render: Skia/Metal; VCL: osx
Locale: nl-NL (nl_NL.UTF-8); UI: en-US
Calc: threaded
Comment 3 m_a_riosv 2023-02-03 00:39:56 UTC
Works for me
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded 

Please test with a clean profile, Menu/Help/Restart in Safe Mode
Comment 4 Daniel 2023-02-03 04:27:14 UTC
Error reproduced. Works after starting with fresh profile.

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: 50(Build:3)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.5.0-1
Calc: threaded
Comment 5 Paul 2023-02-03 08:33:37 UTC
Thank you everyone for your replies.

I confirm that the problem does not occur if I start in Safe Mode.

And, just to repeat, the problem does not occur if I use the earlier version of LO (7.4.5).

My current version is the Mac silicon version below:

Version: 7.5.0.3 (AARCH64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Mac OS X 13.2; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 6 Xisco Faulí 2023-02-03 10:08:30 UTC
Good to hear. Closing
Comment 7 ady 2023-02-04 13:33:53 UTC
Reopening.

I don't think the reporter is saying that there is no bug, but rather that when using safe mode the problem is not present, neither when using 7.4.x (a prior version). The question is whether the problem still occurs after starting version 7.5 in normal mode (after it is not repro in Safe mode). Resetting user profile (maybe with a backup of the current) might be necessary.

Resetting user profile might be also a valid suggestion for Daniel in comment 4.

@Paul and @Daniel, please confirm results.
Comment 8 Paul 2023-02-04 14:41:01 UTC
(In reply to ady from comment #7)
> Reopening.
> 
> I don't think the reporter is saying that there is no bug, but rather that
> when using safe mode the problem is not present, neither when using 7.4.x (a
> prior version). The question is whether the problem still occurs after
> starting version 7.5 in normal mode (after it is not repro in Safe mode).
> Resetting user profile (maybe with a backup of the current) might be
> necessary.
> 
> Resetting user profile might be also a valid suggestion for Daniel in
> comment 4.
> 
> @Paul and @Daniel, please confirm results.

Thanks, Ady. 

Yes, the problem did continue to occur when in normal mode.

I have now deleted my original profile and that seems to fix the problem.

I examined my profile folder. The problem was the file called registrymodifications.xcu

Deleting this file fixed the problem. But I had to recreate my customisations after that. 

I don't understand why my profile should be fine when switching back to 7.4, but not fine with 7.5. 

Anyway, it's working now and recreating my customisations didn't take long. thanks for your help everyone.
Comment 9 Daniel 2023-02-04 23:34:43 UTC
(In reply to ady from comment #7)
> Reopening.
> 
> I don't think the reporter is saying that there is no bug, but rather that
> when using safe mode the problem is not present, neither when using 7.4.x (a
> prior version). The question is whether the problem still occurs after
> starting version 7.5 in normal mode (after it is not repro in Safe mode).
> Resetting user profile (maybe with a backup of the current) might be
> necessary.
> 
> Resetting user profile might be also a valid suggestion for Daniel in
> comment 4.
> 
> @Paul and @Daniel, please confirm results.

Yes, the problem reappeared when restarting in normal mode. I've since continued as Paul has. There is certainly a difference between the two versions that effected 40% of our, er, massive sample size.
Comment 10 m_a_riosv 2023-02-05 00:02:39 UTC
(In reply to Daniel from comment #9)
> ....
> Yes, the problem reappeared when restarting in normal mode. I've since
> continued as Paul has. There is certainly a difference between the two
> versions that effected 40% of our, er, massive sample size.
Whom are 40% of which group of people?

In Menu/Help/Restart in Safe, is the option to clean the profile.
But usually it's enough cleaning the file 
registrymodifications.xcu
in the root folder of the profile.
It keeps the options in Menu/Tools/Options, so not the entire profile needs to be recreated.
https://wiki.documentfoundation.org/UserProfile

We are mainly volunteers helping out in our spare time, so please.
Comment 11 ady 2023-02-05 00:49:56 UTC
(In reply to Paul from comment #8)
> Deleting this file fixed the problem. But I had to recreate my
> customisations after that. 
> 
> I don't understand why my profile should be fine when switching back to 7.4,
> but not fine with 7.5. 

Well, those are interesting questions indeed. Being able to see the difference between those 2 files (the new, recreated one and the old one that caused the failure) _maybe_ would had been useful for developers to analyze. Although I'm glad you "solved" _your_ problem, it doesn't help to solve the original problem in LO.

If someone still has the original profile file that caused the problem, _perhaps_ it might be helpful to attach it here for devs to take a look at it. OTOH, relevant developers might think otherwise.
Comment 12 Daniel 2023-02-06 15:37:54 UTC
Created attachment 185153 [details]
file causing crash in Calc when exiting comment creation
Comment 13 Daniel 2023-02-06 15:38:53 UTC
I can provide complete copies of both my old and new profiles if necessary.
Comment 14 Stéphane Guillou (stragu) 2023-02-13 15:43:21 UTC
Daniel, if you are comfortable sharing your old and new registrymodifications.xcu, please do. Make sure it doesn't include personal data (like you would include in Tools > Options > LibreOffice > User Data) and know that it includes thumbnails of your recent documents (base64-encoded).

Marking as NEW as Daniel reproduced the problem.
Comment 15 Stéphane Guillou (stragu) 2023-03-12 14:02:23 UTC
Paul, Daniel and Maison: it would be great if you could try to get a backtrace for this crash (or easier: if the crash reporter pops up and gives you a link to a crash report, please share it here).

Info depending on OS is here: https://wiki.documentfoundation.org/QA/BugReport/Debug_Information
Comment 16 m_a_riosv 2023-03-12 14:18:28 UTC
*** Bug 154146 has been marked as a duplicate of this bug. ***
Comment 17 maison 2023-03-12 16:08:35 UTC
In addition to bug 154146, the crash also leaves a LibreOffice process running and using 25% of the CPU (or maybe one of the 4 cores).
Comment 18 maison 2023-03-12 16:26:43 UTC
Deleting the profile settings is not a solution. As I mentioned in bug 154146, there is at least one configuration that triggers the bug every time, but not if you have the basic settings.
Comment 19 Maxim Monastirsky 2023-03-12 18:06:47 UTC

*** This bug has been marked as a duplicate of bug 154050 ***