Bug 163530 - assign a macro to a button, crashes LO... Yet my older buttons still work ok!
Summary: assign a macro to a button, crashes LO... Yet my older buttons still work ok!
Status: RESOLVED DUPLICATE of bug 161968
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.2.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-10-19 09:12 UTC by Mark Mclean
Modified: 2024-10-27 09:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature: https://crashreport.libreoffice.org/stats/crash_details/5197e006-bf05-481f-9f6c-a9df4688e5ca


Attachments
Crash pic (40.97 KB, image/png)
2024-10-19 09:18 UTC, Mark Mclean
Details
macro test (13.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-10-19 13:39 UTC, Mark Mclean
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Mclean 2024-10-19 09:12:49 UTC
Description:
Insert, Shape, Basic Shape, Rectangle Rounder. Then Assign Macro. Crashes. All files are saved.

Steps to Reproduce:
1.Insert, Shape, Basic Shape, Rectangle Rounder
2.Assign Macro
3.

Actual Results:
Same as above. crashes

Expected Results:
Crashes


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Mark Mclean 2024-10-19 09:18:06 UTC
Created attachment 197147 [details]
Crash pic
Comment 2 Julien Nabet 2024-10-19 13:02:59 UTC
Could you try https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?
If you still reproduce this, could you attach the file which contains macros?
Comment 3 Julien Nabet 2024-10-19 13:23:58 UTC
I forgot to tell I don't reproduce this on pc Debian x86-64 with master sources updated today with gtk3 or gen rendering.

Perhaps it's also Windows only bug.
Comment 4 Mark Mclean 2024-10-19 13:29:38 UTC
Way to much to learn on this site, I am having a hard time finding where to attach  a file! ? And now, I hope save changes means this will be posted.???
Comment 5 Julien Nabet 2024-10-19 13:35:53 UTC
To attach a file, just click on this link:
https://bugs.documentfoundation.org/attachment.cgi?bugid=163530&action=enter
you can attach a file and make a comment.
Comment 6 Mark Mclean 2024-10-19 13:39:31 UTC
Created attachment 197150 [details]
macro test

Thanks. this is all very different, new to me. I do not, Patch or the other options!
Comment 7 Julien Nabet 2024-10-19 14:00:56 UTC
I gave a try with your file but don't reproduce the crash.

Since you sent several crashreports, could you copy paste a link to one of them so we can see the stacktrace and perhaps it would provide some hints?
Comment 9 Julien Nabet 2024-10-19 14:15:47 UTC
Ok let's put this one to NEW since there's a crashreport.
Comment 10 Mark Mclean 2024-10-19 14:18:48 UTC
OK. I'm trying to think if I did anything to my windows. I do not know what new means. Thank you
Comment 11 Julien Nabet 2024-10-19 14:21:07 UTC
(In reply to Mark Mclean from comment #10)
> OK. I'm trying to think if I did anything to my windows. I do not know what
> new means. Thank you

"New" means here it's confirmed. Normally it should be confirmed by someone else but since you've got a crashreport it should be ok.

Now you can try to apply what I indicated in comment 2 about a potential corrupted LO profile.
Comment 12 Mark Mclean 2024-10-19 14:30:54 UTC
I renamed user file, was surprised it made a new one! but it crashed, here is the report.
https://crashreport.libreoffice.org/stats/crash_details/a54eeaf3-181d-4eb6-94ca-448b35e7c242
I am going to put my old user file back..
Comment 13 Mark Mclean 2024-10-19 15:03:21 UTC
I have 2 laptops, both same, Dells. It worked on the other Laptop! I check both for windows updates, they are both updated.
I took snap shops of both but do not know how to leave file, if needed.

But, both LO say, up to date. Yet, one that does not work, is different that the on that works!

One working 24.2.5.2
One not working 24.8.2.1

Should I uninstall and reinstall new LO. If I do, I believe both will not work..?
Comment 14 Julien Nabet 2024-10-19 16:24:42 UTC
(In reply to Mark Mclean from comment #13)
> ...
> Should I uninstall and reinstall new LO. If I do, I believe both will not
> work..?

I think you can let the one which works.
About the other one, you can try to downgrade LO (uninstall LO 24.8.2 and install LO 24.2.6) just to be sure if it's LO related or if it's something else.
Comment 15 Mark Mclean 2024-10-19 16:47:20 UTC
24.2.6.2 Worked... Thanks
24.2.8.1 was the one that did not work.
Comment 16 Charles Williams 2024-10-19 18:17:15 UTC
I can confirm that this bug is present on macOS

Version: 24.8.2.1 (AARCH64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: macOS 15.0.1; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 17 Patrick (volunteer) 2024-10-19 23:26:11 UTC
(In reply to Charles Williams from comment #16)
> I can confirm that this bug is present on macOS
> 
> Version: 24.8.2.1 (AARCH64) / LibreOffice Community
> Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
> CPU threads: 8; OS: macOS 15.0.1; UI render: default; VCL: osx
> Locale: en-GB (en_GB.UTF-8); UI: en-US
> Calc: threaded

I also can reproduce this crash with LibreOffice 24.8.2.1 (I have the same About dialog text as above).

But I cannot reproduce this crash in my local master build. Even after I assign the macro, save, reopen, uncheck the Edit > Edit Mode menu item, and press the button, there is no crash so maybe a related fix has already been done after LibreOffice 24.8.2.1 was released?:

Version: 25.2.0.0.alpha0+ (AARCH64) / LibreOffice Community
Build ID: 341f3618866c622fa511f153a1b48621e04ddd17
CPU threads: 8; OS: macOS 15.0.1; UI render: Skia/Metal; VCL: osx
Locale: en-CA (en_CA.UTF-8); UI: en-US
Calc: threaded
Comment 18 Julien Nabet 2024-10-26 21:54:56 UTC
Mark/Charles: just for the test, would it be possible you give a try with a daily build from master branch? (see https://dev-builds.libreoffice.org/daily/master/)
Comment 19 Mark Mclean 2024-10-27 08:07:49 UTC
I would like to. But I have no clue as to what the link is to, or how to use it. It only takes me to some odd site with unknow links. I only have updated at LibreOffice.
Comment 20 Julien Nabet 2024-10-27 08:15:43 UTC
(In reply to Mark Mclean from comment #19)
> I would like to. But I have no clue as to what the link is to, or how to use
> it. It only takes me to some odd site with unknow links. I only have updated
> at LibreOffice.

Since you're on Windows with x86-64, you can use this link for example:
https://dev-builds.libreoffice.org/daily/master/Win-x86_64@tb77-TDF/current/LibreOfficeDev_25.2.0.0.alpha0_Win_x86-64.msi

To test:
- uninstall your current LO version
- download LO from the provided site
- install it
Comment 21 Mark Mclean 2024-10-27 08:56:34 UTC
It worked very well!
Only difference was when I was installing, I got a blue window, warning not to run, it had a more info link which allowed me to continue to install. I took a screen shot of the blue window, if you need it...
Comment 22 Mark Mclean 2024-10-27 08:57:16 UTC
Thank you!
Comment 23 Julien Nabet 2024-10-27 09:15:45 UTC
After some research, it's a duplicate of tdf#161968, it'll be fixed from 24.8.3 which should be released in about 2 weeks (see https://wiki.documentfoundation.org/ReleasePlan/24.8).

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