Select Multiple Rows Using Ctrl+ Click

Select Multiple Rows Using Ctrl+ Click

Posted by: manapoleoni on 28 September 2017, 8:49 am EST

• 

  manapoleoni

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2017, 8:49 am EST

  How can I allow a user to select multiple separated rows using Ctrl+ Click? Similar to what’s available in Excel. I’m using Spread 6 with C#.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 29 September 2017, 3:28 am EST

  Hello,

  You can set SelectionPolicy to MultiRange and SelectionUnit to Row as given below:-

  
  fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.MultiRange;
  fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
  
  

  http://help.grapecity.com/spread/SpreadNet10/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.Model.SelectionUnit.html
  
  http://help.grapecity.com/spread/SpreadNet10/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.Model.SelectionUnit.html

  Hope it helps.

  Thanks,
  
  Reeva

• 

  manapoleoni

  • Post Options:
  • Link
    Copy

  Posted 4 October 2017, 2:36 pm EST

  Great Reeva, thanks! You’re the best! Always there!

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 9 October 2017, 1:24 am EST

  Hello,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva