Click event

Click event

Posted by: fsegui on 17 March 2021, 3:54 am EST

• 

  fsegui

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 March 2021, 3:54 am EST

  Hello,

  With former fpSpread (OCX version), when a user was clicking on a cell, the cell was highlighted before entering the fpspread.click event. With the .Net version, that’s not the case anymore. I had to change from Click to CellClick event because I need to get row/column of the cell click and then perform some actions. As the actions take time, the cell has to be shown selected.

  How can I highlight the selected cell before the clickevent? Thanks

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 March 2021, 9:01 pm EST

  Hi,

  You can achieve this by performing your actions on a separate thread. This occurs as you are doing actions in CellClick which is fired before the active cell is changed, by performing the actions on a separate thread, you will leave the main free for further actions like changing of the active cell. Please refer to the sample attached which demonstrates the same.

  Regards. Avnish SpreadClickColor.zip

• 

  fsegui

  • Post Options:
  • Link
    Copy

  Posted 18 March 2021, 10:12 pm EST

  Hi,

  Thanks, works fine with the delegate

• 

  fsegui

  • Post Options:
  • Link
    Copy

  Posted 6 December 2022, 2:24 am EST

  Hi Avnish,

  I’m reopening the subject.
  
  It does not work with Spread v15

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 6 December 2022, 8:51 pm EST

  Hi,

  We have escalated the issue to the development team and will let you know as soon as we have an update.

  Regards
  
  Avnish

  (Internal Tracking ID: SPNET-28049)

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 7 December 2022, 3:01 pm EST

  Hi,

  As per the development team, in the CellClick event if we set the CellClickEventArgs.Cancel = true the active cell will not be changed that is why the active cell is changed after the cell click event.
  
  The best way will be to use the EnterCell event and perform the operations there. Please refer to the sample attached that demonstrates the same.

  Regards
  
  Avnish

  SpreadClickColor_mod.zip

• 

  fsegui

  • Post Options:
  • Link
    Copy

  Posted 7 December 2022, 8:11 pm EST

  Hi,

  Perfect, I wasn’t aware of this event.

  It works fine

  Thanks
  
  Florent