Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DateTimeCellType Class / MaximumValue Property
Example


In This Topic
    MaximumValue Property (DateTimeCellType)
    In This Topic
    Gets or sets the maximum value.
    Syntax
    '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
    Example
    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;
    
    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
    See Also