ActiveColumn Property

Visual Basic
C#

'Declaration
 
Public Property ActiveColumn As Integer

'Usage
 
Dim instance As SheetView
Dim value As Integer
 
instance.ActiveColumn = value
 
value = instance.ActiveColumn

public int ActiveColumn {get; set;}

Property Value

Integer index of the currently selected column

This property is available at run time only.

Set this property to specify the active column. Return the value of this property to retrieve the column index of the active column.

This example creates a SheetView object and assigns it to the active sheet. The ActiveColumn and ActiveRow properties are set and a value is placed in the active cell. The AllowInsert and AllowDelete properties are set to true so that when the user clicks the Insert button on the command bar a row is inserted, when the user clicks the Add button a row is added at the bottom, and when the user clicks the Delete button the selected row is deleted.

C#

FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
sv.ActiveColumn = 2;
sv.ActiveRow = 2;
sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active");
sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal;
sv.AllowInsert = True;
sv.AllowDelete = True;

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
sv.ActiveColumn = 2
sv.ActiveRow = 2
sv.SetValue(sv.ActiveColumn, sv.ActiveRow, "Active")
sv.OperationMode = FarPoint.Web.Spread.OperationMode.Normal
sv.AllowInsert = True
sv.AllowDelete = True

Reference

SheetView Class
SheetView Members
ActiveRow Property