GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > FillGrowth Method : FillGrowth(CellRange,FillSeries) Method |
'Declaration Public Overloads Sub FillGrowth( _ ByVal range As CellRange, _ ByVal series As FillSeries _ )
'Usage Dim instance As Worksheet Dim range As CellRange Dim series As FillSeries instance.FillGrowth(range, series)
public void FillGrowth( CellRange range, FillSeries series )
Exception | Description |
---|---|
System.ArgumentNullException | The range cannot be null. |
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(); }
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
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6