IdxSpreadSheetConditionalFormattingOwner.EndUpdate Method

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

Declaration

procedure EndUpdate;

Remarks

Each change made to a conditional formatting rule modifies the affected cell’s 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 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.

The conditional formatting controller‘s EndUpdate procedure calls the EndUpdate procedure.