ComparedOperator Property (CompareStringValidator)

Visual Basic
C#

'Declaration
 
Public Property ComparedOperator As CompareStringValidatorOperator

'Usage
 
Dim instance As CompareStringValidator
Dim value As CompareStringValidatorOperator
 
instance.ComparedOperator = value
 
value = instance.ComparedOperator

public CompareStringValidatorOperator ComparedOperator {get; set;}

Property Value

The compared operator. The default is CompareStringValidatorOperator.Equals.

Exception	Description
System.ComponentModel.InvalidEnumArgumentException	The assigned value is not defined in CompareStringValidatorOperator.

This example displays an icon if the cell value is invalid.

C#

//Type a value in cell 1,1
FarPoint.Win.Spread.IconNotify iconn = new FarPoint.Win.Spread.IconNotify();
iconn.Icon = new System.Drawing.Icon("C:\\Program Files (x86)\\GrapeCity\\spread.ico");
iconn.IconAlignment = ContentAlignment.MiddleCenter;
iconn.IconTip = "Must contain Test";
FarPoint.Win.Spread.CompareStringValidator svalid = new FarPoint.Win.Spread.CompareStringValidator();
svalid.ComparedOperator = FarPoint.Win.Spread.CompareStringValidatorOperator.Contains;
svalid.ComparedString = "Test";
svalid.Actions.Add(iconn);
fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), svalid);
fpSpread1.Sheets[0].Columns[1].Width = 140;
fpSpread1.Sheets[0].Rows[1].Height = 50;

Visual Basic

'Type a value in cell 1,1
Dim iconn As New FarPoint.Win.Spread.IconNotify()
iconn.Icon = New System.Drawing.Icon("C:\Program Files (x86)\GrapeCity\spread.ico")
iconn.IconAlignment = ContentAlignment.MiddleCenter
iconn.IconTip = "Must contain Test"
Dim svalid As New FarPoint.Win.Spread.CompareStringValidator()
svalid.ComparedOperator = FarPoint.Win.Spread.CompareStringValidatorOperator.Contains
svalid.ComparedString = "Test"
svalid.Actions.Add(iconn)
FpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), svalid)
FpSpread1.Sheets(0).Columns(1).Width = 140
FpSpread1.Sheets(0).Rows(1).Height = 50

Reference

CompareStringValidator Class
CompareStringValidator Members