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
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Noel Power
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
test document (139.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-03-02 12:30 UTC, Noel Power 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 )