FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : FpSpread Property |
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10