Summary: |
vba event binding doesn't work for macros imported from xlsm |
Product: |
LibreOffice
|
Reporter: |
Noel Power <nopower> |
Component: |
Spreadsheet | Assignee: |
Noel Power <nopower> |
Status: |
RESOLVED
FIXED
|
QA Contact: |
|
Severity: |
normal
|
|
|
Priority: |
medium
|
|
|
Version: |
unspecified | |
|
Hardware: |
Other | |
|
OS: |
All | |
|
Whiteboard: |
|
i915 platform:
|
|
i915 features:
|
|
Attachments: |
test document
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 44030 [details] 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 )