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, 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() | |
| cb1_Click() | specific click handlers for the five definable command buttons |
| cb2_Click() | |
| cb3_Click() | |
| cb4_Click() | |
| cb5_Click() | |
| cb6_Click() | |
| cb7_Click() | |
| cb8_Click() | |
| cb9_Click() | |
| cbClick(String) | common click handler for all command buttons |
 | Finalize() | |
| 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 | |
| cb0 | |
| cb1 | |
| cb2 | |
| cb3 | |
| cb4 | |
| cb5 | |
| cb6 | |
| cb7 | |
| cb8 | |
| cb9 | |
| mDeleteButton | |
| mInsertButton |
Fields
| Name | Description | |
|---|---|---|
 | WbIsClosing |