Spread Windows Forms 11.0 Product Documentation
SelectionBlockOptions Property (FpSpread)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : SelectionBlockOptions Property
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

Reference

FpSpread Class
FpSpread Members
OperationMode Property
SelectionUnit Property
SelectionBlockOptions Enum

User-Task Documentation

Specifying What the User Can Select