Spread ASP.NET 6.0 Product Documentation
ActiveColumn Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : ActiveColumn Property


Glossary Item Box

Gets or sets the active column.

Syntax

Visual Basic (Declaration) 
Public Property ActiveColumn As Integer
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As Integer
 
instance.ActiveColumn = value
 
value = instance.ActiveColumn
C# 
public int ActiveColumn {get; set;}

Property Value

Integer index of the currently selected column

Remarks

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.

Example

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#Copy Code
    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 BasicCopy Code
    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

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.