Spreadsheet.ActiveGrid.EditTrigger = OnTap doesn't work

Hello,

I'm trying to make my spreadsheet function where as soon as you click on the cell it goes into edit mode with the cursor waiting input. I have tried changing the EditTrigger for the grid to OnTap, as in the below code, but that does not seem t work. Currently I am triggering the system to send an "F2" keypress once the cell is activated, to get the desired functionality, however that is a less than ideal solution.

Current code

Imports Syncfusion.Windows.Forms.Spreadsheet

Imports Syncfusion.Windows.Forms

Public Class Form2

    Friend spreadsheet As New Spreadsheet


    Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load


        spreadsheet.SetBounds(0, 0, 1024, 768)

        Me.Controls.Add(spreadsheet)


        spreadsheet.ActiveGrid.RowCount = 50

        spreadsheet.ActiveGrid.ColumnCount = 50


        spreadsheet.ActiveGrid.EditTrigger = CellGrid.Helpers.EditTrigger.OnTap

    End Sub

End Class



1 Reply

AR Arulpriya Ramalingam Syncfusion Team September 10, 2021 05:42 PM UTC

Hi Mike, 
 
Thank you for using Syncfusion support. 
 
As per the current behavior of Spreadsheet, the EditTrigger function with OnTap will trigger the Cell to enter edit mode. To enable the edit mode for a cell when F2 key is pressed, we suggest you to use the BeginEdit() method of current cell. Please refer the below user guide. 
 
 
Please get back to us if you need any further assistance. 
 
Regards, 
Arulpriya R. 


Loader.
Up arrow icon