Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Drawing
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms
Imports FarPoint.Win.Spread.Model
Imports FarPoint.Win.Chart
Imports System.Reflection
Imports FarPoint.Win.Spread.Data
Imports Spread.Common.Features.Spread.Common.Features.Sample

Partial Public Class BasicCharts
    Inherits BaseSampleControl
    Private _chartTypes As New Dictionary(Of String, Dictionary(Of String, Type))() From {
        {"Column", New Dictionary(Of String, Type)() From {
            {"Column", GetType(BarSeries)},
            {"Clustered", GetType(ClusteredBarSeries)},
            {"Stacked", GetType(StackedBarSeries)},
            {"Stacked 100%", GetType(StackedBarSeries)},
            {"High Low", GetType(HighLowBarSeries)}
        }},
        {"Bar", New Dictionary(Of String, Type)() From {
            {"Bar", GetType(BarSeries)},
            {"Clustered", GetType(ClusteredBarSeries)},
            {"Stacked", GetType(StackedBarSeries)},
            {"Stacked 100%", GetType(StackedBarSeries)},
            {"High Low", GetType(HighLowBarSeries)}
        }},
        {"Area", New Dictionary(Of String, Type)() From {
            {"Area", GetType(AreaSeries)},
            {"Stacked", GetType(StackedAreaSeries)},
            {"Stacked 100%", GetType(StackedAreaSeries)},
            {"High Low", GetType(HighLowAreaSeries)}
        }},
        {"Line", New Dictionary(Of String, Type)() From {
            {"Line", GetType(LineSeries)},
            {"Smoothed", GetType(LineSeries)},
            {"Stacked", GetType(StackedLineSeries)},
            {"Stacked 100%", GetType(StackedLineSeries)}
        }},
        {"Line With Marker", New Dictionary(Of String, Type)() From {
            {"Line WIth Marker", GetType(LineSeries)},
            {"Smoothed", GetType(LineSeries)},
            {"Stacked", GetType(StackedLineSeries)},
            {"Stacked 100%", GetType(StackedLineSeries)}
        }},
        {"Bubble", New Dictionary(Of String, Type)() From {
            {"Bubble", GetType(XYBubbleSeries)}
        }},
        {"XY", New Dictionary(Of String, Type)() From {
            {"Point", GetType(XYPointSeries)},
            {"Line", GetType(XYLineSeries)},
            {"Line With Marker", GetType(XYLineSeries)}
        }},
        {"XYZ", New Dictionary(Of String, Type)() From {
            {"Point", GetType(XYZPointSeries)},
            {"Line", GetType(XYZLineSeries)},
            {"Line With Marker", GetType(XYZLineSeries)},
            {"Surface", GetType(XYZSurfaceSeries)}
        }},
        {"Stock", New Dictionary(Of String, Type)() From {
            {"High Low Close", GetType(HighLowCloseSeries)},
            {"Open High Low Close", GetType(OpenHighLowCloseSeries)},
            {"Candle Stick", GetType(CandlestickSeries)}
        }},
        {"Pie", New Dictionary(Of String, Type)() From {
            {"Pie", GetType(PieSeries)},
            {"Exploded", GetType(PieSeries)}
        }},
        {"Doughnut", New Dictionary(Of String, Type)() From {
            {"Doughnut", GetType(PieSeries)},
            {"Exploded", GetType(PieSeries)}
        }}
    }
    Private _dataAdapter As SpreadDataBindingAdapter
    Private rowCount As Integer = 0, colCount As Integer = 0
    Public Sub New()
        InitializeComponent()
        Name = "Basic Chart Types"

        'Init Controls
        _dataAdapter = New SpreadDataBindingAdapter() With {
            .Spread = fpSpread1,
            .SheetName = "Sheet1",
            .DataAutoCellTypes = False
        }
        _cbChartGroup.DataSource = _chartTypes.Keys.ToList()
        _cbShape.DataSource = [Enum].GetNames(GetType(BarShape))
        _cbLegendPos.DataSource = [Enum].GetNames(GetType(LegendPos))

        'Set Data
        SetDefaultData()

        AddHandler _cbChartGroup.SelectedIndexChanged, AddressOf _cbChartGroup_SelectedIndexChanged
        AddHandler _cbChartType.SelectedIndexChanged, AddressOf _cbChartType_SelectedIndexChanged
        AddHandler _cbShape.SelectedIndexChanged, AddressOf _cbShape_SelectedIndexChanged
        AddHandler _cbLegendPos.SelectedIndexChanged, AddressOf _cbLegendPos_SelectedIndexChanged
        AddHandler _chb3DView.CheckedChanged, AddressOf _chb3DView_CheckedChanged
        AddHandler _chbLegOrientation.CheckedChanged, AddressOf _chbLegOrientation_CheckedChanged
        _cbChartGroup_SelectedIndexChanged(_cbChartGroup, New EventArgs())
    End Sub

    Private Sub _chbLegOrientation_CheckedChanged(sender As Object, e As EventArgs)
        fpSpread1_Sheet1.Charts(0).Model.LegendAreas(0).Vertical = _chbLegOrientation.Checked
    End Sub

    Private Sub _cbLegendPos_SelectedIndexChanged(sender As Object, e As EventArgs)
        fpSpread1_Sheet1.Charts(0).Model.LegendAreas(0).LegendPos = CType([Enum].Parse(GetType(LegendPos), _cbLegendPos.SelectedItem.ToString()), LegendPos)
    End Sub

    Private Sub _chb3DView_CheckedChanged(sender As Object, e As EventArgs)
        fpSpread1_Sheet1.Charts(0).ViewType = If(_chb3DView.Checked, ChartViewType.View3D, ChartViewType.View2D)
    End Sub

    Private Sub _cbShape_SelectedIndexChanged(sender As Object, e As EventArgs)
        Dim shape = CType([Enum].Parse(GetType(BarShape), _cbShape.SelectedItem.ToString()), BarShape)
        For Each ser As Object In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
            If TypeOf ser Is BarSeries Then
                ser.BarShape = shape
            ElseIf TypeOf ser Is HighLowBarSeries Then
                ser.BarShape = shape
            Else
                For Each dSer As Object In ser.Series
                    dSer.BarShape = shape
                Next
            End If
        Next
    End Sub

    Private Sub _cbChartType_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
        Dim grpName As String = _cbChartGroup.SelectedItem.ToString()
        Dim typeName As String = _cbChartType.SelectedItem.ToString()
        Dim series = _chartTypes(grpName)(typeName)
        _lShape.Visible = CSharpImpl.__Assign(_cbShape.Visible, (grpName = "Column" OrElse grpName = "Bar"))
        fpSpread1_Sheet1.Charts.Clear()
        Dim cellRange = If(typeName = "High Low Close", New CellRange(1, 2, rowCount - 1, colCount - 2), New CellRange(0, 0, rowCount, colCount))
        Dim view = If(_chb3DView.Checked, ChartViewType.View3D, ChartViewType.View2D)
        fpSpread1_Sheet1.AddChart(cellRange, series, 600, 400, 50, 200, view, True)
        SetChartProperties(grpName, typeName)
        ShowPlotWithGridLines(fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0))
        fpSpread1_Sheet1.Charts(0).ContextMenuStrip = Nothing
        If _cbShape.Visible Then _cbShape.SelectedIndex = 0
        _cbLegendPos.SelectedItem = "Right"
        _chbLegOrientation.Checked = True
    End Sub


    Private Sub ShowPlotWithGridLines(plotArea As PlotArea)
        plotArea.Depth = 0.5F
        If TypeOf plotArea Is YPlotArea Then
            TryCast(plotArea, YPlotArea).XAxis.MajorGridVisible = True
            TryCast(plotArea, YPlotArea).YAxes(0).MajorGridVisible = True
            TryCast(plotArea, YPlotArea).ZAxis.MajorGridVisible = True
        ElseIf TypeOf plotArea Is XYPlotArea Then
            TryCast(plotArea, XYPlotArea).XAxes(0).MajorGridVisible = True
            TryCast(plotArea, XYPlotArea).YAxes(0).MajorGridVisible = True
            TryCast(plotArea, XYPlotArea).ZAxis.MajorGridVisible = True
        ElseIf TypeOf plotArea Is XYZPlotArea Then
            TryCast(plotArea, XYZPlotArea).XAxes(0).MajorGridVisible = True
            TryCast(plotArea, XYZPlotArea).YAxes(0).MajorGridVisible = True
            TryCast(plotArea, XYZPlotArea).ZAxes(0).MajorGridVisible = True
        End If
    End Sub

    Private Sub SetChartProperties(grpName As String, typeName As String)
        Dim chartType = If(grpName <> typeName, String.Join(" ", typeName, grpName), grpName)
        'Set Header
        fpSpread1_Sheet1.Charts(0).Model.LabelAreas.Clear()
        fpSpread1_Sheet1.Charts(0).Model.LabelAreas.Add(New LabelArea() With {
            .Text = chartType,
             .Location = New PointF(0.5F, 0.05F),
             .AlignmentX = 0.5F,
             .AlignmentY = 0.5F
        })

        'Chart Group related changes
        If grpName = "Bar" Then
            TryCast(fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0), YPlotArea).Vertical = False
        ElseIf grpName = "Line" Then
            For Each lSer As Object In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                If Not (TypeOf lSer Is StackedLineSeries) Then
                    lSer.PointMarker = New NoMarker()
                Else
                    For Each ser As Object In lSer.Series
                        ser.PointMarker = New NoMarker()
                    Next
                End If
            Next
        ElseIf grpName = "Doughnut" Then
            TryCast(fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0), PiePlotArea).HoleSize = 0.7F
        End If

        'Chart Type related changes
        If typeName = "Stacked 100%" Then
            For Each ser As Object In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                ser.Percent = True
            Next
        ElseIf typeName = "Smoothed" Then
            For Each lSer As LineSeries In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                lSer.SmoothedLine = True
            Next
        ElseIf typeName = "High Low Close" Then
            For Each hlcSer As HighLowCloseSeries In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                hlcSer.CategoryNames.AddRange(fpSpread1_Sheet1.GetClipValue(1, 0, rowCount - 1, 1).Split(ControlChars.Lf))
            Next
        ElseIf typeName = "Exploded" Then
            For Each pieSer As PieSeries In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                pieSer.PieDetachments.AddRange(Enumerable.Repeat(0.2F, pieSer.Values.Count).ToArray())
            Next
        ElseIf typeName = "Line" Then
            For Each pSer As Object In fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series
                pSer.PointMarker = New NoMarker()
            Next
        End If
    End Sub

    Private Sub _cbChartGroup_SelectedIndexChanged(sender As Object, e As EventArgs)
        Dim groupName As String = "Column"
        If _cbChartGroup.SelectedItem IsNot Nothing Then
            groupName = _cbChartGroup.SelectedItem.ToString()
        End If

        'Set Data for selected chart group
        Select Case groupName
            Case "Stock"
                SetData(DataSource.GetStockData())
                Exit Select
            Case "Pie"
                SetData(DataSource.GetMarketShareData(1))
                Exit Select
            Case "Doughnut"
                SetData(DataSource.GetMarketShareData(1))
                Exit Select
            Case Else
                SetDefaultData()
                Exit Select
        End Select
        _chb3DView.Checked = If(groupName = "XYZ", True, _chb3DView.Checked)
        Dim chartTypes = _chartTypes.Where(Function(x) x.Key = groupName).SelectMany(Function(x) x.Value.Keys.ToList()).ToList()
        _cbChartType.DataSource = chartTypes
    End Sub
    Private Sub SetDefaultData()
        ResetSheetData()
        Dim rnd As New Random()
        fpSpread1_Sheet1.SetClipValue(0, 0, 1, 8, vbTab & "Chrome" & vbTab & "FireFox" & vbTab & "IE" & vbTab & "Safari" & vbTab & "Edge" & vbTab & "Opera" & vbTab & "Other")
        For i As Integer = 1 To 4
            fpSpread1_Sheet1.Cells(i, 0).Value = DateTime.Now.Year - i
            For j As Integer = 1 To 7
                fpSpread1_Sheet1.Cells(i, j).Value = rnd.NextDouble().ToString("0.00")
            Next
        Next
        rowCount = 5
        colCount = 8
    End Sub
    Private Sub SetData(list As List(Of Object))
        ResetSheetData()
        Dim r As Integer = 0, c As Integer = 1
        For Each prop As Object In list(0).[GetType]().GetProperties().Skip(1)
            fpSpread1_Sheet1.Cells(r, c).Value = prop.Name
            c += 1
        Next
        _dataAdapter.DataSource = list
        _dataAdapter.MapperInfo = New MapperInfo(1, 0, list.Count, c)
        _dataAdapter.FillSpreadDataByDataSource()
        rowCount = list.Count + 1
        colCount = c
    End Sub
    Private Sub ResetSheetData()
        _dataAdapter.DataSource = Nothing
        fpSpread1_Sheet1.ClearRange(0, 0, rowCount + 1, colCount + 1, False, FarPoint.Win.Spread.ClipboardCopyOptions.All)
    End Sub
    Private Shared Function InlineAssignHelper(Of T)(ByRef target As T, value As T) As T
        target = value
        Return value
    End Function
    Private Class CSharpImpl
        <Obsolete("Please refactor calling code to use normal Visual Basic assignment")>
        Shared Function __Assign(Of T)(ByRef target As T, value As T) As T
            target = value
            Return value
        End Function
    End Class
