SelectionUnit Property (ISheetSelectionModel)

Gets or sets whether users can select cells, rows, or columns.

Syntax

Visual Basic
C#

'Declaration
 
Property SelectionUnit As SelectionUnit

'Usage
 
Dim instance As ISheetSelectionModel
Dim value As SelectionUnit
 
instance.SelectionUnit = value
 
value = instance.SelectionUnit

SelectionUnit SelectionUnit {get; set;}

Property Value

SelectionUnit setting that determines the unit of selections

Example

This example specifies what users can select.

FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
sel.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Column;
MessageBox.Show("You are only able to select columns. Try to select a row or the whole sheet", "SelectionPolicy/Unit", MessageBoxButtons.OK);

Visual Basic

Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
sel = FpSpread1.ActiveSheet.Models.Selection
sel.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single
sel.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Column
MessageBox.Show("You are only able to select columns. Try to select a row or the whole sheet", "SelectionPolicy/Unit", MessageBoxButtons.OK)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

ISheetSelectionModel Interface
ISheetSelectionModel Members