GrapeCity.Xaml.SpreadSheet.Data Namespace : FillSeries Enumeration |
'Declaration Public Enum FillSeries Inherits System.Enum
'Usage Dim instance As FillSeries
public enum FillSeries : System.Enum
Member | Description |
---|---|
Column | Fills the column data. |
Row | Fills the row data. |
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
System.Object
System.ValueType
System.Enum
GrapeCity.Xaml.SpreadSheet.Data.FillSeries
Target Platforms: Windows Server 2012, Windows RT