AnchorColumn Property (ISheetSelectionModel)

Gets the column index of the first cell in the selection of cells.

Syntax

Visual Basic
C#

'Declaration
 
ReadOnly Property AnchorColumn As Integer

'Usage
 
Dim instance As ISheetSelectionModel
Dim value As Integer
 
value = instance.AnchorColumn

int AnchorColumn {get;}

Property Value

Integer column index

Example

This example returns the column index and row index of the first cell selected in the range.

FarPoint.Win.Spread.Model.ISheetSelectionModel sel;
int i, j;
sel = (FarPoint.Win.Spread.Model.ISheetSelectionModel)fpSpread1.ActiveSheet.Models.Selection;
sel.SetSelection(0, 0, 2, 2);
i = sel.AnchorColumn;
j = sel.AnchorRow;
label1.Text = "The anchor column is " + i.ToString() + " - The anchor row is " + j.ToString();

Visual Basic

Dim sel As FarPoint.Win.Spread.Model.ISheetSelectionModel
Dim i, j As Integer
sel = FpSpread1.ActiveSheet.Models.Selection
sel.SetSelection(0, 0, 2, 2)
i = sel.AnchorColumn
j = sel.AnchorRow
Label1.Text = "The anchor column is " & i.ToString() & " - The anchor row is " & j.ToString()

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