Get selected row in a sheet with no columns

Get selected row in a sheet with no columns

Posted by: kbj on 6 March 2020, 10:16 am EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 March 2020, 10:16 am EST - Updated 30 September 2022, 1:35 pm EST

  Hi,
  
  Is it possible to get the selected row in a sheet with no columns. activeRowIndex returns a -1 and activeRow returns the first row.

  

  779×421 14.6 KB

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 9 March 2020, 12:51 am EST

  Hi,

  You can get the active row index from the selection:

  if (fpSpread1.ActiveSheet.SelectionCount > 0)
  {
      int activeRowIndex = fpSpread1.ActiveSheet.GetSelection(0).Row;
  }
  

  Regards,
  
  Jitender

• 

  kbj

  • Post Options:
  • Link
    Copy

  Posted 9 March 2020, 11:39 am EST

  Hi Jitender,
  
  This works perfectly.
  
  Thanks,
  
  Kingman