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, 1:16 am EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 March 2020, 1:16 am EST - Updated 30 September 2022, 4:35 am 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 8 March 2020, 3:51 pm 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, 2:39 am EST

  Hi Jitender,
  
  This works perfectly.
  
  Thanks,
  
  Kingman