TdxSpreadSheetConditionalFormattingRuleCustomScaleStop.EndUpdate Method

Re-enables repainting of the ExpressSpreadSheet or ExpressQuantumGrid View after calling the BeginUpdate procedure.

Declaration

procedure EndUpdate;

Remarks

Each change made to the threshold value and/or its corresponding visual settings (such as the color of a gradient key point or the icon index in the case of a threshold value associated with an icon) modifies the appearance of all cells to which the threshold-based conditional formatting rule is applied. As a result, the worksheet or Grid View that contains the affected cells is repainted every time to reflect the changes. Therefore, multiple changes made to the threshold value and/or concomitant settings result in a sequence of multiple repaint operations. Enclose the code that modifies multiple threshold-related settings within the BeginUpdate/EndUpdate procedure blocks to improve application performance in such cases.

The BeginUpdate procedure postpones the effect of changes made to the conditional formatting rule’s threshold value. To apply all the pending changes, call the EndUpdate procedure. Ensure that every BeginUpdate call is followed by an EndUpdate call, even if an exception occurs.

Note

The EndUpdate procedure internally calls the EndUpdate procedure of the conditional formatting rule to which the threshold value belongs.