To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=68893
Issue #|68893
Summary|support excel sheet control events
Component|framework
Version|680m180
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|PATCH
Priority|P3
Subcomponent|scripting
Assigned to|npower
Reported by|npower
------- Additional comments from [EMAIL PROTECTED] Wed Aug 23 07:40:17 -0700
2006 -------
vba controls ( the ones from the tool-box not the form controls ) can have
events associated with them,
e.g. A button named commandbutton1 when clicked will try and invoke a macro
called commandbutton1_click located in the associated sheet module. Similarly
each control ( from the toolbox ) has a set of supported events. Additionally
not all of the vba events routines have an equivalent OpenOffice.org event. This
set of patches "Tries" to do its best and does 2 things
1) when importing a control from excel it creates a binding if it finds a macro
event handler associated with the control e.g. a "private Sub object_Click(...)"
or whatever. If one of these event handlers is defined ( located in the sheet
module the control is located on ) a "special" script binding is attached to the
imported control for best fit openoffice.org event.
"special" - means its get special treatment and is not handled the same as a
normal script binding
2) when an OpenOffice.org event is fired by the imported XL control that has the
"special" binding, instead of calling the macro script directlyy the event is
forwarded to code that attempts to call the equivelant VBA event macro handler
(but first it uses information about the event and the handler to determine the
correct parameters to pass etc. )
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
