Bug 161060

Summary:	Calc hang on 3rd save every time while using macro editor
Product:	LibreOffice	Reporter:	Sylvain Blanchet <sdblanchet>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	enhancement	CC:	robert
Priority:	medium
Version:	7.6.6.3 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Sylvain Blanchet 2024-05-13 13:12:14 UTC

Description:
Since version 7.6.6.3 (That i know of) Calc And/or the Macro Editor hangs on 3rd save everytime. I'm developping some macros so the macro editor and Calc are open at the same time. A save from macro editor or Calc will hang. I tried to wait for the completion of the save for over an hour and it did not finish. There is a temporary file created in the file directory with 0 byte that looks like this lu4616a3cyoh.tmp The macros are stored in the file standard/Module1 container. I have 29 macros for 1630 line of codes 
The save is not done


Steps to Reproduce:
1.Modify macro, save macro with CTRL-S
2.Execute macro (might have some break points)
3.Finish execution or Stop macro, repeat 3 times

Actual Results:
Green save status bar at bottom stays on forever

Expected Results:
Save completion, continue debugging !!


Reproducible: Always


User Profile Reset: No

Additional Info:
Third save done from Macro Editor or Calc have same result, no save and hangs

I tried using Safe mode but it won't allow me to run the macro even if i changed the security setting for macro before starting the macro editor !!!

Version: 7.6.7.2 (X86_64) / LibreOffice Community
Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: fr-CA (fr_CA); UI: fr-FR
Calc: CL threaded

Édition	Windows 11 Professionnel
Version	23H2
Date d'installation	‎2024-‎04-‎30
Version du système d’exploitation	22631.3527
Expérience	Windows Feature Experience Pack 1000.22700.1003.0

Comment 1 Sylvain Blanchet 2024-05-14 10:31:06 UTC

Found the problem... I was creating the same button on the same sheet repeatedly. When there was 2 or more of the same button (exactly the same caracteristics) overlapping each other that is when the save hangs.

Comment 2 Robert Großkopf 2024-05-29 09:21:24 UTC

(In reply to Sylvain Blanchet from comment #1)
> Found the problem... I was creating the same button on the same sheet
> repeatedly. When there was 2 or more of the same button (exactly the same
> caracteristics) overlapping each other that is when the save hangs.

If you found the reason: Could we close this bug as WORKSFORME?

Comment 3 Sylvain Blanchet 2024-05-29 10:31:52 UTC

I have changed its importance to ENHANCEMENT as I i believe it should be addressed anyway but if you think that it is not neccessary, let me know I'll close it then