Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SelectionBlockOptions Property

In This Topic
    SelectionBlockOptions Property (FpSpread)
    In This Topic
    Gets or sets which type of selections in the component the user can make.
    Public Property SelectionBlockOptions As SelectionBlockOptions
    Dim instance As FpSpread
    Dim value As SelectionBlockOptions
    instance.SelectionBlockOptions = value
    value = instance.SelectionBlockOptions
    public SelectionBlockOptions SelectionBlockOptions {get; set;}

    Property Value

    SelectionBlockOptions setting that determines what can be selected

    This property specifies what users can select when the operation mode (SheetView class OperationMode property) for the sheet is set to OperationMode.Normal or OperationMode.ReadOnly. If you set the operation mode to another value, this property does not have an effect.

    If you want to specify whether the sheet allows users or the application to select certain items, you can set the SheetView class SelectionUnit property.

    This example allows only columns to be selected.
    FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
    FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
    fpSpread1.Location = new Point(10, 10);
    fpSpread1.Height = 200;
    fpSpread1.Width = 400;
    fpSpread1.SelectionBlockOptions = FarPoint.Win.Spread.SelectionBlockOptions.Columns;
    Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
    Dim shv As New FarPoint.Win.Spread.SheetView()
    fpSpread1.Location = New Point(10, 10)
    fpSpread1.Height = 200
    fpSpread1.Width = 400
    fpSpread1.SelectionBlockOptions = FarPoint.Win.Spread.SelectionBlockOptions.Columns
    See Also