FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > DateTimeCellType Class : MaximumDate Property |
'Declaration Public Property MaximumDate As Date
'Usage Dim instance As DateTimeCellType Dim value As Date instance.MaximumDate = value value = instance.MaximumDate
public DateTime MaximumDate {get; set;}
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8