Bug 34941 - vba event binding doesn't work for macros imported from xlsm
Summary: vba event binding doesn't work for macros imported from xlsm
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium normal
Assignee: Noel Power
Depends on:
Reported: 2011-03-02 12:30 UTC by Noel Power
Modified: 2011-03-07 02:41 UTC (History)
0 users

See Also:
Crash report or crash signature:

test document (139.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-03-02 12:30 UTC, Noel Power

Note You need to log in before you can comment on or make changes to this bug.
Description Noel Power 2011-03-02 12:30:39 UTC
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 )
Comment 1 Noel Power 2011-03-02 12:30:56 UTC
for me!
Comment 2 Noel Power 2011-03-02 12:33:29 UTC
the event binding fails because the ooo::vba::isAlienExcelDoc function doesn't get a valid mime type for the filter for .xlsm
Comment 4 Noel Power 2011-03-07 02:41:24 UTC
fixed on master ( see commit above )