[Libreoffice-bugs] [Bug 143306] New: Changing Macro Library name to password them = multiple errors

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143306

            Bug ID: 143306
           Summary: Changing Macro Library name to password them =
                    multiple errors
           Product: LibreOffice
           Version: 7.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bort1352 at gmail.com

Description:
If I copy or export/import a macro from the default "Standard" library to a
library in a new sheet that I've given a custom name to so I can password
protec the macro I get a lot of errors and the macros don't run. 
"wrong number of parameters" if I try to run the macro from the library with
the custom name so I can protect it through Tools > Macros > Run Macro.
"run time error" or "syntax error - already defined" if I try to run them from
the organizer. 

If I leave the library name "Standard" they copy just fine between any document
and work but I'm not able to protect them with a password with that library
name. 

if I put the same exact macro code in a library with any other name than
"Standard" I get errors and the macro does not run. 

Steps to Reproduce:
1. Write an advanced macro. The one this is happening with pushes code and
plays windows midi sounds when a cell in column A is double clicked. Place the
original macro code in the Standard Library.
2. Copy the code of that macro. 
3. Create a new library with a custom name and paste the macro code in to it
then try to run the macro. 

Actual Results:
When I place the same exact, 100% identical macro code in to a library with any
other name than the default "Standard" library that cannot be password
protected so I can protect the macros with a password the macros won't run and
produce error after error that don't make any sense (to me). If I paste the
same macro code in to a "Standard" library it works just fine no matter how
many new sheets I use the same macro in. It's when I use a different name other
than "Standard" for the macro library that the macros error and won't run.

Expected Results:
Copied or imported macros run regardless of the name of the library. I'm trying
to do this so I can password protect the passwords so itchy fingers can't
attempt editing them and messing them up causing them to not work. This sheet
is going to be shared with a lot of people. I don't and can't trust all of them
to leave the macro code alone. 


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Ran the macro's without error as it does if I don't put them in a custom named
library. 

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210712/51677ad7/attachment.htm>