Spread Windows Forms 11.0 Product Documentation
NegativePattern Property (NumberSignDisplayFieldInfo)
Example 


GrapeCity.Win.PluginInputMan Assembly > GrapeCity.Win.Spread.InputMan.CellType.Fields Namespace > NumberSignDisplayFieldInfo Class : NegativePattern Property
Gets or sets the negative pattern of the NumberSignDisplayField.
Syntax
'Declaration
 
Public Property NegativePattern As String
'Usage
 
Dim instance As NumberSignDisplayFieldInfo
Dim value As String
 
instance.NegativePattern = value
 
value = instance.NegativePattern
public string NegativePattern {get; set;}

Property Value

A System.String value indicates the negative pattern.
Remarks
The property retrieves the pattern when the value is negative.
Example
This example sets the NegativePattern field.
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberSignDisplayFieldInfo nsign = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberSignDisplayFieldInfo();
nsign.NegativePattern = "-##.##";
nsign.PositivePattern = "##.##";
nsign.BackColor = Color.Yellow;
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.DisplayFields.Add(nsign);
ncell1.PaintByControl = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 12.31;
Dim nsign As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberSignDisplayFieldInfo()
nsign.NegativePattern = "-##.##"
nsign.PositivePattern = "##.##"
nsign.BackColor = Color.Yellow
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.DisplayFields.Add(nsign)
ncell1.PaintByControl = True
fpSpread1.Sheets(0).Cells(1, 1).CellType = ncell1
fpSpread1.ActiveSheet.Cells(1, 1).Value = 12.31
See Also

Reference

NumberSignDisplayFieldInfo Class
NumberSignDisplayFieldInfo Members