Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / DateTimeCellType Class / MaximumDate Property
Example


In This Topic
    MaximumDate Property
    In This Topic
    Gets or sets the maximum date value allowed for user entry.
    Syntax
    'Declaration
     
    Public Property MaximumDate As Date
    'Usage
     
    Dim instance As DateTimeCellType
    Dim value As Date
     
    instance.MaximumDate = value
     
    value = instance.MaximumDate
    public DateTime MaximumDate {get; set;}

    Property Value

    DateTime object containing the maximum allowed date
    Example
    This example sets up a cell on the first sheet as a date-time cell and specifies some of the properties available.
    FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType();
    datecell.AMString = "a.m. (morning)";
    datecell.PMString = "p.m. (evening)";
    datecell.DateSeparator = " | ";
    datecell.TimeSeparator = ":";
    datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime;
    datecell.MaximumDate = new System.DateTime(2010, 1, 1);
    datecell.MinimumDate = new System.DateTime(1990, 12, 31);
    datecell.MaximumTime = new System.TimeSpan(15, 59, 59);
    datecell.MinimumTime = new System.TimeSpan(11, 0, 0);
    datecell.SpinButton = true;
    fpSpread1.Sheets[0].Cells[7,2].CellType = datecell;
    fpSpread1.Sheets[0].Cells[7,2].Value = System.DateTime.Now;
    Dim datecell As New FarPoint.Win.Spread.CellType.DateTimeCellType()
    datecell.AMString = "a.m. (morning)"
    datecell.PMString = "p.m. (evening)"
    datecell.DateSeparator = " | "
    datecell.TimeSeparator = ":"
    datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDateWithTime
    datecell.MaximumDate = new System.DateTime(2010, 1, 1)
    datecell.MinimumDate = new System.DateTime(1990, 12, 31)
    datecell.MaximumTime = new System.TimeSpan(15, 59, 59)
    datecell.MinimumTime = new System.TimeSpan(11, 0, 0)
    datecell.SpinButton = True
    fpSpread1.Sheets(0).Cells(7,2).CellType = datecell
    fpSpread1.Sheets(0).Cells(7,2).Value = System.DateTime.Now
    See Also