Set Focus On A Particular Cell

Set Focus On A Particular Cell

Posted by: bob-flaherty on 8 September 2017, 5:04 am EST

• 

  bob-flaherty

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 5:04 am EST

  Using C# 3.5 in developing a Windows app.  On one of the forms, there is a listbox and a spread control.  When the use double-clicks on a row in the listbox, data from the object stored in that row of the listbox is used to create a new row on the spread control and numerous cells in the newly created row are populated with data.

  How do you automatically set focus on a particular column in the newly created row (focus on a given cell knowing the row index and the column index) such that the user could start enter data in that cell without having tab or use the mouse?

  This requirment is not just for the ease of entering data but it would also permit the editing of the data when focus leaves the newly created row.

• 

  sureshd

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:04 am EST

  Bob,

  You can use the SetActiveCell method of Spread to set active cell to the desired position (knowing the row and column index). Below snippet illustrates the usage of the SetActiveCell and set the focus at cell(0,1):

          Dim dt As New DataTable("TestTable")
  
          dt.Columns.Add("Number")
  
          dt.Columns.Add("Letter")
  
          dt.Rows.Add(New Object() {"1", "One"})
  
          dt.Rows.Add(New Object() {"2", "Two"})
  
          Dim datamodel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
  
          FpSpread1.ActiveSheet.Models.Data = datamodel
  
          FpSpread1.ActiveSheet.SetActiveCell(0, 1)

  Hope this helps.Thanks
  
  

• 

  suganya_lakshmipriya

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:04 am EST

  The above code makes the particular cell active but cursor focus is not there

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 5:04 am EST

  Hello,

  You need to set EditModePermanent to true for that matter. Please have a look at the code for the same:-

  [csharp]fpSpread1.ActiveSheet.SetActiveCell(0, 1);
  
  fpSpread1.EditModePermanent = true; [/csharp]

  Hope it helps.

  Thanks,
  
  Reeva

• 

  ashish6794

  • Post Options:
  • Link
    Copy

  Posted 1 January 2020, 3:19 pm EST

  fpSpread1.ActiveSheet.SetActiveCell(row, col, true);
  
  fpSpread1.ShowActiveCell(verticalPosition, horizontalPosition);

  this code is working fine for me.