GrapeCity.Documents.Excel.IFormatCondition.TextOperator

TextOperator Property

TextOperator

Returns one of the constants of the ContainsOperator enumeration,specifying the text search performed by the conditional formatting rule.

Use this property with a TextString conditional formatting rule to control whether the rule checks if cell text contains or does not contain the specified text, or begins or ends with it.

Declaration

ContainsOperator TextOperator { get; set; }

Property TextOperator As ContainsOperator

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{"Apple"}, {"Pear"}, {"Apricot"}, {"Plum"}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["A1:A4"]
    .FormatConditions.Add(FormatConditionType.TextString);
condition.Interior.Color = Color.Yellow;
condition.Text = "Ap";
condition.TextOperator = ContainsOperator.BeginsWith;
ContainsOperator textOperator = condition.TextOperator;