<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Changing Macro Library name to password them = multiple errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143306">bug 143306</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Changing Macro Library name to password them = multiple errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143306#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Changing Macro Library name to password them = multiple errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143306">bug 143306</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to bort1352 from <a href="show_bug.cgi?id=143306#c7">comment #7</a>)
<span class="quote">> What do you mean by "assign the macro to the same sheet event"?</span >
I even made a screen cast - <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=173516" name="attach_173516" title="Screen cast of working macros in a non-Standard library">attachment 173516</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173516&action=edit" title="Screen cast of working macros in a non-Standard library">[details]</a></span>! 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>