Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / FpSpread Property
Example


In This Topic
    FpSpread Property
    In This Topic
    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