Spread Windows Forms 11.0 Product Documentation
FpSpread Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : FpSpread Property
Gets Fpspread from sheet view.
Syntax
'Declaration
 
Public ReadOnly Property FpSpread As FpSpread
'Usage
 
Dim instance As SheetView
Dim value As FpSpread
 
value = instance.FpSpread
public FpSpread FpSpread {get;}
Example
This example uses the FpSpread property from the SheetView.
private void Form1_Load(object sender, EventArgs e)
       {
           fpSpread1.Sheets.Count = 4;
           fpSpread2.Sheets.Count = 2;
           fpSpread1.AllowCellOverflow = true;
           fpSpread2.AllowCellOverflow = true;
           fpSpread1.ActiveSheet.Cells[4, 0].Text = "fpSpread1.ActiveSheet.Cells[0, 0].Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()";
           fpSpread2.ActiveSheet.Cells[4, 0].Text = "fpSpread2.ActiveSheet.Cells[0, 0].Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()";         
       }

       private void button1_Click(object sender, EventArgs e)
       {
           fpSpread1.ActiveSheet.Cells[0, 0].Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString();
           fpSpread2.ActiveSheet.Cells[0, 0].Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString();
       }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets.Count = 4
        fpSpread2.Sheets.Count = 2
        FpSpread1.AllowCellOverflow = True
        fpSpread2.AllowCellOverflow = True
        FpSpread1.ActiveSheet.Cells(4, 0).Text = "fpSpread1.ActiveSheet.Cells(0,0).Text = fpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()"
        fpSpread2.ActiveSheet.Cells(4, 0).Text = "fpSpread2.ActiveSheet.Cells(0,0).Text = fpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()"
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        FpSpread1.ActiveSheet.Cells(0, 0).Text = FpSpread2.ActiveSheet.FpSpread.Sheets.Count.ToString()
        FpSpread2.ActiveSheet.Cells(0, 0).Text = FpSpread1.ActiveSheet.FpSpread.Sheets.Count.ToString()
    End Sub
See Also

Reference

SheetView Class
SheetView Members