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


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

    Property Value

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