[Libreoffice-bugs] [Bug 34941] New: vba event binding doesn't work for macros imported from xlsm

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=34941

           Summary: vba event binding doesn't work for macros imported
                    from xlsm
           Product: LibreOffice
           Version: unspecified
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: nopower at novell.com


Created an attachment (id=44030)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=44030)
test document

Event handlers associated with controls on userforms imported from ooxml excel
documents ( e.g. those with .xlsm extensions ) don't work. 

see attachment for example document which also containing Userforms. note:
activex
controls are not imported so there is no 'button' to press to launch the
macros.  To run the macro you need to navigate and execute the macro manually (
from the macro organiser [1] )

[1] open the macro organiser ( Tools|Macros|OrganiseMacro|Libreoffice|Basic )
from the organiser navigate to the macro ( Suse-puzzler.xlsm | Project |
Modules | Module1 ) and choose to run the 'launch' macro from the list of
existing macros. ( of course your security settings should be set to allow
macro execution to run the test )

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.