Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DateTimeCellType Class / DateTimeCellType Constructor / DateTimeCellType Constructor(String)
Message (as string) to display if the input value is not valid
Example


In This Topic
    DateTimeCellType Constructor(String)
    In This Topic
    Creates a new date-time cell with the specified error message.
    Syntax
    '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.
    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;
    See Also

    Reference

    DateTimeCellType Class
    DateTimeCellType Members
    Overload List
    ErrorMessage Property