FillSeries Enumeration

Represents the series type of fill data.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum FillSeries 
   Inherits System.Enum

'Usage
 
Dim instance As FillSeries

public enum FillSeries : System.Enum

Members

Member	Description
Column	Fills the column data.
Row	Fills the row data.

Example

This example uses the FillSeries enumeration.

C#
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);

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

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)

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

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Xaml.SpreadSheet.Data.FillSeries

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace