Visual Basic (Declaration) | |
---|---|
Public Property SelectionBlockOptions As SelectionBlockOptions |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim value As SelectionBlockOptions instance.SelectionBlockOptions = value value = instance.SelectionBlockOptions |
C# | |
---|---|
public SelectionBlockOptions SelectionBlockOptions {get; set;} |
Property Value
SelectionBlockOptions setting that determines what can be selectedThis property specifies what users can select when the operation mode (SheetView class OperationMode property) for the sheet is set to OperationMode.Normal. 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.
C# | Copy Code |
---|---|
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 | Copy Code |
---|---|
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 |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
FpSpread ClassFpSpread Members
OperationMode Property
SelectionUnit Property
SelectionBlockOptions Enum