AddInEvents Class
AddIn Connection class, also handling Events from Excel (Open, Close, Activate)
Inheritance Hierarchy
- System.Object
- DBaddin.AddInEvents
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)
Syntax
public class AddInEvents: IExcelAddIn
The AddInEvents type exposes the following members.
Constructors
| Class | Summary | |
|---|---|---|
 | AddInEvents() |
Methods
| Name | Summary | |
|---|---|---|
 | Application_AfterCalculate() | use Application_AfterCalculate to overcome the problem of auto-fitting formula ranges AFTER calculation (final column width is not available in dblistfetchAction procedure) |
| Application_SheetActivate(Object) | assign command buttons anew with each change of sheets |
| Application_SheetBeforeRightClick(Object, Range, ref Boolean) | Additionally to statically defined context menu in Ribbon this is needed to handle the dynamically displayed CUD DBMapper context menu entries (insert/delete) |
| Application_SheetChange(Object, Range) | Event Procedure needed for CUD DBMappers to capture changes/insertions and set U/D Flag |
| Application_WorkbookActivate(Workbook) | gets defined named ranges for DBMapper invocation in the current workbook after activation and updates Ribbon with it |
| Application_WorkbookBeforeClose(Workbook, ref Boolean) | Clean up after closing workbook, only set flag here, the actual cleanup is only done if workbook is really closed (in WB_Deactivate event) |
| Application_WorkbookDeactivate(Workbook) | Actually clean up after closing workbook |
| Application_WorkbookOpen(Workbook) | reset query cache, refresh DB functions and repair legacy functions if existing |
| Application_WorkbookSave(Workbook, Boolean, ref Boolean) | saves defined DBMaps (depending on configuration), also used to remove contents of DBListfunction results (data safety/space consumption) choosing functions for removal of target data is done with custom doc-properties |
 | assignHandler(Object) | assign click handlers to command buttons in passed sheet Sh, maximum 10 buttons are supported |
| AutoClose() | AutoClose cleans up after finishing addin |
| AutoOpen() | connect to Excel when opening Addin |
| cb0_Click() | specific click handler for the 10th definable command button |
| cb1_Click() | specific click handler for the 1st definable command button |
| cb2_Click() | specific click handler for the 2nd definable command button |
| cb3_Click() | specific click handler for the 3rd definable command button |
| cb4_Click() | specific click handler for the 4th definable command button |
| cb5_Click() | specific click handler for the 5th definable command button |
| cb6_Click() | specific click handler for the 6th definable command button |
| cb7_Click() | specific click handler for the 7th definable command button |
| cb8_Click() | specific click handler for the 8th definable command button |
| cb9_Click() | specific click handler for the 9th definable command button |
| cbClick(String) | common click handler for all command buttons |
 | Finalize() | used for releasing com objects |
| mDeleteButton_Click(CommandBarButton, ref Boolean) | dynamic context menu item delete: delete row in CUD Style DBMappers |
| mInsertButton_Click(CommandBarButton, ref Boolean) | dynamic context menu item insert: insert row in CUD Style DBMappers |
Properties
| Name | Summary | |
|---|---|---|
 | Application | the application object needed for excel event handling (most of this class is dedicated to that) |
| cb0 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
 | cb1 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb2 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb3 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb4 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb5 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb6 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb7 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb8 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| cb9 | CommandButton that can be inserted on a worksheet (name property being the same as the respective target range (for DBMapper/DBAction) or DBSeqnce Name) |
| mDeleteButton | context menu delete button |
| mInsertButton | context menu insert button |
Fields
| Name | Description | |
|---|---|---|
 | WbIsClosing | Flag for sharing closing state between Application_WorkbookBeforeClose and Application_WorkbookDeactivate (true for actually closed workbooks) |