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


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

    Property Value

    DateTime object containing the minimum 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