MaximumValue Property (DateTimeCellType)

Visual Basic
C#

'Declaration
 
Public Property MaximumValue As Date

'Usage
 
Dim instance As DateTimeCellType
Dim value As Date
 
instance.MaximumValue = value
 
value = instance.MaximumValue

public DateTime MaximumValue {get; set;}

Property Value

DateTime object containing the maximum date-time value

C#

FarPoint.Web.Spread.DateTimeCellType dt = new FarPoint.Web.Spread.DateTimeCellType();
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.LongDatePattern = "D";
dtf.ShortDatePattern = "M/d/yyyy";
dt.DateTimeFormat = dtf;
dt.MaximumValue = new Date(2020, 12, 31);
dt.MinimumValue = new Date(1950, 1, 1);
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = dt;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;

Visual Basic

Dim dt As New FarPoint.Web.Spread.DateTimeCellType
Dim dtf As New System.Globalization.DateTimeFormatInfo
dtf.LongDatePattern = "D"
dtf.ShortDatePattern = "M/d/yyyy"
dt.DateTimeFormat = dtf
dt.MaximumValue = New Date(2020, 12, 31)
dt.MinimumValue = New Date(1950, 1, 1)
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = dt
FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

DateTimeCellType Class
DateTimeCellType Members
MinimumValue Property