BeginUpdate;
The BeginUpdate method disables some of the table functions to reduce the time required to update and process table data.
When this method is called and up to the moment when the EndUpdate method is called, the following functions are disabled in the table:
Formula values are not calculated.
Undo buffer is disabled.
Events related to data updating in the cell range are disabled (OnBeforeCellsChange, OnCellsChange).
Events related to modifying selected cell range are disabled (OnBeginSelectionChange, OnSelectionChange, OnEndSelectionChange).
After this method is called, the events will occur as follows:
When a cell value is changed for the first time, the OnBeforeCellsChange event occurs just once.
When a selected cell or selected cell range is edited for the first time, the OnBeginSelectionChange event occurs just once.
On further changing of the values, the events related to modification of values in particular cells occur (OnBeforeCellChange, OnCellChange, OnChangeCellContent). Events related to modification of the selected cell range will not occur.
After the EndUpdate method is called, the OnCellsChange, OnSelectionChange and OnEndSelectionChange events occur once.
See also: