ValueSign Property (GcNumberCellType)

Visual Basic
C#

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

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.

This example allows the user to type positive values in the cell.

C#

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;

Visual Basic

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

Reference

GcNumberCellType Class
GcNumberCellType Members