Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / IntegerCellType.EditModeSettings Class / NumberFormat Property
Example


In This Topic
    NumberFormat Property (IntegerCellType.EditModeSettings)
    In This Topic
    Gets or sets a NumberFormatInfo that defines the format of an editing number.
    Syntax
    '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;}
    Remarks
    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).
    Example
    This example sets a format for edit mode.
    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;                           
    }
    
    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
    
    See Also