﻿Imports Spread.Common.Features.Spread.Common.Features.Sample
Imports System.IO

Partial Public Class ImageFunction
    Inherits BaseSampleControl
    Public Sub New()
        InitializeComponent()
        Name = "Image Function"

        Using stream As MemoryStream = New MemoryStream(My.Resources.ExcelTemplates.IMAGE_Function_Spread)
            _fpSpread.OpenExcel(stream, FarPoint.Excel.ExcelOpenFlags.Exchangeable)
        End Using
    End Sub
End Class

//
// ImageFunction.Designer.vb
//

Partial Class ImageFunction
    ''' <summary> 
    ''' Required designer variable.
    ''' </summary>
    Private components As ComponentModel.IContainer = Nothing

    ''' <summary> 
    ''' Clean up any resources being used.
    ''' </summary>
    ''' <paramname="disposing">true if managed resources should be disposed; otherwise, false.</param>
    Protected Sub Dispose(ByVal 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 ComponentModel.ComponentResourceManager = New ComponentModel.ComponentResourceManager(GetType(ImageFunction))
        splitContainer1 = New Windows.Forms.SplitContainer()
        splitContainer2 = New Windows.Forms.SplitContainer()
        nameBox1 = New FarPoint.Win.Spread.NameBox()
        _fpSpread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, resources.GetObject("splitContainer2.Panel1.Controls"))
        _fpSpread_Sheet1 = _fpSpread.GetSheet(0)
        panel1 = New Windows.Forms.Panel()
        formulaTextBox1 = New FarPoint.Win.Spread.FormulaTextBox()
        pnlMain.SuspendLayout()
        CType(splitContainer1, ComponentModel.ISupportInitialize).BeginInit()
        splitContainer1.Panel1.SuspendLayout()
        splitContainer1.Panel2.SuspendLayout()
        splitContainer1.SuspendLayout()
        CType(splitContainer2, ComponentModel.ISupportInitialize).BeginInit()
        splitContainer2.Panel1.SuspendLayout()
        splitContainer2.Panel2.SuspendLayout()
        splitContainer2.SuspendLayout()
        CType(_fpSpread, ComponentModel.ISupportInitialize).BeginInit()
        panel1.SuspendLayout()
        SuspendLayout()
        ' 
        ' pnlMain
        ' 
        pnlMain.Controls.Add(splitContainer1)
        ' 
        ' pnlControls
        ' 
        pnlControls.Size = New Drawing.Size(210, 599)
        ' 
        ' splitContainer1
        ' 
        splitContainer1.Dock = Windows.Forms.DockStyle.Fill
        splitContainer1.FixedPanel = Windows.Forms.FixedPanel.Panel1
        splitContainer1.IsSplitterFixed = True
        splitContainer1.Location = New Drawing.Point(0, 0)
        splitContainer1.Margin = New Windows.Forms.Padding(0)
        splitContainer1.Name = "splitContainer1"
        splitContainer1.Orientation = Windows.Forms.Orientation.Horizontal
        ' 
        ' splitContainer1.Panel1
        ' 
        splitContainer1.Panel1.Controls.Add(splitContainer2)
        splitContainer1.Panel1MinSize = 20
        ' 
        ' splitContainer1.Panel2
        ' 
        splitContainer1.Panel2.Controls.Add(_fpSpread)
        splitContainer1.Size = New Drawing.Size(636, 599)
        splitContainer1.SplitterDistance = 25
        splitContainer1.TabIndex = 1
        ' 
        ' splitContainer2
        ' 
        splitContainer2.Dock = Windows.Forms.DockStyle.Fill
        splitContainer2.FixedPanel = Windows.Forms.FixedPanel.Panel1
        splitContainer2.IsSplitterFixed = True
        splitContainer2.Location = New Drawing.Point(0, 0)
        splitContainer2.Name = "splitContainer2"
        ' 
        ' splitContainer2.Panel1
        ' 
        splitContainer2.Panel1.Controls.Add(nameBox1)
        ' 
        ' splitContainer2.Panel2
        ' 
        splitContainer2.Panel2.Controls.Add(panel1)
        splitContainer2.Size = New Drawing.Size(636, 25)
        splitContainer2.SplitterDistance = 217
        splitContainer2.TabIndex = 0
        ' 
        ' nameBox1
        ' 
        nameBox1.Dock = Windows.Forms.DockStyle.Fill
        nameBox1.Location = New Drawing.Point(0, 0)
        nameBox1.MaxLength = 255
        nameBox1.Name = "nameBox1"
        nameBox1.Size = New Drawing.Size(217, 24)
        nameBox1.TabIndex = 1
        nameBox1.Text = "A1"
        ' Attach nameBox1 to _fpSpread
        nameBox1.Attach(_fpSpread)
        ' 
        ' _fpSpread
        ' 
        _fpSpread.Dock = Windows.Forms.DockStyle.Fill
        _fpSpread.Font = New Drawing.Font("Calibri", 11.0F)
        _fpSpread.Location = New Drawing.Point(0, 0)
        _fpSpread.Name = "_fpSpread"
        _fpSpread.Size = New Drawing.Size(636, 570)
        _fpSpread.TabIndex = 0
        ' 
        ' panel1
        ' 
        panel1.BorderStyle = Windows.Forms.BorderStyle.FixedSingle
        panel1.Controls.Add(formulaTextBox1)
        panel1.Dock = Windows.Forms.DockStyle.Fill
        panel1.Location = New Drawing.Point(0, 0)
        panel1.Name = "panel1"
        panel1.Size = New Drawing.Size(415, 25)
        panel1.TabIndex = 0
        ' 
        ' formulaTextBox1
        ' 
        formulaTextBox1.AcceptsTab = True
        formulaTextBox1.BorderStyle = Windows.Forms.BorderStyle.None
        formulaTextBox1.Dock = Windows.Forms.DockStyle.Fill
        formulaTextBox1.Location = New Drawing.Point(0, 0)
        formulaTextBox1.Margin = New Windows.Forms.Padding(0)
        formulaTextBox1.Name = "formulaTextBox1"
        formulaTextBox1.RightToLeft = Windows.Forms.RightToLeft.No
        formulaTextBox1.Size = New Drawing.Size(413, 23)
        formulaTextBox1.TabIndex = 0
        ' Attach formulaTextBox1 to _fpSpread
        formulaTextBox1.Attach(_fpSpread)
        ' 
        ' ImageFunction
        ' 
        AutoScaleDimensions = New Drawing.SizeF(8.0F, 16.0F)
        AutoScaleMode = Windows.Forms.AutoScaleMode.Font
        Name = "ImageFunction"
        pnlMain.ResumeLayout(False)
        splitContainer1.Panel1.ResumeLayout(False)
        splitContainer1.Panel2.ResumeLayout(False)
        CType(splitContainer1, ComponentModel.ISupportInitialize).EndInit()
        splitContainer1.ResumeLayout(False)
        splitContainer2.Panel1.ResumeLayout(False)
        splitContainer2.Panel2.ResumeLayout(False)
        CType(splitContainer2, ComponentModel.ISupportInitialize).EndInit()
        splitContainer2.ResumeLayout(False)
        CType(_fpSpread, ComponentModel.ISupportInitialize).EndInit()
        panel1.ResumeLayout(False)
        ResumeLayout(False)

    End Sub

#End Region

    Private splitContainer1 As Windows.Forms.SplitContainer
    Private splitContainer2 As Windows.Forms.SplitContainer
    Private nameBox1 As FarPoint.Win.Spread.NameBox
    Private _fpSpread As FarPoint.Win.Spread.FpSpread
    Private panel1 As Windows.Forms.Panel
    Private formulaTextBox1 As FarPoint.Win.Spread.FormulaTextBox
    Private _fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
End Class