ValueSign Property

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

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

GcNumberCellType Class
GcNumberCellType Members