End Class

'
'
'

Partial Class BasicCharts
	''' <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 Shadows 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()
		Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread()
		Me.fpSpread1_Sheet1 = New FarPoint.Win.Spread.SheetView()
		Me._lChartGroup = New System.Windows.Forms.Label()
		Me._cbChartGroup = New System.Windows.Forms.ComboBox()
		Me._lChartType = New System.Windows.Forms.Label()
		Me._cbChartType = New System.Windows.Forms.ComboBox()
		Me._chb3DView = New System.Windows.Forms.CheckBox()
		Me._lShape = New System.Windows.Forms.Label()
		Me._cbShape = New System.Windows.Forms.ComboBox()
		Me._lLegendPos = New System.Windows.Forms.Label()
		Me._cbLegendPos = New System.Windows.Forms.ComboBox()
		Me._chbLegOrientation = New System.Windows.Forms.CheckBox()
		Me.pnlMain.SuspendLayout()
		Me.pnlControls.SuspendLayout()
		DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
		DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
		Me.SuspendLayout()
		' 
		' pnlMain
		' 
		Me.pnlMain.Controls.Add(Me.fpSpread1)
		' 
		' pnlControls
		' 
		Me.pnlControls.Controls.Add(Me._chbLegOrientation)
		Me.pnlControls.Controls.Add(Me._cbLegendPos)
		Me.pnlControls.Controls.Add(Me._lLegendPos)
		Me.pnlControls.Controls.Add(Me._cbShape)
		Me.pnlControls.Controls.Add(Me._lShape)
		Me.pnlControls.Controls.Add(Me._chb3DView)
		Me.pnlControls.Controls.Add(Me._cbChartType)
		Me.pnlControls.Controls.Add(Me._lChartType)
		Me.pnlControls.Controls.Add(Me._cbChartGroup)
		Me.pnlControls.Controls.Add(Me._lChartGroup)
		' 
		' fpSpread1
		' 
		Me.fpSpread1.AccessibleDescription = ""
		Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
		Me.fpSpread1.Location = New System.Drawing.Point(0, 0)
		Me.fpSpread1.Name = "fpSpread1"
		Me.fpSpread1.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread1_Sheet1})
		Me.fpSpread1.Size = New System.Drawing.Size(477, 487)
		Me.fpSpread1.TabIndex = 0
		' 
		' fpSpread1_Sheet1
		' 
		Me.fpSpread1_Sheet1.Reset()
		Me.fpSpread1_Sheet1.SheetName = "Sheet1"
		' Formulas and custom names must be loaded with R1C1 reference style
		Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
		Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
		' 
		' _lChartGroup
		' 
		Me._lChartGroup.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lChartGroup.AutoSize = True
		Me._lChartGroup.Location = New System.Drawing.Point(14, 18)
		Me._lChartGroup.Name = "_lChartGroup"
		Me._lChartGroup.Size = New System.Drawing.Size(70, 13)
		Me._lChartGroup.TabIndex = 0
		Me._lChartGroup.Text = "Chart Group :"
		' 
		' _cbChartGroup
		' 
		Me._cbChartGroup.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbChartGroup.FormattingEnabled = True
		Me._cbChartGroup.Location = New System.Drawing.Point(29, 44)
		Me._cbChartGroup.Name = "_cbChartGroup"
		Me._cbChartGroup.Size = New System.Drawing.Size(121, 21)
		Me._cbChartGroup.TabIndex = 1
		' 
		' _lChartType
		' 
		Me._lChartType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lChartType.AutoSize = True
		Me._lChartType.Location = New System.Drawing.Point(14, 79)
		Me._lChartType.Name = "_lChartType"
		Me._lChartType.Size = New System.Drawing.Size(65, 13)
		Me._lChartType.TabIndex = 2
		Me._lChartType.Text = "Chart Type :"
		' 
		' _cbChartType
		' 
		Me._cbChartType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbChartType.FormattingEnabled = True
		Me._cbChartType.Location = New System.Drawing.Point(29, 109)
		Me._cbChartType.Name = "_cbChartType"
		Me._cbChartType.Size = New System.Drawing.Size(121, 21)
		Me._cbChartType.TabIndex = 3
		' 
		' _chb3DView
		' 
		Me._chb3DView.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._chb3DView.AutoSize = True
		Me._chb3DView.Location = New System.Drawing.Point(17, 151)
		Me._chb3DView.Name = "_chb3DView"
		Me._chb3DView.Size = New System.Drawing.Size(66, 17)
		Me._chb3DView.TabIndex = 4
		Me._chb3DView.Text = "3D View"
		Me._chb3DView.UseVisualStyleBackColor = True
		' 
		' _lShape
		' 
		Me._lShape.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lShape.AutoSize = True
		Me._lShape.Location = New System.Drawing.Point(17, 188)
		Me._lShape.Name = "_lShape"
		Me._lShape.Size = New System.Drawing.Size(44, 13)
		Me._lShape.TabIndex = 5
		Me._lShape.Text = "Shape :"
		' 
		' _cbShape
		' 
		Me._cbShape.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbShape.FormattingEnabled = True
		Me._cbShape.Location = New System.Drawing.Point(29, 215)
		Me._cbShape.Name = "_cbShape"
		Me._cbShape.Size = New System.Drawing.Size(121, 21)
		Me._cbShape.TabIndex = 6
		' 
		' _lLegendPos
		' 
		Me._lLegendPos.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lLegendPos.AutoSize = True
		Me._lLegendPos.Location = New System.Drawing.Point(20, 259)
		Me._lLegendPos.Name = "_lLegendPos"
		Me._lLegendPos.Size = New System.Drawing.Size(89, 13)
		Me._lLegendPos.TabIndex = 7
		Me._lLegendPos.Text = "Legend Position :"
		' 
		' _cbLegendPos
		' 
		Me._cbLegendPos.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbLegendPos.FormattingEnabled = True
		Me._cbLegendPos.Location = New System.Drawing.Point(29, 288)
		Me._cbLegendPos.Name = "_cbLegendPos"
		Me._cbLegendPos.Size = New System.Drawing.Size(121, 21)
		Me._cbLegendPos.TabIndex = 8
		' 
		' _chbLegOrientation
		' 
		Me._chbLegOrientation.AutoSize = True
		Me._chbLegOrientation.Checked = True
		Me._chbLegOrientation.CheckState = System.Windows.Forms.CheckState.Checked
		Me._chbLegOrientation.Location = New System.Drawing.Point(23, 335)
		Me._chbLegOrientation.Name = "_chbLegOrientation"
		Me._chbLegOrientation.Size = New System.Drawing.Size(100, 17)
		Me._chbLegOrientation.TabIndex = 9
		Me._chbLegOrientation.Text = "Vertical Legend"
		Me._chbLegOrientation.UseVisualStyleBackColor = True
		' 
		' Introduction
		' 
		Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
		Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
		Me.Name = "Introduction"
		Me.pnlMain.ResumeLayout(False)
		Me.pnlControls.ResumeLayout(False)
		Me.pnlControls.PerformLayout()
		DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
		DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
		Me.ResumeLayout(False)

	End Sub

	#End Region

	Private fpSpread1 As FarPoint.Win.Spread.FpSpread
	Private fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
	Private _lChartType As System.Windows.Forms.Label
	Private _cbChartGroup As System.Windows.Forms.ComboBox
	Private _lChartGroup As System.Windows.Forms.Label
	Private _cbChartType As System.Windows.Forms.ComboBox
	Private _cbShape As System.Windows.Forms.ComboBox
	Private _lShape As System.Windows.Forms.Label
	Private _chb3DView As System.Windows.Forms.CheckBox
	Private _chbLegOrientation As System.Windows.Forms.CheckBox
	Private _cbLegendPos As System.Windows.Forms.ComboBox
	Private _lLegendPos As System.Windows.Forms.Label
End Class
