FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > IntegerCellType.EditModeSettings Class : NumberFormat Property |
'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;}
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
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional