Posted 27 September 2017, 11:49 pm 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#.
Forums Home / Spread / Spread for WinForms
Posted by: manapoleoni on 27 September 2017, 11:49 pm EST
Posted 27 September 2017, 11:49 pm 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#.
Posted 28 September 2017, 6:28 pm 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
Posted 4 October 2017, 5:36 am EST
Great Reeva, thanks! You’re the best! Always there!
Posted 8 October 2017, 4:24 pm EST
Hello,
We are glad to know that your issue has been resolved.
Thanks,
Reeva