NumberFormat Property (IntegerCellType.EditModeSettings)

Visual Basic
C#

'Declaration
 
Public Property NumberFormat As NumberFormatInfo

'Usage
 
Dim instance As IntegerCellType.EditModeSettings
Dim value As NumberFormatInfo
 
instance.NumberFormat = value
 
value = instance.NumberFormat

public NumberFormatInfo NumberFormat {get; set;}

If the EditMode property is set and the user enters edit mode in the cell, the value is displayed in the editor using the edit mode format. If the EditMode property is set and the user leaves edit mode in the cell, the value is converted to the display format if it is valid. If the EditMode property is not set, the display format is applied after the cell is updated (default behavior).

This example sets a format for edit mode.

C#

protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FarPoint.Web.Spread.IntegerCellType ict = new FarPoint.Web.Spread.IntegerCellType();
ict.NumberFormat = new System.Globalization.NumberFormatInfo();
//Display mode, leave edit mode
ict.NumberFormat.NumberGroupSeparator = "?";
//Start edit mode
ict.EditMode.NumberFormat = new System.Globalization.NumberFormatInfo();
ict.EditMode.NumberFormat.NegativeSign = "~";
FpSpread1.Sheets[0].Columns[1].CellType = ict;
FpSpread1.Sheets[0].Cells[1, 1].Value = -34567;                           
}

VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
    Return
End If
Dim ict As New FarPoint.Web.Spread.IntegerCellType()
ict.NumberFormat = New System.Globalization.NumberFormatInfo()
'Display mode, leave edit mode
ict.NumberFormat.NumberGroupSeparator = "?"
'Start edit mode
ict.EditMode.NumberFormat = New System.Globalization.NumberFormatInfo()
ict.EditMode.NumberFormat.NegativeSign = "~"
FpSpread1.Sheets(0).Columns(1).CellType = ict
FpSpread1.Sheets(0).Cells(1, 1).Value = -34567
End Sub

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

IntegerCellType.EditModeSettings Class
IntegerCellType.EditModeSettings Members