Spread WPF 17
Spread WPF Documentation / Developer's Guide / Using Touch Support with the Component / Using Touch Support / Using Touch Support with Drag and Fill
In This Topic
    Using Touch Support with Drag and Fill
    In This Topic

    You can use touch support gestures and the touch menu bar or strip with drag and fill.

    Using touch menu bar with drag and fill

    Select a range. Tap the range to display the touch menu bar as shown in the above image.

    Tap the AutoFill menu item to display the drag fill handle at the bottom-right edge of the selected range as shown in the image below.

    Using the Autofill menu item

    Press and slide the handle to drag and fill the range. The CanUserDragFill property must be true to display and use the drag fill handle.

    Slide drag fill handle to fill cell ranges with values

    The above image displays a filled range. Click on the drag fill indicator to display additional drag file options as shown in the following image.

    Shortcut menu displaying additional drag fill options

    Using Code

    The following code adds a drag fill option to the touch menu bar.

    1. Create a button in the touch bar strip.
    2. Create an auto fill click event.
    3. Display the drag fill option using the event.
    4. Use the TouchToolbarOpening event to specify the location of the touch strip.
    CS
    Copy Code
    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;
            }
    VB.NET
    Copy Code
    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
    See Also
    Using Drag Fill