Spread for ASP.NET 13 Product Documentation
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