Spread WPF Documentation
ShowAutoFillIndicator Method
Example 


Displays the automatic fill indicator.
Syntax
'Declaration
 
Public Sub ShowAutoFillIndicator() 
'Usage
 
Dim instance As SheetView
 
instance.ShowAutoFillIndicator()
public void ShowAutoFillIndicator()
Example
This example creates a drag fill option in the toolbar.
private GrapeCity.Windows.SpreadSheet.UI.TouchToolbar _toolbar;        

        public MainPage()
        {
            InitializeComponent();
            this.InitializeTouchStrip();           
        }            

        private void GcSpreadSheet1_TouchToolbarOpening(object sender, GrapeCity.Windows.SpreadSheet.UI.TouchToolbarOpeningEventArgs e)
        {
            e.Handled = true;
     _toolbar.Show(e.X - 100, e.Y - 100);     
        }

        void autoFill_Click(object sender, EventArgs e)
        {
            var activeView = this.GcSpreadSheet1.View;
            if (activeView != null)
            {
                activeView.ShowAutoFillIndicator();
            }
        }

        private void InitializeTouchStrip()
        {
            _toolbar = GrapeCity.Windows.SpreadSheet.UI.TouchToolbarFactory.CreateCutCopyPasteToolBar(this.GcSpreadSheet1.View);
            var separator = new GrapeCity.Windows.SpreadSheet.UI.ToolbarSeparator();
            _toolbar.ToolbarItems.Add(separator);
            var autoFillButton = GrapeCity.Windows.SpreadSheet.UI.TouchToolbarFactory.CreateDragFillButton();
            _toolbar.ToolbarItems.Add(autoFillButton);
            autoFillButton.Click += autoFill_Click;
        }
Private _toolbar As GrapeCity.Windows.SpreadSheet.UI.TouchToolbar
    Public Sub New()
        InitializeComponent()
        Me.InitializeTouchStrip()
    End Sub
  
    Private Sub GcSpreadSheet1_TouchToolbarOpening(sender As Object, e As GrapeCity.Windows.SpreadSheet.UI.TouchToolbarOpeningEventArgs) Handles GcSpreadSheet1.TouchToolbarOpening
        e.Handled = True
        _toolbar.Show(e.X - 100, e.Y - 100)
    End Sub

    Private Sub autoFill_Click(sender As Object, e As EventArgs)
        Dim activeView = Me.GcSpreadSheet1.View
        If activeView IsNot Nothing Then
            activeView.ShowAutoFillIndicator()
        End If
    End Sub

    Private Sub InitializeTouchStrip()
        _toolbar = GrapeCity.Windows.SpreadSheet.UI.TouchToolbarFactory.CreateCutCopyPasteToolBar(Me.GcSpreadSheet1.View)
        Dim separator = New GrapeCity.Windows.SpreadSheet.UI.ToolbarSeparator()
        _toolbar.ToolbarItems.Add(separator)
        Dim autoFillButton = GrapeCity.Windows.SpreadSheet.UI.TouchToolbarFactory.CreateDragFillButton()
        _toolbar.ToolbarItems.Add(autoFillButton)
        AddHandler autoFillButton.Click, AddressOf autoFill_Click
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

SheetView Class
SheetView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.