ActiveSheetView Property

Visual Basic
C#

'Declaration
 
Public ReadOnly Property ActiveSheetView As SheetView

'Usage
 
Dim instance As FpSpread
Dim value As SheetView
 
value = instance.ActiveSheetView

public SheetView ActiveSheetView {get;}

Property Value

SheetView object containing the currently selected sheet

This property is available at run time only.

When the active sheet changes, the ActiveSheetChanged event occurs.

This example creates a column of Currency cells, sets a value in the first cell, then checks whether the value is valid and returns the result to a text box.

C#

private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack) Return;

FpSpread1.ActiveSheetView.Columns[0].CellType=NewFarPoint.Web.Spread.CurrencyCellType();
FpSpread1.ActiveSheetView.SetValue(0,0,108.89);
}

private void Button1_Click(object sender,System.EventArgs e)
{
object val=FpSpread1.ActiveSheetView.Cells[0,0].Value;
string reason;
reason=FpSpread1.Validate(val,0,0);
if(reason==null||reason==String.Empty){
TextBox1.Text="Valid";
}else{
TextBox1.Text=reason;
}
}

VB.NET

Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load

If(Me.IsPostBack)Then Return
FpSpread1.ActiveSheetView.Columns(0).CellType=NewFarPoint.Web.Spread.CurrencyCellType()
FpSpread1.ActiveSheetView.SetValue(0,0,108.89)
End Sub

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
Dim val As Object=FpSpread1.ActiveSheetView.Cells[0,0].Value
Dim reason As String
reason=FpSpread1.Validate(val,0,0)
If(reason=Nothing Or reason=String.Empty)Then
TextBox1.Text="Valid"
Else
TextBox1.Text=reason
End If
End Sub

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Working with the Active Sheet