Imports System.Drawing
Imports System.Windows.Forms
Imports FarPoint.Win.Spread.Model
Imports FarPoint.Win.Spread.Chart
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.CellType
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class IntroSparkline
        Inherits BaseSampleControl
        Private _dateCell As DateTimeCellType
        Private _currencyCell As CurrencyCellType

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

            _dateCell = New DateTimeCellType()
            _dateCell.DateTimeFormat = DateTimeFormat.ShortDate

            _currencyCell = New CurrencyCellType()
            _currencyCell.DecimalPlaces = 2

            InitSpreadSheet(fpSpread.ActiveSheet)
            comboType.DataSource = [Enum].GetValues(GetType(SparklineType))

            AddSampleSparklines(fpSpread.ActiveSheet)

            AddHandler txtRow.TextChanged, AddressOf RowCol_TextChanged
            AddHandler txtColumn.TextChanged, AddressOf RowCol_TextChanged

            AddHandler btnAdd.Click, AddressOf BtnAdd_Click
            AddHandler btnClear.Click, AddressOf BtnClear_Click

            AddHandler fpSpread.EnterCell, AddressOf FpSpread_EnterCell
        End Sub

#Region "Private methods"
        Private Sub InitSpreadSheet(sheet As SheetView)
            fpSpread.AllowCellOverflow = True
            sheet.SetMultipleRowHeights(0, sheet.RowCount, 24)
            sheet.SetMultipleColumnWidths(0, sheet.ColumnCount, 75)
        End Sub

        Private Sub AddSampleSparklines(sheet As SheetView)
            Dim boldFont As New Font("Segoe", 9, FontStyle.Bold)

            sheet.Cells(1, 1).Text = "Stock Analysis example:"
            sheet.Cells(1, 1).Font = boldFont
            Dim random As New Random()
            Dim [date] As DateTime = DateTime.Now
            For row As Integer = 2 To 6
                sheet.Cells(row, 1).Value = [date].AddDays(random.[Next](-10, 10))
                sheet.Cells(row, 1).Font = boldFont
                sheet.Cells(row, 2).Value = random.[Next](50, 60)

                [date] = [date].AddDays(random.[Next](-5, -2))
            Next
            sheet.Cells(2, 1, 6, 1).CellType = _dateCell
            sheet.Cells(2, 1, 6, 1).HorizontalAlignment = CellHorizontalAlignment.Right
            sheet.Cells(2, 2, 6, 2).CellType = _currencyCell

            sheet.Cells(8, 1).Text = "Line Sparkline"
            sheet.Cells(8, 1).Font = boldFont
            sheet.Cells(8, 3).Text = "Column Sparkline"
            sheet.Cells(8, 3).Font = boldFont
            sheet.Cells(8, 5).Text = "Winloss Sparkline"
            sheet.Cells(8, 5).Font = boldFont

            sheet.Cells(9, 0).Text = "Without Date Axis"
            sheet.Cells(9, 0).Font = boldFont
            sheet.Cells(9, 0).VerticalAlignment = CellVerticalAlignment.Center
            sheet.Cells(12, 0).Text = "With Date Axis"
            sheet.Cells(12, 0).Font = boldFont
            sheet.Cells(12, 0).VerticalAlignment = CellVerticalAlignment.Center

            sheet.Rows(9).Height = 35
            sheet.Rows(12).Height = 35

            sheet.Columns(0).Width = sheet.GetPreferredColumnWidth(0)
            For i As Integer = 1 To 6
                sheet.Columns(i).Width = 120
            Next

            Dim data = New SheetCellRange(sheet, 2, 2, 5, 1)

            Dim setting = New ExcelSparklineSetting()
            Dim dateAxisSetting = New ExcelSparklineSetting() With {
                .DateAxis = True
            }
            dateAxisSetting.Formula = "$B$3:$B$7"

            sheet.AddSparkline(data, New CellRange(9, 1, 1, 1), SparklineType.Line, setting)
            sheet.AddSparkline(data, New CellRange(9, 3, 1, 1), SparklineType.Column, setting)
            sheet.AddSparkline(data, New CellRange(9, 5, 1, 1), SparklineType.Winloss, setting)

            sheet.AddSparkline(data, New CellRange(12, 1, 1, 1), SparklineType.Line, dateAxisSetting)
            sheet.AddSparkline(data, New CellRange(12, 3, 1, 1), SparklineType.Column, dateAxisSetting)
            sheet.AddSparkline(data, New CellRange(12, 5, 1, 1), SparklineType.Winloss, dateAxisSetting)
        End Sub

        Private Sub TryToggleButtonState()
            Dim val As Integer = 0
            btnAdd.Enabled = (Integer.TryParse(txtRow.Text, val) AndAlso Integer.TryParse(txtColumn.Text, val))
        End Sub
