IdxSpreadSheetConditionalFormattingOwner.BeginUpdate Method

Disables repainting of the worksheet or Grid View until the EndUpdate procedure is called.

Declaration

procedure BeginUpdate;

Remarks

Each change made to a 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 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 BeginUpdate procedure calls the BeginUpdate procedure.