Excel Events

link - docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-events
enumeration - Excel.EventType.tableAdded


onSelectionChanged event is unstable
link - github.com/OfficeDev/office-js/issues/533


ChartonActivatedOccurs when the chart is activated. (1.8)
 onAdded?
 onDeactivatedOccurs when the chart is deactivated. (1.8)
 onDeleted?
ChartCollectiononActivatedOccurs when a chart is activated. (1.8)
 onAddedOccurs when an object is added to the collection. (1.8)
 onDeactivatedOccurs when a chart is deactivated. (1.8)
 onDeletedOccurs when an object is deleted from the collection. (1.8)
Binding ?onDataChangedOccurs when data or formatting within the binding is changed. (1.9)
 onSelectionChangedOccurs when the active cell or selected range is changed. (1.9)
SettingCollection ?onSettingsChanged 
ShapeonActivatedOccurs when the shape is activated. (1.9)
 onDeactivatedOccurs when the shape is deactivated. (1.9)
TableonChangedOccurs when data changes on a specific table. (1.7)
 onFiltered(beta)
 onSelectionChangedOccurs when the selection changed on a specific table. (1.7)
TableCollectiononAddedOccurs when an object is added to the collection. (1.9)
 onChangedOccurs when data is changed on any table in a workbook, or a worksheet. (1.7)
 onDeletedOccurs when an object is deleted from the collection. (1.9)
 onFiltered(beta)
WorkbookonAutoSaveSettingChangedOccurs when the AutoSave setting is changed on the workbook. (1.9)
 onSelectionChangedOccurs when the active cell or selected range is changed on the workbook. (1.2)
WorksheetonActivatedOccurs when the worksheet is activated. (1.7)
 onCalculatedOccurs when the worksheet has finished calculation. (1.8)
 onChangedOccurs when data changes on a specific worksheet. (1.7)
 onColumnSortedOccurs when one or more columns have been sorted. Left-to-Right column sort operation. (1.10)
 onDeactivatedOccurs when the worksheet is deactivated. (1.7)
 onFiltered(beta) Occurs when filter is applied on a specific worksheet.
 onFormatChangedOccurs when the format changes on a specific worksheet. (1.9)
 onRowHiddenChangedOccurs when the hidden state of one or more rows has changed on a specific worksheet. (1.11)
 onRowSortedOccurs when one or more rows have been sorted. Top-to-Bottom row sort operation. (1.10)
 onSelectionChangedOccurs when the selection changed on a specific worksheet. (1.7)
 onSingleClickedOccurs when a left-clicked/tapped action happens in the worksheet. (1.10)
WorksheetCollectiononActivatedOccurs when any worksheet in the workbook is activated. (1.7)
 onAddedOccurs when a new worksheet is added to the workbook. (1.7)
 onCalculatedOccurs when all the worksheets in the collection have finished calculation. (1.8)
 onChangedOccurs when any worksheet in the workbook is changed. (1.9)
 onColumnSortedOccurs when one or more columns have been sorted. Left-to-Right column sort operation. (1.10)
 onDeactivatedOccurs when any worksheet in the workbook is deactivated. (1.7)
 onDeletedOccurs when a worksheet is deleted from the workbook. (1.7)
 onFiltered(beta) Occurs when any worksheet's filter is applied in the workbook.
 onFormatChangedOccurs when any worksheet in the workbook has format changed. (1.9)
 onRowHiddenChangedOccurs when the hidden state of one or more rows has changed on a specific worksheet. (1.11)
 onRowSortedOccurs when one or more rows have been sorted. Top-to-Bottom row sort operation. (1.10)
 onSelectionChangedOccurs when the selection changes on any worksheet. (1.9)
 onSingleClickedOccurs when left-clicked/tapped operation happens in the worksheet collection. (1.10)

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext