[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
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is not a bug.

The two methods of running the macro are completely different. onDblClickCell
is declared like this:

  Function onDblClickCell(oEvent As Variant) As Boolean

And indeed, it expects an argument (event object), because it's an event
handler. When you run functions/subs from Tools->Macros->Run Macro, or from
IDE, you simply start the function, without passing any arguments to it (unlike
what happens when the application calls your macro assigned to an event). This
naturally complains about missing non-optional argument.

Just try assigning the macro to the same sheet event as in your
"FileThatWorks", and compare the two identically arranged tests - that works
here using Version: 7.1.5.1 (x64) / LibreOffice Community
Build ID: 2ca94649fd6dbdcab938c55c28b6a950a9634a34
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

and also using Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

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