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


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

Property Value

A GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat enumeration indicates the pattern of the field.
The default is GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat.DBNum1_G.
Remarks
The property retrieves the display pattern of the NumberDecimalGeneralFormatDisplayField when the GrapeCity.Win.Spread.InputMan.CellType.GcNumber hasn't the input focus.
Example
This example sets a display format.
// DecimalGeneralFormat only works for ja-JP or zh-CN culture. It is similar to Excel.
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo numfield = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo();
numfield.Pattern = GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat.DBNum1_G;
numfield.BackColor = Color.Bisque;
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.DisplayFields.Add(numfield);
ncell1.PaintByControl = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 12.31;
'DecimalGeneralFormat only works for ja-JP or zh-CN culture. It is similar to Excel.
Dim numfield As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalGeneralFormatDisplayFieldInfo()
numfield.Pattern = GrapeCity.Win.Spread.InputMan.CellType.DecimalGeneralFormat.DBNum1_G
numfield.BackColor = Color.Bisque
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.DisplayFields.Add(numfield)
ncell1.PaintByControl = True
fpSpread1.Sheets(0).Cells(1, 1).CellType = ncell1
fpSpread1.ActiveSheet.Cells(1, 1).Value = 12.31
See Also

Reference

NumberDecimalGeneralFormatDisplayFieldInfo Class
NumberDecimalGeneralFormatDisplayFieldInfo Members