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


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

Reference

FpSpread Class
FpSpread Members
OperationMode Property
SelectionUnit Property
SelectionBlockOptions Enum

User-Task Documentation

Specifying What the User Can Select

 

 


Copyright © GrapeCity, inc. All rights reserved.