﻿Imports Spread.Common.Features.Spread.Common.Features.Sample

Public Class XLookUp
     Inherits BaseSampleControl
     Sub New()

          ' This call is required by the designer.
          InitializeComponent()

          ' Add any initialization after the InitializeComponent() call.
          fpSpread1.AsWorkbook().WorkbookSet.CalculationEngine.CalcFeatures = GrapeCity.Spreadsheet.CalcFeatures.DynamicArray

          Using s As New System.IO.MemoryStream(My.Resources.ExcelTemplates.XLOOKUP)
               fpSpread1.OpenExcel(s)
          End Using
     End Sub
End Class

'
'XLookUp.Designer.vb
'

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()>
Partial Class XLookUp

     'UserControl overrides dispose to clean up the component list.
     <System.Diagnostics.DebuggerNonUserCode()>
     Protected Shadows Sub Dispose(ByVal disposing As Boolean)
          Try
               If disposing AndAlso components IsNot Nothing Then
                    components.Dispose()
               End If
          Finally
               MyBase.Dispose(disposing)
          End Try
     End Sub

     'Required by the Windows Form Designer
     Private components As System.ComponentModel.IContainer

     'NOTE: The following procedure is required by the Windows Form Designer
     'It can be modified using the Windows Form Designer.  
     'Do not modify it using the code editor.
     <System.Diagnostics.DebuggerStepThrough()>
     Private Sub InitializeComponent()
          Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(XLookUp))
          Me.splitContainer1 = New System.Windows.Forms.SplitContainer()
          Me.splitContainer2 = New System.Windows.Forms.SplitContainer()
          Me.nameBox1 = New FarPoint.Win.Spread.NameBox()
          Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("splitContainer2.Panel1.Controls"), Object))
          Me.fpSpread1_Sheet1 = Me.fpSpread1.GetSheet(0)
          Me.panel1 = New System.Windows.Forms.Panel()
          Me.formulaTextBox1 = New FarPoint.Win.Spread.FormulaTextBox()
          Me.pnlMain.SuspendLayout()
          CType(Me.splitContainer1, System.ComponentModel.ISupportInitialize).BeginInit()
          Me.splitContainer1.Panel1.SuspendLayout()
          Me.splitContainer1.Panel2.SuspendLayout()
          Me.splitContainer1.SuspendLayout()
          CType(Me.splitContainer2, System.ComponentModel.ISupportInitialize).BeginInit()
          Me.splitContainer2.Panel1.SuspendLayout()
          Me.splitContainer2.Panel2.SuspendLayout()
          Me.splitContainer2.SuspendLayout()
          CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
          Me.panel1.SuspendLayout()
          Me.SuspendLayout()
          '
          'pnlMain
          '
          Me.pnlMain.Controls.Add(Me.splitContainer1)
          '
          'splitContainer1
          '
          Me.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
          Me.splitContainer1.Location = New System.Drawing.Point(0, 0)
          Me.splitContainer1.Name = "splitContainer1"
          Me.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal
          '
          'splitContainer1.Panel1
          '
          Me.splitContainer1.Panel1.Controls.Add(Me.splitContainer2)
          '
          'splitContainer1.Panel2
          '
          Me.splitContainer1.Panel2.Controls.Add(Me.fpSpread1)
          Me.splitContainer1.Size = New System.Drawing.Size(477, 487)
          Me.splitContainer1.SplitterDistance = 27
          Me.splitContainer1.TabIndex = 1
          '
          'splitContainer2
          '
          Me.splitContainer2.Dock = System.Windows.Forms.DockStyle.Fill
          Me.splitContainer2.Location = New System.Drawing.Point(0, 0)
          Me.splitContainer2.Name = "splitContainer2"
          '
          'splitContainer2.Panel1
          '
          Me.splitContainer2.Panel1.Controls.Add(Me.nameBox1)
          '
          'splitContainer2.Panel2
          '
          Me.splitContainer2.Panel2.Controls.Add(Me.panel1)
          Me.splitContainer2.Size = New System.Drawing.Size(477, 27)
          Me.splitContainer2.SplitterDistance = 158
          Me.splitContainer2.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(158, 21)
          Me.nameBox1.TabIndex = 0
          'Attach nameBox1 to fpSpread1
          Me.nameBox1.Attach(Me.fpSpread1)
          '
          'fpSpread1
          '
          Me.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1, Row 0, Column 0"
          Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
          Me.fpSpread1.Font = New System.Drawing.Font("Calibri", 11.0!)
          Me.fpSpread1.Location = New System.Drawing.Point(0, 0)
          Me.fpSpread1.Name = "fpSpread1"
          Me.fpSpread1.Size = New System.Drawing.Size(477, 456)
          Me.fpSpread1.TabIndex = 0
          '
          'panel1
          '
          Me.panel1.Controls.Add(Me.formulaTextBox1)
          Me.panel1.Dock = System.Windows.Forms.DockStyle.Fill
          Me.panel1.Location = New System.Drawing.Point(0, 0)
          Me.panel1.Name = "panel1"
          Me.panel1.Size = New System.Drawing.Size(315, 27)
          Me.panel1.TabIndex = 0
          '
          'formulaTextBox1
          '
          Me.formulaTextBox1.Dock = System.Windows.Forms.DockStyle.Fill
          Me.formulaTextBox1.Location = New System.Drawing.Point(0, 0)
          Me.formulaTextBox1.Name = "formulaTextBox1"
          Me.formulaTextBox1.Size = New System.Drawing.Size(315, 27)
          Me.formulaTextBox1.TabIndex = 0
          'Attach formulaTextBox1 to fpSpread1
          Me.formulaTextBox1.Attach(Me.fpSpread1)
          '
          'XLookUp
          '
          Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
          Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
          Me.Name = "XLookUp"
          Me.pnlMain.ResumeLayout(False)
          Me.splitContainer1.Panel1.ResumeLayout(False)
          Me.splitContainer1.Panel2.ResumeLayout(False)
          CType(Me.splitContainer1, System.ComponentModel.ISupportInitialize).EndInit()
          Me.splitContainer1.ResumeLayout(False)
          Me.splitContainer2.Panel1.ResumeLayout(False)
          Me.splitContainer2.Panel2.ResumeLayout(False)
          CType(Me.splitContainer2, System.ComponentModel.ISupportInitialize).EndInit()
          Me.splitContainer2.ResumeLayout(False)
          CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
          Me.panel1.ResumeLayout(False)
          Me.ResumeLayout(False)

     End Sub

     Private WithEvents splitContainer1 As System.Windows.Forms.SplitContainer
     Private WithEvents splitContainer2 As System.Windows.Forms.SplitContainer
     Private WithEvents nameBox1 As FarPoint.Win.Spread.NameBox
     Private WithEvents fpSpread1 As FarPoint.Win.Spread.FpSpread
     Private WithEvents panel1 As System.Windows.Forms.Panel
     Private WithEvents formulaTextBox1 As FarPoint.Win.Spread.FormulaTextBox
     Friend WithEvents fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
End Class
