Bug 160888 - Cannot unprotect protected macro library
Summary: Cannot unprotect protected macro library
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-01 12:47 UTC by Theo
Modified: 2024-05-17 03:48 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 Theo 2024-05-01 12:47:54 UTC
Description:
Starting version 2024.2.2 I can no longer unprotect a protected macro library in Calc. The spinning wheel appears and never goes back. The application hangs.

Steps to Reproduce:
1.Protect a macro library using "Tools --> Macros --> Organize Macros --> Basic..."
Select "Organizer...".
Select the tab "Libraries" on the pop-up window
Select the local file in the dropdown under "Location:".
Select the library. In my case this is "LocalAddons"
Click "Password..."
Enter your password of choice under "New Password" and confirm.
2. Save and close the file
3. Reopen the file and try to remove the password by following the steps under 1.

Actual Results:
Application crashes.

Expected Results:
Password is removed.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
This is tested with 24.2.2.2 and 24.2.3.1 on macOS Sonoma and Windows 10.
A file with a macro library that has been password protected with these versions can not be unprotected. Not by these versions, nor by older versions.

Going back to 7.6.6 works if you start from a file with an unprotected macro library.

Help - About info:
Version: 24.2.3.1 (AARCH64) / LibreOffice Community
Build ID: fc604d5980a783e74808a001f1918a603d920494
CPU threads: 8; OS: macOS 14.4.1; UI render: default; VCL: osx
Locale: nl-NL (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2024-05-16 15:24:26 UTC
I could not reproduce the issue, using:

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

At step 3, I was able to click Password, enter the old password, and leave the new password fields empty. The library was then unprotected.

Let's see if someone can reproduce on macOS.
Comment 2 Theo 2024-05-16 17:00:07 UTC
Just checking: did you save, close and then reopen the file? 
I can re-enter the password fine, as long as I don't close and reopen the file.
Comment 3 Stéphane Guillou (stragu) 2024-05-17 03:48:10 UTC
(In reply to Theo from comment #2)
> Just checking: did you save, close and then reopen the file? 
> I can re-enter the password fine, as long as I don't close and reopen the
> file.
Yes, I did that. Can't reproduce on Linux, with gtk3 nor gen VCL plugins.
I also tested on Windows 11 with LO 24.2.2.2, couldn't reproduce either.
I can't start my macOS VM at the moment, so will have to wait for another mac user to test.