ITabFormatCellContent.ValueCondition

Syntax

ValueCondition: TabConditionCellContentValue;

Description

The ValueCondition property determines a condition for values, which should be verified for formatted cells.

Comments

Depending on the selected condition, it is also necessary to set the CellValue property, or the MinValue and MaxValue properties. This property is used, if the ContentType is set to the CellValue value.

Example

Executing the example requires a form with the Button1 button located on it, the TabSheetBox component named TabSheetBox1 and a data source for TabSheetBox.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);

Var

Tab: ITabSheet;

Range: ITabRange;

FormCond: ITabFormatCondition;

ValFormat: ITabFormatCellContent;

Style: ITabCellStyle;

Begin

Style := New TabCellStyle.Create;

Style.Font.Color := GxColor.FromName("White");

Style.BackgroundColor := GxColor.FromName("Black");

Tab := TabSheetBox1.Source.GetTabSheet;

Range := Tab.View.Selection.Range;

FormCond := Range.FormatConditions.Add;

FormCond.Type := TabConditionType.CellContent;

ValFormat := FormCond.Details As ITabFormatCellContent;

ValFormat.ContentType := TabFormatContentType.CellValue;

ValFormat.ValueCondition := TabConditionCellContentValue.Between;

ValFormat.MinValue := 0;

ValFormat.MaxValue := 100;

ValFormat.Style := Style;

End Sub Button1OnClick;

As a result, when the button is clicked, for the selected cell range a conditional format will e added, which applies to cells with certain values. Cell values from the range "0-100", will be displayed in white font on black background.