Imports System.Collections.Generic
Imports System.Drawing
Imports System.Linq
Imports FarPoint.Win.Spread
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Public Class BulletSparkline
        Inherits BaseSampleControl

        Public Sub New()
            InitializeComponent()
            Name = "Bullet"

            InitSparklineSettings()
            InitSpread()
        End Sub

#Region "Private methods"
        Private Sub InitSparklineSettings()
            Dim colors As List(Of Color) = New List(Of Color) From {
                Color.White,
                Color.Black,
                Color.Orange,
                Color.LightGray,
                Color.Gray,
                Color.DarkGray,
                Color.Green
            }

            comboColorScheme.DataSource = colors
            comboMeasureColor.DataSource = colors.ToList()
            comboTargetColor.DataSource = colors.ToList()
            comboMaxColor.DataSource = colors.ToList()
            comboOptimistColor.DataSource = colors.ToList()
            comboPessimistColor.DataSource = colors.ToList()
            comboForecastColor.DataSource = colors.ToList()

            comboColorScheme.SelectedItem = Color.White
            comboMeasureColor.SelectedItem = Color.Black
            comboTargetColor.SelectedItem = Color.Orange
            comboMaxColor.SelectedItem = Color.LightGray
            comboOptimistColor.SelectedItem = Color.Gray
            comboPessimistColor.SelectedItem = Color.DarkGray
            comboForecastColor.SelectedItem = Color.White

            chkMeasureOverMax.Checked = True
            numericBarSize.Value = 0.7D

            AddHandler comboColorScheme.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboMeasureColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboTargetColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboMaxColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboOptimistColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboPessimistColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler comboForecastColor.SelectedIndexChanged, AddressOf OnSparklineSettingsChanged
            AddHandler chkMeasureOverMax.CheckedChanged, AddressOf OnSparklineSettingsChanged
            AddHandler numericBarSize.ValueChanged, AddressOf OnSparklineSettingsChanged
        End Sub

        Private Sub InitSpread()
            fpSpread1.Sheets.Count = 2
            fpSpread1.TabStripInsertTab = False

            InitHorizontalSparkline(fpSpread1.Sheets(0), "Horizontal")
            InitVerticalSparkline(fpSpread1.Sheets(1), "Vertical")
        End Sub

        Private Sub InitHorizontalSparkline(ByVal sheetView As SheetView, ByVal name As String)
            Dim worksheet As GrapeCity.Spreadsheet.IWorksheet = sheetView.AsWorksheet()
            worksheet.Name = name
            worksheet.Cells("B2:I2").Merge()
            worksheet.Cells("B2").Value = "Revenue By Region (million $)"
            worksheet.Cells("B2").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Calibri",
                .Size = 16
            })
            worksheet.Cells("B2").HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Center
            worksheet.Cells("B2").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            sheetView.Cells("B2").ForeColor = Color.White
            sheetView.Cells("B2").BackColor = ColorTranslator.FromHtml("#82bc00")
            worksheet.Cells("B3:I9").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            worksheet.Cells("B3:I9").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Calibri",
                .Size = 12,
                .Bold = True
            })
            sheetView.Cells("B3:I9").BackColor = ColorTranslator.FromHtml("#F4F8EB")
            worksheet.Cells("B4:H9").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = sheetView.FpSpread.Font.Name,
                .Size = 12
            })
            worksheet.Cells("B4:H9").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            worksheet.Cells("B3:I9").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thin
            worksheet.Cells("B3:I9").Borders.Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())
            worksheet.Cells("B4:I9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideHorizontal).LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Dotted
            worksheet.Cells("B4:I9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideHorizontal).Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())
            worksheet.Cells("B4:I9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideVertical).LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Dotted
            worksheet.Cells("B4:I9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideVertical).Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())
            worksheet.SetValue(2, 1, New Object(,) {
            {"Region", "Forecast", "Actual", "Target", "Max", "Optimist F.", "Pessimist F."},
            {"North America", 80, 75, 70, 95, 65, 50},
            {"South America", 79, 62, 80, 95, 75, 50},
            {"Europe", 95, 100, 100, 120, 90, 80},
            {"Asia", 80, 95, 80, 90, 70, 55},
            {"Australia", 35, 20, 40, 50, 35, 15},
            {"Africa", 34, 40, 30, 50, 20, 15}})

            For i As Integer = 3 To 9 - 1
                UpdateSparkline(worksheet, i, 8, SparklineOrientation.Horizontal)
            Next

            worksheet.Rows("2").RowHeight = 30
            worksheet.Rows("4:9").RowHeight = 40
            worksheet.Columns("B:H").ColumnWidth = 100
            worksheet.Columns("I").ColumnWidth = 250
        End Sub

        Private Sub InitVerticalSparkline(ByVal sheetView As SheetView, ByVal name As String)
            Dim worksheet As GrapeCity.Spreadsheet.IWorksheet = sheetView.AsWorksheet()
            worksheet.Name = name

            worksheet.Cells("B2:H2").Merge()
            worksheet.Cells("B2").Value = "Revenue By Region (million $)"
            worksheet.Cells("B2").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Calibri",
                .Size = 16
            })

            worksheet.Cells("B2").HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Center
            worksheet.Cells("B2").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            sheetView.Cells("B2").ForeColor = Color.White
            sheetView.Cells("B2").BackColor = ColorTranslator.FromHtml("#82bc00")
            worksheet.Cells("B3:B9").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            worksheet.Cells("B3:B9").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Calibri",
                .Size = 12,
                .Bold = True
            })

            sheetView.Cells("B3:B9").BackColor = ColorTranslator.FromHtml("#F4F8EB")
            worksheet.Cells("C3:H9").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = sheetView.FpSpread.Font.Name,
                .Size = 12
            })

            worksheet.Cells("C3:H9").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            worksheet.Cells("B3:H9").Borders.LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Thin
            worksheet.Cells("B3:H9").Borders.Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())
            worksheet.Cells("C3:H9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideHorizontal).LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Dotted
            worksheet.Cells("C3:H9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideHorizontal).Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())
            worksheet.Cells("C3:H9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideVertical).LineStyle = GrapeCity.Spreadsheet.BorderLineStyle.Dotted
            worksheet.Cells("C3:H9").Borders(GrapeCity.Spreadsheet.BordersIndex.InsideVertical).Color = GrapeCity.Spreadsheet.Color.FromArgb(Color.Black.ToArgb())

            worksheet.SetValue(2, 1, New Object(,) {
            {"Region", "North America", "South America", "Europe", "Asia", "Australia", "Africa"},
            {"Forecast", 80, 79, 95, 80, 35, 34},
            {"Actual", 75, 62, 100, 95, 20, 40},
            {"Target", 70, 80, 100, 80, 40, 30},
            {"Max", 95, 95, 120, 90, 50, 50},
            {"Optimist F.", 65, 75, 90, 70, 35, 20},
            {"Pessimist F.", 50, 50, 80, 55, 15, 15}})

            For i As Integer = 2 To 8 - 1
                UpdateSparkline(worksheet, 9, i, SparklineOrientation.Vertical)
            Next

            worksheet.Rows("2").RowHeight = 30
            worksheet.Rows("10").RowHeight = 200
            worksheet.Columns("B:H").ColumnWidth = 100
        End Sub

        Private Sub UpdateSparkline(worksheet As GrapeCity.Spreadsheet.IWorksheet, row As Integer, col As Integer, orientation As SparklineOrientation)
            Dim colorScheme As Color = DirectCast(comboColorScheme.SelectedItem, Color)
            Dim measureColor As Color = DirectCast(comboMeasureColor.SelectedItem, Color)
            Dim targetColor As Color = DirectCast(comboTargetColor.SelectedItem, Color)
            Dim maxColor As Color = DirectCast(comboMaxColor.SelectedItem, Color)
            Dim goodColor As Color = DirectCast(comboOptimistColor.SelectedItem, Color)
            Dim badColor As Color = DirectCast(comboPessimistColor.SelectedItem, Color)
            Dim forecastColor As Color = DirectCast(comboForecastColor.SelectedItem, Color)

            Dim colName As Char = Chr(Asc("A") + col)
            If orientation = SparklineOrientation.Horizontal Then
                worksheet.Cells($"{colName}{row + 1}").Formula2 = $"BULLETSPARKLINE($D{row + 1}, $E{row + 1}, $F{row + 1}, $G{row + 1}, $H{row + 1}," +
                    $"$C{row + 1}, 1, ""{colorScheme.Name}"", False, ""{measureColor.Name}"", ""{targetColor.Name}"", ""{maxColor.Name}"", ""{goodColor.Name}""," +
                    $"""{badColor.Name}"", ""{forecastColor.Name}"", {chkMeasureOverMax.Checked}, {numericBarSize.Value})"
            Else
                worksheet.Cells($"{colName}{row + 1}").Formula2 = $"BULLETSPARKLINE(${colName}5, ${colName}6, ${colName}7, ${colName}8, ${colName}9," +
                    $"${colName}4, 1, ""{colorScheme.Name}"", True, ""{measureColor.Name}"", ""{targetColor.Name}"", ""{maxColor.Name}"", ""{goodColor.Name}""," +
                    $"""{badColor.Name}"", ""{forecastColor.Name}"", {chkMeasureOverMax.Checked}, {numericBarSize.Value})"
            End If
        End Sub
#End Region

#Region "Event handlers"
        Private Sub OnSparklineSettingsChanged(sender As Object, e As EventArgs)
            If fpSpread1.ActiveSheetIndex = 0 Then
                For row As Integer = 3 To 8
                    UpdateSparkline(fpSpread1.ActiveSheet.AsWorksheet(), row, 8, SparklineOrientation.Horizontal)
                Next
            ElseIf fpSpread1.ActiveSheetIndex = 1 Then
                For col As Integer = 2 To 7
                    UpdateSparkline(fpSpread1.ActiveSheet.AsWorksheet(), 9, col, SparklineOrientation.Vertical)
                Next
            End If
        End Sub
#End Region

        Enum SparklineOrientation
            Horizontal
            Vertical
        End Enum
    End Class
End Namespace


'
'BulletSparkline.Designer.vb
'


Namespace Features
    Partial Class BulletSparkline
        ''' <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

        '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(BulletSparkline))
            Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("pnlMain.Controls"), Object))
            Me.fpSpread1_Sheet1 = Me.fpSpread1.GetSheet(0)
            Me.groupBox1 = New System.Windows.Forms.GroupBox()
            Me.numericBarSize = New System.Windows.Forms.NumericUpDown()
            Me.label8 = New System.Windows.Forms.Label()
            Me.chkMeasureOverMax = New System.Windows.Forms.CheckBox()
            Me.comboForecastColor = New System.Windows.Forms.ComboBox()
            Me.label7 = New System.Windows.Forms.Label()
            Me.comboPessimistColor = New System.Windows.Forms.ComboBox()
            Me.label6 = New System.Windows.Forms.Label()
            Me.comboOptimistColor = New System.Windows.Forms.ComboBox()
            Me.label5 = New System.Windows.Forms.Label()
            Me.comboMaxColor = New System.Windows.Forms.ComboBox()
            Me.label4 = New System.Windows.Forms.Label()
            Me.comboTargetColor = New System.Windows.Forms.ComboBox()
            Me.label3 = New System.Windows.Forms.Label()
            Me.comboMeasureColor = New System.Windows.Forms.ComboBox()
            Me.label2 = New System.Windows.Forms.Label()
            Me.comboColorScheme = New System.Windows.Forms.ComboBox()
            Me.label1 = New System.Windows.Forms.Label()
            Me.pnlMain.SuspendLayout()
            Me.pnlControls.SuspendLayout()
            CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.groupBox1.SuspendLayout()
            CType(Me.numericBarSize, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.SuspendLayout()
            '
            'pnlMain
            '
            Me.pnlMain.Controls.Add(Me.fpSpread1)
            Me.pnlMain.Size = New System.Drawing.Size(521, 487)
            '
            'pnlControls
            '
            Me.pnlControls.Controls.Add(Me.groupBox1)
            Me.pnlControls.Margin = New System.Windows.Forms.Padding(2)
            Me.pnlControls.Size = New System.Drawing.Size(172, 487)
            '
            'fpSpread1
            '
            Me.fpSpread1.AccessibleDescription = "Book1, 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.Margin = New System.Windows.Forms.Padding(2)
            Me.fpSpread1.Name = "fpSpread1"
            Me.fpSpread1.Size = New System.Drawing.Size(521, 487)
            Me.fpSpread1.TabIndex = 2
            '
            'groupBox1
            '
            Me.groupBox1.Controls.Add(Me.numericBarSize)
            Me.groupBox1.Controls.Add(Me.label8)
            Me.groupBox1.Controls.Add(Me.chkMeasureOverMax)
            Me.groupBox1.Controls.Add(Me.comboForecastColor)
            Me.groupBox1.Controls.Add(Me.label7)
            Me.groupBox1.Controls.Add(Me.comboPessimistColor)
            Me.groupBox1.Controls.Add(Me.label6)
            Me.groupBox1.Controls.Add(Me.comboOptimistColor)
            Me.groupBox1.Controls.Add(Me.label5)
            Me.groupBox1.Controls.Add(Me.comboMaxColor)
            Me.groupBox1.Controls.Add(Me.label4)
            Me.groupBox1.Controls.Add(Me.comboTargetColor)
            Me.groupBox1.Controls.Add(Me.label3)
            Me.groupBox1.Controls.Add(Me.comboMeasureColor)
            Me.groupBox1.Controls.Add(Me.label2)
            Me.groupBox1.Controls.Add(Me.comboColorScheme)
            Me.groupBox1.Controls.Add(Me.label1)
            Me.groupBox1.Dock = System.Windows.Forms.DockStyle.Top
            Me.groupBox1.Location = New System.Drawing.Point(0, 0)
            Me.groupBox1.Margin = New System.Windows.Forms.Padding(2)
            Me.groupBox1.Name = "groupBox1"
            Me.groupBox1.Padding = New System.Windows.Forms.Padding(2)
            Me.groupBox1.Size = New System.Drawing.Size(172, 301)
            Me.groupBox1.TabIndex = 1
            Me.groupBox1.TabStop = False
            Me.groupBox1.Text = "Settings"
            '
            'numericBarSize
            '
            Me.numericBarSize.DecimalPlaces = 2
            Me.numericBarSize.Increment = New Decimal(New Integer() {5, 0, 0, 131072})
            Me.numericBarSize.Location = New System.Drawing.Point(60, 268)
            Me.numericBarSize.Margin = New System.Windows.Forms.Padding(2)
            Me.numericBarSize.Maximum = New Decimal(New Integer() {1, 0, 0, 0})
            Me.numericBarSize.Minimum = New Decimal(New Integer() {1, 0, 0, 131072})
            Me.numericBarSize.Name = "numericBarSize"
            Me.numericBarSize.Size = New System.Drawing.Size(69, 20)
            Me.numericBarSize.TabIndex = 16
            Me.numericBarSize.Value = New Decimal(New Integer() {5, 0, 0, 131072})
            '
            'label8
            '
            Me.label8.AutoSize = True
            Me.label8.Location = New System.Drawing.Point(7, 270)
            Me.label8.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label8.Name = "label8"
            Me.label8.Size = New System.Drawing.Size(49, 13)
            Me.label8.TabIndex = 15
            Me.label8.Text = "Bar Size:"
            '
            'chkMeasureOverMax
            '
            Me.chkMeasureOverMax.AutoSize = True
            Me.chkMeasureOverMax.Location = New System.Drawing.Point(9, 236)
            Me.chkMeasureOverMax.Margin = New System.Windows.Forms.Padding(2)
            Me.chkMeasureOverMax.Name = "chkMeasureOverMax"
            Me.chkMeasureOverMax.Size = New System.Drawing.Size(144, 17)
            Me.chkMeasureOverMax.TabIndex = 14
            Me.chkMeasureOverMax.Text = "Allow Measure Over Max"
            Me.chkMeasureOverMax.UseVisualStyleBackColor = True
            '
            'comboForecastColor
            '
            Me.comboForecastColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboForecastColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboForecastColor.FormattingEnabled = True
            Me.comboForecastColor.Location = New System.Drawing.Point(106, 203)
            Me.comboForecastColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboForecastColor.Name = "comboForecastColor"
            Me.comboForecastColor.Size = New System.Drawing.Size(62, 21)
            Me.comboForecastColor.TabIndex = 13
            '
            'label7
            '
            Me.label7.AutoSize = True
            Me.label7.Location = New System.Drawing.Point(7, 206)
            Me.label7.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label7.Name = "label7"
            Me.label7.Size = New System.Drawing.Size(78, 13)
            Me.label7.TabIndex = 12
            Me.label7.Text = "Forecast Color:"
            '
            'comboPessimistColor
            '
            Me.comboPessimistColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboPessimistColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboPessimistColor.FormattingEnabled = True
            Me.comboPessimistColor.Location = New System.Drawing.Point(106, 173)
            Me.comboPessimistColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboPessimistColor.Name = "comboPessimistColor"
            Me.comboPessimistColor.Size = New System.Drawing.Size(62, 21)
            Me.comboPessimistColor.TabIndex = 11
            '
            'label6
            '
            Me.label6.AutoSize = True
            Me.label6.Location = New System.Drawing.Point(7, 176)
            Me.label6.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label6.Name = "label6"
            Me.label6.Size = New System.Drawing.Size(80, 13)
            Me.label6.TabIndex = 10
            Me.label6.Text = "Pessimist Color:"
            '
            'comboOptimistColor
            '
            Me.comboOptimistColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboOptimistColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboOptimistColor.FormattingEnabled = True
            Me.comboOptimistColor.Location = New System.Drawing.Point(106, 143)
            Me.comboOptimistColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboOptimistColor.Name = "comboOptimistColor"
            Me.comboOptimistColor.Size = New System.Drawing.Size(62, 21)
            Me.comboOptimistColor.TabIndex = 9
            '
            'label5
            '
            Me.label5.AutoSize = True
            Me.label5.Location = New System.Drawing.Point(7, 146)
            Me.label5.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label5.Name = "label5"
            Me.label5.Size = New System.Drawing.Size(74, 13)
            Me.label5.TabIndex = 8
            Me.label5.Text = "Optimist Color:"
            '
            'comboMaxColor
            '
            Me.comboMaxColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboMaxColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboMaxColor.FormattingEnabled = True
            Me.comboMaxColor.Location = New System.Drawing.Point(106, 113)
            Me.comboMaxColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboMaxColor.Name = "comboMaxColor"
            Me.comboMaxColor.Size = New System.Drawing.Size(62, 21)
            Me.comboMaxColor.TabIndex = 7
            '
            'label4
            '
            Me.label4.AutoSize = True
            Me.label4.Location = New System.Drawing.Point(7, 116)
            Me.label4.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label4.Name = "label4"
            Me.label4.Size = New System.Drawing.Size(81, 13)
            Me.label4.TabIndex = 6
            Me.label4.Text = "Maximum Color:"
            '
            'comboTargetColor
            '
            Me.comboTargetColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboTargetColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboTargetColor.FormattingEnabled = True
            Me.comboTargetColor.Location = New System.Drawing.Point(106, 83)
            Me.comboTargetColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboTargetColor.Name = "comboTargetColor"
            Me.comboTargetColor.Size = New System.Drawing.Size(62, 21)
            Me.comboTargetColor.TabIndex = 5
            '
            'label3
            '
            Me.label3.AutoSize = True
            Me.label3.Location = New System.Drawing.Point(7, 86)
            Me.label3.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label3.Name = "label3"
            Me.label3.Size = New System.Drawing.Size(68, 13)
            Me.label3.TabIndex = 4
            Me.label3.Text = "Target Color:"
            '
            'comboMeasureColor
            '
            Me.comboMeasureColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboMeasureColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboMeasureColor.FormattingEnabled = True
            Me.comboMeasureColor.Location = New System.Drawing.Point(106, 53)
            Me.comboMeasureColor.Margin = New System.Windows.Forms.Padding(2)
            Me.comboMeasureColor.Name = "comboMeasureColor"
            Me.comboMeasureColor.Size = New System.Drawing.Size(62, 21)
            Me.comboMeasureColor.TabIndex = 3
            '
            'label2
            '
            Me.label2.AutoSize = True
            Me.label2.Location = New System.Drawing.Point(7, 56)
            Me.label2.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label2.Name = "label2"
            Me.label2.Size = New System.Drawing.Size(78, 13)
            Me.label2.TabIndex = 2
            Me.label2.Text = "Measure Color:"
            '
            'comboColorScheme
            '
            Me.comboColorScheme.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.comboColorScheme.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
            Me.comboColorScheme.FormattingEnabled = True
            Me.comboColorScheme.Location = New System.Drawing.Point(106, 23)
            Me.comboColorScheme.Margin = New System.Windows.Forms.Padding(2)
            Me.comboColorScheme.Name = "comboColorScheme"
            Me.comboColorScheme.Size = New System.Drawing.Size(62, 21)
            Me.comboColorScheme.TabIndex = 1
            '
            'label1
            '
            Me.label1.AutoSize = True
            Me.label1.Location = New System.Drawing.Point(7, 26)
            Me.label1.Margin = New System.Windows.Forms.Padding(2, 0, 2, 0)
            Me.label1.Name = "label1"
            Me.label1.Size = New System.Drawing.Size(76, 13)
            Me.label1.TabIndex = 0
            Me.label1.Text = "Color Scheme:"
            '
            'BulletSparkline
            '
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Margin = New System.Windows.Forms.Padding(2)
            Me.Name = "BulletSparkline"
            Me.Size = New System.Drawing.Size(694, 487)
            Me.pnlMain.ResumeLayout(False)
            Me.pnlControls.ResumeLayout(False)
            CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
            Me.groupBox1.ResumeLayout(False)
            Me.groupBox1.PerformLayout()
            CType(Me.numericBarSize, System.ComponentModel.ISupportInitialize).EndInit()
            Me.ResumeLayout(False)

        End Sub
        Private WithEvents fpSpread1 As FarPoint.Win.Spread.FpSpread
        Friend WithEvents fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
        Private WithEvents groupBox1 As System.Windows.Forms.GroupBox
        Private WithEvents numericBarSize As System.Windows.Forms.NumericUpDown
        Private WithEvents label8 As System.Windows.Forms.Label
        Private WithEvents chkMeasureOverMax As System.Windows.Forms.CheckBox
        Private WithEvents comboForecastColor As System.Windows.Forms.ComboBox
        Private WithEvents label7 As System.Windows.Forms.Label
        Private WithEvents comboPessimistColor As System.Windows.Forms.ComboBox
        Private WithEvents label6 As System.Windows.Forms.Label
        Private WithEvents comboOptimistColor As System.Windows.Forms.ComboBox
        Private WithEvents label5 As System.Windows.Forms.Label
        Private WithEvents comboMaxColor As System.Windows.Forms.ComboBox
        Private WithEvents label4 As System.Windows.Forms.Label
        Private WithEvents comboTargetColor As System.Windows.Forms.ComboBox
        Private WithEvents label3 As System.Windows.Forms.Label
        Private WithEvents comboMeasureColor As System.Windows.Forms.ComboBox
        Private WithEvents label2 As System.Windows.Forms.Label
        Private WithEvents comboColorScheme As System.Windows.Forms.ComboBox
        Private WithEvents label1 As System.Windows.Forms.Label
    End Class
End Namespace

