Spread Windows Forms 11.0 Product Documentation
SelectionUnit Property (ISheetSelectionModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > ISheetSelectionModel Interface : SelectionUnit Property
Gets or sets whether users can select cells, rows, or columns.
Syntax
'Declaration
 
Property SelectionUnit As SelectionUnit
'Usage
 
Dim instance As ISheetSelectionModel
Dim value As SelectionUnit
 
instance.SelectionUnit = value
 
value = instance.SelectionUnit
SelectionUnit SelectionUnit {get; set;}

Property Value

SelectionUnit setting that determines the unit of selections
Example
This example specifies what users can select.
FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
sel.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Column;
MessageBox.Show("You are only able to select columns. Try to select a row or the whole sheet", "SelectionPolicy/Unit", MessageBoxButtons.OK);
Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
sel = FpSpread1.ActiveSheet.Models.Selection
sel.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single
sel.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Column
MessageBox.Show("You are only able to select columns. Try to select a row or the whole sheet", "SelectionPolicy/Unit", MessageBoxButtons.OK)
See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members