Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SelectionPolicy Property
Example


In This Topic
    SelectionPolicy Property (SheetView)
    In This Topic
    Gets the selection policy for the sheet for normal operation mode.
    Syntax
    'Declaration
     
    Public Property SelectionPolicy As SelectionPolicy
    'Usage
     
    Dim instance As SheetView
    Dim value As SelectionPolicy
     
    instance.SelectionPolicy = value
     
    value = instance.SelectionPolicy
    public SelectionPolicy SelectionPolicy {get; set;}

    Property Value

    SelectionPolicy setting that determines the display of selections
    Remarks

    Use this property if the OperationMode property is set to OperationMode.Normal to customize the sheet so that users can select single cells, a range of cells, or multiple ranges of cells. This property does not have an effect if the OperationMode property is set to a value other than OperationMode.Normal.

    Example
    This example specifies the selection policy for the sheet for normal operation mode, and sets the background color and text color for selections.
    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;
    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
    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