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


In This Topic
    SelectionBlockOptions Property (FpSpread)
    In This Topic
    Gets or sets which type of selections in the component the user can make.
    Syntax
    'Declaration
     
    Public Property SelectionBlockOptions As SelectionBlockOptions
    'Usage
     
    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
    Remarks

    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.

    Example
    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;
    Controls.Add(fpSpread1);
    fpSpread1.Sheets.Add(shv);
    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
    Controls.Add(fpSpread1)
    fpSpread1.Sheets.Add(shv)
    fpSpread1.SelectionBlockOptions = FarPoint.Win.Spread.SelectionBlockOptions.Columns
    See Also