Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / CanUserDragFill Property
Example


In This Topic
    CanUserDragFill Property (GcSpreadSheet)
    In This Topic
    Gets or sets whether to allow the user to drag fill a range of cells.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(True)>
    <CategoryAttribute("Spread Workbook")>
    Public Property CanUserDragFill As Boolean
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim value As Boolean
     
    instance.CanUserDragFill = value
     
    value = instance.CanUserDragFill
    [DefaultValue(true)]
    [Category("Spread Workbook")]
    public bool CanUserDragFill {get; set;}
    Example
    This example sets the CanUserDragFill property.
    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
    See Also