FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > DateTimeCellType Class : MaximumTime Property |
'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;}
Exception | Description |
---|---|
System.ArgumentOutOfRangeException | Specified value out of range; must be between 00:00:00 and 23:59:59 |
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10