TdxCustomSpreadSheet.EndUpdate Method

Enables previously disabled repainting of the Spreadsheet control.

Declaration

procedure EndUpdate;

Remarks

Each time the spreadsheet document’s content is changed, the Spreadsheet control initiates repainting to reflect these changes. The list of operations resulting in the control repainting includes worksheet management, importing/exporting spreadsheet document data, data cell management within the currently active worksheet, etc.

To improve the performance of a spreadsheet-based application, enclose the code that performs multiple spreadsheet document 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 “global” BeginUpdate/EndUpdate procedures, individual worksheets, floating containers, table item groups, and even cell objects provide their own BeginUpdate/EndUpdate procedure sets.