Spread WPF 17
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / FillDate Method / FillDate(CellRange,FillSeries,FillDateUnit,Double,DateTime) Method
The fill range.
The fill direction.
The fill date unit.
The fill date step value.
Stops when the fill value exceeds the stop value.


In This Topic
    FillDate(CellRange,FillSeries,FillDateUnit,Double,DateTime) Method
    In This Topic
    Fills the specified range when the source value type is date.
    Syntax
    'Declaration
     
    Public Overloads Sub FillDate( _
       ByVal range As CellRange, _
       ByVal series As FillSeries, _
       ByVal unit As FillDateUnit, _
       ByVal step As Double, _
       ByVal stop As Date _
    ) 
    'Usage
     
    Dim instance As Worksheet
    Dim range As CellRange
    Dim series As FillSeries
    Dim unit As FillDateUnit
    Dim step As Double
    Dim stop As Date
     
    instance.FillDate(range, series, unit, step, stop)
    public void FillDate( 
       CellRange range,
       FillSeries series,
       FillDateUnit unit,
       double step,
       DateTime stop
    )

    Parameters

    range
    The fill range.
    series
    The fill direction.
    unit
    The fill date unit.
    step
    The fill date step value.
    stop
    Stops when the fill value exceeds the stop value.
    Exceptions
    ExceptionDescription
    The range cannot be null.
    Remarks
    The next value is generated by adding the step value to the current value. The step value is affected by the fill date unit.
    See Also