Setting active cell in EditModeOff event

Setting active cell in EditModeOff event

Posted by: tosch on 12 December 2023, 2:40 am EST

• 

  tosch

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 December 2023, 2:40 am EST

  I’m trying to set the active cell in the EditModeOff event based on what the user enters in a cell.

  Calling

  FpSpread1.ActiveSheet.SetActiveCell(intRow, intCol)

  does not have any effect and the active cell is not changed.
  
  What do I have to do to achieve this?

  Thomas

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 December 2023, 11:29 pm EST - Updated 12 December 2023, 11:34 pm EST

  Hi Thomas,

  FpSpread’s EditModeOff event is fired when the edit mode of a cell is stopped. We created a sample as per the information provided by you, but unfortunately could not replicate the issue on our end. See VB_SetActiveCell.zip for implementation.

  Steps to replicate the behavior:

  1. Run the attached application.
  2. Start editing any cell in the second column.
  3. Stop the edit mode of currently active cell by pressing the ‘Enter’ key.

  You will observe that the focus shifts to the ‘A3’ cell. Refer the following GIF to see the behavior on our end.

  

  Kindly update the attached sample if your requirement differs from our understanding.

  Thanks & Regards,
  
  Aastha