DateTimeCellType Constructor(String)

Creates a new date-time cell with the specified error message.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal errorMessage As String _
)

'Usage
 
Dim errorMessage As String
 
Dim instance As New DateTimeCellType(errorMessage)

public DateTimeCellType( 
   string errorMessage
)

Parameters

errorMessage: Message (as string) to display if the input value is not valid

Example

The following example creates a date-time cell with a message to display for invalid data and a custom date format. The date format displays the weekday, a comma, and then the month and day for the specified date. The column width is set to display all the text.

Visual Basic

Dim datecell As New FarPoint.Web.Spread.DateTimeCellType("Needadate!!")
datecell.FormatString="d"
FpSpread1.Sheets(0).Cells(0,0).CellType=datecell
FpSpread1.Sheets(0).Cells(0,0).Value=System.DateTime.Now.ToOADate()
FpSpread1.Sheets(0).Columns(0).Width=175

FarPoint.Web.Spread.DateTimeCellType datecell=new FarPoint.Web.Spread.DateTimeCellType("Needadate!!");
datecell.FormatString="d";
FpSpread1.Sheets[0].Cells[0,0].CellType=datecell;
FpSpread1.Sheets[0].Cells[0,0].Value=System.DateTime.Now.ToOADate();
FpSpread1.Sheets[0].Columns[0].Width=175;

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DateTimeCellType Class
DateTimeCellType Members
Overload List
ErrorMessage Property