#End Region

#Region "Event handlers"
        Private Sub FpSpread_EnterCell(sender As Object, e As EnterCellEventArgs)
            Dim sparkline = fpSpread.ActiveSheet.GetSparkline(fpSpread.ActiveSheet.ActiveRowIndex, fpSpread.ActiveSheet.ActiveColumnIndex)
            btnClear.Enabled = (sparkline IsNot Nothing)
            comboType.Enabled = (sparkline Is Nothing)

            If sparkline Is Nothing Then
                TryToggleButtonState()
            End If
        End Sub

        Private Sub BtnClear_Click(sender As Object, e As EventArgs)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            sheet.SparklineContainer.RemoveSparkline(sheet.ActiveRowIndex, sheet.ActiveColumnIndex)
            btnClear.Enabled = False
            TryToggleButtonState()
            comboType.Enabled = True
        End Sub

        Private Sub BtnAdd_Click(sender As Object, e As EventArgs)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim range As CellRange = sheet.GetSelection(0)

            Dim row As Integer = Integer.Parse(txtRow.Text)
            Dim col As Integer = Integer.Parse(txtColumn.Text)
            Dim sparklineType As SparklineType = CType(comboType.SelectedItem, SparklineType)

            If range.IsValidRange(sheet) Then
                Dim setting As New ExcelSparklineSetting()
                Dim dataRow As Integer = range.Row
                If range.RowCount = 2 Then
                    setting.DateAxis = True
                    setting.Formula = " " & Asc("A") + range.Column & " & $" & range.Row + 1 & ": " & Asc("A") + range.Column + range.ColumnCount - 1 & "  & " & range.Row + range.RowCount - 1 & " "

                    dataRow = range.Row + 1
                End If

                Try
                    sheet.AddSparkline(New SheetCellRange(sheet, dataRow, range.Column, 1, range.ColumnCount), New CellRange(row, col, 1, 1), sparklineType, setting)
                Catch ex As Exception
                    MessageBox.Show(ex.Message, "Error adding Sparkline", MessageBoxButtons.OK, MessageBoxIcon.[Error])
                End Try
            End If
        End Sub

        Private Sub RowCol_TextChanged(sender As Object, e As EventArgs)
            TryToggleButtonState()
        End Sub
#End Region
    End Class
End Namespace


'
'IntroSparkline.Designer.vb
'


