Pattern Property (NumberDecimalGeneralFormatDisplayFieldInfo)

Visual Basic
C#

'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.

The property retrieves the display pattern of the NumberDecimalGeneralFormatDisplayField when the GrapeCity.Win.Spread.InputMan.CellType.GcNumber hasn't the input focus.

This example sets a display format.

C#

// 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;

Visual Basic

'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

Reference

NumberDecimalGeneralFormatDisplayFieldInfo Class
NumberDecimalGeneralFormatDisplayFieldInfo Members