Spread Windows Forms 13.0 Product Documentation
GrapeCity.Win.PluginInputMan Assembly / GrapeCity.Win.Spread.InputMan.CellType Namespace / GcNumberCellType Class / ValueSign Property
Example


In This Topic
    ValueSign Property (GcNumberCellType)
    In This Topic
    Gets or sets the value sign of the control.
    Syntax
    'Declaration
     
    Public Property ValueSign As ValueSignControl
    'Usage
     
    Dim instance As GcNumberCellType
    Dim value As ValueSignControl
     
    instance.ValueSign = value
     
    value = instance.ValueSign
    public ValueSignControl ValueSign {get; set;}

    Property Value

    A ValueSignControl value that indicates the value sign.
    The default is ValueSignControl.NoControl.
    Remarks
    The ValueSign property determines what value can be accepted. If the value is ValueSignControl.Positive, only numbers that are not smaller than zero are allowed. If the value is ValueSignControl.Negative, only numbers that are not bigger than zero are allowed. ValueSignControl.NoControl means all numbers are allowed.
    Example
    This example allows the user to type positive values in the cell.
    GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();            
    ncell1.ValueSign = GrapeCity.Win.Spread.InputMan.CellType.ValueSignControl.Positive;
    fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;
    Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
    ncell1.ValueSign = GrapeCity.Win.Spread.InputMan.CellType.ValueSignControl.Positive
    fpSpread1.Sheets(0).Cells(1, 1).CellType = ncell1
    See Also