FpSpread プロパティ

Visual Basic
C#

'Declaration
 
Public ReadOnly Property FpSpread As FpSpread

public FpSpread FpSpread {get;}

次のサンプルコードは、SheetViewのFpSpreadプロパティを使用します。

C#
Visual Basic

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

SheetView クラス
 SheetView メンバ