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
| Chart | onActivated | Occurs when the chart is activated. (1.8) |
| onAdded | ? | |
| onDeactivated | Occurs when the chart is deactivated. (1.8) | |
| onDeleted | ? | |
| ChartCollection | onActivated | Occurs when a chart is activated. (1.8) |
| onAdded | Occurs when an object is added to the collection. (1.8) | |
| onDeactivated | Occurs when a chart is deactivated. (1.8) | |
| onDeleted | Occurs when an object is deleted from the collection. (1.8) | |
| Binding ? | onDataChanged | Occurs when data or formatting within the binding is changed. (1.9) |
| onSelectionChanged | Occurs when the active cell or selected range is changed. (1.9) | |
| SettingCollection ? | onSettingsChanged | |
| Shape | onActivated | Occurs when the shape is activated. (1.9) |
| onDeactivated | Occurs when the shape is deactivated. (1.9) | |
| Table | onChanged | Occurs when data changes on a specific table. (1.7) |
| onFiltered | (beta) | |
| onSelectionChanged | Occurs when the selection changed on a specific table. (1.7) | |
| TableCollection | onAdded | Occurs when an object is added to the collection. (1.9) |
| onChanged | Occurs when data is changed on any table in a workbook, or a worksheet. (1.7) | |
| onDeleted | Occurs when an object is deleted from the collection. (1.9) | |
| onFiltered | (beta) | |
| Workbook | onAutoSaveSettingChanged | Occurs when the AutoSave setting is changed on the workbook. (1.9) |
| onSelectionChanged | Occurs when the active cell or selected range is changed on the workbook. (1.2) | |
| Worksheet | onActivated | Occurs when the worksheet is activated. (1.7) |
| onCalculated | Occurs when the worksheet has finished calculation. (1.8) | |
| onChanged | Occurs when data changes on a specific worksheet. (1.7) | |
| onColumnSorted | Occurs when one or more columns have been sorted. Left-to-Right column sort operation. (1.10) | |
| onDeactivated | Occurs when the worksheet is deactivated. (1.7) | |
| onFiltered | (beta) Occurs when filter is applied on a specific worksheet. | |
| onFormatChanged | Occurs when the format changes on a specific worksheet. (1.9) | |
| onFormulaChanged | Occurs when a formula changes on a specific worksheet. (1.13) | |
| onRowHiddenChanged | Occurs when the hidden state of one or more rows has changed on a specific worksheet. (1.11) | |
| onRowSorted | Occurs when one or more rows have been sorted. Top-to-Bottom row sort operation. (1.10) | |
| onSelectionChanged | Occurs when the selection changed on a specific worksheet. (1.7) | |
| onSingleClicked | Occurs when a left-clicked/tapped action happens in the worksheet. (1.10) | |
| WorksheetCollection | onActivated | Occurs when any worksheet in the workbook is activated. (1.7) |
| onAdded | Occurs when a new worksheet is added to the workbook. (1.7) | |
| onCalculated | Occurs when all the worksheets in the collection have finished calculation. (1.8) | |
| onChanged | Occurs when any worksheet in the workbook is changed. (1.9) | |
| onColumnSorted | Occurs when one or more columns have been sorted. Left-to-Right column sort operation. (1.10) | |
| onDeactivated | Occurs when any worksheet in the workbook is deactivated. (1.7) | |
| onDeleted | Occurs when a worksheet is deleted from the workbook. (1.7) | |
| onFiltered | (beta) Occurs when any worksheet's filter is applied in the workbook. | |
| onFormatChanged | Occurs when any worksheet in the workbook has format changed. (1.9) | |
| onRowHiddenChanged | Occurs when the hidden state of one or more rows has changed on a specific worksheet. (1.11) | |
| onRowSorted | Occurs when one or more rows have been sorted. Top-to-Bottom row sort operation. (1.10) | |
| onSelectionChanged | Occurs when the selection changes on any worksheet. (1.9) | |
| onSingleClicked | Occurs when left-clicked/tapped operation happens in the worksheet collection. (1.10) |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext