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

Buovjaga <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ilmari.lauhakangas@libreoff
                   |                            |ice.org
         Whiteboard| QA:needsComment            |

--- Comment #1 from Buovjaga <[email protected]> ---
I added a Calc Hello World macro to My Macros > Standard > Module1 and it works
with View Created even with High macro security.

I got the macro from
https://www.debugpoint.com/2014/09/writing-a-macro-in-libreoffice-calc-getting-started/

I tested both with 7.2.0 and the latest master.

Arch Linux 64-bit
Version: 7.4.0.0.alpha1+ / LibreOffice Community
Build ID: ff2b4bff61d2e1679bb525d754c960c48b81c495
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 25 May 2022

Macro:

REM  *****  BASIC  *****
sub hello_world
        dim document   as object
        dim dispatcher as object

        document   = ThisComponent.CurrentController.Frame
        dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

        dim args1(0) as new com.sun.star.beans.PropertyValue
        dim args2(0) as new com.sun.star.beans.PropertyValue

        args1(0).Name = "ToPoint"
        args1(0).Value = "$A$1"
        dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())

        args2(0).Name = "StringName"
        args2(0).Value = "Hello World!"
        dispatcher.executeDispatch(document, ".uno:EnterString", "", 0,
args2())
   msgbox "Completed!"
end sub

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to