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


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

    Property Value

    TimeSpan object containing the minimum allowed time
    Exceptions
    ExceptionDescription
    Specified value out of range; must be between 00:00:00 and 23:59:59.9999999
    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