Imports System.Drawing
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.CellType
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Public Class AreaSparkline
        Inherits BaseSampleControl

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

            InitSpreadsheet(FpSpread1.ActiveSheet)
        End Sub

#Region "Private Methods"
        Private Sub InitSpreadsheet(ByVal sheetview As SheetView)
            Dim worksheet As IWorksheet = sheetview.AsWorksheet()
            worksheet.Cells("A1:E1").Merge()
            worksheet.Rows("1").RowHeight = 32
            worksheet.Cells("A1").Text = "Revenue by State"
            worksheet.Cells("A1").VerticalAlignment = GrapeCity.Spreadsheet.VerticalAlignment.Center
            worksheet.Cells("A1").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Arial",
                .Size = 17
            })

            Dim table As ITable = worksheet.Tables.Add("A2:E6", GrapeCity.Spreadsheet.YesNoGuess.Guess, FarPoint.Win.Spread.TableStyle.TableStyleLight1)
            table.ShowAutoFilter = False

            worksheet.SetValue(1, 0, New Object(,) {
            {"State", 2018, 2019, 2020, "Diagram"},
            {"Idaho", 10000, -9000, 15000, Nothing},
            {"Montana", 1000, 9000, Nothing, Nothing},
            {"Oregon", 10000, 7000, 0, Nothing},
            {"Washington", 1000, 10000, 5000, Nothing},
            {"Utah", -5000, 5000, 12000, Nothing}})
            worksheet.Cells("B3:D7").CellType = New CurrencyCellType() With {
                .DecimalPlaces = 0
            }

            worksheet.Cells("E3").Formula = "AREASPARKLINE(B3:D3,,,0,10000,""#82bc00"",""#f7a711"")"
            worksheet.Cells("E4").Formula = "AREASPARKLINE(B4:D4,,,0,10000,""#82bc00"",""#f7a711"")"
            worksheet.Cells("E5").Formula = "AREASPARKLINE(B5:D5,,,0,10000,""#82bc00"",""#f7a711"")"
            worksheet.Cells("E6").Formula = "AREASPARKLINE(B6:D6,,,0,10000,""#82bc00"",""#f7a711"")"
            worksheet.Cells("E7").Formula = "AREASPARKLINE(B7:D7,,,0,10000,""#82bc00"",""#f7a711"")"

            worksheet.Rows("1").RowHeight = 50
            worksheet.Rows("2").RowHeight = 25
            worksheet.Rows("3:7").RowHeight = 35

            worksheet.Columns("A").ColumnWidth = 100
            worksheet.Columns("B:D").ColumnWidth = 80
            worksheet.Columns("E").ColumnWidth = 200
        End Sub
#End Region
    End Class
End Namespace


'
'AreaSparkline.Designer.vb
'


Namespace Features
    Partial Class AreaSparkline
        ''' <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(AreaSparkline))
            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.pnlMain.SuspendLayout()
            CType(Me.FpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.SuspendLayout()
            '
            'pnlMain
            '
            Me.pnlMain.Controls.Add(Me.FpSpread1)
            '
            'pnlControls
            '
            Me.pnlControls.Size = New System.Drawing.Size(210, 599)
            '
            '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.Name = "FpSpread1"
            Me.FpSpread1.Size = New System.Drawing.Size(636, 599)
            Me.FpSpread1.TabIndex = 1
            '
            'AreaSparkline
            '
            Me.AutoScaleDimensions = New System.Drawing.SizeF(8.0!, 16.0!)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Name = "AreaSparkline"
            Me.pnlMain.ResumeLayout(False)
            CType(Me.FpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
            Me.ResumeLayout(False)

        End Sub
        Friend WithEvents FpSpread1 As FarPoint.Win.Spread.FpSpread
        Friend WithEvents FpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
    End Class
End Namespace

