//Typing a value outside the range clears the value when leaving the cell
FarPoint.Win.Spread.ValueProcess cnotify = new FarPoint.Win.Spread.ValueProcess();
cnotify.ValueProcessOption = FarPoint.Win.Spread.ValueProcessOption.Clear;
cnotify.DoActionReason = FarPoint.Win.Spread.ValidateReasons.EndEdit;
FarPoint.Win.Spread.TextLengthValidator tvalid = new FarPoint.Win.Spread.TextLengthValidator();
tvalid.LengthUnit = FarPoint.Win.Spread.LengthUnit.Char;
tvalid.MaximumLength = 6;
tvalid.MinimumLength = 0;
tvalid.Actions.Add(cnotify);
fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), tvalid);
'Typing a value outside the range clears the value when leaving the cell
Dim cnotify As New FarPoint.Win.Spread.ValueProcess()
cnotify.ValueProcessOption = FarPoint.Win.Spread.ValueProcessOption.Clear
cnotify.DoActionReason = FarPoint.Win.Spread.ValidateReasons.EndEdit
Dim tvalid As New FarPoint.Win.Spread.TextLengthValidator()
tvalid.LengthUnit = FarPoint.Win.Spread.LengthUnit.Char
tvalid.MaximumLength = 6
tvalid.MinimumLength = 0
tvalid.Actions.Add(cnotify)
FpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), tvalid)