Spread WPF 17
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / FillAuto Method / FillAuto(CellRange,FillDirection) Method
The cell range.
The fill direction.


In This Topic
    FillAuto(CellRange,FillDirection) Method
    In This Topic
    Fills the specified range in the specified direction.
    Syntax
    'Declaration
 
Public Overloads Sub FillAuto( _
   ByVal range As CellRange, _
   ByVal direction As FillDirection _
) 
    'Usage
 
Dim instance As Worksheet
Dim range As CellRange
Dim direction As FillDirection
 
instance.FillAuto(range, direction)
    public void FillAuto( 
   CellRange range,
   FillDirection direction
)

    Parameters

    range
    The cell range.
    direction
    The fill direction.
    Exceptions
    ExceptionDescription
    System.ArgumentNullException The range cannot be null.
    Remarks
    For instance : CellRange cellrange=new (0,0,10,10); sheet.FillRange(cellrange,FillDirection.Down); This example fills the Cell[0,1] to Cell[0,9] using Cell[0,0].
    See Also

    Reference

    Worksheet Class
    Worksheet Members
    Overload List