FillLinear(CellRange,FillSeries,Double,Double) Method

Fills the specified range when the source value type is number.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub FillLinear( _
   ByVal range As CellRange, _
   ByVal series As FillSeries, _
   ByVal step As System.Double, _
   ByVal stop As System.Double _
)

'Usage
 
Dim instance As Worksheet
Dim range As CellRange
Dim series As FillSeries
Dim step As System.Double
Dim stop As System.Double
 
instance.FillLinear(range, series, step, stop)

public void FillLinear( 
   CellRange range,
   FillSeries series,
   System.double step,
   System.double stop
)

Parameters

range: The fill range.
series: The fill direction.
step: The fill step value.
stop: The fill stop value.

Exceptions

Exception	Description
System.ArgumentNullException	The range cannot be null.

Remarks

The next value is generated by the step and stop values. The next value is computed by adding the step value to the current cell value.

Example

This example uses the FillLinear method.

gcSpreadSheet1.CanUserDragFill = true;
gcSpreadSheet1.Sheets[0].SetValue(0, 0, new DateTime(2011, 1, 1));
gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
gcSpreadSheet1.Sheets[0].SetValue(0, 2, 5);
gcSpreadSheet1.Sheets[0].SetValue(0, 3, 10);
gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
gcSpreadSheet1.Invalidate();

        private void button1_Click(object sender, RoutedEventArgs e)
        {
     GrapeCity.Windows.SpreadSheet.Data.CellRange r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1);
        gcSpreadSheet1.Sheets[0].FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2);
        GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1);
        gcSpreadSheet1.Sheets[0].FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, new DateTime(2011, 2, 11));
        GrapeCity.Windows.SpreadSheet.Data.CellRange r3 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1);
        //gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down);
        gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
        GrapeCity.Windows.SpreadSheet.Data.CellRange r4 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1);
        //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
        //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2);
        gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55);
        GrapeCity.Windows.SpreadSheet.Data.CellRange r5 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1);
        //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
        //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3);
        gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20);
        gcSpreadSheet1.Invalidate();
        }

VB.NET

GcSpreadSheet1.CanUserDragFill = True
GcSpreadSheet1.Sheets(0).SetValue(0, 0, New DateTime(2011, 1, 1))
GcSpreadSheet1.Sheets(0).SetValue(0, 1, New DateTime(2011, 2, 9))
GcSpreadSheet1.Sheets(0).SetValue(0, 2, 5)
GcSpreadSheet1.Sheets(0).SetValue(0, 3, 10)
GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1)
GcSpreadSheet1.Invalidate()


    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
        Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1)
        GcSpreadSheet1.Sheets(0).FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2)
        Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1)
        GcSpreadSheet1.Sheets(0).FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, New DateTime(2011, 2, 11))
        Dim r3 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1)
        'GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down)
        GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
        Dim r4 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1)
        'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
        'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2)
        GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55)
        Dim r5 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1)
        'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
        'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3)
        GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20)
        GcSpreadSheet1.Invalidate()
    End Sub

Reference

Worksheet Class
Worksheet Members
Overload List