Spread Windows Forms 11.0 Product Documentation
Pattern Property (NumberMoneyPatternDisplayFieldInfo)
Example 


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

Property Value

A System.String value indicates the pattern of the field.
The default is ###[####:万].
Remarks
The property retrieves the display pattern of the NumberMoneyPatternDisplayField when the GrapeCity.Win.Spread.InputMan.CellType.GcNumber hasn't the input focus.
Example
This example sets the Pattern property.
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberMoneyPatternDisplayFieldInfo mfield = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberMoneyPatternDisplayFieldInfo();
mfield.BackColor = Color.Yellow;
mfield.Pattern = "###[##:百]";  //or mfield.Pattern = "###[###:K]";
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.DisplayFields.Add(mfield);
ncell1.PaintByControl = true;
fpSpread1.ActiveSheet.Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 7000;
Dim mfield As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberMoneyPatternDisplayFieldInfo()
mfield.BackColor = Color.Yellow
mfield.Pattern = "###[##:百]"   'or mfield.Pattern = "###[###:K]";
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.DisplayFields.Add(mfield)
ncell1.PaintByControl = True
FpSpread1.ActiveSheet.Cells(1, 1).CellType = ncell1
FpSpread1.ActiveSheet.Cells(1, 1).Value = 7000
See Also

Reference

NumberMoneyPatternDisplayFieldInfo Class
NumberMoneyPatternDisplayFieldInfo Members