SelectionBlockOptions Property (FpSpread)

Gets or sets which type of selections in the component the user can make.

Syntax

Visual Basic
C#

'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;

Visual Basic

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

Reference

FpSpread Class
FpSpread Members
OperationMode Property
SelectionUnit Property
SelectionBlockOptions Enum

User-Task Documentation

Specifying What the User Can Select