TdxSpreadSheetCustomConditionalFormatting.EndUpdate Method

Enables repainting the worksheet or Grid View after calling the BeginUpdate procedure.

Declaration

procedure EndUpdate;

Remarks

Each change made to a conditional formatting rule managed by the controller modifies the affected cells’ appearance, which results in repainting of the corresponding worksheet or Grid View to reflect the changes. Therefore, performing multiple conditional formatting controller and/or rule changes results in a sequence of multiple repainting operations. Enclose the code affecting conditional formatting rules, and/or cell area/style settings within the BeginUpdate/EndUpdate procedure blocks to improve performance in such cases.

The BeginUpdate procedure postpones the effect of changes made to conditional formatting rules within a worksheet or Grid View. Call the EndUpdate procedure to apply all the pending changes. Ensure that every BeginUpdate call is followed by an EndUpdate call, even if an exception occurs.

Note

The EndUpdate procedure internally calls the Owner.EndUpdate procedure.