TdxSpreadSheetCustomView.BeginUpdate Method

Disables repainting operations for the worksheet area displayed by the Spreadsheet control.

Declaration

procedure BeginUpdate;

Remarks

Each time a change is made within the worksheet, the Spreadsheet control initiates repainting to reflect these changes. The list of operations resulting in the worksheet repainting includes row and column appearance customization, cell management, floating container customization, etc.

To improve the performance of a spreadsheet-based application, enclose the code that performs multiple worksheet modifications within the BeginUpdate/EndUpdate procedure blocks.

The BeginUpdate procedure postpones updates. To apply the changes made, invoke the EndUpdate procedure. Ensure that every call to BeginUpdate is followed by a call to the EndUpdate procedure, even if an exception occurs.

Note

In addition to the worksheet’s BeginUpdate/EndUpdate procedures, individual floating containers, table item groups, and cell objects provide their own BeginUpdate/EndUpdate procedure sets.