Spread for ASP.NET 7.0 Product Documentation
EditMode Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > DoubleCellType Class : EditMode Property


Glossary Item Box

Gets the format setting of a cell type in edit mode.

Syntax

Visual Basic (Declaration) 
Public Shadows ReadOnly Property EditMode As DoubleCellType.EditModeSettings
Visual Basic (Usage)Copy Code
Dim instance As DoubleCellType
Dim value As DoubleCellType.EditModeSettings
 
value = instance.EditMode
C# 
public new DoubleCellType.EditModeSettings EditMode {get;}

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.
C#Copy Code
protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FarPoint.Web.Spread.DoubleCellType dbct = new FarPoint.Web.Spread.DoubleCellType();
dbct.NumberFormat = new System.Globalization.NumberFormatInfo();
dbct.NumberFormat.NumberDecimalDigits = 4;
dbct.NumberFormat.NumberDecimalSeparator = ".";
dbct.EditMode.NumberFormat = new System.Globalization.NumberFormatInfo();
dbct.EditMode.NumberFormat.NumberDecimalSeparator = "?";
dbct.EditMode.DecimalDigits = 5; 
FpSpread1.Sheets[0].Columns[1].CellType = dbct;
}
VB.NETCopy Code
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
    Return
End If
Dim dbct As New FarPoint.Web.Spread.DoubleCellType()
dbct.NumberFormat = New System.Globalization.NumberFormatInfo()
dbct.NumberFormat.NumberDecimalDigits = 4
dbct.NumberFormat.NumberDecimalSeparator = "."
dbct.EditMode.NumberFormat = New System.Globalization.NumberFormatInfo()
dbct.EditMode.NumberFormat.NumberDecimalSeparator = "?"
dbct.EditMode.DecimalDigits = 5
FpSpread1.Sheets(0).Columns(1).CellType = dbct
End Sub

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.