Spread Windows Forms 6.0 Product Documentation
SelectionUnit Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : SelectionUnit Property

Glossary Item Box

Gets or sets the smallest unit users or the application can select on this sheet.


Visual Basic (Declaration) 
Public Property SelectionUnit As SelectionUnit
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As SelectionUnit
instance.SelectionUnit = value
value = instance.SelectionUnit
public SelectionUnit SelectionUnit {get; set;}

Property Value

SelectionUnit setting that determines the unit of selections


Use this property if the OperationMode property is set to OperationMode.Normal or OperationMode.ReadOnly to customize the sheet so that users and the application can only select certain items.

If you want to specify that users can only select certain items, but not restrict the application from selecting certain items and the OperationMode property is set to OperationMode.Normal, set the FpSpread class's or SpreadView class's SelectionBlockOptions property.


This example specifies the selection policy for the sheet for normal operation mode, and sets the background color and text color for selections.
C#Copy Code
fpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors;
fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range;
fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell;
fpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2);
fpSpread1.ActiveSheet.AddSelection(3, 0, 2, 2);
fpSpread1.ActiveSheet.SelectionBackColor = Color.Red;
fpSpread1.ActiveSheet.SelectionForeColor = Color.DarkBlue;
Visual BasicCopy Code
FpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors
FpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range
FpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell
FpSpread1.ActiveSheet.AddSelection(0, 0, 2, 2)
FpSpread1.ActiveSheet.AddSelection(3, 0, 2, 2)
FpSpread1.ActiveSheet.SelectionBackColor = Color.Red
FpSpread1.ActiveSheet.SelectionForeColor = Color.DarkBlue


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.