TdxSpreadSheetCustomConditionalFormattingRule.EndUpdate Method

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

Declaration

procedure EndUpdate;

Remarks

Each change made to the conditional formatting rule 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 rule changes at once results in a sequence of multiple repainting operations. Enclose the code changing the rule’s cell style settings, condition expressions, and affected cell areas within the BeginUpdate/EndUpdate procedure blocks to improve performance in such cases.

The BeginUpdate procedure postpones the effect of changes made to the conditional formatting rule applied to one or more cells/cell ranges 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 conditional formatting controller‘s EndUpdate procedure.