| Summary: | vba event binding doesn't work for macros imported from xlsm | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Noel Power <nopower> |
| Component: | Calc | Assignee: | Noel Power <nopower> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | test document | ||
for me! the event binding fails because the ooo::vba::isAlienExcelDoc function doesn't get a valid mime type for the filter for .xlsm http://cgit.freedesktop.org/libreoffice/filters/commit/?id=05f9e490103479caa047edc9fbd3bd3bf555e00c is the fix for that fixed on master ( see commit above ) |
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 )