Bug 161060 - Calc hang on 3rd save every time while using macro editor
Summary: Calc hang on 3rd save every time while using macro editor
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.6.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-13 13:12 UTC by Sylvain Blanchet
Modified: 2024-05-29 10:31 UTC (History)
1 user (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 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