Namespace Features
	Partial Class IntroSparkline
		''' <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 Overloads 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()
			Dim resources As New System.ComponentModel.ComponentResourceManager(GetType(IntroSparkline))
			Me.fpSpread = New FarPoint.Win.Spread.FpSpread()
			Me.fpSpread_Sheet1 = New FarPoint.Win.Spread.SheetView()
			Me.panel1 = New System.Windows.Forms.Panel()
			Me.label1 = New System.Windows.Forms.Label()
			Me.label2 = New System.Windows.Forms.Label()
			Me.label3 = New System.Windows.Forms.Label()
			Me.label4 = New System.Windows.Forms.Label()
			Me.btnAdd = New System.Windows.Forms.Button()
			Me.btnClear = New System.Windows.Forms.Button()
			Me.txtRow = New System.Windows.Forms.TextBox()
			Me.txtColumn = New System.Windows.Forms.TextBox()
			Me.comboType = New System.Windows.Forms.ComboBox()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.panel1.SuspendLayout()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			Me.pnlMain.Size = New System.Drawing.Size(477, 703)
			' 
			' pnlControls
			' 
			Me.pnlControls.AutoScroll = True
			Me.pnlControls.Controls.Add(Me.comboType)
			Me.pnlControls.Controls.Add(Me.txtColumn)
			Me.pnlControls.Controls.Add(Me.txtRow)
			Me.pnlControls.Controls.Add(Me.btnClear)
			Me.pnlControls.Controls.Add(Me.btnAdd)
			Me.pnlControls.Controls.Add(Me.label4)
			Me.pnlControls.Controls.Add(Me.label3)
			Me.pnlControls.Controls.Add(Me.label2)
			Me.pnlControls.Controls.Add(Me.panel1)
			Me.pnlControls.Size = New System.Drawing.Size(157, 703)
			' 
			' fpSpread
			' 
			Me.fpSpread.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread.Name = "fpSpread"
			Me.fpSpread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread_Sheet1})
			Me.fpSpread.Size = New System.Drawing.Size(477, 703)
			Me.fpSpread.TabIndex = 0
			' 
			' fpSpread_Sheet1
			' 
			Me.fpSpread_Sheet1.Reset()
			Me.fpSpread_Sheet1.SheetName = "Sheet1"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' panel1
			' 
			Me.panel1.BackColor = System.Drawing.Color.LightGray
			Me.panel1.Controls.Add(Me.label1)
			Me.panel1.Dock = System.Windows.Forms.DockStyle.Top
			Me.panel1.Location = New System.Drawing.Point(0, 0)
			Me.panel1.Name = "panel1"
			Me.panel1.Size = New System.Drawing.Size(157, 139)
			Me.panel1.TabIndex = 0
			' 
			' label1
			' 
			Me.label1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.label1.Font = New System.Drawing.Font("Segoe UI", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CByte(0))
			Me.label1.Location = New System.Drawing.Point(0, 0)
			Me.label1.Name = "label1"
			Me.label1.Size = New System.Drawing.Size(157, 139)
			Me.label1.TabIndex = 0
			Me.label1.Text = resources.GetString("label1.Text")
			' 
			' label2
			' 
			Me.label2.AutoSize = True
			Me.label2.Location = New System.Drawing.Point(3, 160)
			Me.label2.Name = "label2"
			Me.label2.Size = New System.Drawing.Size(32, 13)
			Me.label2.TabIndex = 1
			Me.label2.Text = "Row:"
			' 
			' label3
			' 
			Me.label3.AutoSize = True
			Me.label3.Location = New System.Drawing.Point(3, 190)
			Me.label3.Name = "label3"
			Me.label3.Size = New System.Drawing.Size(45, 13)
			Me.label3.TabIndex = 2
			Me.label3.Text = "Column:"
			' 
			' label4
			' 
			Me.label4.AutoSize = True
			Me.label4.Location = New System.Drawing.Point(3, 220)
			Me.label4.Name = "label4"
			Me.label4.Size = New System.Drawing.Size(34, 13)
			Me.label4.TabIndex = 2
			Me.label4.Text = "Type:"
			' 
			' btnAdd
			' 
			Me.btnAdd.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnAdd.Enabled = False
			Me.btnAdd.Location = New System.Drawing.Point(33, 256)
			Me.btnAdd.Name = "btnAdd"
			Me.btnAdd.Size = New System.Drawing.Size(94, 25)
			Me.btnAdd.TabIndex = 3
			Me.btnAdd.Text = "Add Sparkline"
			Me.btnAdd.UseVisualStyleBackColor = True
			' 
			' btnClear
			' 
			Me.btnClear.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnClear.Enabled = False
			Me.btnClear.Location = New System.Drawing.Point(33, 289)
			Me.btnClear.Name = "btnClear"
			Me.btnClear.Size = New System.Drawing.Size(94, 25)
			Me.btnClear.TabIndex = 4
			Me.btnClear.Text = "Clear Sparkline"
			Me.btnClear.UseVisualStyleBackColor = True
			' 
			' txtRow
			' 
			Me.txtRow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.txtRow.Location = New System.Drawing.Point(71, 157)
			Me.txtRow.Name = "txtRow"
			Me.txtRow.Size = New System.Drawing.Size(83, 20)
			Me.txtRow.TabIndex = 0
			' 
			' txtColumn
			' 
			Me.txtColumn.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.txtColumn.Location = New System.Drawing.Point(71, 187)
			Me.txtColumn.Name = "txtColumn"
			Me.txtColumn.Size = New System.Drawing.Size(83, 20)
			Me.txtColumn.TabIndex = 1
			' 
			' comboType
			' 
			Me.comboType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboType.FormattingEnabled = True
			Me.comboType.Location = New System.Drawing.Point(71, 217)
			Me.comboType.Name = "comboType"
			Me.comboType.Size = New System.Drawing.Size(83, 21)
			Me.comboType.TabIndex = 2
			' 
			' IntroSparkline
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "IntroSparkline"
			Me.Size = New System.Drawing.Size(635, 703)
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			Me.pnlControls.PerformLayout()
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
			Me.panel1.ResumeLayout(False)
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private fpSpread As FarPoint.Win.Spread.FpSpread
		Private fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
		Private panel1 As System.Windows.Forms.Panel
		Private label1 As System.Windows.Forms.Label
		Private comboType As System.Windows.Forms.ComboBox
		Private txtColumn As System.Windows.Forms.TextBox
		Private txtRow As System.Windows.Forms.TextBox
		Private btnClear As System.Windows.Forms.Button
		Private btnAdd As System.Windows.Forms.Button
		Private label4 As System.Windows.Forms.Label
		Private label3 As System.Windows.Forms.Label
		Private label2 As System.Windows.Forms.Label
	End Class
End Namespace
