
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class CrossWorkbookReferenceDemo
        Inherits BaseSampleControl
        Private workbookSet As IWorkbookSet = GrapeCity.Spreadsheet.Win.Factory.CreateWorkbookSet()

        Public Sub New()
            InitializeComponent()
            SetupSpreadsheets()
        End Sub

        Private Sub SetupSpreadsheets()
            ' create first workbook
            Dim wb1 As IWorkbook = workbookSet.Workbooks.Add()
            For i As Integer = 0 To 2
                wb1.Worksheets.Add()
            Next
            fpSpread1.Attach(wb1)
            fpSpread1.TitleInfo.Text = "Book1"
            fpSpread1.TitleInfo.Visible = True
            fpSpread1.Sheets(0).Cells(0, 0).Text = "Northern Territory"
            fpSpread1.Sheets(0).Cells(1, 0).Text = "Total Unit Sales"
            fpSpread1.Sheets(0).Cells(1, 1).Formula = "SUM(B3:B9)"
            fpSpread1.Sheets(0).Cells(2, 0).Text = "10/1/2018"
            fpSpread1.Sheets(0).Cells(2, 1).Value = 52
            fpSpread1.Sheets(0).Cells(3, 0).Text = "10/2/2018"
            fpSpread1.Sheets(0).Cells(3, 1).Value = 98
            fpSpread1.Sheets(0).Cells(4, 0).Text = "10/3/2018"
            fpSpread1.Sheets(0).Cells(4, 1).Value = 27
            fpSpread1.Sheets(0).Cells(5, 0).Text = "10/4/2018"
            fpSpread1.Sheets(0).Cells(5, 1).Value = 118
            fpSpread1.Sheets(0).Cells(6, 0).Text = "10/5/2018"
            fpSpread1.Sheets(0).Cells(6, 1).Value = 91
            fpSpread1.Sheets(0).Cells(7, 0).Text = "10/6/2018"
            fpSpread1.Sheets(0).Cells(7, 1).Value = 63
            fpSpread1.Sheets(0).Cells(8, 0).Text = "10/7/2018"
            fpSpread1.Sheets(0).Cells(8, 1).Value = 74
            fpSpread1.StatusBarVisible = True
            ' create second workbook
            Dim wb2 As IWorkbook = workbookSet.Workbooks.Add()
            For i As Integer = 0 To 2
                wb2.Worksheets.Add()
            Next
            fpSpread2.Attach(wb2)
            fpSpread2.TitleInfo.Text = "Book2"
            fpSpread2.TitleInfo.Visible = True
            fpSpread2.Sheets(0).Cells(0, 0).Text = "Region"
            fpSpread2.Sheets(0).Cells(0, 1).Text = "Total Units"
            fpSpread2.Sheets(0).Cells(1, 0).Text = "Northern Territory"
            fpSpread2.Sheets(0).Cells(1, 1).Formula = "[Book1]Sheet1!$B$2"
            fpSpread2.Sheets(0).Cells(2, 0).Text = "Southern Territory"
            fpSpread2.Sheets(0).Cells(2, 1).Value = 725
            fpSpread2.Sheets(0).Cells(3, 0).Text = "Eastern Territory"
            fpSpread2.Sheets(0).Cells(3, 1).Value = 437
            fpSpread2.Sheets(0).Cells(4, 0).Text = "Western Territory"
            fpSpread2.Sheets(0).Cells(4, 1).Value = 623
            fpSpread2.Sheets(0).AddTable("table1", 0, 0, 5, 2)
            fpSpread2.StatusBarVisible = True

            wb1.ActiveSheet.Columns(0).AutoFit()
            fpSpread2.ActiveSheet.SetActiveCell(1, 1)
            wb2.SaveLinkValues = True
            fpSpread2_Enter(Nothing, EventArgs.Empty)
            splitContainer1.SplitterDistance = splitContainer2.SplitterDistance
        End Sub

        Private Sub fpSpread1_Enter(sender As Object, e As EventArgs)
            formulaTextBox1.Detach()
            formulaTextBox1.Attach(fpSpread1)
            nameBox1.Detach()
            nameBox1.Attach(fpSpread1)
        End Sub

        Private Sub fpSpread2_Enter(sender As Object, e As EventArgs)
            formulaTextBox1.Detach()
            formulaTextBox1.Attach(fpSpread2)
            nameBox1.Detach()
            nameBox1.Attach(fpSpread2)
        End Sub

        Protected Overrides Sub OnVisibleChanged(e As EventArgs)
            MyBase.OnVisibleChanged(e)
            If Visible Then
                fpSpread2.Focus()
            End If
        End Sub
    End Class
