Spread Windows Forms 13.0 Product Documentation
GrapeCity.Win.PluginInputMan Assembly / GrapeCity.Win.Spread.InputMan.CellType Namespace / MaxMinBehavior Enumeration
Example Example

In This Topic
    MaxMinBehavior Enumeration
    In This Topic
    Defines how to process the GcDateTime.Value, GcNubmer.Value, GcTimeSpan.Value, GcDate.Value, and GcTime.Value properties when there is invalid data during input.
    Public Enum MaxMinBehavior 
       Inherits System.Enum
    Dim instance As MaxMinBehavior
    public enum MaxMinBehavior : System.Enum 
    AdjustToMaxMinAdjusts the value to the valid range between the minimum and maximum.
    CancelInputCancels the last input and holds the old text.
    ClearClears the value to a null reference (Nothing in Visual Basic).
    KeepKeeps the last input and holds the old text.
    RestoreRestores the backup value to the specified property.
    This example adjusts values outside the range to the minimum or maximum value.
    GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType inputcell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
    inputcell1.MaxValue = 50;
    inputcell1.MinValue = 0;
    inputcell1.MaxMinBehavior = GrapeCity.Win.Spread.InputMan.CellType.MaxMinBehavior.AdjustToMaxMin;
    fpSpread1.Sheets[0].Cells[1, 1].CellType = inputcell1;
    Dim inputcell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
    inputcell1.MaxValue = 50
    inputcell1.MinValue = 0
    inputcell1.MaxMinBehavior = GrapeCity.Win.Spread.InputMan.CellType.MaxMinBehavior.AdjustToMaxMin
    fpSpread1.Sheets(0).Cells(1, 1).CellType = inputcell1
    Inheritance Hierarchy


    See Also