Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DateTimeCellType Class / MinimumValue Property
Example


In This Topic
    MinimumValue Property (DateTimeCellType)
    In This Topic
    Gets or sets the minimum value.
    Syntax
    'Declaration
     
    Public Property MinimumValue As Date
    'Usage
     
    Dim instance As DateTimeCellType
    Dim value As Date
     
    instance.MinimumValue = value
     
    value = instance.MinimumValue
    public DateTime MinimumValue {get; set;}

    Property Value

    DateTime object containing the minimum 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