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