Description: Calc crashes when trying to assign a macro to a shape. Steps to Reproduce: - Open LO Calc then add shape to a blank worksheet. - Right click on shape and select Assign Macro Actual Results: The program crashes. Expected Results: A box presenting either a macro to select or some option to create a new one. Even if we create a very short macro before trying to assign a macro to the shape, it still crashes. Reproducible: Always User Profile Reset: Yes Also tried in Safe mode Env: Windows 10 home, Ver 22H2 build 19045.4529 History I have a spreadsheet with macros that worked for a long time. Then I added a new sheet and some macros and at open point it crashed. After this, the crashing issue happens whenever I try and run the macro from a button on the sheet (actually a box shape with rounded edges) I can open the basic macros and edit and run them from within the macro editor but cannot trigger them from the button without crashing Calc. I had assigned a macro to a shape in the past. Now it fails. Have tried with a new blank spreadsheet Also tried safe mode, and tried user profile rests using the LO tools Also tried application repair and lastly installed the 24.2.4.2 over the top of 24.2.3 that this started with. Still happening.
(In reply to Hardy from comment #0) > Also tried application repair and lastly installed the 24.2.4.2 over the top > of 24.2.3 that this started with. Still happening. When you say "24.2.3 that this started with", what was the prior version you actually tried this procedure and it worked as expected? Was this not happening with LO 24.2.2?
Created attachment 195187 [details] Calc file with a shape and macro I am unable to reproduce this issue. I've created a Calc file with a shape on it and then I assigned a macro to the shape. It is working fine (see attached file). Tested with Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:24.2.4-0ubuntu0.24.04.2 Calc: threaded Can you share a sample file where the bug happens?
Also could not reproduce, successfully created shape, assigned macro
(In reply to ady from comment #1) > (In reply to Hardy from comment #0) > > Also tried application repair and lastly installed the 24.2.4.2 over the top > > of 24.2.3 that this started with. Still happening. > > When you say "24.2.3 that this started with", what was the prior version you > actually tried this procedure and it worked as expected? > > Was this not happening with LO 24.2.2? Prior to 24.2.3 I was using 7.0.5. Honestly can't remember which of those two versions I was using when I created the working linked shape.
(In reply to Rafael Lima from comment #2) > Created attachment 195187 [details] > Calc file with a shape and macro > > I am unable to reproduce this issue. I've created a Calc file with a shape > on it and then I assigned a macro to the shape. It is working fine (see > attached file). > > Tested with > > Version: 24.2.4.2 (X86_64) / LibreOffice Community > Build ID: 420(Build:2) > CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) > Locale: pt-BR (pt_BR.UTF-8); UI: en-US > Ubuntu package version: 4:24.2.4-0ubuntu0.24.04.2 > Calc: threaded > > Can you share a sample file where the bug happens? I can, but you already did. It happens with the file you attached. I can edit and run your macro. It works fine when I click the button too. But if I select the shape and right click - assign macro, then calc crashes again.
(In reply to Mudge from comment #3) > Also could not reproduce, successfully created shape, assigned macro Are you in Windows environment Mudge ?
ok. I thought I might delete all my registry settings but seems there are none. So I creates a new test user on this system and signed in as that user. Complete fresh profile. Start calc. Create a simple macro with "Hello" message. Test run from the macro editor - fine. Add a rectangle to the worksheet. Right click, assign macro CRASH!
Just made a test on a second computer. HP Laptop running Win 10 Pro 64 bit. Same test as previous and same result. LO Version is also 24.2.3.2 Win updates on this will be a little older than my main PC.
@Hardy, Please open LO > Help > About. There is an icon in-there to copy the info to the clipboard. Please paste the info in your next comment. This info is relevant for when the problem shows up (i.e. with your current settings). Please paste that info before any additional tests and/or changes (see below) as this info might change too. Additionally (please save all your docs before testing)... * Open Calc > Tools > Options > LibreOffice > OpenCL. Is OpenCL set to ON? What happens with your tests if you set it to OFF (and OK > restart LO)? * Open Calc > Tools > Options > LibreOffice > View > (Graphics Output). Which settings are you using? What happens if you disable all the check boxes in that area (4 check boxes as of LO 24.2) (and then OK > restart LO)? Testing with the aforementioned changes might have different resulting behavior; they _might_ avoid the crash, and _might_ have some impact on performance. The point is to narrow down the source of the problem, so similar conditions might be met by someone else (and then reproduce the behavior).
Created attachment 195221 [details] Video of calc crashing
ok. Info. Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-AU (en_AU); UI: en-US Calc: threaded Suggestions to test with OpenCL switched off - Same result Also disabled all 4 graphics options in View. Same result - crashed. I mentioned earlier that I get a similar crash if I use the Tools -> Macros -> Run Macro menu. I dont get a list of macros - just crash. I tested this also in Impress app and it also crashes. Also for Writer (although I didn't actually create a macro in Writer before trying this option. I did make a basic macro in Impress first though. One thought comes to mind. There are these built in "Application Macros & Dialogues" when I open the Macro editor. About the time this crashing started - I was trying to use a dictionary object and was playing around looking at these 'built in' macros. Is it possible to corrupt them ? If yes - how can I restore them ? I already tried an application repair as previously mentioned. Thanks
Actually - I dont see how that last comment is relevant given that this happens on both my computers.
(In reply to Hardy from comment #12) > Actually - I dont see how that last comment is relevant given that this > happens on both my computers. ATM, no one else has reproduced the issue. With the info you provided, there might be someone with similar settings/context that might be able to reproduce it. There might be other factors in place (extension, java, graphic driver, clipboard history manager,...). Pasting the info from your other system might (or might not) help. JIC, I am still not able to reproduce the crash on Windows 10 and LO in Safe Mode (UI render: default).