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


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)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.