//Type one of the candidate items in cell 1,1 to see the error notification
FarPoint.Win.Spread.MessageBoxNotify cnotify = new FarPoint.Win.Spread.MessageBoxNotify();
cnotify.Caption = "Error";
cnotify.Message = "Invalid";
cnotify.Icon = MessageBoxIcon.Question;
FarPoint.Win.Spread.ExcludeListValidator excludelist = new FarPoint.Win.Spread.ExcludeListValidator();
excludelist.Candidates = new string[] { "Bird", "Deer", "Squirrel", "Lizard" };
excludelist.Actions.Add(cnotify);
fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), excludelist);
'Type one of the candidate items in cell 1,1 to see the error notification
Dim cnotify As New FarPoint.Win.Spread.MessageBoxNotify()
cnotify.Caption = "Error"
cnotify.Message = "Invalid"
cnotify.Icon = MessageBoxIcon.Question
Dim excludelist As New FarPoint.Win.Spread.ExcludeListValidator()
excludelist.Candidates = New String() {"Bird", "Deer", "Squirrel", "Lizard"}
excludelist.Actions.Add(cnotify)
FpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), excludelist)