Spread Windows Forms 11.0 Product Documentation
ValueProcessOption Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ValueProcess Class : ValueProcessOption Property
Gets or sets the ValueProcessOption object.
Syntax
'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.
Exceptions
ExceptionDescription
The assigned value is not a valid ValueProcessOption value.
Example
This example clears the invalid value.
//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);
'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)
See Also

Reference

ValueProcess Class
ValueProcess Members