Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ValueProcessOption Enumeration
Example Example


In This Topic
    ValueProcessOption Enumeration
    In This Topic
    Defines the options that are used by ValueProcess.
    Syntax
    'Declaration
     
    Public Enum ValueProcessOption 
       Inherits System.Enum
    'Usage
     
    Dim instance As ValueProcessOption
    public enum ValueProcessOption : System.Enum 
    Members
    MemberDescription
    Clear Clears the value.
    Keep Keeps the value.
    Restore Restores the former 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)
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Win.Spread.ValueProcessOption

    See Also