FarPoint.Win.Spread
MinimumTime Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > DateTimeCellType Class : MinimumTime Property


Gets or sets the minimum time value allowed for user entry.

Syntax

Visual Basic (Declaration) 
Public Property MinimumTime As TimeSpan
Visual Basic (Usage)Copy Code
Dim instance As DateTimeCellType
Dim value As TimeSpan
 
instance.MinimumTime = value
 
value = instance.MinimumTime
C# 
public TimeSpan MinimumTime {get; set;}

Return Value

TimeSpan object containing the minimum allowed time

Exceptions

ExceptionDescription
ArgumentOutOfRangeException 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.
C#Copy Code
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;
Visual BasicCopy Code
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