ITabFormatCellContent.TextCondition

Syntax

TextCondition: TabConditionCellContentText;

Description

The TextCondition property determines the condition by text, which should be verified for formatted cells. This property is used, if the ContentType is set to the SpecificText value.

Example

To execute the example a form, a button on this form named "Button1", a TabSheetBox component named "TabSheetBox1" and a data source for this component are required.

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.SpecificText;

ValFormat.SpecificText := "abc";

ValFormat.TextCondition := TabConditionCellContentText.Contains;

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, containing the "abc" character combination, will be displayed in white font on black background.