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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|REOPENED                    |RESOLVED

--- Comment #8 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to bort1352 from comment #7)
> What do you mean by "assign the macro to the same sheet event"?

I even made a screen cast - attachment 173516! It shows you how it works; let
me now describe you what you see.

Initially you see me opening your "FileThatWorks.ods". I enable macros, then I
right-click on the sheet's tab in the bottom, and in the context menu I choose
"Sheet Events" (I would expect that as we are talking about "assigning macros
to sheet events", you would see that it maybe relates to the topic). In the
opened events dialog, I show how this file *already* has the macro
"Standard.MidiEditor.onDblClickCell" assigned to "Double click" event. Then I
demonstrate that in this file, double-clicking cells in column A produces edits
in D3; and then I show that in the same file, trying to run the macro from
*Standard* library *directly* does not work, and fails with "wrong number of
parameters" error!

Then you see how I open the other file ("DOES_NOT_WORK.ods") that you attached
here. After accepting macros, I again right-click on the tab, and show that
this file did not have events assigned to the double-click event; but I then
assign it right here - and I use the macro inside the "MidiWriter" library -
obviously this name is not "Standard". After assigning the macro to the event
and closing the dialog (that is what I suggested you to do!), I show you that
now double-clicking the cells in column A also works as expected *in this your
file*, producing edits in D3. After that, I demonstrate that trying to run the
macro directly still doesn't work from Run Macro dialog (as expected). And
after that, I open Basic IDE, to show you that in this file, the Standard
library is empty, and MidiWriter library has all the code.

-- 
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/90434c51/attachment.htm>