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_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 |
 | AutoClose() | AutoClose cleans up after finishing addin |
| AutoOpen() | connect to Excel when opening Addin |
| cleanupHandlers() | COM cleanup for query table objects and command buttons inside their handlers |
 | Finalize() | used for releasing com objects |
| InitializeCBHandlers(Object) | assign click handlers to command buttons in passed workbook Wb |
| InitializeQueryHandlers(Workbook) | initialize query handlers inside list objects for workbook wb, needed for catching refresh event to avoid sheetchange event execution |
| 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) |
| mDeleteButton | context menu delete button |
| mInsertButton | context menu insert button |
Fields
| Name | Description | |
|---|---|---|
 | colCommandButtons | collection of command button handlers for assigned DB modifiers |
| colQueries | collection of query refresh handlers for query objects inside list objects |
 | WbIsClosing | Flag for sharing closing state between Application_WorkbookBeforeClose and Application_WorkbookDeactivate (true for actually closed workbooks) |