Spread Windows Forms 9.0 Product Documentation
ValueSign Property
Example 


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
Requirements

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

See Also

Reference

GcNumberCellType Class
GcNumberCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.