End Namespace

'
'
'

Namespace Features
	Partial Class CrossWorkbookReferenceDemo
		''' <summary> 
		''' Required designer variable.
		''' </summary>
		Private components As System.ComponentModel.IContainer = Nothing

        ''' <summary> 
        ''' Clean up any resources being used.
        ''' </summary>
        ''' <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        Protected Overloads Sub Dispose(disposing As Boolean)
            If disposing AndAlso (components IsNot Nothing) Then
                components.Dispose()
            End If
            MyBase.Dispose(disposing)
        End Sub

#Region "Component Designer generated code"

        ''' <summary> 
        ''' Required method for Designer support - do not modify 
        ''' the contents of this method with the code editor.
        ''' </summary>
        Private Sub InitializeComponent()
			Dim resources As New System.ComponentModel.ComponentResourceManager(GetType(CrossWorkbookReferenceDemo))
			Me.panelFormulaBar = New System.Windows.Forms.Panel()
			Me.splitContainer1 = New System.Windows.Forms.SplitContainer()
			Me.nameBox1 = New FarPoint.Win.Spread.NameBox()
			Me.formulaTextBox1 = New FarPoint.Win.Spread.FormulaTextBox()
			Me.splitContainer2 = New System.Windows.Forms.SplitContainer()
			Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, DirectCast(resources.GetObject("splitContainer2.Panel1.Controls"), Object))
			Me.fpSpread2 = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, DirectCast(resources.GetObject("splitContainer2.Panel2.Controls"), Object))
			Me.pnlMain.SuspendLayout()
			Me.panelFormulaBar.SuspendLayout()
			DirectCast(Me.splitContainer1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.splitContainer1.Panel1.SuspendLayout()
			Me.splitContainer1.Panel2.SuspendLayout()
			Me.splitContainer1.SuspendLayout()
			DirectCast(Me.splitContainer2, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.splitContainer2.Panel1.SuspendLayout()
			Me.splitContainer2.Panel2.SuspendLayout()
			Me.splitContainer2.SuspendLayout()
			DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread2, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.splitContainer2)
			Me.pnlMain.Controls.Add(Me.panelFormulaBar)
			' 
			' panelFormulaBar
			' 
			Me.panelFormulaBar.Controls.Add(Me.splitContainer1)
			Me.panelFormulaBar.Dock = System.Windows.Forms.DockStyle.Top
			Me.panelFormulaBar.Location = New System.Drawing.Point(0, 0)
			Me.panelFormulaBar.Name = "panelFormulaBar"
			Me.panelFormulaBar.Size = New System.Drawing.Size(477, 23)
			Me.panelFormulaBar.TabIndex = 6
			' 
			' splitContainer1
			' 
			Me.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.splitContainer1.Location = New System.Drawing.Point(0, 0)
			Me.splitContainer1.Name = "splitContainer1"
			' 
			' splitContainer1.Panel1
			' 
			Me.splitContainer1.Panel1.Controls.Add(Me.nameBox1)
			Me.splitContainer1.Panel1MinSize = 121
			' 
			' splitContainer1.Panel2
			' 
			Me.splitContainer1.Panel2.Controls.Add(Me.formulaTextBox1)
			Me.splitContainer1.Size = New System.Drawing.Size(477, 23)
			Me.splitContainer1.SplitterDistance = 121
			Me.splitContainer1.TabIndex = 0
			' 
			' nameBox1
			' 
			Me.nameBox1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.nameBox1.Location = New System.Drawing.Point(0, 0)
			Me.nameBox1.MaxLength = 255
			Me.nameBox1.Name = "nameBox1"
			Me.nameBox1.Size = New System.Drawing.Size(121, 21)
			Me.nameBox1.TabIndex = 0
			' 
			' formulaTextBox1
			' 
			Me.formulaTextBox1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.formulaTextBox1.Location = New System.Drawing.Point(0, 0)
			Me.formulaTextBox1.Multiline = False
			Me.formulaTextBox1.Name = "formulaTextBox1"
			Me.formulaTextBox1.Size = New System.Drawing.Size(352, 23)
			Me.formulaTextBox1.TabIndex = 0
			' 
			' splitContainer2
			' 
			Me.splitContainer2.Dock = System.Windows.Forms.DockStyle.Fill
			Me.splitContainer2.Location = New System.Drawing.Point(0, 23)
			Me.splitContainer2.Name = "splitContainer2"
			' 
			' splitContainer2.Panel1
			' 
			Me.splitContainer2.Panel1.Controls.Add(Me.fpSpread1)
			' 
			' splitContainer2.Panel2
			' 
			Me.splitContainer2.Panel2.Controls.Add(Me.fpSpread2)
			Me.splitContainer2.Size = New System.Drawing.Size(477, 464)
			Me.splitContainer2.SplitterDistance = 159
			Me.splitContainer2.TabIndex = 0
			' 
			' fpSpread1
			' 
			Me.fpSpread1.AccessibleDescription = ""
			Me.fpSpread1.BackColor = System.Drawing.SystemColors.Control
			Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread1.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread1.Name = "fpSpread1"
			Me.fpSpread1.RightToLeft = System.Windows.Forms.RightToLeft.No
			Me.fpSpread1.Size = New System.Drawing.Size(159, 464)
			Me.fpSpread1.TabIndex = 1
            AddHandler Me.fpSpread1.Enter, AddressOf Me.fpSpread1_Enter
            ' 
            ' fpSpread2
            ' 
            Me.fpSpread2.AccessibleDescription = ""
			Me.fpSpread2.BackColor = System.Drawing.SystemColors.Control
			Me.fpSpread2.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread2.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread2.Name = "fpSpread2"
			Me.fpSpread2.RightToLeft = System.Windows.Forms.RightToLeft.No
			Me.fpSpread2.Size = New System.Drawing.Size(314, 464)
			Me.fpSpread2.TabIndex = 1
            AddHandler Me.fpSpread2.Enter, AddressOf Me.fpSpread2_Enter
            ' 
            ' CrossWorkbookReferenceDemo
            ' 
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "CrossWorkbookReferenceDemo"
			Me.pnlMain.ResumeLayout(False)
			Me.panelFormulaBar.ResumeLayout(False)
			Me.splitContainer1.Panel1.ResumeLayout(False)
			Me.splitContainer1.Panel2.ResumeLayout(False)
			DirectCast(Me.splitContainer1, System.ComponentModel.ISupportInitialize).EndInit()
			Me.splitContainer1.ResumeLayout(False)
			Me.splitContainer2.Panel1.ResumeLayout(False)
			Me.splitContainer2.Panel2.ResumeLayout(False)
			DirectCast(Me.splitContainer2, System.ComponentModel.ISupportInitialize).EndInit()
			Me.splitContainer2.ResumeLayout(False)
			DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread2, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region
		Private splitContainer1 As System.Windows.Forms.SplitContainer
		Protected Friend panelFormulaBar As System.Windows.Forms.Panel
		Protected Friend nameBox1 As FarPoint.Win.Spread.NameBox
		Protected Friend formulaTextBox1 As FarPoint.Win.Spread.FormulaTextBox
		Private splitContainer2 As System.Windows.Forms.SplitContainer
		Protected Friend fpSpread1 As FarPoint.Win.Spread.FpSpread
		Protected Friend fpSpread2 As FarPoint.Win.Spread.FpSpread
	End Class
End Namespace
