DecimalSeparator Property (NumberDecimalSeparatorDisplayFieldInfo)

In This Topic

Gets or sets the character to use as the decimal separator in display numeric values.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DecimalSeparator As Char

'Usage
 
Dim instance As NumberDecimalSeparatorDisplayFieldInfo
Dim value As Char
 
instance.DecimalSeparator = value
 
value = instance.DecimalSeparator

public char DecimalSeparator {get; set;}

Property Value

The character to use as the decimal separator in display numeric values.

Remarks

The property retrieves the decimal separator. The default value depends on the system information.

Example

This examples sets the display fields.

GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalPartDisplayFieldInfo ndp = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalPartDisplayFieldInfo();
ndp.MaxDigits = 3;
ndp.BackColor = Color.Orange; //PaintByControl must be true for appearance properties
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalSeparatorDisplayFieldInfo ndecimal = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalSeparatorDisplayFieldInfo();
ndecimal.DecimalSeparator = Convert.ToChar("A");
GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberIntegerPartDisplayFieldInfo npart = new GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberIntegerPartDisplayFieldInfo();
npart.MinDigits = 3;
npart.BackColor = Color.Bisque;
GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType ncell1 = new GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType();
ncell1.DropDownCalculator.FlatStyle = FlatStyle.Popup;
ncell1.DropDownCalculator.Font = new System.Drawing.Font("Comic Sans MS", 10);
ncell1.PaintByControl = true;
ncell1.DisplayFields.Add(ndp);
ncell1.DisplayFields.Add(ndecimal);
ncell1.DisplayFields.Add(npart);
fpSpread1.Sheets[0].Cells[1, 1].CellType = ncell1;
fpSpread1.ActiveSheet.Cells[1, 1].Value = 12.3189;

Visual Basic

Dim ndp As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalPartDisplayFieldInfo()
ndp.MaxDigits = 3
ndp.BackColor = Color.Orange 'PaintByControl must be true for appearance properties
Dim ndecimal As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberDecimalSeparatorDisplayFieldInfo()
ndecimal.DecimalSeparator = Convert.ToChar("A")
Dim npart As New GrapeCity.Win.Spread.InputMan.CellType.Fields.NumberIntegerPartDisplayFieldInfo()
npart.MinDigits = 3
npart.BackColor = Color.Bisque
Dim ncell1 As New GrapeCity.Win.Spread.InputMan.CellType.GcNumberCellType()
ncell1.DropDownCalculator.FlatStyle = FlatStyle.Popup
ncell1.DropDownCalculator.Font = New System.Drawing.Font("Comic Sans MS", 10)
ncell1.PaintByControl = True
ncell1.DisplayFields.Add(ndp)
ncell1.DisplayFields.Add(ndecimal)
ncell1.DisplayFields.Add(npart)
fpSpread1.ActiveSheet.Cells(1, 1).CellType = ncell1
fpSpread1.ActiveSheet.Cells(1, 1).Value = 12.3189

Reference

NumberDecimalSeparatorDisplayFieldInfo Class
NumberDecimalSeparatorDisplayFieldInfo Members

Product Support Forum | Print this page