Excel Events
link - learn.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) |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext