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


Partial Public Class ForecastSheet
    Inherits BaseSampleControl
    Public Sub New()
        InitializeComponent()
        Name = "Forecast Sheet"

        Using stream As MemoryStream = New MemoryStream(My.Resources.ExcelTemplates.FinancialData)
            _fpSpread.OpenExcel(stream)
        End Using
    End Sub

    Private Sub OnForecastSheetMenuItemClick(ByVal sender As Object, ByVal e As EventArgs)
        Dim foreCastDialog As Form = FarPoint.Win.Spread.Dialogs.BuiltInDialogs.ForecastSheet(_fpSpread)
        foreCastDialog.ShowDialog(Me)
    End Sub

    Private Sub OnOpenFileMenuItemClick(ByVal sender As Object, ByVal e As EventArgs)
        Dim fileDialog As OpenFileDialog = New OpenFileDialog()
        fileDialog.Filter = "Excel Files| *.xlsx"
        If fileDialog.ShowDialog() = DialogResult.OK Then
            _fpSpread.OpenExcel(fileDialog.OpenFile())
        End If
    End Sub
End Class

//
// ForecastSheet.Designer.vb
//


Partial Class ForecastSheet
    ''' <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(ForecastSheet))
        menuStrip1 = New Windows.Forms.MenuStrip()
        forecastSheetToolStripMenuItem = New Windows.Forms.ToolStripMenuItem()
        openFileToolStripMenuItem = New Windows.Forms.ToolStripMenuItem()
        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()
        menuStrip1.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)
        pnlMain.Controls.Add(menuStrip1)
        ' 
        ' pnlControls
        ' 
        pnlControls.Size = New Drawing.Size(210, 599)
        ' 
        ' menuStrip1
        ' 
        menuStrip1.ImageScalingSize = New Drawing.Size(20, 20)
        menuStrip1.Items.AddRange(New Windows.Forms.ToolStripItem() {forecastSheetToolStripMenuItem, openFileToolStripMenuItem})
        menuStrip1.Location = New Drawing.Point(0, 0)
        menuStrip1.Name = "menuStrip1"
        menuStrip1.Size = New Drawing.Size(636, 28)
        menuStrip1.TabIndex = 0
        menuStrip1.Text = "menuStrip1"
        ' 
        ' forecastSheetToolStripMenuItem
        ' 
        forecastSheetToolStripMenuItem.Name = "forecastSheetToolStripMenuItem"
        forecastSheetToolStripMenuItem.Size = New Drawing.Size(119, 24)
        forecastSheetToolStripMenuItem.Text = "Forecast Sheet"
        AddHandler forecastSheetToolStripMenuItem.Click, New EventHandler(AddressOf OnForecastSheetMenuItemClick)
        ' 
        ' openFileToolStripMenuItem
        ' 
        openFileToolStripMenuItem.Name = "openFileToolStripMenuItem"
        openFileToolStripMenuItem.Size = New Drawing.Size(86, 24)
        openFileToolStripMenuItem.Text = "Open File"
        AddHandler openFileToolStripMenuItem.Click, New EventHandler(AddressOf OnOpenFileMenuItemClick)
        ' 
        ' splitContainer1
        ' 
        splitContainer1.Dock = Windows.Forms.DockStyle.Fill
        splitContainer1.IsSplitterFixed = True
        splitContainer1.Location = New Drawing.Point(0, 28)
        splitContainer1.Name = "splitContainer1"
        splitContainer1.Orientation = Windows.Forms.Orientation.Horizontal
        ' 
        ' splitContainer1.Panel1
        ' 
        splitContainer1.Panel1.Controls.Add(splitContainer2)
        ' 
        ' splitContainer1.Panel2
        ' 
        splitContainer1.Panel2.Controls.Add(_fpSpread)
        splitContainer1.Size = New Drawing.Size(636, 571)
        splitContainer1.SplitterDistance = 25
        splitContainer1.TabIndex = 1
        ' 
        ' splitContainer2
        ' 
        splitContainer2.Dock = Windows.Forms.DockStyle.Fill
        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 = 70
        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(70, 24)
        nameBox1.TabIndex = 0
        ' Attach nameBox1 to _fpSpread
        nameBox1.Attach(_fpSpread)
        ' 
        ' _fpSpread
        ' 
        _fpSpread.AccessibleDescription = "Book1, Sheet1, Row 0, Column 0"
        _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, 542)
        _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(562, 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(560, 23)
        formulaTextBox1.TabIndex = 0
        ' Attach formulaTextBox1 to _fpSpread
        formulaTextBox1.Attach(_fpSpread)
        ' 
        ' ForecastSheet
        ' 
        AutoScaleDimensions = New Drawing.SizeF(8.0F, 16.0F)
        AutoScaleMode = Windows.Forms.AutoScaleMode.Font
        Name = "ForecastSheet"
        pnlMain.ResumeLayout(False)
        pnlMain.PerformLayout()
        menuStrip1.ResumeLayout(False)
        menuStrip1.PerformLayout()
        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 menuStrip1 As Windows.Forms.MenuStrip
    Private forecastSheetToolStripMenuItem As Windows.Forms.ToolStripMenuItem
    Private splitContainer1 As Windows.Forms.SplitContainer
    Private splitContainer2 As Windows.Forms.SplitContainer
    Private nameBox1 As FarPoint.Win.Spread.NameBox
    Private panel1 As Windows.Forms.Panel
    Private formulaTextBox1 As FarPoint.Win.Spread.FormulaTextBox
    Private _fpSpread As FarPoint.Win.Spread.FpSpread
    Private _fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
    Private openFileToolStripMenuItem As Windows.Forms.ToolStripMenuItem
End Class