ValueProcessOption Property

Visual Basic
C#

'Declaration
 
Public Property ValueProcessOption As ValueProcessOption

'Usage
 
Dim instance As ValueProcess
Dim value As ValueProcessOption
 
instance.ValueProcessOption = value
 
value = instance.ValueProcessOption

public ValueProcessOption ValueProcessOption {get; set;}

Property Value

The value process option. The default is ValueProcessOption.Keep.

Exception	Description
System.ComponentModel.InvalidEnumArgumentException	The assigned value is not a valid ValueProcessOption value.

This example clears the invalid value.

C#

//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;
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);

Visual Basic

'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
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)

Reference

ValueProcess Class
ValueProcess Members