EditMode Property (DateTimeCellType)

Visual Basic
C#

'Declaration
 
Public Shadows ReadOnly Property EditMode As DateTimeCellType.EditModeSettings

'Usage
 
Dim instance As DateTimeCellType
Dim value As DateTimeCellType.EditModeSettings
 
value = instance.EditMode

public new DateTimeCellType.EditModeSettings EditMode {get;}

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.

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.DateTimeCellType dct = new FarPoint.Web.Spread.DateTimeCellType();
dct.DateTimeFormat = new System.Globalization.DateTimeFormatInfo();
dct.FormatString = "yyyy/MM/dd";
dct.EditMode.DateTimeFormat = new System.Globalization.DateTimeFormatInfo();
dct.EditMode.FormatString = "yyyy.MM.dd";
FpSpread1.Sheets[0].Columns[1].CellType = dct;
}

VB.NET

protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FarPoint.Web.Spread.DateTimeCellType dct = new FarPoint.Web.Spread.DateTimeCellType();
dct.DateTimeFormat = new System.Globalization.DateTimeFormatInfo();
dct.FormatString = "yyyy/MM/dd";
dct.EditMode.DateTimeFormat = new System.Globalization.DateTimeFormatInfo();
dct.EditMode.FormatString = "yyyy.MM.dd";
FpSpread1.Sheets[0].Columns[1].CellType = dct;
}

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

DateTimeCellType Class
DateTimeCellType Members